Messages

2071

MySQL storage and Qloaderd/Uniloader / Re: QM on Windows 2003

« on: March 05, 2009, 09:30:40 »

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: [Select]

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

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.

2072

Running QueueMetrics / Re: asking for licences but I'm alone in the system

« on: March 04, 2009, 16:50:06 »

Very likely you have used more than 2 different telephones or agents, so QM sees them and thinks they are different people.

Feel free to send your queue_log file to the tech support, so they will tell you which telephones have been in use.

QM is free up to two agents.

2073

Outbound and QueueMetrics / Re: Problem in outbound queue

« on: March 04, 2009, 16:48:22 »

I would try the following tests:

Code: [Select]

...
exten => 3139000,n,setvar(clid=${CALLERID(NUMBER)})
exten => 3139000,n,setvar(agenteis=${AGENTBYCALLERID_${clid}})
exten => 3139000,n,noop(clid: ${clid} agent: ${agenteis})
...

also please run a SHOW AGENTS before running the command.

A lot of thing have been chenged in 1.2 to 1.4 in the dialplan vars etc....

2074

MySQL storage and Qloaderd/Uniloader / Re: QM on Windows 2003

« on: March 04, 2009, 16:42:37 »

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

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?

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

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.

2075

Running QueueMetrics / Re: Filtering on call length

« on: March 04, 2009, 09:45:20 »

Not at the moment (unless you do post-filtering via XML-RPC) but we plan tio have this in the next major version.

FYI, we track this new feature as bug #630.

2076

Outbound and QueueMetrics / Re: outboun calls

« on: March 04, 2009, 09:44:35 »

 

2077

Outbound and QueueMetrics / Re: Problem in outbound queue

« on: March 04, 2009, 09:44:14 »

1. make sure the system is idle (e.g at night)
2. connect to the Asterisk cli via "asterisk -vvvvvvvvvr"
3. run the QM transaction
4. copy the printout of what happended in Asterisk

2078

Scripting QueueMetrics / Re: java equivalent of python example

« on: March 04, 2009, 09:42:59 »

I think this depends on the java library used - anyway I see that you should be able to cast it to an ArrayList if you want to, as it is actually an extended ArrayList - see http://xmlrpc.sourceforge.net/javadoc/redstone/xmlrpc/XmlRpcArray.html

2079

Outbound and QueueMetrics / Re: Problem in outbound queue

« on: March 03, 2009, 15:32:18 »

I think that Set and Setvar should be used based on the *n version.

2080

Outbound and QueueMetrics / Re: outboun calls

« on: March 03, 2009, 15:31:28 »

The "caller" will be the destinatio  number, and "emel romo" the originating party.

2081

QueueMetrics installation / Re: Migrated Trixboxes now I'm having MAJOR issues

« on: March 03, 2009, 15:28:55 »

Can you post a screenshot?

2082

Running QueueMetrics / Re: one report for inbound and outbound queue

« on: March 02, 2009, 15:24:57 »

If you see them all, just create an aggregate queue, like "myInbound|myOutbound" so you can see them at once.
Note tham a number of stats (particularly SLAs) are meaningless if run in mixed inbound/outbound mode.

2083

Running QueueMetrics / Re: users for visitors only for some reports

« on: March 02, 2009, 15:24:01 »

Any user must have the key USER as well as any security keys to enable a given set of activities.

2084

Outbound and QueueMetrics / Re: outboun calls

« on: March 02, 2009, 10:55:24 »

The call looks correct, but it's not a lost one, as it was answered.

2085

Running QueueMetrics / Re: Accessing specific reports without entering username/password

« on: March 02, 2009, 10:54:06 »

#1. You tell your users to login as "guest" password "guest", and create a limited user "guest" on your QM instance. As you can change the text on the
QM homepage, they would simply know what's going on.

#2. You create an auto-post form that will simulate a user logfgin in in QM by acting as-if the home page when you enter credentials.