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)
-
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:
-
</pre>
-
Change /etc/tomcat5.5/tomcat-users.xml
-
-
Also edit /etc/default/tomcat5.5 and change the value from "yes" to "no" and restart Tomcat.
-
<pre lang="enc__bash">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:
-
</pre>
-
Then setup a database, database user and give it some rights.
-
<pre lang="enc__bash">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
-
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.
-
</pre>
-
Create /etc/apache2/workers.properties file with the following content:
-
<pre lang="enc__bash">#
-
# 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
-
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 +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 && /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!
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)