Re: [Dhis2-users] Upgrading from 2.16

2017-08-07 Thread Edward Robinson
You are a lifesaver, thank you!
I would love to buy you that beer / coffee – direct mail sent! 
Cheers!
Ed

From: Em Le Hong [mailto:em.hispviet...@gmail.com]
Sent: Monday, 07 August 2017 8:59 AM
To: Edward Robinson <erobin...@projectbalance.com>
Cc: dhis2-users <dhis2-users@lists.launchpad.net>
Subject: Re: [Dhis2-users] Upgrading from 2.16

Hi,

If you still need the old war files from 2.17 to 2.20, you can get it from the 
link below:

https://drive.google.com/drive/folders/0B-tlJrv190f5Nm9PakE1b2JqTms?usp=sharing

On Thu, Aug 3, 2017 at 7:10 PM, Edward Robinson 
<erobin...@projectbalance.com<mailto:erobin...@projectbalance.com>> wrote:
Excellent, that’s a great help,  Thank you!
If nobody gets back to me on the .wars for 2.17->2.21 then I’ll indeed setup 
the environment and compile though I’d like to avoid that route for time sake.
There’s a coffee or couple of beers (in mBTC) for anyone who can source those 
.wars 

Thanks!

From: Em Le Hong 
[mailto:em.hispviet...@gmail.com<mailto:em.hispviet...@gmail.com>]
Sent: Thursday, 03 August 2017 1:51 PM
To: Edward Robinson 
<erobin...@projectbalance.com<mailto:erobin...@projectbalance.com>>
Cc: dhis2-users 
<dhis2-users@lists.launchpad.net<mailto:dhis2-users@lists.launchpad.net>>
Subject: Re: [Dhis2-users] Upgrading from 2.16

You can read the upgrade notes from the links below:

https://www.dhis2.org/217-upgrade
https://www.dhis2.org/218-upgrade
https://www.dhis2.org/219-upgrade
...

On Thu, Aug 3, 2017 at 6:48 PM, Em Le Hong 
<em.hispviet...@gmail.com<mailto:em.hispviet...@gmail.com>> wrote:
Hi,

Someone was asking similar question recently, I think you can check out the old 
code and build it yourself.

https://code.launchpad.net/dhis2

On Thu, Aug 3, 2017 at 6:43 PM, Edward Robinson 
<erobin...@projectbalance.com<mailto:erobin...@projectbalance.com>> wrote:
I need to upgrade two reasonably large 2.16 instances to at least 2.26 and am 
needing the following:

  *   All .war files from 2.17 up (at least those required for the upgrade)
  *   Instructions specific to each incremental upgrade until 2.26 (if there 
are specific tasks to perform such as running SQL scripts, etc.)

Does this information / these files exist somewhere on the web?
I have googled but can’t find a .war for anything lower than 2.22 in the 
regular places at this point (e.g. 
https://www.dhis2.org/download/releases/2.17/dhis.war)
Can I skip some versions in this incremental update?

Thanks all!

___
Mailing list: https://launchpad.net/~dhis2-users
Post to : 
dhis2-users@lists.launchpad.net<mailto:dhis2-users@lists.launchpad.net>
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp



--
Em Le Hong
DHIS2 Implementation| HISP Vietnam
em.hispviet...@gmail.com<mailto:em.hispviet...@gmail.com> | Skype: 
em.hispviet...@gmail.com<mailto:em.hispviet...@gmail.com>

[https://drive.google.com/uc?id=0B-tlJrv190f5dmR1Y0t2NERvcVU=download]






--
Em Le Hong
DHIS2 Implementation| HISP Vietnam
em.hispviet...@gmail.com<mailto:em.hispviet...@gmail.com> | Skype: 
em.hispviet...@gmail.com<mailto:em.hispviet...@gmail.com>

[https://drive.google.com/uc?id=0B-tlJrv190f5dmR1Y0t2NERvcVU=download]






--
Em Le Hong
DHIS2 Implementation| HISP Vietnam
em.hispviet...@gmail.com<mailto:em.hispviet...@gmail.com> | Skype: 
em.hispviet...@gmail.com<mailto:em.hispviet...@gmail.com>

[https://drive.google.com/uc?id=0B-tlJrv190f5dmR1Y0t2NERvcVU=download]



___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp


Re: [Dhis2-users] Upgrading from 2.16

2017-08-07 Thread Em Le Hong
Hi,

If you still need the old war files from 2.17 to 2.20, you can get it from
the link below:

https://drive.google.com/drive/folders/0B-tlJrv190f5Nm9PakE1b2JqTms?usp=sharing

On Thu, Aug 3, 2017 at 7:10 PM, Edward Robinson <
erobin...@projectbalance.com> wrote:

> Excellent, that’s a great help,  Thank you!
>
> If nobody gets back to me on the .wars for 2.17->2.21 then I’ll indeed
> setup the environment and compile though I’d like to avoid that route for
> time sake.
>
> There’s a coffee or couple of beers (in mBTC) for anyone who can source
> those .wars 
>
>
>
> Thanks!
>
>
>
> *From:* Em Le Hong [mailto:em.hispviet...@gmail.com]
> *Sent:* Thursday, 03 August 2017 1:51 PM
> *To:* Edward Robinson <erobin...@projectbalance.com>
> *Cc:* dhis2-users <dhis2-users@lists.launchpad.net>
> *Subject:* Re: [Dhis2-users] Upgrading from 2.16
>
>
>
> You can read the upgrade notes from the links below:
>
>
>
> https://www.dhis2.org/217-upgrade
>
> https://www.dhis2.org/218-upgrade
>
> https://www.dhis2.org/219-upgrade
>
> ...
>
>
>
> On Thu, Aug 3, 2017 at 6:48 PM, Em Le Hong <em.hispviet...@gmail.com>
> wrote:
>
> Hi,
>
>
>
> Someone was asking similar question recently, I think you can check out
> the old code and build it yourself.
>
>
>
> https://code.launchpad.net/dhis2
>
>
>
> On Thu, Aug 3, 2017 at 6:43 PM, Edward Robinson <
> erobin...@projectbalance.com> wrote:
>
> I need to upgrade two reasonably large 2.16 instances to at least 2.26 and
> am needing the following:
>
>- All .war files from 2.17 up (at least those required for the upgrade)
>- Instructions specific to each incremental upgrade until 2.26 (if
>there are specific tasks to perform such as running SQL scripts, etc.)
>
>
>
> Does this information / these files exist somewhere on the web?
>
> I have googled but can’t find a .war for anything lower than 2.22 in the
> regular places at this point (e.g. https://www.dhis2.org/
> download/releases/2.17/dhis.war)
>
> Can I skip some versions in this incremental update?
>
>
>
> Thanks all!
>
>
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>
>
>
>
> --
>
> *Em Le Hong*
>
> DHIS2 Implementation| *HISP Vietnam *
>
> em.hispviet...@gmail.com | *Skype:* em.hispviet...@gmail.com
>
>
>
>
>
>
>
>
>
>
>
>
>
> --
>
> *Em Le Hong*
>
> DHIS2 Implementation| *HISP Vietnam *
>
> em.hispviet...@gmail.com | *Skype:* em.hispviet...@gmail.com
>
>
>
>
>
>
>
>
>



-- 
*Em Le Hong*
DHIS2 Implementation| *HISP Vietnam *
em.hispviet...@gmail.com | *Skype:* em.hispviet...@gmail.com
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp


Re: [Dhis2-users] Upgrading from 2.16

2017-08-03 Thread Edward Robinson
Excellent, that’s a great help,  Thank you!
If nobody gets back to me on the .wars for 2.17->2.21 then I’ll indeed setup 
the environment and compile though I’d like to avoid that route for time sake.
There’s a coffee or couple of beers (in mBTC) for anyone who can source those 
.wars 

Thanks!

From: Em Le Hong [mailto:em.hispviet...@gmail.com]
Sent: Thursday, 03 August 2017 1:51 PM
To: Edward Robinson <erobin...@projectbalance.com>
Cc: dhis2-users <dhis2-users@lists.launchpad.net>
Subject: Re: [Dhis2-users] Upgrading from 2.16

You can read the upgrade notes from the links below:

https://www.dhis2.org/217-upgrade
https://www.dhis2.org/218-upgrade
https://www.dhis2.org/219-upgrade
...

On Thu, Aug 3, 2017 at 6:48 PM, Em Le Hong 
<em.hispviet...@gmail.com<mailto:em.hispviet...@gmail.com>> wrote:
Hi,

Someone was asking similar question recently, I think you can check out the old 
code and build it yourself.

https://code.launchpad.net/dhis2

On Thu, Aug 3, 2017 at 6:43 PM, Edward Robinson 
<erobin...@projectbalance.com<mailto:erobin...@projectbalance.com>> wrote:
I need to upgrade two reasonably large 2.16 instances to at least 2.26 and am 
needing the following:

  *   All .war files from 2.17 up (at least those required for the upgrade)
  *   Instructions specific to each incremental upgrade until 2.26 (if there 
are specific tasks to perform such as running SQL scripts, etc.)

Does this information / these files exist somewhere on the web?
I have googled but can’t find a .war for anything lower than 2.22 in the 
regular places at this point (e.g. 
https://www.dhis2.org/download/releases/2.17/dhis.war)
Can I skip some versions in this incremental update?

Thanks all!

___
Mailing list: https://launchpad.net/~dhis2-users
Post to : 
dhis2-users@lists.launchpad.net<mailto:dhis2-users@lists.launchpad.net>
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp



--
Em Le Hong
DHIS2 Implementation| HISP Vietnam
em.hispviet...@gmail.com<mailto:em.hispviet...@gmail.com> | Skype: 
em.hispviet...@gmail.com<mailto:em.hispviet...@gmail.com>

[https://drive.google.com/uc?id=0B-tlJrv190f5dmR1Y0t2NERvcVU=download]






--
Em Le Hong
DHIS2 Implementation| HISP Vietnam
em.hispviet...@gmail.com<mailto:em.hispviet...@gmail.com> | Skype: 
em.hispviet...@gmail.com<mailto:em.hispviet...@gmail.com>

[https://drive.google.com/uc?id=0B-tlJrv190f5dmR1Y0t2NERvcVU=download]



___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp


Re: [Dhis2-users] Upgrading from 2.16

2017-08-03 Thread Em Le Hong
You can read the upgrade notes from the links below:

https://www.dhis2.org/217-upgrade
https://www.dhis2.org/218-upgrade
https://www.dhis2.org/219-upgrade
...

On Thu, Aug 3, 2017 at 6:48 PM, Em Le Hong  wrote:

> Hi,
>
> Someone was asking similar question recently, I think you can check out
> the old code and build it yourself.
>
> https://code.launchpad.net/dhis2
>
> On Thu, Aug 3, 2017 at 6:43 PM, Edward Robinson <
> erobin...@projectbalance.com> wrote:
>
>> I need to upgrade two reasonably large 2.16 instances to at least 2.26
>> and am needing the following:
>>
>>- All .war files from 2.17 up (at least those required for the
>>upgrade)
>>- Instructions specific to each incremental upgrade until 2.26 (if
>>there are specific tasks to perform such as running SQL scripts, etc.)
>>
>>
>>
>> Does this information / these files exist somewhere on the web?
>>
>> I have googled but can’t find a .war for anything lower than 2.22 in the
>> regular places at this point (e.g. https://www.dhis2.org/download
>> /releases/2.17/dhis.war)
>>
>> Can I skip some versions in this incremental update?
>>
>>
>>
>> Thanks all!
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-users
>> Post to : dhis2-users@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>
>
> --
> *Em Le Hong*
> DHIS2 Implementation| *HISP Vietnam *
> em.hispviet...@gmail.com | *Skype:* em.hispviet...@gmail.com
>
>
>
>
>
>


-- 
*Em Le Hong*
DHIS2 Implementation| *HISP Vietnam *
em.hispviet...@gmail.com | *Skype:* em.hispviet...@gmail.com
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp


Re: [Dhis2-users] Upgrading from 2.16

2017-08-03 Thread Em Le Hong
Hi,

Someone was asking similar question recently, I think you can check out the
old code and build it yourself.

https://code.launchpad.net/dhis2

On Thu, Aug 3, 2017 at 6:43 PM, Edward Robinson <
erobin...@projectbalance.com> wrote:

> I need to upgrade two reasonably large 2.16 instances to at least 2.26 and
> am needing the following:
>
>- All .war files from 2.17 up (at least those required for the upgrade)
>- Instructions specific to each incremental upgrade until 2.26 (if
>there are specific tasks to perform such as running SQL scripts, etc.)
>
>
>
> Does this information / these files exist somewhere on the web?
>
> I have googled but can’t find a .war for anything lower than 2.22 in the
> regular places at this point (e.g. https://www.dhis2.org/
> download/releases/2.17/dhis.war)
>
> Can I skip some versions in this incremental update?
>
>
>
> Thanks all!
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>


-- 
*Em Le Hong*
DHIS2 Implementation| *HISP Vietnam *
em.hispviet...@gmail.com | *Skype:* em.hispviet...@gmail.com
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp


Re: [Dhis2-users] Upgrading from 2.16

2017-07-16 Thread Bob Jolliffe
Regarding version you should be aiming for, you should always aim to
be not more than 3 versions back from latest release.  As security
issues arise and get addressed they are usually backported as far as
is practical.  But the developers only guarantee security support for
the last 3 versions.

On 16 July 2017 at 21:38, Edward Robinson <erobin...@projectbalance.com> wrote:
> Some excellent tips, thank you Elmarie.
>
> Regards
>
> Ed
>
>
>
> From: Elmarie Claasen [mailto:elma...@hisp.org]
> Sent: Sunday, 16 July 2017 3:00 PM
> To: Edward Robinson <erobin...@projectbalance.com>
> Cc: DHIS 2 Users list <dhis2-users@lists.launchpad.net>
> Subject: Re: [Dhis2-users] Upgrading from 2.16
>
>
>
> Hi Edward,
>
>
>
> Wow this is quite far back. We upgrading some instances from 2.20 now and
> everything is going fine, provided that you drop SQL views before the
> upgrade. SQL views often hold table updates effected through war upgrades.
> From 2.23 to 2.23 you need to read about changes required to sms config if
> used.
>
>
>
> Read the upgrade documentation for each version, some has scripts which you
> must run, others execute an upgrade routine with first startup of the war
> file.
>
>
>
> We have find issues when not upgrading incrementally and also starting up
> the server after each upgrade, so this is recommended. You may find it
> difficult to find the link to older war files but check the URL for download
> of newer versions and just change the version number in the war accordingly.
>
>
>
> I would take care if any of the implementations are tracker because tracker
> got a major overhaul since then including changes in tables. You will find
> apps like individual records etc chenging to tracker and event capture.
>
>
>
> Through learning some hard lessons we usually upgrade on a test instance
> first and test all existing functionality properly. Also had some issues
> with table or column updates so we download a Sierra Leone database of the
> same version and compare the tables and columns in that instance vs ours
> with a SQL view.
>
>
>
> Good luck
>
>
>
> Elmarie
>
>
>
> On 16 Jul 2017 20:10, "Edward Robinson" <erobin...@projectbalance.com>
> wrote:
>
> I have a couple of 2.16 installations that should probably be brought up to
> date.
>
> What are the major caveats I should be looking out for and what is the
> latest stable DHIS2 version that I should be aiming for?  It’s critical that
> service be maintained for the client, I will run the upgrades on another box
> and validate them before updating live but I wondered if anyone had anything
> specific that comes to mind that I should look out for or be aware prior to
> upgrading.  Do I need to upgrade incrementally?
>
>
>
> Thanks in advance!
>
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>
>
> This message and any attachments are subject to a disclaimer published at
> http://www.hisp.org/policies.html#comms_disclaimer.  Please read the
> disclaimer before opening any attachment or taking any other action in terms
> of this electronic transmission.  If you cannot access the disclaimer,
> kindly send an email to disclai...@hisp.org and a copy will be provided to
> you. By replying to this e-mail or opening any attachment you agree to be
> bound by the provisions of the disclaimer.
>
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>

___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp


Re: [Dhis2-users] Upgrading from 2.16

2017-07-16 Thread Edward Robinson
Some excellent tips, thank you Elmarie.
Regards
Ed

From: Elmarie Claasen [mailto:elma...@hisp.org]
Sent: Sunday, 16 July 2017 3:00 PM
To: Edward Robinson <erobin...@projectbalance.com>
Cc: DHIS 2 Users list <dhis2-users@lists.launchpad.net>
Subject: Re: [Dhis2-users] Upgrading from 2.16

Hi Edward,

Wow this is quite far back. We upgrading some instances from 2.20 now and 
everything is going fine, provided that you drop SQL views before the upgrade. 
SQL views often hold table updates effected through war upgrades. From 2.23 to 
2.23 you need to read about changes required to sms config if used.

Read the upgrade documentation for each version, some has scripts which you 
must run, others execute an upgrade routine with first startup of the war file.

We have find issues when not upgrading incrementally and also starting up the 
server after each upgrade, so this is recommended. You may find it difficult to 
find the link to older war files but check the URL for download of newer 
versions and just change the version number in the war accordingly.

I would take care if any of the implementations are tracker because tracker got 
a major overhaul since then including changes in tables. You will find apps 
like individual records etc chenging to tracker and event capture.

Through learning some hard lessons we usually upgrade on a test instance first 
and test all existing functionality properly. Also had some issues with table 
or column updates so we download a Sierra Leone database of the same version 
and compare the tables and columns in that instance vs ours with a SQL view.

Good luck

Elmarie

On 16 Jul 2017 20:10, "Edward Robinson" 
<erobin...@projectbalance.com<mailto:erobin...@projectbalance.com>> wrote:
I have a couple of 2.16 installations that should probably be brought up to 
date.
What are the major caveats I should be looking out for and what is the latest 
stable DHIS2 version that I should be aiming for?  It’s critical that service 
be maintained for the client, I will run the upgrades on another box and 
validate them before updating live but I wondered if anyone had anything 
specific that comes to mind that I should look out for or be aware prior to 
upgrading.  Do I need to upgrade incrementally?

Thanks in advance!

___
Mailing list: https://launchpad.net/~dhis2-users
Post to : 
dhis2-users@lists.launchpad.net<mailto:dhis2-users@lists.launchpad.net>
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp


This message and any attachments are subject to a disclaimer published at 
http://www.hisp.org/policies.html#comms_disclaimer.  Please read the disclaimer 
before opening any attachment or taking any other action in terms of this 
electronic transmission.  If you cannot access the disclaimer, kindly send an 
email to disclai...@hisp.org<mailto:disclai...@hisp.org> and a copy will be 
provided to you. By replying to this e-mail or opening any attachment you agree 
to be bound by the provisions of the disclaimer.
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp


Re: [Dhis2-users] Upgrading from 2.16

2017-07-16 Thread Elmarie Claasen
Hi Edward,

Wow this is quite far back. We upgrading some instances from 2.20 now and
everything is going fine, provided that you drop SQL views before the
upgrade. SQL views often hold table updates effected through war upgrades.
>From 2.23 to 2.23 you need to read about changes required to sms config if
used.

Read the upgrade documentation for each version, some has scripts which you
must run, others execute an upgrade routine with first startup of the war
file.

We have find issues when not upgrading incrementally and also starting up
the server after each upgrade, so this is recommended. You may find it
difficult to find the link to older war files but check the URL for
download of newer versions and just change the version number in the war
accordingly.

I would take care if any of the implementations are tracker because tracker
got a major overhaul since then including changes in tables. You will find
apps like individual records etc chenging to tracker and event capture.

Through learning some hard lessons we usually upgrade on a test instance
first and test all existing functionality properly. Also had some issues
with table or column updates so we download a Sierra Leone database of the
same version and compare the tables and columns in that instance vs ours
with a SQL view.

Good luck

Elmarie

On 16 Jul 2017 20:10, "Edward Robinson" 
wrote:

> I have a couple of 2.16 installations that should probably be brought up
> to date.
>
> What are the major caveats I should be looking out for and what is the
> latest stable DHIS2 version that I should be aiming for?  It’s critical
> that service be maintained for the client, I will run the upgrades on
> another box and validate them before updating live but I wondered if anyone
> had anything specific that comes to mind that I should look out for or be
> aware prior to upgrading.  Do I need to upgrade incrementally?
>
>
>
> Thanks in advance!
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>

-- 


*This message and any attachments are subject to a disclaimer published at 
http://www.hisp.org/policies.html#comms_disclaimer 
.  Please read the 
disclaimer before opening any attachment or taking any other action in 
terms of this electronic transmission.  If you cannot access the 
disclaimer, kindly send an email to disclai...@hisp.org 
 and a copy will be provided to you. By replying to 
this e-mail or opening any attachment you agree to be bound by the 
provisions of the disclaimer.*
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp


Re: [Dhis2-users] Upgrading from 2.16 to 2.21 (using dhis2-tools)

2016-07-12 Thread Kamugunga Adolphe
Thank you Bob and Knut,
 I got the steps,

Regards,



*Adolphe Kamugunga*
*MIS Technical Advisor*
Mobile: +250 788 740 578
Email:kaa...@gmail.com
Skype: ka.adolphe



On 12 July 2016 at 16:19, Knut Staring  wrote:

> Hi Adolphe, please see Bob's guide below. I think the links still work.
> Note that step 3 is a shell script,  but you can also do this manually.
> Knut
> -- Forwarded message --
> From: "Bob Jolliffe" 
> Date: 9 Dec 2015 5:54 p.m.
> Subject: [Dhis2-users] Upgrading from 2.16 to 2.21 (using dhis2-tools)
> To: "dhis2-users" 
> Cc:
>
> 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@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> More help   : https://help.launchpad.net/ListHelp
>>
>
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp


Re: [Dhis2-users] Upgrading from 2.16 to 2.21 (using dhis2-tools)

2015-12-15 Thread Ese Egerega
Thanks Bob for sharing.

-Ese

On Wed, Dec 9, 2015 at 8:40 PM, gerald thomas  wrote:

> Noted Bob
>
> Regards,
> Gerald
> On Dec 9, 2015 7:29 PM, "Bob Jolliffe"  wrote:
>
>> 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  wrote:
>> > Thanks Bob,
>> > Noted!!! You had been so helpful to me.
>> >
>> > Regards,
>> > Gerald
>> >
>> > On Dec 9, 2015 6:06 PM, "Knut Staring"  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 
>> >> 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@lists.launchpad.net
>> >>> 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: 

Re: [Dhis2-users] Upgrading from 2.16 to 2.21 (using dhis2-tools)

2015-12-09 Thread Knut Staring
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  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@lists.launchpad.net
> 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@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp


Re: [Dhis2-users] Upgrading from 2.16 to 2.21 (using dhis2-tools)

2015-12-09 Thread gerald thomas
Thanks Bob,
Noted!!! You had been so helpful to me.

Regards,
Gerald
On Dec 9, 2015 6:06 PM, "Knut Staring"  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 
> 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@lists.launchpad.net
>> 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@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp


Re: [Dhis2-users] Upgrading from 2.16 to 2.21 (using dhis2-tools)

2015-12-09 Thread Bob Jolliffe
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  wrote:
> Thanks Bob,
> Noted!!! You had been so helpful to me.
>
> Regards,
> Gerald
>
> On Dec 9, 2015 6:06 PM, "Knut Staring"  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 
>> 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@lists.launchpad.net
>>> 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@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> More help   : https://help.launchpad.net/ListHelp
>>
>

___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp