From ’java.sun.com’ go to ’Downloads’.

Download the ’Java JDK’.

CAUTION:

Download the version for Windows. If a "login now" window appears, just close it (it’s optional).

Save the file on the desktop and run it. It will be called something like:

jdk-6u17-windows-i586.exe (about 70 megs)

Install the JDK, with default options.

From the Apache Tomcat website - http://tomcat.apache.org/download-60.cgi - download the Windows Service Installer.

The file should be called something like:

apache-tomcat-6.0.20.exe (about 6 megs)

Run the installer.

It should automatically find the JRE/SDK that you just installed.

When prompted:

At the end of the installation, choose "run now".

To test if it is working, enter the following URLin a local browser:

http://127.0.0.1:8080/

If you see the following page, it is working fine.

1.2.1. Configuring, starting and stopping Tomcat

As Tomcat is installed as a system service, it can be managed - started, stopped, etc. - from the Services page in Windows, or from its control process.

When it’s running, it is shown in the running processes under the icon:

From here, you can configure Tomcat. First thing, set the startup type as "automatic".

You should also set the maximum memory usable by Tomcat and QueueMetrics, under the "java" tab as "maximum memory pool". Start by giving it 256 megs of heap and restart Tomcat.

Go to http://dev.mysql.com/downloads/ and download the current ’Community Edition, GA version’

The file will be called something like:

mysql-5.1.41-win32.msi

http://dev.mysql.com/get/Downloads/MySQL-5.1/mysql-5.1.41-win32.msi/from/http://na.mirror.garr.it/mirrors/MySQL/

Also on the same page, download the Connector/J package; go for the ’Generally Available (GA) release’, under the ZIP format.

The file will be called something like:

mysql-connector-java-5.1.10.zip

http://dev.mysql.com/get/Downloads/Connector-J/mysql-connector-java-5.1.10.zip/from/http://gd.tuwien.ac.at/db/mysql/

Install the MySQL server, "typical" setup.

Click on "Configure MYSQL now" - If it does not run the configuration wizard, run it manually.

Choose "Standard configuration"

Click on " Install as Windows service" - and "Launch automatically".

Click on "Include BIN directory"…

Enter "password" as the root password (twice). Click on "enable remote access"

To test if it is working: after the wizard has run, select ’Start’ / ’Programs’ / ’MySQL’ / ’MySQL server’ / ’MySQL command line client’.

When promted for a password, enter "password".

If it enters the shell, this means MySQL is working. Type "\q" to exit.

Go to http://queuemetrics.com / Downloads and choose the latest QueueMetrics.

The file will look something like:

QueueMetrics-1.5.5-trial.tar.gz

TIP:

Unpack the archives "QueueMetrics" and "MySQL Connector/J".

Under the Connector/J archive, you’ll find a file called ’mysql-connector-java-5.1.10-bin.jar’. Copy it to the QueueMetrics folder, under ’WEB-INF/lib/’.

On your computer, find a folder under:

c:\Program Files\Apache Software Foundation\Tomcat 6.0\webapps

Copy the "queuemetrics-1.5.5" folder under "webapps" and rename it to "queuemetrics".

Copy the file ’WEB-INF/README/queuemetrics-sample.sql’ to the local directory. Open a Command prompt.

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

Type ’help;’ or ’\h’ for help. Type ’\c’ to clear the current input statement.

Run the following command to create a database:

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

Run the following command to create a user that can access that database:

mysql> grant all privileges on queuemetrics.* to ’queuemetrics’@’%’ identified by "javadude";
Query OK, 0 rows affected (0.00 sec)

Exit the MySQL shell with "\q".

Now load the database by running the following command:

C:\>mysql -u queuemetrics -p queuemetrics < queuemetrics_sample.sql
Enter password: ********

(Enter ’javadude’ as the password).

Restart Tomcat (open the control panel, click on "Stop" and then "Start").

Go to http://127.0.0.1:8080/queuemetrics - it may take a few seconds to complete because pages have to be compiled.

Log in as ’demoadmin’ password ’demo’.

Now go to the License page (see the bottom of the main page) to see the status of your installation:

Notice the following items:

# This is the default queue log file.
default.queue_log_file=sql:PF

# Rewrites Local/XXX@ext channels in the format Agent/XXX
default.rewriteLocalChannels=true