[Dhis2-users] Help Required

2011-10-27 Thread Ocaya Stephen
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


Re: [Dhis2-users] Help Required

2011-10-27 Thread Knut Staring
What does your log say?

Regards, Knut (via mobile phone)
On Oct 27, 2011 10:28 PM, "Ocaya Stephen"  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
>
>
___
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


Re: [Dhis2-users] Help Required

2011-10-27 Thread Ola Hodne Titlestad
 /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  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
>
>
___
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


Re: [Dhis2-users] Help Required

2011-10-27 Thread Jason Pickering
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"  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  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
>>
>>
>
> ___
> 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


Re: [Dhis2-users] Help Required

2011-10-27 Thread stephocay
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.

-Original Message-
From: Jason Pickering 
Date: Fri, 28 Oct 2011 05:57:08 
To: Ola Hodne Titlestad
Cc: ; Ocaya Stephen
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"  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<http://maps.google.com/maps?f=q&source=s_q&hl=en&geocode=&q=Vetlandsvn.+95B,+0685+Oslo,+Norway>
>
>
> On 27 October 2011 20:58, Ocaya Stephen  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
>>
>>
>
> ___
> 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


Re: [Dhis2-users] Help Required

2011-10-27 Thread Ocaya Stephen
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,  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 
> *Date: *Fri, 28 Oct 2011 05:57:08 +0200
> *To: *Ola Hodne Titlestad
> *Cc: *; Ocaya Stephen >
> *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"  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<http://maps.google.com/maps?f=q&source=s_q&hl=en&geocode=&q=Vetlandsvn.+95B,+0685+Oslo,+Norway>
>>
>>
>> On 27 October 2011 20:58, Ocaya Stephen  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
>>>
>>>
>>
>> ___
>> 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


Re: [Dhis2-users] Help Required

2011-10-28 Thread Jason Pickering
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  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,  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 
>> *Date: *Fri, 28 Oct 2011 05:57:08 +0200
>> *To: *Ola Hodne Titlestad
>> *Cc: *; Ocaya Stephen<
>> stepho...@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"  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<http://maps.google.com/maps?f=q&source=s_q&hl=en&geocode=&q=Vetlandsvn.+95B,+0685+Oslo,+Norway>
>>>
>>>
>>> On 27 October 2011 20:58, Ocaya Stephen  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=/

Re: [Dhis2-users] Help Required

2011-10-28 Thread Knut Staring
Jason is talking about Linux users, not database user's

Regards, Knut (via mobile phone)
On Oct 28, 2011 9:49 AM, "Jason Pickering" 
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 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,  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 
>>> *Date: *Fri, 28 Oct 2011 05:57:08 +0200
>>> *To: *Ola Hodne Titlestad
>>> *Cc: *; Ocaya Stephen<
>>> stepho...@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" 
>>> 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<http://maps.google.com/maps?f=q&source=s_q&hl=en&geocode=&q=Vetlandsvn.+95B,+0685+Oslo,+Norway>
>>>>
>>>>
>>>> On 27 October 2011 20:58, Ocaya Stephen  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
>

Re: [Dhis2-users] Help Required

2011-10-28 Thread Orvalho Augusto
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.picker...@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 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,  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 
>>> *Date: *Fri, 28 Oct 2011 05:57:08 +0200
>>> *To: *Ola Hodne Titlestad
>>> *Cc: *; Ocaya Stephen<
>>> stepho...@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" 
>>> 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<http://maps.google.com/maps?f=q&source=s_q&hl=en&geocode=&q=Vetlandsvn.+95B,+0685+Oslo,+Norway>
>>>>
>>>>
>>>> On 27 October 2011 20:58, Ocaya Stephen  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 h

Re: [Dhis2-users] Help Required

2011-10-28 Thread Knut Staring
On Fri, Oct 28, 2011 at 10:42 AM, Orvalho Augusto  wrote:
> 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

> Caveman
>
>
>
>
> On Fri, Oct 28, 2011 at 9:49 AM, Jason Pickering
>  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 
>> 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,  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 
>>>> Date: Fri, 28 Oct 2011 05:57:08 +0200
>>>> To: Ola Hodne Titlestad
>>>> Cc: ; Ocaya
>>>> Stephen
>>>> 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" 
>>>> 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
>>>>>
>>>>>
>>>>&

Re: [Dhis2-users] Help Required

2011-10-28 Thread Lars Helge Øverland
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

___
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


Re: [Dhis2-users] Help Required

2011-10-28 Thread Orvalho Augusto
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 

> 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
>
___
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


Re: [Dhis2-users] Help Required

2011-10-28 Thread Knut Staring
Caveman, we don't recommend windows for servers.

Regards, Knut (via mobile phone)
On Oct 28, 2011 7:35 PM, "Orvalho Augusto"  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 
>
>> 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
>>
>
>
___
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


Re: [Dhis2-users] Help Required

2011-10-28 Thread Orvalho Augusto
Good! Thanks

Caveman

On Fri, Oct 28, 2011 at 7:40 PM, Knut Staring  wrote:

> Caveman, we don't recommend windows for servers.
>
> Regards, Knut (via mobile phone)
> On Oct 28, 2011 7:35 PM, "Orvalho Augusto"  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 
>>
>>> 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
>>>
>>
>>
___
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