Re: [Dhis2-devs] [Bug 1625181] Re: Organisation Unit Data Lost After Restarting Web Server

[Lars Helge Øverland]

Hi,

this is all clearly explained in the installation guide:

http://dhis2.github.io/dhis2-docs/master/en/implementer/html/install_server_setup.html#install_database_configuration


regards,

Lars




On Sun, Sep 25, 2016 at 10:10 AM, Calle Hedberg 
wrote:

> Scott,
>
> The config file up to version 2.21 was called "hibernate.properties"
>
> From 2.22 onwards this was changed to dhis.conf
>
> So it's a version issue.
>
> Regards
> Calle
>
> On 24 September 2016 at 23:56, Scott Allen <1625...@bugs.launchpad.net>
> wrote:
>
>> I think this is likely my personal user error but somewhere along the
>> lines I've gotten confused on if my config file should be named
>> dhis.conf or hibernate.properties. I'm also confused on whether the file
>> should use "hibernate.connection" or "connection.x" and if the
>> correct notation for the schema update is ".hbm2ddl.auto" or ".schema"
>>
>> Either way, my configurations are lost after rebooting the web server.
>> Any help would be appreciated!
>>
>> --
>> You received this bug notification because you are a member of DHIS 2
>> developers, which is subscribed to DHIS.
>> https://bugs.launchpad.net/bugs/1625181
>>
>> Title:
>>   Organisation Unit Data Lost After Restarting Web Server
>>
>> Status in DHIS:
>>   Invalid
>>
>> Bug description:
>>   When i am trying to create organisation unit hierarchy in new empty
>>   database, and after some time later when i am getting loged out and
>>   restarting server, it loses all organization unit hierarchy in
>>   database organisation unit table in database in spite of i have
>>   assigned value
>>
>>   hibernate.connection.schema = update
>>
>>   in "dhis.conf" file in "DHIS2_HOME" system environment variable.
>>
>>   I think this is a very serious bug in dhis trunk and in dhis2.24
>>   branch.
>>
>> To manage notifications about this bug go to:
>> https://bugs.launchpad.net/dhis2/+bug/1625181/+subscriptions
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-devs
>> Post to : dhis2-devs@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-devs
>> More help   : https://help.launchpad.net/ListHelp
>>
>
>
>
> --
>
> ***
>
> Calle Hedberg
>
> 46D Alma Road, 7700 Rosebank, SOUTH AFRICA
>
> Tel/fax (home): +27-21-685-6472
>
> Cell: +27-82-853-5352
>
> Iridium SatPhone: +8816-315-19119
>
> Email: calle.hedb...@gmail.com
>
> Skype: calle_hedberg
>
> ***
>
>
> ___
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to : dhis2-devs@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>
>


-- 
Lars Helge Øverland
Lead developer, DHIS 2
University of Oslo
Skype: larshelgeoverland
l...@dhis2.org
http://www.dhis2.org 
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] [Bug 1625181] Re: Organisation Unit Data Lost After Restarting Web Server

[Calle Hedberg]

Scott,

The config file up to version 2.21 was called "hibernate.properties"

>From 2.22 onwards this was changed to dhis.conf

So it's a version issue.

Regards
Calle

On 24 September 2016 at 23:56, Scott Allen <1625...@bugs.launchpad.net>
wrote:

> I think this is likely my personal user error but somewhere along the
> lines I've gotten confused on if my config file should be named
> dhis.conf or hibernate.properties. I'm also confused on whether the file
> should use "hibernate.connection" or "connection.x" and if the
> correct notation for the schema update is ".hbm2ddl.auto" or ".schema"
>
> Either way, my configurations are lost after rebooting the web server.
> Any help would be appreciated!
>
> --
> You received this bug notification because you are a member of DHIS 2
> developers, which is subscribed to DHIS.
> https://bugs.launchpad.net/bugs/1625181
>
> Title:
>   Organisation Unit Data Lost After Restarting Web Server
>
> Status in DHIS:
>   Invalid
>
> Bug description:
>   When i am trying to create organisation unit hierarchy in new empty
>   database, and after some time later when i am getting loged out and
>   restarting server, it loses all organization unit hierarchy in
>   database organisation unit table in database in spite of i have
>   assigned value
>
>   hibernate.connection.schema = update
>
>   in "dhis.conf" file in "DHIS2_HOME" system environment variable.
>
>   I think this is a very serious bug in dhis trunk and in dhis2.24
>   branch.
>
> To manage notifications about this bug go to:
> https://bugs.launchpad.net/dhis2/+bug/1625181/+subscriptions
>
> ___
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to : dhis2-devs@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>



-- 

***

Calle Hedberg

46D Alma Road, 7700 Rosebank, SOUTH AFRICA

Tel/fax (home): +27-21-685-6472

Cell: +27-82-853-5352

Iridium SatPhone: +8816-315-19119

Email: calle.hedb...@gmail.com

Skype: calle_hedberg

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

Re: [Dhis2-devs] [Bug 1625181] Re: Organisation Unit Data Lost After Restarting Web Server

[Brajesh Murari]

Its working.

Thanks Alex.

On Tue, Sep 20, 2016 at 2:22 AM, Alex Tumwesigye 
wrote:

> Dear Murari,
>
> The correct dhis.conf is
> connection.dialect = org.hibernate.dialect.PostgreSQLDialect
> connection.driver_class = org.postgresql.Driver
> connection.url = jdbc:postgresql:dhis2
> connection.username = dhis
> connection.password = dhis
> connection.schema = update
>
> See below.
> http://dhis2.github.io/dhis2-docs/2.24/en/implementer/html/
> dhis2_implementation_guide_full.html#d5274e948
>
> Alex
>
> On Mon, Sep 19, 2016 at 6:02 PM, Brajesh Murari <
> 1625...@bugs.launchpad.net> wrote:
>
>> Yes i replaced one line in dhis.conf
>>
>> hibernate.connection.schema = update
>> by
>> hibernate.hbm2ddl.auto = update
>>
>> and its working
>>
>> Thanks Knut
>>
>> On Mon, Sep 19, 2016 at 7:18 PM, Knut Staring  wrote:
>>
>> > Try this in your dhis.conf:
>> >
>> > hibernate.dialect = org.hibernate.dialect.PostgreSQLDialect
>> > hibernate.connection.driver_class = org.postgresql.Driver
>> > hibernate.connection.url = jdbc:postgresql:dhis2
>> > hibernate.connection.username = dhis
>> > hibernate.connection.password = dhis
>> > hibernate.hbm2ddl.auto = update
>> >
>> > --
>> > You received this bug notification because you are subscribed to the bug
>> > report.
>> > https://bugs.launchpad.net/bugs/1625181
>> >
>> > Title:
>> >   Organisation Unit Data Lost After Restarting Web Server
>> >
>> > Status in DHIS:
>> >   Invalid
>> >
>> > Bug description:
>> >   When i am trying to create organisation unit hierarchy in new empty
>> >   database, and after some time later when i am getting loged out and
>> >   restarting server, it loses all organization unit hierarchy in
>> >   database organisation unit table in database in spite of i have
>> >   assigned value
>> >
>> >   hibernate.connection.schema = update
>> >
>> >   in "dhis.conf" file in "DHIS2_HOME" system environment variable.
>> >
>> >   I think this is a very serious bug in dhis trunk and in dhis2.24
>> >   branch.
>> >
>> > To manage notifications about this bug go to:
>> > https://bugs.launchpad.net/dhis2/+bug/1625181/+subscriptions
>> >
>> > Launchpad-Notification-Type: bug
>> > Launchpad-Bug: product=dhis2; status=Invalid; importance=Undecided;
>> > assignee=None;
>> > Launchpad-Bug-Information-Type: Public
>> > Launchpad-Bug-Private: no
>> > Launchpad-Bug-Security-Vulnerability: no
>> > Launchpad-Bug-Commenters: brajesh-murari knutst
>> > Launchpad-Bug-Reporter: Brajesh Murari (brajesh-murari)
>> > Launchpad-Bug-Modifier: Knut Staring (knutst)
>> > Launchpad-Message-Rationale: Subscriber
>> > Launchpad-Message-For: brajesh-murari
>> >
>>
>>
>> --
>> Thanks and Regards
>>
>> Brajesh Murari
>> | Senior Technical Annalist | www.sdrc.co.in | Ph.:(+91)-9430124938 |
>>
>> --
>> You received this bug notification because you are a member of DHIS 2
>> developers, which is subscribed to DHIS.
>> https://bugs.launchpad.net/bugs/1625181
>>
>> Title:
>>   Organisation Unit Data Lost After Restarting Web Server
>>
>> Status in DHIS:
>>   Invalid
>>
>> Bug description:
>>   When i am trying to create organisation unit hierarchy in new empty
>>   database, and after some time later when i am getting loged out and
>>   restarting server, it loses all organization unit hierarchy in
>>   database organisation unit table in database in spite of i have
>>   assigned value
>>
>>   hibernate.connection.schema = update
>>
>>   in "dhis.conf" file in "DHIS2_HOME" system environment variable.
>>
>>   I think this is a very serious bug in dhis trunk and in dhis2.24
>>   branch.
>>
>> To manage notifications about this bug go to:
>> https://bugs.launchpad.net/dhis2/+bug/1625181/+subscriptions
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-devs
>> Post to : dhis2-devs@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-devs
>> More help   : https://help.launchpad.net/ListHelp
>>
>
>
>
> --
> 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 "
>
> ___
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to : dhis2-devs@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>
>


-- 
Thanks and Regards

Brajesh Murari
| Senior Technical Annalist | www.sdrc.co.in | Ph.:(+91)-9430124938 |
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] [Bug 1625181] Re: Organisation Unit Data Lost After Restarting Web Server

[Alex Tumwesigye]

Dear Murari,

The correct dhis.conf is
connection.dialect = org.hibernate.dialect.PostgreSQLDialect
connection.driver_class = org.postgresql.Driver
connection.url = jdbc:postgresql:dhis2
connection.username = dhis
connection.password = dhis
connection.schema = update

See below.
http://dhis2.github.io/dhis2-docs/2.24/en/implementer/html/dhis2_implementation_guide_full.html#d5274e948

Alex

On Mon, Sep 19, 2016 at 6:02 PM, Brajesh Murari <1625...@bugs.launchpad.net>
wrote:

> Yes i replaced one line in dhis.conf
>
> hibernate.connection.schema = update
> by
> hibernate.hbm2ddl.auto = update
>
> and its working
>
> Thanks Knut
>
> On Mon, Sep 19, 2016 at 7:18 PM, Knut Staring  wrote:
>
> > Try this in your dhis.conf:
> >
> > hibernate.dialect = org.hibernate.dialect.PostgreSQLDialect
> > hibernate.connection.driver_class = org.postgresql.Driver
> > hibernate.connection.url = jdbc:postgresql:dhis2
> > hibernate.connection.username = dhis
> > hibernate.connection.password = dhis
> > hibernate.hbm2ddl.auto = update
> >
> > --
> > You received this bug notification because you are subscribed to the bug
> > report.
> > https://bugs.launchpad.net/bugs/1625181
> >
> > Title:
> >   Organisation Unit Data Lost After Restarting Web Server
> >
> > Status in DHIS:
> >   Invalid
> >
> > Bug description:
> >   When i am trying to create organisation unit hierarchy in new empty
> >   database, and after some time later when i am getting loged out and
> >   restarting server, it loses all organization unit hierarchy in
> >   database organisation unit table in database in spite of i have
> >   assigned value
> >
> >   hibernate.connection.schema = update
> >
> >   in "dhis.conf" file in "DHIS2_HOME" system environment variable.
> >
> >   I think this is a very serious bug in dhis trunk and in dhis2.24
> >   branch.
> >
> > To manage notifications about this bug go to:
> > https://bugs.launchpad.net/dhis2/+bug/1625181/+subscriptions
> >
> > Launchpad-Notification-Type: bug
> > Launchpad-Bug: product=dhis2; status=Invalid; importance=Undecided;
> > assignee=None;
> > Launchpad-Bug-Information-Type: Public
> > Launchpad-Bug-Private: no
> > Launchpad-Bug-Security-Vulnerability: no
> > Launchpad-Bug-Commenters: brajesh-murari knutst
> > Launchpad-Bug-Reporter: Brajesh Murari (brajesh-murari)
> > Launchpad-Bug-Modifier: Knut Staring (knutst)
> > Launchpad-Message-Rationale: Subscriber
> > Launchpad-Message-For: brajesh-murari
> >
>
>
> --
> Thanks and Regards
>
> Brajesh Murari
> | Senior Technical Annalist | www.sdrc.co.in | Ph.:(+91)-9430124938 |
>
> --
> You received this bug notification because you are a member of DHIS 2
> developers, which is subscribed to DHIS.
> https://bugs.launchpad.net/bugs/1625181
>
> Title:
>   Organisation Unit Data Lost After Restarting Web Server
>
> Status in DHIS:
>   Invalid
>
> Bug description:
>   When i am trying to create organisation unit hierarchy in new empty
>   database, and after some time later when i am getting loged out and
>   restarting server, it loses all organization unit hierarchy in
>   database organisation unit table in database in spite of i have
>   assigned value
>
>   hibernate.connection.schema = update
>
>   in "dhis.conf" file in "DHIS2_HOME" system environment variable.
>
>   I think this is a very serious bug in dhis trunk and in dhis2.24
>   branch.
>
> To manage notifications about this bug go to:
> https://bugs.launchpad.net/dhis2/+bug/1625181/+subscriptions
>
> ___
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to : dhis2-devs@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>



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

Re: [Dhis2-devs] [Bug 1625181] Re: Organisation Unit Data Lost After Restarting Web Server

[Brajesh Murari]

Yes i replaced one line in dhis.conf

hibernate.connection.schema = update
by
hibernate.hbm2ddl.auto = update

and its working

Thanks Knut

On Mon, Sep 19, 2016 at 7:18 PM, Knut Staring  wrote:

> Try this in your dhis.conf:
>
> hibernate.dialect = org.hibernate.dialect.PostgreSQLDialect
> hibernate.connection.driver_class = org.postgresql.Driver
> hibernate.connection.url = jdbc:postgresql:dhis2
> hibernate.connection.username = dhis
> hibernate.connection.password = dhis
> hibernate.hbm2ddl.auto = update
>
> --
> You received this bug notification because you are subscribed to the bug
> report.
> https://bugs.launchpad.net/bugs/1625181
>
> Title:
>   Organisation Unit Data Lost After Restarting Web Server
>
> Status in DHIS:
>   Invalid
>
> Bug description:
>   When i am trying to create organisation unit hierarchy in new empty
>   database, and after some time later when i am getting loged out and
>   restarting server, it loses all organization unit hierarchy in
>   database organisation unit table in database in spite of i have
>   assigned value
>
>   hibernate.connection.schema = update
>
>   in "dhis.conf" file in "DHIS2_HOME" system environment variable.
>
>   I think this is a very serious bug in dhis trunk and in dhis2.24
>   branch.
>
> To manage notifications about this bug go to:
> https://bugs.launchpad.net/dhis2/+bug/1625181/+subscriptions
>
> Launchpad-Notification-Type: bug
> Launchpad-Bug: product=dhis2; status=Invalid; importance=Undecided;
> assignee=None;
> Launchpad-Bug-Information-Type: Public
> Launchpad-Bug-Private: no
> Launchpad-Bug-Security-Vulnerability: no
> Launchpad-Bug-Commenters: brajesh-murari knutst
> Launchpad-Bug-Reporter: Brajesh Murari (brajesh-murari)
> Launchpad-Bug-Modifier: Knut Staring (knutst)
> Launchpad-Message-Rationale: Subscriber
> Launchpad-Message-For: brajesh-murari
>


-- 
Thanks and Regards

Brajesh Murari
| Senior Technical Annalist | www.sdrc.co.in | Ph.:(+91)-9430124938 |

-- 
You received this bug notification because you are a member of DHIS 2
developers, which is subscribed to DHIS.
https://bugs.launchpad.net/bugs/1625181

Title:
  Organisation Unit Data Lost After Restarting Web Server

Status in DHIS:
  Invalid

Bug description:
  When i am trying to create organisation unit hierarchy in new empty
  database, and after some time later when i am getting loged out and
  restarting server, it loses all organization unit hierarchy in
  database organisation unit table in database in spite of i have
  assigned value

  hibernate.connection.schema = update

  in "dhis.conf" file in "DHIS2_HOME" system environment variable.

  I think this is a very serious bug in dhis trunk and in dhis2.24
  branch.

To manage notifications about this bug go to:
https://bugs.launchpad.net/dhis2/+bug/1625181/+subscriptions

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

Re: [Dhis2-devs] [Bug 1625181] Re: Organisation Unit Data Lost After Restarting Web Server

[Knut Staring]

Your dhis.conf should look like this:

hibernate.dialect = org.hibernate.dialect.PostgreSQLDialect
hibernate.connection.driver_class = org.postgresql.Driver
hibernate.connection.url = jdbc:postgresql:dhis2
hibernate.connection.username = dhis
hibernate.connection.password = dhis
hibernate.hbm2ddl.auto = update

On Mon, Sep 19, 2016 at 3:15 PM, Brajesh Murari <1625...@bugs.launchpad.net>
wrote:

> Specially i did system integration testing with PostGres Data Base, i
> found data does't preserve and after restating server, it loses all data, i
> am not sure but it can be a bug or might be i am losing some system
> configuration issue which need to be taken care of apart form setting
> values like
>
> hibernate.connection.schema = update
>
> in dhis.conf or hibernate.property file. Guide me in this situation where
> i am not been able to find exact
> solution for above system integration testing use case.
>
> --
> You received this bug notification because you are a member of DHIS 2
> developers, which is subscribed to DHIS.
> https://bugs.launchpad.net/bugs/1625181
>
> Title:
>   Organisation Unit Data Lost After Restarting Web Server
>
> Status in DHIS:
>   New
>
> Bug description:
>   When i am trying to create organisation unit hierarchy in new empty
>   database, and after some time later when i am getting loged out and
>   restarting server, it loses all organization unit hierarchy in
>   database organisation unit table in database in spite of i have
>   assigned value
>
>   hibernate.connection.schema = update
>
>   in "dhis.conf" file in "DHIS2_HOME" system environment variable.
>
>   I think this is a very serious bug in dhis trunk and in dhis2.24
>   branch.
>
> To manage notifications about this bug go to:
> https://bugs.launchpad.net/dhis2/+bug/1625181/+subscriptions
>
> ___
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to : dhis2-devs@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>



-- 
Knut Staring
Dept. of Informatics, University of Oslo
Norway: +4791880522
Skype: knutstar
http://dhis2.org
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp