Set the other database connection properties. Uncomment the following properties: db.driver=ĭb.url=jdbc:mysql://$ For example: dir.root=C:/Alfresco/alf_data Open the / file.Įdit the following line with an absolute path to point to the directory in which you want to store Community Edition data. Step 2 created an empty database, and so the contentstore must also be empty. This is because the contentstore must be consistent with the database. Navigate to the /alf_data/ directory and empty the directory. In the mysqld section, add or edit the max_connections property: max_connections = 275 Windows: c:\Users\All Users\MySQL\MySQL Server 5.x\my.ini.Locate the configuration file, for example: Increase the maximum connections setting in the MySQL configuration file. See Optimizing MySQL for more information. Note: You also must ensure that the MySQL database is set to use UTF-8 and InnoDB. Ensure that you keep the ?useUnicode=yes&characterEncoding=UTF-8 parameters at the end of the JDBC URL. Although MySQL is a unicode database, and Unicode strings in Java, the JDBC driver might corrupt your non-English data. The database must be created with the UTF-8 character set and the utf8_bin collation. This allows you to store content with accents in the repository. If you’re using MySQL and require the use of non-US-ASCII characters, you need to set the encoding for internationalization. The connector is a JAR file, for example, mysql-connector-java-5.x.x.ĭownload the database connector from the MySQL site.Ĭopy the JAR file into the /lib directory.įor example, for Tomcat, copy the JAR file into the /lib directory. Install the MySQL database connector to allow the database to talk to the Community Edition server. You can configure a MySQL or MariaDB database connection (with a MySQL JDBC driver) for use with Community Edition. You can configure supported databases for use with Community Edition:
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |