Hi,
I recently had the same problem.
I think your probably using an old mysql jdbc client driver.
I turned on mysqld logging via --log=mysql.log and found that mysql was
rejecting the client connection because it was using old 4.1 passwords
and not the new passwords.
I did a google search on this error message and came up with a nice
article describing how to get arround this. However I eventually just
replaced the mm.myql-2.0.14.jar with a newer
mysql-connector-java-3.0.17-ga.bin.jar and this solved the problem.
Rgds,
Phil
Santosh wrote:
Hi Everyone,
I am trying configure a DataSource for connecting to a database other
than "mail". Following is the configuration I am using in the
<database-connections> section:
<data-source name="jdbc/db"
class="org.apache.james.util.dbcp.JdbcDataSource">
<driver>com.mysql.jdbc.Driver</driver>
<dburl>jdbc:mysql://localhost/mirage?useUnicode=true&characterEncodi
ng=UTF-8&characterSetResults=UTF-8&autoReconnect=true</dburl>
<user>root</user>
<password>trunk</password>
<max>100</max>
</data-source>
1) The server is unable to start. It throws a huge stacktrace in which
the following section seems most relevant:
Caused by: java.sql.SQLException: Communication failure during
handshake. Is there a server running
on localhost:3306?
at org.gjt.mm.mysql.MysqlIO.init(Unknown Source)
at org.gjt.mm.mysql.Connection.connectionInit(Unknown Source)
at org.gjt.mm.mysql.jdbc2.Connection.connectionInit(Unknown
Source)
at org.gjt.mm.mysql.Driver.connect(Unknown Source)
at
org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverC
onnectionFactory.
java:37)
at
org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableCon
nectionFactory.ja
va:290)
at
org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicD
ataSource.java:87
7)
at
org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource
.java:851)
... 28 more
I am quite sure the database server is working fine since other my
Tomcat is able to connect with the same URL.
2) No matter what driver you specify, it used the default MySQL driver
that ships with JAMES. Is using the default MySQL driver necessary?
Waiting for answers.
Thanks a lot.
Santosh.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
