Re: [Dhis2-users] Report on time is showing Zero

[gerald thomas]

Please can someone help

On 2/19/17, gerald thomas <gerald17...@gmail.com> wrote:
> Dear All,
> I am wondering why the when i am running reporting rate summary i am
> getting zero value for "Report on time"
>
> Please help??
> --
> Regards,
>
> Gerald
>


-- 
Regards,

Gerald

___
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] Report on time is showing Zero

[gerald thomas]

Dear All,
I am wondering why the when i am running reporting rate summary i am
getting zero value for "Report on time"

Please help??
-- 
Regards,

Gerald

___
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] Pivot table report per Ages Distribution issue

[gerald thomas]

I already tried that but it not working. Using the "Total" option I am
getting values. I want to know why the "Details" option is not returning
values.

On Feb 16, 2017 07:44, "Kamugunga Adolphe" <kaa...@gmail.com> wrote:

> Hi Gerald,
> Clear you cache  then also check if your analytics run correctly and try
> to generate the pivot again selecting  'Details" option.
>
> Regards,
>
>
> *Adolphe Kamugunga*
> *MIS Technical Advisor*
> Mobile: +250 788 740 578 <+250%20788%20740%20578>
> Email:kaa...@gmail.com
> Skype: ka.adolphe
>  RWANDA
>
>
> On 16 February 2017 at 08:25, gerald thomas <gerald17...@gmail.com> wrote:
>
>> Dear All,
>> i have a monthly data set for hospitals by age distribution, when i
>> create a reporting rate summary for an organization unit which sends
>> report i am getting values (per age distribution) but when i generate
>> a pivot table for the same values i am getting no data
>>
>>
>> --
>> Regards,
>>
>> Gerald
>>
>> ___
>> 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] My DHIS2 Reports app not loading

[gerald thomas]

Kamugunga,
If he had provided the logs then that should had been easy to confirm but
currently the information seem like a bug on the war file. So the best
option is to replace the war file and monitor the logs. If it is a tomcat
issue it will definitely show on the logs.

On Feb 13, 2017 08:14, "Kamugunga Adolphe" <kaa...@gmail.com> wrote:

Dear Gerald,
This could be also related to your tomcat version, we had the similar issue
here in Rwanda with data visualizer, pivot and event report apps not
loading after upgrading to dhis 2.24. We have upgraded to our tomcat from
7.052  to  7.0.68 and it worked.

Please trace back Bob,Lars, and Jason discussion on the tomcat version for
the new dhis2 releases.

Regards.

*Adolphe Kamugunga*
*MIS Technical Advisor*
Mobile: +250 788 740 578 <+250%20788%20740%20578>
Email:kaa...@gmail.com
Skype: ka.adolphe
 RWANDA


On 13 February 2017 at 08:48, gerald thomas <gerald17...@gmail.com> wrote:

> Timothy,
> Please run maintenance and delete war file and name of folder which has
> the name of your war file. Download a new war and tail -f
> /path/Catalina.out if there is no error then everything should be fine.
> Kindly note I am saying "/path/" because I don't the path of your logs.
> Also tomcat must be stop before deleting war file and folder and "tail" the
> logs before starting tomcat.
> Wishing you the best.
>
> On Feb 13, 2017 06:26, "timothy kiyemba" <tkiye...@gmail.com> wrote:
>
>> Anybody with a solution to this problem?
>> --
>> From: Timothy Kiyemba <tkiye...@gmail.com>
>> Sent: ‎12/‎02/‎2017 21:59
>> To: dhis2-devs <dhis2-d...@lists.launchpad.net>; dhis2-users
>> <dhis2-users@lists.launchpad.net>
>> Subject: My DHIS2 Reports app not loading
>>
>> Dear all
>>
>> Has any one faced this challenge before, my DHIS2 reports app is not
>> loading. It just shows that its loading but it never completes. Could I
>> have missed out a step somewhere? See image below;
>>
>> [image: Inline image 1]
>>
>> ___
>> 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
>
>
___
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] My DHIS2 Reports app not loading

[gerald thomas]

Timothy,
Please run maintenance and delete war file and name of folder which has the
name of your war file. Download a new war and tail -f /path/Catalina.out if
there is no error then everything should be fine.
Kindly note I am saying "/path/" because I don't the path of your logs.
Also tomcat must be stop before deleting war file and folder and "tail" the
logs before starting tomcat.
Wishing you the best.

On Feb 13, 2017 06:26, "timothy kiyemba"  wrote:

> Anybody with a solution to this problem?
> --
> From: Timothy Kiyemba 
> Sent: ‎12/‎02/‎2017 21:59
> To: dhis2-devs ; dhis2-users
> 
> Subject: My DHIS2 Reports app not loading
>
> Dear all
>
> Has any one faced this challenge before, my DHIS2 reports app is not
> loading. It just shows that its loading but it never completes. Could I
> have missed out a step somewhere? See image below;
>
> [image: Inline image 1]
>
> ___
> 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] Visualizer issue

[gerald thomas]

Dear all,
I can't really tell what was the issue but after running maintenance &
analytics then change war file to the latest 2.25 war file the issue
was fixed. Everything is OK now. I actually didn't have time to look
at the 'browser console' again because i am afraid of the duration the
analytics will take.

I will keep you posted once those verification exercises are done.

On 2/8/17, Knut Staring <knu...@gmail.com> wrote:
> Hello all, what could be the issue with this message in the browser
> console?
>
> Line Number 1, Column 1:  ANALYTICSTABLE_UPDATE:1:1
> XML Parsing Error: syntax error
> Location:
> http://10.100.1.100:8080/api/system/tasks/ANALYTICSTABLE_UPDATE?lastId=StL6eohelA8
>
>
> On Tue, Feb 7, 2017 at 5:59 PM, gerald thomas <gerald17...@gmail.com>
> wrote:
>
>> Dear all,
>> I am trying to see if i could fix the error by running 'analytics' but
>> during my monitoring process using (shift + ctrl + j) i notice
>> something strange. Please find the attached file showing the error.
>>
>> On 2/7/17, gerald thomas <gerald17...@gmail.com> wrote:
>> > Dear All.
>> > I am using version 2.25 war file, build revision 3de90a5.
>> >
>> > On 2/7/17, gerald thomas <gerald17...@gmail.com> wrote:
>> >> Dear all,
>> >> On my local instance I am receiving an error. Please find the attached
>> >> print screen of the error.
>> >>
>> >
>> >
>> > --
>> > Regards,
>> >
>> > Gerald
>> >
>>
>>
>> --
>> Regards,
>>
>> Gerald
>>
>> ___
>> 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
>


-- 
Regards,

Gerald

___
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] Visualizer issue

[gerald thomas]

Dear All.
I am using version 2.25 war file, build revision 3de90a5.

On 2/7/17, gerald thomas <gerald17...@gmail.com> wrote:
> Dear all,
> On my local instance I am receiving an error. Please find the attached
> print screen of the error.
>


-- 
Regards,

Gerald

___
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] Tomcat error

[gerald thomas]

Good morning all,

Bob, at some point Calle was importing metadata but i don't know if
that should be an issue. I am currently monitoring the logs to see if
i will receive those errors again.

On 1/28/17, Seid Hussein <seid.h...@gmail.com> wrote:
> Hi Gerald,
>
> You can use the (insert if not exists) query to insert your data. But
> unlike the COPY function which allows bulk insert, you have to write an
> insert statement for each data value you intend to insert.
>
> Regards,
>
>
> Seid,
>
> On Saturday, January 28, 2017, Bob Jolliffe <bobjolli...@gmail.com> wrote:
>
>> where does the data come from that you try to import?
>>
>> On 28 January 2017 at 19:55, gerald thomas <gerald17...@gmail.com
>> <javascript:_e(%7B%7D,'cvml','gerald17...@gmail.com');>> wrote:
>>
>>> Funnily I Bob I only copied a section of the log, I have various
>>> dataelements ids & period ids which are sending those errors.
>>> So I am worried where are these errors coming from now.
>>>
>>> On Jan 28, 2017 7:31 PM, "Bob Jolliffe" <bobjolli...@gmail.com
>>> <javascript:_e(%7B%7D,'cvml','bobjolli...@gmail.com');>> wrote:
>>>
>>> Gerald the clue is in your error message:
>>>
>>> Detail: Key (dataelementid, periodid, sourceid,categoryoptioncomboid,
>>> attributeoptioncomboid)=(1973, 2784149, 301,13, 13) already exists.
>>>
>>> This usually means you have duplicates among the datavalues you are
>>> trying to import.  ie. more than one row with the key values as shown in
>>> your error message.
>>>
>>> On 28 January 2017 at 19:02, gerald thomas <gerald17...@gmail.com
>>> <javascript:_e(%7B%7D,'cvml','gerald17...@gmail.com');>> wrote:
>>>
>>>> Seid,
>>>> Thanks for your help but how can i identify those dataelements:
>>>>
>>>> So I suggest you either to use the web API and import through the
>>>> import/export module or find out which of the metadata IDs is
>>>> duplicate and correct it.
>>>>
>>>> On 1/28/17, Seid Hussein <seid.h...@gmail.com
>>>> <javascript:_e(%7B%7D,'cvml','seid.h...@gmail.com');>> wrote:
>>>> > Hi Gerald,
>>>> >
>>>> > I believe you're trying to import through the database rather than
>>>> > the
>>>> API
>>>> > which is a better option because of you've duplicate there the most
>>>> > probable action ta update rather than a duplicate error.
>>>> >
>>>> > Most probably what happened is you have duplicate metadata. Each data
>>>> value
>>>> > shall have a unique combination of data element id, period id, org
>>>> unit id,
>>>> > category option combo id, and attribute option combo id.
>>>> >
>>>> > So I suggest you either to use the web API and import through the
>>>> > import/export module or find out which of the metadata IDs is
>>>> duplicate and
>>>> > correct it.
>>>> >
>>>> > Regards,
>>>> >
>>>> >
>>>> > Seid,
>>>> >
>>>> > On Friday, January 27, 2017, gerald thomas <gerald17...@gmail.com
>>>> <javascript:_e(%7B%7D,'cvml','gerald17...@gmail.com');>> wrote:
>>>> >
>>>> >> Dear All,
>>>> >>
>>>> >> What is the meaning of this error:
>>>> >>
>>>> >> * ERROR 2017-01-05 12:03:07,593 ERROR: duplicate key value violates
>>>> >> unique constraint "datavalue_pkey"
>>>> >>   Detail: Key (dataelementid, periodid, sourceid,
>>>> >> categoryoptioncomboid, attributeoptioncomboid)=(1973, 2784149, 301,
>>>> >> 13, 13) already exists.
>>>> >>
>>>> >> Please find the attached copy of catalina.out log file
>>>> >>
>>>> >> --
>>>> >> Regards,
>>>> >>
>>>> >> Gerald
>>>> >>
>>>> >
>>>>
>>>>
>>>> --
>>>> Regards,
>>>>
>>>> Gerald
>>>>
>>>> ___
>>>> Mailing list: https://launchpad.net/~dhis2-users
>>>> Post to : dhis2-users@lists.launchpad.net
>>>> <javascript:_e(%7B%7D,'cvml','dhis2-users@lists.launchpad.net');>
>>>> Unsubscribe : https://launchpad.net/~dhis2-users
>>>> More help   : https://help.launchpad.net/ListHelp
>>>>
>>>
>>>
>>>
>>
>


-- 
Regards,

Gerald

___
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] Tomcat error

[gerald thomas]

Funnily I Bob I only copied a section of the log, I have various
dataelements ids & period ids which are sending those errors.
So I am worried where are these errors coming from now.

On Jan 28, 2017 7:31 PM, "Bob Jolliffe" <bobjolli...@gmail.com> wrote:

Gerald the clue is in your error message:

Detail: Key (dataelementid, periodid, sourceid,categoryoptioncomboid,
attributeoptioncomboid)=(1973, 2784149, 301,13, 13) already exists.

This usually means you have duplicates among the datavalues you are trying
to import.  ie. more than one row with the key values as shown in your
error message.

On 28 January 2017 at 19:02, gerald thomas <gerald17...@gmail.com> wrote:

> Seid,
> Thanks for your help but how can i identify those dataelements:
>
> So I suggest you either to use the web API and import through the
> import/export module or find out which of the metadata IDs is
> duplicate and correct it.
>
> On 1/28/17, Seid Hussein <seid.h...@gmail.com> wrote:
> > Hi Gerald,
> >
> > I believe you're trying to import through the database rather than the
> API
> > which is a better option because of you've duplicate there the most
> > probable action ta update rather than a duplicate error.
> >
> > Most probably what happened is you have duplicate metadata. Each data
> value
> > shall have a unique combination of data element id, period id, org unit
> id,
> > category option combo id, and attribute option combo id.
> >
> > So I suggest you either to use the web API and import through the
> > import/export module or find out which of the metadata IDs is duplicate
> and
> > correct it.
> >
> > Regards,
> >
> >
> > Seid,
> >
> > On Friday, January 27, 2017, gerald thomas <gerald17...@gmail.com>
> wrote:
> >
> >> Dear All,
> >>
> >> What is the meaning of this error:
> >>
> >> * ERROR 2017-01-05 12:03:07,593 ERROR: duplicate key value violates
> >> unique constraint "datavalue_pkey"
> >>   Detail: Key (dataelementid, periodid, sourceid,
> >> categoryoptioncomboid, attributeoptioncomboid)=(1973, 2784149, 301,
> >> 13, 13) already exists.
> >>
> >> Please find the attached copy of catalina.out log file
> >>
> >> --
> >> Regards,
> >>
> >> Gerald
> >>
> >
>
>
> --
> Regards,
>
> Gerald
>
> ___
> 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] Tomcat error

[gerald thomas]

Seid,
Thanks for your help but how can i identify those dataelements:

So I suggest you either to use the web API and import through the
import/export module or find out which of the metadata IDs is
duplicate and correct it.

On 1/28/17, Seid Hussein <seid.h...@gmail.com> wrote:
> Hi Gerald,
>
> I believe you're trying to import through the database rather than the API
> which is a better option because of you've duplicate there the most
> probable action ta update rather than a duplicate error.
>
> Most probably what happened is you have duplicate metadata. Each data value
> shall have a unique combination of data element id, period id, org unit id,
> category option combo id, and attribute option combo id.
>
> So I suggest you either to use the web API and import through the
> import/export module or find out which of the metadata IDs is duplicate and
> correct it.
>
> Regards,
>
>
> Seid,
>
> On Friday, January 27, 2017, gerald thomas <gerald17...@gmail.com> wrote:
>
>> Dear All,
>>
>> What is the meaning of this error:
>>
>> * ERROR 2017-01-05 12:03:07,593 ERROR: duplicate key value violates
>> unique constraint "datavalue_pkey"
>>   Detail: Key (dataelementid, periodid, sourceid,
>> categoryoptioncomboid, attributeoptioncomboid)=(1973, 2784149, 301,
>> 13, 13) already exists.
>>
>> Please find the attached copy of catalina.out log file
>>
>> --
>> Regards,
>>
>> Gerald
>>
>


-- 
Regards,

Gerald

___
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] Tomcat error

[gerald thomas]

Dear All,

What is the meaning of this error:

* ERROR 2017-01-05 12:03:07,593 ERROR: duplicate key value violates
unique constraint "datavalue_pkey"
  Detail: Key (dataelementid, periodid, sourceid,
categoryoptioncomboid, attributeoptioncomboid)=(1973, 2784149, 301,
13, 13) already exists.

Please find the attached copy of catalina.out log file

-- 
Regards,

Gerald


Part of catalina.out
Description: Binary data
___
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] Data Set Report is not Downloading

[gerald thomas]

Dear Elmarie,

I had done Data Integrity Checks but i don't know which option is
responsible for dataelements names with special characters. Besides we
had been doing data cleanup and we fixed most of those issues.

On 1/27/17, Elmarie Claasen <elma...@hisp.org> wrote:
> Gerald,
>
> We had the same problem so e toime back. Check that you dont have any
> special characters in dataelement names.
>
> Elmarie
>
> On 27 Jan 2017 14:29, "gerald thomas" <gerald17...@gmail.com> wrote:
>
>> Dear All,
>> We had successfully upgraded to version 2.25 but i noticed that we
>> can't download to excel or PDF our data set reports.
>>
>> Please i don't know if it is a bug but it is working on the DHIS2 demo
>> but not on our production server.
>>
>> Thanks in advance for your help.
>>
>> --
>> Regards,
>>
>> Gerald
>>
>> ___
>> 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
>>
>
> --
>
>
> *This message and any attachments are subject to a disclaimer published at
> http://www.hisp.org/policies.html#comms_disclaimer
> <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
> <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.*
>


-- 
Regards,

Gerald

___
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] Analytics table update process stucked

[gerald thomas]

Hi Karina,
Please share your postgres.conf file and your server specification.

On 1/27/17, Lars Helge Øverland  wrote:
> Hi Karina,
>
> it seems to be stuck on the dateperiodstructure resource table. Are you
> able to share the database privately?
>
>
> regards,
>
> Lars
>
>
> On Fri, Jan 27, 2017 at 12:28 PM, Karina Dian Lestari <
> karinadnl...@gmail.com> wrote:
>
>> Hi all,
>>
>> It's been two hours and analytic still stay like this.
>> [image: Inline images 1]
>>
>> This is on DHIS2 2.25.
>> I have done vacuum full and back-up the database before the process. The
>> back-up file is only 4378 KB, I don't think the analysis process should
>> take a long time.
>> Does anyone know how to solve this?
>>
>> Please find attached file to see analytic table log.
>>
>> Thank you very much.
>>
>> --
>> Best regards,
>> Karin.
>>
>> ___
>> 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
> l...@dhis2.org
> http://www.dhis2.org 
>


-- 
Regards,

Gerald

___
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] Data Set Report is not Downloading

[gerald thomas]

Dear All,
We had successfully upgraded to version 2.25 but i noticed that we
can't download to excel or PDF our data set reports.

Please i don't know if it is a bug but it is working on the DHIS2 demo
but not on our production server.

Thanks in advance for your help.

-- 
Regards,

Gerald

___
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] PostgreSQL-9.5 failed to boot-up at restart of Linux server

[gerald thomas]

Thanks to everyone for your support and help during the process though
we are experience what looks to be like bugs but that will be save for
another ticket while we verify and test all the various scenarios
within 2.25.

Once again thanks.

On 1/26/17, Calle Hedberg <calle.hedb...@gmail.com> wrote:
> Hi
>
> Gerald managed to get it all up and working again this afternoon +
> restoring the dump file (onto 9.5.5). So all good now  :-)
>
> Analytics run time dropped from 56 minutes to 17 minutes, which is
> equivalent to the time it takes on my laptop, so the upgrade was overdue...
>
> Regards
> Calle
>
> On 26 January 2017 at 12:46, Bob Jolliffe <bobjolli...@gmail.com> wrote:
>
>> Sounds like now you are really "waist deep in the big muddy".  You have
>> already had to scrap and reinstall your postgres and it looks like your
>> dhis2-tools package is also somehow missing or damaged.
>>
>> You have your backups.  scrap the machine and rebuild.  Follow
>> instruction
>> from https://github.com/dhis2/dhis2-tools.
>>
>> On 26 January 2017 at 10:30, gerald thomas <gerald17...@gmail.com> wrote:
>>
>>> Yes Bob,
>>> But i now i am having a major issue because i can't find the
>>> dhis2-startup, dhis2-stop or dhis2-status but the profile of the
>>> instance is available.
>>>
>>>
>>>
>>> On 1/26/17, Bob Jolliffe <bobjolli...@gmail.com> wrote:
>>> > what works?  you removed it and started again?
>>> >
>>> > On 26 January 2017 at 10:14, gerald thomas <gerald17...@gmail.com>
>>> wrote:
>>> >
>>> >> Bob,
>>> >> Thanks it is works
>>> >>
>>> >>
>>> >> On 1/26/17, Bob Jolliffe <bobjolli...@gmail.com> wrote:
>>> >> > Gerald it sounds like it has got into a bit of a mess and maybe you
>>> >> > risk
>>> >> > just making it worse.  It is really not supposed to be this hard,
>>> >> > but
>>> >> > tit
>>> >> > is next to impossible at a distance to figure out what might have
>>> gone
>>> >> > wrong.
>>> >> >
>>> >> > Given that you are not dependent on migrating the cluster, but that
>>> you
>>> >> are
>>> >> > simply going to restore your dbs, I would advise that you just try
>>> and
>>> >> get
>>> >> > rid of the current non-working postgres installation completely and
>>> >> install
>>> >> > it again.
>>> >> >
>>> >> > sudo apt-get purge postgresql ... etc  (check under /etc and
>>> >> > /var/lib
>>> >> that
>>> >> > all traces have truly gone)
>>> >> >
>>> >> > On 26 January 2017 at 08:42, gerald thomas <gerald17...@gmail.com>
>>> >> wrote:
>>> >> >
>>> >> >> Mutali,
>>> >> >> I think there was an issue where i have postgresql and
>>> postgresql-9.5
>>> >> >> inside /etc/init.d. But when this command: sudo update-rc.d
>>> >> >> postgresql-9.5 enable
>>> >> >>
>>> >> >> I am getting this message "update-rc.d: warning:
>>> >> >> /etc/init.d/postgresql-9.5 missing LSB information"
>>> >> >> >
>>> >> >>
>>> >> >> On 1/26/17, J. Paul Mutali <mut...@gmail.com> wrote:
>>> >> >> > Hi Gerald,
>>> >> >> >
>>> >> >> >  you can use this command: sudo update-rc.d postgresql enable
>>> >> >> >
>>> >> >> > Hope it will work for you.
>>> >> >> >
>>> >> >> > ---
>>> >> >> >
>>> >> >> > JP Mutali
>>> >> >> >
>>> >> >> > Kigali - Rwanda
>>> >> >> >
>>> >> >> > On Thu, Jan 26, 2017 at 8:52 AM, gerald thomas
>>> >> >> > <gerald17...@gmail.com
>>> >> >
>>> >> >> > wrote:
>>> >> >> >
>>> >> >> >> There were some issues with the migration so I had to purge the
>>> 9.3
>>> >> >> >> and
>>> >> >> >> do
>>>

Re: [Dhis2-users] [Dhis2-devs] PostgreSQL-9.5 failed to boot-up at restart of Linux server

[gerald thomas]

Yes Bob,
But i now i am having a major issue because i can't find the
dhis2-startup, dhis2-stop or dhis2-status but the profile of the
instance is available.



On 1/26/17, Bob Jolliffe <bobjolli...@gmail.com> wrote:
> what works?  you removed it and started again?
>
> On 26 January 2017 at 10:14, gerald thomas <gerald17...@gmail.com> wrote:
>
>> Bob,
>> Thanks it is works
>>
>>
>> On 1/26/17, Bob Jolliffe <bobjolli...@gmail.com> wrote:
>> > Gerald it sounds like it has got into a bit of a mess and maybe you
>> > risk
>> > just making it worse.  It is really not supposed to be this hard, but
>> > tit
>> > is next to impossible at a distance to figure out what might have gone
>> > wrong.
>> >
>> > Given that you are not dependent on migrating the cluster, but that you
>> are
>> > simply going to restore your dbs, I would advise that you just try and
>> get
>> > rid of the current non-working postgres installation completely and
>> install
>> > it again.
>> >
>> > sudo apt-get purge postgresql ... etc  (check under /etc and /var/lib
>> that
>> > all traces have truly gone)
>> >
>> > On 26 January 2017 at 08:42, gerald thomas <gerald17...@gmail.com>
>> wrote:
>> >
>> >> Mutali,
>> >> I think there was an issue where i have postgresql and postgresql-9.5
>> >> inside /etc/init.d. But when this command: sudo update-rc.d
>> >> postgresql-9.5 enable
>> >>
>> >> I am getting this message "update-rc.d: warning:
>> >> /etc/init.d/postgresql-9.5 missing LSB information"
>> >> >
>> >>
>> >> On 1/26/17, J. Paul Mutali <mut...@gmail.com> wrote:
>> >> > Hi Gerald,
>> >> >
>> >> >  you can use this command: sudo update-rc.d postgresql enable
>> >> >
>> >> > Hope it will work for you.
>> >> >
>> >> > ---
>> >> >
>> >> > JP Mutali
>> >> >
>> >> > Kigali - Rwanda
>> >> >
>> >> > On Thu, Jan 26, 2017 at 8:52 AM, gerald thomas
>> >> > <gerald17...@gmail.com
>> >
>> >> > wrote:
>> >> >
>> >> >> There were some issues with the migration so I had to purge the 9.3
>> >> >> and
>> >> >> do
>> >> >> a fresh installation of 9.5 and restore my backup. But if the
>> >> >> server
>> >> >> reboot
>> >> >> I will have to manually do:
>> >> >> pg_ctlcluster 9.5 main start
>> >> >>
>> >> >>
>> >> >>
>> >> >>
>> >> >>
>> >> >> On Jan 26, 2017 5:59 AM, "Uwe Wahser" <u...@wahser.de> wrote:
>> >> >>
>> >> >> Hi Gerald,
>> >> >>
>> >> >> we did the upgrade while upgrading to Ubuntu 16.04 and everything
>> >> >> starts
>> >> >> normally. But you have to manually migrate your 9.3 databases into
>> the
>> >> >> 9.5
>> >> >> format - did you do that?
>> >> >>
>> >> >> These were the bash commands I recorded back then (at your own
>> >> >> risk,
>> >> >> no
>> >> >> guarantee - do backups and all that first)
>> >> >>
>> >> >> ~/tomcat-dhis/bin/shutdown.sh
>> >> >> sudo pg_dropcluster 9.5 main --stop
>> >> >> sudo pg_upgradecluster 9.3 main
>> >> >> pg_lsclusters
>> >> >> sudo pg_dropcluster 9.3 main
>> >> >>
>> >> >> Hope that helps,
>> >> >>
>> >> >> Uwe
>> >> >>
>> >> >> ---
>> >> >>
>> >> >> > gerald thomas <gerald17...@gmail.com> hat am 26. Januar 2017 um
>> >> >> > 01:38
>> >> >> geschrieben:
>> >> >> >
>> >> >> >
>> >> >> > Dear All,
>> >> >> > We are upgrading DHIS2 server database (PostgreSQL from 9.3.15 to
>> >> >> > 9.5.5) and it had been successfully done but the Postgres does
>> >> >> > not
>> >> >> > automatically start after boot-up. I am using: (pg_ctlcluster 9.5
>> >> >> > main
>> >> >> > start) to start my database but i want it start automatically.
>> >> >> >
>> >> >> > Please can someone help me?
>> >> >> >
>> >> >> > --
>> >> >> > Regards,
>> >> >> >
>> >> >> > Gerald
>> >> >> >
>> >> >> > ___
>> >> >> > 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-devs
>> >> >> Post to : dhis2-d...@lists.launchpad.net
>> >> >> Unsubscribe : https://launchpad.net/~dhis2-devs
>> >> >> More help   : https://help.launchpad.net/ListHelp
>> >> >>
>> >> >>
>> >> >
>> >>
>> >>
>> >> --
>> >> Regards,
>> >>
>> >> Gerald
>> >>
>> >> ___
>> >> 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
>> >>
>> >
>>
>>
>> --
>> Regards,
>>
>> Gerald
>>
>


-- 
Regards,

Gerald

___
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] PostgreSQL-9.5 failed to boot-up at restart of Linux server

[gerald thomas]

Bob,
Thanks it is works


On 1/26/17, Bob Jolliffe <bobjolli...@gmail.com> wrote:
> Gerald it sounds like it has got into a bit of a mess and maybe you risk
> just making it worse.  It is really not supposed to be this hard, but tit
> is next to impossible at a distance to figure out what might have gone
> wrong.
>
> Given that you are not dependent on migrating the cluster, but that you are
> simply going to restore your dbs, I would advise that you just try and get
> rid of the current non-working postgres installation completely and install
> it again.
>
> sudo apt-get purge postgresql ... etc  (check under /etc and /var/lib that
> all traces have truly gone)
>
> On 26 January 2017 at 08:42, gerald thomas <gerald17...@gmail.com> wrote:
>
>> Mutali,
>> I think there was an issue where i have postgresql and postgresql-9.5
>> inside /etc/init.d. But when this command: sudo update-rc.d
>> postgresql-9.5 enable
>>
>> I am getting this message "update-rc.d: warning:
>> /etc/init.d/postgresql-9.5 missing LSB information"
>> >
>>
>> On 1/26/17, J. Paul Mutali <mut...@gmail.com> wrote:
>> > Hi Gerald,
>> >
>> >  you can use this command: sudo update-rc.d postgresql enable
>> >
>> > Hope it will work for you.
>> >
>> > ---
>> >
>> > JP Mutali
>> >
>> > Kigali - Rwanda
>> >
>> > On Thu, Jan 26, 2017 at 8:52 AM, gerald thomas <gerald17...@gmail.com>
>> > wrote:
>> >
>> >> There were some issues with the migration so I had to purge the 9.3
>> >> and
>> >> do
>> >> a fresh installation of 9.5 and restore my backup. But if the server
>> >> reboot
>> >> I will have to manually do:
>> >> pg_ctlcluster 9.5 main start
>> >>
>> >>
>> >>
>> >>
>> >>
>> >> On Jan 26, 2017 5:59 AM, "Uwe Wahser" <u...@wahser.de> wrote:
>> >>
>> >> Hi Gerald,
>> >>
>> >> we did the upgrade while upgrading to Ubuntu 16.04 and everything
>> >> starts
>> >> normally. But you have to manually migrate your 9.3 databases into the
>> >> 9.5
>> >> format - did you do that?
>> >>
>> >> These were the bash commands I recorded back then (at your own risk,
>> >> no
>> >> guarantee - do backups and all that first)
>> >>
>> >> ~/tomcat-dhis/bin/shutdown.sh
>> >> sudo pg_dropcluster 9.5 main --stop
>> >> sudo pg_upgradecluster 9.3 main
>> >> pg_lsclusters
>> >> sudo pg_dropcluster 9.3 main
>> >>
>> >> Hope that helps,
>> >>
>> >> Uwe
>> >>
>> >> ---
>> >>
>> >> > gerald thomas <gerald17...@gmail.com> hat am 26. Januar 2017 um
>> >> > 01:38
>> >> geschrieben:
>> >> >
>> >> >
>> >> > Dear All,
>> >> > We are upgrading DHIS2 server database (PostgreSQL from 9.3.15 to
>> >> > 9.5.5) and it had been successfully done but the Postgres does not
>> >> > automatically start after boot-up. I am using: (pg_ctlcluster 9.5
>> >> > main
>> >> > start) to start my database but i want it start automatically.
>> >> >
>> >> > Please can someone help me?
>> >> >
>> >> > --
>> >> > Regards,
>> >> >
>> >> > Gerald
>> >> >
>> >> > ___
>> >> > 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-devs
>> >> Post to : dhis2-d...@lists.launchpad.net
>> >> Unsubscribe : https://launchpad.net/~dhis2-devs
>> >> More help   : https://help.launchpad.net/ListHelp
>> >>
>> >>
>> >
>>
>>
>> --
>> Regards,
>>
>> Gerald
>>
>> ___
>> 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
>>
>


-- 
Regards,

Gerald

___
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] PostgreSQL-9.5 failed to boot-up at restart of Linux server

[gerald thomas]

Mutali,
I think there was an issue where i have postgresql and postgresql-9.5
inside /etc/init.d. But when this command: sudo update-rc.d
postgresql-9.5 enable

I am getting this message "update-rc.d: warning:
/etc/init.d/postgresql-9.5 missing LSB information"
>

On 1/26/17, J. Paul Mutali <mut...@gmail.com> wrote:
> Hi Gerald,
>
>  you can use this command: sudo update-rc.d postgresql enable
>
> Hope it will work for you.
>
> ---
>
> JP Mutali
>
> Kigali - Rwanda
>
> On Thu, Jan 26, 2017 at 8:52 AM, gerald thomas <gerald17...@gmail.com>
> wrote:
>
>> There were some issues with the migration so I had to purge the 9.3 and
>> do
>> a fresh installation of 9.5 and restore my backup. But if the server
>> reboot
>> I will have to manually do:
>> pg_ctlcluster 9.5 main start
>>
>>
>>
>>
>>
>> On Jan 26, 2017 5:59 AM, "Uwe Wahser" <u...@wahser.de> wrote:
>>
>> Hi Gerald,
>>
>> we did the upgrade while upgrading to Ubuntu 16.04 and everything starts
>> normally. But you have to manually migrate your 9.3 databases into the
>> 9.5
>> format - did you do that?
>>
>> These were the bash commands I recorded back then (at your own risk, no
>> guarantee - do backups and all that first)
>>
>> ~/tomcat-dhis/bin/shutdown.sh
>> sudo pg_dropcluster 9.5 main --stop
>> sudo pg_upgradecluster 9.3 main
>> pg_lsclusters
>> sudo pg_dropcluster 9.3 main
>>
>> Hope that helps,
>>
>> Uwe
>>
>> ---
>>
>> > gerald thomas <gerald17...@gmail.com> hat am 26. Januar 2017 um 01:38
>> geschrieben:
>> >
>> >
>> > Dear All,
>> > We are upgrading DHIS2 server database (PostgreSQL from 9.3.15 to
>> > 9.5.5) and it had been successfully done but the Postgres does not
>> > automatically start after boot-up. I am using: (pg_ctlcluster 9.5 main
>> > start) to start my database but i want it start automatically.
>> >
>> > Please can someone help me?
>> >
>> > --
>> > Regards,
>> >
>> > Gerald
>> >
>> > ___
>> > 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-devs
>> Post to : dhis2-d...@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-devs
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>


-- 
Regards,

Gerald

___
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] PostgreSQL-9.5 failed to boot-up at restart of Linux server

[gerald thomas]

I already tried that and restart server but the issue is the same.

On Jan 26, 2017 7:27 AM, "J. Paul Mutali" <mut...@gmail.com> wrote:

> Hi Gerald,
>
>  you can use this command: sudo update-rc.d postgresql enable
>
> Hope it will work for you.
>
> ---
>
> JP Mutali
>
> Kigali - Rwanda
>
> On Thu, Jan 26, 2017 at 8:52 AM, gerald thomas <gerald17...@gmail.com>
> wrote:
>
>> There were some issues with the migration so I had to purge the 9.3 and
>> do a fresh installation of 9.5 and restore my backup. But if the server
>> reboot I will have to manually do:
>> pg_ctlcluster 9.5 main start
>>
>>
>>
>>
>>
>> On Jan 26, 2017 5:59 AM, "Uwe Wahser" <u...@wahser.de> wrote:
>>
>> Hi Gerald,
>>
>> we did the upgrade while upgrading to Ubuntu 16.04 and everything starts
>> normally. But you have to manually migrate your 9.3 databases into the 9.5
>> format - did you do that?
>>
>> These were the bash commands I recorded back then (at your own risk, no
>> guarantee - do backups and all that first)
>>
>> ~/tomcat-dhis/bin/shutdown.sh
>> sudo pg_dropcluster 9.5 main --stop
>> sudo pg_upgradecluster 9.3 main
>> pg_lsclusters
>> sudo pg_dropcluster 9.3 main
>>
>> Hope that helps,
>>
>> Uwe
>>
>> ---
>>
>> > gerald thomas <gerald17...@gmail.com> hat am 26. Januar 2017 um 01:38
>> geschrieben:
>> >
>> >
>> > Dear All,
>> > We are upgrading DHIS2 server database (PostgreSQL from 9.3.15 to
>> > 9.5.5) and it had been successfully done but the Postgres does not
>> > automatically start after boot-up. I am using: (pg_ctlcluster 9.5 main
>> > start) to start my database but i want it start automatically.
>> >
>> > Please can someone help me?
>> >
>> > --
>> > Regards,
>> >
>> > Gerald
>> >
>> > ___
>> > 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-devs
>> Post to : dhis2-d...@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-devs
>> 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] PostgreSQL-9.5 failed to boot-up at restart of Linux server

[gerald thomas]

There were some issues with the migration so I had to purge the 9.3 and do
a fresh installation of 9.5 and restore my backup. But if the server reboot
I will have to manually do:
pg_ctlcluster 9.5 main start





On Jan 26, 2017 5:59 AM, "Uwe Wahser" <u...@wahser.de> wrote:

Hi Gerald,

we did the upgrade while upgrading to Ubuntu 16.04 and everything starts
normally. But you have to manually migrate your 9.3 databases into the 9.5
format - did you do that?

These were the bash commands I recorded back then (at your own risk, no
guarantee - do backups and all that first)

~/tomcat-dhis/bin/shutdown.sh
sudo pg_dropcluster 9.5 main --stop
sudo pg_upgradecluster 9.3 main
pg_lsclusters
sudo pg_dropcluster 9.3 main

Hope that helps,

Uwe

---

> gerald thomas <gerald17...@gmail.com> hat am 26. Januar 2017 um 01:38
geschrieben:
>
>
> Dear All,
> We are upgrading DHIS2 server database (PostgreSQL from 9.3.15 to
> 9.5.5) and it had been successfully done but the Postgres does not
> automatically start after boot-up. I am using: (pg_ctlcluster 9.5 main
> start) to start my database but i want it start automatically.
>
> Please can someone help me?
>
> --
> Regards,
>
> Gerald
>
> ___
> 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] PostgreSQL-9.5 failed to boot-up at restart of Linux server

[gerald thomas]

Dear All,
We are upgrading DHIS2 server database (PostgreSQL from 9.3.15 to
9.5.5) and it had been successfully done but the Postgres does not
automatically start after boot-up. I am using: (pg_ctlcluster 9.5 main
start) to start my database but i want it start automatically.

Please can someone help me?

-- 
Regards,

Gerald

___
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] DHIS2-JIRA mini Getting Started doc

[gerald thomas]

Dear Lars,
How can someone have access to DHIS2-JIRA files or questions?

On Jan 2, 2017 7:18 AM, "Lars Helge Øverland"  wrote:

> Hi Sam,
>
> it seems this is not so easy and requires you to be a Jira administrator:
>
> https://confluence.atlassian.com/jira064/managing-groups-720412316.html
>
> We don't plan to grant admin rights at this point but let us know if you
> find a more clever way of achieving this ;)
>
> Lars
>
>
>
>
> On Mon, Jan 2, 2017 at 4:49 AM, Sam Johnson 
> wrote:
>
>> Hi Rachael/Devs,
>>
>>
>>
>> Am just following up on the query below – is it at all possible to enable
>> creation of private user groups within the DHIS2 Jira instance?
>>
>>
>>
>> Regards, Sam.
>>
>>
>>
>>
>>
>> *From: *Dhis2-devs > qebo.co...@lists.launchpad.net> on behalf of Sam Johnson <
>> samuel.john...@qebo.co.uk>
>> *Date: *Tuesday, 6 December 2016 at 00:52
>> *To: *Rachael Brooke , DHIS 2 Users list <
>> dhis2-users@lists.launchpad.net>, DHIS2 Developers <
>> dhis2-d...@lists.launchpad.net>
>> *Cc: *Juan Manuel Alcantara Acosta , Rodolfo
>> Melia 
>> *Subject: *Re: [Dhis2-devs] [Dhis2-users] DHIS2-JIRA mini Getting
>> Started doc
>>
>>
>>
>> Hi Rachael,
>>
>>
>>
>> I just wanted to congratulate the team on successfully migrating to Jira
>> – it’s a great system, and will make feedback and collaboration around
>> DHIS2 even easier.  (I’ve just set up a custom Kanban dashboard for PSI to
>> monitor 2.25 bug-testing, which was very easy to do.)
>>
>>
>>
>> One quick request: would it be possible to enable ordinary users to set
>> up custom user groups?  In order for PSI team members to be able to see
>> this Kanban dashboard, I’ve had to open it up to ‘all logged-in users’,
>> whereas I’m guessing things will very quickly get very cluttered if
>> everyone can see everyone else’s dashboards…  Would it be possible for us
>> to set up custom user groups, so we can share our custom filters and
>> dashboards within a smaller set of users?
>>
>>
>>
>> Cheers, Sam.
>>
>>
>>
>>
>>
>> *From: *Dhis2-users > qebo.co...@lists.launchpad.net> on behalf of Rachael Brooke <
>> rach...@dhis2.org>
>> *Date: *Monday, 28 November 2016 at 12:05
>> *To: *DHIS 2 Users list , DHIS2
>> Developers 
>> *Subject: *[Dhis2-users] DHIS2-JIRA mini Getting Started doc
>>
>>
>>
>> Dear all,
>>
>>
>>
>> As announced previously, we've shifted over to JIRA
>>  for issue tracking.
>>
>>
>>
>> Here's a mini JIRA guide we've compiled for you: Using DHIS2-JIRA for
>> issue tracking
>> 
>> .
>>
>>
>>
>> Best regards,
>>
>> DHIS2 content team 
>>
>>
>>
>> *rach...@dhis2.org *
>>
>> *ceci...@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
> l...@dhis2.org
> 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

Re: [Dhis2-users] DHIS2.24 linking to a wrong database

[gerald thomas]

Absolom,
Kindly check the hibernate.properties or dhis.conf file again. It is
responsible to point DHIS2 to the right database.

On 10/27/16, Absolom MURAMIRA  wrote:
> Dear All,
> I am setting up DHIS2 to run on Ubuntu 16.04 server and PostgreSQL database
> but after setting up all the configuration settings in the dhis.conf and
> exporting the environmental variables in the tomcat-dhis instance, it still
> points to a different H2 database
> (dhis2;DB_CLOSE_DELAY=-1;MVCC=TRUE;ALIAS_COLUMN_NAME=TRUE;DB_CLOSE_ON_EXIT=FALSE)
> and a mysterious user (sa) database type DhisH2. This causes the system to
> loose all the data up on restart. This issue was raised by some one early
> this year but unfortunately i cannot find a solution. If anyone knows the
> solution, please support me.
> Thank you.
> Absolom
>


-- 
Regards,

Gerald

___
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] Looking for Human Resource System to integrate with DHIS

[gerald thomas]

e norm, there can be no progress***
>>>>>> *(Frank Zappa)*
>>>>>> *Skype* arthur_heywood_za
>>>>>> Tanzania* +255-773669393 OR +255 673150252
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>> On 26 August 2016 at 23:08, Calle Hedberg <calle.hedb...@gmail.com>
>>>>>> wrote:
>>>>>>
>>>>>>> Laura,
>>>>>>>
>>>>>>> The two main HRIS component designs "within" DHIS2 are the HRHIS in
>>>>>>> Tanzania and another in Vietnam (John Lewis or Morten will be able to
>>>>>>> tell
>>>>>>> you more about that one).
>>>>>>>
>>>>>>> South Africa is currently using a customised Tracker app for
>>>>>>> managing
>>>>>>> Community Service and Internships (around 10,000 graduates are
>>>>>>> applying for
>>>>>>> internship or Community Service posts per annum).
>>>>>>>
>>>>>>> We are also working on a "core" workforce registry tightly
>>>>>>> integrated
>>>>>>> with DHIS2. By "core" I mean it will only deal with actual HR
>>>>>>> resources
>>>>>>> including position, what they are licensed/authorised to do, and
>>>>>>> contact
>>>>>>> details. Things like continuous education, bursaries, payroll, etc
>>>>>>> are
>>>>>>> processed/managed by other systems. A major advantage of tight
>>>>>>> integration
>>>>>>> will be the ability to use DHIS2 communication and messages + user
>>>>>>> registration to communicate directly with health workers - in
>>>>>>> particular
>>>>>>> since health workers increasingly will be interacting directly with
>>>>>>> DHIS2
>>>>>>> on a daily basis through (daily) capturing of routine data, disease
>>>>>>> notifications, various Tracker apps (browser or Android), etc.
>>>>>>>
>>>>>>> Your basic requirements seem very similar: your primary need is to
>>>>>>> track the workforce as an INPUT RESOURCE to health service delivery,
>>>>>>> and
>>>>>>> not to track salaries and CVs and health insurance and employment
>>>>>>> history
>>>>>>> and a bunch of other "personal" things. So you need to know WHO they
>>>>>>> are,
>>>>>>> where they actually work and with what (in what position), what they
>>>>>>> are
>>>>>>> able to do (mostly this relates to formal/legal practice licensing
>>>>>>> etc, but
>>>>>>> it could be expanded to include specialist knowledge about certain
>>>>>>> diseases
>>>>>>> etc), and how to contact them.
>>>>>>>
>>>>>>> Regards
>>>>>>> Calle
>>>>>>>
>>>>>>> On 26 August 2016 at 21:56, gerald thomas <gerald17...@gmail.com>
>>>>>>> wrote:
>>>>>>>
>>>>>>>> I had use ihris and it is good. If you want help with it I am
>>>>>>>> willing to help.
>>>>>>>>
>>>>>>>> On Aug 26, 2016 6:46 PM, "Laura E. Lincks" <
>>>>>>>> laura.lin...@icap.columbia.edu> wrote:
>>>>>>>>
>>>>>>>>> We are looking for a simple Human Resources tool to integrate with
>>>>>>>>> a DHIS aggregate database. Little is known of the needs of the
>>>>>>>>> HRIS, but
>>>>>>>>> for now it needs to track personnel details and groups of personnel
>>>>>>>>> will
>>>>>>>>> need to be associated with various programs in a separate DHIS
>>>>>>>>> aggregate
>>>>>>>>> database. An Open Source HRIS is preferable.
>>>>>>>>>
>>>>>>>>> In search

Re: [Dhis2-users] [Dhis2-devs] Looking for Human Resource System to integrate with DHIS

[gerald thomas]

Hi all,
In Sierra Leone we successfully deployed both applications and it was a
success but we had an intermediary connection which is the facility
register, which is this case helps us to synchronize the facility list
between both applications. Normally, iHRIS gives the full background
information of staff within each facilities which can be useful for
analysis during disease outbreak or even as part an indicator.
Furthermore, our iHRIS was empowered using mHERO, which is two-way SMS
connection between iHRIS and health workers. They could update their
profile in iHRIS or receive alter of outbreak or even medical instructions
from their leads.

On Oct 8, 2016 5:45 AM, "Bob Jolliffe" <bobjolli...@gmail.com> wrote:

> Hi Arthur
>
> Carl will probably be able to point you to various cases where this
> has been done with dhis2 and ihris.  I am familiar with examples from
> Zanzibar, Kenya and Rwanda which sort of worked but none of which
> could fairly be described as successful in the sense of sustained use
> as far as I know.
>
> I think the main tricky bit to get right is the harmonization of
> health facilities in the two systems not just as one off, but with
> processes to keep them harmonized.  You might only have 20 indicators
> of interest but you have 1000s of facilities.  As soon as the orgunits
> start diverging the interoperability starts falling apart.  I think
> there was also some interesting work done in Bihar on this problem.
>
> One conventionasl "wisdom" that has done the rounds over the past few
> years is that a separate facility registry is the solution to this.  I
> am less sure.  In practice you now find that whereas before the
> problem was harmonizing between 2 systems, now it becomes more complex
> because you have 3 :-)  Add more with LMIS etc ..
>
> So 2 alternative approaches emerge:
> 1. retreat to dhis2 and try and do everything there - sometimes this
> sort of works for many things (which is better than most), but it has
> obvious limits and I don't believe can serve as the basis of long term
> strategy to solve all problems
> 2.  insist that any system that sends data to dhis2 treats dhis2 as
> the authoritative source of facility registry data.  If only they
> would :-)  Unfortunately dhis2 view of the
> physical/geographic/administrative world of the health system can
> diverge sometimes significantly from that of an HRIS system - think of
> MOH employees at offices not involved in health service delivery for
> example.  So there are local arrangements and understandings to be
> made, but in general I think this path holds the most potential,
>
> In practice I think we have to concede the problems have been unsolved
> for now.  Unless someone can point me otherwise.  The challenge seems
> on the surface to be technically fairly trivial,  But beneath lurk
> demons.
>
> Cheers
> Bob
>
> On 8 October 2016 at 07:13, Arthur Heywood <arthurheyw...@gmail.com>
> wrote:
> > Lungo
> > Good to hear from you ... long time no see
> > Thanks for this  can you tell me where we have a SUCCESSFUL
> > implementation where one can actually get IHRIS data through DHIS and
> make
> > integrated indicators, use IHRIS indicators for Bottleneck analysis etc
> >
> > Regards
> > Arthur
> >
> > **Without deviation from the norm, there can be no progress* *(Frank
> Zappa)
> > *Skype* arthur_heywood_za
> > Tanzania* +255-773669393 OR +255 673150252
> >
> >
> >
> >
> >
> >
> >
> >
> >
> > On 5 October 2016 at 06:54, Juma Lungo <jlu...@yahoo.com> wrote:
> >>
> >> Hi Arthur,
> >>
> >> I would recommend iHRIS.
> >>
> >> It has many features, integrates nicely with DHIS2, implemented in many
> >> countries and it is being supported by an active community working
> closely
> >> with DHIS2 developers.
> >>
> >> Lungo
> >>
> >>
> >> 
> >> From: Calle Hedberg <calle.hedb...@gmail.com>
> >> To: Arthur Heywood <arthurheyw...@gmail.com>
> >> Cc: dhis2-users <dhis2-users@lists.launchpad.net>; dhis2-devs
> >> <dhis2-d...@lists.launchpad.net>; gerald thomas <gerald17...@gmail.com
> >;
> >> Seleman Ally <seleman_a...@yahoo.com>
> >> Sent: Tuesday, October 4, 2016 10:20 PM
> >> Subject: Re: [Dhis2-devs] [Dhis2-users] Looking for Human Resource
> System
> >> to integrate with DHIS
> >>
> >> Arthur,
> >>
> >> I'm not directly involved with the HRIS work using DHIS, my current
> focus
> >> is on a fully i

[Dhis2-users] Creation of DHIS2 Team on Slack

[gerald thomas]

Dear All,
I will appreciate if we can create a DHIS2 Team on Slack. It is easier
and a much more faster response forum. It is a messenger also which
makes it instantaneous. Please DHIS2 users i will like to have your
opinion on this.
-- 
Regards,

Gerald

___
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] Existing 2.23 event forms do not work in 2.24 (Only the reporting date field is visualized)

[gerald thomas]

Yes Pedro, you are right. My question is did you ran that script when your
war file was 2.22? It seem like the issue is with the database; so please
share the various log files.

On Thursday, September 8, 2016,  wrote:

> Yes but up to my knowledge this is a upgrade note from 2.22 to 2.23 not
> from 2.23
> to 2.24. In fact the upgrade note of the 2.24 version does not mention
> nothing
> about the need of running any script.
>
> Best, Pedro
>
> > Dear Pedro,
> > Did you read the upgrade notes: https://www.dhis2.org/223-upgrade.
> >
> > There is an SQL upgrade script you need to run before moving to 2.24
> >
> > On Sep 8, 2016 7:24 AM, > wrote:
> >
> >> Hi,
> >>
> >> I upgraded to 2.24 by deploying the war file and using the existing
> DHIS2
> >> database.
> >>
> >> Best, Pedro
> >>
> >>
> >> > Pedro,
> >> > Can you be more specific, did you upgrade to 2.24 or are you running a
> >> new
> >> > instance on 2.24 but with the same forms??
> >> >
> >> > On Sep 8, 2016 7:16 AM, > wrote:
> >> >
> >> >> Good morning,
> >> >>
> >> >> We have a set of forms (Created by default from a set of programs
> >> without
> >> >> registration, i.e. events) working in DHIS 2.23 (Event capture).
> >> >>
> >> >> We installed DHIS 2.24 over the existing 2.23 database schema, but
> then
> >> >> none of
> >> >> the previous forms works. When we enter to any form, the screen only
> >> shows
> >> >> the
> >> >> field 'reporting date' and ignores the rest of fields and sections.
> >> >>
> >> >> What could be the problem?
> >> >>
> >> >> Best regards,
> >> >>
> >> >> Pedro González
> >> >> UPC-BarcelonaTech
> >> >>
> >> >>
> >> >> ___
> >> >> 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
> >> >>
> >> >
> >>
> >>
> >>
> >
>
>
>

-- 
Regards,

Gerald
___
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] Existing 2.23 event forms do not work in 2.24 (Only the reporting date field is visualized)

[gerald thomas]

Dear Pedro,
Did you read the upgrade notes: https://www.dhis2.org/223-upgrade.

There is an SQL upgrade script you need to run before moving to 2.24

On Sep 8, 2016 7:24 AM,  wrote:

> Hi,
>
> I upgraded to 2.24 by deploying the war file and using the existing DHIS2
> database.
>
> Best, Pedro
>
>
> > Pedro,
> > Can you be more specific, did you upgrade to 2.24 or are you running a
> new
> > instance on 2.24 but with the same forms??
> >
> > On Sep 8, 2016 7:16 AM,  wrote:
> >
> >> Good morning,
> >>
> >> We have a set of forms (Created by default from a set of programs
> without
> >> registration, i.e. events) working in DHIS 2.23 (Event capture).
> >>
> >> We installed DHIS 2.24 over the existing 2.23 database schema, but then
> >> none of
> >> the previous forms works. When we enter to any form, the screen only
> shows
> >> the
> >> field 'reporting date' and ignores the rest of fields and sections.
> >>
> >> What could be the problem?
> >>
> >> Best regards,
> >>
> >> Pedro González
> >> UPC-BarcelonaTech
> >>
> >>
> >> ___
> >> 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] Dashboard Error

[gerald thomas]

Dear All,
On my version 2.5, whenever i click "Dashboard" i am receiving an
error. Please find the attached error.

Kindly note that i am accessing all possibilities for a smooth upgrade
of war file version.

-- 
Regards,

Gerald
Title: DHIS 2




An exception occurred

Sorry! The system failed to execute the operation. Usually, no data 
is lost and you can continue working by going back to the previous page.
 If you wish to report the incident, please save this page by choosing 
"File -> Save (page as)" in your browser and include the saved page 
in the report. The problem details are listed below.


  
  [-]
Exception (org.hibernate.exception.SQLGrammarException):
  could not execute query
  
  

  org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:92)
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
org.hibernate.loader.Loader.doList(Loader.java:2536)
org.hibernate.loader.Loader.listUsingQueryCache(Loader.java:2319)
org.hibernate.loader.Loader.list(Loader.java:2268)
org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:119)
org.hibernate.impl.SessionImpl.list(SessionImpl.java:1716)
org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:347)
org.hisp.dhis.hibernate.HibernateGenericStore.getAll(HibernateGenericStore.java:259)
org.hisp.dhis.chart.impl.DefaultChartService.getAllCharts(DefaultChartService.java:1053)
sun.reflect.NativeMethodAccessorImpl.invoke0(NativeMethodAccessorImpl.java:-2)
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
java.lang.reflect.Method.invoke(Method.java:498)
org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)
org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:90)
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
com.sun.proxy.$Proxy61.getAllCharts(Unknown source)
org.hisp.dhis.dashboard.action.ProvideContentAction.execute(ProvideContentAction.java:132)
sun.reflect.NativeMethodAccessorImpl.invoke0(NativeMethodAccessorImpl.java:-2)
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
java.lang.reflect.Method.invoke(Method.java:498)
com.opensymphony.xwork2.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:452)
com.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocation.java:291)
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:254)
org.hisp.dhis.webportal.interceptor.XWorkPortalUserInterceptor.intercept(XWorkPortalUserInterceptor.java:87)
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
org.hisp.dhis.webportal.interceptor.XWorkPortalModuleInterceptor.intercept(XWorkPortalModuleInterceptor.java:90)

Re: [Dhis2-users] Looking for Human Resource System to integrate with DHIS

[gerald thomas]

I had use ihris and it is good. If you want help with it I am willing to
help.

On Aug 26, 2016 6:46 PM, "Laura E. Lincks" 
wrote:

> We are looking for a simple Human Resources tool to integrate with a DHIS
> aggregate database. Little is known of the needs of the HRIS, but for now
> it needs to track personnel details and groups of personnel will need to be
> associated with various programs in a separate DHIS aggregate database. An
> Open Source HRIS is preferable.
>
> In searching for tools I have come across the following:
> HRHIS in Tanzania developed by the
> HISP-TZ/University of Dar es Salaam
> iHRIS  developed by global Capacity Project.​
>
> I was wondering if anyone had any knowledge of or experience with these
> packages or if there were other applications that could be of use to us?
>
> Thanks in advance to anyone with leads or information.
>
> *Laura E. Lincks*
> Database Manager/Developer
> ICAP - Columbia University
> Mailman School of Public Health
> 60 Haven Ave, Floor B1
> New York, NY 10032
> Tel: 212 304 7132
>
> ___
> 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] Installing Ubuntu on HP ProLiant DL180 Gen9

[gerald thomas]

Dear Stephen,
Please do as follows:
Turn off the software RAID in BIOS, and it should work fine.

To disable the Bxxxi RAID, do this:

On Boot press F9 and enter the Setup

System Options
   SATA Controller Options
   Embedded SATA Configuration : Enable SATA Legacy Support

   HP Dynamic Smart Array Bxxxi RAID Controller : Disabled

PCI Device Enable/Disable

   Intel(R) SATA Controller #1 : Enabled
   Intel(R) SATA Controller #2 : Enabled
   HP Dynamic Smart Array Accelerator Manager : Disabled

And then install Ubuntu again.

On 8/22/16, Stephen Gbanyan <mam...@gmail.com> wrote:
> Hi Gerald,
>
> Thanks for that information.  What is the best option?
>
> Thanks
>
> Stephen
>
> On Mon, Aug 22, 2016 at 1:05 PM, gerald thomas <gerald17...@gmail.com>
> wrote:
>
>> Dear Knut,
>> He can try that option but I am not sure it will boot.
>> Normally the server move through all the boot options and end up at
>> network boot. So even if he set it at hard drive it will not boot.
>>
>>
>> On Aug 22, 2016 12:28 PM, "Knut Staring" <knu...@gmail.com> wrote:
>> >
>> > Hi Stephen,
>> >
>> > I am really no expert in this, but I think it looks like it is trying a
>> network boot. See if hitting F10 can get you into the BIOS to set boot
>> order to hard drive as described here:
>> >
>> > http://h30434.www3.hp.com/t5/Desktop-Operating-Systems-and-
>> Recovery/start-pxe-over-ipv4/td-p/4797023
>> >
>> > On Mon, Aug 22, 2016 at 1:56 PM, Stephen Gbanyan <mam...@gmail.com>
>> wrote:
>> >>
>> >> Hi Alex,
>> >>
>> >> During the installing I think I remembered installing it when I was
>> installing ubuntu. If that is not what you are talking about could just
>> guide me that I can do the installing over.
>> >>
>> >> Thanks
>> >>
>> >> Stephen
>> >>
>> >> On Mon, Aug 22, 2016 at 10:51 AM, Alex Tumwesigye <
>> atumwesi...@gmail.com> wrote:
>> >>>
>> >>> Dear Stephen,
>> >>>
>> >>> Did you install the Grub or boot loader?
>> >>>
>> >>> Alex
>> >>>
>> >>> On Mon, Aug 22, 2016 at 1:40 PM, Stephen Gbanyan <mam...@gmail.com>
>> wrote:
>> >>>>
>> >>>> Hi All,
>> >>>>
>> >>>> I got a new HP ProLiant DL180 Gen9 server and I have installed
>> >>>> Ubuntu
>> 16.04.1 but when it restart I get this message below.  Can someone help
>> guide me if I am not doing the right thing.  I need to install to be able
>> to get to the GUI to be able to navigate because I want to install DHIS2.
>> >>>>
>> >>>>
>> >>>> [image: Inline image 1]
>> >>>> Thanks
>> >>>>
>> >>>>
>> >>>> __
>> >>>> Stephen M. Gbanyan, Jr.
>> >>>> Director
>> >>>> Health Information System
>> >>>> Ministry of Health and Social Welfare
>> >>>> Republic of Liberia
>> >>>> +231-886-847-915
>> >>>> skype: mambu9
>> >>>>
>> >>>>
>> >>>> ___
>> >>>> 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
>> >>>>
>> >>>
>> >>>
>> >>>
>> >>> --
>> >>> Alex Tumwesigye
>> >>>
>> >>> Technical Advisor - DHIS2 (Consultant),
>> >>> Ministry of Health/AFENET  | HISP Uganda
>> >>> Kampala
>> >>> Uganda
>> >>> +256 774149 775, + 256 759 800161
>> >>> Skype ID: talexie
>> >>>
>> >>> IT Consultant (Servers, Networks and Security, Health Information
>> Systems - DHIS2, Disease Outbreak & Surveillance Systems) & Solar
>> Consultant
>> >>>
>> >>>
>> >>> "I don't want to be anything other than what I have been - one tree
>> hill "
>> >>
>> >>
>> >>
>> >>
>> >> --
>> >> __
>

Re: [Dhis2-users] Installing Ubuntu on HP ProLiant DL180 Gen9

[gerald thomas]

Dear Knut,
He can try that option but I am not sure it will boot.
Normally the server move through all the boot options and end up at
network boot. So even if he set it at hard drive it will not boot.


On Aug 22, 2016 12:28 PM, "Knut Staring"  wrote:
>
> Hi Stephen,
>
> I am really no expert in this, but I think it looks like it is trying a 
> network boot. See if hitting F10 can get you into the BIOS to set boot order 
> to hard drive as described here:
>
> http://h30434.www3.hp.com/t5/Desktop-Operating-Systems-and-Recovery/start-pxe-over-ipv4/td-p/4797023
>
> On Mon, Aug 22, 2016 at 1:56 PM, Stephen Gbanyan  wrote:
>>
>> Hi Alex,
>>
>> During the installing I think I remembered installing it when I was 
>> installing ubuntu. If that is not what you are talking about could just 
>> guide me that I can do the installing over.
>>
>> Thanks
>>
>> Stephen
>>
>> On Mon, Aug 22, 2016 at 10:51 AM, Alex Tumwesigye  
>> wrote:
>>>
>>> Dear Stephen,
>>>
>>> Did you install the Grub or boot loader?
>>>
>>> Alex
>>>
>>> On Mon, Aug 22, 2016 at 1:40 PM, Stephen Gbanyan  wrote:

 Hi All,

 I got a new HP ProLiant DL180 Gen9 server and I have installed Ubuntu 
 16.04.1 but when it restart I get this message below.  Can someone help 
 guide me if I am not doing the right thing.  I need to install to be able 
 to get to the GUI to be able to navigate because I want to install DHIS2.


 [image: Inline image 1]
 Thanks


 __
 Stephen M. Gbanyan, Jr.
 Director
 Health Information System
 Ministry of Health and Social Welfare
 Republic of Liberia
 +231-886-847-915
 skype: mambu9


 ___
 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

>>>
>>>
>>>
>>> --
>>> Alex Tumwesigye
>>>
>>> Technical Advisor - DHIS2 (Consultant),
>>> Ministry of Health/AFENET  | HISP Uganda
>>> Kampala
>>> Uganda
>>> +256 774149 775, + 256 759 800161
>>> Skype ID: talexie
>>>
>>> IT Consultant (Servers, Networks and Security, Health Information Systems - 
>>> DHIS2, Disease Outbreak & Surveillance Systems) & Solar Consultant
>>>
>>>
>>> "I don't want to be anything other than what I have been - one tree hill "
>>
>>
>>
>>
>> --
>> __
>> Stephen M. Gbanyan, Jr.
>> Director
>> Health Information System
>> Ministry of Health and Social Welfare
>> Republic of Liberia
>> +231-886-847-915
>> skype: mambu9
>>
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-users
>> Post to     : dhis2-users@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> More help   : https://help.launchpad.net/ListHelp
>>
>
>
>
> --
> Knut Staring
> Dept. of Informatics, University of Oslo
> Norway: +4791880522
> Skype: knutstar
> http://dhis2.org
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to     : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>

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

Re: [Dhis2-users] Data is not displayed in any report

[gerald thomas]

Chandrasekar,
Can you run analytics and generate reports again.

On Jul 30, 2016 8:28 AM, "Chandrasekar Ravi"  wrote:

> Dear Team
>
> We are successfully completed web tracker capture and mobile tracker
> capture.
>
> Data has been stored successfully. But we are facing the problem in data
> not showing in program summary report.
>
> Please any one make to fix this issue.
>
>
> *Thanks & Regards*
>
> *Chandrasekar Ravi*
> *Scientist - C, Data Manager*
> *9787214185*
> **
> *MAHA CDC Project*
> *National Institute of Epidemiology, ICMR*
>
> *127, Second Main Road, Tamil Nadu Housing BoardAyapakkam, Ambattur,
> Chennai – 77*
>
> ___
> 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] Merge and Deleting Facilities

[gerald thomas]

Dear Jason,
Thanks for your help and i will do a test on my laptop.

How can i delete these facilities after merging

On 7/29/16, Jason Pickering <jason.p.picker...@gmail.com> wrote:
> Hi Gerald,
> This has been raised a few times on the list already. There were some
> serious flaws with that functionality, and it was removed and has yet to be
> put back in place.
>
> In the meantime, you can try this
>
> https://github.com/dhis2/dhis2-utils/blob/master/resources/sql/merge_orgunits.sql
>
> and call it directly from the database with
>
> SELECT * FROM merge_organisationunits('SOURCE', 'DESTINATION', 'STRATEGY');
>
> where
>
> SOURCE = the source orgunit UID
> DESTINATION = the destination orgunit UID
> STRATEGY= one of  SUM,MAX,MIN,AVG,LAST,FIRST
>
> each of those paramaters should be encased with single-quotes.
>
>
> It goes without saying, this should be thoroughly tested on your
> non-production system before attempting it on your production machine, as
> it is a destructive function (meaning things get permanently deleted).
>
> Regards,
> Jason
>
>
> On Fri, Jul 29, 2016 at 6:05 PM, gerald thomas <gerald17...@gmail.com>
> wrote:
>
>> Dear All,
>> On previous DHIS2 version we were using merge for duplicate sites but
>> on version 2.22 i can't find merge. Please can someone help me?
>>
>> Also, after merging i will like to remove the duplicate facility, what
>> are the procedures to remove or delete a facility.
>>
>> Thanks in advance for your help
>>
>> --
>> Regards,
>>
>> Gerald
>>
>> ___
>> 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
>


-- 
Regards,

Gerald

___
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] Merge and Deleting Facilities

[gerald thomas]

Dear All,
On previous DHIS2 version we were using merge for duplicate sites but
on version 2.22 i can't find merge. Please can someone help me?

Also, after merging i will like to remove the duplicate facility, what
are the procedures to remove or delete a facility.

Thanks in advance for your help

-- 
Regards,

Gerald

___
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] Fwd: Error when starting tomcat

[gerald thomas]

Noted!!!
Collins can you correct as advice for security reasons.

On Jul 28, 2016 9:57 AM, "Bob Jolliffe" <bobjolli...@gmail.com> wrote:

> The reason why it is a risk is that if the web application gets
> compromised then it is possible that an attacker gets access to the
> machine with the privileges of the user running tomcat.
>
> If you scan back through the lists you will remember there was just
> such a problem in December 2013 where a vulnerability in the Struts
> library caused a number of servers to be hacked.  The result was the
> attacker was able to execute arbitrary code as the user running
> tomcat.  So this is not an abstract thing - it has happened and
> (despite eternal vigilance) it can happen again.
>
> So it is really important that the user running the tomcat service (or
> any other for that matter) has constrained privileges which allow it
> to do what it needs to do and nothing else.
>
> Having said that, running tomcat as root is distressingly common.  The
> problem is that having done it once, the log files and any files which
> tomcat writes are owned by root and so the only way people have to
> restart the service is to do so as root.  I can't count the number of
> servers I have seen doing this.
>
> The correct solution, as Jason points out, is to stop the service and
> then recursively change the ownership of all files and directories
> used by the instance to the user which has been created to run the
> service.  Then startup again as that user.
>
> Note that (because this was such a common problem) the dhis2-startup
> command used in dhis2-tools will refuse to run as root and ensures
> that the instance is started under the correct user.
>
> On 28 July 2016 at 10:34, gerald thomas <gerald17...@gmail.com> wrote:
> > Dear Jason,
> > Bob always tell me it is a security risk but I was trying to figure out
> > Collins issue. Thanks again for the information.
> >
> >
> > On Jul 28, 2016 9:13 AM, "Jason Pickering" <jason.p.picker...@gmail.com>
> > wrote:
> >>
> >> Hi Collins and Gerald,
> >>
> >> You should not execute "sudo ./startup.sh" as this means your Tomcat
> will
> >> run as the root user, which is generally a very bad idea.
> >>
> >> From the error, it looks like the user which owns the Tomcat directory
> >> does not actually have access to the logs. So you should "chown" all of
> the
> >> files to that user, and then start Tomcat up as a non-privileged user
> with
> >> something like "sudo -u dhis ./startup.sh".
> >>
> >> Regards,
> >> Jason
> >>
> >>
> >>
> >>
> >> On Thu, Jul 28, 2016 at 10:48 AM, gerald thomas <gerald17...@gmail.com>
> >> wrote:
> >>>
> >>> Dear Collins,
> >>> Can you please use sudo ./startup.sh
> >>> Please share your output
> >>>
> >>>
> >>> On Jul 28, 2016 08:36, "Knut Staring" <knu...@gmail.com> wrote:
> >>>>
> >>>> Hi Collins,
> >>>>
> >>>> Please use this mailing list: "dhis2-users@lists.launchpad.net"
> >>>>
> >>>> It seems as though something has happened to the user you are using to
> >>>> run Tomcat. Make sure this Linux user has sufficient permissions.
> >>>>
> >>>> Knut
> >>>>
> >>>> -- Forwarded message --
> >>>> From: Collins McAdoyo <collins.ad...@gmail.com>
> >>>> Date: Thu, Jul 28, 2016 at 2:55 PM
> >>>> Subject: Error when starting tomcat
> >>>> To: Knut Staring <knu...@gmail.com>
> >>>>
> >>>>
> >>>> Hi Team,
> >>>>
> >>>> Hi Team, my dhis instance was running well but since today it has
> >>>> started giving me errors as follows. Kindly any suggestions on how to
> >>>> fix this?
> >>>>
> >>>> cxx@x:/tomcat-dhis/bin$ ./startup.sh
> >>>> Using CATALINA_BASE:   /tomcat-dhis
> >>>> Using CATALINA_HOME:   /usr/share/tomcat7
> >>>> Using CATALINA_TMPDIR: /tomcat-dhis/temp
> >>>> Using JRE_HOME:/usr/lib/jvm/java-8-oracle/
> >>>> Using CLASSPATH:
> >>>> /usr/share/tomcat7/bin/bootstrap.jar:/usr/share/tomcat7/bin/tomcat-
> >>>> juli.jar
> >>>> touch: cannot touch ‘/tomcat-dhis/logs/cata

Re: [Dhis2-users] Fwd: Error when starting tomcat

[gerald thomas]

Dear Jason,
Bob always tell me it is a security risk but I was trying to figure out
Collins issue. Thanks again for the information.

On Jul 28, 2016 9:13 AM, "Jason Pickering" <jason.p.picker...@gmail.com>
wrote:

> Hi Collins and Gerald,
>
> You should not execute "sudo ./startup.sh" as this means your Tomcat will
> run as the root user, which is generally a very bad idea.
>
> From the error, it looks like the user which owns the Tomcat directory
> does not actually have access to the logs. So you should "chown" all of the
> files to that user, and then start Tomcat up as a non-privileged user with
> something like "sudo -u dhis ./startup.sh".
>
> Regards,
> Jason
>
>
>
>
> On Thu, Jul 28, 2016 at 10:48 AM, gerald thomas <gerald17...@gmail.com>
> wrote:
>
>> Dear Collins,
>> Can you please use sudo ./startup.sh
>> Please share your output
>>
>> On Jul 28, 2016 08:36, "Knut Staring" <knu...@gmail.com> wrote:
>>
>>> Hi Collins,
>>>
>>> Please use this mailing list: "dhis2-users@lists.launchpad.net"
>>>
>>> It seems as though something has happened to the user you are using to
>>> run Tomcat. Make sure this Linux user has sufficient permissions.
>>>
>>> Knut
>>>
>>> -- Forwarded message --
>>> From: Collins McAdoyo <collins.ad...@gmail.com>
>>> Date: Thu, Jul 28, 2016 at 2:55 PM
>>> Subject: Error when starting tomcat
>>> To: Knut Staring <knu...@gmail.com>
>>>
>>>
>>> Hi Team,
>>>
>>> Hi Team, my dhis instance was running well but since today it has
>>> started giving me errors as follows. Kindly any suggestions on how to
>>> fix this?
>>>
>>> cxx@x:/tomcat-dhis/bin$ ./startup.sh
>>> Using CATALINA_BASE:   /tomcat-dhis
>>> Using CATALINA_HOME:   /usr/share/tomcat7
>>> Using CATALINA_TMPDIR: /tomcat-dhis/temp
>>> Using JRE_HOME:/usr/lib/jvm/java-8-oracle/
>>> Using CLASSPATH:
>>> /usr/share/tomcat7/bin/bootstrap.jar:/usr/share/tomcat7/bin/tomcat-
>>> juli.jar
>>> touch: cannot touch ‘/tomcat-dhis/logs/catalina.out’: Permission denied
>>> /usr/share/tomcat7/bin/catalina.sh: 385:
>>> /usr/share/tomcat7/bin/catalina.sh: cannot create /tomcat-
>>> dhis/logs/catalina.out: Permission denied
>>> --
>>> This message was sent from Launchpad by
>>> Collins McAdoyo (https://launchpad.net/~mcadoyo)
>>> using the "Contact this team's admins" link on the DHIS 2 Users team page
>>> (https://launchpad.net/~dhis2-users).
>>> For more information see
>>> https://help.launchpad.net/YourAccount/ContactingPeople
>>>
>>>
>>>
>>> --
>>> 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
>>
>>
>
>
> --
> 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] Fwd: Error when starting tomcat

[gerald thomas]

Dear Collins,
Can you please use sudo ./startup.sh
Please share your output

On Jul 28, 2016 08:36, "Knut Staring"  wrote:

> Hi Collins,
>
> Please use this mailing list: "dhis2-users@lists.launchpad.net"
>
> It seems as though something has happened to the user you are using to run
> Tomcat. Make sure this Linux user has sufficient permissions.
>
> Knut
>
> -- Forwarded message --
> From: Collins McAdoyo 
> Date: Thu, Jul 28, 2016 at 2:55 PM
> Subject: Error when starting tomcat
> To: Knut Staring 
>
>
> Hi Team,
>
> Hi Team, my dhis instance was running well but since today it has
> started giving me errors as follows. Kindly any suggestions on how to
> fix this?
>
> cxx@x:/tomcat-dhis/bin$ ./startup.sh
> Using CATALINA_BASE:   /tomcat-dhis
> Using CATALINA_HOME:   /usr/share/tomcat7
> Using CATALINA_TMPDIR: /tomcat-dhis/temp
> Using JRE_HOME:/usr/lib/jvm/java-8-oracle/
> Using CLASSPATH:
> /usr/share/tomcat7/bin/bootstrap.jar:/usr/share/tomcat7/bin/tomcat-
> juli.jar
> touch: cannot touch ‘/tomcat-dhis/logs/catalina.out’: Permission denied
> /usr/share/tomcat7/bin/catalina.sh: 385:
> /usr/share/tomcat7/bin/catalina.sh: cannot create /tomcat-
> dhis/logs/catalina.out: Permission denied
> --
> This message was sent from Launchpad by
> Collins McAdoyo (https://launchpad.net/~mcadoyo)
> using the "Contact this team's admins" link on the DHIS 2 Users team page
> (https://launchpad.net/~dhis2-users).
> For more information see
> https://help.launchpad.net/YourAccount/ContactingPeople
>
>
>
> --
> Knut Staring
> Dept. of Informatics, University of Oslo
> Norway: +4791880522
> Skype: knutstar
> http://dhis2.org
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] Upgrading DHIS2 from version 2.5 to 2.22

[gerald thomas]

Thanks Knut, they are currently doing data entry till August 15. I will
start on the 16 or 17 and i will keep you informed.

On Jul 27, 2016 12:49 PM, "Knut Staring" <knu...@gmail.com> wrote:

> I suggest you try with 2.16 and let us know how it goes. If problematic,
> then try a few versions earlier.
> Knut
>
> On 27 Jul 2016 19:12, "gerald thomas" <gerald17...@gmail.com> wrote:
>
>> Dear Knut,
>> Noted!!!
>> I noticed that upgrade procedures' starts from version 2.16 and the
>> oldest war file available is 2.7; which means I will have to work blindly
>> till 2.16 by the grace of God.
>> HISP India, please can you help because I heard you had done something
>> like this before.
>>
>> On Jul 27, 2016 12:31 PM, "Knut Staring" <knu...@gmail.com> wrote:
>>
>>> Gi Gerald,
>>>
>>> Please do not take my suggestion as a fully formed and fool-proof
>>> procedure. But since you are exporting and then importing into an empty
>>> instance of a newer version, you will not be messing up your existing data
>>> (but should still take a backup first).
>>>
>>> Piecewise going through every version with the necessary database
>>> updates is the safest route and to always be recommended.
>>>
>>> However, this might be difficult in this case, and certainly very
>>> cumbersome. So I  suggest you give it a try. 2.16 was just a rough number,
>>> I am not sure it will work,  but this method can help you skip a few
>>> versions. However, you will have to test the results thoroughly, and
>>> probably will run into a few obstacles. So it is not a silver bullet,  I'm
>>> afraid.
>>>
>>> Knut
>>>
>>> On 27 Jul 2016 14:04, "gerald thomas" <gerald17...@gmail.com> wrote:
>>>
>>>> Knut,
>>>> That is a very big jump and if it works, it will make my day.
>>>> As per your procedure, I should deploy the 2.16 war file on the newly
>>>> installed DHIS2 with empty database "hmis" and do metadata export of
>>>> everything from the old system which is running on 2.5 war file and finally
>>>> import to the new instance?
>>>> My question again Knut, what is the best method to do this export &
>>>> import: piecewise or everything; if it is piecewise what should I import
>>>> first, second,.. and last?
>>>>
>>>> Thanks for your help
>>>>
>>>> On Jul 26, 2016 15:40, "Knut Staring" <knu...@gmail.com> wrote:
>>>>
>>>>> Hi Gerald,
>>>>> I would try to skip a few versions by exporting metadata and data and
>>>>> probably try to import to an intermediate version such as 2.13 or 2.16.
>>>>>
>>>>> On 26 Jul 2016 21:02, "gerald thomas" <gerald17...@gmail.com> wrote:
>>>>>
>>>>>> Dear All,
>>>>>> I am inquiring for both technical guidance and materials to upgrade a
>>>>>> DHIS2 instance from version 2.5 to 2.22.
>>>>>>
>>>>>> I will be grateful for any help anyone can render for me to
>>>>>> successfully achieve this task. Also, i will like to know where i can
>>>>>> get all the old war files.
>>>>>>
>>>>>> --
>>>>>> Regards,
>>>>>>
>>>>>> Gerald
>>>>>>
>>>>>> ___
>>>>>> Mailing list: https://launchpad.net/~dhis2-users
>>>>>> Post to : dhis2-users@lists.launchpad.net
>>>>>> Unsubscribe : https://launchpad.net/~dhis2-users
>>>>>> More help   : https://help.launchpad.net/ListHelp
>>>>>>
>>>>>
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] Upgrading DHIS2 from version 2.5 to 2.22

[gerald thomas]

Dear Knut,
Noted!!!
I noticed that upgrade procedures' starts from version 2.16 and the oldest
war file available is 2.7; which means I will have to work blindly till
2.16 by the grace of God.
HISP India, please can you help because I heard you had done something like
this before.

On Jul 27, 2016 12:31 PM, "Knut Staring" <knu...@gmail.com> wrote:

> Gi Gerald,
>
> Please do not take my suggestion as a fully formed and fool-proof
> procedure. But since you are exporting and then importing into an empty
> instance of a newer version, you will not be messing up your existing data
> (but should still take a backup first).
>
> Piecewise going through every version with the necessary database updates
> is the safest route and to always be recommended.
>
> However, this might be difficult in this case, and certainly very
> cumbersome. So I  suggest you give it a try. 2.16 was just a rough number,
> I am not sure it will work,  but this method can help you skip a few
> versions. However, you will have to test the results thoroughly, and
> probably will run into a few obstacles. So it is not a silver bullet,  I'm
> afraid.
>
> Knut
>
> On 27 Jul 2016 14:04, "gerald thomas" <gerald17...@gmail.com> wrote:
>
>> Knut,
>> That is a very big jump and if it works, it will make my day.
>> As per your procedure, I should deploy the 2.16 war file on the newly
>> installed DHIS2 with empty database "hmis" and do metadata export of
>> everything from the old system which is running on 2.5 war file and finally
>> import to the new instance?
>> My question again Knut, what is the best method to do this export &
>> import: piecewise or everything; if it is piecewise what should I import
>> first, second,.. and last?
>>
>> Thanks for your help
>>
>> On Jul 26, 2016 15:40, "Knut Staring" <knu...@gmail.com> wrote:
>>
>>> Hi Gerald,
>>> I would try to skip a few versions by exporting metadata and data and
>>> probably try to import to an intermediate version such as 2.13 or 2.16.
>>>
>>> On 26 Jul 2016 21:02, "gerald thomas" <gerald17...@gmail.com> wrote:
>>>
>>>> Dear All,
>>>> I am inquiring for both technical guidance and materials to upgrade a
>>>> DHIS2 instance from version 2.5 to 2.22.
>>>>
>>>> I will be grateful for any help anyone can render for me to
>>>> successfully achieve this task. Also, i will like to know where i can
>>>> get all the old war files.
>>>>
>>>> --
>>>> Regards,
>>>>
>>>> Gerald
>>>>
>>>> ___
>>>> 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] NGINX ERROR-HELP

[gerald thomas]

Stanley,
it means cap header size.

You can increase it nginx.conf file normally located at /etc/nginx/nginx.conf

On 7/27/16, Stanley Kalyati  wrote:
> DHISiers,
>
> What does this error mean?
>
> Thank you
>
> 414 Request-URI Too Large
> --
> nginx
>


-- 
Regards,

Gerald

___
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] Upgrading DHIS2 from version 2.5 to 2.22

[gerald thomas]

Dear All,
I am inquiring for both technical guidance and materials to upgrade a
DHIS2 instance from version 2.5 to 2.22.

I will be grateful for any help anyone can render for me to
successfully achieve this task. Also, i will like to know where i can
get all the old war files.

-- 
Regards,

Gerald

___
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] Ngnix Failed

[gerald thomas]

Dear Morten,
Yes i did because Bob said i am using the old version of the tool.
Please can you send a link where i can get the latest version of the
tool because i want to start all over again.

On 7/26/16, Morten Olav Hansen <mor...@dhis2.org> wrote:
> Hi Gerald
>
> What I'm guessing has happened here is that you have download the dhis2
> nginx config embedded in github (you can see the doctype there)
>
> Please try this url instead:
> https://raw.githubusercontent.com/dhis2/dhis2-tools/master/dhis2-tools/dhis2-tools/usr/share/dhis2-tools/samples/nginx/dhis2
>
> --
> Morten Olav Hansen
> Senior Engineer, DHIS 2
> University of Oslo
> http://www.dhis2.org
>
> On Tue, Jul 26, 2016 at 3:17 PM, gerald thomas <gerald17...@gmail.com>
> wrote:
>
>> Dear Bob,
>>
>> This is the error:
>>
>> inveneo@NMCP:~$ sudo nginx -t
>> nginx: [emerg] unknown directive "> /etc/nginx/sites-enabled/dhis2:41
>> nginx: configuration file /etc/nginx/nginx.conf test failed
>>
>>
>> On 7/26/16, Bob Jolliffe <bobjolli...@gmail.com> wrote:
>> > What error?
>> >
>> > On 26 July 2016 at 10:46, gerald thomas <gerald17...@gmail.com> wrote:
>> >> Yes Morten it returns an error stating nginx failed.
>> >>
>> >> On Jul 26, 2016 9:21 AM, "Morten Olav Hansen" <mor...@dhis2.org>
>> >> wrote:
>> >>>
>> >>> If it's config related, it can also be good to run "nginx -t" which
>> will
>> >>> test the config and return any errors it can see
>> >>>
>> >>> --
>> >>> Morten Olav Hansen
>> >>> Senior Engineer, DHIS 2
>> >>> University of Oslo
>> >>> http://www.dhis2.org
>> >>>
>> >>> On Tue, Jul 26, 2016 at 11:15 AM, Bob Jolliffe
>> >>> <bobjolli...@gmail.com>
>> >>> wrote:
>> >>>>
>> >>>> Hi Gerald
>> >>>>
>> >>>> You should not touch /etc/nginx/nginx.conf at all.  All
>> >>>> customisation
>> >>>> is done under sites-enabled.
>> >>>>
>> >>>> If your nginx is failing to start the chances are that
>> >>>> /var/log/nginx/error.log will tell you what the problem is.
>> >>>>
>> >>>> Bob
>> >>>>
>> >>>> On 25 July 2016 at 21:08, gerald thomas <gerald17...@gmail.com>
>> wrote:
>> >>>> > Dear Bob,
>> >>>> > I am still having issue with the dhis2-tool. After replacing the
>> file
>> >>>> > /etc/nginx/sites-enabled/dhis2
>> >>>> > with the link you provided nginx failed to start:
>> >>>> >
>> >>>> > wget
>> >>>> >
>> https://github.com/dhis2/dhis2-tools/blob/master/dhis2-tools/dhis2-tools/usr/share/dhis2-tools/samples/nginx/dhis2
>> >>>> >
>> >>>> > Kindly note that i replaced all dhis with hmis on
>> >>>> > /etc/nginx/nginx.conf file but i am still having issues.
>> >>>> >
>> >>>> > Please i need help. This is the only procedure I had NOT
>> successfully
>> >>>> > create an instance on.
>> >>>> > --
>> >>>> > Regards,
>> >>>> >
>> >>>> > Gerald
>> >>>> >
>> >>>> > ___
>> >>>> > 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
>> >>>
>> >>>
>> >
>>
>>
>> --
>> Regards,
>>
>> Gerald
>>
>


-- 
Regards,

Gerald

___
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] Ngnix Failed

[gerald thomas]

Dear Bob,

This is the error:

inveneo@NMCP:~$ sudo nginx -t
nginx: [emerg] unknown directive " wrote:
> What error?
>
> On 26 July 2016 at 10:46, gerald thomas <gerald17...@gmail.com> wrote:
>> Yes Morten it returns an error stating nginx failed.
>>
>> On Jul 26, 2016 9:21 AM, "Morten Olav Hansen" <mor...@dhis2.org> wrote:
>>>
>>> If it's config related, it can also be good to run "nginx -t" which will
>>> test the config and return any errors it can see
>>>
>>> --
>>> Morten Olav Hansen
>>> Senior Engineer, DHIS 2
>>> University of Oslo
>>> http://www.dhis2.org
>>>
>>> On Tue, Jul 26, 2016 at 11:15 AM, Bob Jolliffe <bobjolli...@gmail.com>
>>> wrote:
>>>>
>>>> Hi Gerald
>>>>
>>>> You should not touch /etc/nginx/nginx.conf at all.  All customisation
>>>> is done under sites-enabled.
>>>>
>>>> If your nginx is failing to start the chances are that
>>>> /var/log/nginx/error.log will tell you what the problem is.
>>>>
>>>> Bob
>>>>
>>>> On 25 July 2016 at 21:08, gerald thomas <gerald17...@gmail.com> wrote:
>>>> > Dear Bob,
>>>> > I am still having issue with the dhis2-tool. After replacing the file
>>>> > /etc/nginx/sites-enabled/dhis2
>>>> > with the link you provided nginx failed to start:
>>>> >
>>>> > wget
>>>> > https://github.com/dhis2/dhis2-tools/blob/master/dhis2-tools/dhis2-tools/usr/share/dhis2-tools/samples/nginx/dhis2
>>>> >
>>>> > Kindly note that i replaced all dhis with hmis on
>>>> > /etc/nginx/nginx.conf file but i am still having issues.
>>>> >
>>>> > Please i need help. This is the only procedure I had NOT successfully
>>>> > create an instance on.
>>>> > --
>>>> > Regards,
>>>> >
>>>> > Gerald
>>>> >
>>>> > ___
>>>> > 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
>>>
>>>
>


-- 
Regards,

Gerald

___
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] Ngnix Failed

[gerald thomas]

Yes Morten it returns an error stating nginx failed.

On Jul 26, 2016 9:21 AM, "Morten Olav Hansen" <mor...@dhis2.org> wrote:
>
> If it's config related, it can also be good to run "nginx -t" which will
test the config and return any errors it can see
>
> --
> Morten Olav Hansen
> Senior Engineer, DHIS 2
> University of Oslo
> http://www.dhis2.org
>
> On Tue, Jul 26, 2016 at 11:15 AM, Bob Jolliffe <bobjolli...@gmail.com>
wrote:
>>
>> Hi Gerald
>>
>> You should not touch /etc/nginx/nginx.conf at all.  All customisation
>> is done under sites-enabled.
>>
>> If your nginx is failing to start the chances are that
>> /var/log/nginx/error.log will tell you what the problem is.
>>
>> Bob
>>
>> On 25 July 2016 at 21:08, gerald thomas <gerald17...@gmail.com> wrote:
>> > Dear Bob,
>> > I am still having issue with the dhis2-tool. After replacing the file
>> > /etc/nginx/sites-enabled/dhis2
>> > with the link you provided nginx failed to start:
>> >
>> > wget
https://github.com/dhis2/dhis2-tools/blob/master/dhis2-tools/dhis2-tools/usr/share/dhis2-tools/samples/nginx/dhis2
>> >
>> > Kindly note that i replaced all dhis with hmis on
>> > /etc/nginx/nginx.conf file but i am still having issues.
>> >
>> > Please i need help. This is the only procedure I had NOT successfully
>> > create an instance on.
>> > --
>> > Regards,
>> >
>> > Gerald
>> >
>> > ___
>> > 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
>
>
___
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] Ngnix Failed

[gerald thomas]

Dear Bob,
I am still having issue with the dhis2-tool. After replacing the file
/etc/nginx/sites-enabled/dhis2
with the link you provided nginx failed to start:

wget 
https://github.com/dhis2/dhis2-tools/blob/master/dhis2-tools/dhis2-tools/usr/share/dhis2-tools/samples/nginx/dhis2

Kindly note that i replaced all dhis with hmis on
/etc/nginx/nginx.conf file but i am still having issues.

Please i need help. This is the only procedure I had NOT successfully
create an instance on.
-- 
Regards,

Gerald

___
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] Pivot table for reporting rate

[gerald thomas]

Hi all,
This is happening for version 2.23 and 2.24. We  reported this issue before
and we are still waiting for solution.

On Jul 23, 2016 07:23, "Prosper BT"  wrote:

> Dear Carlos,
>
> This usually happens when you have Orgunit in different Orgunits groups
> that belong to the same Orgunit group Set.
>
> For example You have a facility both in  Hospital and Clinic orgunit
> groups, then both Hospital and Clinic are part of one Orgunit group
> "Facility Type".
>
> Use the Data integrity check under "Data Administration" to find out which
> ones violate Orgunits group set.
>
> Organisation units violating exclusive group sets
> Regards
>
> On Wed, Jul 20, 2016 at 3:41 PM, Carlos Nyembwe  wrote:
>
>> Hi everyone,
>>
>> I have problem, these times I was making a reporting rate on pivot table
>> but, in reality we must have value under or equal to 100. In this picture,
>> same values are more that 100.
>>
>> What happened with DHIS2?
>>
>> [image: Inline image 1]
>> --
>> *Carlos Nyembwe*
>> *I'm just a Computer Scientist*
>>
>> *Skype: carloscnk1*
>> *Cell: (+243)813166381 <%28%2B243%29813166381>*
>> *Find me in: | Google Plus  | 
>> **Linkedin
>>  | Facebook
>>  | Twitter
>>  |*
>>
>> ___
>> 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
>>
>>
>
>
> --
> Prosper Behumbiize, MPH
> Global DHIS2 Implementation| HISP Uganda/University Of Oslo
> +256 752 751 776 | +256 776 139 139
> pros...@hispuganda.org  | pros...@dhis2.org | Skype:
> prospertb
>
> ___
> 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] Pivot Table Computation Error on 2.24

[gerald thomas]

Dear All,
After upgrading from 2.21 to 2.24 we noticed the following, when we
were pulling pivot table reports:
For Example if our:

Data Sets is HF1(Morbidity)
Periods is Monthly (the whole of 2015)
Organizations: Facility and then Chiefdom for Malema

and we are getting 100% which is not possible but when i revert to
2.21 the result is different. Please find the attached results from
2.24

Please i need help to solve this issue.





-- 
Regards,

Gerald


data.xls
Description: MS-Excel spreadsheet


data(1).xls
Description: MS-Excel spreadsheet
___
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] Multiple DHIS2 instances on a Single Server

[gerald thomas]

Seth,
Thanks very much for your help. So it is on the ngnix that we define the
path of each instances?

Regards,
Gerald
On Jul 14, 2016 2:59 AM, "Seth Okeyo" <sok...@dndi.org> wrote:

> Hello Gerald.
> I have done that before,  you only need to set up different databases on
> postgresql  (Naming them differently) then creating dhis2 instances with
> the same names you used in the database., this is done by renaming the war
> file before exploding in tomcat.  Set the database connection in the .conf
> Files then environmental variables. You should be good to go.
> Regards
> Seth Okeyo
> Dndi Africa
>
>
> Envoyé à partir de mon Samsung.
>
>
>  Original message 
> From: gerald thomas
> Date:13/07/2016 12:31 PM (GMT+03:00)
> To: dhis2-users , dhis2-devs
> Subject: [Dhis2-users] Multiple DHIS2 instances on a Single Server
>
> Dear All,
> We will be creating multiple instances on a single server with a single
> public IP. I am inquiring how can this be done because i haven't done this
> before.
>
> Regards,
> Gerald
>
___
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] Multiple DHIS2 instances on a Single Server

[gerald thomas]

Dear All,
We will be creating multiple instances on a single server with a single
public IP. I am inquiring how can this be done because i haven't done this
before.

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

Re: [Dhis2-users] Upgrading from DHIS2.old version like 2.18 to 2.24

[gerald thomas]

Kamugunga,

https://mail.google.com/mail/u/0/h/120jm67l1ek8c/?=155df1acfeb87be2=u=e=c#m_15187aa80c4a1ee9

On 7/12/16, Knut Staring  wrote:
> No direct. Have to go step by step. I will forward an email with the
> details.
> Knut
> On 12 Jul 2016 4:02 p.m., "Kamugunga Adolphe"  wrote:
>
>> Dear community,
>>
>> Where can some one get old dhis2 war files  and upgrades notes especially
>> the .sql files released for updgrade  in case i want to upgrade step by
>> step from version to another till i reach the current to avoid jumping to
>> recent version.
>> Is direct jump to recent eg from 2.18 to 2.4  a best practices? if not
>> what should the best practices?
>>
>>
>> *Adolphe Kamugunga*
>> *MIS Technical Advisor*
>> Mobile: +250 788 740 578
>> Email:kaa...@gmail.com
>> Skype: ka.adolphe
>>
>>
>>
>> On 11 July 2016 at 18:43, Morina Matasi 
>> wrote:
>>
>>> Thanks Knut. I tried steps in that link with no joy. I was using
>>> standard
>>> reports in DHIS2.19. These reports are .jrxml files done in Jasper
>>> Reports.
>>> My JRXML report runs well in DHIS2.19 but stops running in DHIS2.20 or
>>> later. Am I the only one who faced this problem? Wasn't there an upgrade
>>> plan for JRXML reports.
>>>
>>>
>>>
>>> On Mon, Jul 11, 2016 at 3:02 PM, Knut Staring  wrote:
>>>
 Hello,

 I have no experience with running Jasper reports on JDK 8, but a quick
 googling showed up this:


 https://community.jaspersoft.com/questions/844403/how-run-jasperreports-java-8

 On Mon, Jul 11, 2016 at 2:20 PM, Morina Matasi <
 morena.motsi...@gmail.com> wrote:

> I need to upgrade my system from 2.19 to 2.24. I have first upgraded
> to
> 2.20 with Tomcat 8 and JDK 8. The system runs by the Jasper Reports
> won't.
> I get error:
>
> net.sf.jasperreports.engine.JRException: Errors were encountered when
> compiling report expressions class file:
> 1. The type java.lang.CharSequence cannot be resolved. It is indirectly
> referenced from required .class files
> value =
> ((java.lang.String)field_organisationunitname.getValue()).equals(((java.lang.String)field_param_organisationunit_name.getValue()))?
> //$JR_EXPR_ID=27$
>
> <>
>
> Did anyone had any issues with Jasper Reports running on JDK 8?
>
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>


 --
 Knut Staring
 Dept. of Informatics, University of Oslo
 Norway: +4791880522
 Skype: knutstar
 http://dhis2.org

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


-- 
Regards,

Gerald

___
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] Upgrading DHIS2 from 2.21 to 2.24

[gerald thomas]

Dear All,
I have an urgent request to upgrade our national instance from 2.21 to
2.24 which i am a bit skeptical about due to the various issues from
my colleagues using DHIS2. Please can I have the simplest steps to
achieve my goal and secondly, is it advisable to use the 2.24 on our
national instance.

Thanks in advance for all your help.

-- 
Regards,

Gerald

___
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] Login issues

[gerald thomas]

admin / district but that is if you don't have your own database

Regards,
Gerald
On Mar 28, 2016 9:09 AM, "GAS GASPY"  wrote:

> Hello,
> Hope everybody is cool.I am new in DHIS, and downloaded the DHIS 2
> installer, installed it in my local machine, but dont know which login
> informations to use.I tried using my launchpad login informations but to no
> avail.Please I need your help !By hoping a cool respond, I wish everyone
> here a blessed day.
>
>
>
>
>
> Warm Regards,
> Baye Gaspard
> Co-Founder of Katamba Techs
>
> ___
> 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] Why does my dhis2 setup return to default after I restart the server?

[gerald thomas]

Which operating system are you using ??

Regards,
Gerald
On Mar 22, 2016 20:34, "Adam Dawoodjee"  wrote:

> Hello Knut,
>
> How can I do that pls?
>
> I'm getting this:
>
> Database type:DhisH2Database name:
> dhis2;DB_CLOSE_DELAY=-1;MVCC=TRUE;ALIAS_COLUMN_NAME=TRUE;DB_CLOSE_ON_EXIT=FALSEDatabase
> user:sa
>
>
>
> On Tue, Mar 22, 2016 at 10:31 PM, Knut Staring  wrote:
>
>> Hi Adam,
>>
>> You are not connected to a Postgres database. Please go to Profile ->
>> About DHIS2 and check your database connection.
>>
>> Knut
>>
>> On Tue, Mar 22, 2016 at 9:27 PM, Adam Dawoodjee 
>> wrote:
>>
>>> Hello again Community!
>>>
>>> Right after rebooting my server or restarting Tomcat, I lose all my
>>> settings, including appearance and user settings and I have to start
>>> afresh. Does anyone know the cause and/or a simple solution to this?
>>>
>>>
>>> Thanks,
>>> Adam
>>>
>>>
>>> ___
>>> Mailing list: https://launchpad.net/~dhis2-users
>>> Post to : dhis2-users@lists.launchpad.net
>>> Unsubscribe : https://launchpad.net/~dhis2-users
>>> More help   : https://help.launchpad.net/ListHelp
>>>
>>>
>>
>>
>> --
>> Knut Staring
>> Dept. of Informatics, University of Oslo
>> Norway: +4791880522
>> Skype: knutstar
>> http://dhis2.org
>>
>
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

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

[gerald thomas]

Dear Channara,
I think Dcocos solution should be a break through and it will minimize the
database size.

Regards,
Gerald
On Mar 19, 2016 05:03, "channara rin"  wrote:

> Thank you,
> let me try testing...
> and by the way, i configured and can run DHIS2 on localhost already. but
> when i plug data into existing DHIS2. it is out of memory.
>
> On Sat, Mar 19, 2016 at 10:08 AM, dcocos  wrote:
>
>> Hi,
>>
>> If you dump with (where dbname is your rename)
>> pg_dump dbname -O -T _* -T aggregated* -T analytics* -T completeness*
>>
>> This will dump without the generated tables which you can recreate by
>> running analytics this reduces the size of the import often by an order of
>> magnitude.
>>
>> On Mar 18, 2016, at 10:14 PM, channara rin 
>> wrote:
>>
>> Hi bob,
>> when i backup, i use command pg_dumpall.
>> i can restore on my personal laptop with 4GB Memory. but for desktop seem
>> out of memory.
>> i will re-check again on task manager what is still processing.
>>
>> On Fri, Mar 18, 2016 at 11:14 PM, Bob Jolliffe 
>> wrote:
>>
>>> 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 <
>>> rin.chann...@gmail.com>
>>> >>> 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 <
>>> rin.chann...@gmail.com>
>>> > 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   : 

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

[gerald thomas]

Dear Channara,
Have you configure environmental variables for DHIS2 on the desktop?

Regards,
Gerald
On Mar 19, 2016 02:14, "channara rin"  wrote:

> Hi bob,
> when i backup, i use command pg_dumpall.
> i can restore on my personal laptop with 4GB Memory. but for desktop seem
> out of memory.
> i will re-check again on task manager what is still processing.
>
> On Fri, Mar 18, 2016 at 11:14 PM, Bob Jolliffe 
> wrote:
>
>> 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 <
>> rin.chann...@gmail.com>
>> > 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
>
>
___
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] [DHIS] Unable to delete a user

[gerald thomas]

Dear all,
This is not really new, from I can delete a user without any problem as
long as I am admin but in a life instance you can only disable users.

Regards,
Gerald
On Mar 11, 2016 05:44, "Archana Chillala"  wrote:

> Hi Lars,
>
> I tried clear cache. But still the same. Unable to delete a user. Even if
> the user is newly created and not associated to any other object.
>
> Any thoughts on this?
>
>
> *Thanks*
>
> Archana Chillala
> Application Developer
> Email archa...@thoughtworks.com
> Telephone +91 9100960533 <+91+9100960533>
> [image: ThoughtWorks]
> 
>
> On Wed, Mar 9, 2016 at 6:22 PM, Lars Helge Øverland 
> wrote:
>
>> Hi Archana,
>>
>> I think this happens due to some leak in our application cache. Try going
>> to data admin > cache statistics > clear cache and try again.
>>
>> regards,
>>
>> Lars
>>
>>
>> On Fri, Mar 4, 2016 at 11:52 AM, Archana Chillala <
>> archa...@thoughtworks.com> wrote:
>>
>>> Hi Morten,
>>>
>>> We are using DHIS version 2.23 and created some sample metadata on it.
>>> When we try to delete a user, the user does not get removed.
>>>
>>> Following are the logs for the exception:
>>>
>>> * INFO  2016-03-04 16:13:13,146 'admin' update
>>> org.hisp.dhis.user.UserAuthorityGroup, name: Superuser, uid: gETZb5SDObu
>>> (AuditLogUtil.java [qtp1727373358-105])
>>> * ERROR 2016-03-04 16:13:13,151 Failed to invoke method deleteUser on
>>> DeletionHandler 'UserSettingDeletionHandler' (DefaultDeletionManager.java
>>> [qtp1727373358-105])
>>> java.lang.reflect.InvocationTargetException
>>> at sun.reflect.GeneratedMethodAccessor618.invoke(Unknown Source)
>>> at
>>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
>>> at java.lang.reflect.Method.invoke(Method.java:497)
>>> at
>>> org.hisp.dhis.system.deletion.DefaultDeletionManager.execute(DefaultDeletionManager.java:147)
>>> at
>>> org.hisp.dhis.system.deletion.DeletionInterceptor.intercept(DeletionInterceptor.java:54)
>>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>>> at
>>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
>>> at
>>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
>>> at java.lang.reflect.Method.invoke(Method.java:497)
>>> Caused by: org.hibernate.NonUniqueObjectException: a different object
>>> with the same identifier value was already associated with the session:
>>> [org.hisp.dhis.user.UserSetting#org.hisp.dhis.user.UserSetting@528fc6ba]
>>> at
>>> org.hibernate.engine.internal.StatefulPersistenceContext.checkUniqueness(StatefulPersistenceContext.java:696)
>>> at
>>> org.hibernate.event.internal.DefaultDeleteEventListener.onDelete(DefaultDeleteEventListener.java:119)
>>> at
>>> org.hibernate.event.internal.DefaultDeleteEventListener.onDelete(DefaultDeleteEventListener.java:74)
>>> at org.hibernate.internal.SessionImpl.fireDelete(SessionImpl.java:918)
>>> at org.hibernate.internal.SessionImpl.delete(SessionImpl.java:855)
>>> at
>>> org.hisp.dhis.user.hibernate.HibernateUserSettingStore.deleteUserSetting(HibernateUserSettingStore.java:107)
>>> at
>>> org.hisp.dhis.user.DefaultUserSettingService.deleteUserSetting(DefaultUserSettingService.java:160)
>>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>>> * INFO  2016-03-04 16:13:13,154 'admin' delete org.hisp.dhis.user.User,
>>> name: user new, uid: bSJzGJPYnWi (AuditLogUtil.java [qtp1727373358-105])
>>> * INFO  2016-03-04 16:13:13,155 'admin' delete
>>> org.hisp.dhis.user.UserCredentials, name: admin admin (AuditLogUtil.java
>>> [qtp1727373358-105])
>>> * INFO  2016-03-04 16:13:13,158 'admin' delete org.hisp.dhis.user.User,
>>> name: user new, uid: bSJzGJPYnWi (AuditLogUtil.java [qtp1727373358-105])
>>> * WARN  2016-03-04 16:13:13,174 SQL Error: 0, SQLState: 23503
>>> (SqlExceptionHelper.java [qtp1727373358-105])
>>> * ERROR 2016-03-04 16:13:13,175 ERROR: update or delete on table
>>> "userinfo" violates foreign key constraint "fk_usersetting_userinfoid" on
>>> table "usersetting"
>>>   Detail: Key (userinfoid)=(289) is still referenced from table
>>> "usersetting". (SqlExceptionHelper.java [qtp1727373358-105])
>>> * ERROR 2016-03-04 16:13:13,175 Error while executing action
>>> (ExceptionInterceptor.java [qtp1727373358-105])
>>> org.springframework.dao.DataIntegrityViolationException: could not
>>> execute statement; SQL [n/a]; constraint [fk_usersetting_userinfoid];
>>> nested exception is org.hibernate.exception.ConstraintViolationException:
>>> could not execute statement
>>> at
>>> org.springframework.orm.hibernate4.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:163)
>>> at
>>> org.springframework.orm.hibernate4.HibernateTransactionManager.convertHibernateAccessException(HibernateTransactionManager.java:730)
>>> at
>>> 

Re: [Dhis2-users] Upgrade from 2.20 to 2.22

[gerald thomas]

Boss
https://www.dhis2.org/220-upgrade
https://www.dhis2.org/221-upgrade
https://www.dhis2.org/222-upgrade

Did you run the script:
https://github.com/dhis2/dhis2-utils/blob/master/resources/sql/upgrade-220.sql
When upgrading to 2.20?

There is not too much for version 2.21 but you need pay attention to
the changes for version 2.22. Kindly go through the links again.

On Thursday, February 18, 2016, Furqonuddin Ramdhani <furqo...@gmail.com>
wrote:

>
> I didn't find any upgrade procedures documents for dhis 2.22, maybe
> someone can send me the link or explain a little bit about the procedures.
> I'm aware there are some changes in table structures but how to migrate it
> properly I still doing trial and error here. In previous version usually
> have upgrade scripts  like this one :
>
> https://github.com/dhis2/dhis2-utils/blob/master/resources/sql/upgrade-220.sql
>
> Thanks
>
> Regards,
> Dhani
>
>
>
> On Thu, Feb 18, 2016 at 11:50 AM, gerald thomas <gerald17...@gmail.com
> <javascript:_e(%7B%7D,'cvml','gerald17...@gmail.com');>> wrote:
>
>> Boss,
>> I think you should upgrade the data structures of postgresql database
>> 2.20 before migrating them to 2.22. Please read the upgrade procedures
>> again because there are steps you should have done. I think it will always
>> fail if your want to move them directly from 2.20 to 2.22
>>
>> Regards,
>> Gerald
>> On Feb 18, 2016 2:38 AM, "Furqonuddin Ramdhani" <furqo...@gmail.com
>> <javascript:_e(%7B%7D,'cvml','furqo...@gmail.com');>> wrote:
>>
>>> Hi,
>>>
>>> I already installed dhis 2.22 and want to migrate all my data from dhis
>>> 2.20, how the best way to do it, I already tried import the metadata from
>>> 2.20 to 2.22 but failed. Any suggestion ?
>>>
>>> Thanks
>>>
>>> --
>>> Regards,
>>> *Furqonuddin Ramdhani*
>>>
>>> ___
>>> Mailing list: https://launchpad.net/~dhis2-users
>>> Post to : dhis2-users@lists.launchpad.net
>>> <javascript:_e(%7B%7D,'cvml','dhis2-users@lists.launchpad.net');>
>>> Unsubscribe : https://launchpad.net/~dhis2-users
>>> More help   : https://help.launchpad.net/ListHelp
>>>
>>>
>
>
> --
> Salam
> *Furqonuddin Ramdhani*
>


-- 
Regards,

Gerald
___
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] Upgrade from 2.20 to 2.22

[gerald thomas]

Boss,
I think you should upgrade the data structures of postgresql database 2.20
before migrating them to 2.22. Please read the upgrade procedures again
because there are steps you should have done. I think it will always fail
if your want to move them directly from 2.20 to 2.22

Regards,
Gerald
On Feb 18, 2016 2:38 AM, "Furqonuddin Ramdhani"  wrote:

> Hi,
>
> I already installed dhis 2.22 and want to migrate all my data from dhis
> 2.20, how the best way to do it, I already tried import the metadata from
> 2.20 to 2.22 but failed. Any suggestion ?
>
> Thanks
>
> --
> Regards,
> *Furqonuddin Ramdhani*
>
> ___
> 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] Organization Units UIDs

[gerald thomas]

Dear David,

It didn't work.

On 2/11/16, David Huser <david.hu...@swisstph.org> wrote:
> Hi Gerald
>
> This should work:
>
> SELECT uid, name FROM organisationunit
>
> Best regards
> David
>
>
> On 10.02.2016 17:47, gerald thomas wrote:
>> Dear All,
>> Please can someone help with the query on PostgreSQL that will return
>> all the facilities and their UIDs??
>>
>> Thanks for your usual cooperation.
>>
>
> ___
> 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
>


-- 
Regards,

Gerald

___
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] Organization Units UIDs

[gerald thomas]

Dear All,
Please can someone help with the query on PostgreSQL that will return
all the facilities and their UIDs??

Thanks for your usual cooperation.

-- 
Regards,

Gerald

___
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] Automatic backup and restoration of Database to Local Server

[gerald thomas]

Dear All,
Please can someone help as per subject???

On 1/8/16, gerald thomas <gerald17...@gmail.com> wrote:
> Dear All,
> Currently our Cloud Hosting and Local Servers are running on version
> 2.21 build 20928. We did an automatic rysnc to copy the database
> backup from the Cloud Hosting server to our Local server on a daily
> basis.
>
> I want Local server to automatic verify backups; drop the old database
> and import the new database it had collected every Friday on the week.
>
> Thanks in advance for your help and i will be grateful for any
> contribution.
>
> --
> Regards,
>
> Gerald
>


-- 
Regards,

Gerald

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

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

[gerald thomas]

Thanks Bob,
Noted!!! You had been so helpful to me.

Regards,
Gerald
On Dec 9, 2015 6:06 PM, "Knut Staring"  wrote:

> Thanks Bob,
>
> This is very helpful, and should be part of the documentation.
>
> Should have thought of the need for Step 7 when I was upgrading recently,
> would have saved me a ton of headache
>
> Knut
>
> On Wed, Dec 9, 2015 at 5:54 PM, Bob Jolliffe 
> wrote:
>
>> I know questions about this comes up now and again.  I just finished
>> doing exactly this for a regional server today so I list my steps here
>> for those planning a similar process.
>>
>> Starting state was a server running ubuntu 12.04, openjdk 7 and dhis2
>> 2.16.
>>
>> Database backup was made and a copy kept off the server.
>>
>> 1.  Upgrade the OS to 14.04.  This is the longest (and scariest) step
>> - a big upgrade to do over the internet.  But the recommended
>> procedure (running 'sudo do-release-upgrade') worked fine.  Took a few
>> hours.  Ubuntu creates an emergency ssh backdoor on port 1022 while
>> this is going on, but fortunately I didn't have to use it.  But we did
>> have ufw firewall running so I took the precaution of opening that
>> port just in case (sudo ufw allow 1022).
>>
>> 2.  Install oracle java 8 :
>>
>> sudo apt-get install software-properties-common
>> sudo add-apt-repository ppa:webupd8team/java
>> sudo apt-get update
>> sudo apt-get install oracle-java8-installer
>> sudo update-java-alternatives -s java-8-oracle
>>
>> 3.  Download all the upgrade scripts and war files
>> for ver in 17 18 19 20 21;
>> do
>>wget -O dhis-2.$ver.war
>> https://www.dhis2.org/download/releases/2.$ver/dhis.war;
>>wget
>> https://raw.githubusercontent.com/dhis2/dhis2-utils/master/resources/sql/upgrade-2$ver.sql
>> done
>>
>> 4.  Read carefully all the upgrade notes at:
>> https://www.dhis2.org/217-upgrade
>> https://www.dhis2.org/218-upgrade
>> https://www.dhis2.org/219-upgrade
>> https://www.dhis2.org/220-upgrade
>> https://www.dhis2.org/221-upgrade
>>
>> 5.  shutdown nginx with
>> sudo service nginx stop
>>
>> 6.  start deploying war files and checking logs as we go.  Apply
>> upgrade scripts as necessary
>>
>> dhis2-deploy-war -f dhis-2.17.war dhis2; tail -f
>> /var/lib/dhis2/dhis2/logs/catalina.out
>>
>> dhis2-deploy-war -f dhis-2.18.war dhis2; tail -f
>> /var/lib/dhis2/dhis2/logs/catalina.out
>>
>> cat upgrade-219.sql |psql dhis2
>> dhis2-deploy-war -f dhis-2.19.war dhis2; tail -f
>> /var/lib/dhis2/dhis2/logs/catalina.out
>>
>> cat upgrade-220.sql |psql dhis2
>> dhis2-deploy-war -f dhis-2.12.war dhis2; tail -f
>> /var/lib/dhis2/dhis2/logs/catalina.out
>>
>> 7.  clear nginx cache and restart
>> sudo -s
>> rm /var/cache/nginx/*
>> exit
>> sudo service nginx start
>>
>> That's about it.  So far everything seems ok.  We just hope there are
>> not problems from messy metadata.  Probably it is a better I idea to
>> do integrity checks on the metadata right at the very start (I
>> forgot).
>>
>> Note I am holding back on 2.21 upgrade because of the issue with md5
>> passwords mentioned in the upgrade notes.   I'll give the users a day
>> or two to make sure they have tested their logins.  Will take 5
>> minutes to do when the time comes.
>>
>> Note that the OS upgrade is necessary to get the right tomcat version
>> through the package system.  We could have avoided by doing a custom
>> tomcat install, but I prefer to stick with the packages.
>>
>> Hope the above helps anyone else faced with this challenge.
>>
>> Bob
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-users
>> Post to : dhis2-users@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> More help   : https://help.launchpad.net/ListHelp
>>
>
>
>
> --
> Knut Staring
> Dept. of Informatics, University of Oslo
> Norway: +4791880522
> Skype: knutstar
> http://dhis2.org
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] [Dhis2-devs] Pivot Table Not Loading

[gerald thomas]

Dear Knutst,
I didn't know anything about an database update script. I will be
sharing the logs soon. Please can you share the database update script
and thanks for your help.

On 11/29/15, knutst <knu...@gmail.com> wrote:
> Hi Gerald, we would need to see error
> messages the comsole of your browser as well as in the Tomcat log. Did you
> run the database update scripts? Regards, Knut style="font-size:75%;color:#575757">Sent from my Samsung Galaxy
> smartphone. Original message
> From: gerald thomas gerald17...@gmail.com
> Date: 2015/11/29  10:00 am  (GMT+06:30) Date:2015/11/29
> 10:00 am  (GMT+06:30) To: dhis2-users
> dhis2-users@lists.launchpad.net, dhis2-devs
> dhis2-d...@lists.launchpad.net Cc:  Subject:
> Re: [Dhis2-devs] Pivot Table Not Loading Dear All,
> Please any help my Data not displaying in Pivot tables it keeps
> showing "initializing".
>
> On 11/28/15, gerald thomas <gerald17...@gmail.com> wrote:
>> Dear All,
>> We updated our instance in Sierra Leone from 2.18 to 2.19 and finally
>> to 2.20. The job was successfully completed with everything working as
>> it should when it was on the 2.19 war file. But on the 2.20 war file
>> the pivot table is not working. Please find the attached file showing
>> where is it handing.
>>
>> Please help.
>>
>> --
>> Regards,
>>
>> Gerald
>>
>
>
> --
> Regards,
>
> Gerald
>
> ___
> 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
> null


-- 
Regards,

Gerald

___
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] Pivot Table Not Loading

[gerald thomas]

Dear All,
We updated our instance in Sierra Leone from 2.18 to 2.19 and finally
to 2.20. The job was successfully completed with everything working as
it should when it was on the 2.19 war file. But on the 2.20 war file
the pivot table is not working. Please find the attached file showing
where is it handing.

Please help.

-- 
Regards,

Gerald
___
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] Pivot Table Not Loading

[gerald thomas]

Dear All,
Please any help my Data not displaying in Pivot tables it keeps
showing "initializing".

On 11/28/15, gerald thomas <gerald17...@gmail.com> wrote:
> Dear All,
> We updated our instance in Sierra Leone from 2.18 to 2.19 and finally
> to 2.20. The job was successfully completed with everything working as
> it should when it was on the 2.19 war file. But on the 2.20 war file
> the pivot table is not working. Please find the attached file showing
> where is it handing.
>
> Please help.
>
> --
> Regards,
>
> Gerald
>


-- 
Regards,

Gerald

___
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] Problem Install DHIS2

[gerald thomas]

When type localhost:8080; does the tomcat page appears?
What i think is missing is the config_dhis folder which contains the
hibernate file.
If this file does not exist please create it because it create the
connection between postgresql and tomcat.
Regards,
Gerald
On Nov 23, 2015 08:10, "Hannan Khan"  wrote:

> Dear Ali
>
> The process describe in the manual is OK. so if you are facing problem can
> you please specify what is it. How much you progress. Did you installed
> tomcat? Is Tomcat running?
>
> Please specify, then I can guide you to solution.
>
> Regards
>
> Hannan Khan
> HISP Bangladesh
>
> On Mon, Nov 23, 2015 at 1:15 PM, Alex Tumwesigye 
> wrote:
>
>> Dear Ali,
>>
>> Please use the dhis2-tools package if you are running Linux/Unix.
>>
>> They are much easy to use.
>>
>> Alex
>>
>> On Mon, Nov 23, 2015 at 9:32 AM, Knut Staring  wrote:
>>
>>> Do you have Java 8?
>>> On Nov 23, 2015 10:05 AM, "ali murtaza"  wrote:
>>>
 regards
 I am ali from Aceh
 I've tried the steps for installation as below dhis28.3. Server setup
 8.3.1.
 Creating a user to run DHIS2
 8.3.2.
 Setting server time zone and locale (optional)
 8.3.3.
 PostgreSQL installation
 8.3.4.
 PostgreSQL performance tuning
 8.3.5.
 Database configuration
 8.3.6.
 File store configuration (optional)
 8.3.7.
 Java installation
 8.3.8.
 Install Tomcat and DHIS2
 8.3.9.
 Running DHIS2
 
 but I'm still having problems
 can you help me please..

>>>
>>> ___
>>> 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
>>>
>>>
>>
>>
>> --
>> Alex Tumwesigye
>>
>> Technical Advisor - DHIS2 (Consultant),
>> Ministry of Health/AFENET
>> Kampala
>> Uganda
>>
>> IT Consultant - BarefootPower Uganda Ltd, SmartSolar, Kenya
>>
>> IT Specialist (Servers, Networks and Security, Health Information Systems
>> - DHIS2 ) & Solar Consultant
>>
>> +256 774149 775, + 256 759 800161
>>
>> "I don't want to be anything other than what I have been - one tree hill "
>>
>> ___
>> 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
>
>
___
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] Exporting Indicators from the DHIS 2 Demo to my Instance

[gerald thomas]

Dear All,
I am finding it hard to create indicators on my local instance because
when i did pivot there is no output. Is there any way i can export and
import indicators from the Demo instance to my local instance.

Please help.

-- 
Regards,

Gerald

___
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] Exporting Indicators from the DHIS 2 Demo to my Instance

[gerald thomas]

Dear All,
How can I insert "Constant" for indicator calculation. For example
Expected Pregnancies = 243 951 in the Demo Instance or Pi

On 10/27/15, gerald thomas <gerald17...@gmail.com> wrote:
> Dear All,
> I am finding it hard to create indicators on my local instance because
> when i did pivot there is no output. Is there any way i can export and
> import indicators from the Demo instance to my local instance.
>
> Please help.
>
> --
> Regards,
>
> Gerald
>


-- 
Regards,

Gerald

___
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] Removing Organization Units

[gerald thomas]

Dear Dapo,
What is the command to remove those data from the database as per
organisation unit?
Please help me.

Regards,
Gerald
On Oct 1, 2015 16:16, "Dapo Adejumo" <dapsyjo...@gmail.com> wrote:

> Hi Gerald,
> What error are you getting?
> If you have data associated with these org units, you will not be able to
> remove them until you delete the data in the database (even if you have
> removed the datasets).
>
> ………
> Regards,
> Dapo Adejumo
> +2348033683677
> Skype : dapojorge
>
> - Original Message -
> From: "gerald thomas" <gerald17...@gmail.com>
> To: "dhis2-users" <dhis2-users@lists.launchpad.net>, "dhis2-devs" <
> dhis2-d...@lists.launchpad.net>
> Sent: Thursday, October 1, 2015 5:10:25 PM
> Subject: [Dhis2-devs] Removing Organization Units
>
> Dear All,
> I am trying to remove Organisation Units from DHIS2 versions 2.18 and
> 2.20 but i am getting error.
>
> But i had already removed the datasets associated with these
> Organisation Units but i still can't remove them.
>
> Please can someone help.
>
> --
> Regards,
>
> Gerald
>
> ___
> 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
>
___
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] Removing Organization Units

[gerald thomas]

Dear  Jason,
Thanks for help

Regards,
Gerald
On Oct 1, 2015 5:07 PM, "Jason Pickering" <jason.p.picker...@gmail.com>
wrote:

> Hi Gerald,
>
>
> Removal of orgunits with associated reports or charts is non trivial, due
> to the use of the "sort_order" in these resources. It will cause a null
> pointer exception if you just delete the orgunit.
>
> I have added two functions to the dhis2-utils repo, which handle the
> deletion and merging of orgunits.
>
> To delete a  site with data , you can try the following postgresql
> function.
>
>
> https://github.com/dhis2/dhis2-utils/blob/master/resources/sql/delete_site_with_data.sql
>
> This function accepts the UID of the organisation unit to delete.
>
> Obviously, this function is provided without any warranty. You should
> certainly make a backup of the database prior to executing it.
>
> This function will handle the removal of orgunits (with no children) and
> should handle cleaning up the various report associations as well.
>
> Be sure to clear your server cache afterwards.
>
> Best regards,
>
> Jason
>
>
>
> On Thu, Oct 1, 2015, 18:49 Bob Jolliffe <bobjolli...@gmail.com> wrote:
>
>> Gerald you would need to do this with an sql delete command.  Before
>> you do you should be 100% sure that you do really want to delete the
>> data - maybe make a backup first.
>>
>> You need to find the primary key (organisationunitid) of the orgunit
>> you want to delete.  Say it is 5677 Then:
>>
>> DELETE FROM datavalue where sourceid like 5677;
>>
>> If you have a few then something like:
>>
>> -- examples only!
>> DELETE FROM datavalue where sourceid in (5677, 5674, 3456);
>>
>> If you have many then put them in a temporary orgunit group and make a
>> fancier query.
>>
>> Note you might still get the odd error when deleting the orgunit if
>> your orgunits are being used in charts and the like.  You'll have to
>> address these one at a time.
>>
>> On 1 October 2015 at 17:39, gerald thomas <gerald17...@gmail.com> wrote:
>> > Dear Dapo,
>> > What is the command to remove those data from the database as per
>> > organisation unit?
>> > Please help me.
>> >
>> > Regards,
>> > Gerald
>> >
>> > On Oct 1, 2015 16:16, "Dapo Adejumo" <dapsyjo...@gmail.com> wrote:
>> >>
>> >> Hi Gerald,
>> >> What error are you getting?
>> >> If you have data associated with these org units, you will not be able
>> to
>> >> remove them until you delete the data in the database (even if you have
>> >> removed the datasets).
>> >>
>> >> ………
>> >> Regards,
>> >> Dapo Adejumo
>> >> +2348033683677
>> >> Skype : dapojorge
>> >>
>> >> - Original Message -
>> >> From: "gerald thomas" <gerald17...@gmail.com>
>> >> To: "dhis2-users" <dhis2-users@lists.launchpad.net>, "dhis2-devs"
>> >> <dhis2-d...@lists.launchpad.net>
>> >> Sent: Thursday, October 1, 2015 5:10:25 PM
>> >> Subject: [Dhis2-devs] Removing Organization Units
>> >>
>> >> Dear All,
>> >> I am trying to remove Organisation Units from DHIS2 versions 2.18 and
>> >> 2.20 but i am getting error.
>> >>
>> >> But i had already removed the datasets associated with these
>> >> Organisation Units but i still can't remove them.
>> >>
>> >> Please can someone help.
>> >>
>> >> --
>> >> Regards,
>> >>
>> >> Gerald
>> >>
>> >> ___
>> >> 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
>> >
>> >
>> > ___
>> > 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
>> >
>>
>> ___
>> 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
>>
>
___
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] Removing Organization Units

[gerald thomas]

Dear All,
The error message: "Object not deleted because it is associated by
objects of type DataValue"

On 10/1/15, gerald thomas <gerald17...@gmail.com> wrote:
> Dear All,
> I am trying to remove Organisation Units from DHIS2 versions 2.18 and
> 2.20 but i am getting error.
>
> But i had already removed the datasets associated with these
> Organisation Units but i still can't remove them.
>
> Please can someone help.
>
> --
> Regards,
>
> Gerald
>


-- 
Regards,

Gerald

___
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] Removing Organization Units

[gerald thomas]

Dear Bob,
Thanks very much for your help. Will get back to you with feedback.

Regards,
Gerald
On Oct 1, 2015 4:49 PM, "Bob Jolliffe" <bobjolli...@gmail.com> wrote:

> Gerald you would need to do this with an sql delete command.  Before
> you do you should be 100% sure that you do really want to delete the
> data - maybe make a backup first.
>
> You need to find the primary key (organisationunitid) of the orgunit
> you want to delete.  Say it is 5677 Then:
>
> DELETE FROM datavalue where sourceid like 5677;
>
> If you have a few then something like:
>
> -- examples only!
> DELETE FROM datavalue where sourceid in (5677, 5674, 3456);
>
> If you have many then put them in a temporary orgunit group and make a
> fancier query.
>
> Note you might still get the odd error when deleting the orgunit if
> your orgunits are being used in charts and the like.  You'll have to
> address these one at a time.
>
> On 1 October 2015 at 17:39, gerald thomas <gerald17...@gmail.com> wrote:
> > Dear Dapo,
> > What is the command to remove those data from the database as per
> > organisation unit?
> > Please help me.
> >
> > Regards,
> > Gerald
> >
> > On Oct 1, 2015 16:16, "Dapo Adejumo" <dapsyjo...@gmail.com> wrote:
> >>
> >> Hi Gerald,
> >> What error are you getting?
> >> If you have data associated with these org units, you will not be able
> to
> >> remove them until you delete the data in the database (even if you have
> >> removed the datasets).
> >>
> >> ………
> >> Regards,
> >> Dapo Adejumo
> >> +2348033683677
> >> Skype : dapojorge
> >>
> >> - Original Message -
> >> From: "gerald thomas" <gerald17...@gmail.com>
> >> To: "dhis2-users" <dhis2-users@lists.launchpad.net>, "dhis2-devs"
> >> <dhis2-d...@lists.launchpad.net>
> >> Sent: Thursday, October 1, 2015 5:10:25 PM
> >> Subject: [Dhis2-devs] Removing Organization Units
> >>
> >> Dear All,
> >> I am trying to remove Organisation Units from DHIS2 versions 2.18 and
> >> 2.20 but i am getting error.
> >>
> >> But i had already removed the datasets associated with these
> >> Organisation Units but i still can't remove them.
> >>
> >> Please can someone help.
> >>
> >> --
> >> Regards,
> >>
> >> Gerald
> >>
> >> ___
> >> 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
> >
> >
> > ___
> > 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
> >
>
___
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] Removing Organization Units

[gerald thomas]

Dear All,
I am trying to remove Organisation Units from DHIS2 versions 2.18 and
2.20 but i am getting error.

But i had already removed the datasets associated with these
Organisation Units but i still can't remove them.

Please can someone help.

-- 
Regards,

Gerald

___
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] Upgrading from 2.5 to 2.20 using dhis-live

[gerald thomas]

Dear Alex,
>From the link you shared i am only seeing 2.10 to 2.20. I can't find
2.6 to 2.9. Please help me and don't forget i am using dhis2-live for
my test case.

On 9/26/15, Alex Tumwesigye <atumwesi...@gmail.com> wrote:
> Dear Thomas,
>
> 2.5 is a very old version. There has been many changes till 2.20.
> I would suggest that you do a systematic upgrade 2.5 to 2.6 to 2.7 to
> 2.8..2.20.
> It is a simple process you need to stop the tomcat server, then dump the
> war file and start the server again for each version.for version 2.13 to
> 2.20.you may need to run upgrade scripts before dumping the war file.
>
> You can get war files from https://apps.dhis2.org/ci
>
> Good luck.
>
> Alex
>
> On Friday, September 25, 2015, gerald thomas <gerald17...@gmail.com> wrote:
>
>> Dear All,
>> I am trying to upgrade one of our local (standalone server) instances
>> of dhis2 which was running on version 2.5. I exported the database and
>> import  the database into a dhis2-live version 2.20.
>> The application is running on windows and my database is PostgreSQL
>> 9.3.9. The upgrade was successful but when i ran "Data Set Report" for
>> a particular Data Set; i am getting a blank report.
>>
>> I tried to do "Analytic and Data Mart" but i am getting error. Please
>> find the attached log files.
>>
>>
>> Please can someone help?
>>
>> --
>> Regards,
>>
>> Gerald
>>
>
>
> --
> Alex Tumwesigye
>
> Technical Advisor - DHIS2 (Consultant),
> Ministry of Health/AFENET
> Kampala
> Uganda
>
> IT Consultant - BarefootPower Uganda Ltd, SmartSolar, Kenya
>
> IT Specialist (Servers, Networks and Security, Health Information Systems -
> DHIS2 ) & Solar Consultant
>
> +256 774149 775, + 256 759 800161
>
> "I don't want to be anything other than what I have been - one tree hill "
>


-- 
Regards,

Gerald

___
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] Upgrading from 2.5 to 2.20 using dhis-live

[gerald thomas]

Dear All,
Where can i download old DHIS 2 live (2.7 or 2.9 or
2.102.19). I am trying to see if that will help me analyze
my issues properly.

Please help me.

On 9/26/15, gerald thomas <gerald17...@gmail.com> wrote:
> Dear Alex,
> From the link you shared i am only seeing 2.10 to 2.20. I can't find
> 2.6 to 2.9. Please help me and don't forget i am using dhis2-live for
> my test case.
>
> On 9/26/15, Alex Tumwesigye <atumwesi...@gmail.com> wrote:
>> Dear Thomas,
>>
>> 2.5 is a very old version. There has been many changes till 2.20.
>> I would suggest that you do a systematic upgrade 2.5 to 2.6 to 2.7 to
>> 2.8..2.20.
>> It is a simple process you need to stop the tomcat server, then dump the
>> war file and start the server again for each version.for version 2.13 to
>> 2.20.you may need to run upgrade scripts before dumping the war file.
>>
>> You can get war files from https://apps.dhis2.org/ci
>>
>> Good luck.
>>
>> Alex
>>
>> On Friday, September 25, 2015, gerald thomas <gerald17...@gmail.com>
>> wrote:
>>
>>> Dear All,
>>> I am trying to upgrade one of our local (standalone server) instances
>>> of dhis2 which was running on version 2.5. I exported the database and
>>> import  the database into a dhis2-live version 2.20.
>>> The application is running on windows and my database is PostgreSQL
>>> 9.3.9. The upgrade was successful but when i ran "Data Set Report" for
>>> a particular Data Set; i am getting a blank report.
>>>
>>> I tried to do "Analytic and Data Mart" but i am getting error. Please
>>> find the attached log files.
>>>
>>>
>>> Please can someone help?
>>>
>>> --
>>> Regards,
>>>
>>> Gerald
>>>
>>
>>
>> --
>> Alex Tumwesigye
>>
>> Technical Advisor - DHIS2 (Consultant),
>> Ministry of Health/AFENET
>> Kampala
>> Uganda
>>
>> IT Consultant - BarefootPower Uganda Ltd, SmartSolar, Kenya
>>
>> IT Specialist (Servers, Networks and Security, Health Information Systems
>> -
>> DHIS2 ) & Solar Consultant
>>
>> +256 774149 775, + 256 759 800161
>>
>> "I don't want to be anything other than what I have been - one tree hill
>> "
>>
>
>
> --
> Regards,
>
> Gerald
>


-- 
Regards,

Gerald

___
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] login issue

[gerald thomas]

Dear Araz,
I am using Tracker Capture and I am using DHIS2 2.18. I am not sure of the
stability of 2.19 and 2.20. But there are others which I don't how it works
or how to configure them. Java versions running on Nokia platforms.
Please help

Regards,
Gerald
On Sep 17, 2015 8:18 AM, "Araz Abishov" <araz.abishov.g...@gmail.com> wrote:

> Hello Faraz and Gerald,
>
> Which android applications (Dashboard, Aggregate, Event or Tracker
> capture) are you using? And which version of DHIS2 server are you running?
> Please note, that all mentioned android apps are compatible only with 2.20.
>
> Best Regards,
> Araz
>
> On Thu, Sep 17, 2015 at 5:02 AM, Morten Olav Hansen <morte...@gmail.com>
> wrote:
>
>> Ok, I will let one our the guys from our Android team answer your
>> question, but please make sure you are using the latest release, and that
>> your server is running DHIS 2.20 (I'm not sure if this is a requirement or
>> not to be honest).
>>
>> It should be able to successfully work against
>> https://apps.dhis2.org/demo at least (which is our server running the
>> latest 2.20)
>>
>> --
>> Morten
>>
>> On Thu, Sep 17, 2015 at 9:55 AM, gerald thomas <gerald17...@gmail.com>
>> wrote:
>>
>>> Morten,
>>> I am sure it the android app and I am having the same issue. Now is it
>>> because my DHIS2 is running on 2.18 because whether way I had tried it
>>> saying "wrong URL"
>>>
>>> Regards,
>>> Gerald
>>> On Sep 17, 2015 2:30 AM, "Morten Olav Hansen" <morte...@gmail.com>
>>> wrote:
>>>
>>>> Hi Faraz
>>>>
>>>> I think we need a bit more information here. Are you trying to install
>>>> DHIS 2 live on your pc?
>>>>
>>>> You mentioned "enter server URL", is this an Android device? and you
>>>> want to try out our app?
>>>>
>>>> --
>>>> Morten
>>>>
>>>> On Wed, Sep 16, 2015 at 7:52 PM, Matthieu Pinard <matth...@pinard.no>
>>>> wrote:
>>>>
>>>>>
>>>>> Dear Faraz,
>>>>>
>>>>> let me foward your question to the community of users and developers
>>>>>
>>>>> Cheers,
>>>>> Matthieu
>>>>>
>>>>> On Tuesday, 15 September 2015, Faraz <faraz.siddi...@mariestopespk.org>
>>>>> wrote:
>>>>>
>>>>>> Hi
>>>>>>
>>>>>> When i installed dhis2 on my tablet pc, its need (enter server URL),
>>>>>> whats this mean?
>>>>>> Please help.
>>>>>>
>>>>>> Faraz
>>>>>> --
>>>>>> This message was sent from Launchpad by
>>>>>> Faraz (https://launchpad.net/~faraz-siddiqui)
>>>>>> using the "Contact this team's admins" link on the DHIS 2 Users team
>>>>>> page
>>>>>> (https://launchpad.net/~dhis2-users).
>>>>>> For more information see
>>>>>> https://help.launchpad.net/YourAccount/ContactingPeople
>>>>>>
>>>>>
>>>>>
>>>>> --
>>>>> Matthieu Pinard
>>>>> DHIS 2 Academy & Community Coordinator | University of Oslo
>>>>>
>>>>>
>>>>> ___
>>>>> 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
>>>>>
>>>>>
>>>>
>>>> ___
>>>> 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-devs
>> Post to : dhis2-d...@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-devs
>> 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-devs] Data Collection App or Tool

[gerald thomas]

Dear Johan,
I totally agreed with you but i am expecting the University of Olso or
DHIS2 developers to help me with a proposed solution; not a total
solution but something that might reduce the gap between data
collection and data entry.

Project like this usually have the support of NGOs which means
logistics won't be a problem for the first 5 years and since it might
be a piloting phase for Sierra Leone, with it success other countries
might benefit from such an application.

On 9/16/15, Johan Ivar Sæbø <joha...@ifi.uio.no> wrote:
> Hi Gerald.
>
> You're raising a complex issue, and one that is not immediately solved
> by technology I think. So the main issue is that the 10 or so paper
> forms in Sierra Leone are not always coming in from the facilities to
> the districts, with the additional issue that district staff find it
> hard to reach back to the facility staff if they have any questions?
> Using mobile solutions might be helpful for both these issues, but will
> raise other issues of infrastructure, support and costs etc.
>
> You can find info about DHIS2 mobile solutions here:
> https://www.dhis2.org/doc/snapshot/en/user/html/ch24.html#mobile_intro
>
> I also have a few comments:
>
> 1) If all facility reporting is affected by these problems, it would
> probably be too much to report by SMS anyway. There are hundreds of data
> elements. Mobile browser based data entry might be better
> 2) If you have logistical problems of supplying facilities with paper
> forms, you might have problems relying on a working distribution of
> phones also, which needs network coverage, charging, support, credits, etc.
>
> Maybe someone on the list have experiences with mobile data collection
> they can share? I know such data collection once featured in the
> long-term plan for Sierra Leone.
>
> Johan
>
> On 15.09.2015 17:22, gerald thomas wrote:
>> Dear All,
>> In Sierra Leone, every district (13) has a DHMT who received
>> aggregated data report from the facilities (PHUs). During my
>> assessment i found a very big gap between data collection and data
>> entry which i am sure is affecting the quality of data in Sierra
>> Leone.
>>
>> Firstly, Stock out of Data Entry Forms (paper based forms).
>>
>> Secondly, Data Entry Clerks can't question information from the Data
>> Collectors neither will the HMIS Staff question the Data Entry Clerks;
>> because they are only entering what is on the paper base records they
>> received from their various PHUs.
>>
>> In light of this, how can we closed this gap using an application
>> running on a very basic protocol (SMS or syncing).
>>
>> Copy in this mail is someone who is willing to help us with partners
>> who might fund such a project.
>>
>> Thanks in advance for your cooperation.
>>
>
>


-- 
Regards,

Gerald

___
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] login issue

[gerald thomas]

Morten,
I am sure it the android app and I am having the same issue. Now is it
because my DHIS2 is running on 2.18 because whether way I had tried it
saying "wrong URL"

Regards,
Gerald
On Sep 17, 2015 2:30 AM, "Morten Olav Hansen"  wrote:

> Hi Faraz
>
> I think we need a bit more information here. Are you trying to install
> DHIS 2 live on your pc?
>
> You mentioned "enter server URL", is this an Android device? and you want
> to try out our app?
>
> --
> Morten
>
> On Wed, Sep 16, 2015 at 7:52 PM, Matthieu Pinard 
> wrote:
>
>>
>> Dear Faraz,
>>
>> let me foward your question to the community of users and developers
>>
>> Cheers,
>> Matthieu
>>
>> On Tuesday, 15 September 2015, Faraz 
>> wrote:
>>
>>> Hi
>>>
>>> When i installed dhis2 on my tablet pc, its need (enter server URL),
>>> whats this mean?
>>> Please help.
>>>
>>> Faraz
>>> --
>>> This message was sent from Launchpad by
>>> Faraz (https://launchpad.net/~faraz-siddiqui)
>>> using the "Contact this team's admins" link on the DHIS 2 Users team page
>>> (https://launchpad.net/~dhis2-users).
>>> For more information see
>>> https://help.launchpad.net/YourAccount/ContactingPeople
>>>
>>
>>
>> --
>> Matthieu Pinard
>> DHIS 2 Academy & Community Coordinator | University of Oslo
>>
>>
>> ___
>> 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
>>
>>
>
> ___
> 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] Can't Login after restoring sample database

[gerald thomas]

Mugeni,

I didn't want to jump into conclusion so soon but i think the database
backup you have maybe having some issues. Do you have any other
database or can you download it again and try it.

This time you are only:
* stop tomcat
* go to pgadmin and delete database (eg dhis): I am assuming you are
using postgresql?
* create database (eg dhis2)
Please don't forget to change the database name to dhis2 on the
hibernate.properties file
* The you import the new file you had downloaded.

On 9/15/15, Mugeni Harold <hmug...@gmail.com> wrote:
> Gerald,
>
> I have followed the steps in the workaround, but still get the same
> exception.
>
> Cheers
>
> -Original Message-
> From: gerald thomas [mailto:gerald17...@gmail.com]
> Sent: Tuesday, September 15, 2015 10:53 AM
> To: Mugeni Harold
> Cc: dhis2-users@lists.launchpad.net
> Subject: Re: [Dhis2-users] Can't Login after restoring sample database
>
> Mugeni,
>
> This seem strange but if you are using win7 then you should find logs in
> C:\Program Files\apache tomcat\log (if it is 64bit you are using)
>
> or C:\Program Files(x86)\apache tomcat\log (if it is 32bit you are using).
>
> Workaround:
>
> * Shutdown tomcat
> * delete the database
> * create a new database
> * Make sure the database information is on the 'hibernate.properties' file
> * Check that the environmental variables are configured properly
> * import the database you wish to use using psql \i /C:/Desktop/dhis2g.sql
> (Note: it is desktop because i am assuming the location of the database is
> on the desktop and also change dhis2g.sql to the name of your file.sql)
>
>
> * Finally, run the command to change the admin profile to admin/district
>
> and reboot your win7 system.
>
> Good luck
>
> On 9/15/15, Mugeni Harold <hmug...@gmail.com> wrote:
>> Gerald,
>>
>> Please find attached the screenshot upon trying to login. For some
>> reason, I can't find any log files for the dhis application. I am
>> using win7 and the WAR file under tomcat.
>>
>>
>> -Original Message-
>> From: gerald thomas [mailto:gerald17...@gmail.com]
>> Sent: Tuesday, September 15, 2015 8:49 AM
>> To: Mugeni Harold
>> Cc: dhis2-users@lists.launchpad.net
>> Subject: Re: [Dhis2-users] Can't Login after restoring sample database
>>
>> Mugeni,
>>
>> Please can you send a screenshot of the error you are having and also
>> the log files?
>>
>> On 9/15/15, Mugeni Harold <hmug...@gmail.com> wrote:
>>> Dear Gerald,
>>>
>>> Thank you so much for your response. I think it works, but what is
>>> happening now is that when I try to login, an exception occurs. I
>>> don't know whether this had to do with the data imported from the
>>> sample databse because though it completed, it did give off some
>>> errors during the restore. Should I retry the restore and if so, are
>>> there some things I need to look out for before I do it?
>>>
>>> Thanks,
>>> Harold
>>>
>>> -Original Message-
>>> From: gerald thomas [mailto:gerald17...@gmail.com]
>>> Sent: Monday, September 14, 2015 4:25 PM
>>> To: Mugeni Harold
>>> Cc: dhis2-users@lists.launchpad.net
>>> Subject: Re: [Dhis2-users] Can't Login after restoring sample
>>> database
>>>
>>> Dear Mugeni,
>>> What database are you using? If it is postgresql
>>>
>>> You can connect to the database using psql admin or psql (database
>>> name)
>>>
>>> Then run this query:
>>> UPDATE users set password = '48e8f1207baef1ef7fe478a57d19f2e5' where
>>> username = 'admin';
>>>
>>> Restart the system and try admin/district
>>>
>>> Wishing you all the best.
>>>
>>> On 9/14/15, Mugeni Harold <hmug...@gmail.com> wrote:
>>>> Hallo Everyone,
>>>>
>>>>
>>>>
>>>> Hope you are all well. I have installed DHIS2 locally on my machine.
>>>> I ran it for a while with my own data and everything was ok. Later I
>>>> decided to run the application using the sample database. I created
>>>> another database called 'dhis2_sierra' and restored in it the sample
>>>> database from dhis2.org . After the restore was finished, I tried to
>>>> run it, but unfortunately I can't login anymore with the
>>>> admin/district combination. Is there something I have missed? All
>>>> your feedback will be appreciated.
>>>>
>>>>
>>>>
>>>> Thank you,
>>>>
>>>> Harold
>>>>
>>>>
>>>>
>>>>
>>>
>>>
>>> --
>>> Regards,
>>>
>>> Gerald
>>>
>>>
>>
>>
>> --
>> Regards,
>>
>> Gerald
>>
>
>
> --
> Regards,
>
> Gerald
>
>


-- 
Regards,

Gerald

___
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] Can't Login after restoring sample database

[gerald thomas]

Mugeni,

This seem strange but if you are using win7 then you should find logs
in C:\Program Files\apache tomcat\log (if it is 64bit you are using)

or C:\Program Files(x86)\apache tomcat\log (if it is 32bit you are using).

Workaround:

* Shutdown tomcat
* delete the database
* create a new database
* Make sure the database information is on the 'hibernate.properties' file
* Check that the environmental variables are configured properly
* import the database you wish to use using psql
\i /C:/Desktop/dhis2g.sql (Note: it is desktop because i am assuming
the location of the database is on the desktop and also change
dhis2g.sql to the name of your file.sql)


* Finally, run the command to change the admin profile to admin/district

and reboot your win7 system.

Good luck

On 9/15/15, Mugeni Harold <hmug...@gmail.com> wrote:
> Gerald,
>
> Please find attached the screenshot upon trying to login. For some reason, I
> can't find any log files for the dhis application. I am using win7 and the
> WAR file under tomcat.
>
>
> -Original Message-
> From: gerald thomas [mailto:gerald17...@gmail.com]
> Sent: Tuesday, September 15, 2015 8:49 AM
> To: Mugeni Harold
> Cc: dhis2-users@lists.launchpad.net
> Subject: Re: [Dhis2-users] Can't Login after restoring sample database
>
> Mugeni,
>
> Please can you send a screenshot of the error you are having and also the
> log files?
>
> On 9/15/15, Mugeni Harold <hmug...@gmail.com> wrote:
>> Dear Gerald,
>>
>> Thank you so much for your response. I think it works, but what is
>> happening now is that when I try to login, an exception occurs. I
>> don't know whether this had to do with the data imported from the
>> sample databse because though it completed, it did give off some
>> errors during the restore. Should I retry the restore and if so, are
>> there some things I need to look out for before I do it?
>>
>> Thanks,
>> Harold
>>
>> -Original Message-
>> From: gerald thomas [mailto:gerald17...@gmail.com]
>> Sent: Monday, September 14, 2015 4:25 PM
>> To: Mugeni Harold
>> Cc: dhis2-users@lists.launchpad.net
>> Subject: Re: [Dhis2-users] Can't Login after restoring sample database
>>
>> Dear Mugeni,
>> What database are you using? If it is postgresql
>>
>> You can connect to the database using psql admin or psql (database
>> name)
>>
>> Then run this query:
>> UPDATE users set password = '48e8f1207baef1ef7fe478a57d19f2e5' where
>> username = 'admin';
>>
>> Restart the system and try admin/district
>>
>> Wishing you all the best.
>>
>> On 9/14/15, Mugeni Harold <hmug...@gmail.com> wrote:
>>> Hallo Everyone,
>>>
>>>
>>>
>>> Hope you are all well. I have installed DHIS2 locally on my machine.
>>> I ran it for a while with my own data and everything was ok. Later I
>>> decided to run the application using the sample database. I created
>>> another database called 'dhis2_sierra' and restored in it the sample
>>> database from dhis2.org . After the restore was finished, I tried to
>>> run it, but unfortunately I can't login anymore with the
>>> admin/district combination. Is there something I have missed? All
>>> your feedback will be appreciated.
>>>
>>>
>>>
>>> Thank you,
>>>
>>> Harold
>>>
>>>
>>>
>>>
>>
>>
>> --
>> Regards,
>>
>> Gerald
>>
>>
>
>
> --
> Regards,
>
> Gerald
>


-- 
Regards,

Gerald

___
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] Data Collection App or Tool

[gerald thomas]

Dear All,
In Sierra Leone, every district (13) has a DHMT who received
aggregated data report from the facilities (PHUs). During my
assessment i found a very big gap between data collection and data
entry which i am sure is affecting the quality of data in Sierra
Leone.

Firstly, Stock out of Data Entry Forms (paper based forms).

Secondly, Data Entry Clerks can't question information from the Data
Collectors neither will the HMIS Staff question the Data Entry Clerks;
because they are only entering what is on the paper base records they
received from their various PHUs.

In light of this, how can we closed this gap using an application
running on a very basic protocol (SMS or syncing).

Copy in this mail is someone who is willing to help us with partners
who might fund such a project.

Thanks in advance for your cooperation.

-- 
Regards,

Gerald

___
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] Editing Dataset

[gerald thomas]

Dear Johan,
Thanks for your help. It was successful.

On 9/14/15, Johan Ivar Sæbø <joha...@ifi.uio.no> wrote:
> Hi Gerald,
>
> you need to delete the [Underfives death ..] data element link in the
> table, and insert the [maternal deaths..]. And vice versa. I remember it
> can be tricky to see the cursor, but try to place it to the left of the
> link and press "delete". Then you can filter for the right data element
> in the selection box and click "insert".
>
> More info on custom forms here
> https://www.dhis2.org/doc/snapshot/en/user/html/ch06s02.html#customDataEntryForm
>
> Johan
>
> On 14.09.2015 14:15, gerald thomas wrote:
>> Dear All,
>> I am not sure how to edit the dataset of HF6. The data elements: 'No.
>> of maternal deaths reported in community' and 'Number of under-fives
>> death reported in community' were swap. I need to edit to correct the
>> swap.
>>
>> Kindly help me with the procedures.
>>
>> Please find the attached view.
>>
>> Thanks in advance for your cooperation.
>>
>>
>>
>> ___
>> 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
>>
>
>


-- 
Regards,

Gerald

___
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] Can't Login after restoring sample database

[gerald thomas]

Dear Mugeni,
What database are you using? If it is postgresql

You can connect to the database using psql admin or psql (database name)

Then run this query:
UPDATE users set password = '48e8f1207baef1ef7fe478a57d19f2e5' where
username = 'admin';

Restart the system and try admin/district

Wishing you all the best.

On 9/14/15, Mugeni Harold  wrote:
> Hallo Everyone,
>
>
>
> Hope you are all well. I have installed DHIS2 locally on my machine. I ran
> it for a while with my own data and everything was ok. Later I decided to
> run the application using the sample database. I created another database
> called 'dhis2_sierra' and restored in it the sample database from dhis2.org
> . After the restore was finished, I tried to run it, but unfortunately I
> can't login anymore with the admin/district combination. Is there something
> I have missed? All your feedback will be appreciated.
>
>
>
> Thank you,
>
> Harold
>
>
>
>


-- 
Regards,

Gerald

___
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] Deactivatimg Lock Exception (Data Loss)

[gerald thomas]

Dear Morten,
Sierra Leone is experience a rear situation.
There is a lock exception which was activated for the various
forms(HF1, HF2, HF3, HF4, HF5, HF6, HF7 and HF8) per month. But when
the rule are remove for those particular months; on HF1(No. of fever
cases, total head counts, total OPD, No. of pregnant women treated,
No. of lactating mothers treated) and HF8(Antenatal) these data
elements are still showing "Data Sets is Locked" and these values are
not being submitted into the database.

Please find the attached view of the data elements.



On 9/11/15, Morten Olav Hansen <morte...@gmail.com> wrote:
> Hi
>
> As I said, all you have to do is to edit your data set, and set expiry days
> to 0. That will make sure that the data set never expires.
>
> I assume you mean deactivate data set locks, not exceptions.
>
> --
> Morten
>
> On Fri, Sep 11, 2015 at 9:21 AM, gerald thomas <gerald17...@gmail.com>
> wrote:
>
>> Dear All,
>> I am using 2.18 and i want to know how i can deactivate lock exception
>> on data elements permanently.
>> Please help me it is urgent.
>> --
>> Regards,
>>
>> Gerald
>>
>> ___
>> 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
>>
>


-- 
Regards,

Gerald
___
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] Deactivatimg Lock Exception (Data Loss)

[gerald thomas]

Dear Knut,
I am so much confused that i really don't know what to do or how to
explain this issues to our Director.
I had already remove all the lock exceptions but the issue is the
same. I have another topic on the forum which is "Data Loss"; i only
found out that these data are actually not submitting these data on
the database.
I don't know if it is a bug but we need to fix this issues.

Thanks in advance for your time and cooperation.

On 9/11/15, Knut Staring <knu...@gmail.com> wrote:
> Dear Gerald,
>
> So you are in fact NOT looking to remove all lock exceptions completely?
> You want to keep them, but you have a problem with how they function?
>
>
>
> On Fri, Sep 11, 2015 at 10:04 AM, gerald thomas <gerald17...@gmail.com>
> wrote:
>
>> Dear Morten,
>> Sierra Leone is experience a rear situation.
>> There is a lock exception which was activated for the various
>> forms(HF1, HF2, HF3, HF4, HF5, HF6, HF7 and HF8) per month. But when
>> the rule are remove for those particular months; on HF1(No. of fever
>> cases, total head counts, total OPD, No. of pregnant women treated,
>> No. of lactating mothers treated) and HF8(Antenatal) these data
>> elements are still showing "Data Sets is Locked" and these values are
>> not being submitted into the database.
>>
>> Please find the attached view of the data elements.
>>
>>
>>
>> On 9/11/15, Morten Olav Hansen <morte...@gmail.com> wrote:
>> > Hi
>> >
>> > As I said, all you have to do is to edit your data set, and set expiry
>> days
>> > to 0. That will make sure that the data set never expires.
>> >
>> > I assume you mean deactivate data set locks, not exceptions.
>> >
>> > --
>> > Morten
>> >
>> > On Fri, Sep 11, 2015 at 9:21 AM, gerald thomas <gerald17...@gmail.com>
>> > wrote:
>> >
>> >> Dear All,
>> >> I am using 2.18 and i want to know how i can deactivate lock exception
>> >> on data elements permanently.
>> >> Please help me it is urgent.
>> >> --
>> >> Regards,
>> >>
>> >> Gerald
>> >>
>> >> ___
>> >> 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
>> >>
>> >
>>
>>
>> --
>> Regards,
>>
>> Gerald
>>
>
>
>
> --
> Knut Staring
> Dept. of Informatics, University of Oslo
> Norway: +4791880522
> Skype: knutstar
> http://dhis2.org
>


-- 
Regards,

Gerald

___
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] Lock Exception

[gerald thomas]

Dear All,
Please i want to know how i can disable lock exception on data sets
and data elements.

Thanks in advance for your cooperation.

-- 
Regards,

Gerald

___
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] Lock Exception

[gerald thomas]

We had enable it and now it had been an issue for us. How can we disable it
totally or should we upgrade to solve the issue.

Regards,
Gerald
On Sep 10, 2015 18:20, "Morten Olav Hansen" <morte...@gmail.com> wrote:

> Hi
>
> By default lock exception is off, but if you have a data set locked that
> you don't want to, you can go to edit data set, and change expiry date to 0.
>
> --
> Morten
>
> On Thu, Sep 10, 2015 at 11:44 PM, gerald thomas <gerald17...@gmail.com>
> wrote:
>
>> Dear All,
>> Please i want to know how i can disable lock exception on data sets
>> and data elements.
>>
>> Thanks in advance for your cooperation.
>>
>> --
>> Regards,
>>
>> Gerald
>>
>> ___
>> 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] Deactivatimg Lock Exception (Data Loss)

[gerald thomas]

Dear All,
I am using 2.18 and i want to know how i can deactivate lock exception
on data elements permanently.
Please help me it is urgent.
-- 
Regards,

Gerald

___
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] Data Loss

[gerald thomas]

Dear Juan,
Furthermore, for another district "Bonthe" with organisation units
(Bendu Cha, BMC, Bum
Dema, Imperi, Jong, Kpanda Kemoh, Kwamabai Krim, Nongoba Bullum,
Sittia, Sogbini, Yawbeko)

From the query again,
hmis=# SELECT period.startdate, period.enddate, organisationunit.name,
count(datavalue.sourceid) FROM datavalue, period, organisationunit
hmis-# WHERE datavalue.periodid = period.periodid AND
datavalue.sourceid = organisationunit.organisationunitid
hmis-# AND datavalue.dataelementid IN (SELECT dataelementid FROM
dataelement WHERE uid IN
hmis(# 
('Uh0eZaSBoy1','EByDLRrUQQ7','t4cOzeDmRBS','oQstHNsrsJm','q22MFSRWNe8','wyMiVZXcDp4','mPNtI6rlJgx','CzFJu6gOT8a','H5lP3PsNGmn','gSDWcj0oWwb','US013EpQT09','MciaFRdH99E','wcO9l9VDdjm','GNPQd1JagxH','Ch6DcBg6c6o','M24QWMWyKhX'))
hmis-# AND datavalue.sourceid IN (SELECT organisationunitid FROM
organisationunit WHERE uid in
('WBbZ4IsR4fJ','KuGGNmQRNRG','ZNSxAuPYkmc','bAfHAdToWpH','JGXzvo6cui0','qgKbTso4uxs','BwLuMFCgNXY','gbBGavOWAOJ','pxCSw2YnJkG','eqvAT82OSZK','Rftqk5lhju2','bSeyZOqAPAo'))
hmis-# GROUP BY period.startdate, period.enddate,
organisationunit.name, datavalue.sourceid;
 startdate  |  enddate   | name | count
++--+---
 2013-11-01 | 2013-11-30 | BMC  | 6
 (1 row)

Please help me; i need to know why this is happening. As you can see
we had been loosing data for quit awhile now on those data elements.

On 9/7/15, gerald thomas <gerald17...@gmail.com> wrote:
> Dear Juan,
> Sorry about the time lapse for this subject but i am currently in the
> field trying to understand why we are having the data loss. One of our
> district "Pujehun" is currently facing this issue. The data entry
> clerk said he had successfully entered information for 2 months:
> January & February and partially for March 2015 for one of his
> organisation unit "Barri" which has the  following sub organisation
> units ( Bandasuma CHC, Konia MCHP, Njaluahun CHP, Potoru CHC, Saahun
> (barri) MCHP, Tambeyama MCHP, Taninahun MCHP, Vaama MCHP, Waiima
> MCHP). Barri and its sub-organisation unit have information for
> February and March 2015 as per the following data elements: suspected
> malaria; total head counts all services, etc but not January 2015.
>
> Using the query you gave me the last time i discovered the following:
>
> SELECT period.startdate, period.enddate, organisationunit.name,
> count(datavalue.sourceid) FROM datavalue, period, organisationunit
> WHERE datavalue.periodid = period.periodid AND  datavalue.sourceid =
> organisationunit.organisationunitid
> AND datavalue.dataelementid IN (SELECT dataelementid FROM dataelement
> WHERE uid IN
> ('Uh0eZaSBoy1','EByDLRrUQQ7','t4cOzeDmRBS','oQstHNsrsJm','q22MFSRWNe8','wyMiVZXcDp4','mPNtI6rlJgx','CzFJu6gOT8a','H5lP3PsNGmn','gSDWcj0oWwb','US013EpQT09','MciaFRdH99E','wcO9l9VDdjm','GNPQd1JagxH','Ch6DcBg6c6o','M24QWMWyKhX'))
> AND datavalue.sourceid IN (SELECT organisationunitid FROM
> organisationunit WHERE uid in
> ('TTcxkf1OGPx','BCnDvAuxUou','r6XG4nxlNxn','BKIrj3yjYJT','bqquAB6z7lS','xZGdhrCZjTn','hOQQ0w4iYio','qHuVAR7RvCa','qHuVAR7RvCa'))
> GROUP BY period.startdate, period.enddate, organisationunit.name,
> datavalue.sourceid;
>
>
>
>  startdate  |  enddate   |name | count
> ++-+---
>  2014-09-01 | 2014-09-30 | Tambeyama MCHP  |19
>  2013-02-01 | 2013-02-28 | Konia MCHP  |19
>  2011-07-01 | 2011-07-31 | Njaluahun CHP   |22
>  2013-10-01 | 2013-10-31 | Bandasuma CHC   |33
>  2014-11-01 | 2014-11-30 | Tambeyama MCHP  |20
>  2011-05-01 | 2011-05-31 | Taninahun MCHP  |21
>  2011-11-01 | 2011-11-30 | Potoru CHC  |24
>  2014-01-01 | 2014-01-31 | Saahun (barri) MCHP |12
>  2012-09-01 | 2012-09-30 | Bandasuma CHC   |26
>  2011-08-01 | 2011-08-31 | Konia MCHP  |20
>  2012-08-01 | 2012-08-31 | Njaluahun CHP   |21
>  2013-01-01 | 2013-01-31 | Saahun (barri) MCHP | 5
>  2011-05-01 | 2011-05-31 | Tambeyama MCHP  |14
>  2014-11-01 | 2014-11-30 | Taninahun MCHP  |28
>  2013-12-01 | 2013-12-31 | Konia MCHP  |22
>  2014-09-01 | 2014-09-30 | Taninahun MCHP  |28
>  2015-02-01 | 2015-02-28 | Saahun (barri) MCHP |22
>  2013-05-01 | 2013-05-31 | Taninahun MCHP  |20
>  2012-10-01 | 2012-10-31 | Potoru CHC  |26
>  2012-03-01 | 2012-03-31 | Bandasuma CHC   |22
>  2011-04-01 | 2011-04-30 | Tambeyama MCHP  |13
>  2012-05-01 | 2012-05-31 | Tambeyama MCHP  |20
>  2014-08-01 | 2014-08-31 | Tambeyama MCHP  |20
>  2013-07-01 | 2013-07-31 | Bandasuma CHC   |10
>  2013-02-01 | 2013-02-28 | Vaama MCHP  |20
>  2015-03-01 | 2015-03-31 | Taninahun M

Re: [Dhis2-users] Data Loss

[gerald thomas]

Dear All,
Any help with reference to the information i had provided? Please help
me with ever necessary so that we could fixed this issue.

Ola & Knut,
If i want to remove all limitations (minimum and maximum) per data
elements; what the procedures?
Secondly, how can i disable dataset locked permanently? Because even
when we unlock dataset; it is still saying dataset is lock.

Thanks in advance for your cooperation.

On 9/7/15, gerald thomas <gerald17...@gmail.com> wrote:
> Dear Juan,
> Furthermore, for another district "Bonthe" with organisation units
> (Bendu Cha, BMC, Bum
> Dema, Imperi, Jong, Kpanda Kemoh, Kwamabai Krim, Nongoba Bullum,
> Sittia, Sogbini, Yawbeko)
>
> From the query again,
> hmis=# SELECT period.startdate, period.enddate, organisationunit.name,
> count(datavalue.sourceid) FROM datavalue, period, organisationunit
> hmis-# WHERE datavalue.periodid = period.periodid AND
> datavalue.sourceid = organisationunit.organisationunitid
> hmis-# AND datavalue.dataelementid IN (SELECT dataelementid FROM
> dataelement WHERE uid IN
> hmis(#
> ('Uh0eZaSBoy1','EByDLRrUQQ7','t4cOzeDmRBS','oQstHNsrsJm','q22MFSRWNe8','wyMiVZXcDp4','mPNtI6rlJgx','CzFJu6gOT8a','H5lP3PsNGmn','gSDWcj0oWwb','US013EpQT09','MciaFRdH99E','wcO9l9VDdjm','GNPQd1JagxH','Ch6DcBg6c6o','M24QWMWyKhX'))
> hmis-# AND datavalue.sourceid IN (SELECT organisationunitid FROM
> organisationunit WHERE uid in
> ('WBbZ4IsR4fJ','KuGGNmQRNRG','ZNSxAuPYkmc','bAfHAdToWpH','JGXzvo6cui0','qgKbTso4uxs','BwLuMFCgNXY','gbBGavOWAOJ','pxCSw2YnJkG','eqvAT82OSZK','Rftqk5lhju2','bSeyZOqAPAo'))
> hmis-# GROUP BY period.startdate, period.enddate,
> organisationunit.name, datavalue.sourceid;
>  startdate  |  enddate   | name | count
> ++--+---
>  2013-11-01 | 2013-11-30 | BMC  | 6
>  (1 row)
>
> Please help me; i need to know why this is happening. As you can see
> we had been loosing data for quit awhile now on those data elements.
>
> On 9/7/15, gerald thomas <gerald17...@gmail.com> wrote:
>> Dear Juan,
>> Sorry about the time lapse for this subject but i am currently in the
>> field trying to understand why we are having the data loss. One of our
>> district "Pujehun" is currently facing this issue. The data entry
>> clerk said he had successfully entered information for 2 months:
>> January & February and partially for March 2015 for one of his
>> organisation unit "Barri" which has the  following sub organisation
>> units ( Bandasuma CHC, Konia MCHP, Njaluahun CHP, Potoru CHC, Saahun
>> (barri) MCHP, Tambeyama MCHP, Taninahun MCHP, Vaama MCHP, Waiima
>> MCHP). Barri and its sub-organisation unit have information for
>> February and March 2015 as per the following data elements: suspected
>> malaria; total head counts all services, etc but not January 2015.
>>
>> Using the query you gave me the last time i discovered the following:
>>
>> SELECT period.startdate, period.enddate, organisationunit.name,
>> count(datavalue.sourceid) FROM datavalue, period, organisationunit
>> WHERE datavalue.periodid = period.periodid AND  datavalue.sourceid =
>> organisationunit.organisationunitid
>> AND datavalue.dataelementid IN (SELECT dataelementid FROM dataelement
>> WHERE uid IN
>> ('Uh0eZaSBoy1','EByDLRrUQQ7','t4cOzeDmRBS','oQstHNsrsJm','q22MFSRWNe8','wyMiVZXcDp4','mPNtI6rlJgx','CzFJu6gOT8a','H5lP3PsNGmn','gSDWcj0oWwb','US013EpQT09','MciaFRdH99E','wcO9l9VDdjm','GNPQd1JagxH','Ch6DcBg6c6o','M24QWMWyKhX'))
>> AND datavalue.sourceid IN (SELECT organisationunitid FROM
>> organisationunit WHERE uid in
>> ('TTcxkf1OGPx','BCnDvAuxUou','r6XG4nxlNxn','BKIrj3yjYJT','bqquAB6z7lS','xZGdhrCZjTn','hOQQ0w4iYio','qHuVAR7RvCa','qHuVAR7RvCa'))
>> GROUP BY period.startdate, period.enddate, organisationunit.name,
>> datavalue.sourceid;
>>
>>
>>
>>  startdate  |  enddate   |name | count
>> ++-+---
>>  2014-09-01 | 2014-09-30 | Tambeyama MCHP  |19
>>  2013-02-01 | 2013-02-28 | Konia MCHP  |19
>>  2011-07-01 | 2011-07-31 | Njaluahun CHP   |22
>>  2013-10-01 | 2013-10-31 | Bandasuma CHC   |33
>>  2014-11-01 | 2014-11-30 | Tambeyama MCHP  |20
>>  2011-05-01 | 2011-05-31 | Taninahun MCHP  |21
>>  2011-11-01 | 2011-11-30 | Potoru CHC  |24
>>  2014-01-01 | 2014-01-31 | Saahun (barri) MCHP |12
>>  2012-09-01 | 2012-09-30 | Bandasuma CHC   |26
>>  2011-08-01 | 2011-08-31 | Konia MCHP  |20
>>  2012-08-01 | 2012-08-31 | Njaluahun CHP   |21
>>  2013-01-01 | 2013-01-31 | Saahun (barri) MCHP | 5
>>  2011-05-0

Re: [Dhis2-users] Data Loss

[gerald thomas]

i) MCHP | 5
 2012-03-01 | 2012-03-31 | Njaluahun CHP   |21
 2013-11-01 | 2013-11-30 | Vaama MCHP  |36
 2012-11-01 | 2012-11-30 | Konia MCHP  |21
 2011-10-01 | 2011-10-31 | Saahun (barri) MCHP | 4
 2013-07-01 | 2013-07-31 | Njaluahun CHP   |18
 2011-11-01 | 2011-11-30 | Taninahun MCHP  |17
 2014-05-01 | 2014-05-31 | Njaluahun CHP   |27
 2013-04-01 | 2013-04-30 | Njaluahun CHP   |19
 2014-02-01 | 2014-02-28 | Njaluahun CHP   |34
 2014-07-01 | 2014-07-31 | Njaluahun CHP   |22
 2011-05-01 | 2011-05-31 | Potoru CHC  |26
 2012-06-01 | 2012-06-30 | Taninahun MCHP  |24
 2011-09-01 | 2011-09-30 | Konia MCHP  |19
 2014-10-01 | 2014-10-31 | Taninahun MCHP  |30
 2012-08-01 | 2012-08-31 | Bandasuma CHC   |22
 2012-09-01 | 2012-09-30 | Njaluahun CHP   |21
 2012-07-01 | 2012-07-31 | Potoru CHC  |24
 2011-12-01 | 2011-12-31 | Tambeyama MCHP  |15
 2012-10-01 | 2012-10-31 | Tambeyama MCHP  |22
 2011-04-01 | 2011-04-30 | Potoru CHC  |12
 2012-05-01 | 2012-05-31 | Potoru CHC  |24
 2014-08-01 | 2014-08-31 | Potoru CHC  |34
 2012-12-01 | 2012-12-31 | Taninahun MCHP  |24
 2011-07-01 | 2011-07-31 | Bandasuma CHC   |26
 2012-12-01 | 2012-12-31 | Tambeyama MCHP  |16
 2013-10-01 | 2013-10-31 | Njaluahun CHP   |28
 2013-06-01 | 2013-06-30 | Vaama MCHP  |19
 2013-05-01 | 2013-05-31 | Potoru CHC  |23
 2012-10-01 | 2012-10-31 | Taninahun MCHP  |24
 2012-04-01 | 2012-04-30 | Potoru CHC  |26
 2011-12-01 | 2011-12-31 | Taninahun MCHP  |21
 2014-10-01 | 2014-10-31 | Tambeyama MCHP  |17
 2015-03-01 | 2015-03-31 | Potoru CHC  |28
 2014-03-01 | 2014-03-31 | Saahun (barri) MCHP |14
 2012-06-01 | 2012-06-30 | Tambeyama MCHP  |20
 2013-11-01 | 2013-11-30 | Konia MCHP  |20
 2012-11-01 | 2012-11-30 | Vaama MCHP  |24
(368 rows)

(END)

The query didn't come back with any information about January 2015 for
those data elements but there is information for the others on the HF1
forms.

QUESTIONS:
1. Is it possible that minimum & maximum values as per data elements
is affecting our data?
2. We have a lock period to verify the data entry clerks efficiency;
and most of them are saying this situation normally happened after the
system had been reopened and they are trying to key in their backlogs.
Is it possible that the lock period is the cause of our loss data.

Thanks for your usual cooperation.


On 8/28/15, Juan Manuel Alcantara Acosta <jmalcanta...@gmail.com> wrote:
> Hello Gerald
> That looks fine, should return all the org units in your database. I think
> it will be simpler for you to get the UIDs from the API or from the org unit
> administration tools, for example using Organisation unit search, the
> results will show the UID in the first column.
> Regards,
> JM
>
> El 27/08/2015, a las 15:58, gerald thomas <gerald17...@gmail.com> escribió:
>
>> Dear Juan,
>> Sorry about the confusion with the query;
>>
>> To get all the UIDs for organisationunit, i tried this query but it didn't
>> work:
>>
>> SELECT * FROM organisationunit;
>>
>> Please am i correct or wrong to run this query?
>>
>> On 8/27/15, gerald thomas <gerald17...@gmail.com> wrote:
>>> Dear Juan,
>>>
>>> If it is, then please view result:
>>>
>>>
>>> hmis=# SELECT period.startdate, period.enddate, organisationunit.name,
>>> count(datavalue.sourceid) FROM datavalue, period, organisationunit
>>> hmis-# WHERE datavalue.periodid = period.periodid AND
>>> datavalue.sourceid = organisationunit.organisationunitid
>>> hmis-# AND datavalue.dataelementid IN (SELECT dataelementid FROM
>>> dataelement WHERE uid IN
>>> hmis(#
>>> ('Uh0eZaSBoy1','EByDLRrUQQ7','t4cOzeDmRBS','oQstHNsrsJm','q22MFSRWNe8','wyMiVZXcDp4','mPNtI6rlJgx','CzFJu6gOT8a','H5lP3PsNGmn','gSDWcj0oWwb','US013EpQT09','MciaFRdH99E','wcO9l9VDdjm','GNPQd1JagxH','Ch6DcBg6c6o','M24QWMWyKhX'))
>>> hmis-# AND datavalue.sourceid IN (SELECT organisationunitid FROM
>>> organisationunit WHERE uid in
>>> ('Uh0eZaSBoy1','EByDLRrUQQ7','t4cOzeDmRBS','oQstHNsrsJm','q22MFSRWNe8','wyMiVZXcDp4','mPNtI6rlJgx','CzFJu6gOT8a','H5lP3PsNGmn','gSDWcj0oWwb','US013EpQT09','MciaFRdH99E','wcO9l9VDdjm','GNPQd1JagxH','Ch6DcBg6c6o','M24QWMWyKhX'))
>>> hmis-# GROUP BY period.startdate, period.enddate,
>>> organisationunit.name, datavalue.sourceid;
>>> startdate | enddate | name | count
>>> ---+-+--+---
>>> (0 rows)
>>>
>>>
>>> On 8/27/15, gerald thomas <ger

Re: [Dhis2-users] [Dhis2-devs] Changing admin password to default

[gerald thomas]

Dear Alan,
Thanks very much

Regards,
Gerald
On Aug 31, 2015 9:22 PM, "Alan Ivey" <ai...@baosystems.com> wrote:

> Hi Gerald,
>
> You can create a password hash with Python and the Bcrypt library. Run
> this single command in your terminal to get a hash for *passwordGoesHere*:
>
> $ python -c 'import bcrypt; hash = bcrypt.hashpw("*passwordGoesHere*",
> bcrypt.gensalt(rounds=10, prefix=b"2a")); print(hash);'
>
> You can insert the resulting hash directly into the database for the admin
> user.
>
> Note: If you do not have the Bcrypt library in your Python installation,
> you should add it with pip. The following will install all prerequisites on
> a CentOS 6 system:
>
> $ yum install gcc libffi-devel python-devel python-pip
> $ pip install --user bcrypt
>
> Before attempting to change the admin user password in the database, visit
> the front page of a new installation to have DHIS2 generate data in the
> database for the admin user (you can do something as simple as $ curl -sL
> http://localhost:8080/). Then, you can enter the following query into the
> Postgres CLI with the DHIS2 database in use:
>
> UPDATE USERS SET password = '001122hashgoeshere221100' WHERE username =
> 'admin';
>
> Restart the application server (Tomcat) and then you should be able to log
> in with your new password *passwordGoesHere* or what you changed it to.
>
> Regards,
> Alan
>
> On Mon, Aug 31, 2015 at 11:02 AM, gerald thomas <gerald17...@gmail.com>
> wrote:
>
>> Dear all,
>> I am setting up a training server for staff and i am using dhis2 live
>> to achieve the task but i am using one of our database rather than the
>> default database. I had already used the following query to change the
>> admin password:
>>
>> UPDATE users set password = '48e8f1207baef1ef7fe478a57d19f2e5'
>> where username = 'admin';
>>
>> What am i doing which is wrong and why i can't login with username:
>> admin password: district
>>
>> --
>> Regards,
>>
>> Gerald
>>
>> ___
>> 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
>>
>
>
___
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] Changing admin password to default

[gerald thomas]

Dear all,
I am setting up a training server for staff and i am using dhis2 live
to achieve the task but i am using one of our database rather than the
default database. I had already used the following query to change the
admin password:

UPDATE users set password = '48e8f1207baef1ef7fe478a57d19f2e5'
where username = 'admin';

What am i doing which is wrong and why i can't login with username:
admin password: district

-- 
Regards,

Gerald

___
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] Changing admin password to default

[gerald thomas]

Dear Knut,
I am using DHIS2 live and it is version: 2.20 Build revision: 19682

On 8/31/15, Knut Staring <knu...@gmail.com> wrote:
> Hi Gerald,
>
> Which version of DHIS2?
>
> On Mon, Aug 31, 2015 at 5:02 PM, gerald thomas <gerald17...@gmail.com>
> wrote:
>
>> Dear all,
>> I am setting up a training server for staff and i am using dhis2 live
>> to achieve the task but i am using one of our database rather than the
>> default database. I had already used the following query to change the
>> admin password:
>>
>> UPDATE users set password = '48e8f1207baef1ef7fe478a57d19f2e5'
>> where username = 'admin';
>>
>> What am i doing which is wrong and why i can't login with username:
>> admin password: district
>>
>> --
>> Regards,
>>
>> Gerald
>>
>> ___
>> 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
>


-- 
Regards,

Gerald

___
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] Changing admin password to default

[gerald thomas]

Dear Knut,
1. No i didn't have it
2. Yes, the admin is there. Also when i run the query the encrypted
password had changed but the 'last update time of password' was not
changed

On 8/31/15, Knut Staring <knu...@gmail.com> wrote:
> I see. There has been a change to the password encryption in 2.21, but that
> should not affect you:
> https://www.mail-archive.com/dhis2-devs-core@lists.launchpad.net/msg00345.html
>
> You don't have the old password to log in as the admin user? Can you see in
> the database that the admin user has not been removed?
>
> On Mon, Aug 31, 2015 at 6:12 PM, gerald thomas <gerald17...@gmail.com>
> wrote:
>
>> Dear Knut,
>> I am using DHIS2 live and it is version: 2.20 Build revision: 19682
>>
>> On 8/31/15, Knut Staring <knu...@gmail.com> wrote:
>> > Hi Gerald,
>> >
>> > Which version of DHIS2?
>> >
>> > On Mon, Aug 31, 2015 at 5:02 PM, gerald thomas <gerald17...@gmail.com>
>> > wrote:
>> >
>> >> Dear all,
>> >> I am setting up a training server for staff and i am using dhis2 live
>> >> to achieve the task but i am using one of our database rather than the
>> >> default database. I had already used the following query to change the
>> >> admin password:
>> >>
>> >> UPDATE users set password = '48e8f1207baef1ef7fe478a57d19f2e5'
>> >> where username = 'admin';
>> >>
>> >> What am i doing which is wrong and why i can't login with username:
>> >> admin password: district
>> >>
>> >> --
>> >> Regards,
>> >>
>> >> Gerald
>> >>
>> >> ___
>> >> 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
>> >
>>
>>
>> --
>> Regards,
>>
>> Gerald
>>
>
>
>
> --
> Knut Staring
> Dept. of Informatics, University of Oslo
> Norway: +4791880522
> Skype: knutstar
> http://dhis2.org
>


-- 
Regards,

Gerald

___
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] Changing admin password to default

[gerald thomas]

Dear Knut,
I did but it is the same thing. This aspect of removing the password reset
is a scare because not all admins do handover.

Regards,
Gerald
On Aug 31, 2015 5:18 PM, "Jason Pickering" <jason.p.picker...@gmail.com>
wrote:

> Also, you must restart the server after you do this. Did you restart it?
>
> On Mon, Aug 31, 2015 at 6:30 PM, gerald thomas <gerald17...@gmail.com>
> wrote:
>
>> Dear Knut,
>> 1. No i didn't have it
>> 2. Yes, the admin is there. Also when i run the query the encrypted
>> password had changed but the 'last update time of password' was not
>> changed
>>
>> On 8/31/15, Knut Staring <knu...@gmail.com> wrote:
>> > I see. There has been a change to the password encryption in 2.21, but
>> that
>> > should not affect you:
>> >
>> https://www.mail-archive.com/dhis2-devs-core@lists.launchpad.net/msg00345.html
>> >
>> > You don't have the old password to log in as the admin user? Can you
>> see in
>> > the database that the admin user has not been removed?
>> >
>> > On Mon, Aug 31, 2015 at 6:12 PM, gerald thomas <gerald17...@gmail.com>
>> > wrote:
>> >
>> >> Dear Knut,
>> >> I am using DHIS2 live and it is version: 2.20 Build revision: 19682
>> >>
>> >> On 8/31/15, Knut Staring <knu...@gmail.com> wrote:
>> >> > Hi Gerald,
>> >> >
>> >> > Which version of DHIS2?
>> >> >
>> >> > On Mon, Aug 31, 2015 at 5:02 PM, gerald thomas <
>> gerald17...@gmail.com>
>> >> > wrote:
>> >> >
>> >> >> Dear all,
>> >> >> I am setting up a training server for staff and i am using dhis2
>> live
>> >> >> to achieve the task but i am using one of our database rather than
>> the
>> >> >> default database. I had already used the following query to change
>> the
>> >> >> admin password:
>> >> >>
>> >> >> UPDATE users set password = '48e8f1207baef1ef7fe478a57d19f2e5'
>> >> >> where username = 'admin';
>> >> >>
>> >> >> What am i doing which is wrong and why i can't login with username:
>> >> >> admin password: district
>> >> >>
>> >> >> --
>> >> >> Regards,
>> >> >>
>> >> >> Gerald
>> >> >>
>> >> >> ___
>> >> >> 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
>> >> >
>> >>
>> >>
>> >> --
>> >> Regards,
>> >>
>> >> Gerald
>> >>
>> >
>> >
>> >
>> > --
>> > Knut Staring
>> > Dept. of Informatics, University of Oslo
>> > Norway: +4791880522
>> > Skype: knutstar
>> > http://dhis2.org
>> >
>>
>>
>> --
>> Regards,
>>
>> Gerald
>>
>> ___
>> 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
>>
>
>
>
> --
> 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] [Dhis2-devs] Changing admin password to default

[gerald thomas]

Jason & Knut,
Is there any workaround for this task other than we had done?

Thanks in advance for your usual cooperation.

On 8/31/15, gerald thomas <gerald17...@gmail.com> wrote:
> Dear Knut,
> I did but it is the same thing. This aspect of removing the password reset
> is a scare because not all admins do handover.
>
> Regards,
> Gerald
> On Aug 31, 2015 5:18 PM, "Jason Pickering" <jason.p.picker...@gmail.com>
> wrote:
>
>> Also, you must restart the server after you do this. Did you restart it?
>>
>> On Mon, Aug 31, 2015 at 6:30 PM, gerald thomas <gerald17...@gmail.com>
>> wrote:
>>
>>> Dear Knut,
>>> 1. No i didn't have it
>>> 2. Yes, the admin is there. Also when i run the query the encrypted
>>> password had changed but the 'last update time of password' was not
>>> changed
>>>
>>> On 8/31/15, Knut Staring <knu...@gmail.com> wrote:
>>> > I see. There has been a change to the password encryption in 2.21, but
>>> that
>>> > should not affect you:
>>> >
>>> https://www.mail-archive.com/dhis2-devs-core@lists.launchpad.net/msg00345.html
>>> >
>>> > You don't have the old password to log in as the admin user? Can you
>>> see in
>>> > the database that the admin user has not been removed?
>>> >
>>> > On Mon, Aug 31, 2015 at 6:12 PM, gerald thomas <gerald17...@gmail.com>
>>> > wrote:
>>> >
>>> >> Dear Knut,
>>> >> I am using DHIS2 live and it is version: 2.20 Build revision: 19682
>>> >>
>>> >> On 8/31/15, Knut Staring <knu...@gmail.com> wrote:
>>> >> > Hi Gerald,
>>> >> >
>>> >> > Which version of DHIS2?
>>> >> >
>>> >> > On Mon, Aug 31, 2015 at 5:02 PM, gerald thomas <
>>> gerald17...@gmail.com>
>>> >> > wrote:
>>> >> >
>>> >> >> Dear all,
>>> >> >> I am setting up a training server for staff and i am using dhis2
>>> live
>>> >> >> to achieve the task but i am using one of our database rather than
>>> the
>>> >> >> default database. I had already used the following query to change
>>> the
>>> >> >> admin password:
>>> >> >>
>>> >> >> UPDATE users set password = '48e8f1207baef1ef7fe478a57d19f2e5'
>>> >> >> where username = 'admin';
>>> >> >>
>>> >> >> What am i doing which is wrong and why i can't login with
>>> >> >> username:
>>> >> >> admin password: district
>>> >> >>
>>> >> >> --
>>> >> >> Regards,
>>> >> >>
>>> >> >> Gerald
>>> >> >>
>>> >> >> ___
>>> >> >> 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
>>> >> >
>>> >>
>>> >>
>>> >> --
>>> >> Regards,
>>> >>
>>> >> Gerald
>>> >>
>>> >
>>> >
>>> >
>>> > --
>>> > Knut Staring
>>> > Dept. of Informatics, University of Oslo
>>> > Norway: +4791880522
>>> > Skype: knutstar
>>> > http://dhis2.org
>>> >
>>>
>>>
>>> --
>>> Regards,
>>>
>>> Gerald
>>>
>>> ___
>>> 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
>>>
>>
>>
>>
>> --
>> Jason P. Pickering
>> email: jason.p.picker...@gmail.com
>> tel:+46764147049
>>
>


-- 
Regards,

Gerald

___
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] Data Loss

[gerald thomas]

Dear Bob,
It is good to here from you once more. We had tried that the last time
but the situation is still the same. We had investigated the time of
those data entry clerks' PCs and some of them had no issue with their
time but it keeps happening.

How can we stop it or fix the issue?

On 8/25/15, Bob Jolliffe bobjolli...@gmail.com wrote:
 Hi Gerald

 Did you check that there is not data missing for Oct, Nov, Dec 2014
 for the same districts?  I think we had a suspicion some time back
 that there was maybe a problem with the client PC date settings.  So
 they thought they were entering for Oct 2014 but in fact it was Oct
 2015.  Hence it didn't appear in analytics and you ended up with
 future data in your database.

 Bob

 On 22 August 2015 at 21:37, gerald thomas gerald17...@gmail.com wrote:
 Dear dhis2-users,
 If someone cannot help me; can anyone explain why am i having data for
 October, November, December 2015 on my database?

 dhis=# select * from period where startdate  '2015-01-01';
  periodid | periodtypeid | startdate  |  enddate
 --+--++
   1121694 |6 | 2016-01-01 | 2016-12-31
   2058605 |3 | 2015-11-01 | 2015-11-30
   2058606 |3 | 2015-12-01 | 2015-12-31
   2058607 |3 | 2015-10-01 | 2015-10-31
   2058611 |1 | 2015-01-16 | 2015-01-16
   2058619 |1 | 2015-01-26 | 2015-01-26
   2058631 |1 | 2015-01-29 | 2015-01-29
   2058632 |3 | 2015-09-01 | 2015-09-30
   2058656 |3 | 2015-02-01 | 2015-02-28
   2058727 |3 | 2015-06-01 | 2015-06-30
   2058806 |3 | 2015-07-01 | 2015-07-31
   2058811 |2 | 2015-03-02 | 2015-03-08
   2058812 |3 | 2015-03-01 | 2015-03-31
   2058814 |3 | 2015-05-01 | 2015-05-31
   2065151 |6 | 2020-01-01 | 2020-12-31
   2072304 |3 | 2015-04-01 | 2015-04-30
   2109802 |4 | 2015-04-01 | 2015-06-30
   2115342 |3 | 2015-08-01 | 2015-08-31
   2122928 |   292091 | 2015-03-01 | 2015-04-30
   2129098 |2 | 2015-05-25 | 2015-05-31
   2129099 |1 | 2015-12-31 | 2015-12-31
 Please we need to fix this issue of data loss; can anyone out there help
 me.
 Please !!!

 On 8/20/15, gerald thomas gerald17...@gmail.com wrote:
 Dear All,
 We are having a serious issues on our online server in Sierra Leone.
 Data are normally entered but during analysis these data normally got
 missing. This had been an issue i had raised before but the situation
 is still the same and it is even worst now.

 Please this is an urgent technical problem we need to fix for Sierra
 Leone and any help will be appreciated till we overcome this
 situation.

 Please help us!

 --
 Regards,

 Gerald



 --
 Regards,

 Gerald

 ___
 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



-- 
Regards,

Gerald

___
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] Old DHIS2 War Files

[gerald thomas]

Thanks very much

Regards,
Gerald
On Aug 25, 2015 1:33 PM, Jan Henrik Øverland janhenrik.overl...@gmail.com
wrote:

 Version 2.10+ here (same source as Halvdan linked to). Just change the
 version number:

 https://apps.dhis2.org/ci/job/dhis-*2.10*
 /lastSuccessfulBuild/artifact/dhis-2/dhis-web/dhis-web-portal/target/dhis.war

 On Tue, Aug 25, 2015 at 3:13 PM, Jason Phillips ja...@hisp.org wrote:

 We have some older ones if you don't have any luck using Lars' suggestion.

 Jason Phillips
 Information Systems
 HISP South Africa

 Sent from my mobile - please excuse any typos.
 On 25 Aug 2015 15:11, Lars Helge Øverland larshe...@gmail.com wrote:

 Hi,

 you can normally use the download URL and replace 20 with the version
 you need:

 https://www.dhis2.org/download/releases/2.20/dhis.war

 Not exactly sure how many we keep.

 regards,

 Lars


 On Tue, Aug 25, 2015 at 3:06 PM, gerald thomas gerald17...@gmail.com
 wrote:

 Dear All,
 Where can i find the old DHIS2 war files?

 --
 Regards,

 Gerald

 ___
 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




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


 *This message and any attachments are subject to a disclaimer published
 at http://www.hisp.org/policies.html#comms_disclaimer
 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
 disclai...@hisp.org and a copy will be provided to you. By replying to
 this e-mail or opening any attachment you agree to be bound by the
 provisions of the disclaimer.*

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