I have the new server up and runniing and I am now tyring to the get backup file on the server. I am tyro at this and seems to not be working so well - trying to ssh it in but using putty I keep getting no file is found… gonna try DVD next… so once i have it is do not use the restore script?
To update database. I am unsure what the table name is - new to mysql and I do not know the command to slow the scolling so I cannot see the top of the table llisting for the update. Any advice. I have searched the web but no obvious solution yet. The command to import the data in mysql requires the tablename
Good morning we are still down but making progress. I have attempted to restore and I gen an error - it says Site ‘default’ already exists in ‘/var/www/openemr/sites’. Should delete this file or what ?
thanks
Stephen,
Looks like I’m getting closer, but still not quite there.
5.0.2 Install went ok
sql import and upgrade reported no errors
Copied documents, edi, ira to the new /var/www/html/openemr/sites/default/documents
However the command lines given in the upgrade guide call for a / at the end of each line, as in;
cp -r openemr_bk/sites/default/documents openemr/sites/default/
which would create a situation where the files would be copied to;
/var/www/html/openemr/sites/default/documents/documents
instead of
/var/www/html/openemr/sites/default/documents (which is where they are now)
In any case the calendar looks good, patients records show this error upon opening;
I tried changing the ownership of the numbered folders in the documents directory to www-data:www-data and the permissions to 0700 (which is what they were in the old system, but that didn’t do it.
Whats next?,
Today, after much help from the wonderful folks on this forum we cleared the last big hurdle (billing) and were able to submit acceptable Florida Blue claims. This marked the successful migration of OpenEMR v4.2.0 on Ubuntu14.04 to v5.0.2 on 18.04. There were many twists and turns (and a couple total reloads) but the end result is a pair of servers (one in the office & one at home) that stay in sync and are performing their much needed tasks of serving our doctors, their staff and 3,600+ patients. We owe much to the entire OpenEMR community, and to pay some of that back, I am donating a step-by-step how to guide compiled during the upgrade project to anyone who asks for it. If you need to update your 4.x versions to the new 5.0.2 and get on 18.04 at the same time, you may find this useful. I am going through the final editing and proof reading now and it will be available on May 20th. I’m re-testing the whole procedure using Ubuntu 20.04 this weekend and if it flies, I’ll put that in as well. Message me here if you’re interested in getting your hands on it. @hitechelp
1 Like
The Conversion guide I’ve been working on is complete and can be downloaded from my Gdrive Here
Those who are still stuck on v4.x.x and Ubuntu 14.04 now have a step-by-step procedure to get themselves up-to-date on Ubuntu 18.04 and OpenEMR v5.0.2 The guide also has extra features that I’ve developed over the years to help me be a better sysadmin and work smarter not harder. It includes; how to set up an off-site backup server and keep it in sync with your production server. How to set up and use Apache Logs Viewer to quickly screen your logs for hack attempts. How to set up an APC UPS and have it warn you via e-mail when the power goes out. How to warn off would by interlopers with a scary looking warning page and other bits and pieces. Best of luck to everyone and stay safe. @hitechelp
1 Like