date:20160319

hi all,
do you hav any experience with postgresql database?
i use command psql/pg_restore into new system. i got out of memory.
my system server is 4GB memory and file backup size is around 100MB
___
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] Migrated from v2.15 to v2.22 - completeDataSetRegistrations.json no longer working

Hi Ryan,

Do these data have dimensional breakdowns/disaggregations? I am thinking
you could possibly have a double "default" categoryoptioncombo after
upgrading (or something similar).

Knut

On Fri, Mar 18, 2016 at 11:10 AM, WILLIAMS, Ryan O'Neil <
williamsr...@who.int> wrote:

> Dear all,
>
>
>
> The following api call was working fine in v2.15, it produced a dataset
> completion listing for the selected root org unit and selected period.
>
>
>
> http://.../api/*completeDataSetRegistrations*
> .json?dataSet=FoeRJtqaHVd=kL43warJd3F=fEOswPWAZzz=nB1uyplEoHE=vZy3KF8FQdA=LuReWzkAXRf=2014-01-01=2015-01-01=Hs0PQkZwh54=true
>
>
>
> After migration, the same call produces the error message below. Anyone
> has any ideas or can steer me in the right direction on sorting this out, I
> would greatly appreciate it.
>
> Our DHIS2 instance is running on a mySQL backend.
>
>
>
> *ERROR MESSAGE:*
>
> HTTP Status 500 - No row with the given identifier exists:
> [org.hisp.dhis.dataelement.DataElementCategoryOptionCombo#0] (through
> reference chain:
> org.hisp.dhis.dataset.CompleteDataSetRegistrations["completeDataSetRegistrations"]->java.util.ArrayList[0]->org.hisp.dhis.dataset.CompleteDataSetRegistration["attributeOptionCombo"]->org.hisp.dhis.dataelement.DataElementCategoryOptionCombo_$$_jvst512_50["href"])
>
> *type* Exception report
>
> *message* *No row with the given identifier exists:
> [org.hisp.dhis.dataelement.DataElementCategoryOptionCombo#0] (through
> reference chain:
> org.hisp.dhis.dataset.CompleteDataSetRegistrations["completeDataSetRegistrations"]->java.util.ArrayList[0]->org.hisp.dhis.dataset.CompleteDataSetRegistration["attributeOptionCombo"]->org.hisp.dhis.dataelement.DataElementCategoryOptionCombo_$$_jvst512_50["href"])*
>
> *description* *The server encountered an internal error that prevented it
> from fulfilling this request.*
>
> *exception*
>
> com.fasterxml.jackson.databind.JsonMappingException: No row with the given
> identifier exists:
> [org.hisp.dhis.dataelement.DataElementCategoryOptionCombo#0] (through
> reference chain:
> org.hisp.dhis.dataset.CompleteDataSetRegistrations["completeDataSetRegistrations"]->java.util.ArrayList[0]->org.hisp.dhis.dataset.CompleteDataSetRegistration["attributeOptionCombo"]->org.hisp.dhis.dataelement.DataElementCategoryOptionCombo_$$_jvst512_50["href"])
>
>
> com.fasterxml.jackson.databind.JsonMappingException.wrapWithPath(JsonMappingException.java:210)
>
>
> com.fasterxml.jackson.databind.JsonMappingException.wrapWithPath(JsonMappingException.java:177)
>
>
> com.fasterxml.jackson.databind.ser.std.StdSerializer.wrapAndThrow(StdSerializer.java:199)
>
>
> com.fasterxml.jackson.databind.ser.std.BeanSerializerBase.serializeFields(BeanSerializerBase.java:683)
>
>
> com.fasterxml.jackson.databind.ser.BeanSerializer.serialize(BeanSerializer.java:157)
>
>
> com.fasterxml.jackson.databind.ser.BeanPropertyWriter.serializeAsField(BeanPropertyWriter.java:693)
>
>
> com.fasterxml.jackson.databind.ser.std.BeanSerializerBase.serializeFields(BeanSerializerBase.java:675)
>
>
> com.fasterxml.jackson.databind.ser.BeanSerializer.serialize(BeanSerializer.java:157)
>
>
> com.fasterxml.jackson.databind.ser.impl.IndexedListSerializer.serializeContents(IndexedListSerializer.java:119)
>
>
> com.fasterxml.jackson.databind.ser.impl.IndexedListSerializer.serialize(IndexedListSerializer.java:79)
>
>
> com.fasterxml.jackson.databind.ser.impl.IndexedListSerializer.serialize(IndexedListSerializer.java:18)
>
>
> com.fasterxml.jackson.databind.ser.BeanPropertyWriter.serializeAsField(BeanPropertyWriter.java:693)
>
>
> com.fasterxml.jackson.databind.ser.std.BeanSerializerBase.serializeFields(BeanSerializerBase.java:675)
>
>
> com.fasterxml.jackson.databind.ser.BeanSerializer.serialize(BeanSerializer.java:157)
>
>
> com.fasterxml.jackson.databind.ser.DefaultSerializerProvider.serializeValue(DefaultSerializerProvider.java:130)
>
>
> com.fasterxml.jackson.databind.ObjectMapper._configAndWriteValue(ObjectMapper.java:3559)
>
>
> com.fasterxml.jackson.databind.ObjectMapper.writeValue(ObjectMapper.java:2893)
>
>
> org.hisp.dhis.dxf2.render.DefaultRenderService.toJson(DefaultRenderService.java:70)
>
>
> org.hisp.dhis.webapi.controller.CompleteDataSetRegistrationController.getCompleteDataSetRegistrationsJson(CompleteDataSetRegistrationController.java:122)
>
> sun.reflect.GeneratedMethodAccessor1018.invoke(Unknown Source)
>
>
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
>
> java.lang.reflect.Method.invoke(Method.java:498)
>
>
> org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:222)
>
>
> org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:137)
>
>
> org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:110)
>
>
>

Re: [Dhis2-users] [Dhis2-devs] Financial Year setting

Support for this is planned for the next release, I think:
https://blueprints.launchpad.net/dhis2/+spec/configurable-financial-year-relative-period

Knut

On Thu, Mar 17, 2016 at 12:10 PM, Mugeni Harold  wrote:

> Hi guys,
>
>
>
> I am looking at some graphs in visualizer and whenever I use the period
> ‘last 5 financial years’, it uses the October to September financial year.
> Is there a setting in dhis2 for determining the organization’s financial
> year? If yes, where is it?
>
>
>
> Cheers,
>
> Harold
>
>
>
> ___
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to : dhis2-d...@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-devs
> 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] Load-balancing DHIS2 Webservers

2016-03-19 Thread Jason Phillips

Valid points, Bob, from the sounds of it.

I appreciate the brief catchup – very much.

I shall urgently investigate!

Kind Regards,

*Jason Phillips*

[image: hisp]
*Information Systems / Infrastructure*

*Health Information Systems Program*

eMail: ja...@hisp.org
Tel/Fax:+27 21 712 0170
Cell: +27 72 973 7250
Skype: jason.n.phillips

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.

*From:* Bob Jolliffe [mailto:bobjolli...@gmail.com]
*Sent:* Wednesday, 16 March 2016 4:43 PM
*To:* Jason Phillips
*Cc:* Lars Helge Øverland; DHIS 2 Users list
*Subject:* Re: [Dhis2-users] Load-balancing DHIS2 Webservers

Jason,

Put simply, when users interact with the application they deal with
information from the underlying database. But the dhis2 java application
doesn't keep going backwards and forwards to the database for everything
all the time. To be efficient it also maintains a cached copy of what is
in the database. So at any given moment in time what is seen by the
application may not be exactly what is in the database. This is not a
problem when there is only one dhis2 instance as differences get resolved,
cache is flushed to database, refreshed from database etc.

But with more than one dhis2 instance feeding off the same database they
can (and inevitably) will develop inconsistent views. Which might have
some disastrous result. So something else needs to be configured to ensure
these multiple cache's remain consistent.

One way to do that is to use distributed caching as described here (
http://www.ehcache.org/documentation/2.8/get-started/cache-topologies.html#distributed-caching)
- though that does seem to require an additional non-open source
component. There might be other approaches as well.

I don't really have experience of doing this, just pointing out that I
think you need a strategy to address it in order to do the sort of load
scaling you talk about.

Bob

On 16 March 2016 at 15:13, Jason Phillips wrote:

Hibernate cache...?

I’m sorry, I don’t speak Norwegian. The what, now?

I’ll Google when I get a chance, but for now, have no idea what you’re
talking about… J

It does sound important, though…

Kind Regards,

*Jason Phillips*

[image: hisp]
*Information Systems / Infrastructure*

*Health Information Systems Program*

eMail: ja...@hisp.org
Tel/Fax:+27 21 712 0170
Cell: +27 72 973 7250
Skype: jason.n.phillips

*From:* Bob Jolliffe [mailto:bobjolli...@gmail.com]
*Sent:* Wednesday, 16 March 2016 2:24 PM
*To:* Lars Helge Øverland
*Cc:* Jason Phillips; DHIS 2 Users list
*Subject:* Re: [Dhis2-users] Load-balancing DHIS2 Webservers

I have not done this, but I imagine that hibernate cache replication
between instances is something that really needs to be done to have this
sort of scaling configuration work.

I do remember there was a brief flirtation with hazelcast before reverting
to ehcache. Is anybody using ehcache in this way ie. for replication in a
clustering setup?

On 16 March 2016 at 12:22, Lars Helge Øverland wrote:

Hi Jason,

there is the concept of "sticky sessions" which should ensure that a user
is always sent to the same server throughout his session:

https://www.nginx.com/products/session-persistence/

http://nginx.org/en/docs/http/load_balancing.html

There are other issues with load balancing (session persistence in case a
server goes down, hibernate cache replication) but this could help.

regards,

Lars

On Tue, Mar 15, 2016 at 8:20 PM, Jason Phillips wrote:

Aha!

A little more reading goes a long way… ip_hash persistence appears to work
– I can log in, anyway.

For those of you interested, here’s the URL:
http://nginx.org/en/docs/http/ngx_http_upstream_module.html#ip_hash

If I have anything more relevant to share, I will…

Kind Regards,

*Jason Phillips*

[image: hisp]

Re: [Dhis2-users] Load-balancing DHIS2 Webservers

2016-03-19 Thread Jason Phillips

Thanks, Lars!



I read it, but was under the impression that those features are part of the
paid version only, and we don’t have that (yet).

It does look interesting, and we’ll definitely be investigating more…  I’ll
let you know how it all pans out.

As it is, we have a five-server setup running currently, using ip_hash
weighted balancing.  It’s far from perfect, since the IP on mobiles changes
more often than copper/DSL, but it is working.  We’ve got a bit of work to
do to make it more streamlined, but we’re getting there… J



Kind Regards,

*Jason Phillips*

[image: hisp]
*Information Systems / Infrastructure*

*Health Information Systems Program*

eMail:   ja...@hisp.org
Tel/Fax:+27 21 712 0170
Cell: +27 72 973 7250
Skype: jason.n.phillips

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.







*From:* Lars Helge Øverland [mailto:l...@dhis2.org]
*Sent:* Wednesday, 16 March 2016 1:23 PM
*To:* Jason Phillips
*Cc:* DHIS 2 Users list
*Subject:* Re: [Dhis2-users] Load-balancing DHIS2 Webservers



Hi Jason,



there is the concept of "sticky sessions" which should ensure that a user
is always sent to the same server throughout his session:



https://www.nginx.com/products/session-persistence/

http://nginx.org/en/docs/http/load_balancing.html



There are other issues with load balancing (session persistence in case a
server goes down, hibernate cache replication) but this could help.



regards,



Lars













On Tue, Mar 15, 2016 at 8:20 PM, Jason Phillips  wrote:

Aha!



A little more reading goes a long way…  ip_hash persistence appears to work
– I can log in, anyway.

For those of you interested, here’s the URL:
http://nginx.org/en/docs/http/ngx_http_upstream_module.html#ip_hash



If I have anything more relevant to share, I will…



Kind Regards,

*Jason Phillips*

[image: hisp]
*Information Systems / Infrastructure*

*Health Information Systems Program*

eMail:   ja...@hisp.org
Landline:  +27 21 712 0170
Mobile: +27 72 973 7250
Skype: jason.n.phillips

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.







*From:* Jason Phillips [mailto:ja...@hisp.org]
*Sent:* Tuesday, 15 March 2016 8:34 PM
*To:* DHIS 2 Users list
*Subject:* Load-balancing DHIS2 Webservers



Hi, community (and Oslo team),



I am trying to set up a load-balanced DHIS2 web-server system; we have a
web server that’s getting slaughtered with incoming data, and we want to
distribute the load to other physical servers.  I’ve done some
experimentation, a fair amount of web-trawling, and using a dedicated nginx
virtual server, have (semi)successfully set up a load-balancing model like
so:





My problem is that going through the load-balancer, I appear to need some
kind of setting that will “keep” me at the Web-Server I first started with
– the load-balancer is set to round-robin, currently, with the following
settings:



upstream dhis2 {

server webserver1.dhis.hisp.org;

server webserver2.dhis.hisp.org;

}



server {

listen 80;

server_name www.hisp.org hisp.org;



location / {

include /etc/nginx/proxy_params;

proxy_pass http://dhis2;

}

location /staging {

include /etc/nginx/proxy_params;

proxy_pass http://dhis2;

}

location /training {

include /etc/nginx/proxy_params;

proxy_pass http://dhis2;

}

}



What’s happening is that I attempt to log in, and get immediately switched
“round-robin” style to the second server for the post (promptly getting the
“forgot password?” prompt).
Nett result: I can’t log in…

If I log in to either one of the webservers directly, everything is fine
and dandy, but going through the LB is a no-go, so far.  (I have noticed
some interesting behaviour from two web servers connected to the same Db,
and would be keen to hear what input anyone has on that score – bad idea?

Re: [Dhis2-users] Tracker: capture coordinates

2016-03-19 Thread GROUT, Lise

That would be great Abyot, so that different programmes visiting the same 
village (or school or helth facility) just have to record it once when 
registering the entity.

Have a nice day

Lise

Sent from my iPhone

On 17 Mar 2016, at 07:59, Abyot Asalefew Gizaw 
> wrote:

Dear Lise,

You are correct, we do not have that feature. We can implement it for the 
upcoming release.

---
Thank you,
Abyot.

On Thu, Mar 17, 2016 at 1:48 AM, GROUT, Lise 
> wrote:
Dear DHIS2 users,

One question. I would like to use tracker to track villages. I would like to 
capture coordinates once at time of registration (rather than inside programs, 
so that we have only 1 set of coordinates for all programs and all stages). But 
I don't see any option to capture coordinates for a tracked entity or though 
attributes. Is there any mean to do it?

Thanks !

Lise.

___
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] restore database out of memory

Hi Channara,

What values do you have for JAVA_OPTS?

On Fri, Mar 18, 2016 at 1:10 PM, channara rin 
wrote:

> hi all,
> do you hav any experience with postgresql database?
> i use command psql/pg_restore into new system. i got out of memory.
> my system server is 4GB memory and file backup size is around 100MB
>
> ___
> 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

[Dhis2-users] Event Visualiser Status: Conflict, User: xyw not allowed...

2016-03-19 Thread David Hagan

This issue just ‘popped’ in the last 12 hours for a pilot system for event
capture. Some form changes were made and pushed out … and while this error
seems to point to a permissions issue …. it doesn’t make any logical sense.
Here goes,

3 event charts worked last night.
This morning, those same 3 charts throw an error:

Code: 409
Status: Conflict
User_ xyz is not allowed to view org unit: abc

The silly thing is, I’m not logged in as that user, but as Admin, with full
access to all orgs.

If I look at the request URL (similar to below) …

/api/analytics/events/aggregate/wVzYQk6jW5q.json?stage=iPDH75AgmNv=kbaD30LqqjQ=ou:abc;tMQcwX60LSi;I3BIS1WKwpD=pe:LAST_4_WEEKS;THIS_WEEK=EVENT=NAME

which generates the error, and remove the offending org id from the query
string …. it brings back a result-set rather than the error message.

Any clues anyone?

Version info is: 2.21
Build revision: 20971Build date: 2015-12-18 12:01

David
___
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] Event Visualiser Status: Conflict, User: xyw not allowed...

2016-03-19 Thread Jason Pickering

Are you sure this is not server caching, possibly the reverse proxy?



On Wed, Mar 16, 2016 at 1:40 PM, David Hagan 
wrote:

> This issue just ‘popped’ in the last 12 hours for a pilot system for event
> capture. Some form changes were made and pushed out … and while this error
> seems to point to a permissions issue …. it doesn’t make any logical sense.
> Here goes,
>
> 3 event charts worked last night.
> This morning, those same 3 charts throw an error:
>
> Code: 409
> Status: Conflict
> User_ xyz is not allowed to view org unit: abc
>
> The silly thing is, I’m not logged in as that user, but as Admin, with
> full access to all orgs.
>
> If I look at the request URL (similar to below) …
>
>
> /api/analytics/events/aggregate/wVzYQk6jW5q.json?stage=iPDH75AgmNv=kbaD30LqqjQ=ou:abc;tMQcwX60LSi;I3BIS1WKwpD=pe:LAST_4_WEEKS;THIS_WEEK=EVENT=NAME
>
> which generates the error, and remove the offending org id from the query
> string …. it brings back a result-set rather than the error message.
>
> Any clues anyone?
>
> Version info is: 2.21
> Build revision: 20971Build date: 2015-12-18 12:01
>
> David
>
> ___
> 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
>
>


-- 
Jason P. Pickering
email: jason.p.picker...@gmail.com
tel:+46764147049
___
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

[Dhis2-users] Financial Year setting

2016-03-19 Thread Mugeni Harold

Hi guys,

 

I am looking at some graphs in visualizer and whenever I use the period
'last 5 financial years', it uses the October to September financial year.
Is there a setting in dhis2 for determining the organization's financial
year? If yes, where is it?

 

Cheers,

Harold

 

___
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

[Dhis2-users] Tracker: capture coordinates

2016-03-19 Thread GROUT, Lise

Dear DHIS2 users,

One question. I would like to use tracker to track villages. I would like to 
capture coordinates once at time of registration (rather than inside programs, 
so that we have only 1 set of coordinates for all programs and all stages). But 
I don't see any option to capture coordinates for a tracked entity or though 
attributes. Is there any mean to do it?

Thanks !

Lise.
___
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] Load-balancing DHIS2 Webservers

2016-03-19 Thread Lars Helge Øverland

Hi Jason,

there is the concept of "sticky sessions" which should ensure that a user
is always sent to the same server throughout his session:

https://www.nginx.com/products/session-persistence/
http://nginx.org/en/docs/http/load_balancing.html

There are other issues with load balancing (session persistence in case a
server goes down, hibernate cache replication) but this could help.

regards,

Lars






On Tue, Mar 15, 2016 at 8:20 PM, Jason Phillips  wrote:

> Aha!
>
>
>
> A little more reading goes a long way…  ip_hash persistence appears to
> work – I can log in, anyway.
>
> For those of you interested, here’s the URL:
> http://nginx.org/en/docs/http/ngx_http_upstream_module.html#ip_hash
>
>
>
> If I have anything more relevant to share, I will…
>
>
>
> Kind Regards,
>
> *Jason Phillips*
>
> [image: hisp]
> *Information Systems / Infrastructure*
>
> *Health Information Systems Program*
>
> eMail:   ja...@hisp.org
> Landline:  +27 21 712 0170
> Mobile: +27 72 973 7250
> Skype: jason.n.phillips
>
> 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.
>
>
>
>
>
>
>
> *From:* Jason Phillips [mailto:ja...@hisp.org]
> *Sent:* Tuesday, 15 March 2016 8:34 PM
> *To:* DHIS 2 Users list
> *Subject:* Load-balancing DHIS2 Webservers
>
>
>
> Hi, community (and Oslo team),
>
>
>
> I am trying to set up a load-balanced DHIS2 web-server system; we have a
> web server that’s getting slaughtered with incoming data, and we want to
> distribute the load to other physical servers.  I’ve done some
> experimentation, a fair amount of web-trawling, and using a dedicated nginx
> virtual server, have (semi)successfully set up a load-balancing model like
> so:
>
>
>
>
>
> My problem is that going through the load-balancer, I appear to need some
> kind of setting that will “keep” me at the Web-Server I first started with
> – the load-balancer is set to round-robin, currently, with the following
> settings:
>
>
>
> upstream dhis2 {
>
> server webserver1.dhis.hisp.org;
>
> server webserver2.dhis.hisp.org;
>
> }
>
>
>
> server {
>
> listen 80;
>
> server_name www.hisp.org hisp.org;
>
>
>
> location / {
>
> include /etc/nginx/proxy_params;
>
> proxy_pass http://dhis2;
>
> }
>
> location /staging {
>
> include /etc/nginx/proxy_params;
>
> proxy_pass http://dhis2;
>
> }
>
> location /training {
>
> include /etc/nginx/proxy_params;
>
> proxy_pass http://dhis2;
>
> }
>
> }
>
>
>
> What’s happening is that I attempt to log in, and get immediately switched
> “round-robin” style to the second server for the post (promptly getting the
> “forgot password?” prompt).
> Nett result: I can’t log in…
>
> If I log in to either one of the webservers directly, everything is fine
> and dandy, but going through the LB is a no-go, so far.  (I have noticed
> some interesting behaviour from two web servers connected to the same Db,
> and would be keen to hear what input anyone has on that score – bad idea?
> If so, why?  And what can be done to address the issues? – but I shall save
> that for a separate post…)
>
>
>
> Has anyone done any research/experimentation/development with a
> load-balancing model of DHIS2 in a web-server context?  I would be most
> interested to hear input.
>
>
>
> Kind Regards,
>
> *Jason Phillips*
>
> [image: hisp]
> *Information Systems / Infrastructure*
>
> *Health Information Systems Program*
>
> eMail:   ja...@hisp.org
> Landline:  +27 21 712 0170
> Mobile: +27 72 973 7250
> Skype: jason.n.phillips
>
> 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.
>
>
>
> *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

Re: [Dhis2-users] Event Visualiser Status: Conflict, User: xyw not allowed...

2016-03-19 Thread David Hagan

Hm,

I did do some testing overnight as that user …..

Let me check.

DH

From:  Jason Pickering 
Date:  Wednesday 16 March 2016 at 13:50
To:  David Hagan 
Cc:  dhis2-users 
Subject:  Re: [Dhis2-users] Event Visualiser Status: Conflict, User: xyw not 
allowed...

Are you sure this is not server caching, possibly the reverse proxy?

On Wed, Mar 16, 2016 at 1:40 PM, David Hagan  wrote:
This issue just ‘popped’ in the last 12 hours for a pilot system for event 
capture. Some form changes were made and pushed out … and while this error 
seems to point to a permissions issue …. it doesn’t make any logical sense. 
Here goes,

3 event charts worked last night.
This morning, those same 3 charts throw an error:

Code: 409
Status: Conflict
User_ xyz is not allowed to view org unit: abc

The silly thing is, I’m not logged in as that user, but as Admin, with full 
access to all orgs.

If I look at the request URL (similar to below) … 

/api/analytics/events/aggregate/wVzYQk6jW5q.json?stage=iPDH75AgmNv=kbaD30LqqjQ=ou:abc;tMQcwX60LSi;I3BIS1WKwpD=pe:LAST_4_WEEKS;THIS_WEEK=EVENT=NAME

which generates the error, and remove the offending org id from the query 
string …. it brings back a result-set rather than the error message.

Any clues anyone?

Version info is: 2.21
Build revision: 20971Build date: 2015-12-18 12:01

David

___
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

-- 
Jason P. Pickering
email: jason.p.picker...@gmail.com
tel:+46764147049

___
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] Tracker: capture coordinates

2016-03-19 Thread Abyot Asalefew Gizaw

Yes,  can have value type coordinate for both attributes and data elements.

This allows you to record coordinate at the time of tracked entity instance
registration and also during data entry for program stages. You can decide
where and how many coordinates to record - this depends on how many
attributes and/or data elements of type coordinate that you have defined.

One thing you need to keep in mind is, we do not have yet a means to
visualize these coordinates in our mapping tool. But we can start with
recording...

---
Thank you,
Abyot.

On Thu, Mar 17, 2016 at 9:05 AM, GROUT, Lise  wrote:

> That would be great Abyot, so that different programmes visiting the same
> village (or school or helth facility) just have to record it once when
> registering the entity.
>
> Have a nice day
>
> Lise
>
> Sent from my iPhone
>
> On 17 Mar 2016, at 07:59, Abyot Asalefew Gizaw  wrote:
>
> Dear Lise,
>
> You are correct, we do not have that feature. We can implement it for the
> upcoming release.
>
> ---
> Thank you,
> Abyot.
>
> On Thu, Mar 17, 2016 at 1:48 AM, GROUT, Lise  wrote:
>
>> Dear DHIS2 users,
>>
>> One question. I would like to use tracker to track villages. I would like
>> to capture coordinates once at time of registration (rather than inside
>> programs, so that we have only 1 set of coordinates for all programs and
>> all stages). But I don't see any option to capture coordinates for a
>> tracked entity or though attributes. Is there any mean to do it?
>>
>> Thanks !
>>
>> Lise.
>>
>> ___
>> 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] Load-balancing DHIS2 Webservers

Jason,

Put simply, when users interact with the application they deal with
information from the underlying database.  But the dhis2 java application
doesn't keep going backwards and forwards to the database for everything
all the time.  To be efficient it also maintains a cached copy of what is
in the database.  So at any given moment in time what is seen by the
application may not be exactly what is in the database.  This is not a
problem when there is only one dhis2 instance as differences get resolved,
cache is flushed to database, refreshed from database etc.

But with more than one dhis2 instance feeding off the same database they
can (and inevitably) will develop inconsistent views.  Which might have
some disastrous result.  So something else needs to be configured to ensure
these multiple cache's remain consistent.

One way to do that is to use distributed caching as described here (
http://www.ehcache.org/documentation/2.8/get-started/cache-topologies.html#distributed-caching)
- though that does seem to require an additional non-open source
component.  There might be other approaches as well.

I don't really have experience of doing this, just pointing out that I
think you need a strategy to address it in order to do the sort of load
scaling you talk about.

Bob



On 16 March 2016 at 15:13, Jason Phillips  wrote:

> Hibernate cache...?
>
> I’m sorry, I don’t speak Norwegian.  The what, now?
>
>
>
> I’ll Google when I get a chance, but for now, have no idea what you’re
> talking about…  J
>
> It does sound important, though…
>
>
>
> Kind Regards,
>
> *Jason Phillips*
>
> [image: hisp]
> *Information Systems / Infrastructure*
>
> *Health Information Systems Program*
>
> eMail:   ja...@hisp.org
> Tel/Fax:+27 21 712 0170
> Cell: +27 72 973 7250
> Skype: jason.n.phillips
>
> 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.
>
>
>
>
>
>
>
> *From:* Bob Jolliffe [mailto:bobjolli...@gmail.com]
> *Sent:* Wednesday, 16 March 2016 2:24 PM
> *To:* Lars Helge Øverland
> *Cc:* Jason Phillips; DHIS 2 Users list
> *Subject:* Re: [Dhis2-users] Load-balancing DHIS2 Webservers
>
>
>
> I have not done this, but I imagine that hibernate cache replication
> between instances is something that really needs to be done to have this
> sort of scaling configuration work.
>
>
>
> I do remember there was a brief flirtation with hazelcast before reverting
> to ehcache.  Is anybody using ehcache in this way ie. for replication in a
> clustering setup?
>
>
>
> On 16 March 2016 at 12:22, Lars Helge Øverland  wrote:
>
> Hi Jason,
>
>
>
> there is the concept of "sticky sessions" which should ensure that a user
> is always sent to the same server throughout his session:
>
>
>
> https://www.nginx.com/products/session-persistence/
>
> http://nginx.org/en/docs/http/load_balancing.html
>
>
>
> There are other issues with load balancing (session persistence in case a
> server goes down, hibernate cache replication) but this could help.
>
>
>
> regards,
>
>
>
> Lars
>
>
>
>
>
>
>
>
>
>
>
>
>
> On Tue, Mar 15, 2016 at 8:20 PM, Jason Phillips  wrote:
>
> Aha!
>
>
>
> A little more reading goes a long way…  ip_hash persistence appears to
> work – I can log in, anyway.
>
> For those of you interested, here’s the URL:
> http://nginx.org/en/docs/http/ngx_http_upstream_module.html#ip_hash
>
>
>
> If I have anything more relevant to share, I will…
>
>
>
> Kind Regards,
>
> *Jason Phillips*
>
> [image: hisp]
> *Information Systems / Infrastructure*
>
> *Health Information Systems Program*
>
> eMail:   ja...@hisp.org
> Landline:  +27 21 712 0170
> Mobile: +27 72 973 7250
> Skype: jason.n.phillips
>
> 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.
>
>
>
>
>
>
>
> *From:* Jason Phillips [mailto:ja...@hisp.org]
> *Sent:* Tuesday, 15 March 2016 8:34 PM
> *To:* DHIS 2 Users list
> *Subject:* Load-balancing DHIS2 Webservers
>
>
>
> Hi, community (and Oslo team),
>

Re: [Dhis2-users] [Dhis2-devs] Financial Year setting

2016-03-19 Thread Mugeni Harold

Dear Knut,

 

Thank you for the quick reply. Do you know why then it is currently selecting 
this particular financial year? And is it possible for me to configure graphs 
to use a period e.g.. last 5 financial years, but be able to define which 
financial year to use currently?

 

Thank you,

Harold

 

From: Knut Staring [mailto:knu...@gmail.com] 
Sent: Thursday, March 17, 2016 1:16 PM
To: Mugeni Harold
Cc: DHIS 2 developers; dhis2-users@lists.launchpad.net
Subject: Re: [Dhis2-devs] Financial Year setting

 

Support for this is planned for the next release, I think:
https://blueprints.launchpad.net/dhis2/+spec/configurable-financial-year-relative-period

Knut

 

On Thu, Mar 17, 2016 at 12:10 PM, Mugeni Harold  wrote:

Hi guys,

 

I am looking at some graphs in visualizer and whenever I use the period ‘last 5 
financial years’, it uses the October to September financial year. Is there a 
setting in dhis2 for determining the organization’s financial year? If yes, 
where is it?

 

Cheers,

Harold

 


___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-d...@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
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

[Dhis2-users] Map with large size cannot download

2016-03-19 Thread Mihayo Mathayo

Hello Team,

Hope your all doing fine,i can not download map with size more than 2
MB,what could be the problem?  i can only display the map but when i try to
download it loads for so long .am using version 2.18.

Regards
___
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] restore database out of memory

One other quick thought that is easy to test and eliminate.  Postgres
out of memory errors on restore can also result from a corrupted dump
file.  It might be worthwhile to check on another system that your
dump is good.

On 18 March 2016 at 17:08, Bob Jolliffe  wrote:
> Ah you are on Windoze.  I also don't have much real experience of
> running dhis2 other than on linux, but it strikes me that
> (i) 4G machine is small but should still "work"
> (ii) the databse size you are talking about 100m is quite small and
> the restore operation should not be consuming vast amounts of memory
> (iii) postgres will run, albeit not very efficiently, with quite small
> amounts of memory.
>
> So ...
>
> I think you need to look at what else you have running on that machine
> which could be consuming the bulk of memory.  I think windoze system
> tools like task manager and perfmon.exe might show you useful
> information.
>
> Have you modified postgres config or is it default setting?  Default
> settings would be very conservative but should work.  If you have
> modified, you might have given postgres the impression it has more
> memory available than actually exists.
>
> On 18 March 2016 at 16:53, channara rin  wrote:
>> No from hard drive. it has free disk space 100GB for C: and D: is 45GB
>>
>> On Fri, Mar 18, 2016 at 10:31 PM, Knut Staring  wrote:
>>>
>>> Sorry Channara, I didn't read your question properly, this has nothing to
>>> do with JAVA_OPTS.
>>>
>>> Unfortunately, I have no experience with getting Postgres out of memory
>>> errors, though google tells me a lot of people do.
>>>
>>> Could it perhaps be that your hard drive is filling up?
>>>
>>> On Fri, Mar 18, 2016 at 3:38 PM, channara rin 
>>> wrote:

 here in java_opts=-Djava.awt.headless=true -Dfile.encoding=UTF-8 -server
 -Xms128m -Xmx1024m -XX:NewSize=2048m -XXMaxNewSize=2048m -XX:PermSize=256m
 -XX:MaxPermSize=1024m -XX:+DisableExplicitGC -xx:+UseConcMarkSweepGC
 -XX:+DisableExplicitGC

 On Fri, Mar 18, 2016 at 7:39 PM, Knut Staring  wrote:
>
> Hi Channara,
>
> What values do you have for JAVA_OPTS?
>
> On Fri, Mar 18, 2016 at 1:10 PM, channara rin 
> wrote:
>>
>> hi all,
>> do you hav any experience with postgresql database?
>> i use command psql/pg_restore into new system. i got out of memory.
>> my system server is 4GB memory and file backup size is around 100MB
>>
>> ___
>> 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


>>>
>>>
>>>
>>> --
>>> 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] DHIS2 crashes during login

2016-03-19 Thread Jason Pickering

Hi Tantely,

Please have a look at our guidelines for reporting a problem.


Please include the logs of the server when it crashes as this will help to
diagnose what the issue might be.

Regards,
Jason


On Fri, Mar 18, 2016 at 12:43 PM, Raminosoa Rabemanantsoa, Tantely <
tramino...@mikolo.org> wrote:

> Hello everyone,
>
>
> I am a new user of DHIS2. I am working with a DHIS2 application that has
> already been installed last year inside an Amazon cloud web server.  The
> version that we have is DHIS2 2.19. The Tomcat version is 1.7. All the data
> elements, organization unit and questionnaires have been integrated into
> the system.
>
>
> We are observing odd situation such as Tomcat is crashing each time a
> couple of users (15+) are accessing DHIS2 simultaneously, especially when
> they are using the DHIS2 Data Capture within tablets. DHIS2 is only back
> after restarting Tomcat.
>
>
> Do you know the Server and JVM memory specifications that are recommended
> to expect about 300 concurrent DHIS2 users?
>
>
> Here are some Java environment variables and server caracteristics that we
> are using:
>
>
> Java opts:   -Xms1024m -Xmx2048m -XX:PermSize=256m
> -XX:MaxPermSize=512m
>
> Java version: 1.7.0_91
>
> OS name:Linux
>
> OS architecture:amd64
>
> OS version:4.1.10-17.31.amzn1.x86_64
>
> Server memory:Mem Total in JVM: 1243 Free in JVM: 547 Max Limit: 1820
>
> CPU cores:2
>
> Server RAM: 3.75 G
>
>
> Thank you for your support!
>
>
> 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
>
>


-- 
Jason P. Pickering
email: jason.p.picker...@gmail.com
tel:+46764147049
___
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] restore database out of memory

here in java_opts=-Djava.awt.headless=true -Dfile.encoding=UTF-8 -server
-Xms128m -Xmx1024m -XX:NewSize=2048m -XXMaxNewSize=2048m -XX:PermSize=256m
-XX:MaxPermSize=1024m -XX:+DisableExplicitGC -xx:+UseConcMarkSweepGC
-XX:+DisableExplicitGC

On Fri, Mar 18, 2016 at 7:39 PM, Knut Staring  wrote:

> Hi Channara,
>
> What values do you have for JAVA_OPTS?
>
> On Fri, Mar 18, 2016 at 1:10 PM, channara rin 
> wrote:
>
>> hi all,
>> do you hav any experience with postgresql database?
>> i use command psql/pg_restore into new system. i got out of memory.
>> my system server is 4GB memory and file backup size is around 100MB
>>
>> ___
>> 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] Phone Recommendations for DHIS2 Java Mobile Client

2016-03-19 Thread Ted Johnson

Knut,

We know Android very well, but we want to be able to test DHIS2 on feature
phones as well.

Long version: We have a website that we have developed to work in Opera
Mini on feature phones, but we need a feature phone that will allow us to
upgrade to the latest version of Opera Mini. I'm hoping we can find in one
phone a good test environment for DHIS2 and our Opera-Mini-optimized
website.

On Wed, Mar 16, 2016 at 4:57 PM, Knut Staring  wrote:

> Hi Ted,
>
> Is there a strong reason for you to prefer featurephones over Android? The
> j2me client needs an update before it will work with the newest version of
> the server (we are planning to fix this, but alas, not yet).
>
> Knut
>
> On Wed, Mar 16, 2016 at 2:40 PM, Ted Johnson  wrote:
>
>> Greetings from Madagascar. This is my first  post to the users group, and
>> I'm not officially a DHIS2 user yet.
>>
>> I am interested in buying a Java phone for testing the DHIS2 Java Mobile
>> Client, along with other Java apps related to my work.
>>
>> Here in the capitol, we have been unable to locate a Nokia S40 series
>> phone (which is what was recommended on the DHIS2 website). I would like a
>> recommendation for phone that is somewhat common in Africa.
>>
>> Thanks in advance.
>>
>>
>> --
>> *Ted Johnson* | Media and Communications Manager
>>
>> tjohn...@hni.org  | www.hni.org | www.DataWinners.com
>> 
>>
>> http://www.facebook.com/humannetworkinternational
>> http://www.facebook.com/datawinners
>> @DataWinners 
>>
>> ___
>> 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
>



-- 
*Ted Johnson* | Media and Communications Manager

tjohn...@hni.org  | www.hni.org | www.DataWinners.com


http://www.facebook.com/humannetworkinternational
http://www.facebook.com/datawinners
@DataWinners 
___
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] [Dhis2-devs] Financial Year setting

Not as far as I know

On Thu, Mar 17, 2016 at 12:24 PM, Mugeni Harold  wrote:

> Dear Knut,
>
>
>
> Thank you for the quick reply. Do you know why then it is currently
> selecting this particular financial year? And is it possible for me to
> configure graphs to use a period e.g.. last 5 financial years, but be able
> to define which financial year to use currently?
>
>
>
> Thank you,
>
> Harold
>
>
>
> *From:* Knut Staring [mailto:knu...@gmail.com]
> *Sent:* Thursday, March 17, 2016 1:16 PM
> *To:* Mugeni Harold
> *Cc:* DHIS 2 developers; dhis2-users@lists.launchpad.net
> *Subject:* Re: [Dhis2-devs] Financial Year setting
>
>
>
> Support for this is planned for the next release, I think:
>
> https://blueprints.launchpad.net/dhis2/+spec/configurable-financial-year-relative-period
>
> Knut
>
>
>
> On Thu, Mar 17, 2016 at 12:10 PM, Mugeni Harold  wrote:
>
> Hi guys,
>
>
>
> I am looking at some graphs in visualizer and whenever I use the period
> ‘last 5 financial years’, it uses the October to September financial year.
> Is there a setting in dhis2 for determining the organization’s financial
> year? If yes, where is it?
>
>
>
> Cheers,
>
> Harold
>
>
>
>
> ___
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to : dhis2-d...@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>
>
>
>
> --
>
> Knut Staring
>
> Dept. of Informatics, University of Oslo
>
> Norway: +4791880522
>
> Skype: knutstar
>
> http://dhis2.org
>



-- 
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] restore database out of memory

No from hard drive. it has free disk space 100GB for C: and D: is 45GB

On Fri, Mar 18, 2016 at 10:31 PM, Knut Staring  wrote:

> Sorry Channara, I didn't read your question properly, this has nothing to
> do with JAVA_OPTS.
>
> Unfortunately, I have no experience with getting Postgres out of memory
> errors, though google tells me a lot of people do.
>
> Could it perhaps be that your hard drive is filling up?
>
> On Fri, Mar 18, 2016 at 3:38 PM, channara rin 
> wrote:
>
>> here in java_opts=-Djava.awt.headless=true -Dfile.encoding=UTF-8 -server
>> -Xms128m -Xmx1024m -XX:NewSize=2048m -XXMaxNewSize=2048m -XX:PermSize=256m
>> -XX:MaxPermSize=1024m -XX:+DisableExplicitGC -xx:+UseConcMarkSweepGC
>> -XX:+DisableExplicitGC
>>
>> On Fri, Mar 18, 2016 at 7:39 PM, Knut Staring  wrote:
>>
>>> Hi Channara,
>>>
>>> What values do you have for JAVA_OPTS?
>>>
>>> On Fri, Mar 18, 2016 at 1:10 PM, channara rin 
>>> wrote:
>>>
 hi all,
 do you hav any experience with postgresql database?
 i use command psql/pg_restore into new system. i got out of memory.
 my system server is 4GB memory and file backup size is around 100MB

 ___
 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
>>>
>>
>>
>
>
> --
> 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] Load-balancing DHIS2 Webservers

2016-03-19 Thread Jason Phillips

Hibernate cache...?

I’m sorry, I don’t speak Norwegian.  The what, now?



I’ll Google when I get a chance, but for now, have no idea what you’re
talking about…  J

It does sound important, though…



Kind Regards,

*Jason Phillips*

[image: hisp]
*Information Systems / Infrastructure*

*Health Information Systems Program*

eMail:   ja...@hisp.org
Tel/Fax:+27 21 712 0170
Cell: +27 72 973 7250
Skype: jason.n.phillips

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.







*From:* Bob Jolliffe [mailto:bobjolli...@gmail.com]
*Sent:* Wednesday, 16 March 2016 2:24 PM
*To:* Lars Helge Øverland
*Cc:* Jason Phillips; DHIS 2 Users list
*Subject:* Re: [Dhis2-users] Load-balancing DHIS2 Webservers



I have not done this, but I imagine that hibernate cache replication
between instances is something that really needs to be done to have this
sort of scaling configuration work.



I do remember there was a brief flirtation with hazelcast before reverting
to ehcache.  Is anybody using ehcache in this way ie. for replication in a
clustering setup?



On 16 March 2016 at 12:22, Lars Helge Øverland  wrote:

Hi Jason,



there is the concept of "sticky sessions" which should ensure that a user
is always sent to the same server throughout his session:



https://www.nginx.com/products/session-persistence/

http://nginx.org/en/docs/http/load_balancing.html



There are other issues with load balancing (session persistence in case a
server goes down, hibernate cache replication) but this could help.



regards,



Lars













On Tue, Mar 15, 2016 at 8:20 PM, Jason Phillips  wrote:

Aha!



A little more reading goes a long way…  ip_hash persistence appears to work
– I can log in, anyway.

For those of you interested, here’s the URL:
http://nginx.org/en/docs/http/ngx_http_upstream_module.html#ip_hash



If I have anything more relevant to share, I will…



Kind Regards,

*Jason Phillips*

[image: hisp]
*Information Systems / Infrastructure*

*Health Information Systems Program*

eMail:   ja...@hisp.org
Landline:  +27 21 712 0170
Mobile: +27 72 973 7250
Skype: jason.n.phillips

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.







*From:* Jason Phillips [mailto:ja...@hisp.org]
*Sent:* Tuesday, 15 March 2016 8:34 PM
*To:* DHIS 2 Users list
*Subject:* Load-balancing DHIS2 Webservers



Hi, community (and Oslo team),



I am trying to set up a load-balanced DHIS2 web-server system; we have a
web server that’s getting slaughtered with incoming data, and we want to
distribute the load to other physical servers.  I’ve done some
experimentation, a fair amount of web-trawling, and using a dedicated nginx
virtual server, have (semi)successfully set up a load-balancing model like
so:





My problem is that going through the load-balancer, I appear to need some
kind of setting that will “keep” me at the Web-Server I first started with
– the load-balancer is set to round-robin, currently, with the following
settings:



upstream dhis2 {

server webserver1.dhis.hisp.org;

server webserver2.dhis.hisp.org;

}



server {

listen 80;

server_name www.hisp.org hisp.org;



location / {

include /etc/nginx/proxy_params;

proxy_pass http://dhis2;

}

location /staging {

include /etc/nginx/proxy_params;

proxy_pass http://dhis2;

}

location /training {

include /etc/nginx/proxy_params;

proxy_pass http://dhis2;

}

}



What’s happening is that I attempt to log in, and get immediately switched
“round-robin” style to the second server for the post (promptly getting the
“forgot password?” prompt).
Nett result: I can’t log in…

If I log in to either one of the webservers directly, everything is fine
and dandy, but going through the LB is a no-go, so far.  (I have noticed
some interesting behaviour from two web

Re: [Dhis2-users] Fwd: Phone Recommendations for DHIS2 Java Mobile Client

2016-03-19 Thread aluka.terpase

Hi Ted
You can also use Aisha 210. We have deployed it in Nigeria and it has worked 
well.
Thanks


 Immaculate Ayebazibwe  wrote:

>HiTed,IwouldrecommendtheASHA206,OneoftheprojectsinUgandawasusingthat.OnWed,Mar16,2016at11:02PM,TedJohnsontjohnson@hni.orgwrote:ItsprobablyfineifIhavetowaituntiltheserverissueisworkedout.Iwillnotbeusingthephoneforareal-worlddatacollection,butrathertofamiliarizemyselfwithDHIS2vis-a-vistheneedsofourclients.HowcanIreachBenorScott?WehavetwopeopleinZambiarightnowfortheUNDPLastMileworkshop.
> 
>OnWed,Mar16,2016at6:17PM,JasonPickeringjason.p.pickering@gmail.comwrote:HiTed,IthinkmostNokiafeaturephoneswillwork.BenandScottfromAkroshavealotofexperienceusingJ2MEphonesinZambiaandmaybeabletoprovidemoredetailsaboutexactmodels.
> 
>AsKnutpointsout,theremaybesomeissueswiththeJ2MEclientanddifferentserverversionsatthemoment,whichwearelookinginto.
> 
>Regards,Jason--Forwardedmessage--From:TedJohnsontjohnson@hni.orgDate:Wed,Mar16,2016at3:03PMSubject:Re:[Dhis2-users]PhoneRecommendationsforDHIS2JavaMobileClientTo:KnutStaringknutst@gmail.comCc:dhis2-users@lists.launchpad.netdhis2-users@lists.launchpad.netKnut,WeknowAndroidverywell,butwewanttobeabletotestDHIS2onfeaturephonesaswell.Longversion:WehaveawebsitethatwehavedevelopedtoworkinOperaMinionfeaturephones,butweneedafeaturephonethatwillallowustoupgradetothelatestversionofOperaMini.ImhopingwecanfindinonephoneagoodtestenvironmentforDHIS2andourOpera-Mini-optimizedwebsite.
> 
>OnWed,Mar16,2016at4:57PM,KnutStaringknutst@gmail.comwrote:HiTed,IsthereastrongreasonforyoutopreferfeaturephonesoverAndroid?Thej2meclientneedsanupdatebeforeitwillworkwiththenewestversionoftheserver(weareplanningtofixthis,butalas,notyet).KnutOnWed,Mar16,2016at2:40PM,TedJohnsontjohnson@hni.orgwrote:GreetingsfromMadagascar.Thisismyfirst
> 
>posttotheusersgroup,andImnotofficiallyaDHIS2useryet.IaminterestedinbuyingaJavaphonefortestingtheDHIS2JavaMobileClient,alongwithotherJavaappsrelatedtomywork.Hereinthecapitol,wehavebeenunabletolocatea
> 
>NokiaS40seriesphone(whichiswhatwasrecommendedontheDHIS2website).IwouldlikearecommendationforphonethatissomewhatcommoninAfrica.
>

Re: [Dhis2-users] Load-balancing DHIS2 Webservers

I have not done this, but I imagine that hibernate cache replication
between instances is something that really needs to be done to have this
sort of scaling configuration work.

I do remember there was a brief flirtation with hazelcast before reverting
to ehcache.  Is anybody using ehcache in this way ie. for replication in a
clustering setup?

On 16 March 2016 at 12:22, Lars Helge Øverland  wrote:

> Hi Jason,
>
> there is the concept of "sticky sessions" which should ensure that a user
> is always sent to the same server throughout his session:
>
> https://www.nginx.com/products/session-persistence/
> http://nginx.org/en/docs/http/load_balancing.html
>
> There are other issues with load balancing (session persistence in case a
> server goes down, hibernate cache replication) but this could help.
>
> regards,
>
> Lars
>
>
>
>
>
>
> On Tue, Mar 15, 2016 at 8:20 PM, Jason Phillips  wrote:
>
>> Aha!
>>
>>
>>
>> A little more reading goes a long way…  ip_hash persistence appears to
>> work – I can log in, anyway.
>>
>> For those of you interested, here’s the URL:
>> http://nginx.org/en/docs/http/ngx_http_upstream_module.html#ip_hash
>>
>>
>>
>> If I have anything more relevant to share, I will…
>>
>>
>>
>> Kind Regards,
>>
>> *Jason Phillips*
>>
>> [image: hisp]
>> *Information Systems / Infrastructure*
>>
>> *Health Information Systems Program*
>>
>> eMail:   ja...@hisp.org
>> Landline:  +27 21 712 0170
>> Mobile: +27 72 973 7250
>> Skype: jason.n.phillips
>>
>> 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.
>>
>>
>>
>>
>>
>>
>>
>> *From:* Jason Phillips [mailto:ja...@hisp.org]
>> *Sent:* Tuesday, 15 March 2016 8:34 PM
>> *To:* DHIS 2 Users list
>> *Subject:* Load-balancing DHIS2 Webservers
>>
>>
>>
>> Hi, community (and Oslo team),
>>
>>
>>
>> I am trying to set up a load-balanced DHIS2 web-server system; we have a
>> web server that’s getting slaughtered with incoming data, and we want to
>> distribute the load to other physical servers.  I’ve done some
>> experimentation, a fair amount of web-trawling, and using a dedicated nginx
>> virtual server, have (semi)successfully set up a load-balancing model like
>> so:
>>
>>
>>
>>
>>
>> My problem is that going through the load-balancer, I appear to need some
>> kind of setting that will “keep” me at the Web-Server I first started with
>> – the load-balancer is set to round-robin, currently, with the following
>> settings:
>>
>>
>>
>> upstream dhis2 {
>>
>> server webserver1.dhis.hisp.org;
>>
>> server webserver2.dhis.hisp.org;
>>
>> }
>>
>>
>>
>> server {
>>
>> listen 80;
>>
>> server_name www.hisp.org hisp.org;
>>
>>
>>
>> location / {
>>
>> include /etc/nginx/proxy_params;
>>
>> proxy_pass http://dhis2;
>>
>> }
>>
>> location /staging {
>>
>> include /etc/nginx/proxy_params;
>>
>> proxy_pass http://dhis2;
>>
>> }
>>
>> location /training {
>>
>> include /etc/nginx/proxy_params;
>>
>> proxy_pass http://dhis2;
>>
>> }
>>
>> }
>>
>>
>>
>> What’s happening is that I attempt to log in, and get immediately
>> switched “round-robin” style to the second server for the post (promptly
>> getting the “forgot password?” prompt).
>> Nett result: I can’t log in…
>>
>> If I log in to either one of the webservers directly, everything is fine
>> and dandy, but going through the LB is a no-go, so far.  (I have noticed
>> some interesting behaviour from two web servers connected to the same Db,
>> and would be keen to hear what input anyone has on that score – bad idea?
>> If so, why?  And what can be done to address the issues? – but I shall save
>> that for a separate post…)
>>
>>
>>
>> Has anyone done any research/experimentation/development with a
>> load-balancing model of DHIS2 in a web-server context?  I would be most
>> interested to hear input.
>>
>>
>>
>> Kind Regards,
>>
>> *Jason Phillips*
>>
>> [image: hisp]
>> *Information Systems / Infrastructure*
>>
>> *Health Information Systems Program*
>>
>> eMail:   ja...@hisp.org
>> Landline:  +27 21 712 0170
>> Mobile: +27 72 973 7250
>> Skype: jason.n.phillips
>>
>> This message and any attachments are subject to a disclaimer published at
>> http://www.hisp.org/policies.html#comms_disclaimer.  Please read

Re: [Dhis2-users] restore database out of memory

Ah you are on Windoze.  I also don't have much real experience of
running dhis2 other than on linux, but it strikes me that
(i) 4G machine is small but should still "work"
(ii) the databse size you are talking about 100m is quite small and
the restore operation should not be consuming vast amounts of memory
(iii) postgres will run, albeit not very efficiently, with quite small
amounts of memory.

So ...

I think you need to look at what else you have running on that machine
which could be consuming the bulk of memory.  I think windoze system
tools like task manager and perfmon.exe might show you useful
information.

Have you modified postgres config or is it default setting?  Default
settings would be very conservative but should work.  If you have
modified, you might have given postgres the impression it has more
memory available than actually exists.

On 18 March 2016 at 16:53, channara rin  wrote:
> No from hard drive. it has free disk space 100GB for C: and D: is 45GB
>
> On Fri, Mar 18, 2016 at 10:31 PM, Knut Staring  wrote:
>>
>> Sorry Channara, I didn't read your question properly, this has nothing to
>> do with JAVA_OPTS.
>>
>> Unfortunately, I have no experience with getting Postgres out of memory
>> errors, though google tells me a lot of people do.
>>
>> Could it perhaps be that your hard drive is filling up?
>>
>> On Fri, Mar 18, 2016 at 3:38 PM, channara rin 
>> wrote:
>>>
>>> here in java_opts=-Djava.awt.headless=true -Dfile.encoding=UTF-8 -server
>>> -Xms128m -Xmx1024m -XX:NewSize=2048m -XXMaxNewSize=2048m -XX:PermSize=256m
>>> -XX:MaxPermSize=1024m -XX:+DisableExplicitGC -xx:+UseConcMarkSweepGC
>>> -XX:+DisableExplicitGC
>>>
>>> On Fri, Mar 18, 2016 at 7:39 PM, Knut Staring  wrote:

 Hi Channara,

 What values do you have for JAVA_OPTS?

 On Fri, Mar 18, 2016 at 1:10 PM, channara rin 
 wrote:
>
> hi all,
> do you hav any experience with postgresql database?
> i use command psql/pg_restore into new system. i got out of memory.
> my system server is 4GB memory and file backup size is around 100MB
>
> ___
> 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
>>>
>>>
>>
>>
>>
>> --
>> 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

[Dhis2-users] Phone Recommendations for DHIS2 Java Mobile Client

2016-03-19 Thread Ted Johnson

Greetings from Madagascar. This is my first  post to the users group, and
I'm not officially a DHIS2 user yet.

I am interested in buying a Java phone for testing the DHIS2 Java Mobile
Client, along with other Java apps related to my work.

Here in the capitol, we have been unable to locate a Nokia S40 series phone
(which is what was recommended on the DHIS2 website). I would like a
recommendation for phone that is somewhat common in Africa.

Thanks in advance.


-- 
*Ted Johnson* | Media and Communications Manager

tjohn...@hni.org  | www.hni.org | www.DataWinners.com


http://www.facebook.com/humannetworkinternational
http://www.facebook.com/datawinners
@DataWinners 
___
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] restore database out of memory

Sorry Channara, I didn't read your question properly, this has nothing to
do with JAVA_OPTS.

Unfortunately, I have no experience with getting Postgres out of memory
errors, though google tells me a lot of people do.

Could it perhaps be that your hard drive is filling up?

On Fri, Mar 18, 2016 at 3:38 PM, channara rin 
wrote:

> here in java_opts=-Djava.awt.headless=true -Dfile.encoding=UTF-8 -server
> -Xms128m -Xmx1024m -XX:NewSize=2048m -XXMaxNewSize=2048m -XX:PermSize=256m
> -XX:MaxPermSize=1024m -XX:+DisableExplicitGC -xx:+UseConcMarkSweepGC
> -XX:+DisableExplicitGC
>
> On Fri, Mar 18, 2016 at 7:39 PM, Knut Staring  wrote:
>
>> Hi Channara,
>>
>> What values do you have for JAVA_OPTS?
>>
>> On Fri, Mar 18, 2016 at 1:10 PM, channara rin 
>> wrote:
>>
>>> hi all,
>>> do you hav any experience with postgresql database?
>>> i use command psql/pg_restore into new system. i got out of memory.
>>> my system server is 4GB memory and file backup size is around 100MB
>>>
>>> ___
>>> 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
>>
>
>


-- 
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] [Dhis2-devs] restore database out of memory