MySQL

Supported versions

Axway supports MySQL Enterprise Server – Advanced Edition (Commercial) 5.6.x starting with version 5.6.14.

To view the current version information, connect to the MySQL utility and use the status MySQL command.

Note   MySQL usage for InterPlay is allowed for demo purpose only.

Disk space requirements

Below is the minimum disk space needed to set up a MySQL database:

  • InterPlay – 200 megabytes minimum disk space
  • Designer – 200 megabytes minimum disk space
  • Repository – 200 megabytes minimum disk space
  • Report Server – 200 megabytes minimum disk space
Note   During the product lifecycle, the RAM and disk space requirements may evolve. Monitor the machine resources used to ensure that sufficient resources are always available for your database.

Database information

The database character set has to be set to UTF-8.

User information

To install the component correctly, you must have previously created the user or users as specified below.

Grant all privileges to each component user.

Note   The client host is a part of access management and it is mandatory to define a set of permission per user and client host. It is possible to use the '%' character for all computers. Please refer to the MySQL 5.1 documentation for more information.

InterPlay – one user

User – Permissions

InterPlay – All privileges

InterPlay – two users

User – Permissions

  • InterPlayAdmin – All privileges
  • InterPlay – select, update, insert, delete, execute

Designer – one user

User – Permissions

IPDesigner – All privileges

Repository – one user

User – Permissions

AISRepository – All privileges

Repository – two users

User – Permissions

  • AISRepository – select, update, insert, delete, execute
  • AISRepositoryAdmin – All privileges

Report Server – one user

User – Permissions

AISuiteReporting – All privileges

Report Server – two users

User – Permissions

  • axway – select, update, insert, delete, execute
  • AISuiteReporting – All privileges

Use the following commands to create the Administrator and Functional users for Report Server.

Administrator:

  • CREATE USER <ADMIN_USER>'@'%' IDENTIFIED BY '<ADMIN_USER_PASSWORD>
  • Grant all privileges to *.* TO '<ADMIN_USER>'@'%' IDENTIFIED BY '<ADMIN_USER_PASSWORD>' with GRANT option

Functional:

  • Grant SELECT, UPDATE, INSERT, DELETE, EXECUTE in <REPORT_FUNCTIONAL_DATABASE>.* to <FUNCTIONAL_USER>'@'%' IDENTIFIED BY '<FUNCTIONAL_USER_PASSWORD>

Server parameters

The following list shows the mandatory parameters and their values for Axway products (using the MySQL show variables command):

  • Default storage engine – default-storage-engine = INNODB
  • SQL mode – sql-mode = "STRICT_TRANS_TABLES, NO_AUTO_CREATE_USER, NO_ENGINE_SUBSTITUTION"
  • Transaction isolation level – transaction-isolation = READ-COMMITTED
  • innodb flush behavior – innodb_flush_log_at_trx_commit = 1
  • init_connect – set session autocommit=0
  • Function creation mode – log_bin_trust_function_creators = 1
  • Recursivity – max_sp_recursion_depth = 100
  • Table name case management – lower_case_table_names = 1
  • Maximum allowed packet – max_allowed_packet >= 16MB

SSL warning message

In MySQL server 5.6.26+ and 5.7.6+, SSL is enabled by default on the server side. However, InterPlay connects to MySQL without SSL.

The following warning message appears in the log:

Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.

To prevent this warning, use a custom URL with the useSSL=false parameter to connect to MySQL.

 

Related Links