Hi all,
I am working on JAMES version 2.2.0. Till now i was using file as
Storage type (which is default). Now i am trying to use MySQL as the
storage repository.
Below is the environment on which i am working:
OS: Linux Ubuntu 6.0
JAMES: 2.2.0
MySQL: 4.1
Java 5
Have created a DB with name "ofbiz" with user "ragha" and password
"ragha"
Below is the snippet of the config.xml file:
<database-connections>
<data-sources>
<data-source name="maildb"
class="org.apache.james.util.dbcp.JdbcDataSource">
<driver>org.gjt.mm.mysql.Driver</driver>
<dburl>jdbc:mysql://localhost/ofbiz</dburl>
<user>ragha</user>
<password>ragha</password>
<max>40</max>
</data-source>
</data-sources>
</database-connections>
For dburl, i have tried with localhost, 127.0.01 and my machine IP.
Error is same for all the three.
Note: MySQL server is up!
I am getting an exception, and the stack is as below:
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).
at
org.apache.excalibur.containerkit.lifecycle.LifecycleHelper.fail(LifecycleHelper.java:289)
at
org.apache.excalibur.containerkit.lifecycle.LifecycleHelper.startup(LifecycleHelper.java:159)
at
org.apache.avalon.phoenix.components.application.DefaultApplication.startup(DefaultApplication.java:480)
at
org.apache.avalon.phoenix.components.application.DefaultApplication.doRunPhase(DefaultApplication.java:428)
at
org.apache.avalon.phoenix.components.application.DefaultApplication.runPhase(DefaultApplication.java:364)
at
org.apache.avalon.phoenix.components.application.DefaultApplication.start(DefaultApplication.java:138)
at
org.apache.avalon.framework.container.ContainerUtil.start(ContainerUtil.java:251)
at
org.apache.avalon.phoenix.components.kernel.DefaultKernel.startup(DefaultKernel.java:178)
at
org.apache.avalon.phoenix.components.kernel.DefaultKernel.addApplication(DefaultKernel.java:254)
at
org.apache.avalon.phoenix.components.deployer.DefaultDeployer.deploy(DefaultDeployer.java:353)
at
org.apache.avalon.phoenix.components.embeddor.DefaultEmbeddor.deployFile(DefaultEmbeddor.java:498)
at
org.apache.avalon.phoenix.components.embeddor.DefaultEmbeddor.deployFile(DefaultEmbeddor.java:491)
at
org.apache.avalon.phoenix.components.embeddor.DefaultEmbeddor.deployFiles(DefaultEmbeddor.java:476)
at
org.apache.avalon.phoenix.components.embeddor.DefaultEmbeddor.deployDefaultApplications(DefaultEmbeddor.java:466)
at
org.apache.avalon.phoenix.components.embeddor.DefaultEmbeddor.execute(DefaultEmbeddor.java:224)
at
org.apache.avalon.phoenix.frontends.CLIMain.run(CLIMain.java:158)
at
org.apache.avalon.phoenix.frontends.CLIMain.execute(CLIMain.java:144)
at
org.apache.avalon.phoenix.frontends.CLIMain.main(CLIMain.java:102)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.apache.avalon.phoenix.launcher.Main.startup(Main.java:94)
at org.apache.avalon.phoenix.launcher.Main.main(Main.java:46)
Caused by:
org.apache.avalon.framework.configuration.ConfigurationException: Error
configurable datasource
at
org.apache.james.util.dbcp.JdbcDataSource.configure(JdbcDataSource.java:198)
at
org.apache.avalon.cornerstone.blocks.datasource.DefaultDataSourceSelector.initialize(DefaultDataSourceSelector.java:104)
at
org.apache.avalon.framework.container.ContainerUtil.initialize(ContainerUtil.java:235)
at
org.apache.excalibur.containerkit.lifecycle.LifecycleHelper.startup(LifecycleHelper.java:144)
... 22 more
Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot create
PoolableConnectionFactory (Cannot connect to MySQL server on
localhost:3306. Is there a MySQL server running on the machine/port you
are trying to connect to? (java.lang.NumberFormatException))
at
org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:855)
at org.apache.james.util.dbcp.JdbcDataSource
$1.createDataSource(JdbcDataSource.java:120)
at
org.apache.commons.dbcp.BasicDataSource.setLogWriter(BasicDataSource.java:598)
at
org.apache.james.util.dbcp.JdbcDataSource.configure(JdbcDataSource.java:155)
... 25 more
Caused by: java.sql.SQLException: Cannot connect to MySQL server on
localhost:3306. Is there a MySQL server running on the machine/port you
are trying to connect to? (java.lang.NumberFormatException)
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(DriverConnectionFactory.java:37)
at
org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:290)
at
org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:877)
at
org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:851)
... 28 more
There was an uncaught exception:
---------------------------------------------------------
--- Message ---
Failed to start application james.
--- Stack Trace ---
org.apache.avalon.phoenix.interfaces.DeploymentException: Failed to
start application james.
at
org.apache.avalon.phoenix.components.deployer.DefaultDeployer.deploy(DefaultDeployer.java:379)
at
org.apache.avalon.phoenix.components.embeddor.DefaultEmbeddor.deployFile(DefaultEmbeddor.java:498)
at
org.apache.avalon.phoenix.components.embeddor.DefaultEmbeddor.deployFile(DefaultEmbeddor.java:491)
at
org.apache.avalon.phoenix.components.embeddor.DefaultEmbeddor.deployFiles(DefaultEmbeddor.java:476)
at
org.apache.avalon.phoenix.components.embeddor.DefaultEmbeddor.deployDefaultApplications(DefaultEmbeddor.java:466)
at
org.apache.avalon.phoenix.components.embeddor.DefaultEmbeddor.execute(DefaultEmbeddor.java:224)
at
org.apache.avalon.phoenix.frontends.CLIMain.run(CLIMain.java:158)
at
org.apache.avalon.phoenix.frontends.CLIMain.execute(CLIMain.java:144)
at
org.apache.avalon.phoenix.frontends.CLIMain.main(CLIMain.java:102)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.apache.avalon.phoenix.launcher.Main.startup(Main.java:94)
at org.apache.avalon.phoenix.launcher.Main.main(Main.java:46)
Caused by: org.apache.avalon.framework.CascadingException: Failed to
start application james.
at
org.apache.avalon.phoenix.components.kernel.DefaultKernel.startup(DefaultKernel.java:195)
at
org.apache.avalon.phoenix.components.kernel.DefaultKernel.addApplication(DefaultKernel.java:254)
at
org.apache.avalon.phoenix.components.deployer.DefaultDeployer.deploy(DefaultDeployer.java:353)
... 14 more
Caused by: org.apache.avalon.phoenix.interfaces.ApplicationException:
Component named "database-connections" failed to pass through the
Initialization stage. (Reason:
org.apache.avalon.framework.configuration.ConfigurationException: Error
configurable datasource).
at
org.apache.avalon.phoenix.components.application.DefaultApplication.start(DefaultApplication.java:144)
at
org.apache.avalon.framework.container.ContainerUtil.start(ContainerUtil.java:251)
at
org.apache.avalon.phoenix.components.kernel.DefaultKernel.startup(DefaultKernel.java:178)
... 16 more
Caused by:
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).
at
org.apache.excalibur.containerkit.lifecycle.LifecycleHelper.fail(LifecycleHelper.java:289)
at
org.apache.excalibur.containerkit.lifecycle.LifecycleHelper.startup(LifecycleHelper.java:159)
at
org.apache.avalon.phoenix.components.application.DefaultApplication.startup(DefaultApplication.java:480)
at
org.apache.avalon.phoenix.components.application.DefaultApplication.doRunPhase(DefaultApplication.java:428)
at
org.apache.avalon.phoenix.components.application.DefaultApplication.runPhase(DefaultApplication.java:364)
at
org.apache.avalon.phoenix.components.application.DefaultApplication.start(DefaultApplication.java:138)
... 18 more
Caused by:
org.apache.avalon.framework.configuration.ConfigurationException: Error
configurable datasource
at
org.apache.james.util.dbcp.JdbcDataSource.configure(JdbcDataSource.java:198)
at
org.apache.avalon.cornerstone.blocks.datasource.DefaultDataSourceSelector.initialize(DefaultDataSourceSelector.java:104)
at
org.apache.avalon.framework.container.ContainerUtil.initialize(ContainerUtil.java:235)
at
org.apache.excalibur.containerkit.lifecycle.LifecycleHelper.startup(LifecycleHelper.java:144)
... 22 more
Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot create
PoolableConnectionFactory (Cannot connect to MySQL server on
localhost:3306. Is there a MySQL server running on the machine/port you
are trying to connect to? (java.lang.NumberFormatException))
at
org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:855)
at org.apache.james.util.dbcp.JdbcDataSource
$1.createDataSource(JdbcDataSource.java:120)
at
org.apache.commons.dbcp.BasicDataSource.setLogWriter(BasicDataSource.java:598)
at
org.apache.james.util.dbcp.JdbcDataSource.configure(JdbcDataSource.java:155)
... 25 more
Caused by: java.sql.SQLException: Cannot connect to MySQL server on
localhost:3306. Is there a MySQL server running on the machine/port you
are trying to connect to? (java.lang.NumberFormatException)
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(DriverConnectionFactory.java:37)
at
org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:290)
at
org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:877)
at
org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:851)
... 28 more
Please do the needful.
Thanks in advance,
Rag Setty
This e-mail and any files transmitted with it are for the sole use of the
intended recipient(s) and may contain confidential and privileged information.
If you are not the intended recipient or received it in error, please contact
the sender by reply e-mail and destroy all copies of the original message.
Please do not copy it for any purpose or disclose its contents.
Copyright Tarang Software Technologies Pvt. Ltd. 2004. All rights Reserved
