Re: [Dhis2-users] Database being cleared after Tomcat shutdown

2017-08-31 Thread Edward Robinson 
Hi, I am working with 2.16 and am in the process of upgrading but will not be 
doing that on the live servers – I need to get this working offline on 2.16 
before performing the upgrade.
Regards
Ed

From: Em Le Hong [mailto:em.hispviet...@gmail.com]
Sent: Thursday, 31 August 2017 3:42 PM
To: Edward Robinson <erobin...@projectbalance.com>
Cc: DHIS 2 Users list <dhis2-users@lists.launchpad.net>
Subject: Re: [Dhis2-users] Database being cleared after Tomcat shutdown

Hi again,

If you upgrade from 2.16 to 2.22 or above 2.22, you have to change the 
configuration file from hibernate.properties to dhis.conf. Otherwise, it can't 
connect to the correct database.

Read here to check how to create dhis.conf file.

https://docs.dhis2.org/2.22/en/implementer/html/ch08s03.html#d5e500

On Thu, Aug 31, 2017 at 8:29 PM, Em Le Hong 
<em.hispviet...@gmail.com<mailto:em.hispviet...@gmail.com>> wrote:
Hi,

Which version are you working on? for the recent new version, DHIS2 no longer 
use hibernate.properties file.

Read the upgrade note here:
https://www.dhis2.org/222-upgrade

On Thu, Aug 31, 2017 at 6:32 PM, Edward Robinson 
<erobin...@projectbalance.com<mailto:erobin...@projectbalance.com>> wrote:
I know this is not an uncommon issue and I recall it relates to a configuration 
problem if I’m not mistaken, but for the life of me I cannot fathom why two 
machines I am working with seem to exhibit this behaviour consistently.  I have 
a couple of Windows test servers set up to facilitate an offline upgrade from 
2.16 but I’m unable to resolve this on these two machines.  I’ve seen this on 
Linux as well so assume it’s not OS related.

In a nutshell, the system appears to start up fine, I am able to login and 
access the system, create data elements, create users, etc. but when Tomcat is 
shut down, the database is cleared except for the aggregate tables (all other 
tables are dropped):
[cid:image001.jpg@01D32298.C3F1E660]

When Tomcat is started again, obviously the data is no longer there.  As long 
as it’s running, all appears well in the tables:
[cid:image003.jpg@01D32298.C3F1E660]

I have attached a copy of the logs as well as my hibernate.properties file 
(dummy password) and my system variables.  I’ve also attached a screenshot of 
the ‘about DHIS2’ page for reference.

As far as I can see, the only issues / errors on startup include:
A bunch of ERROR for database constraint drop scripts on startup – because the 
database does not yet exist – I assume these are benign.
Some WARN messages:
   “[127.0.0.1]:5701 [dev] [3.2.1] No join method is enabled! 
Starting standalone. (HazelcastInstanceImpl.java [localhost-startStop-1])”
   “RP discovery / realm validation disabled;  (RealmVerifier.java 
[localhost-startStop-1])”
   “Did not find any ViewResolvers to delegate to; please configure 
them using the 'viewResolvers' property on the ContentNegotiatingViewResolver 
(ContentNegotiatingViewResolver.java [localhost-startStop-1])”

Any idea what could be causing this?

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



--
Em Le Hong
DHIS2 Implementation| HISP Vietnam
em.hispviet...@gmail.com<mailto:em.hispviet...@gmail.com> | Skype: 
em.hispviet...@gmail.com<mailto:em.hispviet...@gmail.com>

[https://drive.google.com/uc?id=0B-tlJrv190f5dmR1Y0t2NERvcVU=download]






--
Em Le Hong
DHIS2 Implementation| HISP Vietnam
em.hispviet...@gmail.com<mailto:em.hispviet...@gmail.com> | Skype: 
em.hispviet...@gmail.com<mailto:em.hispviet...@gmail.com>

[https://drive.google.com/uc?id=0B-tlJrv190f5dmR1Y0t2NERvcVU=download]



___
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] Database being cleared after Tomcat shutdown

2017-08-31 Thread Em Le Hong 
Hi again,

If you upgrade from 2.16 to 2.22 or above 2.22, you have to change the
configuration file from hibernate.properties to dhis.conf. Otherwise, it
can't connect to the correct database.

Read here to check how to create dhis.conf file.

https://docs.dhis2.org/2.22/en/implementer/html/ch08s03.html#d5e500

On Thu, Aug 31, 2017 at 8:29 PM, Em Le Hong 
wrote:

> Hi,
>
> Which version are you working on? for the recent new version, DHIS2 no
> longer use hibernate.properties file.
>
> Read the upgrade note here:
> https://www.dhis2.org/222-upgrade
>
> On Thu, Aug 31, 2017 at 6:32 PM, Edward Robinson <
> erobin...@projectbalance.com> wrote:
>
>> I know this is not an uncommon issue and I recall it relates to a
>> configuration problem if I’m not mistaken, but for the life of me I cannot
>> fathom why two machines I am working with seem to exhibit this behaviour
>> consistently.  I have a couple of Windows test servers set up to facilitate
>> an offline upgrade from 2.16 but I’m unable to resolve this on these two
>> machines.  I’ve seen this on Linux as well so assume it’s not OS related.
>>
>>
>>
>> In a nutshell, the system appears to start up fine, I am able to login
>> and access the system, create data elements, create users, etc. but when
>> Tomcat is shut down, the database is cleared except for the aggregate
>> tables (all other tables are dropped):
>>
>>
>>
>> When Tomcat is started again, obviously the data is no longer there.  As
>> long as it’s running, all appears well in the tables:
>>
>>
>>
>> I have attached a copy of the logs as well as my hibernate.properties
>> file (dummy password) and my system variables.  I’ve also attached a
>> screenshot of the ‘about DHIS2’ page for reference.
>>
>>
>>
>> As far as I can see, the only issues / errors on startup include:
>>
>> A bunch of ERROR for database constraint drop scripts on startup –
>> because the database does not yet exist – I assume these are benign.
>>
>> Some WARN messages:
>>
>>“[127.0.0.1]:5701 [dev] [3.2.1] No join method is enabled!
>> Starting standalone. (HazelcastInstanceImpl.java [localhost-startStop-1])”
>>
>>“RP discovery / realm validation disabled;
>> (RealmVerifier.java [localhost-startStop-1])”
>>
>>“Did not find any ViewResolvers to delegate to; please
>> configure them using the 'viewResolvers' property on the
>> ContentNegotiatingViewResolver (ContentNegotiatingViewResolver.java
>> [localhost-startStop-1])”
>>
>>
>>
>> Any idea what could be causing this?
>>
>> ___
>> 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
>>
>>
>
>
> --
> *Em Le Hong*
> DHIS2 Implementation| *HISP Vietnam *
> em.hispviet...@gmail.com | *Skype:* em.hispviet...@gmail.com
>
>
>
>
>
>


-- 
*Em Le Hong*
DHIS2 Implementation| *HISP Vietnam *
em.hispviet...@gmail.com | *Skype:* em.hispviet...@gmail.com
___
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] Database being cleared after Tomcat shutdown

2017-08-31 Thread Em Le Hong 
Hi,

Which version are you working on? for the recent new version, DHIS2 no
longer use hibernate.properties file.

Read the upgrade note here:
https://www.dhis2.org/222-upgrade

On Thu, Aug 31, 2017 at 6:32 PM, Edward Robinson <
erobin...@projectbalance.com> wrote:

> I know this is not an uncommon issue and I recall it relates to a
> configuration problem if I’m not mistaken, but for the life of me I cannot
> fathom why two machines I am working with seem to exhibit this behaviour
> consistently.  I have a couple of Windows test servers set up to facilitate
> an offline upgrade from 2.16 but I’m unable to resolve this on these two
> machines.  I’ve seen this on Linux as well so assume it’s not OS related.
>
>
>
> In a nutshell, the system appears to start up fine, I am able to login and
> access the system, create data elements, create users, etc. but when Tomcat
> is shut down, the database is cleared except for the aggregate tables (all
> other tables are dropped):
>
>
>
> When Tomcat is started again, obviously the data is no longer there.  As
> long as it’s running, all appears well in the tables:
>
>
>
> I have attached a copy of the logs as well as my hibernate.properties file
> (dummy password) and my system variables.  I’ve also attached a screenshot
> of the ‘about DHIS2’ page for reference.
>
>
>
> As far as I can see, the only issues / errors on startup include:
>
> A bunch of ERROR for database constraint drop scripts on startup – because
> the database does not yet exist – I assume these are benign.
>
> Some WARN messages:
>
>“[127.0.0.1]:5701 [dev] [3.2.1] No join method is enabled!
> Starting standalone. (HazelcastInstanceImpl.java [localhost-startStop-1])”
>
>“RP discovery / realm validation disabled;
> (RealmVerifier.java [localhost-startStop-1])”
>
>“Did not find any ViewResolvers to delegate to; please
> configure them using the 'viewResolvers' property on the
> ContentNegotiatingViewResolver (ContentNegotiatingViewResolver.java
> [localhost-startStop-1])”
>
>
>
> Any idea what could be causing this?
>
> ___
> 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
>
>


-- 
*Em Le Hong*
DHIS2 Implementation| *HISP Vietnam *
em.hispviet...@gmail.com | *Skype:* em.hispviet...@gmail.com
___
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