Unable to replace default SQLite index by a MySQL database

[Mayur P]

Hi team,

I want to connect the Dicom server with the MySQL database, but the error is coming ..please help suggest some solution.

I'm using MySQL Server8.0

I have created an empty database named "orthanc" using create database in MySQL.

I changed in mysql.json, file to connect with local MySQL database below is my file.

{
    /**
    "MySQL" : {
        // Enable the use of MySQL to store the Orthanc index?
        "EnableIndex" : true,

        // Enable the use of MySQL to store the DICOM files?
        "EnableStorage" : true,

        // Parameters of the MySLQ database
        "Host" : "localhost",
        "Port" : 3306,
        "Database" : "othanc",
        "Username" : "root",
        "Password" : "@Mayur1234",
        "Lock" : false
    }
}

Log file shows the following error:

W0610 15:38:20.851059 PluginsManager.cpp:258] Registering plugin 'mysql-storage' (version 4.3)
E0610 15:38:20.866678 PluginsManager.cpp:153] MySQL error (1045,28000): Plugin caching_sha2_password could not be loaded: The specified module could not be found. Library path is 'C:/Program Files/OrthancMySQL//caching_sha2_password.dll'
W0610 15:38:20.866678 PluginsManager.cpp:157] Database is currently unavailable, retrying...

Log file attached

[BR]

Please see this thread for several options to resolve: https://stackoverflow.com/questions/49194719/authentication-plugin-caching-sha2-password-cannot-be-loaded

Appears to be an issue with MySQL, not Orthanc

BR