dhis2-users team mailing list archive

[Knut Staring <knutst@xxxxxxxxx>]

Hi Nick,
Looks to me as if your DHIS2 Live does not find  the postgres db. Can you
please go to About DHIS2 and see whether it lists H2 or Postgres as
 database? And is it the right db name?

I think most likely you have placed your hibernate.properties file
somewhere else - it SHOULD be in the dhis-live\conf folder

Knut


On Wed, May 28, 2014 at 5:41 AM, <duttas@xxxxxxxxxxxx> wrote:

>  Hi Everyone,
>
>
>
> I am having some trouble importing a database into a local DHIS2-Live
> instance in Windows 7. When I check pgadmin it looks like it’s been
> imported correctly. I have tried both restoring/importing the database
> using
>
> psql –U dhis –f databasename.dump –d dhis2 to recover and
>
> psql –U dbuser dbname < filename.sql to import
>
>
>
> However when I check the dhis instance it is just a blank instance with
> none of the data/metadata present. I also have created a hibernate.propties
> file containing the following:
>
> 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
>
>
>
> Just wondering where I might be going wrong here? Thanks
>
>
>
> Nick
>
>
>
>
>
>
>
>
>
>
>
>
>
>  ------------------------------
>
> This message was scanned for viruses with Trend Micro ScanMail, GFI
> MailSecurity and GFI MailEssentials by the World Health Organization
> Regional Office for the Western Pacific. However, the recipient is advised
> to scan this e-mail and any attached files for viruses.
>
> Disclaimer:
>
> This e-mail, together with any attachments, is intended for the named
> recipients only and is confidential. It may also be privileged or otherwise
> protected by law.
>
> If you have received it in error, please notify the sender immediately by
> reply e-mail and delete it and any attachments from your system. You may
> not copy or disclose its contents to anyone.
>  <#14640eb8037b3a9a_>
>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-users
> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>


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