topic Connect Alfresco with Mysql in Alfresco Archive

Connect Alfresco with Mysql

yogesh123 — Mon, 22 Sep 2014 07:34:49 GMT

Hi, I have installed Alfresco community on ubuntu, but it comes with postgresql as default database. How can I configure Alfresco with Mysql? Please let me know the steps, if anybody knows.Thanks in advance.

Re: Connect Alfresco with Mysql

mlagneaux — Mon, 22 Sep 2014 07:56:10 GMT

Hello,

Database connection is configured in [TOMCAT_HOME]/shared/alfreco-global.properties file. In the comments of this file, you will find an example of MySQL connection. Moreover, you'll have to put the MYSQL JDBC connector in [TOMCAT_HOME]/shared/lib.

Feel free if you need further details.

Re: Connect Alfresco with Mysql

yogesh123 — Mon, 22 Sep 2014 08:44:06 GMT

Hi Mlagneaux,
I don't find alfresco-global.properties file in [TOMCAT_HOME]/shared folder.
I found classes and lib folders over there, inside classed there is alfresco-global.properties file.
Even I don't find example which you were talking about.
Thanks for your help.

Re: Connect Alfresco with Mysql

mrogers — Tue, 23 Sep 2014 05:39:59 GMT

This is well documented please read the alfresco documentation but miagamuex has essentially got it right although a slight error with the location of alfresco-global.properties.

But in summary here are the steps.

A install MySQL,
B create an empty schema for alfresco to use and an account to access the schema
C add the MySQL connector to tomcat's shared lib if its not there already
D set the db.url, db.database and db.password properties in alfresco-global.properties.