Important Note:
The installation of MySQL databases is outside the scope of DocuWare Support. Since MySQL is a third-party application, DocuWare is not responsible for any corrupted systems if the database is damaged during or after the installation.
Please seek assistance from your IT department regarding any issues that may arise or recommendations regarding the management of MySQL.
The installation of MySQL databases is outside the scope of DocuWare Support. Since MySQL is a third-party application, DocuWare is not responsible for any corrupted systems if the database is damaged during or after the installation.
Please seek assistance from your IT department regarding any issues that may arise or recommendations regarding the management of MySQL.
Behavior:
When attempting to start services or connect to your MySQL database after upgrading to V3 (MySQL 8.0.28), the following error occurs;
"Retrieval of the RSA public key is not enabled for insecure connections."
Solution:
When selecting the authentication method for the SQL database, "strong password encryption for authentication" was selected. Due to different authentication methods implemented in MySQL 5.x and MySQL 8, if you select the newer method, DocuWare will not be able to retrieve the RSA keys needed for authentication. To verify what authentication method you are using, run the following SQL command:
When selecting the authentication method for the SQL database, "strong password encryption for authentication" was selected. Due to different authentication methods implemented in MySQL 5.x and MySQL 8, if you select the newer method, DocuWare will not be able to retrieve the RSA keys needed for authentication. To verify what authentication method you are using, run the following SQL command:
"SHOW VARIABLES LIKE 'default_authentication_plugin';"
If the value is 'mysql_native_password', it means the server is using the older, less secure authentication method. If the value is 'caching_sha2_password', the server is using the newer, stronger password encryption method. To resolve this behavior, you must change MySQL's authentication methods. This requires uninstalling and reinstalling the new V3 database.
*Before proceeding, please take a backup before uninstalling the database*
Refer to KBA-37252 for instructions on installing an external MySQL 8.0.28 and converting it to a V3 database. When prompted for an Authentication Method, ensure you select Use Legacy Authentication Method (Retain MySQL 5.x Compatibility).
Once the installation is completed, as detailed in KBA-37252, start the DocuWare services or attempt to connect DocuWare to the new V3 database, which should proceed without error.
KBA is applicable to On-premise Organizations ONLY.
