How to backup Layout Based Form? (LBF)

George_Messiha · March 21, 2025, 7:55pm

I installed via docker…

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

To repro…

sjpadgett · March 21, 2025, 8:34pm

Sorry George but I’m not a docker expert and while I use windows docker, I always use an openemr image. Mostly the development-easy from openemr/docker directory.
Have you looked into https://hub.docker.com/r/openemr/openemr/?

George_Messiha · March 21, 2025, 10:51pm

Yes 7.02… openemr/openemr latest

brady.miller · March 22, 2025, 4:04am

Likely an issue with mariadb client on alpine linux connecting to mysql database (since those tools use alpine linux client rather than the standard openemr database connector).

For the older mysql 8.* versions have needed to do the following for it to work (--default-authentication-plugin=mysql_native_password):

github.com/openemr/openemr

ci/apache_83_80/docker-compose.yml

master


      
          # docker-compose.yml for travis ci testing
          services:
            mysql:
              restart: always
              image: mysql:8.0
              command: ['mysqld','--character-set-server=utf8mb4','--default-authentication-plugin=mysql_native_password']
              environment:
                MYSQL_ROOT_PASSWORD: root
            openemr:
              restart: always
              image: openemr/openemr:flex-3.20
              ports:
              - 80:80
              - 443:443
              volumes:
              - ../../:/var/www/localhost/htdocs/openemr

Recommend the following for a starting point for 7.0.2 when using the production openemr dockers:

github.com/openemr/openemr

docker/production/docker-compose.yml

rel-702

# Use admin/pass as user/password credentials to login to openemr (from OE_USER and OE_PASS below)
# MYSQL_HOST and MYSQL_ROOT_PASS are required for openemr
# MYSQL_USER, MYSQL_PASS, OE_USER, MYSQL_PASS are optional for openemr and
#   if not provided, then default to openemr, openemr, admin, and pass respectively.
version: '3.1'
services:
  mysql:
    restart: always
    image: mariadb:10.11
    command: ['mysqld','--character-set-server=utf8mb4']
    volumes:
    - databasevolume:/var/lib/mysql
    environment:
      MYSQL_ROOT_PASSWORD: root
  openemr:
    restart: always
    image: openemr/openemr:7.0.2
    ports:
    - 80:80
    - 443:443

This file has been truncated. show original