Skip to main content
A
Anonymous
March 10, 2009
Question

Getting Java Connection Error with MySQL

  • March 10, 2009
  • 6 replies
  • 2673 views
I've ben working on a site for the passed month and now suddenly I'm getting error it was working fine yesterdand it suddenly stopped. Nothing has changed what does this error mean

Communications link failure due to underlying exception: ** BEGIN NESTED EXCEPTION ** java.net.ConnectException MESSAGE: Connection refused: connect STACKTRACE: java.net.ConnectException: Connection refused: connect at java.net.PlainSocketImpl.socketConnect(Native Method) at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:333) at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:195) at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:182) at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366) at java.net.Socket.connect(Socket.java:519) at java.net.Socket.connect(Socket.java:469) at java.net.Socket.(Socket.java:366) at java.net.Socket.(Socket.java:209) at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:173) at com.mysql.jdbc.MysqlIO.(MysqlIO.java:267) at com.mysql.jdbc.Connection.createNewIO(Connection.java:2739) at com.mysql.jdbc.Connection.(Connection.java:1553) at com.mysql.jdbc.NonRegistering...

This topic has been closed for replies.

6 replies

A
Anonymous
March 11, 2009
I have gone to Windows firewall and set it to allow for localhost on port 3306 the mysql listening one, but no change
R
recursivecodes
Participating Frequently
March 24, 2009
FWIW, I'm seeing this same problem recently too. Only it's just happening on one query (my rss feed) and only to a very select few IPs. Port 3306 is open on Windows Firewall. I'm completely at a loss here.

Hoping someone posts an update here :)
N
Newsgroup_User
Inspiring
March 11, 2009
What version of MySQL, what version of the JDBC drivers and what version of
CF?

--
Adam
A
Anonymous
March 11, 2009
Everyrthing is the latest version CF8.01, MySQL 5.1 it was all working last week and then stopped this week - nothing was changed at all
A
Anonymous
March 11, 2009
No update was added I'm not sure about connection pooling but I didn't enable it

N
Newsgroup_User
Inspiring
March 11, 2009
a few shots in the dark:
a) was mysql upgraded on the remote server maybe?
b) are you using connection pooling? try disabling that in cf admin for
this dsn if you do...



Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com/
N
Newsgroup_User
Inspiring
March 11, 2009
jhutchdublin wrote:
> I've ben working on a site for the passed month and now suddenly I'm getting
> error it was working fine yesterdand it suddenly stopped. Nothing has changed
> what does this error mean

This looks like a firewall issue. Check that you can connect to the
MySQL server using another way (telnet, heidiSQL, navicat, etc)?

--
Mack
A
Anonymous
March 11, 2009
I can connect through Navicat to the database and even run and return a query
S
Simon.Dau
Known Participant
March 10, 2009
I second that. What a hell have happened?
Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices