> 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]
