史上最郁闷的问题！php能连mysql，jdbc死活连不上mysql，请大侠帮忙看看

ddrisme

平台：bsd6.2+diable jdk1.5 +mysql 4.1+hibernate3.2+c3p0 php能连mysql，jdbc死活连不上mysql，请大侠帮忙看看
代码是经过本地window开发环境测试的。

Jul 9, 2008 2:16:34 AM com.mchange.v2.log.MLog <clinit>
INFO: MLog clients using java 1.4+ standard logging.
Jul 9, 2008 2:16:34 AM com.mchange.v2.c3p0.C3P0Registry banner
INFO: Initializing c3p0-0.9.1-pre9 [built 23-September-2006 01:47:24; debug? true; trace: 10]
Jul 9, 2008 2:16:34 AM com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource getPoolManager
INFO: Initializing c3p0 pool... com.mchange.v2.c3p0.PoolBackedDataSource@8099f75a [ connectionPoolDataSource -> com.mchange.v2.c3p0.WrapperConnectionPoolDataSource@a7857b78 [ acquireIncrement -> 1, acquireRetryAttempts -> 30, acquireRetryDelay -> 1000, autoCommitOnClose -> false, automaticTestTable -> null, breakAfterAcquireFailure -> false, checkoutTimeout -> 0, connectionCustomizerClassName -> null, connectionTesterClassName -> com.mchange.v2.c3p0.impl.DefaultConnectionTester, debugUnreturnedConnectionStackTraces -> false, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, identityToken -> 26f9e5, idleConnectionTestPeriod -> 18000, initialPoolSize -> 30, maxAdministrativeTaskTime -> 0, maxConnectionAge -> 0, maxIdleTime -> 0, maxIdleTimeExcessConnections -> 0, maxPoolSize -> 30, maxStatements -> 0, maxStatementsPerConnection -> 0, minPoolSize -> 30, nestedDataSource -> com.mchange.v2.c3p0.DriverManagerDataSource@a010c661 [ description -> null, driverClass -> null, factoryClassLocation -> null, identityToken -> 5b675e, jdbcUrl -> jdbc:mysql://localhost:3306/inlife?autoReconnect=true&useUnicode=true&characterEncoding=gbk&mysqlEncoding=gbk, properties -> {user=******, password=******} ], preferredTestQuery -> null, propertyCycle -> 0, testConnectionOnCheckin -> false, testConnectionOnCheckout -> false, unreturnedConnectionTimeout -> 0, usesTraditionalReflectiveProxies -> false; userOverrides: {} ], dataSourceName -> null, factoryClassLocation -> null, identityToken -> 16877f8, numHelperThreads -> 3 ]
Jul 9, 2008 2:16:54 AM com.mchange.v2.async.ThreadPoolAsynchronousRunner$DeadlockDetector run
WARNING: com.mchange.v2.async.ThreadPoolAsynchronousRunner$DeadlockDetector@1263db -- APPARENT DEADLOCK!!! Creating emergency threads for unassigned pending tasks!
Jul 9, 2008 2:16:54 AM com.mchange.v2.async.ThreadPoolAsynchronousRunner$DeadlockDetector run
WARNING: com.mchange.v2.async.ThreadPoolAsynchronousRunner$DeadlockDetector@1263db -- APPARENT DEADLOCK!!! Complete Status:
        Managed Threads: 3
        Active Threads: 3
        Active Tasks:
                com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@1389b3f (com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#0)
                com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@158689a (com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#1)
                com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@13b5a3a (com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#2)
        Pending Tasks:
                com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@1a0b53e
                com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@1dafb4e
                com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@1a8d460
                com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@10f0625
                com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@15c97e4
                com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@1f8247d
                com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@23bdd1
                com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@830122
                com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@bf7916
                com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@a6af6e
                com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@1478a2d
                com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@1c09624
                com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@c1186f
                com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@12b3349
                com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@134263a
                com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@b9b8d0
                com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@1148603
                com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@6a63d3
                com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@bfed5a
                com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@77eb97
                com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@10c3a08
                com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@1b6235b
                com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@cb42cf
                com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@8f2ca6
                com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@1bc4ec8
                com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@1d840d9
                com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@898540
Pool thread stack traces:
        Thread[com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#0,5,main]
                java.net.PlainSocketImpl.socketConnect(Native Method)
                java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:333)
                java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:195)
                java.net.PlainSocketImpl.connect(PlainSocketImpl.java:182)
                java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366)
                java.net.Socket.connect(Socket.java:516)
                java.net.Socket.connect(Socket.java:466)
                java.net.Socket.<init>(Socket.java:366)
                java.net.Socket.<init>(Socket.java:20
                com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:147)
                com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:276)
                com.mysql.jdbc.Connection.createNewIO(Connection.java:2769)
                com.mysql.jdbc.Connection.<init>(Connection.java:1531)
                com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266)
                com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:135)
                com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:182)
                com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:171)
                com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:129)
                com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:862)
                com.mchange.v2.resourcepool.BasicResourcePool.access$700(BasicResourcePool.java:33)
                com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1527)
                com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547)
        Thread[com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#1,5,main]
                java.net.PlainSocketImpl.socketConnect(Native Method)
                java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:333)
                java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:195)
                java.net.PlainSocketImpl.connect(PlainSocketImpl.java:182)
                java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366)
                java.net.Socket.connect(Socket.java:516)
                java.net.Socket.connect(Socket.java:466)
                java.net.Socket.<init>(Socket.java:366)
                java.net.Socket.<init>(Socket.java:20
                com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:147)
                com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:276)
                com.mysql.jdbc.Connection.createNewIO(Connection.java:2769)
                com.mysql.jdbc.Connection.<init>(Connection.java:1531)
                com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266)
                com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:135)
                com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:182)
                com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:171)
                com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:129)
                com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:862)
                com.mchange.v2.resourcepool.BasicResourcePool.access$700(BasicResourcePool.java:33)
                com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1527)
                com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547)
        Thread[com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#2,5,main]
                java.net.PlainSocketImpl.socketConnect(Native Method)
                java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:333)
                java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:195)
                java.net.PlainSocketImpl.connect(PlainSocketImpl.java:182)
                java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366)
                java.net.Socket.connect(Socket.java:516)
                java.net.Socket.connect(Socket.java:466)
                java.net.Socket.<init>(Socket.java:366)
                java.net.Socket.<init>(Socket.java:20
                com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:147)
                com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:276)
                com.mysql.jdbc.Connection.createNewIO(Connection.java:2769)
                com.mysql.jdbc.Connection.<init>(Connection.java:1531)
                com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266)
                com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:135)
                com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:182)
                com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:171)
                com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:129)
                com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:862)
                com.mchange.v2.resourcepool.BasicResourcePool.access$700(BasicResourcePool.java:33)
                com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1527)
                com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547)



cp30版本我能换的都换过 至少换过4个版本
mysql4.1 的java驱动 3.1  5.x能下的我都换过。都是一样的错误。
郁闷的是我的php居然能连mysql。
为何jdbc就不能连上呢？？

[ 本帖最后由 ddrisme 于 2008-7-9 12:39 编辑 ]

bestwc

话说今年还想用jdbc驱动连mssql呢，没成功的说。我的经验是freebsd上不要使用JAVA。：）

ddrisme

我后来装了个postgresql，没问题！！
郁闷啊。史上最郁闷的事情发生了！
现状是：php能连mysql
jdbc能连postgresql
jdbc不能连mysql

zeeler

你的jdbc什么版本？
jdbc是2.4之类老版本时，登录密码是按照老密码方式，需要修改mysql的密码，比如：update user set password=old_password("1234") where ....
如果JDBC是3.0以上的新版本，mysql是采用新密码，即： update user set password=password("1234") where ...
不同版本jdbc支持的密码格式不同，可以试试

zeeler

错误信息太多了，看得头都大了，建议先直接写个java程序jdbc连一下，先别用框架，看看报什么错误

ddrisme

我写了一个jdbc连 还是连不上 说什么 last packet 0 ms。。。。
死活是连不上。。
jdbc版本 3.1 *  5.*
5.1*都试过了
都不行。。。。。
密码我也新建了用户 inlife 也进不去。。。。
但是 mysql -p 客户端能进去啊。。。。
查询都没问题
跑了半年的php论坛 也是一点问题都没有

ddrisme

最奇怪的是 netstat -an 居然米有 3306在监听
但是php的论坛能跑》》》
郁闷。。。。

ddrisme

另外装mysql5  
测试问题依然。。。。。
javax.servlet.ServletException: Communications link failure due to underlying exception:

** BEGIN NESTED EXCEPTION **

java.net.SocketException
MESSAGE: java.net.ConnectException: Operation timed out

STACKTRACE:

java.net.SocketException: java.net.ConnectException: Operation timed out
        at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:156)
        at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:276)
        at com.mysql.jdbc.Connection.createNewIO(Connection.java:2641)
        at com.mysql.jdbc.Connection.<init>(Connection.java:1531)
        at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266)
        at java.sql.DriverManager.getConnection(DriverManager.java:525)
        at java.sql.DriverManager.getConnection(DriverManager.java:171)
        at org.apache.jsp.testmysql_jsp._jspService(testmysql_jsp.java:51)
        at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
        at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)
        at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
        at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:17
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
        at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:541)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:14
        at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:199)
        at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:282)
        at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:754)
        at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:684)
        at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:876)
        at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
        at java.lang.Thread.run(Thread.java:595)


** END NESTED EXCEPTION **



Last packet sent to the server was 0 ms ago.
        org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:825)
        org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:75
        org.apache.jsp.testmysql_jsp._jspService(testmysql_jsp.java:87)
        org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
        javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
        org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)
        org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
        org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
        javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

ddrisme

问题搞定。。原来是 mysql的端口没有打开。。
在my。cnf里把 skipn-networ这个参数打开即可。。。

macafee

在BSD上不用SOCK连接用IP连接？难道是远程调用？