Edge Encryption Proxy does not support MySQL version 8

You have decided to configure your Edge Encryption Proxies to use a MySQL database that is running on version 8.x.

When starting the proxy the following may be seen in the edgeencryption.log file:

  1. If you installed the MySQL database to use the stronger authentication method the Edge Encryption database user will not be able to login.  To resolve this you can install the database using the older backward compatible authentication method or execute this for the Edge Encryption database user from the database command line:
    • ALTER USER 'edge_db_user’@'%' IDENTIFIED WITH mysql_native_password BY 'mypassword';
  2. The following will print in the log:

    2018-05-25 17:32:22,722 ERROR Unable to connect to database: jdbc:mysql://localhost as user root - org.mariadb.jdbc.internal.common.QueryException: Unknown system variable 'tx_isolation' 
    2018-05-25 17:32:22,722 ERROR Error while accessing database

There is currently no workaround for this error.  The only option is to use a MySQL database version of 5.5 through 7.x, i.e. MySQL version 8.x cannot be used with Edge Encryption.

Article Information

Last Updated:2018-06-14 07:07:57