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 / MariaDB Plugin - 2.0

Description

This plugin add support for MySQL and MariaDB RDMS .

MySQL supported versions are 5.7 and 8.0.

MariaDB supported version is 10.

MariaDB GUI integration is available since JPlatform 10SP3. Before this version, configuration can only be done in properties files.


Installation

MariaDB

Installation

  • Go to Admin Area > Properties > Database.
  • Select MariaDB in the RDBMS list box.
  • Enter the JDBC URL, example: jdbc:mariadb://localhost:3306/jcmsdbunit?jdbcCompliantTruncation=false&useSSL=false&useFractionalSeconds=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

Mysql

MySQL 8

No particular configuration is needed about UTF-8. database default format is already utf8mb4.

About Mysql authentication plugins, only mysql_native_password is supported by embedded driver. The connection account must be created with this authentication mode.

MySQL 5

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

Installation

  • 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&useFractionalSeconds=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 2.0

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 

Information

Version
  • 2.0
Stability
  • Stable
Compatibility
  • JCMS 9
    JPlatform 10
Certified by Jalios
  • Yes
Price
  • Module gratuit
Support
  • Jalios Support
Author
  • Jalios SA
License
  • Jalios
Size
  • 557.27 KB
Updated
  • 10/30/19
Download
  • 8
Domains