Error when using MySQL 8.0.12

[Marcos Fernandes de Sousa Júnior]

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';

[Sébastien Jodogne]

Hello,

You are most probably not using the 1.1 version of the MySQL plugin, that introduced a fix for MySQL 8.0:

https://bitbucket.org/sjodogne/orthanc-databases/commits/6a574d810b98e736d01f231ce9c0bbd0954fa5ef

Sébastien-

[Djiinbables XD]

Thank you! Is there a place where i can download the latest version of the 64bit .dll or do i have to download the source and build it myself?

--

[Sébastien Jodogne]

I have just put precompiled binaries at the following location ("OrthancMySQL-1.1-Index64.dll"):

https://www.orthanc-server.com/browse.php?path=/plugin-mysql

[Djiinbables XD]

Awesome man, thank you very much!