I'll report back tonight, thanks again!
On Tue, Nov 13, 2012 at 11:08 AM, Daniel Mikusa <dmik...@vmware.com> wrote: > 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 > >
