Blank screen on first start of OpenEMR 5.0.2

brady.miller · May 10, 2020, 10:42pm

The nice thing about the above install instruction set is that is can be done on a bare bones ubuntu install (in fact, having apache installed on the ubuntu will cause issues since they will fight for port 80; this can easily be adjusted by changing the port in the docker-compose.yml script though). No messing with dependencies. It just works and you get to even drink a cup of (or )

Mohammad · May 11, 2020, 3:59am

if https with openemr certs. you do not need port 80, only 443 am I correct?

brady.miller · May 11, 2020, 4:53am

hi @Mohammad , Yes, to clarify, can also use port 443 (ssl), which can also be changed if needed in the docker-compose.yml

rdh61 · May 11, 2020, 6:49am

Thank you Sandra. That’s kind of you.

rdh61 · May 11, 2020, 6:53am

Thank you Stephen. Super simple hmmm, that’s tempting… I’ll give it a go. I presume I’d better purge my system of all openemr, mysql, mariadb, apache files and folders before starting…? What about php?

rdh61 · May 12, 2020, 6:43am

@stephenwaite @brady.miller

The docker procedure carried through smoothly, apparently successfully, but when I try to open localhost/openemr in my browser (Firefox), I persistently get: “Problem loading page. The connection to the server was reset while the page was loading”. Same in Chrome: “This site can’t be reached”.

brady.miller · May 12, 2020, 7:05am

try just:
http://localhost/

rdh61 · May 12, 2020, 7:09am

Thank you, that works.

rdh61 · May 12, 2020, 7:14am

@stephenwaite @brady.miller My next question is: How do I restore my openemr 5.0.2 backup to this docker installation?

gutiersa · May 12, 2020, 10:45pm

you don’t, but you can connect this installation to your database by entering the password information in …/sites/default/sqlconf.php

brady.miller · May 12, 2020, 11:36pm

Hi,
Backups and restores can be done with dockers like any other installation. The key difference is that need to do the steps within the openemr docker that you now have running. Just think of the docker as a virtual machine and then it makes more sense.

rdh61 · May 13, 2020, 5:21am

@gutiersa @brady.miller Sadly, I think it fair to say you both overestimate my understanding. I have a Docker installation. I have a backup, on a memory stick, made from a regular installation of 5.0.2 on another machine. I need that data accessible by my new Docker installation. What do I do? I am afraid I will need step by step instructions. My apologies.

stephenwaite · May 13, 2020, 11:03pm

hi @rdh61, no prob, we’re up for

let’s bring in the db first

extract the contents of emr_backup.tar on your to your Downloads folder
go there in your terminal prompt; cd ~/Downloads
gzip -d openemr.sql.gz
docker ps we’re looking for the container id for the mariadb to use in the next step
docker cp /home/$USER/Downloads/openemr.sql <mariadb container id>:.
docker exec -it <mariadb container id> /bin/bash
mysql -uroot -proot openemr < openemr.sql
exit
docker exec -it $(docker ps | grep _openemr | cut -f 1 -d " ") /bin/sh
wget https://raw.githubusercontent.com/openemr/openemr/rel-502/sql_upgrade.php
run the upgrade script even though not “upgrading” :); go to localhost/sql_upgrade.php in your browser
back to terminal and rm sql_upgrade.php
exit
go to localhost to login and see your data

rdh61 · May 14, 2020, 10:21am

Thank you very much. I have come unstuck at point 5. What have I done wrong?

robert@roberts-work-laptop:~$ cd ~/Downloads
robert@roberts-work-laptop:~/Downloads$ gzip -d openemr.sql.gz
robert@roberts-work-laptop:~/Downloads$ docker ps
CONTAINER ID        IMAGE                   COMMAND                  CREATED             STATUS              PORTS                                      NAMES
79f95d5fae4c        openemr/openemr:5.0.2   "./run_openemr.sh"       2 days ago          Up 39 minutes       0.0.0.0:80->80/tcp, 0.0.0.0:443->443/tcp   openemr_openemr_1
16d0ec71eb7a        mariadb:10.4            "docker-entrypoint.s…"   2 days ago          Up 39 minutes       3306/tcp                                   openemr_mysql_1
robert@roberts-work-laptop:~/Downloads$ docker cp /home/robert/Downloads/openemr.sql <16d0ec71eb7a>:
bash: 16d0ec71eb7a: No such file or directory

stephenwaite · May 14, 2020, 12:35pm

hi @rdh61, no need for the less than greater than symbols around the container id and you need the period to specify that you’d like to keep the same name on the copy:

docker cp /home/robert/Downloads/openemr.sql 16d0ec71eb7a:.

gutiersa · May 14, 2020, 2:38pm

Unfortunately, my understanding of docker containerization is minimal,

rdh61 · May 14, 2020, 3:19pm

OK, I got through the 11 steps, but what I see in my browser is:

“FATAL ERROR: crypt() function is not working correctly in OpenEMR”

But I have a doubt. When you wrote: “run the upgrade script even though not “upgrading” :); go to localhost/sql_upgrade in your browser” (I found out you meant “localhost/sql_upgrade.php” ), did you actually mean “run the script” (which I did, as though upgrading from 5.0.1), or did you just mean “go to localhost/sql_upgrade.php in your browser”?

stephenwaite · May 14, 2020, 3:38pm

nice catch, i edited, yes, had you run it just in case, it’s good practice

have seen that error before and we’ll have to reset your admin password
so back to the mariadb docker

docker exec -it 16d0ec71eb7a /bin/bash
mysql -uroot -proot openemr
UPDATE users_secure SET password = '$2a$05$MKtnxYsfFPlb2mOW7Qzq2Oz61S26s5E80Yd60lKdX4Wy3PBdEufNu', salt = '$2a$05$MKtnxYsfFPlb2mOW7Qzq2b$' WHERE username = 'admin';
login with admin and pass at localhost

rdh61 · May 14, 2020, 3:47pm

Thank you very much, all good now. If I should find anything not working as I expect, should I post on this thread or start a new one?

stephenwaite · May 14, 2020, 3:48pm

it’s fine here

did you have any documents to bring over from your previous install?