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 <egonzale...@gmail.com> 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@lists.launchpad.net > 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 Mob1: +33 6 4434 2931 Mob2: +47 9188 0522 Skype: knutstar
Installation on a Windows laptop (1).pptx
Description: MS-Powerpoint 2007 presentation
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp