Difference between revisions of "Ehour Timesheet Management"

From SME Server
Jump to navigationJump to search
m (→‎Quick install: SME9 specifics)
Line 10: Line 10:
  
 
==Quick install==
 
==Quick install==
1. Download the latest version (v1.1 tested in this how-to) [http://ehour.nl/download/download.phtml here]
 
  
 +
1. Download the latest version (v1.4.1 tested in this how-to) [http://ehour.nl/download/download.phtml here]
 +
 +
----
 +
=== SME 8===
 
2. Install Java: 'yum install java'
 
2. Install Java: 'yum install java'
 +
----
 +
=== SME 9 ===
 +
2. Install Java: 'yum install java-1.6.0-openjdk dejavu*
 +
 +
----
 +
  
 
3. Make the downloaded file executable: 'chmod 755 [downloaded_file]'
 
3. Make the downloaded file executable: 'chmod 755 [downloaded_file]'
Line 19: Line 28:
  
 
5. Point your browser to 'http://yourserver:8000' and login with user/pass: admin:admin
 
5. Point your browser to 'http://yourserver:8000' and login with user/pass: admin:admin
 
  
 
==MySQL backend==
 
==MySQL backend==

Revision as of 18:25, 24 August 2014

PythonIcon.png Skill level: Medium
The instructions on this page require a basic knowledge of linux.


About

"eHour is the open source webbased time tracking tool for companies and organizations who need accurate information on how much time is spend on projects by their people. eHour makes the amount of time your people spend on projects visible and available as simple and user friendly as possible. eHour requires Java."


Forum discussion

This how-to can be discussed on the forums here


Quick install

1. Download the latest version (v1.4.1 tested in this how-to) here


SME 8

2. Install Java: 'yum install java'


SME 9

2. Install Java: 'yum install java-1.6.0-openjdk dejavu*



3. Make the downloaded file executable: 'chmod 755 [downloaded_file]'

4. Execute the downloaded file: './[downloaded_file], and follow script/questions

5. Point your browser to 'http://yourserver:8000' and login with user/pass: admin:admin

MySQL backend

By default eHour uses an internal database (Derby). However you can use MySQL as the backend database too. Please note that if you want to use/change to MySQL, all existing data will not be used/transferred. It will still be available in the Derby database.

A. Create a new MySQL database (e.g. ehour) (see here how to)

B. Download the MySQL schema for ehour here

C. Import the downloaded MySQL schema into the ehour database

mysql ehour < fresh.mysql.sql

D. Allow MySQL Local Network Access

config setprop mysqld LocalNetworkingOnly no
expand-template /etc/my.cnf
sv t /service/mysqld  

E. Create ehour SME Server db entries (Only required if you want to access ehour from the outside world)

config set ehour service
config setprop ehour TCPPort 8000
config setprop ehour access public
config setprop ehour status enabled
signal-event remoteaccess-update

F. Edit the ehour config file to use the MySQL database

/opt/ehour/home/conf/ehour.properties

Set the database to MySQL and remove the # signs in front of the MySQL lines and change the MySQL user and password

ehour.standalone.port=8000
# derby, mysql and postgresql are supported. When derby is selected you can ignore the ehour.database lines
ehour.database=mysql
#
# for mysql uncomment the following lines (and make sure postgresql lines below are commented out)
ehour.database.driver=com.mysql.jdbc.Driver
ehour.database.url=jdbc:mysql://localhost:3306/ehour?zeroDateTimeBehavior=convertToNull&useOldAliasMetadataBehavior=true 
ehour.database.username=[mysql user]
ehour.database.password=[mysql password]
#
# for postgresql uncomment the following lines (and make sure mysql lines above are commented out)
#ehour.database.driver=org.postgresql.Driver
#ehour.database.url=jdbc:postgresql://localhost:5433/ehour 
#ehour.database.username=sa 
#ehour.database.password=sa
#
ehour.db.version=0.8.4
#
ehour.configurationType=DEPLOYMENT
#
ehour.translations=%ehour.home%/resources/i18n

G. Add '/opt/ehour/ehour start' to /etc/rc.d/rc.local (This can be improved by adding ehour to runlevel 7)


Demo

here