4.1.2-7 Upgrade to 4.2.0 left sidebar absent

system · July 15, 2015, 4:01am

hamdpa wrote on Wednesday, July 15, 2015:

Hi fsgl,
Just noticed that your 5/2/15 post above says to upgrade after doing the restore. Does that mean that when you restore to a newer version it becomes the older version then you have to upgrade it, or am I misreading your post?
Thank you,
Henry

system · July 15, 2015, 5:56am

fsgl wrote on Wednesday, July 15, 2015:

When the 4.2.0 Ubuntu-Debian Package was installed, the login page should have version 4.2.0 under the login button.

With restore, the web directory & database from 4.1.2(7) replaced that from 4.2.0(2). You need to run the Upgrade. After upgrading, login should read 4.2.0(2) again. It should also be patched to (3).

When you have more time in the future, consider Linux Mint. It’s far more user friendly than Ubuntu. Adding a screenshot is a snap. Just click the icon from the panel. No more fussing with LibreOffice.

If you need a suggestion for the creation of a system image, just holler. Should emr_backup.tar fails to restore, it will be a comfort to have a system image on hand.

Windows’ built-in system image creation tool is unreliable & clumsy to use.

system · July 15, 2015, 12:57pm

hamdpa wrote on Wednesday, July 15, 2015:

Hi fsgl,
Thank you. I thought something went wrong. However, when I try to upgrade 4.1.2(7) to 4.2 it has an error. Says “This package can not upgrade OpenEMR, because OpenEMR is not installed at /var/www/openemr”.
What are my options. This is a result of adding /html/ to the path. Can I simply rename that file or do I need to start all over again.

Henry

system · July 15, 2015, 4:52pm

hamdpa wrote on Wednesday, July 15, 2015:

fsgl
As an aside are you running Linux Mint desktop or server? If your running a server does it have a graphical interface? I need a server.
Thanks
Henry

system · July 15, 2015, 8:51pm

fsgl wrote on Wednesday, July 15, 2015:

Just move the openemr web directory from html to var/www & run the upgrade again.

Brady struggled with Ubuntu’s change of the web directory from var/www to var/www/html. He came up with a “trick” to circumvent this annoying development. I cannot find that post. The web directory is not truly in var/www. It is a bit of am “illusion”.

You may want to want to change Line 175 back to var/www/openemr for future restores.

My test copy is on Linux Mint 17. LM is only available with a GUI. Unlike Ubuntu, no server version. Does it matter if we are talking about a VM?

system · July 15, 2015, 11:48pm

hamdpa wrote on Wednesday, July 15, 2015:

Yes need server for everyone else to login to the system. It makes sense why you prefer Linux Mint if your using desktop version. I’ll try your suggestion. If it doesn’t work will use copy of appliance prior to restore, but change restore back to the way it was originally.

Thanks again,

Henry

system · July 16, 2015, 1:25pm

fsgl wrote on Thursday, July 16, 2015:

Found this mini-tutorial.

VirtualBox is supposed to be free.

system · July 16, 2015, 4:22pm

fsgl wrote on Thursday, July 16, 2015:

2nd find.

system · July 23, 2015, 4:00am

hamdpa wrote on Thursday, July 23, 2015:

Thank you fsgl,

I’ve been using VMware only because that’s what Brady used originally and have become familiar with it. My understanding is that the VM is not what gives you server ability, but rather the Ubuntu server. Since LM Mint doesn’t come in a server version it’s not an option for me. If I am incorrect please let me know.

Henry

system · July 23, 2015, 8:39am

fsgl wrote on Thursday, July 23, 2015:

If you have a shared folder in VirtualBox so that staff can have access to OpenEMR, is a server an absolute requirement?

If everything is working well with VM & Ubuntu, no need to switch.

system · August 2, 2015, 3:32pm

hamdpa wrote on Sunday, August 02, 2015:

Hi to all,
Still trying to upgrade OpenEMR 4.1.2(7) to 4.2. Am running Ubuntu 14.04.02 LTS server guest on a Windows 8.1 Pro host. I backedup with admin/backup. Restored the backup and everything appears ok. Checked last patient inputed into the system on Friday and the patient is there. When I try to now update the new 4.1.2(7) instance to 4.2 I get the below error. Can anyone please help.

Thank you,

Henry

system · August 2, 2015, 6:48pm

fsgl wrote on Sunday, August 02, 2015:

According to this post, MS was required to install the old version in the new OS, restore the backup to it, backup again from the new OS, restore in 4.2.0 then upgrade.

system · August 3, 2015, 2:20am

hamdpa wrote on Monday, August 03, 2015:

HI fsgl,
I believe you mean;

Install the an old version of 4.1.2(7) in the new OS
Restore the backup to it
Upgrade to 4.2

Is this the correct sequence?
Looks like its back to the drawing board, unless there is reliable way to uninstall OpenEMR

As allways you are very insightfull.
Thank you,
Henry

system · August 3, 2015, 11:28am

fsgl wrote on Monday, August 03, 2015:

Hi Henry,

I was always of the impression that one can leapfrog from version 3.0 directly to 4.2.0 in one fell swoop. The school of hard knocks taught MS that is not exactly so. It was very good of him to share his experience in his last post.

Try these suggestions for deletion. I think that if you have to reinstall Ubuntu 14.04 more than once, Macrium Reflect would work for the VM as well. Because you already have a Windows device, it would be quite easy to burn the Windows PE .iso.

I reread the post. Your understanding of the sequence appears to be correct.

Hopefully we will get this nut cracked as well.

system · August 4, 2015, 10:33am

fsgl wrote on Tuesday, August 04, 2015:

If your 3 step process doesn’t work, try the following.

install 4.1.2 in Ubuntu 14.04.
restore backup to it.
backup from 4.1.2 in 14.04.
delete 4.1.2 in 14.04.
install 4.2.0 in 14.04.
restore backup from 3 to 5.
upgrade database.

system · August 17, 2015, 1:45pm

drjccaldwell wrote on Monday, August 17, 2015:

I have been very slack lately but with ICD-10 looming and some other issues I have come to the realization that some work is needed.
Current System:

Ubuntu 10.04
OpenEMR 4.1.0
Customized Back-Up solution ( Convinced some senior college students it should be their senior project. Worked out great. They brought the whole class to the office and I have a good back up solution. Will try to document this sometime for others to copy.)

Will be upgrading to:

LinuxMint 17.2 MATE ( Maintained until 2019)
OpenEMR 4.2.0 with patches
Make sure Back-Up is working
Load ICD-10 codes

I will attempt to write down the steps I take and post afterwards and the missteps will be evident here…

As a very unskilled practitioner hopefully my contributions will help others.
(Should have some posts within the week.)

system · August 17, 2015, 4:07pm

fsgl wrote on Monday, August 17, 2015:

Upgrade of OpenEMR had been straightforward in the past just by running commands for Ubuntu-Debian Package. Things became more complex when Canonical moved the web directry to var/www/html. MS has written that old version of OE must be installed in LM 17.2 as a prerequisite, therefore he indicated that leapfrogging is not possible.

Great to see that upgrade of LM is not such a chore anymore. Did not upgrade from 17 myself because it works well. Good move to LM because of user friendliness.

System image creation & recovery with Macrium is a very handy tool, especially if there are OS upgrades as well.

Recovery of emr_backup.tar with the restore script works very well, provided that the user knows the difference between the MySQL password & root password.

We use only 16 ICD codes in the office. Entire process took 20 minutes with this converter.

system · September 7, 2015, 4:32pm

hamdpa wrote on Monday, September 07, 2015:

Hi fsgl,

Finally cracked this nut! I confirmed that you can only restore to the same version that you backed up (Found a forum post where Rod Roark mentions this). Had to start all over. Did the following;

Followed Brady’s “OpenEMR 4.1.1 Appliance Manual” as much as possible given that upgraded Ubuntu, Webmin and some of the programs are slightly different.

Installed latest 64 bit VMware player
Installed Ubuntu Server 64 bit 14.04 LTS (after confirming that my amd chip is compatible)
Installed Webmin
Installed VMware Tools (this is needed to support VIX)
Installed VMware VIX 1.14 (in windows OS not Ubuntu OS appliance) (this is needed to support PowerShell commands used for soft shutdowns and start up to properly automate backup of entire appliance)
Configure Powershell command scripts which are used with Windows Task Scheduler to automate backup
Installed Postfix Mail Server
Configured Static IP Address
Confirmed VMware player clock and hardware clock same
Installed Brady’s OpenEMR 4.1.2-3 package (which reads on Login Page as 4.1.2-7)
Patched to 7 (just to be sure)
Installed and configured SSL self signed Certificates (via webmin)
Configured Firewall (via webmin)
Configured Router for new port forwarding IP address
Installed Brady’s “cool” appliance startup /shutdown script that confirms IP address (Just looks Good)
Copied restore file from old 4.1.2-7 appliance to new 4.1.2-7 just to be sure as they had different dates
Tried Backup via Web interface, but found that sql file was not properly being created. When I tried to restore got an error stating (tar substituting ”.” for empty member name)
By untarring the emr_backup.tar file I found it could not find the sql file only the openemr file.
Thus did manual backup and taring of both sql file and openemr file as per wiki and this restored without a hitch. Avoided permission problems by using (sudo –i) thus working in root (#).
Upgraded to OpenEMR 4.2.0-3
Checked OpenEMR and everything looks good!
Fixed openemr/library/gen_x12_837.inc.php file as started getting Availity BCBS sender ID problem again when tested.
Patch to 4.2.0-4

Love the appliance. Copy after every step and dump it when you make a mistake and start back where you left off without any fear. Leave the old appliance in library until you’re sure you don’t need it anymore.

Ahh Nirvanna!!!

Thank you for your help.

Henry

system · September 7, 2015, 6:59pm

fsgl wrote on Monday, September 07, 2015:

Good to hear that the ordeal is over & that we have another confirmation restore script only works within the same version of OpenEMR.

Thanks for the feedback. It will help others with their appliance.

system · September 8, 2015, 10:53pm

fsgl wrote on Tuesday, September 08, 2015:

Henry, your tutorial is officially in the Wiki.

Appliance aficionados should be pleased.