struts failed connection to remote mySQL

From: David (humblecelt_at_yahoo.com)
Date: 08/14/04 

Date: 13 Aug 2004 16:01:56 -0700

I have a struts app running on tomcat 5.0.25 running on my apple (OS
X)and I am trying to connect to mySQL on a Redhat 9.0 with mySQL
3.23.54 on it. I created a "sqluser" on the linux server, belonging
to the mysql group. I added the sqluser to the user table in the
mysql database. I set the redhat security to "medium" and set the
eth0 as a trusted device.

Here is my jdbc connection info:
<data-source key="musiccollection"
type="org.apache.commons.dbcp.BasicDataSource">
        <set-property property="description" value="Music Collection
Database"/>
        <set-property property="driverClassName"
value="com.mysql.jdbc.Driver"/>
        <set-property property="username" value="sqluser"/>
        <set-property property="password" value="sqluser"/>
        <set-property property="url"
value="jdbc:mysql://192.168.0.1:3306/musiccollection?autoReconnect=true"/>
        <set-property property="maxCount" value="8"/>
        <set-property property="minCount" value="2"/>
</data-source>

When I try to startup my struts app I get the following error:

INFO: Initializing, config='ApplicationResources', returnNull=true
Aug 13, 2004 4:49:18 PM org.apache.struts.action.ActionServlet
initModuleDataSources
SEVERE: Initializing application data source musiccollection
org.apache.commons.dbcp.SQLNestedException: Cannot create
PoolableConnectionFactory (Unable to connect to any hosts due to
exception: java.net.ConnectException: Operation timed out

** BEGIN NESTED EXCEPTION **

java.net.ConnectException
MESSAGE: Operation timed out

STACKTRACE:

java.net.ConnectException: Operation timed out
 at java.net.PlainSocketImpl.socketConnect(Native Method)
        at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:305)
        at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:171)
        at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:158)
        at java.net.Socket.connect(Socket.java:452)
        at java.net.Socket.connect(Socket.java:402)
        at java.net.Socket.<init>(Socket.java:309)
        at java.net.Socket.<init>(Socket.java:124)
        at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:121)
        at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:220)
        at com.mysql.jdbc.Connection.createNewIO(Connection.java:1768)
        at com.mysql.jdbc.Connection.<init>(Connection.java:440)
        at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:400)
        at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:37)
        at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:290)
        at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:877)
        at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:851)
        at org.apache.commons.dbcp.BasicDataSource.setLogWriter(BasicDataSource.java:598)
        at org.apache.struts.action.ActionServlet.initModuleDataSources(ActionServlet.java:1087)
        at org.apache.struts.action.ActionServlet.init(ActionServlet.java:472)
        at javax.servlet.GenericServlet.init(GenericServlet.java:211)
        at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1019)
        at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:862)
        at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:3991)
        at org.apache.catalina.core.StandardContext.start(StandardContext.java:4335)
        at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:823)
        at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:807)
        at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:595)
        at org.apache.catalina.core.StandardHostDeployer.install(StandardHostDeployer.java:277)
        at org.apache.catalina.core.StandardHost.install(StandardHost.java:832)
        at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:683)
        at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:432)
        at org.apache.catalina.startup.HostConfig.start(HostConfig.java:964)
        at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:349)
        at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
        at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1091)
        at org.apache.catalina.core.StandardHost.start(StandardHost.java:789)
        at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1083)
        at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:478)
        at org.apache.catalina.core.StandardService.start(StandardService.java:476)
        at org.apache.catalina.core.StandardServer.start(StandardServer.java:2298)
        at org.apache.catalina.startup.Catalina.start(Catalina.java:556)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:324)
        at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:284)
        at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:422)

** END NESTED EXCEPTION **

)
        at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:855)
        at org.apache.commons.dbcp.BasicDataSource.setLogWriter(BasicDataSource.java:598)
        at org.apache.struts.action.ActionServlet.initModuleDataSources(ActionServlet.java:1087)
        at org.apache.struts.action.ActionServlet.init(ActionServlet.java:472)
        at javax.servlet.GenericServlet.init(GenericServlet.java:211)
        at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1019)
        at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:862)
        at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:3991)
        at org.apache.catalina.core.StandardContext.start(StandardContext.java:4335)
        at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:823)
        at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:807)
        at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:595)
        at org.apache.catalina.core.StandardHostDeployer.install(StandardHostDeployer.java:277)
        at org.apache.catalina.core.StandardHost.install(StandardHost.java:832)
        at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:683)
        at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:432)
        at org.apache.catalina.startup.HostConfig.start(HostConfig.java:964)
        at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:349)
        at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
        at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1091)
        at org.apache.catalina.core.StandardHost.start(StandardHost.java:789)
        at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1083)
        at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:478)
        at org.apache.catalina.core.StandardService.start(StandardService.java:476)
        at org.apache.catalina.core.StandardServer.start(StandardServer.java:2298)
        at org.apache.catalina.startup.Catalina.start(Catalina.java:556)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:324)
        at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:284)
        at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:422)
Caused by: java.sql.SQLException: Unable to connect to any hosts due
to exception: java.net.ConnectException: Operation timed out

** BEGIN NESTED EXCEPTION **

java.net.ConnectException
MESSAGE: Operation timed out

=============================================
I am out of ideas, but I am no linux or db expert either. I would
great appreciate any pointers or advice you can offer.

Thanks,
David

Relevant Pages

  • Re: PHP 5.2 and Mysql
    ... I have redhat 3.0 Enterprise, and mysql ... and php 4.3.9 (installed from an rpm) - I can access data from my mysql ... db using php and the "pear" Db .php. ...
    (comp.lang.php)
  • Re: PostgreSQL or MySQL on RedHat
    ... > I have been using MySQL on RedHat for about a year now. ... > geek friends keep telling me that PostgreSQL is better. ...
    (RedHat)
  • Re: wacky default..
    ... compiling sources, and building packages was ... RedHat-style layout with RedHat style init scripts, logfiles, and lists ... "leave MySQL off by default so a basic installation doesn't also ... require MySQL as well due to library dependencies". ...
    (comp.os.linux.setup)
  • Re: MySQL 4.0.x
    ... >> I have just recently posted a similar request and I guess the Fedora ... >> buying RHEL are happy with this archaic MySQL version either. ... Given that it's RedHat that seems to have the issue with the licensing, ...
    (Fedora)