The key is here:
----
org.apache.commons.dbcp.SQLNestedException: Cannot create
PoolableConnectionFactory (Communication failure during handshake. Is there
a server running on 127.0.0.1:3306?)
----
Upgrade your mysql connector to 4.1 (NOT 3.1) or to 5.

Make sure your mysql server is listening on the TCP port 3306.

"telnet 127.0.0.1 3306" should work and establish a connection.

If this does not work make sure you don't have a skip-network (I don't remember the real option name) in your my.cnf

Stefano

myepoch wrote:
I had config:

         <data-source name="maildb"
class="org.apache.james.util.dbcp.JdbcDataSource">
            <!--<driver>org.gjt.mm.mysql.Driver</driver>-->
            <driver>com.mysql.jdbc.Driver</driver>
            <dburl>jdbc:mysql://127.0.0.1/mail?autoReconnect=true</dburl>
            <user>root</user>
            <password>root</password>
            <max>20</max>
         </data-source>


but it does not successfully yet.


Norman Maurer wrote:
Please try to change:

<driver>org.gjt.mm.mysql.Driver</driver>


to:

<driver>com.mysql.jdbc.Driver</driver>


I think the wrong connector is used to connect.  If your problems still
persisist, post the exception you get again..


bye
Norman


myepoch schrieb:
mysql connector is mysql-connector-java-3.1.13-bin.jar and add it to james/lib/
mysql version is 4.1


You need to upgrade to a new mysql connector to get it workin with mysql
4.1 or 5.x..  (if im not wrong).


bye
Norman



---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to