dhis2-devs team mailing list archive

[Eduardo Gonzalez <egonzalezhn@xxxxxxxxx>]

Dear Knut,

many thanks for this, it worked!

I had to install Postgresql v9.5 to make it work. I the start couldn't get
in, then I did some tests and i discover that you have to add control all
privileges to the dhis user in the privileges tab.

Many thank again for this detail instructions, I suggest to add the
privileges step and add this Tutorial to the main page of the download
DHIS2 LIVE section, I have seem many people asking the same thing,  setup
postgresql with DHIS2 Live.

Again, many thanks for your help!

best,

E.

2018-02-24 2:29 GMT-06:00 Knut Staring <knutst@xxxxxxxxx>:

> Hi Eduardo,
>
> You seem to be on the right track, I attach some slides I made a long time
> ago.
>
> Here is what it says in the manual regarding dhis.conf:
> https://docs.dhis2.org/2.25/en/implementer/html/install_
> server_setup.html#install_database_configuration
>
> I would suggest starting with an empty Postgres database. and let DHIS2
> generate the tables.
>
> Knut
>
> On Sat, Feb 24, 2018 at 1:49 AM, Eduardo Gonzalez <egonzalezhn@xxxxxxxxx>
> wrote:
>
>> 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.
>>
>> _______________________________________________
>> 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
>>
>>
>
>
> --
> Knut Staring
>
> Department of Information, Evidence and Research
> World Health Organization, Geneva, Switzerland
> Office: +41 22 791 3683 <+41%2022%20791%2036%2083> Mob1: +33 6 4434 2931
> <+33%206%2044%2034%2029%2031> Mob2: +47 9188 0522
> Skype:     knutstar
>