Topic: Installing on Windows 2008 Server
I was installing tracmor onto a fresh Windows 2008 box and found the installation instructions to be incomplete and the required resources to be unclear. The following are all of the steps I took to install tracmor including setting up the database on a different drive, installing the required IIS features and other required software. I hope someone else finds this information helpful.
Install the following:
.NET 4.0 - http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=22
C++ 2008 - http://www.microsoft.com/download/en/confirmation.aspx?id=29
mySQL - MySQL Server only - http://dev.mysql.com/downloads/installer/
tracmor - http://code.google.com/p/tracmor/downloads/list extract to F:\wwwroot
Install IIS
Server Manager -> Roles -> Add Role -> Web Server (IIS)
Include the following Role Services from Application Development: CGI, ISAPI Extensions, ASP.NET
Install PHP
http://windows.php.net/downloads
Install to C:/PHP/
During setup select the option to run as server - IIS FastCGI
IIS Manager setup
Select Sites -> Add Web site (under Actions)
Site name: tracmor
Physical Path: F:\wwwroot
Select Handler Mappings from tracmor Home -> Add Managed Handler (under Actions)
Requested path - *.php
Executable - C:\php\php5nsapi.dll
Name: PHP
Edit Configuration files
Set the following value in C:\ProgramData\MySQL\MySQL Server 5.5\ my.ini
datadir = "F:\SQLdata\"
Restart mySQL service
Fill the following values in F:\wwwroot\includes\configuration.in.php
Fill SQL login information to DB_CONNECTION_1 user = {tracmor user}, password ={password}
change _DOCROOT_ value to F:\wwwroot
Edit F:\wwwroot\data_model\create.sql
change all 'TYPE =' to 'ENGINE =' and 'TYPE=' to 'ENGINE ='
MySQL Database Initialization
Run MySQL Command Line Client and execute the following commands:
CREATE DATABASE tracmor;
CREATE USER '{tracmor user}'@'localhost' identified by '{password}’;
GRANT ALL ON tracmor.* to '{tracmor user}'@'localhost';
USE tracmor
SOURCE F:/wwwroot/data_model/create.sql
SOURCE F:/wwwroot/data_model/data.sql