QueueMetrics > MySQL storage and Qloaderd/Uniloader

asterisk/mysql and queuemetrics in different servers

(1/1)

adolfo:
hello

I'm trying to monitorize with queuemetrics my asterisk server. Queuemetrics is installed a remote server (same net).
Asterisk , MySQL and Qloader are running in the same server.
When I access to queuemetrics web interface I recibe this message:
"Errore JDBC:java.sql.SQLException: Server connection failure during transaction. Due to underlying exception: 'java.net.ConnectException: Connection refused'. - Attempted reconnect 3 times. Giving up."

I execute JDBC Connection tester link and show the message:

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:
java.sql.SQLException: Server connection failure during transaction. Due to underlying exception: 'java.net.ConnectException: Connection refused'. Attempted reconnect 3 times. Giving up.

I suppose that's mean the queuemetrics application can't access to the queuemetrics database created in asterisk server.
The permission access is granted at the way described in the installation manual.

I'm sure Qloaderd loads data in queuemetrics database

Somebody Knows how to solve this?
What is the right way to connect queuemetrics server to asterisk/mysql server?
Any help will be accept

My configurations are:

Queuemetrics:
In web.xml file

param-name>JDBC_URL</param-name>
            <param-value>jdbc:mysql://192.168.30.123/queuemetrics?autoReconnect=true&amp;zeroDateTimeBehavior=convertToNull&amp;jdbcCompliantTruncation=false&amp;user=queuemetrics&amp;password=javadude</param-value>
 
In configuration.propierties file:
default.queue_log_file=sql:P01
.....
cluster.trix.manager=tcp:admin:amp111@192.168.30.123
cluster.trix.queuelog=sql:P01
cluster.trix.monitored_calls=z:/qm_streamcall/server_trix
cluster.trix.callfilesdir=
cluster.trix.audioRpcServer=
cluster.trix.agentSecurityKey=
----------------------------------------------
Qloaderd config:
qloader=/usr/local/qloaderd-1.11/qloader.pl
partition=P01
queuelog=/var/log/asterisk/queue_log
logfile=/var/log/asterisk/qloader.log
-------------------------------------------------------
Qloader.pl
my $mysql_host = $options{h} || "127.0.0.1";
my $mysql_db   = $options{d} || "queuemetrics";
my $mysql_user = $options{u} || "queuemetrics";
my $mysql_pass = $options{p} || "javadude";

THANKS IN ADVANCE

QueueMetrics:
Connection refused makes me think that MySQL is not answering on port 3306 and/or there is some firewall or binding rule taht prevents it to do so. Otherwise it would print something to state that your user was incotrrect.

adolfo:
thank you.
I am going to check what you says.

adolfo:
OK , solved.

The problem was a incorrect  bind address in  my.cnf mysql's file.
Now Qmetrics is working fine.

Best Regads

QueueMetrics:
That's fine.  ;D

Navigation

[0] Message Index