Can't get Alfresco to work with MySQL

senti — Mon, 23 Mar 2009 21:12:54 GMT

I have tried installing Alfresco on Linux (CentOS 4.7) for the first time, but I am encountering problems.I have downloaded file "Alfresco-Labs-3Stable-Linux-x86-Install". I install Alfresco successfully. First issue is that GUI installer doesn't ask me anything about database selection (although PD

Re: Can't get Alfresco to work with MySQL

mikeh — Mon, 23 Mar 2009 21:30:47 GMT

The first log indicates you didn't quite set up the custom-hibernate-dialect.properties and custom-repository.properties files correctly. Could you post them here?

Thanks,
Mike

Re: Can't get Alfresco to work with MySQL

senti — Mon, 23 Mar 2009 21:46:10 GMT

Mike,

custom-hibernate-dialect.properties


#
# Sample Hibernate configuration for changing Database dialect
# For a full list: http://www.hibernate.org/hib_docs/v3/reference/en/html_single/#configuration-optional-dialects
#

#
# Derby dialect
#
#hibernate.dialect=org.hibernate.dialect.DerbyDialect

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

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

#
# PostgreSQL dialect
#
#postgresql#hibernate.dialect=org.hibernate.dialect.PostgreSQLDialect
#postgresql#hibernate.query.substitutions=true TRUE, false FALSE
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

custom-repository.properties


#
# Sample custom content and index data location
#
dir.root=/opt/Alfresco/alf_data
dir.indexes=/opt/Alfresco/alf_data/lucene-indexes

#
# Sample database connection properties
#
db.name=alfresco
db.username=alfresco
db.password=alfresco
#db.pool.initial=10
#db.pool.max=100

#
# External locations
#
ooo.exe=/opt/Alfresco/program/soffice
ooo.user=${dir.root}/oouser
img.root=/usr/local
swf.exe=/opt/Alfresco/bin/pdf2swf

#
# Property to control whether schema updates are performed automatically.
# Updates must be enabled during upgrades as, apart from the static upgrade scripts,
# there are also auto-generated update scripts that will need to be executed.  After
# upgrading to a new version, this can be disabled.
#
#db.schema.update=true

#
# Derby connection
#
#db.driver=org.apache.derby.jdbc.EmbeddedDriver
#db.url=jdbc:derby:/opt/Alfresco/alf_data/derby_data/alfresco;create=true

#
# HSQL connection
#
#hsql#db.driver=org.hsqldb.jdbcDriver
#hsql#db.url=jdbc:hsqldb:file:/opt/Alfresco/alf_data/hsql_data/alfresco;ifexists=true;shutdown=true;

#
# MySQL connection (This is default and requires mysql-connector-java-5.0.3-bin.jar, which ships with the Alfresco se
rver)
#
mysql#db.driver=org.gjt.mm.mysql.Driver
mysql#db.url=jdbc:mysql://localhost:3306/alfresco

#
# PostgreSQL connection (requires postgresql-8.2-504.jdbc3.jar or equivalent)
#
#postgresql#db.driver=org.postgresql.Driver
#postgresql#db.url=jdbc:postgresql://localhost:3306/alfresco
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

I am pretty sure it must be something extremely simple (and I was just blind or dumb), but I just can't see it

Thanks.

Re: Can't get Alfresco to work with MySQL

mikeh — Tue, 24 Mar 2009 09:20:55 GMT

Lose the "mysql#" in custom-hibernate-dialect.properties

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

Thanks,
Mike

Re: Can't get Alfresco to work with MySQL

senti — Tue, 24 Mar 2009 16:23:55 GMT

Mike,

That helped. Thanks a lot

However, that "mysql#" string is there by default, so maybe distribution should be updated with correct configuration files.

topic Can't get Alfresco to work with MySQL in Alfresco Archive

Can't get Alfresco to work with MySQL

Re: Can't get Alfresco to work with MySQL

Re: Can't get Alfresco to work with MySQL

Re: Can't get Alfresco to work with MySQL

Re: Can't get Alfresco to work with MySQL