Messages

1

MySQL storage and Qloaderd/Uniloader / Re: Error with queue_log query

« on: December 29, 2011, 15:19:34 »

I'm on asterisk 1.8

2

MySQL storage and Qloaderd/Uniloader / Error with queue_log query

« on: December 29, 2011, 15:19:03 »

i have a table queue_log on my asterik

and configure queuemetrics like this :

default.queue_log_file=astr:asterisk|3

sqlPreset.3.table=asterisk.queue_log_processed
sqlPreset.3.f_time_id=real_timestamp
sqlPreset.3.f_call_id=callid
sqlPreset.3.f_queue=queuename
sqlPreset.3.f_agent=agent
sqlPreset.3.f_verb=event
sqlPreset.3.f_partition=
sqlPreset.3.f_data1=data1
sqlPreset.3.f_data2=data2
sqlPreset.3.f_data3=data3
sqlPreset.3.f_data4=data4
sqlPreset.3.f_data5=data5
sqlPreset.3.f_incr=id


I create view like this to had timestamp :

CREATE VIEW queue_log_processed AS SELECT UNIX_TIMESTAMP(TIME) AS real_timestamp, callid
AS call_id, queuename AS queuename, agent AS agent, event AS event, data1,
data2, data3, data4, data5, id AS id FROM asterisk.queue_log


but when i try access to data i got :

Database access error.  -  <p> - Exception: it.loway.tpf.common.exceptions.TechException - Errore file/DB: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.queue_log WHERE        (time >= '1325113200' AND time<='1325167816')     AND qu' at line 1 - at it.loway.app.queuemetrics.asterisk.logs.analyzers.AnalizzaLogAstRT.createTemporaryFile(AnalizzaLogAstRT.java:277) - at it.loway.app.queuemetrics.asterisk.logs.analyzers.AnalizzaLogAstRT.loadLogInfo(AnalizzaLogAstRT.java:171) - at it.loway.app.queuemetrics.caricamento.caricaCoda.runDataAnalysis(caricaCoda.java:281) - at it.loway.app.queuemetrics.caricamento.caricaCoda.doRun(caricaCoda.java:70) -

3

QueueMetrics installation / No data retrieve

« on: October 05, 2009, 16:59:13 »

I install queuemetrics with demo licence and qloader

in qloader.log i see :

Code: [Select]

|Mon Oct  5 13:43:26 2009|Loaded 100 lines so far...
 |Mon Oct  5 13:43:26 2009|Loaded 200 lines so far...
 |Mon Oct  5 13:43:26 2009|Loaded 300 lines so far...
 |Mon Oct  5 13:43:26 2009|Loaded 400 lines so far...
 |Mon Oct  5 13:43:26 2009|Loaded 500 lines so far...
 |Mon Oct  5 13:43:26 2009|Loaded 600 lines so far...
 |Mon Oct  5 13:43:26 2009|Loaded 700 lines so far...
 |Mon Oct  5 13:43:26 2009|Loaded 800 lines so far...
 |Mon Oct  5 13:43:26 2009|Loaded 900 lines so far...
 |Mon Oct  5 13:43:26 2009|Loaded 1000 lines so far...
 |Mon Oct  5 13:43:26 2009|Loaded 1100 lines so far...
 |Mon Oct  5 13:43:26 2009|Loaded 1200 lines so far...
 |Mon Oct  5 13:43:26 2009|Loaded 1300 lines so far...
 |Mon Oct  5 13:44:14 2009|QueueMetrics MySQL loader - $Revision: 1.17 $
 |Mon Oct  5 13:44:14 2009|Partition P001 - PID 19344 - TZ offset: 0 s. - Heartbeat after 900 s.
 |Mon Oct  5 13:44:14 2009|Now connecting to DB queuemetrics on localhost as user queuemetrics with password javadude
 |Mon Oct  5 13:44:14 2009|Ignoring all timestamps below 1254743026
 |Mon Oct  5 13:44:14 2009|Skipped 100 lines so far...
 |Mon Oct  5 13:44:14 2009|Skipped 200 lines so far...
 |Mon Oct  5 13:44:14 2009|Skipped 300 lines so far...
 |Mon Oct  5 13:44:14 2009|Skipped 400 lines so far...
 |Mon Oct  5 13:44:14 2009|Skipped 500 lines so far...
 |Mon Oct  5 13:44:14 2009|Skipped 600 lines so far...
 |Mon Oct  5 13:44:14 2009|Skipped 700 lines so far...
 |Mon Oct  5 13:44:14 2009|Skipped 800 lines so far...
 |Mon Oct  5 13:44:14 2009|Skipped 900 lines so far...
 |Mon Oct  5 13:44:14 2009|Skipped 1000 lines so far...
 |Mon Oct  5 13:44:14 2009|Skipped 1100 lines so far...
 |Mon Oct  5 13:44:14 2009|Skipped 1200 lines so far...
 |Mon Oct  5 13:44:14 2009|Skipped 1300 lines so far...
 |Mon Oct  5 13:54:37 2009|Loaded 100 lines so far...

so i think qloader works.

But when I come on 127.0.0.1:8080/queuemetrics

i enter

demouser and demo for password

but after that , my own queue don't appears in select

Can you help me plz

4

QueueMetrics installation / Re: Table 'queuemetrics.arch_classes' doesn't exist

« on: October 05, 2009, 16:55:26 »

OK all works

exept i don't see my queue and agent in interface

i only see DSP and Test queues

5

QueueMetrics installation / Re: Table 'queuemetrics.arch_classes' doesn't exist

« on: October 05, 2009, 12:20:34 »

I solve my issue by executing database_sample.sql but i have another one :

I don't understand how queuemetrics and asterisk are linked. because in queueMetrics I don't have my asterisk queue.

and no information in stat

6

QueueMetrics installation / Re: Table 'queuemetrics.arch_classes' doesn't exist

« on: October 05, 2009, 12:05:49 »

I run installDb.sh

and now i have :

Java Error: Errore DB: java.sql.SQLException: Unknown column 'lic_version' in 'field list' The required database table 'dbversion' is missing some fields. Are you updating from a previous version of QM?

7

QueueMetrics installation / Table 'queuemetrics.arch_classes' doesn't exist

« on: October 05, 2009, 11:59:02 »

Hi,

I try to install queuemetrics on Centos with asterisk 1.6

I had install queuemetrics like that :

yum install queuemetrics.

But when i run :

http://192.168.1.5:8080/queuemetrics/

All is OK exept :

Checking if exists database table: 'arch_classes'     Error     Java Error: Problema DB: java.sql.SQLException: Table 'queuemetrics.arch_classes' doesn't exist The required database table 'arch_classes' is missing or unreadable.


How can i solve it ?