CAIQUM-8041: AIQUM 9.16P2 mega-app.ear deployment fails with 'mysql_native_password' not supported error
Issue
- AIQUM 9.16P2 GUI fails to load after an upgrade, a fresh installation, or an OS restart on Windows Server 2022 Standard
- Browser shows error 404
- "mega-app.ear" deployment fails
- server.log:
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 = 'mysql_native_password'- Running the following query in MySQL shows that the jboss user is set to use mysql_native_password authentication protocol plugin:
mysql> select Host,User,plugin,password_last_changed from mysql.user;
+-----------+------------------+-----------------------+-----------------------+
| Host | User | plugin | password_last_changed |
| localhost | jboss | mysql_native_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)