I keep getting:
E0904 14:22:53.409078 PluginsManager.cpp:164] Unsupported MySQL charset: 255
When using MySQL 8.0.12 as an index for the latest version of Orthanc’s compiled source code.
I created the DB using the following command:
CREATE DATABASE databasename CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
weirdly enough Orthanc even manages to create the whole database structure but it stops before properly working(it can’t be accessed from the address bar).
I tried messing with some settings in the my.ini file but it didn’t help…
Any tips? Is that a known bug? Can anyone confirm that orthanc actually works with this version of MySQL?
I had another problem earlier that was also related to the new MySQL version:
E0904 13:19:49.479970 PluginsManager.cpp:164] MySQL error (2059,HY000): Plugin caching_sha2_password could not be loaded: Não foi possível encontrar o módulo especificado. Library path is ‘/caching_sha2_password.dll’
Which i managed to avoid by explicitly creating a new user and using the native hashing using:
CREATE USER ‘user’@‘localhost’ IDENTIFIED WITH mysql_native_password BY ‘password’;