topic Re: Cannot Find MySQL install Option in Alfresco Archive

Cannot Find MySQL install Option

voidwalker — Fri, 06 Mar 2009 17:53:19 GMT

I am trying to install Labs 3 stable and I can get it to work very well with darby. The problem is that during install I did not see an option to choose MySQL. The Docs said I should have seem one.Basically what am I missing?ThanksJohn Hortonjohn.horton@southcentral.edu

Re: Cannot Find MySQL install Option

alexey — Sat, 07 Mar 2009 10:30:59 GMT

Hi!
You can change database type after setup. First, you must create a mysql database. After that in a file %ALFRESCO_HOME%\tomcat\shared\classes\alfresco\extension\custom-repository.properties uncomment and change the lines "db.username","db.password".
Also uncomment strings

db.driver=org.gjt.mm.mysql.Driver
db.url=jdbc:mysql://localhost/alfresco‍‍

and comment this strings

#db.driver=org.hsqldb.jdbcDriver
#db.url=jdbc:hsqldb:file:alf_data/hsql_data/alfresco;ifexists=true;shutdown=true;‍‍

In a file %ALFRESCO_HOME%\tomcat\shared\classes\alfresco\extension\custom-hibernate-dialect.properties you must change

#
# HSQL dialect
#
#hibernate.dialect=org.hibernate.dialect.HSQLDialect

#
# MySQL dialect (default)
#
hibernate.dialect=org.hibernate.dialect.MySQLInnoDBDialect‍‍‍‍‍‍‍‍‍

Restart Alfresco then.
Hope to help.
P.S. Sorry for my English by the way

Re: Cannot Find MySQL install Option

voidwalker — Tue, 10 Mar 2009 11:53:40 GMT

Thank you very much.
Your help was appreciated and your English is better than mine on most days.
Have a peaceful day.