topic Re: 'alfresco.alf_store' doesn't exist and other errors in Alfresco Archive

'alfresco.alf_store' doesn't exist and other errors

udaygarikapati — Mon, 25 Sep 2006 20:51:19 GMT

Hi All,When I try to setup Alfresco1.4 preview machine on a new machine in my other network, it is throwing following errors. Before this attempt I have instaled the same version with DB name change to alfresco14 on my machine. Later I packaged this bundle and put on the target machine and setup the

Re: 'alfresco.alf_store' doesn't exist and other errors

kevinr — Tue, 26 Sep 2006 08:23:19 GMT

The exception seems to be caused by:

Caused by: java.sql.SQLException: Connections could not be acquired from the underlying database!
at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:106)
Caused by: com.mchange.v2.resourcepool.CannotAcquireResourceException: A ResourcePool could not acquire a resource from its primary factory or source.

Can you test the database connection from the alfresco machine to the DB? Also can you check you have the correct username/password setup for the DB.

Thanks,

Kevin

Re: 'alfresco.alf_store' doesn't exist and other errors

udaygarikapati — Thu, 28 Sep 2006 08:48:14 GMT

Hi Kevin,

Thanks for the reply.

Alfrescso and my database (MySQL) are on the same Linux box. I have created a username/pwd specific to use the db which is for Alfreco. And also i have used default 'alfresco' name for un/pwd and DBname to setup alfresco on the same machine too.

In normal shell i can able to login with the above un/pwd and can see the DB 'alfresco'. Also I have mentioned in the repository.properties in the alfresco.war. Also I have explicitly set the permissions again for the user to have access to DB. But still the problem comes.

When the Alfresco boots/starts for the first time, it will create all the DB tables. This is not done when I start for the first time, so inturn the application is checking for the tables, so it's unable to find. SO the probelm.

Can you tell me why it happens, unable to create the tables.

thanks,
Uday Garikapati