QueueMetrics > MySQL storage and Qloaderd/Uniloader

I have a big problem with mysql database

(1/1)

wusanchez:
i have the next configuration in queuemetrics
default.queue_log_file=astr:asterisk|3

but in the all data has the asterisk, in tables queue_log, can i see the partition field.

the databases "queuemetrics" has the following  table "queue_log" with this fields:
mysql> desc queue_log;
+------------------+------------------+------+-----+---------+----------------+
| Field            | Type             | Null | Key | Default | Extra          |
+------------------+------------------+------+-----+---------+----------------+
| partition        | varchar(20)      | NO   | MUL |         |                |
| time_id          | int(11) unsigned | NO   |     | 0       |                |
| call_id          | varchar(200)     | NO   |     | NULL    |                |
| queue            | varchar(50)      | NO   |     | NULL    |                |
| agent            | varchar(30)      | NO   |     |         |                |
| verb             | varchar(30)      | NO   | MUL |         |                |
| data1            | varchar(200)     | YES  |     | NULL    |                |
| data2            | varchar(200)     | NO   |     | NULL    |                |
| data3            | varchar(200)     | NO   |     | NULL    |                |
| data4            | varchar(200)     | NO   |     | NULL    |                |
| data5            | varchar(200)     | NO   |     |         |                |
| serverid         | varchar(10)      | NO   |     |         |                |
| unique_row_count | int(10) unsigned | NO   |     | NULL    | auto_increment |
+------------------+------------------+------+-----+---------+----------------+
13 rows in set (0.00 sec)

and in the Asterisk databases has the "queue_log" table with this fields:
mysql> desc queue_log;
+-----------+------------------+------+-----+---------+----------------+
| Field     | Type             | Null | Key | Default | Extra          |
+-----------+------------------+------+-----+---------+----------------+
| id        | int(10) unsigned | NO   | PRI | NULL    | auto_increment |
| time      | int(10) unsigned | YES  |     | NULL    |                |
| callid    | varchar(128)     | NO   |     |         |                |
| queuename | varchar(32)      | NO   |     |         |                |
| agent     | varchar(32)      | NO   |     |         |                |
| event     | varchar(32)      | NO   |     |         |                |
| data      | varchar(255)     | NO   |     |         |                |
+-----------+------------------+------+-----+---------+----------------+
7 rows in set (0.00 sec)

Anthony:
Hi,

given your current setup, all is correct and according to standards.
Your setup is that data that is used by QueueMetrics is obtained from the Asterisk realtime queue log, and not from the queue_log table in the QueueMetrics database.
The Asterisk table does not see any partition, because the partition is specific to QueueMetrics.

Navigation

[0] Message Index