Situation
I have taken a look at the AWS standard installation and want to try to do something similar on Google Cloud using Cloud SQL and Cloud Storage. Muddled around until I almost got it but it only worked for a second.
Steps I took:
- Set up the Cloud SQL instance + enabled private networking. Copied the
private ip
. - Set up the VM on Debian with 2 persistent disks: logvolume01 and sitevolume
a. Also set up the custom hostname to beopenemr.{mydomain}.com
and pointed my domain to the public ip of the VM by adding an A record to my nameserver. - Set up docker and docker compose. used this guide
- Mounted the disks and edited fstab.
a. Encountered errors with hydrating the docker volumes when I tried to bind them to the mount locations of the disks. Seemed to only hydrate when the volumes where mounted as named volumes, so I mounted the disks where docker mounts named volumes:/var/lib/docker/volumes/{VOLUME NAME}/
instead of at/mnt/disks/{VOLUME NAME}
. some related documentation of this issue - Copied the following
docker-compose.yaml
onto my VM and spun up my container.
version: '3.1'
services:
openemr:
restart: always
image: openemr/openemr:7.0.0
ports:
- 80:80
- 443:443
volumes:
- logvolume01:/var/log
- sitevolume:/var/www/localhost/htdocs/openemr/sites
environment:
MYSQL_HOST: ${private ip copied from step 1}
MYSQL_ROOT_PASS: root
MYSQL_USER: openemr
MYSQL_PASS: openemr
OE_USER: admin
OE_PASS: pass
volumes:
logvolume01: {}
sitevolume: {}
OpenEMR Version
I’m using OpenEMR version 7.0.0
Operating System
Google Cloud VM - Debian GNU/Linux 11 (bullseye)
What happened/Issues
- I was able to get it up and running. Logged in once. And then pow! Website complained about a missing
site_id
the second time I tried to log in - Also… i’m not sure what the AWS buckets were used for in the AWS standard installation… backups? but I wanted to use a Cloud Storage Bucket for the patient documents because our practice has a ton of scanned documents. That makes more sense to me given the large file sizes of some medical …
- How would I get SSL encryption ???
- I’m lost as to how I would be able to upgrade in the future without deleting my database tables? Whenever I tried to create a new docker container it would complain that my tables were already created
Sorry for the long post and many questions.