You are viewing a plain text version of this content. The canonical link for it is here.
Posted to server-user@james.apache.org by Brian Fincher <br...@gmail.com> on 2005/05/17 20:25:38 UTC
A newbie database problem
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.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 (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: server-user-unsubscribe@james.apache.org
For additional commands, e-mail: server-user-help@james.apache.org
Re: A newbie database problem
Posted by Camron Levanger <ca...@dreamlabmedia.com>.
mysql -u root -p mysql GRANT (whatever you want or ALL) PRIVILEGES ON
(*.* or your_db.*) TO your_user@'%' IDENTIFIED BY 'your_passw'
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: server-user-unsubscribe@james.apache.org
> For additional commands, e-mail: server-user-help@james.apache.org
>
>
Re: A newbie database problem
Posted by Brian Fincher <br...@gmail.com>.
Thanks! Granting priveleges on 127.0.0.1 fixed the problem.
On 5/17/05, apache@bago.org <ap...@bago.org> 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 *.*
>
> If you use mysql 4 you should upgrade to connectorJ instead of
> org.gjt.mm.mysql.Driver.
> You can download Connector/J from www.mysql.com site.
>
> You should also check your permission: you need to add the privileges for
> 127.0.0.1 (localhost could be not enough, depending on your "hosts"
> configuration)
>
> > 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)
>
> Stefano
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: server-user-unsubscribe@james.apache.org
> For additional commands, e-mail: server-user-help@james.apache.org
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: server-user-unsubscribe@james.apache.org
For additional commands, e-mail: server-user-help@james.apache.org
Re: A newbie database problem
Posted by ap...@bago.org.
> 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 *.*
If you use mysql 4 you should upgrade to connectorJ instead of
org.gjt.mm.mysql.Driver.
You can download Connector/J from www.mysql.com site.
You should also check your permission: you need to add the privileges for
127.0.0.1 (localhost could be not enough, depending on your "hosts"
configuration)
> 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)
Stefano
---------------------------------------------------------------------
To unsubscribe, e-mail: server-user-unsubscribe@james.apache.org
For additional commands, e-mail: server-user-help@james.apache.org