News:
Forum:
Read News Read Forum

Anuko Time Tracker Installation Guide for Windows with IIS

Note: This procedure was tested on Windows XP SP3 and may also work for other Windows versions.

Installing MySQL Server

To install MySQL server (Community edition) 5.1.37 follow these steps:



When Configuration Wizard completes it creates and starts a Windows service called MySQL. It's probably a good idea to check in this service exists in Start - Control Panel - Administrative Tools - Services and whether you can stop and start it again.

C:\>mysql -u root -p
Enter password: ******
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2.
Server version: 5.1.37-community MySQL Community Server (GPL)

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> exit;
Bye

C:\>



Installing IIS

Install Internet Information Services (web server) if you haven't done it before.

Start / Control Panel / Add or Remove Programs / Add/Remove Windows Components / Internet Information Services (IIS)

Installing PHP

Install PHP for IIS & FastCGI with Microsoft Web Platform Installer as described here:

http://blogs.iis.net/bills/archive/2006/09/19/How-to-install-PHP-on-IIS7-_2800_RC1_2900_.aspx

Just click "Install Now with the Microsoft Web Platform Installed" button and accept all default settings.

Configuring PHP

Open Start / Control Panel / Add or Remove Programs, choose PHP 5.x.x and click Change button.

In case when installation file is not found download it from http://windows.php.net/download/ For example, http://windows.php.net/downloads/releases/php-5.2.10-nts-Win32-VC6-x86.msi

Move forward with Next button in opened PHP Setup wizard, choose Change button in it.
Move forward without changes until "Choose items for install" page.
Then enable the following components if they were not enabled yet:
Disable the following component:

Installing Anuko Time Tracker

Deploying Anuko Time Tracker Source Code

Download Anuko Time Tracker distribution archive. Current download path is http://www.anuko.com/downloads/time_tracker/anuko_time_tracker.zip

Extract the archive into C:\Inetpub\wwwroot\. The extraction procedure will create the timetracker directory inside wwwroot.

In Windows Explorer choose Properties on C:\Inetpub\wwwroot\timetracker, switch to Security tab and add Internet Guest Account (usually named IUSR_<MACHINENAME>) with Full Access.

If you don't see Properties / Security tab, tick off Windows Explorer / Tools / Folder Options / View / Use simple file sharing.

Creating a Database

Create a database for your time tracker to use, as well as login and password to access it. For example, if your database name is timetracker, login is ttuser and password ttpassword then start MySQL console and issue the following commands:
C:\>mysql -u root -p
Enter password: ******
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 9
Server version: 5.1.37-community MySQL Community Server (GPL)

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> create database timetracker;
Query OK, 1 row affected (0.00 sec)

mysql> grant all on timetracker.* to ttuser@localhost identified by "ttpassword";
Query OK, 0 rows affected (0.06 sec)

mysql> exit;
Bye

C:\>


C:\>mysql -u root -p
Enter password: ******
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 8
Server version: 5.1.37-community MySQL Community Server (GPL)

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| test               |
| timetracker        |
+--------------------+
4 rows in set (0.00 sec)

mysql> exit;
Bye

C:\>


If you see your database entry in the list of databases then we are okay.

By this point we have created a database for time tracking and defined a user / password combination to access it.

Modifying the DSN Value in config.php to Access the Database

Now, when our database is created, we need to change the DSN value in time tracker config.php file (located in its WEB-INF sub-directory) to reflect the database name and user / password combination we just defined.
define("DSN",'mysql://ttuser:ttpassword@localhost/timetracker');

The above statement defines that time tracker code will access timetracker database as ttuser with ttpassword password.

Populate the Database

To populate the database with schema and initial data point your browser to http://localhost/timetracker/dbinstall.php and click the Create button in DB Install section.

Trying Anuko Time Tracker

Now it's time to test Anuko Time Tracker. Point your browser to http://localhost/timetracker/ and check what you see. If everything is configured correctly you should see a page similar to this:

If you don't see this but instead see a blank page or some error you need to troubleshoot your entire installation and make sure that every required component is configured and works correctly (by actually CHECKING that it works, when you can).

A blank page at this point may mean many things, among others, such as:
You need to thoroughly test each and every component to make sure they work together nicely.

To test Anuko Time Tracker create a new team manager account (there is an option for this in top black menu). Then create a few projects, a few activities, and then try entering time.

Cleanup

Remove the file dbinstall.php (C:\Inetpub\wwwroot\timetracker\dbinstall.php) for security reasons.

Anuko Time Tracker Installation Guide
Hosting and Content Management by Anuko (sponsored by City Photos)