topic Re: Mysql and SQLGrammarException in Alfresco Archive

Mysql and SQLGrammarException

gael_poffet — Fri, 13 Mar 2009 14:21:32 GMT

Hi all,I'm tying to configure Alfresco Labs3 stable on a Debian Lenny server. Everything is working fine when I'm using Derby but as soon as I change the config to use MySQL Alfresco is not starting.I got this error:14:19:24,352 INFO [domain.schema.SchemaBootstrap] Schema managed by database diale

Re: Mysql and SQLGrammarException

thewheel — Tue, 17 Mar 2009 09:41:50 GMT

I have the same problem with openSUSE11.0
It works (great) with de derby database but won't start with MySQL
Also: during installation there is no question about the database to use although the installation manual say's so….

Any help would be appreciated.

The Wheel

Ok, this is really dumm…

In 'custum-hibernate-dialect.properties' the "#" in front of the mysql line should not be removed, but the whole string "#mysql#" has to be removed!!!

After deleting everyting in "/opt/Alfresco/alf_data/" it now works for me!!!!

Re: Mysql and SQLGrammarException

zshay — Tue, 17 Mar 2009 17:59:21 GMT

Gael,

Do you have multiple lines commented out in your hibernate properties file? I saw references to both HQL and derby in your error trace. Not sure if it is allowed to specify multiple database sources…so I would double check that you only have one type enabled. "custom-repository.properties" and "custom-hibernate-dialect.properties" are both good places to check for this configuration.

Best regards,
Zach