cancel
Showing results for 
Search instead for 
Did you mean: 

Alfresco folder: name Alfresco_1.3 causes problems?

loggheci
Champ in-the-making
Champ in-the-making
I installed Alfresco 1.3 on my XP machine with Tomcat 5.0… and MySQL.
I used the foldername Alfresco_1.3.

While starting up Alfresco with Alf_start, I could not connect to my Alfresco database…

First I got a SEVERE error, that was because in custom-db-connection.properties the db.url was set to jdbc:mysql://localhost/alfresco instead of jdbc:mysql://localhost/alfresco_1.3.

After I changed db.url to jdbc:mysql://localhost/alfresco_1.3 I got an ERROR:

12:41:52,296 ERROR [org.hibernate.util.JDBCExceptionReporter] Connections could not be acquired from the underlying database!
12:42:12,156 ERROR [org.hibernate.util.JDBCExceptionReporter] Connections could not be acquired from the underlying database!
12:42:12,156 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] could not get database metadata
java.sql.SQLException: Connections could not be acquired from the underlying database!
   at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:106)
   at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:352)
….

I searched on the forums, tried everything I found, but my problem existed.
Finally I renamed my folder Alfresco_1.3 tot Alfresco, I changed db.url to the default value 'alfresco', and now everything works fine…

Strange for me, but perhaps it is normal…

Can somebody give some more explanation?

Thanks,

Chris

(Excuse me for my english, I'am Dutch speaking)
1 REPLY 1

rivetlogic
Champ on-the-rise
Champ on-the-rise
Hi,

I don't think you can create a database in MySql with such a name. You should also know that the database and a user that can access that database must be created in MySql before you start Alfresco. The database name and the username/password of the user that can access it must match what's in custom-db-connection.properties.

Hope this helps,

–Aladdin
Getting started

Tags


Find what you came for

We want to make your experience in Hyland Connect as valuable as possible, so we put together some helpful links.