Can't connect to mysql server with J Connector.

[Denis Labon]

I can't connect to mysql server using the mysql-connector-java-3.0.11.
I was able to run the same program when I was running Suse 9.0 but
since I install Suse 9.1, I can't connect.
The error message is:
java.sql.SQLException: Unable to connect to any hosts due to
exception: java.net.ConnectException: Connection refused

I'm using mysql-standard-4.0.14 and able to get in the mysql server by
typing:
bin/mysql -uroot -ptest
The /etc/my.cnf file is the default one from
support-files/my-medium.cnf
The #skip-networking is comment out.
Try to telnet localhost 3306 and it display the following text:
Trying 127.0.0.1...
Connected to localhost.
Escape character is '^]'.
4
4.0.14-standard-log|0x-qw$E,Connection closed by foreign host.

[Bill Karwin]

Denis Labon wrote:

I can't connect to mysql server using the mysql-connector-java-3.0.11.
I was able to run the same program when I was running Suse 9.0 but
since I install Suse 9.1, I can't connect.
The error message is:
java.sql.SQLException: Unable to connect to any hosts due to
exception: java.net.ConnectException: Connection refused

Since you have already ruled out that the mysqld is not running or is
started with --skip-networking, then perhaps you are not calling the
Java method getConnection() correctly? Make sure you are passing valid
connect URL string, and correct user and password.

For another possible reason, read this bug:
https://bugzilla.redhat.com/bugzilla...g.cgi?id=77467

I know you said you're running on SuSE, not Red Hat, but it still might
be relevant. The bug comments give a couple of possible changes that
can resolve the problem.

Good luck,
Bill K.

[Bill Karwin]

Denis Labon wrote:

I can't connect to mysql server using the mysql-connector-java-3.0.11.
I was able to run the same program when I was running Suse 9.0 but
since I install Suse 9.1, I can't connect.
The error message is:
java.sql.SQLException: Unable to connect to any hosts due to
exception: java.net.ConnectException: Connection refused

Since you have already ruled out that the mysqld is not running or is
started with --skip-networking, then perhaps you are not calling the
Java method getConnection() correctly? Make sure you are passing valid
connect URL string, and correct user and password.

For another possible reason, read this bug:
https://bugzilla.redhat.com/bugzilla...g.cgi?id=77467

I know you said you're running on SuSE, not Red Hat, but it still might
be relevant. The bug comments give a couple of possible changes that
can resolve the problem.

Good luck,
Bill K.

[Denis Labon]

Bill Karwin wrote:

started with --skip-networking, then perhaps you are not calling the
Java method getConnection() correctly? Make sure you are passing valid
connect URL string, and correct user and password.
I just reinstall Suse 9.0 and the program work perfectly. I didn't
even have to compile it. The program is a simple program that connect
to the mysql server and get out.

For another possible reason, read this bug:
https://bugzilla.redhat.com/bugzilla...g.cgi?id=77467

If I understand correctly, the bug is related to glibc. Unfortunately,
I overide Suse9.1, I can not try to put the setting
"set-variable=thread_stack=256k" and see if it works. However, I don't
believe it has anything to do with glibc. The version they are talking
about is glibc-2.2.4-18.7.0.7 and the glibc version of Suse 9.0 is
2.3.2-88 and the glibc version of Suse 9.1 is 2.3.3. So, logically it
should works.

Does anyone know what is require for the mysql Java connector to work
with mysql?(type of environment, libraries,..., low-level stuff ).

thanx!

[Denis Labon]

Bill Karwin wrote:

started with --skip-networking, then perhaps you are not calling the
Java method getConnection() correctly? Make sure you are passing valid
connect URL string, and correct user and password.
I just reinstall Suse 9.0 and the program work perfectly. I didn't
even have to compile it. The program is a simple program that connect
to the mysql server and get out.

For another possible reason, read this bug:
https://bugzilla.redhat.com/bugzilla...g.cgi?id=77467

If I understand correctly, the bug is related to glibc. Unfortunately,
I overide Suse9.1, I can not try to put the setting
"set-variable=thread_stack=256k" and see if it works. However, I don't
believe it has anything to do with glibc. The version they are talking
about is glibc-2.2.4-18.7.0.7 and the glibc version of Suse 9.0 is
2.3.2-88 and the glibc version of Suse 9.1 is 2.3.3. So, logically it
should works.

Does anyone know what is require for the mysql Java connector to work
with mysql?(type of environment, libraries,..., low-level stuff ).

thanx!