XAMPP version for EMR - 5.0.2. Windows 10

brady.miller · February 22, 2020, 6:40pm

For the upgrade strategy here, I would probably take advantage of one of OpenEMR’s docker tricks, which supports automatic upgrade from 5.0.1 to 5.0.2.

Steps would be:

Start up a new 5.0.1 docker in a new directory via docker-compose up -d (change this to 5.0.1 instead of 5.0.2 here: https://gist.github.com/bradymiller/8f8dc5215b07d287f7dc0fed80bf2b9d#file-openemr-502-docker-example-docker-compose-yml-L18)
Bring in your current installation into this docker
Change back the above line to 5.0.2 and do another docker-compose up -d

and voila

ncavalier · February 25, 2020, 12:59am

After first successful installation on Linux Ubuntu, I trying reinstall it on other computer, and something getting wrong in step 3 of instructions provided by Bredy. I had the same problem first time, and then I replaced it from other code I found on Google.
Now it the same problem
Is it possible to post installation instruction on OpenEmr downloads, for Docker- Linux users. It will be very helpful for all users, who interesting in more advanced Openemr platform.

ncavalier · February 25, 2020, 1:02am

Error message from new instillation

nerik@nerik-2060:~/testopenemr$ docker-compose up -d
ERROR: Couldn’t connect to Docker daemon at http+docker://localhost - is it running?

If it’s at a non-standard location, specify the URL with the DOCKER_HOST environment variable.

ncavalier · February 25, 2020, 1:12am

I will start new topic - Docker installation instruction on Linux Ubuntu. Let’s do step by step tutorial to fix all problems.

ncavalier · February 26, 2020, 5:17pm

cverk · March 24, 2020, 11:30pm

I struggled through trying to upgrade using the current newest Xampp and version 5.0.2 because I could not just upgrade my current installation due to a lower version of php. It seems in addition to some bugs like you mentioned such as overlapping code boxes on the fee sheet, that it went back to the problem of very slow performance under windows.(using windows10, I7 processor and 8gb ram) Unfortunately all the previous suggestions that seemed to help before did not seem to help with the updated xampp version.So I am stuck at this point because it takes too long to load a patient to make it workable in my office so far.
The Docker thing looks like a pretty big learning curve for us windows users. Does it solve the performance problem because it seems like it would add more overhead that way?

ncavalier · March 25, 2020, 1:19am

I spend a lot of time to upgrade my current 5.0.1. Windows, but stuck with Xampp upgrade.
Also I spent mach more time with docker, its also not good chose for me yet. I learned how to do all the docker installation process on Linux, but also got a lot of problems with my data restore.
And finally I found best way for me, I switched from Windows platform to Linux Mint!!!
Mach better platform, very easy installation and upgrade process, and fast respond.
My recommendation for all windows users, don’t waist your time for upgrade to 5.0.2 it is not ready yet, its not working. Best choice to switch to Linux Mint!!!
If you need I can give you step by step installation instruction later .

cverk · March 25, 2020, 11:47pm

I built a server and tried the mint thing a while back and found it very difficult to get it to serve files correctly to the 6 windows work stations in my office. After struggling with it for awhile I converted back to xampp for windows. Xampp has been just fine since it is only running on a local wired network and I set all the suggested passwords which limits the security concerns. Frankly version 5.0.1 has worked fine for my needs in a small primary care office but it would be nice to keep up with the updates.
If the xampp option is going away however it would be nice to see some instructions on how to transfer all your data from 5.0.1 under windows xampp into a docker or VM and how you would set that up to run on a windows network. I am up to about 16 GB of data, so starting over without importing those files does not seem like an option.

ncavalier · March 27, 2020, 3:38pm

I just finished today my project to transfer my 5.0.1 windows Xampp based data, to 5.0.2. platform in Linux Mint.
We also have small private clinic, with a office based network for 8 computers. Every time with EMR upgrade we had a lot of issues. We moved the server to Linux Mint this time and it is working very well on the server computer but all the other computers are running Windows 10 without conflicts. This is my suggestion for your as well.

2017 · March 27, 2020, 5:22pm

Would you show the step by step procedures for the conversion? Thanks in advance

ncavalier · March 27, 2020, 7:00pm

All you need to do is, just install Linux Mint on new computer.
Backup you data from Open EMR.

INSTALL OPENEMR 5.0.1 ON MINT

OpenEMR 5.0.1 Ubuntu-Debian Package Installation with PHP7

INTRUCTIONS FOR INSTALL:

https://www.open-emr.org/wiki/index.php/OpenEMR_5.0.1_Ubuntu-Debian_Package_Installation_with_PHP7

THEN FALLOW RESTORE PROCEDURE BELOW

https://www.open-emr.org/wiki/index.php/Backing_Up_Using_the_Built_In_Tools

Restore script can be found in openemr/contrib/util as an executable file.
Copy emr_backup.tar and restore script to the home directory.

OPEN TERMINAL
sudo ./restore

/home/your home directory username/emr_backup.tar

in gaglae

/var/www/openemr/gacl.

Terminal Output

nerik@nerik:~$ sudo ./restore

WARNING: This script is experimental.

It may have serious bugs or omissions.

Use it at your own risk!

Now you will be asked for the backup file.

By default this is named emr_backup.tar, although you may have saved it as something else.

Enter path/name of backup file: /home/nerik/emr_backup03262020.tar

Extracting /home/nerik/emr_backup03262020.tar …

tar: Substituting `.’ for empty member name

Extracting /tmp/emr_backup/openemr.tar.gz …

Extracting /tmp/emr_backup/phpgacl.tar.gz …

tar: Substituting `.’ for empty member name

Do you want to specify site ID, locations or database names for the restore? [N/y] Y

Current values are shown in [brackets]. Just hit Enter to leave them as-is.

Site ID [default]? - enter

OpenEMR database name [openemr]? - enter

OpenEMR database user [openemr]?- enter

OpenEMR database password [escargot]?- enter

New OpenEMR web directory [/var/www/openemr]?- enter

New phpGACL web directory [ $phpgacl_location = dirname(FILE).’/…/gacl’;]? /var/www/openemr/gacl.

If you have a particular requirement for the UTF-8 collation to use,

then please specify it here. Hit Enter to accept the default ‘utf8_general_ci’.

Enter ‘none’ if you do not want UTF-8.

UTF-8 collation [utf8_general_ci]?- enter

Your Site ID will be ‘default’.

I will install a new OpenEMR web directory ‘/var/www/openemr’ from the backup.

I will restore the OpenEMR database backup to the MySQL database ‘openemr’.

The OpenEMR database user will be ‘openemr’ with password ‘escargot’.

MySQL will use character set ‘utf8’ with collation ‘utf8_general_ci’.

I will copy the phpGACL web directory backup to ‘/var/www/openemr/gacl.’.

Please check the above very carefully!

Any existing databases and directories matching these names will be DESTROYED.

Do you wish to continue? [N/y] y

In order to create MySQL databases and users on this computer, I will need to

log into MySQL as its ‘root’ user. The next question asks for the MySQL root

user’s password for this server, the one that you are restoring to. This is

a MySQL password, not a system login password. It might be blank.

Enter the password, if any, for the MySQL root user:

Dropping old OpenEMR database if it exists …

Database “openemr” dropped

Restoring OpenEMR database …

mysql: [Warning] Using a password on the command line interface can be insecure.

Restoring OpenEMR web directory tree …

Modifying /var/www/openemr/sites/default/sqlconf.php …

Restoring phpGACL web directory tree …

Modifying /var/www/openemr/library/acl.inc …

All done.

UPGRADE TO 5.0.2

Stable Production Release (Version 5.0.2)

https://www.open-emr.org/wiki/index.php/OpenEMR_Downloads

RENAME OPENEMR FOLDER TO OPENEMR_BK

DOWN LOAD: openemr-5.0.2.tar.gz

DOUBLE CLIC ON IT TO UNPACK IT

THAN MOVE IT IN TO VAR/WWW/

THAN GO TO OPENEMR_BK/SITES/DEFAULT/SQLCOFIG.PHP AND COPY IT

THAN GO TO OPENEMR SITES/DEFAULT/SQLCOFIG.PHP AND REPLACE IT

Copy following directories from openemr_bk to - openemr directory (copy in the same order as listed below):

openemr_bk/sites/default/documents (COPY TO) => openemr/sites/default/documents 
openemr_bk/sites/default/edi (COPY TO) => openemr/sites/default/documents/edi 
openemr_bk/sites/default/era (COPY TO) => openemr/sites/default/documents/era 
openemr_bk/sites/default/letter_templates/custom_pdf.php (COPY TO) => openemr/sites/default/custom_pdf.php 
openemr_bk/sites/default/letter_templates (COPY TO) => openemr/sites/default/documents/letter_templates 
openemr_bk/sites/default/procedure_results (COPY TO) => openemr/sites/default/documents/procedure_results

THAN GO TO : http://localhost/openemr/sql_upgrade.php

INSTRUCTIONS: https://www.open-emr.org/wiki/index.php/Linux_Upgrade_5.0.1_to_5.0.2

Richardburt · March 29, 2020, 1:57pm

Morning Mr Cavalier,
In the installation on mint did you install Apache server?

ncavalier · March 29, 2020, 4:58pm

No, its installs automatically, when you do OpenEMR installation.
Its very easy installation, and much easier then Windows installation.

Richardburt · March 29, 2020, 5:07pm

Great thanks for reply. I am going to start my install now following your instructions. I have the same situation as you do moving from windows to Linux.

Richardburt · March 29, 2020, 7:06pm

I am getting an error site ‘default’ already exists in ’ /var/www/openemr/sites’

mdsupport · March 29, 2020, 8:12pm

If you are reinstalling, check and rename subdirectory ‘default’ - specifically sql configuration file - from prior setup.

Richardburt · March 29, 2020, 8:15pm

Thanks will try out.

ncavalier · March 29, 2020, 9:32pm

If you doing new Open EMR installation on Linux, you not suppose to receive this message.
When you restoring your backup.tar data, you need to rename openemr folder to like openemr_old, and then start the process. Restore process will create new openemr file automatically. And then after finish the process, need to delete openemr_old.
Same, in time of upgrade process to 5.0.2. need to rename openemr folder to openemr_bk.

Richardburt · March 29, 2020, 9:49pm

This is the error i am getting .

Dropping old OpenEMR database if it exists …
Database “openemr” dropped
Restoring OpenEMR database …
mysql: [Warning] Using a password on the command line interface can be insecure.
mysql: [Warning] Using a password on the command line interface can be insecure.
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1118 (42000) at line 3640: Row size too large (> 8126). Changing some columns to TEXT or BLOB may help. In current row format, BLOB prefix of 0 bytes is stored inline.
Error: Restore to database ‘openemr’ failed.

ncavalier · March 30, 2020, 1:10am

It’s because you didn’t renamed original openemr folder. System created new openemr folder and it’s going to make an error.
Start over again and rename openemr folder.