alfresco 1.4 and MySQL 5.0

[mabayona]

Hi,

has anybody got alfresco running with MySQL 5.0.X?

I have installed alfresco 1.4 and MySQL 4.X several times with no problem. But when i try with MySQL5.0.x i get problems . I get no further and even the database is not created. It seems that alfresco does not get connected with MySQL.

The following configuration works OK:

alfresco 1.4
mysql 4.1.x
mysql-connector-java-3.1.12-bin.jar

but if I use MySQL 5.0.24 instead, i get the following errors:

08:55:43,859 ERROR [web.context.ContextLoader] Context initialization failed
org.springframework.beans.factory.BeanCreationException: Error creating bean with name dictionaryRepositoryBootstrap defined in class path resource [alfresco/core-services-context.xml]: Initialization of bean failed; nested exception is org.springframework.transaction.CannotCreateTransactionException: Could not open Hibernate Session for transaction; nested exception is org.hibernate.exception.GenericJDBCException: Cannot open connection
org.springframework.transaction.CannotCreateTransactionException: Could not open Hibernate Session for transaction; nested exception is org.hibernate.exception.GenericJDBCException: Cannot open connection
org.hibernate.exception.GenericJDBCException: Cannot open connection
   at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)
   at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)
   at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
   at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29)
   at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:420)
   at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:144)
   at org.hibernate.jdbc.JDBCContext.connection(JDBCContext.java:129)
   at org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:57)
   at org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1290)
   at org.springframework.orm.hibernate3.HibernateTransactionManager.doBegin(HibernateTransactionManager.java:520)




Any idea?

Thanks in advance.

[kevinr]

We and several of our customers use MySQL 5 with no problems. Can you test that you can connect to the DB from that machine? Also can you check the username/password combination to the database, and that you have given access rights to that user to the DB. I'm just guessing as this is our default setup and there is not a known problem.

Thanks,

Kevin

[mabayona]

Yes, that was it. It was a silly permision thing (that changes from MySQL 4 to MySQL 5 by the way). All that was missing was the permission on user alfresco on schema alfresco (this permission got lost when deleting the database and recreating it).

All I did was to create the DB alfresco and assigning all permissions again from user alfresco in database alfresco. It works now.

Thanks.