You could also try changing the owner of the database (easy to do in PgAdmin III) to the dhis user.
On Sat, Apr 10, 2010 at 5:32 PM, Knut Staring <[email protected]> wrote: > Hi Roger, > > It does certainly sound like a problem with your hibernate.properties. > > Are you perchance running Postgres on a nonstandard port (not 5432)? > > If you have a Postgres user called dhis with password dhis running on port > 5433 on your local machine, the following should be correct: > > hibernate.dialect = org.hibernate.dialect.PostgreSQLDialect > hibernate.connection.driver_class = org.postgresql.Driver > hibernate.connection.url = jdbc:postgresql://localhost:5433/dhis2 > hibernate.connection.username = dhis > hibernate.connection.password = dhis > hibernate.hbm2ddl.auto = update > > Knut > > On Sat, Apr 10, 2010 at 5:20 PM, Friedman, Roger (CDC/OID/NCHHSTP) (CTR) < > [email protected]> wrote: > >> Hi all. >> >> Edem kindly provided me with a DB dump file to use. It was Postgres but I >> had installed MySQL. So I just installed Postgres, created the DHIS2 >> database, created the dhis user and granted all on database to dhis. I >> reloaded the backup and can see the data in the tables. I stopped dhis in >> tomcat, changed the hibernate file to the Postgres version, and tried to >> restart dhis. It fails. It looks like the problem was that hibernate could >> not open the jdbc connection, message "Connections could not be acquired >> from the underlying database!". Excuse me if I don,t type the whole error >> chain on my Blackberry (remote e-mail access is down right now). Any >> suggestions? I notice my mysql hibernate file has a //localhost before >> :dhis2, the Postgres version does not. >> >> Thanks, Roger >> >> _______________________________________________ >> Mailing list: https://launchpad.net/~dhis2-users >> Post to : [email protected] >> Unsubscribe : https://launchpad.net/~dhis2-users >> More help : https://help.launchpad.net/ListHelp >> >> > > > -- > Cheers, > Knut Staring > -- Cheers, Knut Staring
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : [email protected] Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
