Ubuntu 14.4 End Of Life and OpenEMR


(David Martelle) #1

Situation
How to get my server operating system (OS) up-to-date, i.e. to Ubuntu 18.4 or even 16.4 would be ok.
As Ubuntu 14.4 (aka Trusty Tahr) approaches end of life (EOL) which is 30 April, 2019, we are faced with either paying Canonical for extended security maintenance (ESM) or upgrading our OS. Needless to say the OS upgrade is the desired path.

However, the OS upgrade has been an exercise in futility. At this point we’re facing the ESM fees because we have yet to discover how to migrate OpenEMR to a current Ubuntu OS.

I’ve read everything I can find and tried everything I can think of without succeeding in getting a usable system on 16.4.

  1. Running “do-release-upgrade”
    This ends with errors indicating it can’t update the OpenEMR package and a disk that won’t boot.

  2. Running the 4.2.2 package upgrade with PHP5 to get the database up to speed in hopes we can create a backup that we can restore to a fresh 4.2.2 install on 16.4 but the restore fails.

  3. Ran the 5.0.0 package upgrade with PHP5 and made a backup but it will not restore to a 5.0.0 on 16.4 either.

Since we can’t run the Upgrade packages that use PHP7 how are we supposed to get off 14.4?

OpenEMR Version
I’m using OpenEMR version 4.2.0(4)

Browser:
I’m using: FireFox 60.6.1esr (32-bit)

Operating System
I’m using: Ubuntu 14.4

Logs
Did you check the logs? Was there anything pertinent in them? Paste them here (surround with three backticks (```) for readability
Logs unobtainable after updater crashed and left the encrypted disk unrecoverable.


(Tyran Mincey) #2

I am having the same problem. My back up data files were not tested and appear to not be restorable. It looks like they should have been back up tto a tar.gz extension and that did not happen. I used a ubuntu 14.4 Installation CD and was able to get into the secured file enough to make a backup. using `tar -zcvf. See this link https://www.cyberciti.biz/faq/how-do-i-compress-a-whole-linux-or-unix-directory/. Otherwise I would not be able to get to any of my data. I plan to do a fresh install of 14.4 and updgrade. Once stable I will try to restore the openemr tarball that I created. I will keep you posted. I put a couple of questions up and I am still waiting for some answers but I think there are a few issues with the Ubuntu upgrade and the openemr backup application. Best to do a backup of the entire openemr directory and maybe someone will figure out how to get it in if I do not. Meanwhile you may be able to a least get to yout data and save it.


(Stephen Waite) #3

instead of running the ubuntu upgrade it’s probably easiest to buy a new server

then you can practice the OpenEMR upgrade with a backup from ubuntu 14 until you are comfortable


(David Martelle) #4

Tyran, Stephen
I have no issues as far as backup goes. I haven’t used the built in backup in several years.
I keep a primary and an offsite backup server in sync via private key encrypted rsync.
I clone the backup’s hdd when I need a test bed.

The problem (and do correct me if wrong) appears to be that no provisions were made for the EOL of 14.4 and now the incompatibility of components of OEMR such as PHP between versions has negatively impacted the ability of long term users (like us) to move OEMR to a newer OS. A new OMER on an EOL OS is less than optimal. Just need a way to get up to date for both the OS and OpenEMR.

I will be eager to assist anyone who steps up to take this on, everything we’ve built since 2011 is riding on this.

I have a test bed that was upgraded using openemr-php5_5.0.0-2_all.deb still on 14.4 under test while working our custom mods into 5.0.0.

Regards,
David


(David Martelle) #5

Oh by the way, I just checked with Canonical and the ESR Support is $750.00 per year (but there is a $2,500.00 cart minimum) so I’m definitely not interested in going that route.


(Stephen Waite) #6

hi @hitechelp, have you thought about purchasing a server as the next step in your migration? Then you could practice the upgrade process with a backup of OpenEMR.


(Tyran Mincey) #7

Okay everyone. I am uo and running again;

  1. I resinstalled my Ubunut 14.4
  2. I used the restore script to restore the openemr backup.
  3. I upgraded Openemr to 5.0,’
  4. I then backed this file up in two separate locations
  5. Foolish me I decided to give the Ubuntu 14.4- 16.4 upgrade and it crashed - clearly there is a bug here when it comes to Openemr as it freeze trying to delete the www directory.
  6. I idid a clean install of 16.4
  7. I ther restored the Openemr 5.0 file.

At first it looked as if the backups had non properly exected. But I noticed when I butn to disks they do not work and I cannot explaint when. Insead I used a eternal hard drive and swapped it back to the surver and just mounted it and the file were all at there. I hopes this helps

T


(David Martelle) #8

Hi @leader,
I already have two new servers, but how will that be of any help if there is no way to migrate OpenEMR 4.2.0 from Ubuntu 14.4 to 16.4 or 18.4? Surely someone else has done this already. Those still on 14.4 will need to get to a current OS before June when the security updates for 14.4 end. Still looking for an answer.


(Stephen Waite) #9

it’s possible to upgrade 4.2.0 to 5.0.1 on ubuntu 18, there’s plenty of guides online for settingup multiple php versions


(David Martelle) #10

That’s good, are there any instructions?


(Stephen Waite) #11

guides above is a link to one, btw, did you try this