Ravil A. Desai wrote:
I check many places and tried various options, including autoConnect=true
option to JDBC connect string, but I am still getting following exceptions.
I am using DbVisualizer as a client on Windows 2000 and mysqld is running on
my Redhat 8.0 Linux machine. I am using "com.mysql.jdbc.Driver" as my JDBC
Driver and my JDBC url is "jdbc:mysql://192.168.123.102:3306/menagerie". The
Linux machine is on my local LAN.
Could there be something wrong with the setting on my mysqld running on
Linux or something wrong with my client. I am using the product version of
MySQL server and JDBC driver.
Thanks
14:49:09 [INFO] Connecting: mysql1
14:49:09 [INFO] Load driver using CLASSPATH: com.mysql.jdbc.Driver
java.sql.SQLException: Communication link failure: java.io.IOException
at com.mysql.jdbc.MysqlIO.init(Unknown Source)
at com.mysql.jdbc.Connection.connectionInit(Unknown Source)
at com.mysql.jdbc.jdbc2.Connection.connectionInit(Unknown Source)
at com.mysql.jdbc.Driver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(DriverManager.java:512)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at
se.pureit.dbvis.wrapper.DriverManagerImpl.getConnection(DriverManagerImpl.ja
va:31)
at se.pureit.dbvis.Database.doConnect(Database.java:180)
at se.pureit.dbvis.Database.access$000(Database.java:35)
at se.pureit.dbvis.Database$ConnectionCommand.execute(Database.java:1060)
at se.pureit.util.ThreadCommand.runExecute(ThreadCommand.java:163)
at se.pureit.util.ThreadCommand.run(ThreadCommand.java:143)
at java.lang.Thread.run(Thread.java:536)
Are you using Redhat's MySQL binaries, or MySQL AB's???
Redhat's MySQL binaries for Redhat 8.0 are broken, as they don't allow TCP/IP connections...it crashes the server every time you connect. Redhat has yet to issue an errata/patch to correct this problem for 8.0 (but they have for 7.3 and older)
MySQL AB's 'official' binaries (RPM or .tar.gz) don't exhibit this problem (3.23.53 or 4.0.4/4.0.5)
-Mark
--
For technical support contracts, visit https://order.mysql.com/?ref=mmma
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mark Matthews <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer - JDBC/Java
/_/ /_/\_, /___/\___\_\___/ Flossmoor (Chicago), IL USA
<___/ www.mysql.com
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
