This is a well known problem regarding MySQL and Linux. One of two has a screwy implementation of resolving host names. WHich one depends on who you talk to.
Known solutions include using 127.0.0.1. You will also have issues with authenticating to the server if you limit mysql logins by server. I have tried 127.0.0.1, but even this does not work gives same error, can you think of any other solution... Also changed driver class name to com.mysql.jdbc.Driver, didn't work <parameter> > <name>url</name> > <value>jdbc:mysql://127.0.0.1:3306/prototypedb?autoReconnect=t > rue</value> > </parameter> > <!-- Class name for mm.mysql JDBC driver --> > <parameter> > <name>driverClassName</name> > <value>org.gjt.mm.mysql.Driver</value> > </parameter> -----Original Message----- From: Jim Barrows [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 10, 2004 12:26 PM To: Struts Users Mailing List Subject: RE: java.net.ConnectException: Connection refused > -----Original Message----- > From: Shilpa Nalgonda [mailto:[EMAIL PROTECTED] > Sent: Tuesday, August 10, 2004 9:17 AM > Cc: Struts Users Mailing List > Subject: RE: java.net.ConnectException: Connection refused > > > > I am using Tomcat4.0, struts1.1, mysql 4.0.18 , on Linux > environment. And i > am unable > to connect to mysql db. Below is the url > i am using in server.xml file. and also i have the jdbc driver under > WEB-INF/lib - mysql-connector-java-3.0.14-production-bin.jar...I was > successfully able to deploy the same application on Windows, > using the same > server.xml file. please help. This is a well known problem regarding MySQL and Linux. One of two has a screwy implementation of resolving host names. WHich one depends on who you talk to. Known solutions include using 127.0.0.1. You will also have issues with authenticating to the server if you limit mysql logins by server. > > <parameter> > <name>factory</name> > <value>org.apache.commons.dbcp.BasicDataSourceFactory</value> > </parameter> > <parameter> > <name>url</name> > <value>jdbc:mysql://localhost:3306/prototypedb?autoReconnect=t > rue</value> > </parameter> > <!-- Class name for mm.mysql JDBC driver --> > <parameter> > <name>driverClassName</name> > <value>org.gjt.mm.mysql.Driver</value> > </parameter> > > org.apache.commons.dbcp.SQLNestedException: Cannot create > PoolableConnectionFactory, cause: > java.sql.SQLException: Server connection failure during > transaction. Due to > underlying exception: 'java.net.ConnectException: Connection refused'. > > ** BEGIN NESTED EXCEPTION ** > > java.net.ConnectException > MESSAGE: Connection refused > > STACKTRACE: > > java.net.ConnectException: Connection refused > 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(StandardSocketFac > tory.java:121) > at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:220) > at com.mysql.jdbc.Connection.createNewIO(Connection.java:1884) > at com.mysql.jdbc.Connection.<init>(Connection.java:440) > at > com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriv > er.java:400) > at > org.apache.commons.dbcp.DriverConnectionFactory.createConnecti > on(DriverConne > ctionFactory.java:82) > at > org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(P > oolableConnect > ionFactory.java:300) > at > org.apache.commons.dbcp.BasicDataSource.validateConnectionFact > ory(BasicDataS > ource.java:838) > at > org.apache.commons.dbcp.BasicDataSource.createDataSource(Basic > DataSource.jav > a:821) > at > org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDat > aSource.java:5 > 18) > at com.ecommerce.DAO.DAOFactory.getConnection(Unknown Source) > at com.ecommerce.DAO.UserDAO.<init>(Unknown Source) > at > com.ecommerce.action.PlaceOrderAction.execute(Unknown Source) > at > org.apache.struts.action.RequestProcessor.processActionPerform > (RequestProces > sor.java:484) > at > org.apache.struts.action.RequestProcessor.process(RequestProce > ssor.java:274) > at > org.apache.struts.action.ActionServlet.process(ActionServlet.j > ava:1482) > at > org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525) > at > javax.servlet.http.HttpServlet.service(HttpServlet.java:760) > at > javax.servlet.http.HttpServlet.service(HttpServlet.java:853) > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilt > er(Application > FilterChain.java:247) > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(Appli > cationFilterCh > ain.java:193) > at > org.apache.catalina.core.StandardWrapperValve.invoke(StandardW > rapperValve.ja > va:243) > at > org.apache.catalina.core.StandardPipeline.invokeNext(StandardP > ipeline.java:5 > 66) > at > org.apache.catalina.core.StandardPipeline.invoke(StandardPipel > ine.java:472) > at > org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) > at > org.apache.catalina.core.StandardContextValve.invoke(StandardC > ontextValve.ja > va:190) > at > org.apache.catalina.core.StandardPipeline.invokeNext(StandardP > ipeline.java:5 > 66) > at > org.apache.catalina.valves.CertificatesValve.invoke(Certificat > esValve.java:2 > 46) > at > org.apache.catalina.core.StandardPipeline.invokeNext(StandardP > ipeline.java:5 > 64) > at > org.apache.catalina.core.StandardPipeline.invoke(StandardPipel > ine.java:472) > at > org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) > at > org.apache.catalina.core.StandardContext.invoke(StandardContex > t.java:2347) > Attempted reconnect 3 times. Giving up. > at com.mysql.jdbc.Connection.createNewIO(Connection.java:1952) > at com.mysql.jdbc.Connection.<init>(Connection.java:440) > at > com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriv > er.java:400) > at > org.apache.commons.dbcp.DriverConnectionFactory.createConnecti > on(DriverConne > ctionFactory.java:82) > at > org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(P > oolableConnect > ionFactory.java:300) > at > org.apache.commons.dbcp.BasicDataSource.validateConnectionFact > ory(BasicDataS > ource.java:838) > at > org.apache.commons.dbcp.BasicDataSource.createDataSource(Basic > DataSource.jav > a:821) > at > org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDat > aSource.java:5 > 18) > at com.ecommerce.DAO.DAOFactory.getConnection(Unknown Source) > at com.ecommerce.DAO.UserDAO.<init>(Unknown Source) > at > com.ecommerce.action.PlaceOrderAction.execute(Unknown Source) > at > org.apache.struts.action.RequestProcessor.processActionPerform > (RequestProces > sor.java:484) > at > org.apache.struts.action.RequestProcessor.process(RequestProce > ssor.java:274) > at > org.apache.struts.action.ActionServlet.process(ActionServlet.j > ava:1482) > at > org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525) > at > javax.servlet.http.HttpServlet.service(HttpServlet.java:760) > at > javax.servlet.http.HttpServlet.service(HttpServlet.java:853) > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilt > er(Application > FilterChain.java:247) > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(Appli > cationFilterCh > ain.java:193) > at > org.apache.catalina.core.StandardWrapperValve.invoke(StandardW > rapperValve.ja > va:243) > at > org.apache.catalina.core.StandardPipeline.invokeNext(StandardP > ipeline.java:5 > 66) > at > org.apache.catalina.core.StandardPipeline.invoke(StandardPipel > ine.java:472) > at > org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) > at > org.apache.catalina.core.StandardContextValve.invoke(StandardC > ontextValve.ja > va:190) > at > org.apache.catalina.core.StandardPipeline.invokeNext(StandardP > ipeline.java:5 > 66) > at > org.apache.catalina.valves.CertificatesValve.invoke(Certificat > esValve.java:2 > 46) > at > org.apache.catalina.core.StandardPipeline.invokeNext(StandardP > ipeline.java:5 > 64) > at > org.apache.catalina.core.StandardPipeline.invoke(StandardPipel > ine.java:472) > at > org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) > at > org.apache.catalina.core.StandardContext.invoke(StandardContex > t.java:2347) > at > org.apache.catalina.core.StandardHostValve.invoke(StandardHost > Valve.java:180 > ) > at > org.apache.catalina.core.StandardPipeline.invokeNext(StandardP > ipeline.java:5 > 66) > at > org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDi > spatcherValve. > java:170) > at > org.apache.catalina.core.StandardPipeline.invokeNext(StandardP > ipeline.java:5 > 64) > at > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReport > Valve.java:170 > ) > at > org.apache.catalina.core.StandardPipeline.invokeNext(StandardP > ipeline.java:5 > 64) > at > org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValv > e.java:468) > at > org.apache.catalina.core.StandardPipeline.invokeNext(StandardP > ipeline.java:5 > 64) > at > org.apache.catalina.core.StandardPipeline.invoke(StandardPipel > ine.java:472) > at > org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) > at > org.apache.catalina.core.StandardEngineValve.invoke(StandardEn > gineValve.java > :174) > at > org.apache.catalina.core.StandardPipeline.invokeNext(StandardP > ipeline.java:5 > 66) > at > org.apache.catalina.core.StandardPipeline.invoke(StandardPipel > ine.java:472) > at > org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) > at > org.apache.catalina.connector.http.HttpProcessor.process(HttpP > rocessor.java: > 1027) > at > org.apache.catalina.connector.http.HttpProcessor.run(HttpProce > ssor.java:1125 > ) > at java.lang.Thread.run(Thread.java:534) > com.ecommerce.ecomexception.DAOException: Could not retrieve > Connection > Object. > at com.ecommerce.DAO.DAOFactory.getConnection(Unknown Source) > at com.ecommerce.DAO.UserDAO.<init>(Unknown Source) > at > com.ecommerce.action.PlaceOrderAction.execute(Unknown Source) > at > org.apache.struts.action.RequestProcessor.processActionPerform > (RequestProces > sor.java:484) > at > org.apache.struts.action.RequestProcessor.process(RequestProce > ssor.java:274) > at > org.apache.struts.action.ActionServlet.process(ActionServlet.j > ava:1482) > at > org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525) > at > javax.servlet.http.HttpServlet.service(HttpServlet.java:760) > at > javax.servlet.http.HttpServlet.service(HttpServlet.java:853) > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilt > er(Application > FilterChain.java:247) > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(Appli > cationFilterCh > ain.java:193) > at > org.apache.catalina.core.StandardWrapperValve.invoke(StandardW > rapperValve.ja > va:243) > at > org.apache.catalina.core.StandardPipeline.invokeNext(StandardP > ipeline.java:5 > 66) > at > org.apache.catalina.core.StandardPipeline.invoke(StandardPipel > ine.java:472) > at > org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) > at > org.apache.catalina.core.StandardContextValve.invoke(StandardC > ontextValve.ja > va:190) > at > org.apache.catalina.core.StandardPipeline.invokeNext(StandardP > ipeline.java:5 > 66) > at > org.apache.catalina.valves.CertificatesValve.invoke(Certificat > esValve.java:2 > 46) > at > org.apache.catalina.core.StandardPipeline.invokeNext(StandardP > ipeline.java:5 > 64) > at > org.apache.catalina.core.StandardPipeline.invoke(StandardPipel > ine.java:472) > at > org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) > at > org.apache.catalina.core.StandardContext.invoke(StandardContex > t.java:2347) > at > org.apache.catalina.core.StandardHostValve.invoke(StandardHost > Valve.java:180 > ) > at > org.apache.catalina.core.StandardPipeline.invokeNext(StandardP > ipeline.java:5 > 66) > at > org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDi > spatcherValve. > java:170) > at > org.apache.catalina.core.StandardPipeline.invokeNext(StandardP > ipeline.java:5 > 64) > at > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReport > Valve.java:170 > ) > at > org.apache.catalina.core.StandardPipeline.invokeNext(StandardP > ipeline.java:5 > 64) > at > org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValv > e.java:468) > at > org.apache.catalina.core.StandardPipeline.invokeNext(StandardP > ipeline.java:5 > 64) > at > org.apache.catalina.core.StandardPipeline.invoke(StandardPipel > ine.java:472) > at > org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) > at > org.apache.catalina.core.StandardEngineValve.invoke(StandardEn > gineValve.java > :174) > at > org.apache.catalina.core.StandardPipeline.invokeNext(StandardP > ipeline.java:5 > 66) > at > org.apache.catalina.core.StandardPipeline.invoke(StandardPipel > ine.java:472) > at > org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) > at > org.apache.catalina.connector.http.HttpProcessor.process(HttpP > rocessor.java: > 1027) > at > org.apache.catalina.connector.http.HttpProcessor.run(HttpProce > ssor.java:1125 > ) > at java.lang.Thread.run(Thread.java:534) > Aug 10, 2004 3:25:10 AM com.ecommerce.action.PlaceOrderAction execute > SEVERE: Payment.populate > java.lang.NullPointerException > at com.ecommerce.DAO.UserDAO.insertNewUser(Unknown Source) > at > com.ecommerce.action.PlaceOrderAction.execute(Unknown Source) > at > org.apache.struts.action.RequestProcessor.processActionPerform > (RequestProces > sor.java:484) > at > org.apache.struts.action.RequestProcessor.process(RequestProce > ssor.java:274) > at > org.apache.struts.action.ActionServlet.process(ActionServlet.j > ava:1482) > at > org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525) > at > javax.servlet.http.HttpServlet.service(HttpServlet.java:760) > at > javax.servlet.http.HttpServlet.service(HttpServlet.java:853) > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilt > er(Application > FilterChain.java:247) > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(Appli > cationFilterCh > ain.java:193) > at > org.apache.catalina.core.StandardWrapperValve.invoke(StandardW > rapperValve.ja > va:243) > at > org.apache.catalina.core.StandardPipeline.invokeNext(StandardP > ipeline.java:5 > 66) > at > org.apache.catalina.core.StandardPipeline.invoke(StandardPipel > ine.java:472) > at > org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) > at > org.apache.catalina.core.StandardContextValve.invoke(StandardC > ontextValve.ja > va:190) > at > org.apache.catalina.core.StandardPipeline.invokeNext(StandardP > ipeline.java:5 > 66) > at > org.apache.catalina.valves.CertificatesValve.invoke(Certificat > esValve.java:2 > 46) > at > org.apache.catalina.core.StandardPipeline.invokeNext(StandardP > ipeline.java:5 > 64) > at > org.apache.catalina.core.StandardPipeline.invoke(StandardPipel > ine.java:472) > at > org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) > at > org.apache.catalina.core.StandardContext.invoke(StandardContex > t.java:2347) > at > org.apache.catalina.core.StandardHostValve.invoke(StandardHost > Valve.java:180 > ) > at > org.apache.catalina.core.StandardPipeline.invokeNext(StandardP > ipeline.java:5 > 66) > at > org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDi > spatcherValve. > java:170) > at > org.apache.catalina.core.StandardPipeline.invokeNext(StandardP > ipeline.java:5 > 64) > at > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReport > Valve.java:170 > ) > at > org.apache.catalina.core.StandardPipeline.invokeNext(StandardP > ipeline.java:5 > 64) > at > org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValv > e.java:468) > at > org.apache.catalina.core.StandardPipeline.invokeNext(StandardP > ipeline.java:5 > 64) > at > org.apache.catalina.core.StandardPipeline.invoke(StandardPipel > ine.java:472) > at > org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) > at > org.apache.catalina.core.StandardEngineValve.invoke(StandardEn > gineValve.java > :174) > at > org.apache.catalina.core.StandardPipeline.invokeNext(StandardP > ipeline.java:5 > 66) > at > org.apache.catalina.core.StandardPipeline.invoke(StandardPipel > ine.java:472) > at > org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) > at > org.apache.catalina.connector.http.HttpProcessor.process(HttpP > rocessor.java: > 1027) > at > org.apache.catalina.connector.http.HttpProcessor.run(HttpProce > ssor.java:1125 > ) > at java.lang.Thread.run(Thread.java:534) > Aug 10, 2004 3:25:10 AM org.apache.struts.action.RequestProcessor > processException > WARNING: Unhandled Exception thrown: class > javax.servlet.ServletException > > > > Below is the configuration which i want to add in server.xml > > <!-- JNDI datasource setup to connect to MYSQL database--> > <Context path="/prototype" docBase="prototype" > debug="5" reloadable="true" crossContext="true" > useNaming="true"> > > <Logger className="org.apache.catalina.logger.FileLogger" > prefix="localhost_PrototypeDBTest_log." suffix=".txt" > timestamp="true"/> > <Resource name="jdbc/prototypedb" > auth="Container" > type="javax.sql.DataSource"/> > > <ResourceParams name="jdbc/prototypedb"> > <parameter> > <name>factory</name> > > <value>org.apache.commons.dbcp.BasicDataSourceFactory</value> > </parameter> > > <!-- Maximum number of dB connections in pool. Make sure you > configure your mysqld max_connections large enough to handle > all of your db connections. Set to 0 for no limit. > --> > <parameter> > <name>maxActive</name> > <value>20</value> > </parameter> > > <!-- Maximum number of idle dB connections to retain in pool. > Set to 0 for no limit. > --> > <parameter> > <name>maxIdle</name> > <value>10</value> > </parameter> > > <!-- Maximum time to wait for a dB connection to > become available > in ms, in this example 10 seconds. An Exception is thrown if > this timeout is exceeded. Set to -1 to wait indefinitely. > --> > <parameter> > <name>maxWait</name> > <value>10000</value> > </parameter> > > <!-- MySQL dB username and password for dB connections --> > <parameter> > <name>username</name> > <value>antonio</value> > </parameter> > <parameter> > <name>password</name> > <value>play</value> > </parameter> > > <!-- Class name for mm.mysql JDBC driver --> > <parameter> > <name>driverClassName</name> > <value>org.gjt.mm.mysql.Driver</value> > </parameter> > > <!-- The JDBC connection url for connecting to your MySQL dB. > The autoReconnect=true argument to the url makes > sure that the > mm.mysql JDBC Driver will automatically reconnect if > mysqld closed > the > connection. mysqld by default closes idle > connections after 8 > hours. > --> > <parameter> > <name>url</name> > > <value>jdbc:mysql://localhost:3306/prototypedb?autoReconnect=t > rue</value> > </parameter> > </ResourceParams> > </Context> > - > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
