anonymous wrote on Wednesday, April 22, 2009:
How to upgrade from 2.9 to 3.0.1 in Windows environment. Any one can please provide documentation.
Is there any change in database layout from 2.9 to 3.x?
Thanks!
bradymiller wrote on Wednesday, April 22, 2009:
hey
The complexity of your upgrade depends on the following answers to these questions:
1. Have you installed php-gacl?
2. Have you installed sql-ledger?
3. Is your OpenEMR administrator username entitled ‘admin’?
-brady
bradymiller wrote on Wednesday, April 22, 2009:
Also,
What’s your PHP and Apache versions (or XAMPP version will suffice)?
-brady
anonymous wrote on Wednesday, April 22, 2009:
Hi Brady,
I installed XAMPP 1.7.1. It has
•Apache HTTPD 2.2.11 + Openssl 0.9.8i
•MySQL 5.1.33
•PHP 5.2.9
•phpMyAdmin 3.1.3.1
Other anwers:
1. Have you installed php-gacl?
Yes
2. Have you installed sql-ledger?
No
3. Is your OpenEMR administrator username entitled ‘admin’?
Yes.
Thanks for your help.
bradymiller wrote on Thursday, April 23, 2009:
hey,
I’m assuming your php-gacl database is separate from your openemr database. If this isn’t the, then let me know adnd don’t follow below instructions.
I’d suggest getting this to work on a test server before using any real data, and backup your data and databases before attempting.
Here are instructions for getting php-gacl to work when upgrading from a <3.0 version to a >3.0 version if php-gacl was previously installed:
1) Move old openemr directory to a backup directory
2) Move new version into your openemr directory
3) Copy openemr/library/sqlconf.php file from old version into the new version
4) Edit openemr/interface/globals.php (set $webserver_root and $web_root to be same as old version)
5) Open up you openemr/library/sqlconf.php file and note the variables for host, login, pass, and dbase variables (I’d suggest writing these on a piece of paper in the order listed). Then place these values (with above ordering) in the corresponding blank variables found in openemr/gacl/gacl.ini.php (host, user, password, name) and openemr/gacl/gacl.class.php (db_host, db_user, db_password, db_name).
6) Place the gacl_ prefix on all tables in your php-gacl database (I put a link to a php hack that will do this at bottom of these instructions)
7) Save your modified php-gacl database to a mysql backup file (use ‘mysqldump’ command)
8) Restore the gacl database backup file into your openemr database (use ‘mysql’ command) (thus you have now combined the gacl and openemr databases)
9) Open openemr/sql_upgrade.php in browser and follow instructions (this will upgrade your sql database)
10) Open openemr/acl_upgrade.php in browser (this will upgrade your gacl)
11) Clean up by dropping your original gacl database
Here’s the link to the custom php hack that will put prefix on your tables:
http://bradymd.com/prefixMod.tar.gz
Unpackage it with 7-zip (it’s free) twice, and you will end up with a php file. Then place on your server and run it through your browser. For ‘Enter New Prefix’ ensure you put ‘gacl’. And again your gonna put your gacl database name for ‘Enter database name:’.
Other useful links that you should read through to help out:
Joe’s instructions for windows upgrading:
http://www.oemr.org/modules/wiwimod/index.php?page=UpgradeWindowsOne
full upgrade in linux which gives good overview of steps:
http://bradymd.com/appliance/update3/
another thread:
https://sourceforge.net/forum/forum.php?thread_id=3117812&forum_id=202505
hope this helps get you started, let us know how it goes.
brady
anonymous wrote on Thursday, April 23, 2009:
Thanks Brady.
anonymous wrote on Wednesday, August 26, 2009:
Brady, it works like a charm. We upgraded without any issues.
With previous version - somehow ENS Health was always complaining that something is missing in the X12 file. With new version it works nice without any issues.
bradymiller wrote on Wednesday, August 26, 2009:
hey,
Just in time to upgrade to 3.1.0:
http://www.oemr.org/modules/wiwimod/index.php?page=UpgradeThreeZeroThreeOneWindows
-brady
bradymiller wrote on Thursday, August 27, 2009:
Figured this would be a good place to continue discussion about upgrading gacl brought up in this message:
https://sourceforge.net/forum/message.php?msg_id=7588742
Riaz,
I’m guessing you’ll need to do something like just step 6-8 in above instructions. To further help out in using the embedded php-gacl, answer the following questions:
1) Your operating system?
2) Do you have a user with the name ‘admin’?
3) Are your phpgacl tables in a separate database or are they in the openemr database?
-brady
rayaz wrote on Friday, August 28, 2009:
Thanks for the interest.
I am using Ubuntu 9.04
Openemr 3.1.0
I have a user name ‘admin’
mysql> show databases;
±-------------------+
| Database |
±-------------------+
| information_schema |
| gacl |
| mysql |
| openemr |
±-------------------+
Now then?
Thank you.
bradymiller wrote on Saturday, August 29, 2009:
hey,
Here’s how to do it (back up both your gacl and openemr sql databases):
1) Place the gacl_ prefix on all tables in your gacl database (I put a link to a php hack that will do this at bottom of these instructions)
2) Save your modified gacl database to a mysql backup file (use ‘mysqldump’ command)
3) Restore the gacl database backup file into your openemr database (use ‘mysql’ command) (thus you have now combined the gacl and openemr databases)
4) Revert openemr/library/acl.inc file to original:
http://openemr.cvs.sourceforge.net/viewvc/openemr/openemr/library/acl.inc?revision=1.27
Here’s the link to the custom php hack that will put prefix on your tables:
http://bradymd.com/prefixMod.tar.gz
Unpackage it and then place on your server and run it through your browser. For ‘Enter New Prefix’ ensure you put ‘gacl’. And again your gonna put your gacl database name for ‘Enter database name:’. Remember to remove this script from your server when you are done.
-brady
bradymiller wrote on Saturday, August 29, 2009:
One more thing,
Also note that your php-gacl tables are not UTF-8 compatible, hence you can’t convert your database to full UTF-8. This likely won’t matter for your (if only gonna user english characters); see here for more details:
http://www.oemr.org/modules/wiwimod/index.php?page=UpgradeUtf
If you want to have UTF-8 compatibility need to do one of two below options:
1) Go back to version 3.0.1 (if you have a back up), merge the gacl tables there, and then go through the upgrade process (this will convert the gacl tables)
2) Don’t merge your old gacl tables. Instead simply install a fresh set of gacl tables into openemr (everything will be default, and a ‘admin’ user will be set up). If you want this option then let me know; It’s very easy.
-brady
bradymiller wrote on Saturday, August 29, 2009:
ohh, there’s also a third simpler option for UTF-8 compatibility:
3) After our merge the tables as described in my first message, run the sql_upgrade.php script and post the output here (should skip over all the stuff you already did and update the gacl tables). Again as stated in 1st message make sure you back up these tables before you start.
-brady
anonymous wrote on Saturday, August 29, 2009:
Thanks Brady. Its work great again!
In http://www.oemr.org/modules/wiwimod/index.php?page=UpgradeThreeZeroThreeOneWindows&back=OpenEmrUpgradeHowtos, please add one more line saying copy "documents" folder and contents from old version to 3.1.0 version.
rayaz wrote on Saturday, August 29, 2009:
Hey there Brady,
Thanks for the multiple options. Option 2 is easiest for me. Could you please explain how to do it.
Thanks again.
bradymiller wrote on Sunday, August 30, 2009:
hey
As before, baclup your database first.
Option 2)
---- Open openemr/gacl/setup.php in web browser
---- Open openemr/acl_setup.php in web browser
---- Revert openemr/library/acl.inc file to original:
http://openemr.cvs.sourceforge.net/viewvc/openemr/openemr/library/acl.inc?revision=1.27
This will clear your current gacl setup (will go to the default setup), butyou can login as the admin user, and then can set up your other users via admin->acl interface.
-brady
rayaz wrote on Sunday, August 30, 2009:
Thanks Brady, that did the trick.
rayaz wrote on Sunday, August 30, 2009:
But now am unable to restore from backups made after the change. I end up with "Error: The phpGACL directory ’ ’ does not start with ‘/’.
Backups made before the change restore perfectly.
Any help?
bradymiller wrote on Sunday, August 30, 2009:
hey,
Did you revert to the original openemr/library/acl.inc page (download below and save in place of your current file)
http://openemr.cvs.sourceforge.net/viewvc/openemr/openemr/library/acl.inc?revision=1.27
If still having error let me know. Then I’ll look at closer for any bugs in the backup/restore scripts.
-brady
rayaz wrote on Monday, August 31, 2009:
I have the error despite reverting to original openemr/library/acl.inc .
Regards.