Installing Anuko Time Tracker on Windows 7 with Apache

Note: this section covers installation and configuration issues of Anuko Time Tracker on Windows 7 with Apache 2.2.14, PHP 5.2.12, and MySQL 5.1.37. If you'd like us to include a similar detailed description for another configuration, not yet covered in Anuko Time Tracker Installation Guide you can do so by buying a support incident.

Install and Configure Apache

• Make sure that you don't run any other web server on your host. Particularly check that Internet Information Services (IIS) is not installed or at least not running on your host: Start / Control Panel / Programs / Turn Windows features on or off / Internet Information Services.

• Download Apache HTTP Server from http://httpd.apache.org/download.cgi . Choose Win32 Binary including OpenSSL 0.x.x (MSI Installer). E.g. apache_2.2.14-win32-x86-openssl-0.9.8k.msi
• Run Apache HTTP Server installer.

Choose Typical setup type.

Server will be installed to C:\Program Files\Apache Software Foundation\Apache2.2\ by default.

Once Installation is complete, verify the installation by clicking on the Apache Icon in the taskbar. You can also verify your installation of Apache by opening http://localhost/ in your browser.

• Stop Apache. Open C:\Program Files\Apache Software Foundation\Apache2.2\conf\httpd.conf with Notepad. Find section <Directory “C:\Program Files\Apache Software Foundation\Apache2.2\htdocs”> and replace Options and AllowOverride directives in it from:

<Directory "C:/Program Files/Apache Software Foundation/Apache2.2/htdocs">
    Options Indexes FollowSymLinks
    AllowOverride None
</Directory>

to:

<Directory "C:/Program Files/Apache Software Foundation/Apache2.2/htdocs">
    Options None
    AllowOverride All
</Directory>

Find section <IfModule dir_module> and replace DirectoryIndex index.html with DirectoryIndex index.php index.html so that it becomes:

<IfModule dir_module>
    DirectoryIndex index.html index.php
</IfModule>

Start Apache.

Install and Configure PHP

• Download PHP 5.2.x installer from http://www.php.net/downloads.php Windows Binaries section. E.g. php-5.2.12-win32-installer.msi.
• Run PHP installer. Leave default Destination Folder.

Choose Apache 2.2.x module:



Choose Items to Install:

Extensions / bzip2
Extensions / Curl
Extensions / GD2
Extensions / Gettext
Extensions / LDAP
Extensions / Multi-Byte String
Extensions / MySQL
Extensions / MySQLi
Extensions / OpenSSL
Extensions / PDO / MySQL
Extensions / Shared Memory
Extensions / SOAP
Extensions / Sockets
Extensions / zip

• Restart Apache HTTP Server (with Apache monitor in system tray).
• To check that PHP works create file C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\php.php with Notepad:

Then open http://localhost/php.php with your browser. You should see something like the following:

Install and Configure MySQL

• Download MySQL 5.1 Community Edition server from http://dev.mysql.com/downloads/mysql/5.1.html#win32 . Choose Windows Essentials 5.1.x for your platform. E.g. mysql-essential-5.1.42-win32.msi
• Install MySQL using Typical Setup Type.

Choose Configure the MySQL server now when Setup Wizard has been completed.



Choose Standard Configuration in MySQL Server Instance Configuration Wizard.



Choose password for root database user. MySQL Server Instance Configuration will be finished with the following screen:

Installing and Configuring Anuko Time Tracker

Now we have everything ready to install and configure Anuko Time Tracker. Here are the installation steps:

Deploying Anuko Time Tracker Source Code

• Remove timetracker directory and all test files inside it (C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\timetracker\).
• Download Anuko Time Tracker distribution archive. Current download path is http://www.anuko.com/downloads/time_tracker/anuko_time_tracker.zip If a particular not-current version is required you can try getting http://www.anuko.com/downloads/time_tracker/archive/wrtimetracker_v0.8.zip
• Extract the archive into C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\. The extraction procedure will create the timetracker directory inside htdocs.

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:\>

• Check if the database was actually created by using the "show databases;" sql statement in MySQL console:

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.

• Edit the C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\timetracker\WEB-INF\config.php file. Change the DSN value to provide proper database name, user name, and password to access it. For example:

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:

• MySQL extension for PHP not installed or not working.
• mbstring extension for PHP not installed.
• Time tracker database not created.
• Access (login / password) to the database is not configured properly in config.php.
• MySQL service is down.

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:\Program Files\Apache Software Foundation\Apache2.2\htdocs\timetracker\dbinstall.php) for security reasons.

Anuko Time Tracker Installation Guide