Initial Installation

System Requirements

The system should be installed on a Windows Server (2000/2003/2008) with at least 4Gb free disk space and at least 0.5Gb free memory.

Installation Procedure

Please note: These installation notes are draft and should be used as guidelines at this stage.

Install MySQL database. Files used:

• mysql-5.1.39-win32.msi
• mysql-gui-tools-5.0-r17-win32.msi
• mysql-connector-odbc-5.1.5-win32.msi

Note: the latest MySQL Enterprise binaries should be used - download from MySQL as required.

Configure the database as InnoDB, accepting 50+ connections, with no anonymous access.
Ensure that the database and bin areas are installed away from the root drive.

NOTE THE ROOT PASSWORD.

If any other database is installed on the machine, change the default port for connections to 5306.

Install IIS at this stage, if not already installed, from the Add/Remove Windows Components control panel screen (Note: IIS can also be installed as part of the Vision installation package).

Install the Vision package.

• File used: IN090922Vision.zip
• Note: Install the Vision application files away from the root drive.

Change the default port in Connection.asp and Productivity.asp to the port number you chose for database connections when installing MySQL.

Configure IIS:

Settings used:

• Create a new web site, pointing to the virtual directory where you installed the Vision application.
• Change the default document to Productivity.asp
• Set the port for the application (Note: If there are other sites or web servers on the machine, you may need to change this or them away from the standard port 80.)
• Set the permissions on the database so that the default IIS user for the machine has access to the folders.
• Ensure that Web Service Extensions are enabled for Active Server Pages (from the IIS configuration screen, on the left below Default Web Pages).
• Ensure that the pages expire immediately, to force reload (this should happen automatically with server-derived pages, but better safe than sorry).
• For IIS 6.0 or greater, ensure that Parent Paths are enabled, by enabling the flag 'Enable Parent Paths' from the web site's properties/Home Directory/Configuration/Options screen.
• Stop and start the Website created.

Load the database structure through the MySQL Administrator.

• File used:
• {Vision}/Database/CreateDB.sql
• or
• {Vision}/Database/CreateDB-Struct.sql
• {Vision}/Database/CreateDB-Data.sql

These files can also be loaded through the following command:

>mysql.exe --host=127.0.0.1 --user=root --password={password} --default-character-set=utf8 --comments <{SQL file}

Create any users with localhost permissions through the MySQL Administrator.

Create user permissions in the database using MySQL Query Browser.

Check that the system is working using a web browser.