Topics

1

QueueMetrics installation / Installation on Debian failing

« on: August 17, 2009, 13:29:37 »

I am trying to install on a debian system but failing can anyone point me in the right direction??

I have a debian box running
Linux pinky 2.6.18 #1 SMP Fri Nov 23 16:23:22 GMT 2007 i686 GNU/Linux

I have installed Java and believe it is running correctly
pinky:/usr/share/mysql-connector-java-5.1.8# java -version
java version "1.5.0_20"
Java(TM) 2 Runtime Environment, Standard Edition (build 1.5.0_20-b02)
Java HotSpot(TM) Server VM (build 1.5.0_20-b02, mixed mode)
pinky:/usr/share/mysql-connector-java-5.1.8#

I have a working MySql database being used for other projects
mysqladmin  Ver 8.41 Distrib 5.0.32, for pc-linux-gnu on i486
Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license

Server version          5.0.32-Debian_7etch6-log
Protocol version        10
Connection              Localhost via UNIX socket
UNIX socket             /var/run/mysqld/mysqld.sock
Uptime:                 9 days 20 hours 32 min 10 sec

and I can log on with the default Queuemetrics username and password
pinky:/usr/share/mysql-connector-java-5.1.8# mysql queuemetrics -uqueuemetrics -pjavadude
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 26703
Server version: 5.0.32-Debian_7etch6-log Debian etch distribution

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

mysql>

I have followed the instructions to the letter but all I get from dbtest is :-

It looks like you don't have a working JDBC connection.
QueueMetrics requires a working JDBC connection to a MySQL database in order to work properly.
If you have not already done so:

Download the MySQL database driver and put it in WEB-INF/lib with the other JAR files. Restart the servlet container.
Create a database for QueueMetrics and import the sample database you'll find in WEB-INF/README
Edit the file WEB-INF/web.xml to enter the database server, user and password QueueMetrics will use to connect
These steps are explained in greater detail in QueueMetrics user manual, available at http://queuemetrics.com/manual.jsp.

This is the current configuration found:

XML configuration file located at: /usr/share/tomcat5.5/webapps/queuemetrics/WEB-INF/web.xml
JDBC URI configured as: jdbc:mysql://localhost/queuemetrics?autoReconnect=true&zeroDateTimeBehavior=convertToNull&jdbcCompliantTruncation=false&user=queuemetrics&password=javadude
Most common JDBC errors are explained in the FAQs, available at http://queuemetrics.com/faq.jsp.


Any ideas??

Mike