WR Time Tracker Setup and Configuration Guide

Note 1: This document is no longer current. Please read the readme.txt file in the distribution archive for installation instructions.

Note 2: This procedure describes WR Time Tracker installation on FreeBSD v5.1. Assumptions: Apache web server, MySQL, ad PHP are installed and fully functional.

Set up components for WR Time Tracker

1) Install pear-DB. The source code is assumed to be in /usr/ports/databases/pear-DB. If it is not there consider getting it from http://pear.php.net.

Install pear-DB by executing the following commands:

cd /usr/ports/databases/pear-DB 
make && make install 

Install WR Time Tracker source code and configure Apache access

2) Download WR Time Tracker source code:

cd /opt 
fetch http://wrconsulting.com/downloads/wrtimetracker.zip 

3) Unpack the archive and set proper access rights:

cd /usr/local/www/data 
tar -zxf /opt/wrtimetracker.tgz 
chown -R www:www timetracker 
chmod 440 ./timetracker/config.php 

4) Set up Apache web server to work with WR Time Tracker directory (/usr/local/www/data/timetracker).

Create and configure access to WR Time Tracker MySQL database (wrtts)

5) Create MySQL database for WR Time Tracker and remove the database creation script from the timetracker directory:

mysql < ./timetracker/mysql.sql 
rm -f ./timetracker/mysql.sql 

6) Create login and password to access the wrtts database. In order to do it launch mysql console and execute the following commands:

grant all on wrtts.* to wrttsuser@localhost identified by "wrttspassword"; 
exit; 

* Note: you may need to change login (wrttsuser) and its password (wrttspassword).

7) Edit the file config.php in the timetracker catalog. Find the $dsn variable in it and put your login and password values in it. for example:

$dsn = 'mysql://wrttsuser:wrttspassword@localhost/wrtts'; 

8) Restart Apache:

/usr/local/sbin/apachectl restart 

Setup automatic database cleanups for WR Time Tracker

9) If necessary, set up automatic database cleaning from old records. Default history depth is 3 months. If this is not what you want open the file ./timetracker/maint_db.sh and find the following line in it:

old=`date -v-3m +%Y%m%d` 

The 3 here is the history depth in months. Change it as you wish and then move the script maint_db.sh to the weekly cron catalog:

mv ./timetracker/maint_db.sh /etc/periodic/weekly/601.maint_db.sh

Now WR Time Tracker should be ready to run.

Check WR Time Tracker functionality

Test functionality of the system by creating a new manager account and giving it a test ride. Here is how the form for creating manager accounts looks like: