We apologize for untranslated text, you can use the Google Translation button to get an automatic translation of the web page in the language of your choice.

MySQL 5 Plugin - 1.3

Description

This plugin adds the support for MySQL 5 RDBMS.


Installation

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 


Changes

MySQL 5 Plugin v1.3

  • Upgraded driver
  • MySQL 5.6 and 5.7 certified

MySQL 5 Plugin v1.2

Compatibility with JCMS 8

MySQL 5 Plugin v1.1

Compatibility with JCMS 7

MySQL 5 Plugin v1.0

First release

Information

Version
  • 1.3
Stability
  • Stable
Compatibility
  • JCMS 7.0
    JCMS 6.0
    JCMS 6.1
    JCMS 7.1
    JCMS 8
    JCMS 9
    JPlatform 10
Certified by Jalios
  • Yes
Price
  • Module gratuit
Support
  • Jalios Support
Author
  • Jalios SA
License
  • Jalios
Size
  • 933.98 KB
Updated
  • 5/3/17
Download
  • 74
Domains