Prerequisites for MySQL

Applicable for Engagement Services

1. Create the database needed for Engagement Services with unicode character set as UTF8. Also ensure that you modify the my.cnf or my.ini with the following parameters:

   [client]
   
   default-character-set = utf8
   
   [mysql]
   
   default-character-set = utf8
   
   [mysqld]|
   
   character-set-client-handshake = FALSE
   
   collation_server='utf8_unicode_ci'
   
   character_set_server='utf8'
   
   

2. Next, restart the MySQL service and run the following query to verify the details:

   mysql> show variables like '%coll%';
   +----------------------+-----------------+
   | Variable_name | Value |
   +----------------------+-----------------+
   | collation_connection | utf8_unicode_ci |
   | collation_database | utf8_unicode_ci |
   | collation_server | utf8_unicode_ci |
   +----------------------+-----------------+
   3 rows in set (0.00 sec)
   mysql> show variables like '%char%';
   +--------------------------+----------------------------+
   | Variable_name | Value |
   +--------------------------+----------------------------+
   | character_set_client | utf8 |
   | character_set_connection | utf8 |
   | character_set_database | utf8 |
   | character_set_filesystem | binary |
   | character_set_results | utf8 |
   | character_set_server | utf8 |
   | character_set_system | utf8 |
   | character_sets_dir | /usr/share/mysql/charsets/ |
   +--------------------------+----------------------------+

Applicable for Identity Services

If you are using any lower versions of MySQL 5.7 such as v5.7.12 or lower during installation, you may encounter an error due to which the installation rolls back. This error occurs due to a bug in the MySQL database.

For more information, refer MySQL Bugs

Following are the error details:

• Error: Migration V810_27_01__DeleteDuplicateAcsUserIdProviderGuidRowsAddUniqueConstraint.sql failed
• SQL State: HY000
• Error Code: 1093
• Error Message: You can't specify target table 'users' for update in FROM clause
• Location: <Location where the installation is done>

To resolve this error, run the following commands in the MySQL Server:

1. Execute the following command before running the installer:

SET GLOBAL optimizer_switch = 'derived_merge=off';

2. Once the installation is done, set derived_merge ON using the following command:

SET GLOBAL optimizer_switch = 'derived_merge=on';