WR Consulting

WR Time Tracker Installation Guide

Install and configure Apache web server and MySQL server.
Install PHP with PEAR database access code.
Unpack distribution files into a selected directory for Apache web server. If you have a previous deployment of WR Time Tracker v0.3 - remove it and then deploy new code.
For UNIX systems set full access rights for catalog WEB-INF/templates_c/ (chmod 777 templates_c).
Create your database in mysql console using mysql.sql script. For example:

mysql -u username -p < mysql.sql

Change $dsn value in /WEB-INF/config.php file to reflect your database connection parameters (user name and password). Note that in this variable:

define("DSN",'mysql://root:no@localhost/wrtts');
root is user name, no is password, wrtts is database name.

Set MULTITEAM_MODE = "true" in /WEB-INF/config.php file if you want to allow users create their own teams. By default it is "false", which means that only admin can create teams.
If you install time tracker into a sub-directory of your site reflect this in the APP_NAME parameter in /WEB-INF/config.php file. For example, for http://localhost/timetracker/ set APP_NAME = "timetracker".
Create database using mysql.sql script. Alternatively, if the database is already created, you can use /dbinstall.php utility to create its structure. Remove /dbinstall.php after use.
Login to your time tracker site as admin with password "secret" without quotes and create at least one team.
Change admin password using the following SQL console command:

update users set u_password=password('new_password_here') where u_login='admin'

No connection to the database.
WR Time Tracker was developed and tested for PHP <=5.1.2, MySQL <=4.1, Apache <=1.3.23.
PHP compiled without session support.

MySQL v4.1 is supported if you use WR Time Tracker v0.4.1 and later versions.
If you are migrating your database from earlier MySQL versions you might need to configure your server to support old passwords to allow existing users log on as before.
If things do not work consider reading this document http://dev.mysql.com/doc/refman/5.0/en/old-client.html

Backup database and the code on the site.
Deploy new v0.4.1 distribution code.
Change $dsn value in /WEB-INF/config.php file to reflect your database connection parameters (user name and password).
For UNIX systems set up full access rights for catalog WEB-INF/templates_c/ (chmod 777 templates_c).
Launch http://your_time_tracker_site/dbinstall.php utility. Sequentially execute an UPDATE and then CONVERT PASSWORDS operations. Remove /dbinstall.php after use.
Check whether your site is still working with old passwords, rollback if necessary.

Note: if these instructions need improvement please let us know what is missing. Thanks!

News
context sensitive news