Cannot create PoolableConnectionFactory

[balasubramani]

hai friends ,
       i have installed jdk 1.5 , Mysql 4.1.10  and tried to start the tomcat server . i am getting the following exception ,
[size=75] Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Access denied for user 'alfresco'@'sella4' (using password: YES))
        at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:855)
        at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:540)
        at org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.getConnection(LocalDataSourceConnectionProvider.java:79)
        at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:303)
        … 54 more
Caused by: java.sql.SQLException: Access denied for user 'alfresco'@'sella4' (using password: YES)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2921)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:770)
        at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3641)
        at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1175)
        at com.mysql.jdbc.Connection.createNewIO(Connection.java:2544)
        at com.mysql.jdbc.Connection.<init>(Connection.java:1474)
        at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:264)
        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)
        … 57 more
[/size]


                   Can anyone tell me what is the problem ….?

                   Thanks in advance ..

Regards,
Bala.

[roberth1962]

Hi,

    I got that same probelm as well and it really trouble me for few days. Then I saw that error message I got in the server.log. It turns out that db_setup.sql grants option to 'alfresco'@'localhost' and alfresco tries to connect to MySQL using host name instead. I modified my db_setup.sql and added one more line to it like this "grant all on alfresco.* to 'alfresco'@'test.com' identified by 'alfresco' with grant option;". Or you can manually add that to your MySQL. Then that problem gone.

    Hope this help!!

Robert