Upgrade from DHIS2 2.19 to DHIS2 2.22

Raminosoa_Rabemanant · 25 March 2016 08:41

Thank you Knut for this valuable information! We are crossing our fingers and hope that DHIS2 2.22 will be set up correctly.

Regards,

Tantely.

This message and its attachments are confidential and solely for the intended recipients. If received in error, please delete them and notify the sender via reply e-mail immediately.

···

On Fri, Mar 25, 2016 at 11:21 AM, Knut Staring knutst@gmail.com wrote:

Hi,
Bob wrote a nice step-by-step here: https://lists.launchpad.net/dhis2-users/msg08793.html

I think the most tricky point may be around the shift in encryption mechanisms for passwords in 2.21, as described in the notes.

With systematic backups in the beginning and along the way, and starting and stopping of Tomcat etc, and checking that things are ok, it may take few hours.

Good luck,

Knut

On Fri, Mar 25, 2016 at 7:26 AM, Raminosoa Rabemanantsoa, Tantely traminosoa@mikolo.org wrote:

Hello everyone,

We are using DHIS2 2.19 and we are planning to upgrade to the 2.22 version. We have been informed about the upgrade script like the one mentioned here https://github.com/dhis2/dhis2-utils/blob/master/resources/sql/upgrade-220.sql
and we would like to ask if there is an upgrade procedure for us to follow in order to keep all the components for the new version (data values, data elements, data sets, indicators…). Do you have some idea on how long this procedure may take?

Regards,

Tantely

This message and its attachments are confidential and solely for the intended recipients. If received in error, please delete them and notify the sender via reply e-mail immediately.

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

–

Raminosoa_Rabemanant · 31 March 2016 08:51

Dear Knut,

In order to launch the SQL script mentionned here (https://github.com/dhis2/dhis2-utils/blob/master/resources/sql/upgrade-220.sql) to run against the database to perform necessary upgrades, could you please mention a tutorial link illustrating about how to run the script? Our postgreSQL database is installed on an Amazon web services with Linux operating system.

Thanks,

Tantely.

This message and its attachments are confidential and solely for the intended recipients. If received in error, please delete them and notify the sender via reply e-mail immediately.

···

On Fri, Mar 25, 2016 at 11:21 AM, Knut Staring knutst@gmail.com wrote:

Hi,
Bob wrote a nice step-by-step here: https://lists.launchpad.net/dhis2-users/msg08793.html

I think the most tricky point may be around the shift in encryption mechanisms for passwords in 2.21, as described in the notes.

With systematic backups in the beginning and along the way, and starting and stopping of Tomcat etc, and checking that things are ok, it may take few hours.

Good luck,

Knut

–

On Fri, Mar 25, 2016 at 7:26 AM, Raminosoa Rabemanantsoa, Tantely traminosoa@mikolo.org wrote:

Hello everyone,

We are using DHIS2 2.19 and we are planning to upgrade to the 2.22 version. We have been informed about the upgrade script like the one mentioned here https://github.com/dhis2/dhis2-utils/blob/master/resources/sql/upgrade-220.sql
and we would like to ask if there is an upgrade procedure for us to follow in order to keep all the components for the new version (data values, data elements, data sets, indicators…). Do you have some idea on how long this procedure may take?

Regards,

Tantely

This message and its attachments are confidential and solely for the intended recipients. If received in error, please delete them and notify the sender via reply e-mail immediately.

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

–

Tantely Raminosoa

Data Officer
Management Sciences for Health

Madagascar-Antananarivo Madagascar

Mobile: 0321180040

Skype: traminosoa

Stronger health systems. Greater health impact.

wget https://github.com/dhis2/dhis2-utils/blob/master/resources/sql/upgrade-220.sql

Knut_Staring · 31 March 2016 17:47

Dear Tantely,

I am travelling so hopefully others can chip in, but a couple of quick pointers for googling below.

Perhaps it would be best if you comment on the parts of Bob’s link that causes difficulty?

Here are the main steps:

You need to log in remotely to your server via ssh.
Then you can download the upgrade script like this:

Then run cat upgrade-220.sql |psql dhis2

···

On Thu, Mar 31, 2016 at 1:51 AM, Raminosoa Rabemanantsoa, Tantely traminosoa@mikolo.org wrote:

Dear Knut,

In order to launch the SQL script mentionned here (https://github.com/dhis2/dhis2-utils/blob/master/resources/sql/upgrade-220.sql) to run against the database to perform necessary upgrades, could you please mention a tutorial link illustrating about how to run the script? Our postgreSQL database is installed on an Amazon web services with Linux operating system.

Thanks,

Tantely.

This message and its attachments are confidential and solely for the intended recipients. If received in error, please delete them and notify the sender via reply e-mail immediately.

–

On Fri, Mar 25, 2016 at 11:21 AM, Knut Staring knutst@gmail.com wrote:

Hi,
Bob wrote a nice step-by-step here: https://lists.launchpad.net/dhis2-users/msg08793.html

I think the most tricky point may be around the shift in encryption mechanisms for passwords in 2.21, as described in the notes.

With systematic backups in the beginning and along the way, and starting and stopping of Tomcat etc, and checking that things are ok, it may take few hours.

Good luck,

Knut

Tantely Raminosoa

Data Officer
Management Sciences for Health

Madagascar-Antananarivo Madagascar

Mobile: 0321180040

Skype: traminosoa

Stronger health systems. Greater health impact.

–

On Fri, Mar 25, 2016 at 7:26 AM, Raminosoa Rabemanantsoa, Tantely traminosoa@mikolo.org wrote:

Hello everyone,

We are using DHIS2 2.19 and we are planning to upgrade to the 2.22 version. We have been informed about the upgrade script like the one mentioned here https://github.com/dhis2/dhis2-utils/blob/master/resources/sql/upgrade-220.sql
and we would like to ask if there is an upgrade procedure for us to follow in order to keep all the components for the new version (data values, data elements, data sets, indicators…). Do you have some idea on how long this procedure may take?

Regards,

Tantely

This message and its attachments are confidential and solely for the intended recipients. If received in error, please delete them and notify the sender via reply e-mail immediately.

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

–

Knut Staring

Dept. of Informatics, University of Oslo

Norway: +4791880522

Skype: knutstar

bobj · 1 April 2016 14:27

There are two ways to apply the upgrade script. First you have to get it the server, for example using wget as Knut mentions. Then you can either do:

cat upgrade-220.sql | psql dhis2

which might seem a bit obscure if you are not familiar with unix pipes. Alternatively:

psql -f upgrade-220.sql dhis2

has the same effect.

Note that this assumes you have the permissions to perform the operation on the database. I don’t know how your database has been setup. But if your user is raminosoa then you might first create yourself superuser rights to the postgres database like:

sudo -u postgres createuser -s raminosoa

If your database is setup on a different machine you would probably have to use a password.

···

On 31 March 2016 at 09:51, Raminosoa Rabemanantsoa, Tantely traminosoa@mikolo.org wrote:

Dear Knut,

In order to launch the SQL script mentionned here (https://github.com/dhis2/dhis2-utils/blob/master/resources/sql/upgrade-220.sql) to run against the database to perform necessary upgrades, could you please mention a tutorial link illustrating about how to run the script? Our postgreSQL database is installed on an Amazon web services with Linux operating system.

Thanks,

Tantely.

This message and its attachments are confidential and solely for the intended recipients. If received in error, please delete them and notify the sender via reply e-mail immediately.

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

On Fri, Mar 25, 2016 at 11:21 AM, Knut Staring knutst@gmail.com wrote:

Hi,
Bob wrote a nice step-by-step here: https://lists.launchpad.net/dhis2-users/msg08793.html

I think the most tricky point may be around the shift in encryption mechanisms for passwords in 2.21, as described in the notes.

With systematic backups in the beginning and along the way, and starting and stopping of Tomcat etc, and checking that things are ok, it may take few hours.

Good luck,

Knut

Tantely Raminosoa

Data Officer
Management Sciences for Health

Madagascar-Antananarivo Madagascar

Mobile: 0321180040

Skype: traminosoa

Stronger health systems. Greater health impact.

–

On Fri, Mar 25, 2016 at 7:26 AM, Raminosoa Rabemanantsoa, Tantely traminosoa@mikolo.org wrote:

Hello everyone,

We are using DHIS2 2.19 and we are planning to upgrade to the 2.22 version. We have been informed about the upgrade script like the one mentioned here https://github.com/dhis2/dhis2-utils/blob/master/resources/sql/upgrade-220.sql
and we would like to ask if there is an upgrade procedure for us to follow in order to keep all the components for the new version (data values, data elements, data sets, indicators…). Do you have some idea on how long this procedure may take?

Regards,

Tantely

This message and its attachments are confidential and solely for the intended recipients. If received in error, please delete them and notify the sender via reply e-mail immediately.

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

–

Raminosoa_Rabemanant · 4 April 2016 03:08

Thank you Bob and Knut for those instructions. I am trying to figure out and will be back to report some news.

Best Regards.

This message and its attachments are confidential and solely for the intended recipients. If received in error, please delete them and notify the sender via reply e-mail immediately.

···

On Fri, Apr 1, 2016 at 5:27 PM, Bob Jolliffe bobjolliffe@gmail.com wrote:

There are two ways to apply the upgrade script. First you have to get it the server, for example using wget as Knut mentions. Then you can either do:

cat upgrade-220.sql | psql dhis2

which might seem a bit obscure if you are not familiar with unix pipes. Alternatively:

psql -f upgrade-220.sql dhis2

has the same effect.

Note that this assumes you have the permissions to perform the operation on the database. I don’t know how your database has been setup. But if your user is raminosoa then you might first create yourself superuser rights to the postgres database like:

sudo -u postgres createuser -s raminosoa

If your database is setup on a different machine you would probably have to use a password.

On 31 March 2016 at 09:51, Raminosoa Rabemanantsoa, Tantely traminosoa@mikolo.org wrote:

Dear Knut,

In order to launch the SQL script mentionned here (https://github.com/dhis2/dhis2-utils/blob/master/resources/sql/upgrade-220.sql) to run against the database to perform necessary upgrades, could you please mention a tutorial link illustrating about how to run the script? Our postgreSQL database is installed on an Amazon web services with Linux operating system.

Thanks,

Tantely.

This message and its attachments are confidential and solely for the intended recipients. If received in error, please delete them and notify the sender via reply e-mail immediately.

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

On Fri, Mar 25, 2016 at 11:21 AM, Knut Staring knutst@gmail.com wrote:

Hi,
Bob wrote a nice step-by-step here: https://lists.launchpad.net/dhis2-users/msg08793.html

I think the most tricky point may be around the shift in encryption mechanisms for passwords in 2.21, as described in the notes.

With systematic backups in the beginning and along the way, and starting and stopping of Tomcat etc, and checking that things are ok, it may take few hours.

Good luck,

Knut

Tantely Raminosoa

Data Officer
Management Sciences for Health

Madagascar-Antananarivo Madagascar

Mobile: 0321180040

Skype: traminosoa

Stronger health systems. Greater health impact.

–

On Fri, Mar 25, 2016 at 7:26 AM, Raminosoa Rabemanantsoa, Tantely traminosoa@mikolo.org wrote:

Hello everyone,

We are using DHIS2 2.19 and we are planning to upgrade to the 2.22 version. We have been informed about the upgrade script like the one mentioned here https://github.com/dhis2/dhis2-utils/blob/master/resources/sql/upgrade-220.sql
and we would like to ask if there is an upgrade procedure for us to follow in order to keep all the components for the new version (data values, data elements, data sets, indicators…). Do you have some idea on how long this procedure may take?

Regards,

Tantely

This message and its attachments are confidential and solely for the intended recipients. If received in error, please delete them and notify the sender via reply e-mail immediately.

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