mysql java connector

cuk · 06-01-2008, 08:59 AM

Hello,
I use a java program which connects to mysql. When I start mysqld the recomended way:

Code:

/etc/rc.d/rc.mysqld start

the program refuses to connect, giving the following errors:

Code:

java.net.SocketException: java.net.ConnectException: Connection refused
	at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:151)
	at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:280)
	at com.mysql.jdbc.Connection.createNewIO(Connection.java:1774)
	at com.mysql.jdbc.Connection.<init>(Connection.java:437)
	at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:268)
	at java.sql.DriverManager.getConnection(Unknown Source)
	at java.sql.DriverManager.getConnection(Unknown Source)

However, if I start mysqld simply with

Code:

su -c 'mysqld_safe&'

everything works.
It is not really a serious problem, I have been working like this for almost a year. Just curious. I use slackware 12.0, and I have uncommented SKIP='--skip-networking' in rc.mysqld. Thanks in advance for your interest.
Kind regards

zhoun · 06-01-2008, 09:07 AM

Yes, the java not support Unix socket pipe, only support tcp/udp, So you have to enable the network access to mysqld.

cuk · 06-01-2008, 09:15 AM

but I think I have done so by uncommenting SKIP=--skip-networking in rc.mysqld.
I also tried uncommenting #skip-networking false in my.cnf, but mysqld refused to start:

Code:

Starting mysqld daemon with databases from /var/lib/mysql
STOPPING server from pid file /var/run/mysql/mysql.pid

zhoun · 06-01-2008, 10:11 AM

I think you should comment "#SKIP=--skip-networking" in rc.mysqld, not uncomment like this "SKIP=--skip-networking".
You can check the *.err file in the /var/lib/mysql directory to see what's wrong with mysql when you changed the my.cnf.

cuk · 06-01-2008, 10:48 AM

Thanks, that did it! I don't know anymore why I commented it out in the first place, probably I thought SKIP=--skip is a double negation, thus it would enable it. Anyway, now it works.