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.


Messages - adolfo

Pages: [1]
1
Outbound and QueueMetrics / Re: EXPERIMENTAL: replace the queueDial.agi with a pure-scripting solution
« on: August 05, 2008, 13:32:28 »
Hello

I have not too much experience in asterisk + queuemetrics

In what file is necessary include this portion of code?

extensions_custom.conf???

There is necessary another configuration in other file????

Thanks in advance

2
MySQL storage and Qloaderd/Uniloader / Re: asterisk/mysql and queuemetrics in different servers
« on: June 26, 2008, 17:06:47 »
OK , solved.

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

Best Regads

3
MySQL storage and Qloaderd/Uniloader / Re: asterisk/mysql and queuemetrics in different servers
« on: June 24, 2008, 14:17:06 »
thank you.
I am going to check what you says.

4
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

5
MySQL storage and Qloaderd/Uniloader / Re: Qmetrics don't load data from SQL???
« on: October 08, 2007, 13:44:26 »
one more issue.

after rotate queue_log asterisk log file, is necessary to make a 'logger reload' in the asterisk console and restart qloaderd.

If I dont do this, I experiment the same situation I expose in the beginning of post, Qloaderd no load new entries in database.




6
MySQL storage and Qloaderd/Uniloader / Re: Qmetrics don't load data from SQL???
« on: October 03, 2007, 17:15:34 »

I know what happened. The system configuration log rotate for asterisk logs runs weekly.
When it runs, queue_log has any entries. And logically, queuemetrics shows nothing
When I select MySQL database partition(SQL:P001) in the custom report and all historical data is loaded.
This is possible edit the /usr/local/tomcat/webapps/queuemetrics-1.4.2/WEB-INF/configuration.properties
and insert default.queue_log_file=SQL:P01. I was running with the default configuration, /var/log/asterisk/queue_log

Now after restart  the qloaderd script , all new data calls is featuring in the graphips plus the historical.
A little big error.

Anyway thanks for support

7
MySQL storage and Qloaderd/Uniloader / Re: Qmetrics don't load data from SQL???
« on: October 02, 2007, 11:41:10 »
i do it. I restart qloaderd service. Data is loading in mysql database. There is new entries. But same result.

Queuemetrics don't shows reports of calls received.

Somebody can help me? some idea?

Thanks

8
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.






9
MySQL storage and Qloaderd/Uniloader / Re: What mean partition in qloader
« on: July 27, 2007, 08:43:59 »
OK, I understand.

Thank you  for your help.

10
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]