Author Topic: I have a big problem with mysql database  (Read 3078 times)

wusanchez

  • Newbie
  • *
  • Posts: 9
  • Karma: 0
    • View Profile
    • Email
I have a big problem with mysql database
« on: December 12, 2011, 18:24:32 »
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

  • Loway
  • Newbie
  • *
  • Posts: 25
  • Karma: 31
    • View Profile
    • QueueMetrics
Re: I have a big problem with mysql database
« Reply #1 on: December 14, 2011, 10:56:01 »
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.