NetApp Active IQ Management Server Service unable to start on Windows platform

Applies to

• Active IQ Unified Manager (AIQUM) 9.11 for Windows
• Active IQ Unified Manager (AIQUM) 9.12 for Windows

Issue

• When starting the NetApp Active IQ Management Server Service in Active IQ Unified Manager 9.11+ for Windows, the service fails to start. Reviewing the server.log at C:\ProgramData\NetApp\OnCommandAppData\ocie\log\server.log the following error is observed:

Caused by: java.sql.SQLNonTransientConnectionException: Could not connect to address=(host=localhost)(port=3306)(type=master) : Client does not support authentication protocol requested by server. plugin type was = 'caching_sha2_password'

• Running the following query in MySQL shows that the jboss user is set to use caching_sha2_password authentication protocol plugin:

mysql> select Host,User,plugin,password_last_changed from mysql.user;
+-----------+------------------+-----------------------+-----------------------+
| Host      | User             | plugin                | password_last_changed |
+-----------+------------------+-----------------------+-----------------------+
| localhost | jboss            | caching_sha2_password | 2023-03-29 16:17:40   |
| localhost | mysql.infoschema | caching_sha2_password | 2023-03-29 12:20:19   |
| localhost | mysql.session    | caching_sha2_password | 2023-03-29 12:20:19   |
| localhost | mysql.sys        | caching_sha2_password | 2023-03-29 12:20:19   |
| localhost | root             | mysql_native_password | 2023-03-29 12:21:19   |
+-----------+------------------+-----------------------+-----------------------+
5 rows in set (0.00 sec)