Try eHour 2

eHour 2 - eHour in the Cloud

The new eHour has a brand new user interface, new features such as an approval process and expense claiming plus a lot more. Give it a try.

 

Install instructions eHour.WAR on Linux

eHour requires a Java JDK, the Apache Tomcat servlet container and a MySQL database to be installed. Although this may seem as a lot, installation is easy.

When you are upgrading an existing installation of eHour, please see the upgrade instructions; do not follow the installation instructions again.

 

Java 1.5+

eHour is developed using Java technology so you'll need a Java runtime environment (version 1.5 or newer), before anything happens.

Download and install the latest version from http://java.sun.com/javase/downloads/index.jsp.
Even if your Linux distribution came with Java pre-installed it might be better to reinstall Java as some dists such as Ubuntu come with a very strict security policy.

 

MySQL 5+ installation and configuration

For now only MySQL is supported as the back-end database. If you don't have MySQL, version 5 at least, installed download it from http://dev.mysql.com/downloads/mysql/5.0.html#downloads and follow the 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:


        mysqladmin create ehour -u user -p


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 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):


        mysql ehour -u user -p < fresh.mysql.sql


Now that the database is set up it's time to set up the final part, Apache Tomcat.

 

Apache Tomcat 5.5 installation and configuration

Install Tomcat

Apache Tomcat acts as the container server which runs the application. If you don't have Tomcat installed you can download it from http://tomcat.apache.org/download-55.cgi#5.5.20.

Install instructions for Tomcat can be found on their site.

Install the MySQL JDBC connector
Now that you have Tomcat installed you need to make it MySQL-aware by installing the MySQL JDBC connector. The JDBC connector can be fetched from http://dev.mysql.com/downloads/connector/j/5.0.html.
Take note, version 5.1.5 of the MySQL JDBC connector contains a bug that prevents eHour from working correctly. eHour was tested with version 5.0.8.

Unpack the downloaded archive and copy the extracted mysql-connector-5.x.x-bin.jar file to Tomcat's common/lib directory.

Hook up eHour to Tomcat
Before you deploy eHour in Tomcat you have to configure the database connection, make sure Tomcat isn't running.
In the conf/tomcat directory of the eHour distribution you'll find the ehour.xml config file.
Edit this file in your favourite text-editor and replace the following fields:

@ehour.db.usernamethe MySQL username
@ehour.db.passwordthe MySQL password
@ehour.db.hostnamethe hostname/IP address of your MySQL server
@ehour.db.namethe eHour MySQL database

When you're done editing copy this file to the conf/Catalina/localhost directory in your Tomcat install directory

Install eHour in Tomcat
In the install directory of Tomcat create a directory named deploy

From the eHour distribution copy the ehour-0.8.3.war into this directory.

Don't copy the war file to your webapps dir as you normally would.

 

Start it all up !

MySQL is probably already running, otherwise you wouldn't be able to install the database in a previous step.
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/.