eHour requires a Java JDK, the Apache Tomcat servlet container and a MySQL or PostgreSQL database.
When you are upgrading an existing installation of eHour, please see the upgrade instructions.
Java 1.6+
eHour requires a Java 6 runtime environment.
Download and install the latest version from Oracle's site. Look for the button "download JRE".
With eHour 0.9.1 a Java 6 environment is required.
Tomcat installation
Apache Tomcat is the container server which runs the application. If you don't have Tomcat installed you can download it from http://tomcat.apache.org/download-60.cgi.
Install instructions for Tomcat can be found on their site.
eHour home
eHour 0.9.1 introduces the concept of the eHour home directory. This is the directory where you unpacked the eHour archive. The log file is stored in this directory as well as general configuration, etc.
To make eHour aware of the home directory you have to create an environment variable:
Database setup
Click a database to review the setup guide and any known issues.
MySQL
Install MySQL
To install MySQL use your Linux's package system or install it manually by downloading it from MySQL's site and follow their installation instructions.
Create database
With MySQL installed and started create a MySQL database named eHour by executing the following command and replacing user with a database user that has enough priviliges to create a new database:
Install eHour database
With the ehour database created the next step is to create the datamodel and fill them with some default data. In the eHour's sql/mysql/install directory there's a fresh.mysql.sql script which contains the datamodel and default data.
Execute it by running the following command (don't forget to replace the user):
Unpack the downloaded archive and copy the extracted mysql-connector-5.x.x-bin.jar file to Tomcat's lib directory.
PostgreSQL
Install PostgreSQL
To install PostgreSQL use your Linux's package system or install it manually by downloading it from PostgreSQL's site and follow their installation instructions.
Create database
With PostgreSQL installed and started create a database named eHour by executing the following command and replacing user with a database user that has enough priviliges to create a new database:
Install eHour database
With the ehour database created the next step is to create the datamodel and fill them with some default data. In the eHour's sql/postgresql/install directory there's a fresh.postgresql.sql script which contains the datamodel and default data.
Execute it by running the following command (don't forget to replace the user):
Copy the downloaded jar file to Tomcat's lib directory.
Database connection
Before you deploy eHour in Tomcat you have to configure the database connection, make sure that Tomcat isn't running.
In the conf/tomcat directory of the eHour distribution you'll find an ehour_mysql.xml/ehour_postgresql.xml config file.
Open this file in a text editor.
The first line reads:
Unfortunately Tomcat does not read the environment variable you set up earlier so you need to replace the ${EHOUR_HOME} variable with the full path to your ehour home directory. For example it should look like:
Replace the following fields:
%ehour.db.username%
the database username
%ehour.db.password%
the database password
%ehour.db.hostname%
the hostname/IP address of your database server
%ehour.db.name%
the eHour database name
When you're done editing save this file as ehour.xml in the conf/Catalina/localhost directory in your Tomcat install directory. You need to create this directory if you haven't started Tomcat before.
Don't drop the ehour war in Tomcat's webapp directory as you would do with other applications
Make sure you rename the file to ehour.xml
Start it all up !
Make sure you have started your database first.
Start Tomcat by running startup.sh in the bin directory of the Tomcat installation directory. After a couple of seconds Tomcat and eHour will be initialized and you can access the application at [http://localhost:8080/ehour/].
No one expected, but won in this contest is the wedding planner salary same boy, because he gave the name of the writer last Grabbe, wrote the play "City of masters, or the tale of two hunchback," which he read ... of course, Grandma!
1 Comment
Hide/Show CommentsNov 09, 2011
Anonymous
No one expected, but won in this contest is the wedding planner salary same boy, because he gave the name of the writer last Grabbe, wrote the play "City of masters, or the tale of two hunchback," which he read ... of course, Grandma!
Add Comment