Howto to install actiTIME on a Debian server
actiTIME Basic is a free easy-to-use timesheet optimized for your basic time tracking needs. It provides you with functionality for:
- time tracking and reporting
- user schedule and overtime control
- project and task management
For more information visit the website: http://www.actitime.com/fw_features.html
This article describes how to install actiTIME on a Debian server or a Debian derived OS such as Ubuntu. actiTIME comes in three flavors and one of them is freeware 
That’s the one we are going to install.
So let’s start!
These are the requirements for actiTIME:
- Java 2 SDK 1.4.2 or higher
- Apache Tomcat Application Server 4.1 or higher
- MySQL database, it will need MySQL 4.1.17+, 5.0.x or 5.1.x installed
Install Java
Add “non-free” to the Debian Lenny repositories (/etc/apt/sources.list)
-
apt-get update && apt-get install sun-java6-jdk
-
update-java-alternatives -s java-6-sun
-
echo 'JAVA_HOME="/usr/lib/jvm/java-6-sun"' | tee -a /etc/environment
Install Tomcat
Install it by running:
-
apt-get install tomcat5.5 tomcat5.5-admin
Change /etc/tomcat5.5/tomcat-users.xml
-
<?xml version='1.0' encoding='utf-8'?>
-
<tomcat-users>
-
<role rolename="admin"/>
-
<role rolename="manager"/>
-
<role rolename="tomcat"/>
-
<user username="tomcat" password="Some-Obscure-Password" roles="admin,manager,tomcat"/>
-
</tomcat-users>
Also edit /etc/default/tomcat5.5 and change the value from “yes” to “no” and restart Tomcat.
-
TOMCAT5_SECURITY=no
-
/etc/init.d/tomcat5.5 restart
Install mysql-server and create database
If you don’t already have a running mysql server then install it by running:
-
apt-get install mysql-server
Then setup a database, database user and give it some rights.
-
mysql -uroot -p
-
CREATE DATABASE actitime;
-
CREATE USER 'actitime-usr'@'localhost' IDENTIFIED BY 'Another-Obscure-Password';
-
GRANT ALL ON actitime.* TO 'actitime-usr'@'localhost';
-
flush privileges;
-
\q
Install actiTIME
Download ActiTime and upload it to your server. (http://actitime.com/download.html
-
cd /var/lib/tomcat5.5/webapps
-
tar xvzf /tmp/actitime15_unix.tar.gz
-
cd actitime
-
bash ./setup_mysql.sh -mysqlhome /usr -username actitime-usr -password Another-Obscure-Password -host localhost -dbname actitime
Settings file (db name and user including pwd) is found in /var/lib/tomcat5.5/webapps/actitime/WEB-INF/classes/com/actimind/actitime/AT.Properties
You should now be able to connect to your actiTIME. Point a browser to http://your.host.name:8180/actitime
Now I have a bit difficulty with this setting. This means that I have to shoot a another hole in my vlan ACL. Let’s make this happen on port 80 shall we!
Install libapache2-mod-jk
Connect Apache2 to Tomcat5.5.
-
apt-get install libapache2-mod-jk
Create /etc/apache2/workers.properties file with the following content:
-
#
-
# This file provides minimal jk configuration properties needed to
-
# connect to Tomcat.
-
#
-
# We define a worked named 'default'
-
#
-
-
workers.tomcat_home=/var/lib/tomcat6
-
workers.java_home=/usr/lib/jvm/java-6-sun
-
ps=/
-
worker.list=default
-
-
worker.default.port=8009
-
worker.default.host=localhost
-
worker.default.type=ajp13
-
worker.default.lbfactor=1
Then add the following to /etc/apache2/apache2.conf
-
# Where to find workers.properties
-
JkWorkersFile /etc/apache2/workers.properties
-
-
# Where to put jk logs
-
JkLogFile /var/log/apache2/mod_jk.log
-
-
# Set the jk log level [debug/error/info]
-
JkLogLevel info
-
-
# Select the log format
-
JkLogStampFormat "[%a %b %d %H:%M:%S %Y] "
Finally create a new VirtualHost in /etc/apache2/sites-available and place the following content beteen the VirtualHost tags:
-
# JkOptions indicate to send SSL KEY SIZE,
-
JkOptions +ForwardKeySize +ForwardURICompat -ForwardDirectories
-
-
# JkRequestLogFormat set the request format
-
JkRequestLogFormat "%w %V %T"
-
-
# Tomcat serves everything by default
-
JkMount / default
-
JkMount /* default
-
-
# Apache serves the following URLs
-
JkUnMount /static default
-
JkUnMount /static/* default
Now enable the VirtualHost and reload Apache2:
-
a2ensite <site-name> && /etc/init.d/apache reload
So now ActiTime should also be available on http://your.host.name/actitime
Point a browser to the URL and log on with the default credentials. (username: admin / password: manager)
AND CHANGE IT!
You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.
Hi!
I read Your artuicle, did what You said and all I can get is error no. 500 from tomcat server. Do You have any idea, what could it be?
Hi nathan,
Error 500 is a very common error and does not provide detailed information. Can you confirm that tomcat server is running with provided examples?
(apt-get install tomcat5.5-webapps)