dhis2-users team mailing list archive

[Knut Staring <knutst@xxxxxxxxx>]

Hi Francis,

It is still connecting to H2 instead of Postgres (database type: H2).

One possibility is that this is because your file has aquired an unwanted
extension like .txt. It looks to you as if it is called dhis.conf, but in
reality it is called dhis.conf.txt

You can also just delete the top rows in dhis.conf, those that relate to H2.

Knut

On Wed, Sep 13, 2017 at 4:44 PM, Fran Kimonye <fkimonye@xxxxxxxxx> wrote:

> plus the two log file
>
> On Wed, Sep 13, 2017 at 5:41 PM, Fran Kimonye <fkimonye@xxxxxxxxx> wrote:
>
>> Have deleted and the error still persist.
>>
>> Attached find my dhis.config file
>>
>>
>> On Wed, Sep 13, 2017 at 5:21 PM, Knut Staring <knutst@xxxxxxxxx> wrote:
>>
>>> Or just delete the environment variable
>>>
>>> On Wed, Sep 13, 2017 at 4:20 PM, Fran Kimonye <fkimonye@xxxxxxxxx>
>>> wrote:
>>>
>>>> My database name is dhis2.
>>>>
>>>> I should set my Environment variable DHIS_HOME: C:/PATH/Projects/DH
>>>> IS2/1/dhis-live/conf
>>>>
>>>> On Wed, Sep 13, 2017 at 5:09 PM, Knut Staring <knutst@xxxxxxxxx> wrote:
>>>>
>>>>> So your database is called dhis2?
>>>>>
>>>>> And dhis.conf is in C:/PATH/Projects/DHIS2/1/dhis-live/conf ?
>>>>>
>>>>> Then I think the problem may be that you have set the Environment
>>>>> variable DHIS2_HOME: C:\DHIS2, which is a different location.
>>>>>
>>>>> On Wed, Sep 13, 2017 at 4:04 PM, Fran Kimonye <fkimonye@xxxxxxxxx>
>>>>> wrote:
>>>>>
>>>>>> Hi Knut,
>>>>>>
>>>>>> kindly assist
>>>>>> *dhis.config file.*
>>>>>>
>>>>>> connection.dialect = org.hibernate.dialect.PostgreSQLDialect
>>>>>> connection.driver_class = org.postgresql.Driver
>>>>>> connection.url = jdbc:postgresql:dhis2
>>>>>> connection.username = dhis
>>>>>> connection.password = Dhis2017
>>>>>>
>>>>>> connection.schema = update
>>>>>>
>>>>>> *PostgreSQL connection*
>>>>>>
>>>>>> username: dhis
>>>>>> password: Dhis2017
>>>>>>
>>>>>> Have attached the log file.
>>>>>>
>>>>>> On Wed, Sep 13, 2017 at 3:48 PM, Knut Staring <knutst@xxxxxxxxx>
>>>>>> wrote:
>>>>>>
>>>>>>> You should see a black MS-DOS command window with lots of text. My
>>>>>>> guess is that there is something wrong with the connection file, probably
>>>>>>> one of the following
>>>>>>>
>>>>>>> a) the database name
>>>>>>> b) the postgres username
>>>>>>> c) the password
>>>>>>>
>>>>>>> On Wed, Sep 13, 2017 at 2:46 PM, Fran Kimonye <fkimonye@xxxxxxxxx>
>>>>>>> wrote:
>>>>>>>
>>>>>>>> Hi knut,
>>>>>>>>
>>>>>>>> This the error am experiencing when access DHIS2 live on localhost.
>>>>>>>> HTTP ERROR: 503
>>>>>>>>
>>>>>>>> Problem accessing /. Reason:
>>>>>>>>
>>>>>>>>     Service Unavailable
>>>>>>>>
>>>>>>>> ------------------------------
>>>>>>>> *Powered by Jetty://*
>>>>>>>>
>>>>>>>> *Regards,*
>>>>>>>> *Francis*
>>>>>>>>
>>>>>>>> On Wed, Sep 13, 2017 at 3:06 PM, Knut Staring <knutst@xxxxxxxxx>
>>>>>>>> wrote:
>>>>>>>>
>>>>>>>>> Here are some old slides that may be helpful
>>>>>>>>>
>>>>>>>>> On Wed, Sep 13, 2017 at 2:02 PM, Knut Staring <knutst@xxxxxxxxx>
>>>>>>>>> wrote:
>>>>>>>>>
>>>>>>>>>>  Go into the /conf folder and open the file dhis.conf with an
>>>>>>>>>> editor, e.g. WordPad or Notepad++
>>>>>>>>>>
>>>>>>>>>> Then configure the file like the first section here:
>>>>>>>>>> https://docs.dhis2.org/2.27/en/implementer/html/install_dhis
>>>>>>>>>> 2_configuration_reference.html
>>>>>>>>>>
>>>>>>>>>> In the following line, you can change the last word (dhis2) to
>>>>>>>>>> the name of your particular Postgres database:
>>>>>>>>>>
>>>>>>>>>> connection.url = jdbc:postgresql:dhis2
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>> On Wed, Sep 13, 2017 at 1:58 PM, Fran Kimonye <fkimonye@xxxxxxxxx
>>>>>>>>>> > wrote:
>>>>>>>>>>
>>>>>>>>>>> Thanks Knut. Have joined the user mailing list. How do i connect
>>>>>>>>>>> to PostgreSQL using DHIS2 live? If i use DHIS2 live will i be able to
>>>>>>>>>>> customize the forms?
>>>>>>>>>>>
>>>>>>>>>>> Regards,
>>>>>>>>>>> Francis
>>>>>>>>>>>
>>>>>>>>>>> On Wed, Sep 13, 2017 at 2:04 PM, Knut Staring <knutst@xxxxxxxxx>
>>>>>>>>>>> wrote:
>>>>>>>>>>>
>>>>>>>>>>>> Dear Francis, please sign up for the user mailing list:
>>>>>>>>>>>> https://launchpad.net/~dhis2-users
>>>>>>>>>>>>
>>>>>>>>>>>> To run DHIS2 on your laptop, you dont need MS SQL, Tomcat or
>>>>>>>>>>>> Xampp. You can just use DHIS2 Live, and connect to Postgres.
>>>>>>>>>>>>
>>>>>>>>>>>> Regards,
>>>>>>>>>>>> Knut
>>>>>>>>>>>>
>>>>>>>>>>>>
>>>>>>>>>>>> On Wed, Sep 13, 2017 at 1:01 PM, Fran Kimonye <
>>>>>>>>>>>> fkimonye@xxxxxxxxx> wrote:
>>>>>>>>>>>>
>>>>>>>>>>>>> i'm a newbie in DHIS2. How do i install .WAR far in windows 10 64 bit. I have installed Postgress, MS SQL, Tomcat through Xammp and Bitnami tomcatstack-8.5.20-0.
>>>>>>>>>>>>>
>>>>>>>>>>>>> I manged to start the services for Bitnami tomcatstack-8.5.20-0 and loade the .WAR file though i cannot open the link. The error reads 403 Access Denied.
>>>>>>>>>>>>>
>>>>>>>>>>>>> Kindly assist. Thank you.
>>>>>>>>>>>>>
>>>>>>>>>>>>>
>>>>>>>>>>>>> Regards,
>>>>>>>>>>>>>
>>>>>>>>>>>>> Francis
>>>>>>>>>>>>>
>>>>>>>>>>>>>
>>>>>>>>>>>>
>>>>>>>>>>>>
>>>>>>>>>>>> --
>>>>>>>>>>>> Knut Staring
>>>>>>>>>>>> Dept. of Informatics, University of Oslo
>>>>>>>>>>>> Norway: +4791880522 <+47%20918%2080%20522>
>>>>>>>>>>>> Skype: knutstar
>>>>>>>>>>>> http://dhis2.org
>>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>> --
>>>>>>>>>> Knut Staring
>>>>>>>>>> Dept. of Informatics, University of Oslo
>>>>>>>>>> Norway: +4791880522 <+47%20918%2080%20522>
>>>>>>>>>> Skype: knutstar
>>>>>>>>>> http://dhis2.org
>>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>> --
>>>>>>>>> Knut Staring
>>>>>>>>> Dept. of Informatics, University of Oslo
>>>>>>>>> Norway: +4791880522 <+47%20918%2080%20522>
>>>>>>>>> Skype: knutstar
>>>>>>>>> http://dhis2.org
>>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> --
>>>>>>> Knut Staring
>>>>>>> Dept. of Informatics, University of Oslo
>>>>>>> Norway: +4791880522 <+47%20918%2080%20522>
>>>>>>> Skype: knutstar
>>>>>>> http://dhis2.org
>>>>>>>
>>>>>>
>>>>>>
>>>>>
>>>>>
>>>>> --
>>>>> Knut Staring
>>>>> Dept. of Informatics, University of Oslo
>>>>> Norway: +4791880522 <+47%20918%2080%20522>
>>>>> Skype: knutstar
>>>>> http://dhis2.org
>>>>>
>>>>
>>>>
>>>
>>>
>>> --
>>> Knut Staring
>>> Dept. of Informatics, University of Oslo
>>> Norway: +4791880522 <+47%20918%2080%20522>
>>> Skype: knutstar
>>> http://dhis2.org
>>>
>>
>>
>


-- 
Knut Staring
Dept. of Informatics, University of Oslo
Norway: +4791880522
Skype: knutstar
http://dhis2.org