![]() ![]() Specify server in place of localhost if MySQL server is not the same as ‘this’ AEM server communities is the default database (schema) name. JDBC connection URI: jdbc:mysql://localhost:3306/communities?characterEncoding=UTF-8 Select the + icon to create a connection configuration. Locate the Day Commons JDBC Connections Pool When MySQL runs on a server different from AEM, the server hostname must be specified in place of ‘localhost’ in the JDBC connector. The OSGi configuration for Day Commons JDBC Connections Pool configures the MySQL JDBC Driver.Īll publish and author AEM instances should point to the same MySQL server. Use the refresh icon to the right of ‘SCHEMAS’: Once the script is executed, it is necessary to refresh the SCHEMAS section of the Navigator to see the new database. In the following image, the init_schema.sql file is ready to be executed: In the Workbench window for the file opened in Step 1, select the lightening (flash) icon to execute the script. Select the downloaded init_schema.sql script.From the File pulldown menu, select the Open SQL Script option.If the database name is changed in the script, be sure to also change it in the JDBC config. The default name of the database is communities. Select the view link to save the data to a local fileįollow the steps below to install the database. ![]() Notice the value for the jcr:data property is a view link Select the jcr:content node for the sql file One method for downloading the schema is to: Select the /libs/social/config/datastore/dsrp/schema folder The SQL script is obtained from the AEM repository: Open the Communities connection to install the database. The Connection Name chosen is entered as the datasource name in JDBC OSGi configuration.Select Test Connection to verify the connection to the running MySQL service In the dialog Setup New Connection, enter values appropriate for your platformįor demonstration purposes, with the author AEM instance and MySQL on the same server: Select the + icon to the right of MySQL Connections. When the MySQL Workbench is first launched, unless already in use for other purposes, it will not yet show any connections: MySQL Workbench should be downloaded and installed following the instructions for the target OS. MySQL Workbench provides an UI for executing SQL scripts which install the schema and initial data. To provide better multilingual support, it is necessary to use the UTF8 character set.Ĭhange MySQL to have UTF8 as its character set:Ĭhange the MySQL database to default to UTF8: Lower case table namesĪs SQL is case insensitive, for case sensitive operating systems, it is necessary to include a setting to lower case all table names.įor example, to specify all lower case table names on a Linux OS: MySQL should be downloaded and installed following the instructions for the target OS. May run on same host as AEM or run remotely.MySQL server Community Server version 5.6 or later These instructions describe how to connect to the MySQL server and establish the UGC database. MySQL is a relational database that can be used to store user generated content (UGC).
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |