On Nov 13, 2012, at 9:55 AM, S Ahmed wrote: > Dan, > > Thanks for your help. > > From the terminal I was very explicit, I did this: > >> mysql --host localhost --port 3306 --user myuser --password >> password: 123 > > And it worked fine. In my log4net, I believe I set jdbc logs to be ALL or > DEBUG (i'll check when I get home), but it didn't output the host and > password (just in case it is reading from the wrong file somehow??).
It's not an issue of a wrong user / pass, the exception is saying that it literally cannot connect to the host that you've specified. >>> Caused by: java.net.ConnectException: Connection refused Can you include the output from the following commands? telnet localhost 3306 telnet 127.0.0.1 3306 cat /etc/hosts You might also want to enable wireshark and see what is happening when your application starts. Dan > > > > On Tue, Nov 13, 2012 at 8:18 AM, Daniel Mikusa <dmik...@vmware.com> wrote: > >> On Nov 12, 2012, at 10:55 PM, S Ahmed wrote: >> >>> I can't seem to connect to my mysql database from my java code, but I can >>> do it via terminal using the user and password that is in my spring >> context >>> file. >>> >>> I also tried modifying it to localhost:3306 but that didn't change >> anything >>> (it defaults to 3306). >> >> Have you tried using 127.0.0.1 or the IP address of the machine? Perhaps >> something is not right in your /etc/hosts file and it is unable to lookup >> localhost. >> >>> >>> Both the application and mysql are on the same server (ec2). >>> >>> What can I do to figure out the issue? I'm lost! >>> >>> my xml file has: >>> >>> <bean id="dataSource" class="org.apache.tomcat.jdbc.pool.DataSource" >>> destroy-method="close"> >>> <property name="driverClassName" value="com.mysql.jdbc.Driver"/> >>> <property name="url" value="jdbc:mysql://localhost/mydb"/> >>> <property name="username" value="myuser"/> >>> <property name="password" value="123"/> >>> >>> <property name="maxActive" value="100"/> >>> <property name="maxIdle" value="30"/> >>> <property name="maxWait" value="1000"/> >>> <property name="defaultAutoCommit" value="true"/> >>> <property name="removeAbandoned" value="true"/> >>> <property name="removeAbandonedTimeout" value="60"/> >>> >>> <property name="testOnBorrow" value="true"/> >>> <property name="validationQuery" value="SELECT 1"/> >>> >>> </bean> >>> >>> This is the error I am getting: >>> >>> Exception in thread "main" >>> org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get >>> JDBC Connection; nested exception is >>> com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications >>> link failure >>> >> <snip> >>> >>> Caused by: java.net.ConnectException: Connection refused >>> at java.net.PlainSocketImpl.socketConnect(Native Method) >>> at >>> >> java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:327) >>> at >>> >> java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:193) >>> at >>> >> java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:180) >>> at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:384) >>> at java.net.Socket.connect(Socket.java:546) >>> at java.net.Socket.connect(Socket.java:495) >>> at java.net.Socket.<init>(Socket.java:392) >>> at java.net.Socket.<init>(Socket.java:235) >>> at >>> >> com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:257) >>> at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:300) >>> ... 29 more >> >> Seems like the root cause is that a connection cannot be made to the >> server. Double check your credentials. Also, how are you testing from the >> terminal? Can you run "telnet localhost 3306"? >> >> Dan >> >> >> >> --------------------------------------------------------------------- >> To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org >> For additional commands, e-mail: users-h...@tomcat.apache.org >> >> --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
