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 Re: 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