Re: [Dhis2-users] Top Urgent Help

2018-11-28 Thread Bob Jolliffe
Hi Getachew Unfortunately no matter how many times you send it, it isn't possible for anyone on this list to help you with the information provided. We do not know which URL gives this error nor anything about the role you are logging in with. Nor the dhis2 version. These would be the types of

Re: [Dhis2-users] [Dhis2-devs] postgresql version 9.6 required for dhis version 2.31

2018-10-31 Thread Bob Jolliffe
Version 2.31 will not On Wed, 31 Oct 2018, 09:00 moses mwale, wrote: > Sorry just to interject, so dhis2 does not work with Postgres 9.5? > > On Wed, 31 Oct 2018 at 9:58 AM, Bjørn Sandvik wrote: > >> Hi, >> >> PostGIS requirement is 2.2 or later. >> AFAIK, this will still be the case for 2.31.

Re: [Dhis2-users] Upgrade DHIS 2.28 to 2.30

2018-10-03 Thread Bob Jolliffe
e. > > Watching the log file showed some error with a missing analytics table > repeated a number of times, could be be other errors I may have missed. > > On Wed, Oct 3, 2018, 19:02 Bob Jolliffe wrote: > >> There is a little bit of trickery involved with the upgrade from

Re: [Dhis2-users] Upgrade DHIS 2.28 to 2.30

2018-10-03 Thread Bob Jolliffe
There is a little bit of trickery involved with the upgrade from 2.29 to 2.30. It has been discussed earlier in this group I believe. It is related to the loading of the postgis extension. So it is quite important to understand which user you connect the database to run the upgrade.sql script,

Re: [Dhis2-users] DHIS-2 demo portal not working

2018-09-20 Thread Bob Jolliffe
Hi Randy I am not sure who is responsible for maintaining that portal demo, but perhaps one of the reasons it has fallen into disrepair is that this is really not a good example to follow. If you look at the page source you will notice that the credentials to access the objects (admin:district)

Re: [Dhis2-users] [Dhis2-devs] Setup DHIS2 in Linux (Debian)

2018-09-17 Thread Bob Jolliffe
I have made a package of dhis2 management scripts for Ubuntu (dhis2-tools) also described in implementers manual. It would be trivial enough to repackage for Debian in there is particular demand. On Mon, 17 Sep 2018, 11:01 Viktor Varland, wrote: > Hi Nayeem > > I have written down Debian 9

Re: [Dhis2-users] Dhis2.30 Failing to start

2018-08-23 Thread Bob Jolliffe
No, looks like the problem is out of memory. You need to tweak your memory settings somehow/somewhere. Where exactly depends on how much RAM you have free on the machine and what other processes might be running and using memory and how you have setup tomcat. Possibly you need to increase the

[Dhis2-users] dhis2.org maintenance

2018-05-18 Thread Bob Jolliffe
Hello The https://www.dhis2.org website is being moved on to new infrastructure this evening. You may experience some slight disruption as DNS mapping is switched over. Apologies for any inconvenience caused. If you are intending to edit the site it might be better that you hold off till

Re: [Dhis2-users] Trouble running Analytics for 2.29

2018-05-10 Thread Bob Jolliffe
but where is the postgresql log file in your setup > (with dhis2-tools)? > > The strange thing is that everything else works up until the last part of > aggregation. In other words, I can do this again and again, > > Knut > > On Thu, May 10, 2018 at 6:19 PM, Bob Jolliff

Re: [Dhis2-users] Trouble running Analytics for 2.29

2018-05-10 Thread Bob Jolliffe
Your database has popped  To find out why take a look in the postgresql log file around the same time. On Thu, 10 May 2018, 13:51 Knut Staring, wrote: > Hi all, > > Wondering if anyone has a tip for what is going wrong on my serer. I just > tested running Analytics in 2.29

Re: [Dhis2-users] Analytics taking too much time for tracker

2018-04-30 Thread Bob Jolliffe
Hi Hannan I recall you had a similar request which I responded to back in Jan 11. Maybe worth re-reading that thread as some of it seems still to be relevant. In particular: 1. The first question, as always, is has this suddenly happened or has something recently changed? Back then there had

Re: [Dhis2-users] Problem with recaptcha

2018-03-27 Thread Bob Jolliffe
Elmarie are you sure that the problem is not related to the error "Invalid domain for site key"? Maybe you need to get a new key. I am not sure if your issue is related to reCaptcha version but I would have expected a different error message. I understand that reCaptcha is upgraded to v2 from

Re: [Dhis2-users] is there someone do existdb and hadoop integreate?

2018-02-21 Thread Bob Jolliffe
Hi easy I am not really sure where you are going with this. I have used existdb experimentally with dhis2 metadata though nothing highly parallel with hadoop. Are you considering importing dhis2 data into exist? Or thinking somehow of an exist storage backend to dhis2. This one is not currently

Re: [Dhis2-users] [Dhis2-devs] Preserving DHIS2 instance (or format for export)?

2018-01-08 Thread Bob Jolliffe
and you can also have "files". Maybe the best approach is to cleanup the webapps directory (leaving only war file) then zip up all of DHIS2_HOME together with database backup. You need to think about whether you want to also keep old log files. dhis2, but also possibly proxy and postgres. It

Re: [Dhis2-users] Data Element Version??

2017-11-15 Thread Bob Jolliffe
I think of the numbers are small you are best just to maintain two different dataelementgroups of datalements with names/codes which are related. I don't think this is really a versioning problem as you describe it. Unless you are planning to go on and make more versions. It is similar to the

Re: [Dhis2-users] Server Specification

2017-11-14 Thread Bob Jolliffe
Hi Isaiah > Are there guidelines with minimum server specification for setting up a > local instance of dhis2. Not really. The actual requirements are very much dependent on the context of use - number of users, number of orgunits, tracker vs aggregate etc. If you are talking about something

Re: [Dhis2-users] [Dhis2-devs] DHIS 2, PostgreSQL only

2017-11-09 Thread Bob Jolliffe
Very good Lars! Looking at the move to postgresql 10 (presumably one or two more versions down the line), have you been considering the native partitioning support for dealing with huge datavalue tables? This looks like it might be very suited to our classic problem of large amounts of historic

Re: [Dhis2-users] Integration of OpenMRS & DHIS2

2017-11-07 Thread Bob Jolliffe
Hi Gerald My knowledge of that openmrs module is quite old .. I wrote the initial implementation but that is over 5 years ago. I think what you should do is to contact the current maintainers of the module for support on the various errors you might be seeing. I know there was some Google

Re: [Dhis2-users] postgresql 10 released

2017-10-11 Thread Bob Jolliffe
Some interesting looking new features. Per database and per table level replication could be particularly useful. On 11 October 2017 at 17:42, Lars Helge Øverland wrote: > Hi, > > postgres > > https://www.postgresql.org/about/news/1786/ > > > > > -- > Lars Helge Øverland > Lead

Re: [Dhis2-users] DHIS 2 to support PostgreSQL only?

2017-09-08 Thread Bob Jolliffe
Agree. As a prelude we can put the export import through its paces. Would be great to have a volunteer mysql Guinea pig user that we could document a migration. On 8 Sep 2017 9:27 am, "Lars Helge Øverland" wrote: > Hi all, > > I want to bring up the idea of solely support

Re: [Dhis2-users] Major speed issue with pg_restore

2017-07-18 Thread Bob Jolliffe
minutes is a pretty big difference… > > > > *From:* Bob Jolliffe [mailto:bobjolli...@gmail.com] > *Sent:* Monday, 17 July 2017 2:33 PM > *To:* Edward Robinson <erobin...@projectbalance.com> > *Cc:* Lars Helge Øverland <l...@dhis2.org>; dhis2-users < > dhis

Re: [Dhis2-users] Major speed issue with pg_restore

2017-07-17 Thread Bob Jolliffe
erland [mailto:l...@dhis2.org] > *Sent:* Monday, 17 July 2017 8:41 AM > *To:* Edward Robinson <erobin...@projectbalance.com> > *Cc:* Bob Jolliffe <bobjolli...@gmail.com>; dhis2-users < > dhis2-users@lists.launchpad.net> > *Subject:* Re: [Dhis2-users] Major speed issue with

Re: [Dhis2-users] Upgrading from 2.16

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

Re: [Dhis2-users] Major speed issue with pg_restore

2017-07-15 Thread Bob Jolliffe
Ed you never answered my earlier question about the hardware you were running on? On 15 Jul 2017 6:40 p.m., "Edward Robinson" wrote: > Sorry for this slow response, time has not been on my side  > Also, thanks Bob, Knut and Hannan for your responses. > > So to

Re: [Dhis2-users] Major speed issue with pg_restore

2017-07-14 Thread Bob Jolliffe
n (and possibly logging). I'm tweaking a little more then > going to restart it. > Some sort of progress indicator would be nice for restoring large dumps like > these. > I'll post my postgresql.conf and other details shortly. Thanks! > > -----Original Message- >

Re: [Dhis2-users] Major speed issue with pg_restore

2017-07-14 Thread Bob Jolliffe
I am also trying to understand how a plain sql dump is only 7G while the custom compressed format is 650G. But given that is true, why aren't you using the plain text dump? On 14 July 2017 at 13:02, Bob Jolliffe <bobjolli...@gmail.com> wrote: > Hi Edward > > Can you tell us a

Re: [Dhis2-users] Major speed issue with pg_restore

2017-07-14 Thread Bob Jolliffe
Hi Edward Can you tell us a bit more about the machine. In particular RAM size and disk type/speed and filesystem type. Given that you are probably not going to be running anything else on this machine while you are restoring I think you might be able to tweak a bit more aggressively just for

Re: [Dhis2-users] Server processor use 100%

2017-07-13 Thread Bob Jolliffe
server will also be decommissioned and will setup > a new server with new cardinals. I will start upgrade work after I return. > > Thank you for your valuable advice and kind concern. > > Best regards > > Hannan > > On Mon, Jul 10, 2017 at 8:21 PM, Bob Jolliffe <bobjolli

Re: [Dhis2-users] Server processor use 100%

2017-07-10 Thread Bob Jolliffe
Sorry that should have been 'ls -la /tmp' On 10 July 2017 at 10:50, Bob Jolliffe <bobjolli...@gmail.com> wrote: > Hi Hannan > > There is no circumstance that tomcat user should be running the sshd > command. It could be this machine has been compromised. Unless you have &g

Re: [Dhis2-users] Server processor use 100%

2017-07-10 Thread Bob Jolliffe
Hi Hannan There is no circumstance that tomcat user should be running the sshd command. It could be this machine has been compromised. Unless you have some strange setup that you are logging in as tomcat user. Please contact me directly if you want me to check. Meanwhile you might want to

Re: [Dhis2-users] [Dhis2-devs] critical security vulnerability found - immediate dhis upgrade required

2017-07-02 Thread Bob Jolliffe
Following this announcement by Lars back in March it is really troubling to report that we are still hearing of servers being hacked as a result of this vulnerability. The most recent case brought to my attention just over a week ago (a tomcat server running as root with a dhis2 war file from nov

Re: [Dhis2-users] [Dhis2-devs] Any open source GIS/map database tools other than DHIS2

2017-06-21 Thread Bob Jolliffe
Adding another voice in favour of qgis. I am no gis expert but even I figured out how to use it :-) @Bjørn, GeoJSON-format will be great. On 21 June 2017 at 17:38, Bjørn Sandvik wrote: > Hi, > > I would highly recommend QGIS, which is the leader among open source GIS - > well

Re: [Dhis2-users] [Dhis2-devs] HELP NEEDED: DHIS2 design issue

2017-06-13 Thread Bob Jolliffe
Hi Calle Good points. The issue of informed consent and access for clinically relevant time period is certainly important for many EMR use cases. There are of course many more issues relating to handling, storing and sharing patient data. For example transport security and node authentication

[Dhis2-users] Fwd: IHE Cardiology and IHE Quality, Research and Public Health Supplements published for Public Comment

2017-05-29 Thread Bob Jolliffe
Hi all See below the IHE request for public comment. I have worked with James Kariuki on the update to ADX. ADX is designed for the reporting of aggregate health data. Please take the time to review and comment. Regards Bob -- Forwarded message -- From: Integrating the

Re: [Dhis2-users] DHIS2 Server Academy announcement

2017-05-22 Thread Bob Jolliffe
Gentle reminder. If you are interested in attending this academy please register very soon. Regards Bob On 16 May 2017 at 13:59, Bob Jolliffe <bobjolli...@gmail.com> wrote: > Apologies for cross-posting. > > Registration is now open for the second DHIS2 server academy in Accr

Re: [Dhis2-users] DHIS2 Server Academy announcement

2017-05-17 Thread Bob Jolliffe
members attend. > > Thanks! > Ime > Abuja > > > On 5/16/2017 5:32 PM, Bob Jolliffe wrote: > > Correction that is 26 to 29 June. > > On 16 May 2017 1:59 p.m., "Bob Jolliffe" <bobjolli...@gmail.com> wrote: > >> Apologies for cross-posting.

Re: [Dhis2-users] DHIS2 Server Academy announcement

2017-05-16 Thread Bob Jolliffe
Correction that is 26 to 29 June. On 16 May 2017 1:59 p.m., "Bob Jolliffe" <bobjolli...@gmail.com> wrote: > Apologies for cross-posting. > > Registration is now open for the second DHIS2 server academy in Accra, > June 24-28. Spaces are limited and time is ti

[Dhis2-users] DHIS2 Server Academy announcement

2017-05-16 Thread Bob Jolliffe
Apologies for cross-posting. Registration is now open for the second DHIS2 server academy in Accra, June 24-28. Spaces are limited and time is tight so if you are interested, please register without delay. The registration page and more info can be found at

[Dhis2-users] New system administrator list

2017-03-31 Thread Bob Jolliffe
Hi all Recently we held a small academy in Kigali, Rwanda, dedicated to system administration aspects of dhis2. The time was 4 days, which was too short, so amongst other things we resolved that we would continue to interact and learn together as a community of practice going forward. One way

Re: [Dhis2-users] WAR file cannot deploy in tomcat 8

2017-03-01 Thread Bob Jolliffe
gt; at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:717) > at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:940) > at org.apache.catalina.startup.HostConfig$DeployWar.run( > HostConfig.java:1816) > at java.util.concurrent.Executors$RunnableAdapter.call(

Re: [Dhis2-users] WAR file cannot deploy in tomcat 8

2017-03-01 Thread Bob Jolliffe
Hi Hannan There is not sufficient info in this message to be able to help. We know from your report that it failed to start. You need to look earlier in the logfile for why it failed to start. Also the java version might be helpful. Bob On 2 March 2017 at 11:24, Hannan Khan

Re: [Dhis2-users] [Dhis2-devs] UNABLE TO INSTALL DHIS2 ON A LOCAL MACHINE

2017-02-22 Thread Bob Jolliffe
Take a look in the log file (catalina.out). Your tomcat is running but it seems that the dhis.war file has not been loaded for some reason - which might be clear in the log file. On 22 February 2017 at 09:17, Stanley Kalyati wrote: > Dear Coalleagues, > > I am trying to

Re: [Dhis2-users] [Dhis2-devs] release cycle: from 4 to 3 releases per year

2017-02-03 Thread Bob Jolliffe
Lars, has there been any recent discussion over adopting an ubuntu-style approach of two types of release? I think a lot of people running large national setups with 1000's of users would be happy to see a long-term-service release maybe once a year with at least guaranteed security related

Re: [Dhis2-users] [Dhis2-devs] heads up on tomcat versions and dhis

2017-02-01 Thread Bob Jolliffe
asonable to me. We took a temporary route and > used one we knew would work until the upgrade to at least 2.24 is feasible. > > On Wed, Feb 1, 2017, 18:38 Bob Jolliffe <bobjolli...@gmail.com> wrote: > >> Thanks Jason. To make matters more complicated it looks like ubuntu >&g

Re: [Dhis2-users] [Dhis2-devs] heads up on tomcat versions and dhis

2017-02-01 Thread Bob Jolliffe
e/tomcat70/commit/a3d7be9e35505f85fc01f5f36451c7 > 10f9c9bbcc > > which introduced this, which seems to be Tomcat 7.0.73, so something > earlier than that should work as well. I am not sure which commit this was > in Tomcat 8. > > Hope that helps. > > Regards, > Jason

Re: [Dhis2-users] heads up on tomcat versions and dhis

2017-02-01 Thread Bob Jolliffe
Hi Lars and all I can see this is going to cause quite a bit of chaos with large country installations where they are not able to be too agile with upgrading. Do you have more precise info on the exact tomcat version numbers? We just saw in Zim (DHIS 2.22) that the package manager automatically

Re: [Dhis2-users] Tomcat error

2017-01-30 Thread Bob Jolliffe
mail.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. > > > > Reg

Re: [Dhis2-users] Tomcat error

2017-01-28 Thread Bob Jolliffe
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, > attributeo

Re: [Dhis2-users] Tomcat error

2017-01-28 Thread Bob Jolliffe
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

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

2017-01-26 Thread Bob Jolliffe
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. >

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

2017-01-26 Thread Bob Jolliffe
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

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

2017-01-26 Thread Bob Jolliffe
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

Re: [Dhis2-users] Extract CommCare cases and import into DHIS2

2017-01-09 Thread Bob Jolliffe
Hi David This looks useful. And nice setup instructions. One small comment - looking at your setup instructions, I don't think it is really necessary for the ccde user to have sudo membership. Or even a password. Other than installing the required python packages (which doesn't have to be

Re: [Dhis2-users] API: dataSets.dataElements

2016-11-03 Thread Bob Jolliffe
The reason why there isn't a backward compatible api is because the underlying model has changed to support overriding the categorycombo per dataset. So a dataset no longer has dataElements, but dataSetElements. The dataSetElement is a compound object consisting of both a dataelement reference

Re: [Dhis2-users] [Dhis2-devs] 25 hours in completing Analytic

2016-10-24 Thread Bob Jolliffe
Hi Calle I think Lars would probably know better, but given the kinds of cross tabulation that is happening with analytics, I doubt that it will scale linearly. Would be good to get some empirical data but I think you are probably going to have something more approaching n^2 time complexity. On

Re: [Dhis2-users] [Dhis2-devs] 25 hours in completing Analytic

2016-10-24 Thread Bob Jolliffe
For the benefit of others on this thread, this is the tweaking I shared with Neeraj - He had 3200MB shared_buffers set (as per the online manual). I suggested with his 48G of RAM he tries: shared_buffers = 12GB effective_cache_size = 20GB (remember the manual is based on an exampe machine with

Re: [Dhis2-users] how to install and run DHIS2 2.24 on window with tomcat from XAMP and restore a sql data base file with psql command

2016-10-13 Thread Bob Jolliffe
Go and check at http://localhost:8080/dhis. From the log file tomcat and your dhis application are running. Admittedly running in a 32bit jre (which you should uninstall and reinstall a 64bit one) but running all the same. On 13 October 2016 at 09:20, vunda limbe wrote: >

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

2016-10-08 Thread Bob Jolliffe
s > though they are offering administrative services and should need > monitoring as well. > > Kayode > > > On 10/8/16, Bob Jolliffe <bobjolli...@gmail.com> wrote: >> Hi Lungo >> >> Not quite what I said. It is early days for the SL shining case study >

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

2016-10-08 Thread Bob Jolliffe
ll increase. This is where iHRIS is the best option. > > Best regards, > > Lungo > > > > From: Bob Jolliffe <bobjolli...@gmail.com> > To: Arthur Heywood <arthurheyw...@gmail.com> > Cc: Juma Lungo <jlu...@yahoo.com>; dh

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

2016-10-07 Thread Bob Jolliffe
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

Re: [Dhis2-users] [Dhis2-devs] error when deploing dhis 2.24 on windows

2016-10-06 Thread Bob Jolliffe
Bad war file is what it looks like to me too. Guy if you are going to do two things (change war file and change jdk) do them one at a time and test. That way you will learn which was the culprit. On 6 October 2016 at 15:06, Morten Olav Hansen wrote: > Probably a damaged war

Re: [Dhis2-users] Fwd: changing organisation unit coordinates in DHIS-2.23

2016-09-22 Thread Bob Jolliffe
e spam folder.. not sure why.. >> >> -- >> Morten Olav Hansen >> Senior Engineer, DHIS 2 >> University of Oslo >> http://www.dhis2.org >> >> On Thu, Sep 22, 2016 at 4:04 AM, Bob Jolliffe <bobjolli...@gmail.com> >> wrote: >> >>

[Dhis2-users] Fwd: changing organisation unit coordinates in DHIS-2.23

2016-09-21 Thread Bob Jolliffe
-- Forwarded message -- From: Wilson, Randy <rwil...@msh.org> Date: 21 September 2016 at 16:21 Subject: Fwd: changing organisation unit coordinates in DHIS-2.23 To: Lars Helge Øverland <larshe...@gmail.com>, Bob Jolliffe < bobjolli...@gmail.com> Hi Lars and B

Re: [Dhis2-users] Too Many Open Files?

2016-09-07 Thread Bob Jolliffe
Hi Jason Halvdan is right - these are more likely file descriptors associated with sockets. The limit you have dug up is the kernel limit (ie total no of "files" that the kernel can have open in total) which is probably not the limit you are reaching. If you have a very busy server you can have

Re: [Dhis2-users] Browser not working

2016-08-03 Thread Bob Jolliffe
s and also make a note in implementer docs. On 3 August 2016 at 14:59, Bob Jolliffe <bobjolli...@gmail.com> wrote: > Not other than the workarounds uncovered and discussed in this thread and > the other. Once user complaints stopped, so did I :-) > > > On 3 August 2016 at 14:

Re: [Dhis2-users] Browser not working

2016-08-03 Thread Bob Jolliffe
ough. >> >> Best >> >> S >> >> >> >> >> >> -- >> Steven Uggowitzer >> eSHIfT Partner Network, Entuura Ventures Ltd >> Tel: +41 22 366 1920 >> Mob: +41 79 719 4180 >> Skype: fendant123 &

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

2016-07-28 Thread Bob Jolliffe
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

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

2016-07-27 Thread Bob Jolliffe
Gerald I assume that you are going to try this out on a test machine, not the machine on which the users are entering data. On 27 July 2016 at 13:54, gerald thomas wrote: > Thanks Knut, they are currently doing data entry till August 15. I will > start on the 16 or 17 and

Re: [Dhis2-users] Ngnix Failed

2016-07-26 Thread Bob Jolliffe
ww.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 >>

Re: [Dhis2-users] Ngnix Failed

2016-07-26 Thread Bob Jolliffe
; >>> 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 >>

Re: [Dhis2-users] Ngnix Failed

2016-07-26 Thread Bob Jolliffe
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 A

Re: [Dhis2-users] Ngnix Failed

2016-07-26 Thread Bob Jolliffe
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

Re: [Dhis2-users] [Dhis2-devs] Problem upgrading from 2.20 to 2.21

2016-07-22 Thread Bob Jolliffe
Jul 22, 2016, at 9:37 AM, Bob Jolliffe <bobjolli...@gmail.com> wrote: >> >> Thanks all. The startup routines should take care of all this stuff >> without the need for running manual queries. And indeed they do >> unless they fail - which as Dan says they do horribly

Re: [Dhis2-users] Problem upgrading from 2.20 to 2.21

2016-07-22 Thread Bob Jolliffe
e = > 'sum'; > > Regards, > > Michael > > > On 22 July 2016 at 09:09, Bob Jolliffe <bobjolli...@gmail.com> wrote: >> >> Hi >> >> After upgrading from 2.20 to 2.21 system is failing to start with: >> >> ERROR 2016-07-22 09:01:36,593 j

Re: [Dhis2-users] Browser not working

2016-07-20 Thread Bob Jolliffe
t; We are using Tomcat as web server not nginx. > > We also did not use dhis2-tools. > > Thanks > > > *From: *Bob Jolliffe > *Sent: *Tuesday, 19 July 2016 23:33 > *To: *Olav Poppe > *Cc: *DHIS Users; Steven Uggowitzer > *Subject: *Re: [Dhis2-users] Browser not wo

Re: [Dhis2-users] Browser not working

2016-07-19 Thread Bob Jolliffe
p/chromium/issues/detail?id=150066. Like there is something about the response which chrome doesn't like and hence silently drops the cookie. That's all I can say for now. On 19 July 2016 at 22:46, Bob Jolliffe <bobjolli...@gmail.com> wrote: > Not really related, but those double GETs I se

Re: [Dhis2-users] Browser not working

2016-07-19 Thread Bob Jolliffe
ng if you attempt to hit DHIS2 directly >> without going through the reverse proxy? >> >> Regards, >> Jason >> >> >> On Tue, Jul 19, 2016 at 6:45 PM, Steven Uggowitzer <whoto...@gmail.com> >> wrote: >> >>> It's for Chrome and Safar

Re: [Dhis2-users] Browser not working

2016-07-19 Thread Bob Jolliffe
>> >> >> [image: Inline images 1] >> >> -- >> Steven Uggowitzer >> eSHIfT Partner Network, Entuura Ventures Ltd >> Tel: +41 22 366 1920 >> Mob: +41 79 719 4180 >> Skype: fendant123 >> LinkedIn: http://ch.linked

Re: [Dhis2-users] Browser not working

2016-07-19 Thread Bob Jolliffe
; *Dato: *19. juli 2016 kl. 15.19.34 GMT > *Til: *Olav Poppe <olav.po...@me.com> > > Just to add that I'm using version 2.22 build 22086 > > > *From: *Olav Poppe > *Sent: *Tuesday, 19 July 2016 16:08 > *To: *ifeanyiok...@yahoo.com > *Cc: *Bob Jolliffe; Ntawuyirusha

[Dhis2-users] Fwd: Browser not working

2016-07-18 Thread Bob Jolliffe
oops, forgot users ... -- Forwarded message -- From: Bob Jolliffe <bobjolli...@gmail.com> Date: 18 July 2016 at 11:40 Subject: Re: [Dhis2-users] Browser not working To: Emmanuel Ntawuyirusha <ntawe...@gmail.com> Hi Emmanuel If it works with firefox then it is r

Re: [Dhis2-users] [Dhis2-devs] Multiple DHIS2 instances on a Single Server

2016-07-14 Thread Bob Jolliffe
Hi Gerald What Seth describes is pretty much what dhis2-tools does. It just partially automates some of the setup and takes care of some fiddly things like serving static files through cache, rotating backups etc. And you have dhis2-tools running on sl.dhis2.org. Simon Jespersen has been

Re: [Dhis2-users] Upgrading DHIS2 from 2.21 to 2.24

2016-07-12 Thread Bob Jolliffe
Important first step is make sure you make a snapshot of database and keep a copy of the original war file (in case you need to revert back to where you started). You might also consider revamping your postgres by upgrading to postgres 9.5 (apparently significant performance gains according to

Re: [Dhis2-users] Option, option set and dataelement

2016-05-27 Thread Bob Jolliffe
he category e.g. > GEN.F/GEN.M for gender female/male and HPY.T/HPY.F for happy or not happy. But > that's not really nice for the outputs and exports. Imagine having a simple > number code (like Month) that is presented as MON.10, Mon.11 etc. in charts > and > pivots ... > > Than

Re: [Dhis2-users] [Dhis2-devs] thomas lindsjørn joins as android developer

2016-05-24 Thread Bob Jolliffe
welcome Thomas On 24 May 2016 at 20:20, Jim Grace wrote: > Hi Thomas, welcome! > > > On Tue, May 24, 2016 at 3:13 PM, Knut Staring wrote: >> >> Welcome Thomas! >> >> Knut >> >> On 24 May 2016 9:09 p.m., "Lars Helge Øverland" wrote: >>> >>> Hi

Re: [Dhis2-users] Option, option set and dataelement

2016-05-23 Thread Bob Jolliffe
I think (semantically) the correct way is to create a new "Unknown" option, though it should have a different code and uid from other unknowns. The displayed label just happens to be the same but the underlying concept is different. That is, they actually represent the likes of "Unknown age",

Re: [Dhis2-users] [Dhis2-devs] Digit group separator in pivot table - what should the default value be?

2016-05-04 Thread Bob Jolliffe
I *think* we discuss the space separator business purely related to display. So when exporting to excel, or any other case where the number is expected to be consumed as a number (including storage in the database), exported via api in json/xml datavalueset etc there should be no spaces, commas

Re: [Dhis2-users] [Dhis2-devs] Digit group separator in pivot table - what should the default value be?

2016-05-03 Thread Bob Jolliffe
https://en.wikipedia.org/wiki/Decimal_mark#Digit_grouping seems to support Jim's suggestion of space as default. On 3 May 2016 at 21:32, Ola Hodne Titlestad wrote: > Supporting Jim's suggestion on a system/implementation setting to > configure a default system-wide separator

Re: [Dhis2-users] [Dhis2-devs] dhis 2.23 upgrade

2016-04-26 Thread Bob Jolliffe
ding to the docs, PostGIS 2.2 works against PostgreSQL 9.1 > and later: > > > http://postgis.net/docs/manual-2.2/postgis_installation.html#install_requirements > > We have of course tested DHIS 2 against PostGIS 2.2, so this should be > safe. > > Lars > > > >

Re: [Dhis2-users] [Dhis2-devs] dhis 2.23 upgrade

2016-04-26 Thread Bob Jolliffe
Hi Lars I know that a lot of production servers are running postgres 9.3 (default with ubuntu 14.04). The instructions assume postgres 9.4 is used. I know they could upgrade, but I wonder has anybody tested the gis extensions with 9.3? Regards Bob On 25 April 2016 at 18:38, Lars Helge

Re: [Dhis2-users] API: Mass-deleting data values

2016-03-29 Thread Bob Jolliffe
This sounds like what Lars was saying about importing "blank" values. On 29 March 2016 at 09:38, Gijsbert Ooms wrote: > Just a little update on this (we were having the same issue). > > > > It is true that overwriting with ‘0’ works only if zeroIsSignificant is > set

Re: [Dhis2-users] DHIS2 not restarting with Server after Bootup [SOLVED]

2016-03-23 Thread Bob Jolliffe
Hi Adam It sounds like you have a system tomcat (/etc/init.d/tomcat7) competing with your custom dhis tomcats. Probably you can uninstall this first to remove any ambiguities (apt-get remove tomcat7). It was probably competing for the default port 8080. Bob On 23 March 2016 at 14:37, Adam

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

2016-03-19 Thread Bob Jolliffe
ed to you. By replying to this e-mail or opening any attachment > you agree to be bound by the provisions of the disclaimer. > > > > > > > > *From:* Bob Jolliffe [mailto:bobjolli...@gmail.com] > *Sent:* Wednesday, 16 March 2016 2:24 PM > *To:* Lars Helge Øverland > *Cc:*

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

2016-03-19 Thread Bob Jolliffe
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 <bobjolli...@gmail.com> wrote

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

2016-03-19 Thread Bob Jolliffe
I have not done this, but I imagine that hibernate cache replication between instances is something that really needs to be done to have this sort of scaling configuration work. I do remember there was a brief flirtation with hazelcast before reverting to ehcache. Is anybody using ehcache in

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

2016-03-19 Thread Bob Jolliffe
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

Re: [Dhis2-users] [Dhis2-devs] Free SSL with letsencrypt

2016-03-14 Thread Bob Jolliffe
And this Chinese supplier might well be the way around any issues arising from US sanctions :-) On 14 March 2016 at 12:30, Steven Uggowitzer wrote: > Thanks David, > > For those of you looking for another (probably less secure) free option, > there is also WoSign

Re: [Dhis2-users] [Dhis2-devs] Free SSL with letsencrypt

2016-03-14 Thread Bob Jolliffe
Thanks David. That's really useful. Removing credit card transactions from the process of getting certs signed is going to be very valuable. Note from here (https://community.letsencrypt.org/t/certificates-for-us-sanctioned-countries/1223) that there might still be some issues in some US

[Dhis2-users] New openssl vulnerability

2016-03-08 Thread Bob Jolliffe
Hi In case anyone has noticed and started to panic, there are some new openssl vulnerabilities, which might effect your nginx installations. http://www.infoq.com/news/2016/03/two-new-openssl-flaws?utm_source=infoqWeeklyNewsletter_medium=WeeklyNL_EditorialContent_development_campaign=03082016news

Re: [Dhis2-users] DHIS2 DXF schema files

2016-02-29 Thread Bob Jolliffe
We don't follow or express schema for dxf. Particularly the metadata has been too dynamic. ( The link is very old and not maintained. ) Morten did introduce a schemas endpoint to the API (eg see https://play.dhis2.org/demo/api/schemas/dataElement) which provides the structure and types of the

Re: [Dhis2-users] Interested in DHIS 2

2016-02-24 Thread Bob Jolliffe
I can maybe add further to Knut and Jason's advice. Setting up dhis2 a critical piece of web based infrastructure which remote users can rely on to be available, secure, well tuned etc does imply a range of infrastructural skills related to things like networking and linux system administration

  1   2   3   4   >