I have been using 4.1.0 for the last 3 years. I do my backups which at one point stopped working for 14 months and then mysteriously started working again (linuxmint user). The machine I am currently using is in the process of slowly dieing. So…I have a new machine Linuxmint 17.1 and and install of the latest openemr download. I have my backup file and also a config file from 4.1.0 and I am trying to install on the new machine.
I have no clue how to utilize the config file (I am in Canada so there are such additions as provinces to the states list, PHN number, etc). I tried installing the backup file and the process went smoothly but now I cannot login using admin-pass, admin-mypassword, myaccount-mypassword and so I have no access.
Any help is appreciated - I have enough computer knowledge to be dangerous but I studied medicine and not computing ;). In advance thanks.
Install is fine - even the login image is the old one with the clinic name for 4.2 now. I can go in as administrator in linux and see the documents that are part of charts, etc. However, when I go to log in I get: Failure during database access! Check server error log. Which is different from the invalid password message I get when I type things in wrong on the 4.1 install
And guess what - I do not know how to check the server error log. Should I have upgraded one update at a time and then moved to 4.20 that way?
Because backup had been problematic for 14 months & because it restores the 4.1.0 web directory when the 4.2.0 web directory is needed, this transfer method is the wrong approach.
Transferring thus works well only if the old & new devices are on the same OpenEMR version.
It may be difficult to pinpoint each corrupt file to correct it.
Unlike in Windows, where the backup contains a copy of OpenEMR allowing the practice to resume work simply by starting Apache/MySQL; Linux users must first install OpenEMR in the new device before importing the old data.
A drawback of using Linux is the fact that incomplete deletion of OpenEMR will prevent its reinstall. The deletion of the xampp directory in Windows occurs in minutes & is complete.
Perhaps it would be more efficient to clear the decks & begin anew.
Suggestion:
Delete OpenEMR in the new device by reinstalling LM 17.1.
Create a system image before installing OpenEMR in case it needs deletion & reinstall.
Install the Package via the command line as it is faster & less error-prone than using the Debi Installer.
Copy the 4 default folders from 4.1.0: documents, era, edi, letter_templates & paste into the 4.2.0 default folder.
I am wondering if my problem is around the config file? I do an export from 4.1 and then can re-import into 4.1, do the database recovery and all is fine. However, 4.2 doesn’t have the Import Config command under the Backups tab. Is there a script for this elsewhere that I could use? I have added provinces, and a clinic ID, and a few other things
Export Configuration will copy the files in attached, but it’s not the entire database as described here.
The regular backup will dump the database, but you are having a problem with its recovery.
You can tease out the copy of the database (openemr.sql) from emr_backup.tar & import it into phpMyAdmin in the new device. That method is less reliable as a mysqldump.
We will walk you through the entire process, step-by-step, in minute detail; if need be. Don’t be embarrassed to ask, because that is how we all learn.
Step by step may well work - I was looking at the existing folder for phpMyAdmin and I don’t recognize any files in there for openemr. Just tell me what files to copy where and with sudo I am okay (maybe)
Be prepare to use the “nuclear option” & Macrium Reflect; if you cannot get rid of every last bit of OpenEMR. It is not possible to reinstall OpenEMR if old pieces remain.
Package Install, Import of Old Data & Upgrade of Old Database
Install the Ubuntu Debian Package. Run each of the commands, one at a time. You will be asked to supply a MySQL root password during the installation.
Copy the dumpfile from flash drive to the home directory on the new device.
In new device run this command to import old database,
sudo mysql -u root -p openemr < /home/your home directory username/dumpfile.sql
When prompted, supply MySQL root password from the installation of the package from Step 1 of this post.
Copy the various default folders from 4.1.0 to the 4.2.0 default folder.
Upgrade the old database with these instructions, again running one command at a time.
Check that the login page is 4.2.0 (2) & that login is possible.
damn, one more issue - I cannot copy the documents file from the sites/default folder - even with sudo it says that I don’t have permission and it is omitted.(the other three I do not use: era, edi, and letter templates.