Cannot create PoolableConnectionFactory

balasubramani — Tue, 25 Oct 2005 15:14:15 GMT

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 passw

Re: Cannot create PoolableConnectionFactory

roberth1962 — Fri, 09 Dec 2005 02:37:51 GMT

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

topic Cannot create PoolableConnectionFactory in Alfresco Archive

Cannot create PoolableConnectionFactory

Re: Cannot create PoolableConnectionFactory