@ALFRECO@:- Configuring the MySQL database with Alfresco

@ALFRECO@:- Configuring the MySQL database with Alfresco

This section describes how to configure a MySQL database for use with Alfresco.

1.        Install the MySQL database connector. The MySQL database connector is required when installing Alfresco with MySQL. The database connector allows MySQL database to talk to the Alfresco server.

a.        Download mysql-connector-java-5.x.x-bin.jar from the MySQL download site: http://dev.mysql.com/.

b.        Copy the JAR file into the /lib directory. For example, for Tomcat, copy the JAR file into the Alfresco/tomcat/lib directory.

2.        Create a database named MYSQL. If you are using MySQL and require the use of non-US-ASCII characters, you need to set the encoding for internationalization. This allows you to store content with accents in the repository. The database must be created with the UTF-8 character set and the utf8_bin collation. Although MySQL is a unicode database, and Unicode strings in Java, the JDBC driver may corrupt your non-English data. Ensure that you keep the ?useUnicode=yes&characterEncoding=UTF-8 parameters at the end of the JDBC URL.

3.        Create a user named root.

4.        Set the new user's password to root.

5.        Navigate to the <Alfresco_Home>/alf_data/  directory and empty the <contentstore> directory. This is because the contentstore must be consistent with the database. Since, we have created an empty database in Step 2, we must empty the contentstore.

6.        Open the E:\Alfresco\tomcat\shared\classes/alfresco-global.properties.sample file.

7.        Edit the following line with an absolute path to point to the directory in which you want to store Alfresco data. For example: dir.root=E:/Alfresco/alf_data 

                                                              Fig: Alfresco-global.properties. Sample

8.        Open the E:\Alfresco\tomcat\shared\classes/alfresco-global.properties.sample file. Uncomment the following properties in Alfresco-global.properties file:

db.driver=org.gjt.mm.mysql.Driver

db.username=root

db.password=root

db.name=mysql

db.url=jdbc:mysql://localhost:3306/mysql?useUnicode=yes&characterEncoding=UTF-8

Note: Ensure that these database connection properties are not commented out.

                                       Fig: Alfresco-global.properties

9.        Save the file without the .sample extension.

10.     Now start the alfresco server (i.e.  Alfresco-Home/manager-windows).

11.     Server will run successfully. Open the localhost:8080/alfresco on the browser.

12.     Installation of Alfresco with Mysql successfully created.

Note:             Change the Database name if already using..