I have just upgraded to MySQL 4.1.11 and am now having a problem starting
James as a service...
I am using James 2.2.1-RC1 and was using an older version of MySQL without
problems. This is a development box.
I have confirmed that I have the database Jamesmail in place and that the
server is responding and the user jamesmail has all the needed privileges
and the password is correct
Here is the appropriate piece of my config file...
<data-source name="maildb"
class="org.apache.james.util.dbcp.JdbcDataSource">
<driver>org.gjt.mm.mysql.Driver</driver>
<dburl>jdbc:mysql://127.0.0.1/jamesmail?autoReconnect=true</dburl>
<user>jamesmail</user>
<password>tafhplt01</password>
<max>20</max>
</data-source>
</data-sources>
</database-connections>
and here is a piece of the wrapper log file (see below)...
and near the bottom find...it appears that James can not establish a
connection with my MySQL server. I can telnet into the server on 3306 (of
course I get garbage but I get a connection)...
INFO | jvm 1 | 2005/05/19 23:15:36 | Caused by:
org.apache.commons.dbcp.SQLNestedException: Cannot create
PoolableConnectionFactory (Communication failure during handshake. Is there
a server running on 127.0.0.1:3306?)
INFO | jvm 1 | 2005/05/19 23:15:36 | at
org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.jav
a:855)
INFO | jvm 1 | 2005/05/19 23:15:36 | at
org.apache.james.util.dbcp.JdbcDataSource$1.createDataSource(JdbcDataSource.
java:120)
INFO | jvm 1 | 2005/05/19 23:15:36 | at
org.apache.commons.dbcp.BasicDataSource.setLogWriter(BasicDataSource.java:59
8)
INFO | jvm 1 | 2005/05/19 23:15:36 | at
org.apache.james.util.dbcp.JdbcDataSource.configure(JdbcDataSource.java:155)
INFO | jvm 1 | 2005/05/19 23:15:36 | ... 18 more
INFO | jvm 1 | 2005/05/19 23:15:36 | Caused by: java.sql.SQLException:
Communication failure during handshake. Is there a server running on
127.0.0.1:3306?
INFO | jvm 1 | 2005/05/19 23:15:36 | at
org.gjt.mm.mysql.MysqlIO.init(Unknown Source)
INFO | jvm 1 | 2005/05/19 23:15:36 | at
org.gjt.mm.mysql.Connection.connectionInit(Unknown Source)
INFO | jvm 1 | 2005/05/19 23:15:36 | at
org.gjt.mm.mysql.jdbc2.Connection.connectionInit(Unknown Source)
INFO | jvm 1 | 2005/05/19 23:15:36 | at
org.gjt.mm.mysql.Driver.connect(Unknown Source)
INFO | jvm 1 | 2005/05/19 23:15:36 | at
org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConne
ctionFactory.java:37)
INFO | jvm 1 | 2005/05/19 23:15:36 | at
org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnect
ionFactory.java:290)
INFO | jvm 1 | 2005/05/19 23:15:36 | at
org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataS
ource.java:877)
INFO | jvm 1 | 2005/05/19 23:15:36 | at
org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.jav
a:851)
INFO | jvm 1 | 2005/05/19 23:15:36 | ... 21 more
STATUS | wrapper | 2005/05/19 23:15:32 | Launching a JVM...
INFO | jvm 1 | 2005/05/19 23:15:33 | Wrapper (Version 2.2.8)
INFO | jvm 1 | 2005/05/19 23:15:33 |
INFO | jvm 1 | 2005/05/19 23:15:33 |
INFO | jvm 1 | 2005/05/19 23:15:33 | Phoenix 4.0.1
INFO | jvm 1 | 2005/05/19 23:15:33 |
INFO | jvm 1 | 2005/05/19 23:15:36 |
org.apache.excalibur.containerkit.lifecycle.LifecycleException: Component
named "database-connections" failed to pass through the Initialization
stage. (Reason:
org.apache.avalon.framework.configuration.ConfigurationException: Error
configurable datasource).
INFO | jvm 1 | 2005/05/19 23:15:36 | at
org.apache.excalibur.containerkit.lifecycle.LifecycleHelper.fail(LifecycleHe
lper.java:289)
INFO | jvm 1 | 2005/05/19 23:15:36 | at
org.apache.excalibur.containerkit.lifecycle.LifecycleHelper.startup(Lifecycl
eHelper.java:159)
INFO | jvm 1 | 2005/05/19 23:15:36 | at
org.apache.avalon.phoenix.components.application.DefaultApplication.startup(
DefaultApplication.java:480)
INFO | jvm 1 | 2005/05/19 23:15:36 | at
org.apache.avalon.phoenix.components.application.DefaultApplication.doRunPha
se(DefaultApplication.java:428)
INFO | jvm 1 | 2005/05/19 23:15:36 | at
org.apache.avalon.phoenix.components.application.DefaultApplication.runPhase
(DefaultApplication.java:364)
INFO | jvm 1 | 2005/05/19 23:15:36 | at
org.apache.avalon.phoenix.components.application.DefaultApplication.start(De
faultApplication.java:138)
INFO | jvm 1 | 2005/05/19 23:15:36 | at
org.apache.avalon.framework.container.ContainerUtil.start(ContainerUtil.java
:251)
INFO | jvm 1 | 2005/05/19 23:15:36 | at
org.apache.avalon.phoenix.components.kernel.DefaultKernel.startup(DefaultKer
nel.java:178)
INFO | jvm 1 | 2005/05/19 23:15:36 | at
org.apache.avalon.phoenix.components.kernel.DefaultKernel.addApplication(Def
aultKernel.java:254)
INFO | jvm 1 | 2005/05/19 23:15:36 | at
org.apache.avalon.phoenix.components.deployer.DefaultDeployer.deploy(Default
Deployer.java:353)
INFO | jvm 1 | 2005/05/19 23:15:36 | at
org.apache.avalon.phoenix.components.embeddor.DefaultEmbeddor.deployFile(Def
aultEmbeddor.java:498)
INFO | jvm 1 | 2005/05/19 23:15:36 | at
org.apache.avalon.phoenix.components.embeddor.DefaultEmbeddor.deployFile(Def
aultEmbeddor.java:491)
INFO | jvm 1 | 2005/05/19 23:15:36 | at
org.apache.avalon.phoenix.components.embeddor.DefaultEmbeddor.deployFiles(De
faultEmbeddor.java:476)
INFO | jvm 1 | 2005/05/19 23:15:36 | at
org.apache.avalon.phoenix.components.embeddor.DefaultEmbeddor.deployDefaultA
pplications(DefaultEmbeddor.java:466)
INFO | jvm 1 | 2005/05/19 23:15:36 | at
org.apache.avalon.phoenix.components.embeddor.DefaultEmbeddor.execute(Defaul
tEmbeddor.java:224)
INFO | jvm 1 | 2005/05/19 23:15:36 | at
org.apache.avalon.phoenix.frontends.CLIMain.run(CLIMain.java:158)
INFO | jvm 1 | 2005/05/19 23:15:36 | at java.lang.Thread.run(Unknown
Source)
INFO | jvm 1 | 2005/05/19 23:15:36 | Caused by:
org.apache.avalon.framework.configuration.ConfigurationException: Error
configurable datasource
INFO | jvm 1 | 2005/05/19 23:15:36 | at
org.apache.james.util.dbcp.JdbcDataSource.configure(JdbcDataSource.java:198)
INFO | jvm 1 | 2005/05/19 23:15:36 | at
org.apache.avalon.cornerstone.blocks.datasource.DefaultDataSourceSelector.in
itialize(DefaultDataSourceSelector.java:104)
INFO | jvm 1 | 2005/05/19 23:15:36 | at
org.apache.avalon.framework.container.ContainerUtil.initialize(ContainerUtil
.java:235)
INFO | jvm 1 | 2005/05/19 23:15:36 | at
org.apache.excalibur.containerkit.lifecycle.LifecycleHelper.startup(Lifecycl
eHelper.java:144)
INFO | jvm 1 | 2005/05/19 23:15:36 | ... 15 more
INFO | jvm 1 | 2005/05/19 23:15:36 | Caused by:
org.apache.commons.dbcp.SQLNestedException: Cannot create
PoolableConnectionFactory (Communication failure during handshake. Is there
a server running on 127.0.0.1:3306?)
INFO | jvm 1 | 2005/05/19 23:15:36 | at
org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.jav
a:855)
INFO | jvm 1 | 2005/05/19 23:15:36 | at
org.apache.james.util.dbcp.JdbcDataSource$1.createDataSource(JdbcDataSource.
java:120)
INFO | jvm 1 | 2005/05/19 23:15:36 | at
org.apache.commons.dbcp.BasicDataSource.setLogWriter(BasicDataSource.java:59
8)
INFO | jvm 1 | 2005/05/19 23:15:36 | at
org.apache.james.util.dbcp.JdbcDataSource.configure(JdbcDataSource.java:155)
INFO | jvm 1 | 2005/05/19 23:15:36 | ... 18 more
INFO | jvm 1 | 2005/05/19 23:15:36 | Caused by: java.sql.SQLException:
Communication failure during handshake. Is there a server running on
127.0.0.1:3306?
INFO | jvm 1 | 2005/05/19 23:15:36 | at
org.gjt.mm.mysql.MysqlIO.init(Unknown Source)
INFO | jvm 1 | 2005/05/19 23:15:36 | at
org.gjt.mm.mysql.Connection.connectionInit(Unknown Source)
INFO | jvm 1 | 2005/05/19 23:15:36 | at
org.gjt.mm.mysql.jdbc2.Connection.connectionInit(Unknown Source)
INFO | jvm 1 | 2005/05/19 23:15:36 | at
org.gjt.mm.mysql.Driver.connect(Unknown Source)
INFO | jvm 1 | 2005/05/19 23:15:36 | at
org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConne
ctionFactory.java:37)
INFO | jvm 1 | 2005/05/19 23:15:36 | at
org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnect
ionFactory.java:290)
INFO | jvm 1 | 2005/05/19 23:15:36 | at
org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataS
ource.java:877)
INFO | jvm 1 | 2005/05/19 23:15:36 | at
org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.jav
a:851)
INFO | jvm 1 | 2005/05/19 23:15:36 | ... 21 more
INFO | jvm 1 | 2005/05/19 23:15:36 | There was an uncaught exception:
INFO | jvm 1 | 2005/05/19 23:15:36 |
---------------------------------------------------------
Tony Freeman
TEAMXL
678.344.2305 Office
509.693.2598 eFax
[EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
