Upgrade from 3.0 to 4.0 dev

Management and Administration
1

biller wrote on Monday, December 27, 2010:

If someone would be kind enough to help me through this process it would be greatly appreciated.  I have copied over the 4.0 directory files and folders and replaced the /sites/default/sqlconf.php with the original file.  I then ran sql_upgrade.php and acl_upgrade.php.  When I try to log in with the user name and password it tells me that it is incorrect.  If I look at the users using phpmyadmin I can see all the users and garbled passwords.  If you need additional information please let me know.  Thanks in advance for your help.  John

2

visolveemr wrote on Tuesday, December 28, 2010:

Hi,

Have you verified the ‘groups’ table. Check for the username existence in the ‘groups’ table.

Hope this will resolve the login issue.

Thanks
ViCarePlus Team,
www.vicareplus.com
services@vicareplus.com

3

biller wrote on Tuesday, December 28, 2010:

Thank you visolveemr for your suggestion.  I did look and the “groups” table looks up to date.  I did find a way to get it to work.  If I upgrade to 3.2 and then to 4.0 it seems to function.  It appears I just can’t get it to upgrade from 3.0 to 4.0.  If there is a howto somewhere that I’ve missed and you could point me in that direction it would be greatly appreciated.  I did follow the instructions in the install file. 

Thanks again for your help
John

4

visolveemr wrote on Wednesday, December 29, 2010:

Hi,

Hope the following link helps you to upgrade the OpenEMR:
http://www.openmedsoftware.org/wiki/OpenEMR_Upgrade_Guides

Thanks
ViCarePlus Team,
www.vicareplus.com
services@vicareplus.com

5

anonymous wrote on Wednesday, December 29, 2010:

I am using 2.9.0 on Ubuntu and am having a hard time finding instruction on how to upgrade to at least 3.2.0 and hopefully 4.0 eventually

6

bradymiller wrote on Thursday, December 30, 2010:

hey,
Breaking the 3.0 barrier is the most difficult hurdle (rest is easy). To help with upgrade to 3.2.0 from 2.9.0, need answers to following questions:
1. Do you have sql-ledger installed?
2. Do you have php-gacl installed?
3. Do you have an adminstrator user named ‘admin’?

-brady

7

anonymous wrote on Thursday, December 30, 2010:

yes to all of the above

8

bradymiller wrote on Saturday, January 01, 2011:

hi,

Most importantly, do this on a test server first.

For the upgrade above 3.0, to get an idea, see what I did for the appliance here (steps 1-5): http://www.bradymd.com/appliance/update3/

Here’s an instruction set (again, try on a test server first):
1) Move old openemr directory to a backup directory
2) Move new openemr version (3.2.0) into openemr directory
3) Edit openemr/library/sqlconf.php file (set variables to be same as
    previous version, and don’t touch the utf8 flag)
4) Edit openemr/interface/globals.php (set $webserver_root and $web_root
    to be same as old version)
5) Place the gacl_ prefix on all tables in your php-gacl database (I put
     a link to a php hack that will do this below these steps)
6) Save your modified php-gacl database to a mysql backup file (use
    ‘mysqldump’ command)
7) Restore the gacl database backup file into your openemr database (use
    ‘mysql’ command) (thus you have now combined the gacl and openemr databases)
8) Open sql_upgrade.php in browser and follow instructions (this will
    upgrade your sql database)
9) Open openemr/acl_upgrade.php in browser (this will upgrade your gacl)
10) Open openemr/sl_convert.php in browser (this will convert your sql-ledger stuff into OpenEMR)
10) 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.

-brady