<html><div><font color="#0000ff" face="Verdana" size="2"></font> </div>Perhaps there is a mysql group I could ask?  But I will ask here anyway.<br><br>Someone is using java and tomcat and mysql.  Accessing mysql on 10.0.0.66<br>from 10.10.0.2.  They are pingable from each other but go through gateway<br>10.10.0.30.<br><br>And mysql -h 10.0.0.66  <br>from 10.10.0.2 returns a prompt after a while.<br><br>However using jdbc times out even with a timeout of 70000.  Here is the command:<br><br><br><font face="courier new,courier">jdbc:mysql://10.0.0.66/dma_oam?useUnicode=true&characterEncoding=Big5&socketTimeout=700000&connectTimeout=700000   id</font><br>(id omitted from this message for security reasons)<br><br>This is being executed from Java. <br><br>And to repeat, when it was used before there were 1 hop from server machine to host machine (like here):<br><blockquote><font face="courier new,courier">traceroute to 10.0.0.50 (10.0.0.50), 30 hops max, 38 byte packets<br> 1  10.0.0.50 (10.0.0.50)  1.158 ms  0.198 ms  0.186 ms</font><br></blockquote>but in this case there are two<br><blockquote><font face="courier new,courier">traceroute to 10.0.0.66 (10.0.0.66), 30 hops max, 38 byte packets<br> 1  10.10.0.30 (10.10.0.30)  20.068 ms  19.775 ms  19.806 ms<br> 2  10.0.0.66 (10.0.0.66)  24.404 ms  23.240 ms  23.249 ms</font><br></blockquote><br><br>Could this be the reason for the timeout?  Can jdbc not hop?<br><br><br>if you are interested, here is a stack backtrace<br><br>j<font face="courier new,courier">ava.net.SocketTimeoutException: Read timed out<br>        at java.net.SocketInputStream.socketRead0(Native Method)<br>        at java.net.SocketInputStream.read(SocketInputStream.java:129)<br>        at java.io.BufferedInputStream.fill(BufferedInputStream.java:218)<br>        at java.io.BufferedInputStream.read1(BufferedInputStream.java:258)<br>        at java.io.BufferedInputStream.read(BufferedInputStream.java:317)<br>        at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1316)<br>        at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:1463)<br>        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1854)<br>        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1109)<br>        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1203)<br>        at com.mysql.jdbc.MysqlIO.sqlQuery(MysqlIO.java:1164)<br>        at com.mysql.jdbc.Connection.execSQL(Connection.java:2087)<br>        at com.mysql.jdbc.Connection.execSQL(Connection.java:2037)<br>        at com.mysql.jdbc.Statement.executeQuery(Statement.java:1156)<br>        at com.mysql.jdbc.Connection.initializePropsFromServer(Connection.java:2753)<br>        at com.mysql.jdbc.Connection.createNewIO(Connection.java:1671)<br>        at com.mysql.jdbc.Connection.<init>(Connection.java:432)<br></font><br><br><mcallman@allmanpc.com><fedora-list@redhat.com><cave.dnb2m97pp@aliceadsl.fr><akonstam@sbcglobal.net><sound)><pilot><scanner><rio500><fb><kbd><joystick><gpm><dri><mainboard><pmu><bluetooth><irda><dvb><console><pilot><console><scanner><console><fb><console><kbd><console><joystick><console><gpm><console><mainboard><console><rio500><console><pmu><console><bluetooth><console><irda><console><dvb><xconsole><console><dri><null><mpeters@mac.com><fedora-list@redhat.com><theatre@sasktel.net><mailto:theatre@sasktel.net><theatre@sasktel.net><mailto:theatre@sasktel.net><pmr.freire@gmail.com><fedora-list@redhat.com><mpeters@mac.com><fedora-list@redhat.com><theatre@sasktel.net><fedora-list@redhat.com><mpeters@mac.com><mpeters@mac.com><mpeters@mac.com><fedora-list@redhat.com><chrisw01@comcast.net><fedora-list@redhat.com><mpeters@mac.com><fedora-list@redhat.com><mpeters@mac.com><fedora-list@redhat.com><mikkel@infinity-ltd.com><fedora-list@redhat.com><theatre@sasktel.net><fedora-list@redhat.com><mpeters@mac.com><mpeters@mac.com><mpeters@mac.com><fedora-list@redhat.com><francois.patte@math-info.univ-paris5.fr></francois.patte@math-info.univ-paris5.fr></fedora-list@redhat.com></mpeters@mac.com></mpeters@mac.com></mpeters@mac.com></fedora-list@redhat.com></theatre@sasktel.net></fedora-list@redhat.com></mikkel@infinity-ltd.com></fedora-list@redhat.com></mpeters@mac.com></fedora-list@redhat.com></mpeters@mac.com></fedora-list@redhat.com></chrisw01@comcast.net></fedora-list@redhat.com></mpeters@mac.com></mpeters@mac.com></mpeters@mac.com></fedora-list@redhat.com></theatre@sasktel.net></fedora-list@redhat.com></mpeters@mac.com></fedora-list@redhat.com></pmr.freire@gmail.com></mailto:theatre@sasktel.net></theatre@sasktel.net></mailto:theatre@sasktel.net></theatre@sasktel.net></fedora-list@redhat.com></mpeters@mac.com></null></dri></console></xconsole></dvb></console></irda></console></bluetooth></console></pmu></console></rio500></console></mainboard></console></gpm></console></joystick></console></kbd></console></fb></console></scanner></console></pilot></console></dvb></irda></bluetooth></pmu></mainboard></dri></gpm></joystick></kbd></fb></rio500></scanner></pilot></sound)></akonstam@sbcglobal.net></cave.dnb2m97pp@aliceadsl.fr></fedora-list@redhat.com></mcallman@allmanpc.com></html>