dhis2-users team mailing list archive

[Bob Jolliffe <bobjolliffe@xxxxxxxxx>]

Hi Gerald

If you are not doing this over ssh like me, it would probably be best
to do step 1 by popping a 14.04 server cd in the tray (or usb thingy)
and upgrading the OS off that.

Bob

On 9 December 2015 at 19:16, gerald thomas <gerald17006@xxxxxxxxx> wrote:
> Thanks Bob,
> Noted!!! You had been so helpful to me.
>
> Regards,
> Gerald
>
> On Dec 9, 2015 6:06 PM, "Knut Staring" <knutst@xxxxxxxxx> wrote:
>>
>> 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
>>
>> _______________________________________________
>> 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
>>
>