QueueMetrics > MySQL storage and Qloaderd/Uniloader

QM on Windows 2003

(1/2) > >>

jucha:
I have QM1.5 on windows 2003 with MySQL and tomcat.
Open http://myhostqm:8081/QM works good with MySQL, BUT

1..
 qLoader no works with /etc/init.d/qloaderd start
This load data on local Mysql
But
/usr/local/qloader/qloader.pl /var/log/asterisk/queue_log P001 /var/log/asterisk/qloader.log load data to my remote myhostqm

my $mysql_host = $options{h} || "myhostqmip";
my $mysql_db   = $options{d} || "queuemetrics";
my $mysql_user = $options{u} || "queuemetrics";
my $mysql_pass = $options{p} || "javadude";

What is the mistake.!!!!!

2..
Asterisk wizard do no connect to Asterisk. I tried with telnet ipasterisk 5038 and login with admin:amp111, and works fine from myhostqm.
The properties file is:
callfile.dir=tcp:admin:amp111@ipasterisk

cluster.servers=aleph
cluster.aleph.manager=tcp:admin:amp111@ipasterisk

this a short java log.
[4426D1D613905F3747D44D7D0D43C40B] Tempo totale esecuzione verbo 'qm_start': 31 ms
[4426D1D613905F3747D44D7D0D43C40B] Tempo totale esecuzione verbo 'qm_start2': 62 ms
Errore: java.io.FileNotFoundException: \etc\asterisk\agents.conf (El sistema no puede hallar la ruta especificada) nella lettura di un file
Errore: java.io.FileNotFoundException: \etc\asterisk\queues.conf (El sistema no puede hallar la ruta especificada) nella lettura di un file
[4426D1D613905F3747D44D7D0D43C40B] Tempo totale esecuzione verbo 'qm_setupWizard': 31 ms
Errore: java.io.FileNotFoundException: \etc\asterisk\agents.conf (El sistema no puede hallar la ruta especificada) nella lettura di un file
Errore: java.io.FileNotFoundException: \etc\asterisk\queues.conf (El sistema no puede hallar la ruta especificada) nella lettura di un file
[4426D1D613905F3747D44D7D0D43C40B] Tempo totale esecuzione verbo 'qm_setupWizard': 32 ms

What is the mistake.!!!!!

QueueMetrics:

--- Quote from: jucha on March 04, 2009, 16:24:53 ---I have QM1.5 on windows 2003 with MySQL and tomcat.

1..
 qLoader no works with /etc/init.d/qloaderd start
This load data on local Mysql
But
/usr/local/qloader/qloader.pl /var/log/asterisk/queue_log P001 /var/log/asterisk/qloader.log load data to my remote myhostqm

my $mysql_host = $options{h} || "myhostqmip";
my $mysql_db   = $options{d} || "queuemetrics";
my $mysql_user = $options{u} || "queuemetrics";
my $mysql_pass = $options{p} || "javadude";

What is the mistake.!!!!!

--- End quote ---

I guess you are running Asterisk on linux, correct? You should look at the error log that qloaderd produces on /var/log/asterisk/qloaderd.txt and see wat is wrong. Is MySQL on the Win32 box or n the Linux box?




--- Quote from: jucha on March 04, 2009, 16:24:53 ---2..
Asterisk wizard do no connect to Asterisk. I tried with telnet ipasterisk 5038 and login with admin:amp111, and works fine from myhostqm.
The properties file is:
callfile.dir=tcp:admin:amp111@ipasterisk

cluster.servers=aleph
cluster.aleph.manager=tcp:admin:amp111@ipasterisk

this a short java log.
[4426D1D613905F3747D44D7D0D43C40B] Tempo totale esecuzione verbo 'qm_start': 31 ms
[4426D1D613905F3747D44D7D0D43C40B] Tempo totale esecuzione verbo 'qm_start2': 62 ms
Errore: java.io.FileNotFoundException: \etc\asterisk\agents.conf (El sistema no puede hallar la ruta especificada) nella lettura di un file
Errore: java.io.FileNotFoundException: \etc\asterisk\queues.conf (El sistema no puede hallar la ruta especificada) nella lettura di un file
[4426D1D613905F3747D44D7D0D43C40B] Tempo totale esecuzione verbo 'qm_setupWizard': 31 ms
Errore: java.io.FileNotFoundException: \etc\asterisk\agents.conf (El sistema no puede hallar la ruta especificada) nella lettura di un file
Errore: java.io.FileNotFoundException: \etc\asterisk\queues.conf (El sistema no puede hallar la ruta especificada) nella lettura di un file
[4426D1D613905F3747D44D7D0D43C40B] Tempo totale esecuzione verbo 'qm_setupWizard': 32 ms

What is the mistake.!!!!!


--- End quote ---

The files must be local files for autoconfig to work. We plan to have files fetched remotely, but this is not so at the moment. So just copy agents.conf and queues.conf from the Asterisk box to a local directory, or mount /etc/asterisk from the Linux box.

jucha:
Yes. Asterisk on Centos 5.1 and MySql on Windows.
tail -f /var/log/asterisk/qloaderd.log and tail -f /var/log/asterisk/qloaderdlog
does not produces any error.
Display records uploaded on mysql local or remote.
My questions is: qLoader no works with /etc/init.d/qloaderd start
This load data on local Mysql
But
/usr/local/qloader/qloader.pl /var/log/asterisk/queue_log P001 /var/log/asterisk/qloader.log load data to my remote myhostqm.

Next
agents.conf and queues.conf in c:\ ?
But asterisk -rx"Show manager connected" no display javaclient conected. How i do to agents uses the login page, if remote QM do not connect to asterisk manager?

QueueMetrics:
1. you have to change the qloaderd settings on the Asterisk box.

You need to create a configuration file under /etc/sysconfig/qloaderd that will look like the following one:


--- Code: ---PARTITION=P001
QUEUELOG=/var/log/asterisk/queue_log
LOGFILE=/var/log/asterisk/qloaderd.log

LOCKFILE=/var/lock/subsys/qloaderd
PIDFILE=/var/run/qloaderd.pid

MYSQLHOST=myQMserver
MYSQLDB=queuemetrics
MYSQLUSER=queuemetrics
MYSQLPASS=javadude

--- End code ---

You usually only need to modify the PARTITION and maybe QUEUELOG entries.


2. It requires no manager connection, it's just trying to read the files locally. So you can either copy them or share them from the Linux box.

jucha:
Thank you.
First point: ok.

Second point.
But manager connection is requiered for agents loging!! That´s raight?

Navigation

[0] Message Index

[#] Next page