Thanks! Granting priveleges on 127.0.0.1 fixed the problem. On 5/17/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > >
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
