dhis 2.23 upgrade

Hi all,

a few things to be aware of when upgrading to DHIS 2.23 (click on the link below or continue reading this email):

https://www.dhis2.org/223-upgrade

Database

Run the database SQL upgrade script once before updating the WAR file. It only applies if you have set up program rules for your system.

Server

In order to take advantage of the GIS clustering functionality introduced in DHIS 2.23 you must install the PostGIS extender on the server. After installing the extender, PostGIS will be installed in the database automatically when DHIS 2 is started. Please read the installation guide. Basically you can invoke:

sudo apt-get install postgresql-9.4 postgresql-9.4-postgis-2.2 postgresql-contrib-9.4

User Interface

  • The Organisation unit module has been merged into the Maintenance app.

  • The Data elements and Indicators module has been merged into the Maintenance app.

  • The schedule program messages function has been moved from the Program app to the Data administration app under Scheduling.

  • The local SMS modem functionality which could be configured under the Mobile Configuration app has been removed from the system.

regards,

Lars

···

Lars Helge Øverland

Lead developer, DHIS 2

University of Oslo

Skype: larshelgeoverland

http://www.dhis2.org

Hi Lars, thanks guys for remarkable job.

Sorry for jumping to the negative side. I just tried the version 2.23. some functionalities are misbehaving. On my local computer and also I tested the https://play.dhis2.org/

  1. The Pivot table for Aggregated is fun looking, with some Undefined messages

Inline image

  1. Program Indicators including the Functions such as d2:daysBetween or d2:yearsBetween, return the message “No value found” if you run any of Indicators on the program indicators analysis (See the pick below). Also I just created local indicator

Inline image

  1. The pic below is screenshot, showing the Filter of people aged between 5yrs to 17yrs. It works well when you view tracked entity, but it fails to aggregate. Is there anything I am missing?

Inline image

Best regards

Sele

···

On Monday, April 25, 2016 8:17 PM, Lars Helge Øverland lars@dhis2.org wrote:

Hi all,

a few things to be aware of when upgrading to DHIS 2.23 (click on the link below or continue reading this email):

https://www.dhis2.org/223-upgrade

Database

Run the database SQL upgrade script once before updating the WAR file. It only applies if you have set up program rules for your system.

Server

In order to take advantage of the GIS clustering functionality introduced in DHIS 2.23 you must install the PostGIS extender on the server. After installing the extender, PostGIS will be installed in the database automatically when DHIS 2 is started. Please read the installation guide. Basically you can invoke:

sudo apt-get install postgresql-9.4 postgresql-9.4-postgis-2.2 postgresql-contrib-9.4

User Interface

  • The Organisation unit module has been merged into the Maintenance app.

  • The Data elements and Indicators module has been merged into the Maintenance app.

  • The schedule program messages function has been moved from the Program app to the Data administration app under Scheduling.

  • The local SMS modem functionality which could be configured under the Mobile Configuration app has been removed from the system.

regards,

Lars


Lars Helge Øverland

Lead developer, DHIS 2

University of Oslo

Skype: larshelgeoverland

http://www.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

confirming point 1 on demo and snapshot (Firefox 45.0.2 under Windows 7)

Regards, Uwe

···

Seleman Ally <seleman_ally@yahoo.com> hat am 26. April 2016 um 11:09
geschrieben:

Hi Lars, thanks guys for remarkable job.

Sorry for jumping to the negative side. I just tried the version 2.23. some
functionalities are misbehaving. On my local computer and also I tested the
https://play.dhis2.org/

1. The Pivot table for Aggregated is fun looking, with some Undefined messages

2. Program Indicators including the Functions such as d2:daysBetween or
d2:yearsBetween, return the message "No value found" if you run any of
Indicators on the program indicators analysis (See the pick below). Also I
just created local indicator

3. The pic below is screenshot, showing the Filter of people aged between 5yrs
to 17yrs. It works well when you view tracked entity, but it fails to
aggregate. Is there anything I am missing?

Best regards
Sele

    On Monday, April 25, 2016 8:17 PM, Lars Helge Øverland <lars@dhis2.org> > wrote:

Hi all,
a few things to be aware of when upgrading to DHIS 2.23 (click on the link
below or continue reading this email):
https://www.dhis2.org/223-upgrade

Database
Run the database SQL upgrade script once before updating the WAR file. It only
applies if you have set up program rules for your system.

Server
In order to take advantage of the GIS clustering functionality introduced in
DHIS 2.23 you must install the PostGIS extender on the server. After
installing the extender, PostGIS will be installed in the database
automatically when DHIS 2 is started. Please read the installation guide.
Basically you can invoke:sudo apt-get install postgresql-9.4
postgresql-9.4-postgis-2.2 postgresql-contrib-9.4User Interface
   
   - The Organisation unit module has been merged into the Maintenance app.
   
   - The Data elements and Indicators module has been merged into the
Maintenance app.
   
   - The schedule program messages function has been moved from the Program
app to the Data administration app under Scheduling.
   
   - The local SMS modem functionality which could be configured under the
Mobile Configuration app has been removed from the system.

regards,
Lars

--
Lars Helge Øverland
Lead developer, DHIS 2University of OsloSkype: larshelgeoverland
http://www.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

Hi Lars

I know that a lot of production servers are running postgres 9.3
(default with ubuntu 14.04).

The instructions assume postgres 9.4 is used. I know they could
upgrade, but I wonder has anybody tested the gis extensions with 9.3?

Regards
Bob

···

On 25 April 2016 at 18:38, Lars Helge Øverland <lars@dhis2.org> wrote:

Hi all,

a few things to be aware of when upgrading to DHIS 2.23 (click on the link
below or continue reading this email):

https://www.dhis2.org/223-upgrade

Database

Run the database SQL upgrade script once before updating the WAR file. It
only applies if you have set up program rules for your system.

Server

In order to take advantage of the GIS clustering functionality introduced in
DHIS 2.23 you must install the PostGIS extender on the server. After
installing the extender, PostGIS will be installed in the database
automatically when DHIS 2 is started. Please read the installation guide.
Basically you can invoke:

sudo apt-get install postgresql-9.4 postgresql-9.4-postgis-2.2
postgresql-contrib-9.4

User Interface

The Organisation unit module has been merged into the Maintenance app.

The Data elements and Indicators module has been merged into the Maintenance
app.

The schedule program messages function has been moved from the Program app
to the Data administration app under Scheduling.

The local SMS modem functionality which could be configured under the Mobile
Configuration app has been removed from the system.

regards,

Lars

--
Lars Helge Øverland
Lead developer, DHIS 2
University of Oslo
Skype: larshelgeoverland
http://www.dhis2.org

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

Hi Bob,

I have not tested all combinations of postgresql and postgis versions.

However, according to the docs, PostGIS 2.2 works against PostgreSQL 9.1 and later:

http://postgis.net/docs/manual-2.2/postgis_installation.html#install_requirements

We have of course tested DHIS 2 against PostGIS 2.2, so this should be safe.

Lars

···

On Tue, Apr 26, 2016 at 11:35 AM, Bob Jolliffe bobjolliffe@gmail.com wrote:

Hi Lars

I know that a lot of production servers are running postgres 9.3

(default with ubuntu 14.04).

The instructions assume postgres 9.4 is used. I know they could

upgrade, but I wonder has anybody tested the gis extensions with 9.3?

Regards

Bob

On 25 April 2016 at 18:38, Lars Helge Øverland lars@dhis2.org wrote:

Hi all,

a few things to be aware of when upgrading to DHIS 2.23 (click on the link

below or continue reading this email):

https://www.dhis2.org/223-upgrade

Database

Run the database SQL upgrade script once before updating the WAR file. It

only applies if you have set up program rules for your system.

Server

In order to take advantage of the GIS clustering functionality introduced in

DHIS 2.23 you must install the PostGIS extender on the server. After

installing the extender, PostGIS will be installed in the database

automatically when DHIS 2 is started. Please read the installation guide.

Basically you can invoke:

sudo apt-get install postgresql-9.4 postgresql-9.4-postgis-2.2

postgresql-contrib-9.4

User Interface

The Organisation unit module has been merged into the Maintenance app.

The Data elements and Indicators module has been merged into the Maintenance

app.

The schedule program messages function has been moved from the Program app

to the Data administration app under Scheduling.

The local SMS modem functionality which could be configured under the Mobile

Configuration app has been removed from the system.

regards,

Lars

Lars Helge Øverland

Lead developer, DHIS 2

University of Oslo

Skype: larshelgeoverland

http://www.dhis2.org


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

Lars Helge Øverland

Lead developer, DHIS 2

University of Oslo

Skype: larshelgeoverland

http://www.dhis2.org

Exactly. Database upgrade is a bit of a task to be planned for. There is also the all the db user accounts and the like. Sometimes it is easier to just update the whole cluster than individually exporting and importing databases. All of which is why I was hoping folk with 9.3 would be able to enjoy the new functionality without going through this first - it looks like they should be able to.

···

On 26 April 2016 at 20:34, Dan Cocos dcocos@gmail.com wrote:

Hi All,

Admins should also be careful because Postgres doesn’t automatically update between versions, you usually have to export, drop then import into the new version and postgres 9.4 won’t start if there is a 9.3 database still around.

Dan

Dan Cocos
Principal, BAO Systems

+1 202-352-2671 | dcocos@baosystems.com | http://www.baosystems.com | 2900 K Street, Suite 404, Washington D.C. 20007

On Apr 26, 2016, at 7:21 AM, Lars Helge Øverland lars@dhis2.org wrote:

Hi Bob,

I have not tested all combinations of postgresql and postgis versions.

However, according to the docs, PostGIS 2.2 works against PostgreSQL 9.1 and later:

http://postgis.net/docs/manual-2.2/postgis_installation.html#install_requirements

We have of course tested DHIS 2 against PostGIS 2.2, so this should be safe.

Lars


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

On Tue, Apr 26, 2016 at 11:35 AM, Bob Jolliffe bobjolliffe@gmail.com wrote:

Hi Lars

I know that a lot of production servers are running postgres 9.3
(default with ubuntu 14.04).

The instructions assume postgres 9.4 is used. I know they could
upgrade, but I wonder has anybody tested the gis extensions with 9.3?

Regards
Bob

On 25 April 2016 at 18:38, Lars Helge Øverland lars@dhis2.org wrote:

Hi all,

a few things to be aware of when upgrading to DHIS 2.23 (click on the link
below or continue reading this email):

https://www.dhis2.org/223-upgrade

Database

Run the database SQL upgrade script once before updating the WAR file. It
only applies if you have set up program rules for your system.

Server

In order to take advantage of the GIS clustering functionality introduced in
DHIS 2.23 you must install the PostGIS extender on the server. After
installing the extender, PostGIS will be installed in the database
automatically when DHIS 2 is started. Please read the installation guide.
Basically you can invoke:

sudo apt-get install postgresql-9.4 postgresql-9.4-postgis-2.2
postgresql-contrib-9.4

User Interface

The Organisation unit module has been merged into the Maintenance app.

The Data elements and Indicators module has been merged into the Maintenance
app.

The schedule program messages function has been moved from the Program app
to the Data administration app under Scheduling.

The local SMS modem functionality which could be configured under the Mobile
Configuration app has been removed from the system.

regards,

Lars


Lars Helge Øverland
Lead developer, DHIS 2
University of Oslo
Skype: larshelgeoverland
http://www.dhis2.org


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


Lars Helge Øverland

Lead developer, DHIS 2

University of Oslo

Skype: larshelgeoverland

http://www.dhis2.org

Hi Lars, Bob and Everybody

I wonder if there is anyone installed postgis-2.2 on postgresql-9.3. If so, could you share the best practice instructions.

Best Regards

Sele

Hi Bob,

I have not tested all combinations of postgresql and postgis versions.

However, according to the docs, PostGIS 2.2 works against PostgreSQL 9.1 and later:

http://postgis.net/docs/manual-2.2/postgis_installation.html#install_requirements

We have of course tested DHIS 2 against PostGIS 2.2, so this should be safe.

Lars

···

On Tuesday, April 26, 2016 2:22 PM, Lars Helge Øverland lars@dhis2.org wrote:

On Tue, Apr 26, 2016 at 11:35 AM, Bob Jolliffe bobjolliffe@gmail.com wrote:

Hi Lars

I know that a lot of production servers are running postgres 9.3

(default with ubuntu 14.04).

The instructions assume postgres 9.4 is used. I know they could

upgrade, but I wonder has anybody tested the gis extensions with 9.3?

Regards

Bob

On 25 April 2016 at 18:38, Lars Helge Øverland lars@dhis2.org wrote:

Hi all,

a few things to be aware of when upgrading to DHIS 2.23 (click on the link

below or continue reading this email):

https://www.dhis2.org/223-upgrade

Database

Run the database SQL upgrade script once before updating the WAR file. It

only applies if you have set up program rules for your system.

Server

In order to take advantage of the GIS clustering functionality introduced in

DHIS 2.23 you must install the PostGIS extender on the server. After

installing the extender, PostGIS will be installed in the database

automatically when DHIS 2 is started. Please read the installation guide.

Basically you can invoke:

sudo apt-get install postgresql-9.4 postgresql-9.4-postgis-2.2

postgresql-contrib-9.4

User Interface

The Organisation unit module has been merged into the Maintenance app.

The Data elements and Indicators module has been merged into the Maintenance

app.

The schedule program messages function has been moved from the Program app

to the Data administration app under Scheduling.

The local SMS modem functionality which could be configured under the Mobile

Configuration app has been removed from the system.

regards,

Lars

Lars Helge Øverland

Lead developer, DHIS 2

University of Oslo

Skype: larshelgeoverland

http://www.dhis2.org


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp


Lars Helge Øverland

Lead developer, DHIS 2

University of Oslo

Skype: larshelgeoverland

http://www.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

Hi Sele,

did you try running installing from the repositories like this?

sudo apt-get install postgis-2.2 postgresql-contrib-9.3
···

On Mon, May 2, 2016 at 1:03 PM, Seleman Ally seleman_ally@yahoo.com wrote:

Hi Lars, Bob and Everybody

I wonder if there is anyone installed postgis-2.2 on postgresql-9.3. If so, could you share the best practice instructions.

Best Regards

Sele

On Tuesday, April 26, 2016 2:22 PM, Lars Helge Øverland lars@dhis2.org wrote:

Hi Bob,

I have not tested all combinations of postgresql and postgis versions.

However, according to the docs, PostGIS 2.2 works against PostgreSQL 9.1 and later:

http://postgis.net/docs/manual-2.2/postgis_installation.html#install_requirements

We have of course tested DHIS 2 against PostGIS 2.2, so this should be safe.

Lars

On Tue, Apr 26, 2016 at 11:35 AM, Bob Jolliffe bobjolliffe@gmail.com wrote:

Hi Lars

I know that a lot of production servers are running postgres 9.3

(default with ubuntu 14.04).

The instructions assume postgres 9.4 is used. I know they could

upgrade, but I wonder has anybody tested the gis extensions with 9.3?

Regards

Bob

On 25 April 2016 at 18:38, Lars Helge Øverland lars@dhis2.org wrote:

Hi all,

a few things to be aware of when upgrading to DHIS 2.23 (click on the link

below or continue reading this email):

https://www.dhis2.org/223-upgrade

Database

Run the database SQL upgrade script once before updating the WAR file. It

only applies if you have set up program rules for your system.

Server

In order to take advantage of the GIS clustering functionality introduced in

DHIS 2.23 you must install the PostGIS extender on the server. After

installing the extender, PostGIS will be installed in the database

automatically when DHIS 2 is started. Please read the installation guide.

Basically you can invoke:

sudo apt-get install postgresql-9.4 postgresql-9.4-postgis-2.2

postgresql-contrib-9.4

User Interface

The Organisation unit module has been merged into the Maintenance app.

The Data elements and Indicators module has been merged into the Maintenance

app.

The schedule program messages function has been moved from the Program app

to the Data administration app under Scheduling.

The local SMS modem functionality which could be configured under the Mobile

Configuration app has been removed from the system.

regards,

Lars

Lars Helge Øverland

Lead developer, DHIS 2

University of Oslo

Skype: larshelgeoverland

http://www.dhis2.org


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp


Lars Helge Øverland

Lead developer, DHIS 2

University of Oslo

Skype: larshelgeoverland

http://www.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

Lars Helge Øverland

Lead developer, DHIS 2

University of Oslo

Skype: larshelgeoverland

http://www.dhis2.org

Thanks Lars

I tried the command above, it looks like it can’t find the package. Below is the message

“Reading state information… Done
E: Unable to locate package postgis-2.2
E: Couldn’t find any package by regex ‘postgis-2.2’”

Do you think, we need to add Repository to sources.list?

Best Regards

Sele

Hi Sele,

did you try running installing from the repositories like this?

sudo apt-get install postgis-2.2 postgresql-contrib-9.3
···

On Monday, May 2, 2016 2:49 PM, Lars Helge Øverland lars@dhis2.org wrote:

On Mon, May 2, 2016 at 1:03 PM, Seleman Ally seleman_ally@yahoo.com wrote:

Hi Lars, Bob and Everybody

I wonder if there is anyone installed postgis-2.2 on postgresql-9.3. If so, could you share the best practice instructions.

Best Regards

Sele

On Tuesday, April 26, 2016 2:22 PM, Lars Helge Øverland lars@dhis2.org wrote:

Hi Bob,

I have not tested all combinations of postgresql and postgis versions.

However, according to the docs, PostGIS 2.2 works against PostgreSQL 9.1 and later:

http://postgis.net/docs/manual-2.2/postgis_installation.html#install_requirements

We have of course tested DHIS 2 against PostGIS 2.2, so this should be safe.

Lars

On Tue, Apr 26, 2016 at 11:35 AM, Bob Jolliffe bobjolliffe@gmail.com wrote:

Hi Lars

I know that a lot of production servers are running postgres 9.3

(default with ubuntu 14.04).

The instructions assume postgres 9.4 is used. I know they could

upgrade, but I wonder has anybody tested the gis extensions with 9.3?

Regards

Bob

On 25 April 2016 at 18:38, Lars Helge Øverland lars@dhis2.org wrote:

Hi all,

a few things to be aware of when upgrading to DHIS 2.23 (click on the link

below or continue reading this email):

https://www.dhis2.org/223-upgrade

Database

Run the database SQL upgrade script once before updating the WAR file. It

only applies if you have set up program rules for your system.

Server

In order to take advantage of the GIS clustering functionality introduced in

DHIS 2.23 you must install the PostGIS extender on the server. After

installing the extender, PostGIS will be installed in the database

automatically when DHIS 2 is started. Please read the installation guide.

Basically you can invoke:

sudo apt-get install postgresql-9.4 postgresql-9.4-postgis-2.2

postgresql-contrib-9.4

User Interface

The Organisation unit module has been merged into the Maintenance app.

The Data elements and Indicators module has been merged into the Maintenance

app.

The schedule program messages function has been moved from the Program app

to the Data administration app under Scheduling.

The local SMS modem functionality which could be configured under the Mobile

Configuration app has been removed from the system.

regards,

Lars

Lars Helge Øverland

Lead developer, DHIS 2

University of Oslo

Skype: larshelgeoverland

http://www.dhis2.org


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp


Lars Helge Øverland

Lead developer, DHIS 2

University of Oslo

Skype: larshelgeoverland

http://www.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


Lars Helge Øverland

Lead developer, DHIS 2

University of Oslo

Skype: larshelgeoverland

http://www.dhis2.org