detail walkthrough to use postgresql with DHIS2 Live

Support - Assistance technique
1

Hi Ingunn,
I would suggest the following workflow for such emails. You can reply with a template such as below:

“

Hi xxx,

thanks for your request. Can I suggest that you reach out our DHIS2 Community members and send your request to the developers (dhis2-devs@lists.launchpad.net) and/or users lists (dhis2-users@lists.launchpad.net). Please note that you need to be signed up in these lists. In case you aren’t yet signed it, you can find instructions here: https://www.dhis2.org/contact.

Best,

yyy

"

Cheers,

Matthieu

···

———

Matthieu Pinard

DHIS2 Online Academy Coordinator | University of Oslo

On 28 Feb 2018, at 15:06, Ingunn Gihle ingunngi@ifi.uio.no wrote:

-----Opprinnelig melding-----
Fra: bounces@canonical.com [mailto:bounces@canonical.com] På vegne av Eduardo
Sendt: 24. februar 2018 02:48
Til: Ingunn Gihle ingunngi@ifi.uio.no
Emne: detail walkthrough to use postgresql with DHIS2 Live

Dear all,

I am trying to test DHIS2 for monitoring projects in a Humanitarian organization.

I cannot find the way to use postgresql with DHIS2 LIVE, so far i have located the dhis.conf file and also download dhis2-db-sierra-leone.sql.

Is it possible that you can help with a step by step instruction to make the set up? since i have limit knowledge for programing this database.

I have tried to make my test with the H2 version but when i try to use analytic to export i get this error:

2018-02-21 08:06:37 Process failed: StatementCallback; bad SQL
grammar [create table _orgunitstructure_temp (organisationunitid integer not null primary key, organisationunituid character(11), level integer, “idlevel1” integer, “uidlevel1” character(11), “idlevel2” integer, “uidlevel2” character(11));]; nested exception is
org.h2.jdbc.JdbcSQLException: Tabla “_ORGUNITSTRUCTURE_TEMP” ya existe Table “_ORGUNITSTRUCTURE_TEMP” already exists; SQL statement: create table _orgunitstructure_temp (organisationunitid integer not null primary key, organisationunituid character(11), level integer, “idlevel1” integer, “uidlevel1” character(11), “idlevel2” integer, “uidlevel2” character(11)); [42101-194]
2018-02-21 08:06:37 Updating resource tables
2018-02-21 08:06:37 Analytics table update process started

Then I tried to change the dhis2.conf with the following text:

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

didnt work, i got 503 error.

I have also downloaded POSTGRADESQL 10 (I am not sure if this is necessary).

many thanks in advance for your support!

best,

Eduardo.

This message was sent from Launchpad by
Eduardo (https://launchpad.net/~edgonhn) using the “Contact this team’s admins” link on the DHIS 2 developers team page (https://launchpad.net/~dhis2-devs).
For more information see
https://help.launchpad.net/YourAccount/ContactingPeople