bradymiller wrote on Monday, September 21, 2009:
hey,
Did you follow these exact instructions:
1) Move old openemr directory to a backup directory
2) Move new version into openemr directory
3) Copy following directories from old version to new /openemr directory:
/openemr/documents
/openemr/edi
/openemr/era
openemr/custom/letter_templates
4) Edit openemr/interface/globals.php (set $webserver_root and $web_root to be same as old version)
5) Open up your old openemr version openemr/library/sqlconf.php file and transfer the variables to your new openemr version file
6) In the openemr/library/sqlconf.php file in the new version, set the $config variable (found near bottom of file within bunch of slashes) to 1 ($config = 1;).
7) 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 this message)
8) Save your modified php-gacl database to a mysql backup file (use ‘mysqldump’ command)
9) Restore the gacl database backup file into your openemr database (use ‘mysql’ command) (thus you have now combined the gacl and openemr databases)
10) Open sql_upgrade.php in browser and follow instructions (this will upgrade your sql database)
11) Open openemr/acl_upgrade.php in browser (this will upgrade your gacl)
12) Configure optional settings in interface/globals.php and includes/config.php files
Here’s the link to the custom php hack that will put prefix on your tables:
http://bradymd.com/prefixMod.tar.gz
Unpackage, 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 when you are done.
I’d suggest making a testing server to try/retry this until you get it to work. Then when get it working from start to finish, can upgrade your productions versions.
Some things to note in above instructions:
-do the gacl migration before the sql_upgrade.php script. In upgrade from 3.0.1 to 3.1.0 some changes are made to the gacl tables to ensure compatible with UTU-8 (note it doesn’t convert to UTF-8, it just makes it compatible with a conversion if a user chooses to do this at some point)
-
Do not edit any of the gacl config files (in 3.1.0 this is no longer needed; they grab needed stuff from library/sqlconf.php)
-
Ensure before you upgrade that you indeed do have an ‘admin’ user in the php-gacl program (in the older versions, an authorized user in openemr can look the same as a authorized user in php-gacl; you could also get away with not having the user in php-gacl. This is no longer case in 3.0+, which is why you may not be able to log in as admin)
Let me know if still having problems when follow this strict protocol. If you are, would be interesting to confirm that your openemr database does indeed have the gacl tables in it with the gacl_ prefix. There is a way to "break" into gacl if don’t have access by temporarily modifying source code in the gacl, but only rare users whom are installing new gacl tables without an ‘admin’ need to do this.
-brady