I’m trying to get the MySQL backend working with Orthanc on Windows Server 2019 but I get this startup error
message with MySQL 8.19:
MySQL plugin is incompatible with database schema version:
Same thing on RHEL 8. It works fine with MySQL 5.7 on Windows so I am wondering why this is. Is Orthanc
compatible with MySQL 8 ???
any help much appreciated,
regards,
-ian.
Hello,
The MySQL plugin for Orthanc is compatible with MySQL 8.x since its version 1.1 (released on 2018-07-18), as can be seen in the release notes at the bottom of this page:
https://www.orthanc-server.com/browse.php?path=/plugin-mysql
Check out the version of the MySQL plugin by inspecting your logs.
If you expect further help from this forum, check out the following page, provide logs in “–verbose” mode, as well as a minimal working example on GNU/Linux for us to reproduce your issue:
https://book.orthanc-server.com/users/support.html
HTH,
Sébastien-
Hi Sebastien,
Thanks for the quick reply. I’m running on RHEL version 8.0.0 with MySQL version 8.0.17 and version
2.0 of the MySQL plugin built from source. If I put --verbose on I can see this in the log:
Hello,
The following message:
“MySQL plugin is incompatible with database schema version: 0”
has already been discussed in the past on this forum:
https://groups.google.com/d/msg/orthanc-users/yV3LSTh_TjI/WSGPCp3QAwAJ
It occurs in the scenario where multiple Orthanc servers access the same database. WARNING: As of release 1.5.8, only one Orthanc server can write to the same MySQL/PostgreSQL database, as explained in the Orthanc Book:
https://book.orthanc-server.com/plugins/mysql.html#locking
https://book.orthanc-server.com/plugins/postgresql.html#postgresql-lock
It looks like a fix was committed to enable the “single-writer, multi-reader” scenario, but this fix is still pending in the mainline of the MySQL plugin (no official release yet):
https://groups.google.com/d/msg/orthanc-users/yV3LSTh_TjI/h3PRApJFBAAJ
https://bitbucket.org/sjodogne/orthanc-databases/commits/e26690365c2501ab54bd92f9a33acb1475436e94
Please could you make sure that only one Orthanc server is using the MySQL database, and give a try dropping your database, then using the mainline version of the MySQL plugin?
Regards,
Sébastien-
Hi Sebastien,
I’ve tried re-installing MySQL and dropping/recreating the Orthanc database but I get exactly the same thing.
Pretty sure I’ve not had multiple writers messing things up but I’ll try starting again from scratch and will let
you know how I get on.
thanks,
-ian.
I’ve now started with a fresh AWS cloud instance, installed Orthanc from source, installed the MySQL plugin version 2.0 (mainline)
and installed MySQL again but I get *exactly * the same error message:
The “?” corresponds to variables mapped within SQL queries when MySQL is called from a programming language. This is perfectly legal and fine.
As far as I’m concerned, I’m unable to reproduce your issue on my computer, and I don’t have time to investigate very specific MySQL issues in the following weeks. If you want a quick answer, please provide a way to replicate your issue in a Docker environment (i.e. provide a command-line to start a Docker container running MySQL, against which the Orthanc MySQL plugin does not work).
Just for the record I’ve tried version 1.1 of the plugin and get exactly the same thing as well. I’m not quite sure how this could
be a problem with multiple writers as I’ve not managed to actually start a single Orthanc instance yet. Will have to give up
on this for now as I don’t have time to investigate further. Incidentally I was already aware of how the ? wildcard worked - the
point I was trying to make was a possible quoting problem if the SQL queries are passed via a standard UNIX shell rather than
an API.
regards,
-ian.
Hello again Ian,
I’m not quite sure how this could be a problem with multiple writers as I’ve not managed to actually start a single Orthanc instance yet. Will have to give up on this for now as I don’t have time to investigate further.
As written before, please explain how to independently reproduce your issue using a MySQL running in Docker, and I’ll happily have a look at your problem.
Sébastien-
For reference, here are the procedures to run MySQL 8.0.19 from Docker, then start Orthanc against it:
(1) Start the MySQL container in one terminal:
$ docker run -p 3306:3306 -e MYSQL_ROOT_PASSWORD=root --rm -t -i mysql:8.0.19
(2) Create a database for Orthanc within this MySQL container (in another terminal):
$ echo “CREATE DATABASE orthanc;” | mysql --protocol=tcp --host=localhost --port=3306 --user=root -p
NB: Password is “root”, cf. the “MYSQL_ROOT_PASSWORD” environment variable.
(3) Compile MySQL plugin 2.0 for Orthanc, and create the following configuration file:
{
“Name” : “MyOrthanc”,
“MySQL” : {
“EnableIndex” : true,
“EnableStorage” : true,
“Host” : “localhost”,
“Port” : 3306,
“UnixSocket” : “”,
“Database” : “orthanc”,
“Username” : “root”,
“Password” : “root”,
“Lock” : true
},
“Plugins” : [ “.” ]
}
This configuration is essentially the one from the Orthanc Book:
https://book.orthanc-server.com/plugins/mysql.html#usage
Using this setup, I cannot reproduce your issue, and Orthanc just runs fine.
As a consequence, if you cannot provide additional information, I cannot provide further support by myself.
Kind Regards,
Sébastien-
I think I’ve spotted the problem. In your example you have used the “root” account in the configuration file
whereas I have used a no-privileged “orthanc” account. To get thing working I did this:
All now works. If I subsequently restart the server but using the “orthanc” credentials then
it still works. It seems that something requires root permission on first start up but not
subsequently.
If I do this it doesn’t work:
Drop the orthanc database
Create the orthanc database as root
Grant all privileges on the orthanc database to user “orthanc”
Start the Orthanc server with non-root “orthanc” user credentials.
thanks,
-ian.
Hi Ian,
Many thanks for your investigation! Thanks to it, I was able to reproduce your issue on my computer. For further reference, here are the instructions:
(1) Start the MySQL container in one terminal:
$ docker run --name mysql -p 3306:3306 -e MYSQL_ROOT_PASSWORD=root --rm -t -i mysql:8.0.19
(2) Create a database for Orthanc within this MySQL container (in another terminal):
$ cat <<EOF | mysql --protocol=tcp --host=localhost --port=3306 --user=root -p
CREATE USER ‘orthanc’@‘%’ IDENTIFIED BY ‘orthanc’;
GRANT ALL PRIVILEGES ON orthanc.* TO ‘orthanc’@‘%’;
CREATE DATABASE orthanc;
EOF
NB: Password is “root”, cf. the “MYSQL_ROOT_PASSWORD” environment variable.
(3) Start Orthanc using the following configuration file:
{
“Name” : “MyOrthanc”,
“MySQL” : {
“EnableIndex” : true,
“EnableStorage” : true,
“Host” : “localhost”,
“Port” : 3306,
“UnixSocket” : “”,
“Database” : “orthanc”,
“Username” : “orthanc”,
“Password” : “orthanc”,
“Lock” : true
},
“Plugins” : [ “.” ]
}
In such a situation, MySQL plugin 2.0 stops and reports the following error (which indicates that the Orthanc database has not fully been initialized):
E0312 12:22:15.924770 PluginsManager.cpp:164] MySQL error (1419,HY000): You do not have the SUPER privilege and binary logging is enabled (you might want to use the less safe log_bin_trust_function_creators variable)
If Orthanc is then started a second time, we get your initial error message:
E0312 12:22:30.514954 PluginsManager.cpp:164] MySQL plugin is incompatible with database schema version: 0
The error results from the fact that, by default, a regular MySQL user has not the possibility to run the “CREATE TRIGGER” command. This corrupts the initialization process.
I have just pushed a fix in the mainline of the MySQL plugin, that adds safeguards to avoid this corruption and that displays a solution for the Orthanc user:
https://bitbucket.org/sjodogne/orthanc-databases/commits/740d9829f52e59719eb5770f56a537e820f61ec0
I would love to have your feedback about this modification. If this patch fixes your issue, I’ll happily make a fresh release 2.1 of the MySQL plugin.
Regards,
Sébastien-
Hi,
I reactivate this awaiting feedback thread because i just hit the exact same issue,
however by changing the log_bin_trust_function_creators to true solves the problem,
Best regards,
Salim
Hi Salim,
Thanks for your feedback.
The following changeset that is pending in the mainline will explicitly display the instruction about “log_bin_trust_function_creators”, and the plugin will refuse to start as long as this instruction is not fulfilled:
https://hg.orthanc-server.com/orthanc-databases/rev/740d9829f52e59719eb5770f56a537e820f61ec0
However, we’re still waiting from the feedback of the original poster (Ian) about these bug fixes to start the official release process of the version 2.1 of the MySQL plugin.
Regards,
Sébastien-
getting the same error. Hopefully version 2.1 will come soon and fix that. Trying to use Orthanc on Windows with latest MySQL server administered in MySQL Workbench
Thank you all,
Emil
Hello,
As written above, we’re still waiting for user feedback before we can release the MySQL 2.1 plugin.
Please try and compile the plugin from the sources of the mainline, then provide feedback if you want a quick official release:
https://book.orthanc-server.com/plugins/mysql.html
Sébastien-