It is sounding like a host problem, if you are connecting from localhost use your_user@'localhost'
% is any host, but I believe for some reason any host does not work if you are connecting from localhost.
Camron G. Levanger The Dreamlab http://www.dreamlabmedia.com 866-890-3705
On May 17, 2005, at 12:25 PM, Brian Fincher wrote:
I currently have james working fine using files but I was trying to move over to mysql. Here is my data-source section:
<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/mail?autoReconnect=true</ dburl>
<user>james</user>
<password>james</password>
<max>20</max>
</data-source>
I created a database called "maildb" and granted the user "james" all priveleges on *.*
Here is the exception
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.st artup(DefaultApplication.java:480)
at org.apache.avalon.phoenix.components.application.DefaultApplication.do RunPhase(DefaultApplication.java:428)
at org.apache.avalon.phoenix.components.application.DefaultApplication.ru nPhase(DefaultApplication.java:364)
at org.apache.avalon.phoenix.components.application.DefaultApplication.st art(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.addApplicati on(DefaultKernel.java:254)
at org.apache.avalon.phoenix.components.deployer.DefaultDeployer.deploy (DefaultDeployer.java:353)
at org.apache.avalon.phoenix.components.embeddor.DefaultEmbeddor.deployFi le(DefaultEmbeddor.java:498)
at org.apache.avalon.phoenix.components.embeddor.DefaultEmbeddor.deployFi le(DefaultEmbeddor.java:491)
at org.apache.avalon.phoenix.components.embeddor.DefaultEmbeddor.deployFi les(DefaultEmbeddor.java:476)
at org.apache.avalon.phoenix.components.embeddor.DefaultEmbeddor.deployDe faultApplications(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.DefaultDataSourceSelec tor.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 (Server configuration denies access to data
source)
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: Server configuration denies access
to data source
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 (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
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
