MySQL 5

• Add a new Database named jcmsdb with UTF-8 encoding.
• Create a new user jcms allowed to managed this Database.

JCMS

• Go to Admin Area > Properties > Database.
• Select MySQL 5 in the RDBMS list box.
• Enter the JDBC URL for MySQL 5. Example: jdbc:mysql://localhost:3306/jcmsdb?jdbcCompliantTruncation=false&useUnicode=true&characterEncoding=UTF-8&useSSL=false&sendFractionalSeconds=false
• Enter the name (jcms) and the password to access to the jcmsdb database.
• Click on Check Connection...
• Once the database connection has been established successfully , save and restard JCMS

Migration 

Configurations update required with plugin 1.3

Important : migrating to plugin version  1.3 requires an update of your JDBC URL, the following configuration must be modified : 

• Date and Time behavior
  Add parameter &sendFractionalSeconds=false, to the JDBC URL.
  This parameter is absolutely required to provide correct date and time behavior in JCMS
• SSL configuration for communication between JCMS and MySQL :
  • If SSL is not required (for example if MySQL server is located on same server as the webapp, thus without any opened port to the outside world), then do not use SSL at all and add parameter  &useSSL=false 
This is the default configuration of the MySQL JDBC URL provided in the plugin.
  • If SSL is required : 
    • Use SSL and add check it (this would be the recommended production configuration), then use following parameters in JDBC URL :
       &verifyServerCertificate=true&useSSL=true 
      for this purpose, the MySQL server certificate must be added in the Java trust store 
    • Use SSL, but do not check it (this would be the recommended developpement configuration), then use following parameters in JDBC URL : 
        &verifyServerCertificate=false&useSSL=true