dhis2-users team mailing list archive

[Knut Staring <knutst@xxxxxxxxx>]

Thanks Bob,

This is very helpful, and should be part of the documentation.

Should have thought of the need for Step 7 when I was upgrading recently,
would have saved me a ton of headache

Knut

On Wed, Dec 9, 2015 at 5:54 PM, Bob Jolliffe <bobjolliffe@xxxxxxxxx> wrote:

> I know questions about this comes up now and again.  I just finished
> doing exactly this for a regional server today so I list my steps here
> for those planning a similar process.
>
> Starting state was a server running ubuntu 12.04, openjdk 7 and dhis2 2.16.
>
> Database backup was made and a copy kept off the server.
>
> 1.  Upgrade the OS to 14.04.  This is the longest (and scariest) step
> - a big upgrade to do over the internet.  But the recommended
> procedure (running 'sudo do-release-upgrade') worked fine.  Took a few
> hours.  Ubuntu creates an emergency ssh backdoor on port 1022 while
> this is going on, but fortunately I didn't have to use it.  But we did
> have ufw firewall running so I took the precaution of opening that
> port just in case (sudo ufw allow 1022).
>
> 2.  Install oracle java 8 :
>
> sudo apt-get install software-properties-common
> sudo add-apt-repository ppa:webupd8team/java
> sudo apt-get update
> sudo apt-get install oracle-java8-installer
> sudo update-java-alternatives -s java-8-oracle
>
> 3.  Download all the upgrade scripts and war files
> for ver in 17 18 19 20 21;
> do
>    wget -O dhis-2.$ver.war
> https://www.dhis2.org/download/releases/2.$ver/dhis.war;
>    wget
> https://raw.githubusercontent.com/dhis2/dhis2-utils/master/resources/sql/upgrade-2$ver.sql
> done
>
> 4.  Read carefully all the upgrade notes at:
> https://www.dhis2.org/217-upgrade
> https://www.dhis2.org/218-upgrade
> https://www.dhis2.org/219-upgrade
> https://www.dhis2.org/220-upgrade
> https://www.dhis2.org/221-upgrade
>
> 5.  shutdown nginx with
> sudo service nginx stop
>
> 6.  start deploying war files and checking logs as we go.  Apply
> upgrade scripts as necessary
>
> dhis2-deploy-war -f dhis-2.17.war dhis2; tail -f
> /var/lib/dhis2/dhis2/logs/catalina.out
>
> dhis2-deploy-war -f dhis-2.18.war dhis2; tail -f
> /var/lib/dhis2/dhis2/logs/catalina.out
>
> cat upgrade-219.sql |psql dhis2
> dhis2-deploy-war -f dhis-2.19.war dhis2; tail -f
> /var/lib/dhis2/dhis2/logs/catalina.out
>
> cat upgrade-220.sql |psql dhis2
> dhis2-deploy-war -f dhis-2.12.war dhis2; tail -f
> /var/lib/dhis2/dhis2/logs/catalina.out
>
> 7.  clear nginx cache and restart
> sudo -s
> rm /var/cache/nginx/*
> exit
> sudo service nginx start
>
> That's about it.  So far everything seems ok.  We just hope there are
> not problems from messy metadata.  Probably it is a better I idea to
> do integrity checks on the metadata right at the very start (I
> forgot).
>
> Note I am holding back on 2.21 upgrade because of the issue with md5
> passwords mentioned in the upgrade notes.   I'll give the users a day
> or two to make sure they have tested their logins.  Will take 5
> minutes to do when the time comes.
>
> Note that the OS upgrade is necessary to get the right tomcat version
> through the package system.  We could have avoided by doing a custom
> tomcat install, but I prefer to stick with the packages.
>
> Hope the above helps anyone else faced with this challenge.
>
> Bob
>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-users
> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>



-- 
Knut Staring
Dept. of Informatics, University of Oslo
Norway: +4791880522
Skype: knutstar
http://dhis2.org