Author Topic: jdm - SQL connection problems  (Read 4010 times)

pldt

  • Newbie
  • *
  • Posts: 1
  • Karma: 0
    • View Profile
    • Email
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... )
...

QueueMetrics

  • Loway
  • Hero Member
  • *
  • Posts: 2999
  • Karma: 39
    • View Profile
    • QueueMetrics
Re: jdm - SQL connection problems
« Reply #1 on: June 20, 2008, 09:13:07 »
"Could not create..." makes me think of a connection error. Are you sure MySQL is doing a bind on the correct address/port?