How to Link Tomcat 7 and Postgresql 9.2

Dear All,

I had finally succeeded in my first installation.

I changed the DHIS2_HOME folder to the another user called '’Jux” and then create the environmental variable /home/Jux/DHIS2_HOME/dhis in the tomcat file in etc/init.d. I finally turn the tomcat file into execution file by doing the chmod 755 tomcat.

Thanks for everything. But I will be coming with another question about our central server in a few minute.

···

Ola Hodne Titlestad (Mr)
HISP
Department of Informatics

University
of Oslo

Mobile: +47 48069736
Home address: Eftasåsen 68, 0687 Oslo, Norway. Googlemaps link

On 13 September 2013 12:35, Gerald Thomas gerald.81@hotmail.com wrote:

Knut,
Please I am sorry for my late response.
Kindly find the attached file as per request.
From the environmental variable the tomcat is not seeing the database.


From: knutst@gmail.com
Date: Fri, 13 Sep 2013 08:01:01 +0200
Subject: Re: [Dhis2-users] How to Link Tomcat 7 and Postgresql 9.2

To: gerald.81@hotmail.com
CC: dhis2-users@lists.launchpad.net

Hi Gerald,

This is not the screenshot I need to see. Please log in (I think you said admin/district is working). Then in the menu go to Help → About DHIS2.

Just copy the text of that page (or take another screenshot if you prefer) and send to me.

Knut

On Fri, Sep 13, 2013 at 7:30 AM, Gerald Thomas gerald.81@hotmail.com wrote:

FYI! Sorry I didn’t attached before.

Sent from Windows Mail

From: Gerald Thomas

Sent: ‎Friday‎, ‎September‎ ‎13‎, ‎2013 ‎6‎:‎30‎ ‎AM
To: Knut Staring
Cc: dhis2-users@lists.launchpad.net

Knut,

I really don’t know where to put this export statement; because I already tried it on the ~/.bashrc file but it is not work. I tried it on the /etc/environment; it is not working. I am not start Tomcat using bin/startup.sh because I already enable it to run automatically.

Please find the attached view screen of my dhis screen.

Sent from Windows Mail

From: Knut Staring

Sent: ‎Friday‎, ‎September‎ ‎13‎, ‎2013 ‎6‎:‎20‎ ‎AM
To: Gerald Thomas
Cc: dhis2-users@lists.launchpad.net

Also, where did you put the export statement? Are you starting using Tomcat’s bin/startup.sh ? Is that where you included the statement below?

export DHIS2_HOME=/home/DHIS2_HOME/dhis

On Fri, Sep 13, 2013 at 7:16 AM, Knut Staring knutst@gmail.com wrote:

This file looks good, and seems to be in the place you are pointing to.

Please also share the content of the About DHIS2 page.

On Fri, Sep 13, 2013 at 7:09 AM, Gerald Thomas gerald.81@hotmail.com wrote:

Dear Knut,

Yes I am talking about Ubuntu installation. My windows installation is working ok.

Please find the attached file as per request

Sent from Windows Mail

From: Knut Staring

Sent: ‎Friday‎, ‎September‎ ‎13‎, ‎2013 ‎6‎:‎06‎ ‎AM
To: Gerald Thomas
Cc: dhis2-users@lists.launchpad.net

Hi Gerald, I assume you are talking about and Ubuntu installation even though you send from Windows Mail?

In your /home/DHIS2_HOME/dhis folder, do you have a file called hibernate.properties? Can you share the contents of that file with us?

Inside DHIS2, please go to Help → About DHIS2 and copy the content here.

Knut

On Fri, Sep 13, 2013 at 6:44 AM, Gerald Thomas gerald.81@hotmail.com wrote:

Dear Support,

I already completed the installation but i can’t get access to the

database that i had imported. During my research i have seeing a lot of

procedures to do it but they seem not to be working. Please can you help

me with a reliable solution. If possible can you send a your messenger

ID (Skype or gtalk) so that we can do the process together. Thanks in

advance for your help.

Kindly note that I am not having any errors but I can only login to the dhis using the default username/password (admin/district). This simply means the database that I had imported is not seeing the tomcat.

Most of the journals said this is my problem “export DHIS2_HOME='/home/dhis/config”

On my configuration DHIS2_HOME directory is found inside the home folder of the root; therefore my “export DHIS2_HOME=/home/DHIS2_HOME/dhis

Please I don’t know if this is were I am getting it all wrong. Please help

Sent from Windows Mail


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


Knut Staring

Dept. of Informatics, University of Oslo

+4791880522

http://dhis2.org


Knut Staring

Dept. of Informatics, University of Oslo

+4791880522

http://dhis2.org


Knut Staring

Dept. of Informatics, University of Oslo

+4791880522

http://dhis2.org


Knut Staring

Dept. of Informatics, University of Oslo

+4791880522

http://dhis2.org


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

Hi Gerald,

the initial problem was likely that the user starting up DHIS was not the same as the user’s .bashrc file you set the DHIS2_HOME variable in. To avoid this problems and make it more predictable it is recommended to set DHIS2_HOME inside a tomcat/bin/setenv.sh file, ie. directly for the tomcat instance you are running.

Lars

···

On Fri, Sep 13, 2013 at 2:29 PM, Gerald Thomas gerald.81@hotmail.com wrote:

Dear All,

I had finally succeeded in my first installation.

I changed the DHIS2_HOME folder to the another user called '’Jux” and then create the environmental variable /home/Jux/DHIS2_HOME/dhis in the tomcat file in etc/init.d. I finally turn the tomcat file into execution file by doing the chmod 755 tomcat.

Thanks for everything. But I will be coming with another question about our central server in a few minute.

Sent from Windows Mail

From: Gerald Thomas

Sent: Friday, September 13, 2013 1:01 PM
To: Ola Hodne Titlestad
Cc: Knut Staring, dhis2-users@lists.launchpad.net

Yes it is. But since it look like it is the issue I am changing the user account which is house it and send you the file again.

Sent from Windows Mail

From: Ola Hodne Titlestad

Sent: Friday, September 13, 2013 12:29 PM
To: Gerald Thomas
Cc: Knut Staring, dhis2-users@lists.launchpad.net

Gerald,

Are you sure /home/DHIS2_HOME/dhis is a valid path to a folder/directory on your local system and that the file hibernate.properties is located in that folder?

Ola



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


Ola Hodne Titlestad (Mr)
HISP
Department of Informatics

University of Oslo

Mobile: +47 48069736
Home address: Eftasåsen 68, 0687 Oslo, Norway. Googlemaps link

On 13 September 2013 12:35, Gerald Thomas gerald.81@hotmail.com wrote:

Knut,
Please I am sorry for my late response.
Kindly find the attached file as per request.
From the environmental variable the tomcat is not seeing the database.


From: knutst@gmail.com
Date: Fri, 13 Sep 2013 08:01:01 +0200
Subject: Re: [Dhis2-users] How to Link Tomcat 7 and Postgresql 9.2

To: gerald.81@hotmail.com
CC: dhis2-users@lists.launchpad.net

Hi Gerald,

This is not the screenshot I need to see. Please log in (I think you said admin/district is working). Then in the menu go to Help → About DHIS2.

Just copy the text of that page (or take another screenshot if you prefer) and send to me.

Knut

On Fri, Sep 13, 2013 at 7:30 AM, Gerald Thomas gerald.81@hotmail.com wrote:

FYI! Sorry I didn’t attached before.

Sent from Windows Mail

From: Gerald Thomas

Sent: Friday, September 13, 2013 6:30 AM
To: Knut Staring
Cc: dhis2-users@lists.launchpad.net

Knut,

I really don’t know where to put this export statement; because I already tried it on the ~/.bashrc file but it is not work. I tried it on the /etc/environment; it is not working. I am not start Tomcat using bin/startup.sh because I already enable it to run automatically.

Please find the attached view screen of my dhis screen.

Sent from Windows Mail

From: Knut Staring

Sent: Friday, September 13, 2013 6:20 AM
To: Gerald Thomas
Cc: dhis2-users@lists.launchpad.net

Also, where did you put the export statement? Are you starting using Tomcat’s bin/startup.sh ? Is that where you included the statement below?

export DHIS2_HOME=/home/DHIS2_HOME/dhis

On Fri, Sep 13, 2013 at 7:16 AM, Knut Staring knutst@gmail.com wrote:

This file looks good, and seems to be in the place you are pointing to.

Please also share the content of the About DHIS2 page.

On Fri, Sep 13, 2013 at 7:09 AM, Gerald Thomas gerald.81@hotmail.com wrote:

Dear Knut,

Yes I am talking about Ubuntu installation. My windows installation is working ok.

Please find the attached file as per request

Sent from Windows Mail

From: Knut Staring

Sent: Friday, September 13, 2013 6:06 AM
To: Gerald Thomas
Cc: dhis2-users@lists.launchpad.net

Hi Gerald, I assume you are talking about and Ubuntu installation even though you send from Windows Mail?

In your /home/DHIS2_HOME/dhis folder, do you have a file called hibernate.properties? Can you share the contents of that file with us?

Inside DHIS2, please go to Help → About DHIS2 and copy the content here.

Knut

On Fri, Sep 13, 2013 at 6:44 AM, Gerald Thomas gerald.81@hotmail.com wrote:

Dear Support,

I already completed the installation but i can’t get access to the

database that i had imported. During my research i have seeing a lot of

procedures to do it but they seem not to be working. Please can you help

me with a reliable solution. If possible can you send a your messenger

ID (Skype or gtalk) so that we can do the process together. Thanks in

advance for your help.

Kindly note that I am not having any errors but I can only login to the dhis using the default username/password (admin/district). This simply means the database that I had imported is not seeing the tomcat.

Most of the journals said this is my problem “export DHIS2_HOME='/home/dhis/config”

On my configuration DHIS2_HOME directory is found inside the home folder of the root; therefore my “export DHIS2_HOME=/home/DHIS2_HOME/dhis

Please I don’t know if this is were I am getting it all wrong. Please help

Sent from Windows Mail


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


Knut Staring

Dept. of Informatics, University of Oslo

+4791880522

http://dhis2.org


Knut Staring

Dept. of Informatics, University of Oslo

+4791880522

http://dhis2.org


Knut Staring

Dept. of Informatics, University of Oslo

+4791880522

http://dhis2.org


Knut Staring

Dept. of Informatics, University of Oslo

+4791880522

http://dhis2.org


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