which version are you running currently that you’re able to log into and use?
I have version 7 on my home computer, which I am able to log into and use.
Ok and you wish to bring that over to this computer running lubuntu?
Then you need a backup of that OpenEMR to work with.
I do not have a computer running Lubuntu! Lubuntu was my OLD operating system. I replaced it with Linux Mint.
Both my work computer and my home computer run Linux Mint, my work computer LM21 and my home computer LM19.1.
The backup that I have was made with Openemr 7 on Lubuntu on my work computer. I then changed my OS. It is now LM21.
I restored that backup with success on my home computer, but with failure and all the problems we have been dealing with on my work computer.
Hide quoted text
would get another backup from the home computer and try again on the work computer
“would get another backup from the home computer and try again on the work computer”
Same result: blank screen.
Here is my terminal output during the restore procedure (I had placed my extracted backup in my home folder):
robert@robert-Lenovo-B590:~$ gzip -d openemr.sql.gz
robert@robert-Lenovo-B590:~$ docker ps
CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES
8d884a549e8c openemr/openemr:7.0.0 "./openemr.sh" 6 days ago Up 5 minutes 0.0.0.0:80->80/tcp, :::80->80/tcp, 0.0.0.0:443->443/tcp, :::443->443/tcp openemr_openemr_1
ec9b8b94e1be mariadb:10.6 "docker-entrypoint.s…" 6 days ago Up 5 minutes 3306/tcp openemr_mysql_1
robert@robert-Lenovo-B590:~$ docker cp /home/robert/openemr.sql ec9b8b94e1be:.
robert@robert-Lenovo-B590:~$ docker exec -it ec9b8b94e1be /bin/bash
root@ec9b8b94e1be:/# mysql -uroot -proot
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 3
Server version: 10.6.8-MariaDB-1:10.6.8+maria~focal mariadb.org binary distribution
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB [(none)]> drop database openemr
-> create database openemr
-> \q
Bye
root@ec9b8b94e1be:/# mysql -uroot -proot openemr < openemr.sql
root@ec9b8b94e1be:/# exit
exit
robert@robert-Lenovo-B590:~$ docker exec -it $(docker ps | grep _openemr | cut -f 1 -d " ") /bin/sh
/var/www/localhost/htdocs/openemr # wget https://github.com/openemr/openemr/blob/rel-700/sql_upgrade.php
Connecting to github.com (140.82.121.4:443)
saving to 'sql_upgrade.php'
sql_upgrade.php 100% |*************************************************************************************************************************| 298k 0:00:00 ETA
'sql_upgrade.php' saved
# AT THIS POINT I RAN localhost/sql_upgrade.php IN MY BROWSER
/var/www/localhost/htdocs/openemr # rm sql_upgrade.php
/var/www/localhost/htdocs/openemr # exit
Here is the output when bringing over my documents:
robert@robert-Lenovo-B590:~$ tar xvzf openemr.tar.gz sites/default/documents
sites/default/documents
sites/default/documents/1
sites/default/documents/2
sites/default/documents/3
# MANY NUMBERED FOLDERS LIKE THIS WITH INDIVIDUAL PATIENT RECORDS - EDITED OUT HERE FOR PRIVACY REASONS
sites/default/documents/mpdf
sites/default/documents/mpdf/pdf_tmp
sites/default/documents/mpdf/pdf_tmp/README
sites/default/documents/mpdf/ttfontdata
sites/default/documents/edi
sites/default/documents/edi/README.txt
sites/default/documents/logs_and_misc
sites/default/documents/logs_and_misc/methods
sites/default/documents/logs_and_misc/methods/README.md
sites/default/documents/procedure_results
sites/default/documents/procedure_results/README
sites/default/documents/smarty
sites/default/documents/smarty/main
sites/default/documents/smarty/main/%%15^15E^15E9C670%%general_upload.html.php
sites/default/documents/smarty/main/%%89^899^8992C16F%%general_list.html.php
sites/default/documents/smarty/main/%%A6^A60^A60BDC9D%%general_fragment.html.php
sites/default/documents/smarty/gacl
sites/default/documents/.htaccess
sites/default/documents/onsite_portal_documents
sites/default/documents/onsite_portal_documents/templates
sites/default/documents/onsite_portal_documents/templates/Insurance_Info.tpl
sites/default/documents/onsite_portal_documents/templates/Privacy_Document.tpl
sites/default/documents/onsite_portal_documents/templates/Hipaa_Document_Oemr.tpl
sites/default/documents/couchdb
sites/default/documents/couchdb/README
sites/default/documents/certificates
sites/default/documents/certificates/README.md
sites/default/documents/era
sites/default/documents/era/README.txt
sites/default/documents/temp
sites/default/documents/temp/README
sites/default/documents/custom_menus
sites/default/documents/custom_menus/patient_menus
sites/default/documents/custom_menus/patient_menus/Custom.json
sites/default/documents/custom_menus/Custom.json
robert@robert-Lenovo-B590:~$ docker cp sites/default/documents/ $(docker ps | grep _openemr | cut -f 1 -d " "):/var/www/localhost/htdocs/openemr/sites/default/
robert@robert-Lenovo-B590:~$
what do you see on your home computer?
docker exec -it $(docker ps | grep _openemr | cut -f 1 -d " ") ls -lrt openemr/sites/default/documents/logs_and_misc/methods
robert@robert-ideacentre-AIO-520-22IKU:~$ docker exec -it $(docker ps | grep _openemr | cut -f 1 -d " ") ls -lrt openemr/sites/default/documents/logs_and_misc/methods
ls: openemr/sites/default/documents/logs_and_misc/methods: No such file or directory
robert@robert-ideacentre-AIO-520-22IKU:~$
In fact:
robert@robert-ideacentre-AIO-520-22IKU:~$ docker exec -it $(docker ps | grep _openemr | cut -f 1 -d " ") ls -lrt openemr
ls: openemr: No such file or directory
robert@robert-ideacentre-AIO-520-22IKU:~$
what about docker exec -it $(docker ps | grep _openemr | cut -f 1 -d " ") ls -lrt
robert@robert-ideacentre-AIO-520-22IKU:~$ docker exec -it $(docker ps | grep _openemr | cut -f 1 -d " ") ls -lrt
total 2084
dr-x------ 3 apache root 4096 Oct 30 2021 sites
-r-------- 1 root root 1975 Feb 22 2022 xdebug.sh
-r-------- 1 root root 2109 Feb 22 2022 ssl.sh
-rwx------ 1 root root 8136 Feb 22 2022 openemr.sh
dr-x------ 1 apache root 4096 Aug 7 21:44 config
-r-------- 1 apache root 475624 Aug 7 21:44 composer.lock
-r-------- 1 apache root 4427 Aug 7 21:44 composer.json
-r-------- 1 apache root 124 Aug 7 21:44 cloudbuild.yaml
dr-x------ 1 apache root 4096 Aug 7 21:44 ci
dr-x------ 1 apache root 4096 Aug 7 21:44 ccr
-r-------- 1 apache root 5269 Aug 7 21:44 build.xml
dr-x------ 1 apache root 4096 Aug 7 21:44 bin
dr-x------ 1 apache root 4096 Aug 7 21:44 apis
-r-------- 1 apache root 22160 Aug 7 21:44 acknowledge_license_cert.html
-r-------- 1 apache root 476705 Aug 7 21:44 _rest_routes.inc.php
-r-------- 1 apache root 22585 Aug 7 21:44 _rest_config.php
-r-------- 1 apache root 3021 Aug 7 21:44 README.md
-r-------- 1 apache root 35147 Aug 7 21:44 LICENSE
-r-------- 1 apache root 15499 Aug 7 21:44 FHIR_README.md
dr-x------ 1 apache root 4096 Aug 7 21:44 Documentation
-r-------- 1 apache root 2214 Aug 7 21:44 DOCKER_README.md
-r-------- 1 apache root 28787 Aug 7 21:44 CONTRIBUTING.md
-r-------- 1 apache root 5526 Aug 7 21:44 CODE_OF_CONDUCT.md
-r-------- 1 apache root 27016 Aug 7 21:44 API_README.md
-r-------- 1 apache root 2089 Aug 7 21:44 version.php
dr-x------ 1 apache root 4096 Aug 7 21:44 tests
dr-x------ 1 apache root 4096 Aug 7 21:44 templates
dr-x------ 1 apache root 4096 Aug 7 21:44 swagger
dr-x------ 1 apache root 4096 Aug 7 21:44 src
dr-x------ 1 apache root 4096 Aug 7 21:44 sql
dr-x------ 1 apache root 4096 Aug 7 21:44 sphere
-r-------- 1 apache root 26 Aug 7 21:44 robots.txt
dr-x------ 1 apache root 4096 Aug 7 21:44 portal
-r-------- 1 apache root 2178 Aug 7 21:44 phpunit.xml
-r-------- 1 apache root 3524 Aug 7 21:44 package.json
dr-x------ 1 apache root 4096 Aug 7 21:44 oauth2
dr-x------ 1 apache root 4096 Aug 7 21:44 modules
dr-x------ 1 apache root 4096 Aug 7 21:44 library
dr-x------ 1 apache root 4096 Aug 7 21:44 interface
-r-------- 1 apache root 917 Aug 7 21:44 index.php
-r-------- 1 apache root 23074 Aug 7 21:44 gulpfile.js
dr-x------ 1 apache root 4096 Aug 7 21:44 gacl
-r-------- 1 apache root 2 Aug 7 21:44 docker-version
dr-x------ 1 apache root 4096 Aug 7 21:44 docker
dr-x------ 1 apache root 4096 Aug 7 21:44 custom
dr-x------ 1 apache root 4096 Aug 7 21:44 controllers
-r-------- 1 apache root 109 Aug 7 21:44 controller.php
dr-x------ 1 apache root 4096 Aug 7 21:44 contrib
dr-x------ 1 apache root 4096 Aug 7 21:44 vendor
-r-------- 1 apache root 693653 Aug 7 21:45 package-lock.json
dr-x------ 1 apache root 4096 Aug 7 21:45 public
dr-x------ 1 apache root 4096 Aug 7 21:49 ccdaservice
robert@robert-ideacentre-AIO-520-22IKU:~$
This may also be of interest:
robert@robert-ideacentre-AIO-520-22IKU:~$ docker exec -it $(docker ps | grep _openemr | cut -f 1 -d " ") ls -lrt sites/default/documents/logs_and_misc/methods
total 4
-rwx------ 1 apache 1000 63 Sep 30 2018 README.md
robert@robert-ideacentre-AIO-520-22IKU:~$
do you have an older backup with the keys in the logs_and_misc/methods folder?
I have an older backup, done on my work computer just before I upgraded openemr from v6 to v7. But it does not contain anything in the logs_and_misc/methods folder except the README.md file.
what does this output on your work computer?
docker exec -it $(docker ps | grep _openemr | cut -f 1 -d " ") ls -lrt sites/default/documents/logs_and_misc/methods
robert@robert-Lenovo-B590:~$ docker exec -it $(docker ps | grep _openemr | cut -f 1 -d " ") ls -lrt sites/default/documents/logs_and_misc/methods
total 12
-rwx------ 1 apache 1000 63 Sep 30 2018 README.md
-rw-r–r-- 1 apache apache 155 Aug 20 15:15 sixb
-rw-r–r-- 1 apache apache 155 Aug 20 15:15 sixa
robert@robert-Lenovo-B590:~$
That’s a turn up for the books… sixa and sixb. I trust you can figure out what’s going on because it makes absolutely no sense to me!
pretty sure those keys are from when you installed a fresh openemr and logged in and since your backup has no keys it didn’t overwrite these and allow you to access the db
it should be fine to remove these keys in this case which will allow you to access the db since it will make new keys when none are found
docker exec -it $(docker ps | grep _openemr | cut -f 1 -d " ") rm sites/default/documents/logs_and_misc/methods/sixa
docker exec -it $(docker ps | grep _openemr | cut -f 1 -d " ") rm sites/default/documents/logs_and_misc/methods/sixb
then can login
Should I save them somewhere somehow (just in case) before I delete them?
sure,
docker cp <openemr container id>:/var/www/localhost/htdocs/openemr/sites/default/documents/logs_and_misc/methods/sixa ~/Documents/.
docker cp <openemr container id>:/var/www/localhost/htdocs/openemr/sites/default/documents/logs_and_misc/methods/sixb ~/Documents/.Thank you. I can now log in and use openemr!
Clearly this shouldn’t have happened. Is it something I have done wrong, or is it something for developers to look into?
Also, on my home computer, is it going to be a problem that there appears to be no sixa and sixb?
the backup should’ve had the keys so would make a fresh backup and confirm
sixa and sixb are present and correct in the new backup.
Is it going to be a problem that there appears to be no sixa and sixb on my home computer even though the software is working?