topic Re: Installation on Ubuntu x64 with MySQL in Alfresco Archive

Installation on Ubuntu x64 with MySQL

n4zroth — Sun, 19 Jul 2015 17:45:31 GMT

Hi,I had Alfresco-5.0.d installed and running with its own PostgreSQL installation but I'd rather have (kinda need) to run it on MySQL. I tried changing the configuration and migrating the data from PostgreSQL to MySQL (meh) but that didn't work out correctly. As the system had nearly no data in it,

Re: Installation on Ubuntu x64 with MySQL

mrogers — Mon, 20 Jul 2015 14:59:44 GMT

Here are the settings from alfresco global properties.

db.driver=org.gjt.mm.mysql.Driver
db.url=jdbc:mysql://${db.host}:${db.port}/${db.name}
hibernate.dialect=org.hibernate.dialect.MySQLInnoDBDialect

Also remember to create an empty db for alfresco to use.
create database alfresco DEFAULT CHARACTER SET utf8;
grant all on alfresco.* to 'alfresco'@'localhost' identified by 'alfresco' with grant option;
grant all on alfresco.* to 'alfresco'@'localhost.localdomain' identified by 'alfresco' with grant option;

Re: Installation on Ubuntu x64 with MySQL

mrogers — Mon, 20 Jul 2015 15:01:00 GMT

Also put your driver in the tomcat lib folder.

And please if that still does not work then give error details from your alfresco.log file.