Are LBF forms in the Database or on the OpenEMR web site?
I would like to backup the LBF form I created.
Perfect what about Manage List? I don’t see my custom list in lists or list options
I want to create in Dev a custom list and and a custom form and be able to export it and deploy it on another environment.
There is a option in Admin → Features → Configuration Export/Import you can turn on that adds more features to the Admin → System → Backup page.
You should be able to download your layouts as well as any lists you’ve created. I know I’ve done exports just to track changes in LBF forms. I haven’t played with the import process, but presumably you should be able to do an import of an LBF form. Bear in mind you’ll want to import each custom list first before doing the LBF form import as I imagine otherwise things would break.
Unfortunately, i am running in Docker and the Export doesn’t work for me I get “There was an error on the backup” Doing the config backup or the standard backup.
Version 7.0.2(2)
That’s interesting, there must be something unique to your setup. The demo servers are all running on docker.
For example: https://demo.openemr.io/openemr/
Username admin/pass and you can verify the export is working fine for the LBF form & lists.
Running Docker on Windows.
I used these commands to create the containers:
docker pull openemr/openemr:latest
docker pull phpmyadmin/phpmyadr:latest
docker pull phpmyadmin:latest
docker pull mysql:latest
docker network create mynet
docker run --detach --name mysql --env “MYSQL_ROOT_PASSWORD=root” --net mynet mysql --character-set-server=utf8
docker run --detach -p 81:80 --name phpmyadmin --env “PMA_HOST=mysql” --net mynet phpmyadmin/phpmyadmin
docker run --detach -p 80:80 --name openemr --env “MYSQL_HOST=mysql” --env “MYSQL_ROOT_PASS=root” --net mynet openemr/openemr
Check your apache error logs (where php errors are stored) on the docker image when you do the backup. Perhaps there’s something unique to the windows environment, shouldn’t be though since its a docker container.
How are you handling the writeable sites directory on the docker image? That’d be the other thing I’d look at. I believe the export writes out to /tmp/ but if it is writing to the sites directory and that’s locked down you may run into problems.
Looking at the log file in /var/log/apache2/
Undefined array key “data_type” in /var/www/localhost/htdocs/openemr/interface/main/finder/dynamic_finder.php on line 411
That’s the only thing you see after running the export and getting an error? That dynamic_finder.php is in a different code section, there should be other logs showing the error.
The name of the page for the backup is: /interface/main/backup.php so that should be showing in your logs if there is a php error being triggered.
[Fri Mar 21 15:18:12.674434 2025] [php:notice] [pid 105:tid 105] [client 172.19.0.1:50478] [2025-03-21T15:18:12.674129+00:00] OpenEMR.ERROR: Not all selected assets were included in header {“selectedAssets”:[“”],“foundAssets”:[“jquery”,“bootstrap”,“utility”,“main-theme”,“compact-theme”,“textformat”,“dialog”]} , referer: http://localhost/interface/main/tabs/main.php?token_main=VG294k1PcjJagERZ0D3H5Sz564RIi3LFN8ZidrV5
mysqldump: Got error: 1045: “Plugin caching_sha2_password could not be loaded: Error loading shared library /usr/lib/mariadb/plugin/caching_sha2_password.so: No such file or directory” when trying to connect
Haven’t seen that error before. You mentioned you’re running a mysql image above, yet its looking for a mariadb plugin. Not sure if you’re error is on the php server side, or if its on the mysql side of things.
@brady.miller or @jesdynf any thoughts on this?
The only other thing I would of trying is to use one of the image files from the development docker-composes. For example our easy-dev uses openemr/openemr-flex for the image and uses mariadb:11.4 for the database and see if you run into the same error. However you’d want to do a manual db dump and also copy your openemr sites directory (that has all the encryption keys) before you do something like that if you have work you want to save.
Just to be sure I’ll fire up my windows docker and test.
Update:
Test okay for me using easy dev.
11.4.4-MariaDB-ubu2404 - mariadb.org binary distribution
1 Like
Yea not sure how to change it to use mysql instead for that function.
Problem is MariaDB doesn’t support by default caching_sha2_password plugin. You must be using a mysql config to migrate your database. Check my.ini if authentication plugin caching_sha2_password is used.
You can update the user’s authentication method to mysql_native_password using an ALTER USER command.
1 Like
Looks like mysql 8 doesn’t either.
1 Like
How? To update native password? Nothing else has issues just the backup and export function
Sounds like to me that somehow your MariaDB install is corrupted or your client and server binaries are different. An install from the MariaDB repo’s should provide the correct/working native server and client utilities.
Where do the engine config’s come from?