Jdon版jive安装过程中,mysql数据库连接出错!(请帮帮忙,谢谢!)

laoren
05-12-31 2 147 1

我把Jdon版jive按照说明安装起来,用的是mysql5.0,按照说明数据库建好,数据表也生成了,配置文件的路径也该好了。运行进入Jive 论坛安装工具页面http://127.0.0.1:8080/jive/admin/setup/,实施到第三步时数据库连接不能建立报错。
可是我手动写了个小程序测试一下数据库连接时没有问题的,不知道是为什么?请问哪位兄台遇到个这个问题,怎么解决的?忘不吝赐教,兄弟感激不尽!

DefaultConnectionProvider.log文件中打出的log如下:
Starting ConnectionPool:
dbDriver = org.gjt.mm.mysql.Driver
dbServer = jdbc:mysql://localhost/Jive
dbLogin = root
log file = D:\workspace\jdonbbs\application\WEB-INF\jiveHome\logs\DefaultConnectionProvider.log
minconnections = 3
maxconnections = 10
Total refresh interval = 0.5 days
-----------------------------------------
--->Attempt (1 of 5) failed to create new connections set at startup:
java.sql.SQLException: Communication failure during handshake. Is there a server running on localhost:3306?
Will try again in 10 seconds...
--->Attempt (2 of 5) failed to create new connections set at startup:
java.sql.SQLException: Communication failure during handshake. Is there a server running on localhost:3306?
Will try again in 10 seconds...
--->Attempt (3 of 5) failed to create new connections set at startup:
java.sql.SQLException: Communication failure during handshake. Is there a server running on localhost:3306?
Will try again in 10 seconds...
--->Attempt (4 of 5) failed to create new connections set at startup:
java.sql.SQLException: Communication failure during handshake. Is there a server running on localhost:3306?
Will try again in 10 seconds...

All attempts at connecting to Database exhausted

任何意见我都会很感激的,谢谢了先!

1
hehp
2006-01-05 15:30


我的成功连接如下:

Driver: com.mysql.jdbc.Driver
Url: jdbc:mysql://192.168.0.74:3306/jive?useUnicode=true&characterEncoding=GBK

把驱动mysql-connector-java-3.1.7 拷贝到:tomcat\common\lib 目录下。
在装mysql时,同时把原有的mysql卸去。

数据库属性
名称: MySQL
版本: 4.1.10a-nt

JDBC驱动属性
驱动: MySQL-AB JDBC Driver, 版本 mysql-connector-java-3.1.7 ( $Date: 2005/01/25 19:11:41 $, $Revision: 1.27.4.54 $ )
连接URL: jdbc:mysql://192.168.0.74:3306/jive?useUnicode=true&characterEncoding=GBK
连接用户名: jive@dbsvr

数据库功能
支持事务? yes
支持多连接? yes
只读模式? no


五四河---(http://www.54he.com)

laoren
2006-01-07 14:56

谢谢了!
问题解决了,我原来的数据库驱动不支持mysql5.0,
我重新换了一个最新的,一切都好了:)