DHIS2 Live setup with postgresql database

Support - Assistance technique
1

Dear DHIS2 Users,

I have downloaded dhis2 live setup and learned it, Now i want to integrate it with postgresql database, I changed conf file but could not succeded, it leads me to error 503.
Can anyone help me plz?

one of my colleague asked same question on stackoverflow aswell.

Thanks in advance.

···

--
RAJA IMRAN QAMER,

Senior Software Engineer, Team Lead,
PACE TECHNOLOGIES,
Email:imran@pace-tech.com, rajaimranqamer@gmail.com
Phone: +923345073573, +92512361110
Web: www.pace-tech.com

2

Hi Raja,

What does the hibernate file look like? I’ve located mine in \dhis-live\conf

Here is a sample of mine which seems to be working

Hibernate SQL dialect

connection.dialect = org.hibernate.dialect.PostgreSQLDialect

JDBC driver class

connection.driver_class = org.postgresql.Driver

JDBC driver connection URL

connection.url = jdbc:postgresql:dbname

Database username

connection.username = username

Database password

connection.password = password

Database schema behavior, can be validate, update, create, create-drop

connection.schema = update

#Encryption password (sensitive)

#encryption.password = password

···

On Wed, May 31, 2017 at 1:12 PM, Raja Imran Qamer imran@pace-tech.com wrote:

Dear DHIS2 Users,

I have downloaded dhis2 live setup and learned it, Now i want to integrate it with postgresql database, I changed conf file but could not succeded, it leads me to error 503.

Can anyone help me plz?

one of my colleague asked same question on stackoverflow aswell.

https://stackoverflow.com/questions/44257061/how-to-do-configuration-of-postgresql-database-in-dhis2#44257061

Thanks in advance.

–

RAJA IMRAN QAMER,

Senior Software Engineer, Team Lead,

PACE TECHNOLOGIES,

Email:imran@pace-tech.com, rajaimranqamer@gmail.com

Phone: +923345073573, +92512361110

Web: www.pace-tech.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

–

Shurajit Dutta
Health Information Consultant

3

Hi,
There is a command window with lots of info. Please paste that here.

···

On May 31, 2017 7:13 AM, “Raja Imran Qamer” imran@pace-tech.com wrote:

Dear DHIS2 Users,

I have downloaded dhis2 live setup and learned it, Now i want to integrate it with postgresql database, I changed conf file but could not succeded, it leads me to error 503.

Can anyone help me plz?

one of my colleague asked same question on stackoverflow aswell.

https://stackoverflow.com/questions/44257061/how-to-do-configuration-of-postgresql-database-in-dhis2#44257061

Thanks in advance.

–

RAJA IMRAN QAMER,

Senior Software Engineer, Team Lead,

PACE TECHNOLOGIES,

Email:imran@pace-tech.com, rajaimranqamer@gmail.com

Phone: +923345073573, +92512361110

Web: www.pace-tech.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