Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.


Topics - adolfo

Pages: [1]
1
MySQL storage and Qloaderd/Uniloader / asterisk/mysql and queuemetrics in different servers
« on: June 23, 2008, 14:50:56 »
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

2
MySQL storage and Qloaderd/Uniloader / Qmetrics don't load data from SQL???
« on: October 01, 2007, 16:29:36 »
Hello
I'm testing a demo of queuemetrics 1.4.2 version
I have a problem with qmetrics and Mysql storage.
My db called queuemetrics contains data loaded from asterisk logs. Ok , it's correct
About one week, Queuemetrics shown the data of my database in his web interface, making graphics and working fine updating all call entries received.

But today, when we arrive the office, the queuemetrics web interface, shows nothing,  but the Mysql database exists and it is full with our queue data.

No calls data in the graphics on web interface.
The connection database is ok: db=queuemetrics, pass=javadude, etc.....
Tomcat is running. I restart it without sucess
The SQL Connector used is mysql-connector-java-3.0.17
I run the JDBC connection tester and all it's ok
Sql database contains old entries. For example, I select data from queue_log and shows :

................
| P000                 | 1190718768 | 1190718754.713 | 1001  | Local/110@from-internal-5766,1 | CONNECT             | 7                                            |            |               |       |          |                1 |
| P000                 | 1190719074 | 1190719067.725 | 1000  | NONE                           | ENTERQUEUE          |                                              | 0912021500 |               |       |          |                1 |
| P000                 | 1190719076 | 1190719067.725 | 1000  | Local/101@from-internal-d5be,1 | CONNECT             | 2                                            |            |               |       |          |                1 |
| P000                 | 1190719185 | 1190718754.713 | 1001  | Local/110@from-internal-5766,1 | COMPLETECALLER      | 7                                            | 417        |               |       |          |                1 |
| P000                 | 1190719287 | 1190719067.725 | 1000  | Local/101@from-internal-d5be,1 | COMPLETECALLER      | 2                                            | 211        |               |       |          |                1 |
| P000                 | 1190720391 | 1190720383.756 | 1000  | NONE                           | ENTERQUEUE          |                                              | 699317721  |               |       |          |                1 |
| P000                 | 1190720393 | 1190720383.756 | 1000  | Local/101@from-internal-3754,1 | CONNECT             | 2                                            |            |               |       |          |                1 |
| P000                 | 1190720442 | 1190720383.756 | 1000  | Local/101@from-internal-3754,1 | COMPLETECALLER      | 2                                            | 49         |               |       |          |                1 |
| P000                 | 1190721472 | NONE           | NONE  | NONE                           | HEARTBEAT           |                                              |            |               |       |          |                1 |
+----------------------+------------+----------------+-------+--------------------------------+---------------------+--                                       -----+------------+---------------+-------+----------+------------------+
435 rows in set (0.00 sec)

I repeat: all seems works ok about one week. But today queuemetrics shows nothing.
What' s happen? Somebody have an idea about it?

Thanks in advance



PD: excuse me for my bad english.






3
MySQL storage and Qloaderd/Uniloader / What mean partition in qloader
« on: July 26, 2007, 14:55:08 »
hello

I'm implement queuemetrics with asterisk on debian lenny. By the moment, all seems to work fine.

I have a question.
I read in qloader manual the sintaxis ".qloader.pl /var/log/asterisk/queue_log  P001 /var/log/asterisk/qloader.log" to execute the script. OK , data in logs appears in database. But I'm not sure if really I'm doing the instructions correctly. P001 is about partition.
My question is:

What partition is?
What is the meaning of "partition"?
Witch value should be in the partition fileld?

Thanks in advance

Adolfo


Pages: [1]