Messages

1

QueueMetrics installation / jdm - SQL connection problems

« on: June 19, 2008, 09:59:04 »

Hi,
I' ve a slackware 12.1 distro / asterisk 1.4 / mysql 5 / jdm 1.6.6 / mysql-connector-java-5.1.6-bin.jar
when i make http://localhost:8080/queuemetrics/dbtest/  i occurred this error on 4 step:
---
Connecting to the database   Error
Problem encountered:
Please set the correct server address, database name, user name and password to access the MySQL database.
To do so, edit the JDBC_URL property of WEB-INF/web.xml

Java Error:
com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
----
My jdburl in web.xml is
<param-value>jdbc:mysql://localhost/queuemetrics?autoReconnect=true&amp;zeroDateTimeBehavior=convertToNull&amp;jdbcCompliantTruncation=false&amp;user=queuemetrics&amp;password=javadude</param-value>

I've grant all privileges to database "queuemetrics" on MySql for user  'queuemetrics'@'localhost'

Help me!!!!!
Do u have any ideas....

Thank you too.... (i'm italian, if u want write in italian language... )
...