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

05-12-31 laoren

我把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,

我重新换了一个最新的,一切都好了:)