Help Required

Hullo All,

I have set up DHIS 2.5 on Ubuntu Server Using the Installation Steps Outlined on the website (dhis2.org) and the application seems not to be picking the database connection setting in hibernate.properties.

On Logging, I See the following Message:
“The database is currently running in-memory. This is useful for testing purposes but might happen because your database configuration was not picked up. Please make sure this is intentional. Your data will be destroyed when the application shuts down.”

My Hibernate File is in /home/root/dhis2/DHIS2_HOME/hibernate.properties

MY Environment Variable is Here. /usr/local/apache-tomcat-7.0.22/bin/setenv.sh and the content of the setenv.sh is below

export JAVA_HOME=/usr/lib/jvm/java-6-sun
export JAVA_OPTS=“-Xmx600m -XX:MaxPermSize=1000m”
export DHIS2_HOME=/home/root/dhis2/DHIS2_HOME/

Thanks for any Help
Stephen Ocaya

···

You can do anything, but not everything.

What does your log say?

Regards, Knut (via mobile phone)

···

On Oct 27, 2011 10:28 PM, “Ocaya Stephen” stephocay@gmail.com wrote:

Hullo All,

I have set up DHIS 2.5 on Ubuntu Server Using the Installation Steps Outlined on the website (dhis2.org) and the application seems not to be picking the database connection setting in hibernate.properties.

On Logging, I See the following Message:
“The database is currently running in-memory. This is useful for testing purposes but might happen because your database configuration was not picked up. Please make sure this is intentional. Your data will be destroyed when the application shuts down.”

My Hibernate File is in /home/root/dhis2/DHIS2_HOME/hibernate.properties

MY Environment Variable is Here. /usr/local/apache-tomcat-7.0.22/bin/setenv.sh and the content of the setenv.sh is below

export JAVA_HOME=/usr/lib/jvm/java-6-sun
export JAVA_OPTS=“-Xmx600m -XX:MaxPermSize=1000m”
export DHIS2_HOME=/home/root/dhis2/DHIS2_HOME/

Thanks for any Help
Stephen Ocaya

You can do anything, but not everything.


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

/usr/local/apache-tomcat-7.0.22/logs/catalina.out will tell you whether dhis found your hibernate.properties file or not, and tell you if the DHIS2_HOME was recognised or not.

Ola

···

Ola Hodne Titlestad (Mr)
HISP
Department of Informatics
University of Oslo

Mobile: +47 48069736
Home address: Vetlandsvn. 95B, 0685 Oslo, Norway. Googlemaps link

On 27 October 2011 20:58, Ocaya Stephen stephocay@gmail.com wrote:

You can do anything, but not everything.

Hullo All,

I have set up DHIS 2.5 on Ubuntu Server Using the Installation Steps Outlined on the website (dhis2.org) and the application seems not to be picking the database connection setting in hibernate.properties.

On Logging, I See the following Message:
“The database is currently running in-memory. This is useful for testing purposes but might happen because your database configuration was not picked up. Please make sure this is intentional. Your data will be destroyed when the application shuts down.”

My Hibernate File is in /home/root/dhis2/DHIS2_HOME/hibernate.properties

MY Environment Variable is Here. /usr/local/apache-tomcat-7.0.22/bin/setenv.sh and the content of the setenv.sh is below

export JAVA_HOME=/usr/lib/jvm/java-6-sun
export JAVA_OPTS=“-Xmx600m -XX:MaxPermSize=1000m”
export DHIS2_HOME=/home/root/dhis2/DHIS2_HOME/

Thanks for any Help
Stephen Ocaya


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

Have you properly configured postgres to enable tcp/ip connections from localhost?

You should not run tomcat with root. If you are using another user to start tomcat, this user may not be able to read anything from /home/root.

As knut and ola say however, the log will provide you with the answer.

Regards,

Jason

···

On Oct 28, 2011 12:00 AM, “Ola Hodne Titlestad” olati@ifi.uio.no wrote:

/usr/local/apache-tomcat-7.0.22/logs/catalina.out will tell you whether dhis found your hibernate.properties file or not, and tell you if the DHIS2_HOME was recognised or not.

Ola



Ola Hodne Titlestad (Mr)
HISP
Department of Informatics
University of Oslo

Mobile: +47 48069736
Home address: Vetlandsvn. 95B, 0685 Oslo, Norway. Googlemaps link

On 27 October 2011 20:58, Ocaya Stephen stephocay@gmail.com wrote:

You can do anything, but not everything.

Hullo All,

I have set up DHIS 2.5 on Ubuntu Server Using the Installation Steps Outlined on the website (dhis2.org) and the application seems not to be picking the database connection setting in hibernate.properties.

On Logging, I See the following Message:
“The database is currently running in-memory. This is useful for testing purposes but might happen because your database configuration was not picked up. Please make sure this is intentional. Your data will be destroyed when the application shuts down.”

My Hibernate File is in /home/root/dhis2/DHIS2_HOME/hibernate.properties

MY Environment Variable is Here. /usr/local/apache-tomcat-7.0.22/bin/setenv.sh and the content of the setenv.sh is below

export JAVA_HOME=/usr/lib/jvm/java-6-sun
export JAVA_OPTS=“-Xmx600m -XX:MaxPermSize=1000m”
export DHIS2_HOME=/home/root/dhis2/DHIS2_HOME/

Thanks for any Help
Stephen Ocaya


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


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

Thank you all. Let me checkout on the configuration and have alook at the log file.

As regards the root, so far the computer has that account and it is the one that is used to start dhis. May be to confirm, is this the dhis database user or the computer user? I hope it is the computer user.

Will let you. Thanks again

···

Sent from my BlackBerry® smartphone provided by Airtel Uganda.


From: Jason Pickering jason.p.pickering@gmail.com

Date: Fri, 28 Oct 2011 05:57:08 +0200

To: Ola Hodne Titlestadolati@ifi.uio.no

Cc: dhis2-users@lists.launchpad.net; Ocaya Stephenstephocay@gmail.com

Subject: Re: [Dhis2-users] Help Required

Have you properly configured postgres to enable tcp/ip connections from localhost?

You should not run tomcat with root. If you are using another user to start tomcat, this user may not be able to read anything from /home/root.

As knut and ola say however, the log will provide you with the answer.

Regards,

Jason

On Oct 28, 2011 12:00 AM, “Ola Hodne Titlestad” olati@ifi.uio.no wrote:

/usr/local/apache-tomcat-7.0.22/logs/catalina.out will tell you whether dhis found your hibernate.properties file or not, and tell you if the DHIS2_HOME was recognised or not.

Ola



Ola Hodne Titlestad (Mr)
HISP
Department of Informatics
University of Oslo

Mobile: +47 48069736
Home address: Vetlandsvn. 95B, 0685 Oslo, Norway. Googlemaps link

On 27 October 2011 20:58, Ocaya Stephen stephocay@gmail.com wrote:

You can do anything, but not everything.

Hullo All,

I have set up DHIS 2.5 on Ubuntu Server Using the Installation Steps Outlined on the website (dhis2.org) and the application seems not to be picking the database connection setting in hibernate.properties.

On Logging, I See the following Message:
“The database is currently running in-memory. This is useful for testing purposes but might happen because your database configuration was not picked up. Please make sure this is intentional. Your data will be destroyed when the application shuts down.”

My Hibernate File is in /home/root/dhis2/DHIS2_HOME/hibernate.properties

MY Environment Variable is Here. /usr/local/apache-tomcat-7.0.22/bin/setenv.sh and the content of the setenv.sh is below

export JAVA_HOME=/usr/lib/jvm/java-6-sun
export JAVA_OPTS=“-Xmx600m -XX:MaxPermSize=1000m”
export DHIS2_HOME=/home/root/dhis2/DHIS2_HOME/

Thanks for any Help
Stephen Ocaya


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


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

Hullo,

This is a subsection of the log file catalina.out

It seems the hibernate.properties could not be read

Deploying web application archive dhis.war

  • INFO 21:50:29,457 System property dhis2.home not set (DefaultLocationManager.java [Thread-2])

  • INFO 21:50:29,459 Environment variable DHIS2_HOME points to /home/root/dhis2/DHIS2_HOME/ (DefaultLocationManager.java [Thread-2])

  • INFO 21:50:30,999 Could not read external configuration from file system (DefaultHibernateConfigurationProvider.java [Thread-2])

  • INFO 21:50:48,557 Sceduled task of type: org.hisp.dhis.scheduling.Runnables (SpringScheduler.java [Thread-2])

  • INFO 21:50:50,196 Executing startup routine [1 of 11, runlevel 1]: TableAlteror (DefaultStartupRoutineExecutor.java [Thread-2])

  • INFO 21:50:50,948 Tables updated (TableAlteror.java [Thread-2])

I have SOLVED the Problem.

Thanks TO ALL

···

On Thu, Oct 27, 2011 at 9:13 PM, stephocay@gmail.com wrote:

Thank you all. Let me checkout on the configuration and have alook at the log file.

As regards the root, so far the computer has that account and it is the one that is used to start dhis. May be to confirm, is this the dhis database user or the computer user? I hope it is the computer user.

Will let you. Thanks again
Sent from my BlackBerry® smartphone provided by Airtel Uganda.


From: Jason Pickering jason.p.pickering@gmail.com

Date: Fri, 28 Oct 2011 05:57:08 +0200

To: Ola Hodne Titlestadolati@ifi.uio.no

Cc: dhis2-users@lists.launchpad.net; Ocaya Stephenstephocay@gmail.com

Subject: Re: [Dhis2-users] Help Required

Have you properly configured postgres to enable tcp/ip connections from localhost?

You should not run tomcat with root. If you are using another user to start tomcat, this user may not be able to read anything from /home/root.

As knut and ola say however, the log will provide you with the answer.

Regards,

Jason

On Oct 28, 2011 12:00 AM, “Ola Hodne Titlestad” olati@ifi.uio.no wrote:

/usr/local/apache-tomcat-7.0.22/logs/catalina.out will tell you whether dhis found your hibernate.properties file or not, and tell you if the DHIS2_HOME was recognised or not.

Ola



Ola Hodne Titlestad (Mr)
HISP
Department of Informatics
University of Oslo

Mobile: +47 48069736
Home address: Vetlandsvn. 95B, 0685 Oslo, Norway. Googlemaps link

On 27 October 2011 20:58, Ocaya Stephen stephocay@gmail.com wrote:

You can do anything, but not everything.

Hullo All,

I have set up DHIS 2.5 on Ubuntu Server Using the Installation Steps Outlined on the website (dhis2.org) and the application seems not to be picking the database connection setting in hibernate.properties.

On Logging, I See the following Message:
“The database is currently running in-memory. This is useful for testing purposes but might happen because your database configuration was not picked up. Please make sure this is intentional. Your data will be destroyed when the application shuts down.”

My Hibernate File is in /home/root/dhis2/DHIS2_HOME/hibernate.properties

MY Environment Variable is Here. /usr/local/apache-tomcat-7.0.22/bin/setenv.sh and the content of the setenv.sh is below

export JAVA_HOME=/usr/lib/jvm/java-6-sun
export JAVA_OPTS=“-Xmx600m -XX:MaxPermSize=1000m”
export DHIS2_HOME=/home/root/dhis2/DHIS2_HOME/

Thanks for any Help
Stephen Ocaya


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


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

You can do anything, but not everything.

Hi Stephen,
Just one more important point, and that is to be sure NOT to run Tomcat as "root’. If you are using a manual install of Tomcat, as opposed to installing it through the package manager of Linux, it is best practice to create a seperate user for tomcat, and run the process as a non-privileged user. There are numerous examples on the net to show you how to achieve this. We should probably highlight this in the implementation guide a bit better, but it it documented there from the standpoint of using the package manager to install Tomcat, as opposed to a manual install.

Regards,
Jason

···

On Fri, Oct 28, 2011 at 8:18 AM, Ocaya Stephen stephocay@gmail.com wrote:

Hullo,

This is a subsection of the log file catalina.out

It seems the hibernate.properties could not be read

Deploying web application archive dhis.war

  • INFO 21:50:29,457 System property dhis2.home not set (DefaultLocationManager.java [Thread-2])

  • INFO 21:50:29,459 Environment variable DHIS2_HOME points to /home/root/dhis2/DHIS2_HOME/ (DefaultLocationManager.java [Thread-2])

  • INFO 21:50:30,999 Could not read external configuration from file system (DefaultHibernateConfigurationProvider.java [Thread-2])

  • INFO 21:50:48,557 Sceduled task of type: org.hisp.dhis.scheduling.Runnables (SpringScheduler.java [Thread-2])

  • INFO 21:50:50,196 Executing startup routine [1 of 11, runlevel 1]: TableAlteror (DefaultStartupRoutineExecutor.java [Thread-2])

  • INFO 21:50:50,948 Tables updated (TableAlteror.java [Thread-2])

I have SOLVED the Problem.

Thanks TO ALL

On Thu, Oct 27, 2011 at 9:13 PM, stephocay@gmail.com wrote:

Thank you all. Let me checkout on the configuration and have alook at the log file.

As regards the root, so far the computer has that account and it is the one that is used to start dhis. May be to confirm, is this the dhis database user or the computer user? I hope it is the computer user.

Will let you. Thanks again
Sent from my BlackBerry® smartphone provided by Airtel Uganda.


From: Jason Pickering jason.p.pickering@gmail.com

Date: Fri, 28 Oct 2011 05:57:08 +0200

To: Ola Hodne Titlestadolati@ifi.uio.no

Cc: dhis2-users@lists.launchpad.net; Ocaya Stephenstephocay@gmail.com

Subject: Re: [Dhis2-users] Help Required

Have you properly configured postgres to enable tcp/ip connections from localhost?

You should not run tomcat with root. If you are using another user to start tomcat, this user may not be able to read anything from /home/root.

As knut and ola say however, the log will provide you with the answer.

Regards,

Jason

On Oct 28, 2011 12:00 AM, “Ola Hodne Titlestad” olati@ifi.uio.no wrote:

/usr/local/apache-tomcat-7.0.22/logs/catalina.out will tell you whether dhis found your hibernate.properties file or not, and tell you if the DHIS2_HOME was recognised or not.

Ola



Ola Hodne Titlestad (Mr)
HISP
Department of Informatics
University of Oslo

Mobile: +47 48069736
Home address: Vetlandsvn. 95B, 0685 Oslo, Norway. Googlemaps link

On 27 October 2011 20:58, Ocaya Stephen stephocay@gmail.com wrote:

You can do anything, but not everything.

Hullo All,

I have set up DHIS 2.5 on Ubuntu Server Using the Installation Steps Outlined on the website (dhis2.org) and the application seems not to be picking the database connection setting in hibernate.properties.

On Logging, I See the following Message:
“The database is currently running in-memory. This is useful for testing purposes but might happen because your database configuration was not picked up. Please make sure this is intentional. Your data will be destroyed when the application shuts down.”

My Hibernate File is in /home/root/dhis2/DHIS2_HOME/hibernate.properties

MY Environment Variable is Here. /usr/local/apache-tomcat-7.0.22/bin/setenv.sh and the content of the setenv.sh is below

export JAVA_HOME=/usr/lib/jvm/java-6-sun
export JAVA_OPTS=“-Xmx600m -XX:MaxPermSize=1000m”
export DHIS2_HOME=/home/root/dhis2/DHIS2_HOME/

Thanks for any Help
Stephen Ocaya


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


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

You can do anything, but not everything.

Jason is talking about Linux users, not database user’s

Regards, Knut (via mobile phone)

···

On Oct 28, 2011 9:49 AM, “Jason Pickering” jason.p.pickering@gmail.com wrote:

Hi Stephen,
Just one more important point, and that is to be sure NOT to run Tomcat as "root’. If you are using a manual install of Tomcat, as opposed to installing it through the package manager of Linux, it is best practice to create a seperate user for tomcat, and run the process as a non-privileged user. There are numerous examples on the net to show you how to achieve this. We should probably highlight this in the implementation guide a bit better, but it it documented there from the standpoint of using the package manager to install Tomcat, as opposed to a manual install.

Regards,
Jason

On Fri, Oct 28, 2011 at 8:18 AM, Ocaya Stephen stephocay@gmail.com wrote:

Hullo,

This is a subsection of the log file catalina.out

It seems the hibernate.properties could not be read

Deploying web application archive dhis.war

  • INFO 21:50:29,457 System property dhis2.home not set (DefaultLocationManager.java [Thread-2])

  • INFO 21:50:29,459 Environment variable DHIS2_HOME points to /home/root/dhis2/DHIS2_HOME/ (DefaultLocationManager.java [Thread-2])

  • INFO 21:50:30,999 Could not read external configuration from file system (DefaultHibernateConfigurationProvider.java [Thread-2])

  • INFO 21:50:48,557 Sceduled task of type: org.hisp.dhis.scheduling.Runnables (SpringScheduler.java [Thread-2])

  • INFO 21:50:50,196 Executing startup routine [1 of 11, runlevel 1]: TableAlteror (DefaultStartupRoutineExecutor.java [Thread-2])

  • INFO 21:50:50,948 Tables updated (TableAlteror.java [Thread-2])

I have SOLVED the Problem.

Thanks TO ALL

On Thu, Oct 27, 2011 at 9:13 PM, stephocay@gmail.com wrote:

Thank you all. Let me checkout on the configuration and have alook at the log file.

As regards the root, so far the computer has that account and it is the one that is used to start dhis. May be to confirm, is this the dhis database user or the computer user? I hope it is the computer user.

Will let you. Thanks again
Sent from my BlackBerry® smartphone provided by Airtel Uganda.


From: Jason Pickering jason.p.pickering@gmail.com

Date: Fri, 28 Oct 2011 05:57:08 +0200

To: Ola Hodne Titlestadolati@ifi.uio.no

Cc: dhis2-users@lists.launchpad.net; Ocaya Stephenstephocay@gmail.com

Subject: Re: [Dhis2-users] Help Required

Have you properly configured postgres to enable tcp/ip connections from localhost?

You should not run tomcat with root. If you are using another user to start tomcat, this user may not be able to read anything from /home/root.

As knut and ola say however, the log will provide you with the answer.

Regards,

Jason

On Oct 28, 2011 12:00 AM, “Ola Hodne Titlestad” olati@ifi.uio.no wrote:

/usr/local/apache-tomcat-7.0.22/logs/catalina.out will tell you whether dhis found your hibernate.properties file or not, and tell you if the DHIS2_HOME was recognised or not.

Ola



Ola Hodne Titlestad (Mr)
HISP
Department of Informatics
University of Oslo

Mobile: +47 48069736
Home address: Vetlandsvn. 95B, 0685 Oslo, Norway. Googlemaps link

On 27 October 2011 20:58, Ocaya Stephen stephocay@gmail.com wrote:

You can do anything, but not everything.

Hullo All,

I have set up DHIS 2.5 on Ubuntu Server Using the Installation Steps Outlined on the website (dhis2.org) and the application seems not to be picking the database connection setting in hibernate.properties.

On Logging, I See the following Message:
“The database is currently running in-memory. This is useful for testing purposes but might happen because your database configuration was not picked up. Please make sure this is intentional. Your data will be destroyed when the application shuts down.”

My Hibernate File is in /home/root/dhis2/DHIS2_HOME/hibernate.properties

MY Environment Variable is Here. /usr/local/apache-tomcat-7.0.22/bin/setenv.sh and the content of the setenv.sh is below

export JAVA_HOME=/usr/lib/jvm/java-6-sun
export JAVA_OPTS=“-Xmx600m -XX:MaxPermSize=1000m”
export DHIS2_HOME=/home/root/dhis2/DHIS2_HOME/

Thanks for any Help
Stephen Ocaya


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


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

You can do anything, but not everything.


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

And another recommendation is protect tomcat with Apache (configure it to work like reverse proxy). Somewhere on the tomcat docs they do recommend that too.

Caveman

···

On Fri, Oct 28, 2011 at 9:49 AM, Jason Pickering jason.p.pickering@gmail.com wrote:

Hi Stephen,
Just one more important point, and that is to be sure NOT to run Tomcat as "root’. If you are using a manual install of Tomcat, as opposed to installing it through the package manager of Linux, it is best practice to create a seperate user for tomcat, and run the process as a non-privileged user. There are numerous examples on the net to show you how to achieve this. We should probably highlight this in the implementation guide a bit better, but it it documented there from the standpoint of using the package manager to install Tomcat, as opposed to a manual install.

Regards,
Jason

On Fri, Oct 28, 2011 at 8:18 AM, Ocaya Stephen stephocay@gmail.com wrote:

Hullo,

This is a subsection of the log file catalina.out

It seems the hibernate.properties could not be read

Deploying web application archive dhis.war

  • INFO 21:50:29,457 System property dhis2.home not set (DefaultLocationManager.java [Thread-2])

  • INFO 21:50:29,459 Environment variable DHIS2_HOME points to /home/root/dhis2/DHIS2_HOME/ (DefaultLocationManager.java [Thread-2])

  • INFO 21:50:30,999 Could not read external configuration from file system (DefaultHibernateConfigurationProvider.java [Thread-2])

  • INFO 21:50:48,557 Sceduled task of type: org.hisp.dhis.scheduling.Runnables (SpringScheduler.java [Thread-2])

  • INFO 21:50:50,196 Executing startup routine [1 of 11, runlevel 1]: TableAlteror (DefaultStartupRoutineExecutor.java [Thread-2])

  • INFO 21:50:50,948 Tables updated (TableAlteror.java [Thread-2])

I have SOLVED the Problem.

Thanks TO ALL

On Thu, Oct 27, 2011 at 9:13 PM, stephocay@gmail.com wrote:

Thank you all. Let me checkout on the configuration and have alook at the log file.

As regards the root, so far the computer has that account and it is the one that is used to start dhis. May be to confirm, is this the dhis database user or the computer user? I hope it is the computer user.

Will let you. Thanks again
Sent from my BlackBerry® smartphone provided by Airtel Uganda.


From: Jason Pickering jason.p.pickering@gmail.com

Date: Fri, 28 Oct 2011 05:57:08 +0200

To: Ola Hodne Titlestadolati@ifi.uio.no

Cc: dhis2-users@lists.launchpad.net; Ocaya Stephenstephocay@gmail.com

Subject: Re: [Dhis2-users] Help Required

Have you properly configured postgres to enable tcp/ip connections from localhost?

You should not run tomcat with root. If you are using another user to start tomcat, this user may not be able to read anything from /home/root.

As knut and ola say however, the log will provide you with the answer.

Regards,

Jason

On Oct 28, 2011 12:00 AM, “Ola Hodne Titlestad” olati@ifi.uio.no wrote:

/usr/local/apache-tomcat-7.0.22/logs/catalina.out will tell you whether dhis found your hibernate.properties file or not, and tell you if the DHIS2_HOME was recognised or not.

Ola



Ola Hodne Titlestad (Mr)
HISP
Department of Informatics
University of Oslo

Mobile: +47 48069736
Home address: Vetlandsvn. 95B, 0685 Oslo, Norway. Googlemaps link

On 27 October 2011 20:58, Ocaya Stephen stephocay@gmail.com wrote:

You can do anything, but not everything.

Hullo All,

I have set up DHIS 2.5 on Ubuntu Server Using the Installation Steps Outlined on the website (dhis2.org) and the application seems not to be picking the database connection setting in hibernate.properties.

On Logging, I See the following Message:
“The database is currently running in-memory. This is useful for testing purposes but might happen because your database configuration was not picked up. Please make sure this is intentional. Your data will be destroyed when the application shuts down.”

My Hibernate File is in /home/root/dhis2/DHIS2_HOME/hibernate.properties

MY Environment Variable is Here. /usr/local/apache-tomcat-7.0.22/bin/setenv.sh and the content of the setenv.sh is below

export JAVA_HOME=/usr/lib/jvm/java-6-sun
export JAVA_OPTS=“-Xmx600m -XX:MaxPermSize=1000m”
export DHIS2_HOME=/home/root/dhis2/DHIS2_HOME/

Thanks for any Help
Stephen Ocaya


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


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

You can do anything, but not everything.


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

And another recommendation is protect tomcat with Apache (configure it to
work like reverse proxy). Somewhere on the tomcat docs they do recommend
that too.

Indeed - this is also in the DHIS2 implementation guide:
http://dhis2.org/doc/snapshot/en/implementer/html/ch10s04.html#d5e981

Bob has further refined the setup to ease the task of running multiple
Tomcat instances behind Apache, and is hoping to add this to the
documentation over the next week or so.

Knut

···

On Fri, Oct 28, 2011 at 10:42 AM, Orvalho Augusto <orvaquim@gmail.com> wrote:

Caveman

On Fri, Oct 28, 2011 at 9:49 AM, Jason Pickering > <jason.p.pickering@gmail.com> wrote:

Hi Stephen,
Just one more important point, and that is to be sure NOT to run Tomcat as
"root'. If you are using a manual install of Tomcat, as opposed to
installing it through the package manager of Linux, it is best practice to
create a seperate user for tomcat, and run the process as a non-privileged
user. There are numerous examples on the net to show you how to achieve
this. We should probably highlight this in the implementation guide a bit
better, but it it documented there from the standpoint of using the package
manager to install Tomcat, as opposed to a manual install.

Regards,
Jason

On Fri, Oct 28, 2011 at 8:18 AM, Ocaya Stephen <stephocay@gmail.com> >> wrote:

Hullo,

This is a subsection of the log file catalina.out

It seems the hibernate.properties could not be read

Deploying web application archive dhis.war
* INFO 21:50:29,457 System property dhis2.home not set
(DefaultLocationManager.java [Thread-2])
* INFO 21:50:29,459 Environment variable DHIS2_HOME points to
/home/root/dhis2/DHIS2_HOME/ (DefaultLocationManager.java [Thread-2])
* INFO 21:50:30,999 Could not read external configuration from file
system (DefaultHibernateConfigurationProvider.java [Thread-2])
* INFO 21:50:48,557 Sceduled task of type:
org.hisp.dhis.scheduling.Runnables (SpringScheduler.java [Thread-2])
* INFO 21:50:50,196 Executing startup routine [1 of 11, runlevel 1]:
TableAlteror (DefaultStartupRoutineExecutor.java [Thread-2])
* INFO 21:50:50,948 Tables updated (TableAlteror.java [Thread-2])

I have SOLVED the Problem.

Thanks TO ALL

On Thu, Oct 27, 2011 at 9:13 PM, <stephocay@gmail.com> wrote:

Thank you all. Let me checkout on the configuration and have alook at
the log file.

As regards the root, so far the computer has that account and it is the
one that is used to start dhis. May be to confirm, is this the dhis database
user or the computer user? I hope it is the computer user.

Will let you. Thanks again

Sent from my BlackBerry® smartphone provided by Airtel Uganda.

________________________________
From: Jason Pickering <jason.p.pickering@gmail.com>
Date: Fri, 28 Oct 2011 05:57:08 +0200
To: Ola Hodne Titlestad<olati@ifi.uio.no>
Cc: <dhis2-users@lists.launchpad.net>; Ocaya
Stephen<stephocay@gmail.com>
Subject: Re: [Dhis2-users] Help Required

Have you properly configured postgres to enable tcp/ip connections from
localhost?

You should not run tomcat with root. If you are using another user to
start tomcat, this user may not be able to read anything from /home/root.

As knut and ola say however, the log will provide you with the answer.

Regards,
Jason

On Oct 28, 2011 12:00 AM, "Ola Hodne Titlestad" <olati@ifi.uio.no> >>>> wrote:

/usr/local/apache-tomcat-7.0.22/logs/catalina.out will tell you
whether dhis found your hibernate.properties file or not, and tell you if
the DHIS2_HOME was recognised or not.
Ola
------

----------------------------------
Ola Hodne Titlestad (Mr)
HISP
Department of Informatics
University of Oslo

Mobile: +47 48069736
Home address: Vetlandsvn. 95B, 0685 Oslo, Norway. Googlemaps link

On 27 October 2011 20:58, Ocaya Stephen <stephocay@gmail.com> wrote:

Hullo All,

I have set up DHIS 2.5 on Ubuntu Server Using the Installation Steps
Outlined on the website (dhis2.org) and the application seems not to be
picking the database connection setting in hibernate.properties.

On Logging, I See the following Message:
"The database is currently running in-memory. This is useful for
testing purposes but might happen because your database configuration was
not picked up. Please make sure this is intentional. Your data will be
destroyed when the application shuts down."

My Hibernate File is in
/home/root/dhis2/DHIS2_HOME/hibernate.properties

MY Environment Variable is Here.
/usr/local/apache-tomcat-7.0.22/bin/setenv.sh and the content of the
setenv.sh is below

export JAVA_HOME=/usr/lib/jvm/java-6-sun
export JAVA_OPTS="-Xmx600m -XX:MaxPermSize=1000m"
export DHIS2_HOME=/home/root/dhis2/DHIS2_HOME/

Thanks for any Help
Stephen Ocaya

--

You can do anything, but not everything.

_______________________________________________
Mailing list: DHIS 2 Users in Launchpad
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : DHIS 2 Users in Launchpad
More help : ListHelp - Launchpad Help

_______________________________________________
Mailing list: DHIS 2 Users in Launchpad
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : DHIS 2 Users in Launchpad
More help : ListHelp - Launchpad Help

--

You can do anything, but not everything.

_______________________________________________
Mailing list: DHIS 2 Users in Launchpad
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : DHIS 2 Users in Launchpad
More help : ListHelp - Launchpad Help

_______________________________________________
Mailing list: DHIS 2 Users in Launchpad
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : DHIS 2 Users in Launchpad
More help : ListHelp - Launchpad Help

--
Knut Staring
Informatics, U. of Oslo
http://hisp.uio.no
+4791880522

Not trying to confuse people here. But if a reverse proxy is only
what's needed i can recommend using nginx over apache - its
specifically designed to act as one and a lot more light-weight / less
resource intensive than apache. On debian / ubuntu Install with

sudo apt-get install nginx

and then put this into the server block of /usr/local/nginx/conf/nginx.conf

location / {
            proxy_pass http://localhost:8085/dhis/;
            proxy_redirect off;
}

start with

/usr/local/sbin/nginx

and stop with

/usr/local/sbin/nginx -s stop

Lars

Indeed is ngix is better for reverse proxy and a lot of more people start to use it. But I think there is not native ngix for windows so apache would fit for this.

And I think is not good to edit files (on debian way) /etc/apache/mods-enabled. So on Docs we must change those reverse proxy settings to a file located at /etc/apache/sites-*.

Sorry if I seem bad guy. Thanks!

Caveman

···

2011/10/28 Lars Helge Øverland larshelge@gmail.com

Not trying to confuse people here. But if a reverse proxy is only

what’s needed i can recommend using nginx over apache - its

specifically designed to act as one and a lot more light-weight / less

resource intensive than apache. On debian / ubuntu Install with

sudo apt-get install nginx

and then put this into the server block of /usr/local/nginx/conf/nginx.conf

location / {

        proxy_pass         [http://localhost:8085/dhis/](http://localhost:8085/dhis/);

        proxy_redirect     off;

}

start with

/usr/local/sbin/nginx

and stop with

/usr/local/sbin/nginx -s stop

Lars

Caveman, we don’t recommend windows for servers.

Regards, Knut (via mobile phone)

···

On Oct 28, 2011 7:35 PM, “Orvalho Augusto” orvaquim@gmail.com wrote:

Indeed is ngix is better for reverse proxy and a lot of more people start to use it. But I think there is not native ngix for windows so apache would fit for this.

And I think is not good to edit files (on debian way) /etc/apache/mods-enabled. So on Docs we must change those reverse proxy settings to a file located at /etc/apache/sites-*.

Sorry if I seem bad guy. Thanks!

Caveman

2011/10/28 Lars Helge Øverland larshelge@gmail.com

Not trying to confuse people here. But if a reverse proxy is only

what’s needed i can recommend using nginx over apache - its

specifically designed to act as one and a lot more light-weight / less

resource intensive than apache. On debian / ubuntu Install with

sudo apt-get install nginx

and then put this into the server block of /usr/local/nginx/conf/nginx.conf

location / {

        proxy_pass         [http://localhost:8085/dhis/](http://localhost:8085/dhis/);

        proxy_redirect     off;

}

start with

/usr/local/sbin/nginx

and stop with

/usr/local/sbin/nginx -s stop

Lars

Good! Thanks

Caveman

···

On Fri, Oct 28, 2011 at 7:40 PM, Knut Staring knutst@gmail.com wrote:

Caveman, we don’t recommend windows for servers.

Regards, Knut (via mobile phone)

On Oct 28, 2011 7:35 PM, “Orvalho Augusto” orvaquim@gmail.com wrote:

Indeed is ngix is better for reverse proxy and a lot of more people start to use it. But I think there is not native ngix for windows so apache would fit for this.

And I think is not good to edit files (on debian way) /etc/apache/mods-enabled. So on Docs we must change those reverse proxy settings to a file located at /etc/apache/sites-*.

Sorry if I seem bad guy. Thanks!

Caveman

2011/10/28 Lars Helge Øverland larshelge@gmail.com

Not trying to confuse people here. But if a reverse proxy is only

what’s needed i can recommend using nginx over apache - its

specifically designed to act as one and a lot more light-weight / less

resource intensive than apache. On debian / ubuntu Install with

sudo apt-get install nginx

and then put this into the server block of /usr/local/nginx/conf/nginx.conf

location / {

        proxy_pass         [http://localhost:8085/dhis/](http://localhost:8085/dhis/);

        proxy_redirect     off;

}

start with

/usr/local/sbin/nginx

and stop with

/usr/local/sbin/nginx -s stop

Lars