External MySQL database

[suseman]

We are running MySQL on a seperate system from the Alfresco installation. How do I configure Alresco to communicate with the 'alfresco' database on an external server?

[steve]

Hi,

If you are running Tomcat, look in the following file:
tomcat\shared\classes\alfresco\extension\custom-db-connection.properties.sample

Find the line in the file (assuming you are using MySQL):

db.url=jdbc:mysql://localhost/alfresco‍

Uncomment this, and change the connection syntax in line with the MySQL connector syntax. - e.g. change 'localhost' to 'remote_machine_name'
(see here: http://dev.mysql.com/doc/refman/5.0/en/cj-configuration-properties.html)

To get your extension working, follow the instructions in the wiki:
http://wiki.alfresco.com/wiki/Repository_Configuration

Hope this helps,

Steve