Gotta change my server

drjccaldwell wrote on Tuesday, June 02, 2009:

We’ve been upgrading OpenEMR since 2.something and putting it on an old CentOS (actually ClarkConnect) server. Now want to install a fresh Ubuntu server edition instead. Want to be able to upgrade OpenEMR with a package tool. Also want the added benefits of the Ubuntu service cycles.

Which version of Ubuntu Server should I use?

Currently running OpenEMR 3.0

Thanks,
Clif

aperezcrespo wrote on Tuesday, June 02, 2009:

I would stick with Server 8.04 LTS, It is maintained until 2013 by Canonical Ltd.  As opposed to 2010 for Server 9.04.

My two cents.
Thanks

bradymiller wrote on Tuesday, June 02, 2009:

Yep,

Agree with Server 8.04 LTS since maintained until 2013.

If you want to use the openemr ubuntu package (to get the upgrade feature), then I’d rec installing the openemr ubuntu package first into ubuntu 8.04 and then merging your openemr into this. Let me know if you want to do this, and I can quickly come up with detailed instructions.

-brady

drjccaldwell wrote on Thursday, June 11, 2009:

Forgive the delay in getting back. Summer Vacation and all…
Thanks for the advice. Any instructions in how to merge my installation into the new would be greatly appreciated. I have some questions concerning the best way to back up prior to merge.

With appreciation,
Clif

bradymiller wrote on Thursday, June 11, 2009:

hey,

quick questions:
How did you upgrade to 3.0 ?
Did your previous version have sql-ledger or php-gacl installed?
In openemr/library/sqlconf.php what is the database name variable?

The best way to back up is via the admin->backup function. This will back up your openemr sql database and your openemr web directory (although this sort of depends on answer to the above questions). Also, you won’t need to actually modify your CentOS stuff, so this can function as a backup also.

Here’s the generic idea of what your gonna do (I can be more specific when I know the answer to the above questions).

1) Install ubuntu Server 8.04 LTS
–Install the ‘Ubuntu/debian OpenEMR Package’ package at http://oemr.org/modules/wiwimod/index.php?page=DownloadPage

2) Drop the ‘openemr’ mysql database in ubuntu

3) Copy and unpackage the file you created in admin->backup to ubuntu.

4) Import your old database from unpackage backup file into ubuntu’s mysql (specifics depend on answer to above questions)

5) Copy over following directories from your unpackaged backup openemr web directory into ubuntu web directory /var/www/openemr:
/documents
/edi
/era
/custom/letter_templates

Again, these are generic and specifics depend on your answers to questions at top of this message.  Once done with this process, you’ll then have the “openemr” ubuntu package installed, which means you can take advantage of ubuntu’s package updating mechanism for a “one click” openemr upgrade for subsequent openemr releases.

-brady

bill22 wrote on Friday, June 12, 2009:

I had been thinking of using clarkconnect for an oemr server.  What drawbacks did you find using clarkconnect?
Thanks,bill