Home

Cannot create PoolableConnectionFactory

You are here

2 posts / 0 new
Last post
Cannot create PoolableConnectionFactory

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 ,
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.(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

Can anyone tell me what is the problem ....?

Thanks in advance ..

Regards,
Bala.

This might help

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 :D