After spending a lot of time with docker configurations,and I was stuck on data recovery process from my backup.tar to docker. It looks like there is still not actual stable configurations on docker.
I currently finally moved my EMR data from Windows to Linux Mint, and it was very easy and quick re-installation.
I decided for now to stay and run my EMR on Linux platform, and in parallel learn more about docker version.
Thank you Brady for all your support time and recommendations…
I’ve been playing around with Docker. OpenEMR v5.0.2 will not install with image mariadb:10.4. Works fine with mariadb:10.2. The errors in the docker log for the openemr instance with 10.4 are as follows:
ERROR IN OPENEMR INSTALL: Unable to execute SQL: SELECT user FROM mysql.user WHERE user = 'openemr' AND host = '%' due to: The user specified as a definer ('mariadb.sys'@'localhost') does not exist
2020-05-16T18:01:22.776547088Z Couldn’t set up. Any of these reasons could be what’s wrong:
2020-05-16T18:01:22.776585736Z - You didn’t spin up a MySQL container or connect your OpenEMR container to a mysql instance
2020-05-16T18:01:22.776592541Z - MySQL is still starting up and wasn’t ready for connection yet
2020-05-16T18:01:22.776597266Z - The Mysql credentials were incorrect
2020-05-16T18:01:24.314500671Z PHP Warning: mysqli_connect(): (HY000/1045): Access denied for user ‘openemr’@‘172.27.0.3’ (using password: YES) in /var/www/localhost/htdocs/openemr/library/classes/Installer.class.php on line 693
2020-05-16T18:01:24.315765641Z ERROR IN OPENEMR INSTALL: Unable to execute SQL: create database openemr character set utf8 collate utf8_general_ci due to: Can’t create database ‘openemr’; database exists
Hi @vrjula ,
MariaDB 10.4.13 was just released several days ago and breaks OpenEMR install:
MariaDB 10.4.13 breaks OpenEMR install · Issue #3516 · openemr/openemr · GitHub
There is a fix, which will get into patch 3 (along with rebuild of the packages) in several days.
For now, rec changing the image to mariadb:10.4.12
Ahh, much obliged!
Very cool otherwise…
Not sure what is causing the issues you’re seeing but this instructional youtube video might help.
You can skip all the virtual box stuff and skip to around the 6 minute mark.
@vrjula , The docker OpenEMR 5.0.2 image has been updated to patch 3, so it will now work with most recent version of mariadb 10.4.