← Back to team overview

dhis2-devs team mailing list archive

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

 

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 <1625181@xxxxxxxxxxxxxxxxxx>
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 <knutst@xxxxxxxxx> 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@xxxxxxxxxxxxxxxxxxx
> 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 "

Follow ups

References