[asterisk-users] Dynamic realtime + queues

[Jose Flores Galicia]

2013/4/18 Tommy Cooper <tomcooper83 at yahoo.com>:
>
>
> Thanks again for replying, I got a wireshark capture with that command you
> provided. Please find attached the wireshark capture
>
> ----- Forwarded Message -----
> From: Leandro Dardini <ldardini at gmail.com>
> To: Tommy Cooper <tomcooper83 at yahoo.com>; Asterisk Users Mailing List -
> Non-Commercial Discussion <asterisk-users at lists.digium.com>
> Sent: Thursday, April 18, 2013 11:32 PM
> Subject: Re: [asterisk-users] Dynamic realtime + queues
>
> Uhm ... I see the easy way will be to tcpdump the connection between the
> asterisk and the mysql database server and to dump the exact SQL syntax
> used. It will be something wrong...
>
> Leandro
>
> PS
> tcpdump -i any -n -s 1500 -w /tmp/data.pcap port 3306
>
>
>
>
> 2013/4/18 Tommy Cooper <tomcooper83 at yahoo.com>
>
> Thank you for your response
>
> I already have a name column but my primary key is 'QueueID' instead of name
>
> +-----------------------------+-----------------------+------+-----+------------+----------------+
> | Field                       | Type                  | Null | Key | Default
> | Extra          |
> +-----------------------------+-----------------------+------+-----+------------+----------------+
> | QueueID                     | mediumint(8) unsigned | NO   | PRI | NULL
> | auto_increment |
> | name                        | varchar(128)          | NO   | UNI | NULL
> |                |
> | description                 | varchar(128)          | YES  |     | NULL
> |                |
> | maxlen                      | tinyint(4)            | YES  |     | NULL
> |                |
> | reportholdtime              | varchar(3)            | YES  |     | no
> |                |
> | periodic_announce_frequency | varchar(4)            | YES  |     | NULL
> |                |
> | periodic_announce           | varchar(128)          | YES  |     | NULL
> |                |
> | strategy                    | varchar(20)           | NO   |     |
> rrmemory   |                |
> | joinempty                   | varchar(35)           | YES  |     | no
> |                |
> | leavewhenempty              | varchar(35)           | YES  |     | no
> |                |
> | autopause                   | varchar(3)            | YES  |     | no
> |                |
> | announce_round_seconds      | varchar(4)            | YES  |     | NULL
> |                |
> | retry                       | varchar(4)            | YES  |     | NULL
> |                |
> | wrapuptime                  | varchar(4)            | YES  |     | NULL
> |                |
> | announce_holdtime           | varchar(3)            | YES  |     | no
> |                |
> | announce_frequency          | varchar(4)            | YES  |     | 0
> |                |
> | timeout                     | varchar(4)            | YES  |     | 60
> |                |
> | context                     | varchar(128)          | NO   |     | NULL
> |                |
> | musicclass                  | varchar(128)          | YES  |     | default
> |                |
> | autofill                    | varchar(3)            | YES  |     | yes
> |                |
> | ringinuse                   | varchar(45)           | YES  |     | no
> |                |
> | musiconhold                 | varchar(128)          | YES  |     | yes
> |                |
> | monitor_type                | varchar(128)          | YES  |     |
> MixMonitor |                |
> | monitor_format              | varchar(128)          | YES  |     | wav
> |                |
> | servicelevel                | varchar(4)            | YES  |     | 60
> |                |
> | queue_thankyou              | varchar(128)          | YES  |     |
> |                |
> | queue_youarenext            | varchar(128)          | YES  |     |
> |                |
> | queue_thereare              | varchar(128)          | YES  |     |
> |                |
> | queue_callswaiting          | varchar(128)          | YES  |     |
> |                |
> | queue_holdtime              | varchar(128)          | YES  |     |
> |                |
> | queue_minutes               | varchar(128)          | YES  |     |
> |                |
> | queue_seconds               | varchar(128)          | YES  |     |
> |                |
> | queue_lessthan              | varchar(128)          | YES  |     |
> |                |
> | queue_reporthold            | varchar(128)          | YES  |     |
> |                |
> | relative_periodic_announce  | varchar(4)            | YES  |     | yes
> |                |
> +-----------------------------+-----------------------+------+-----+------------+----------------+
> 35 rows in set (0.00 sec)
>
>
>
>
> --
> _____________________________________________________________________
> -- Bandwidth and Colocation Provided by http://www.api-digital.com --
> New to Asterisk? Join us for a live introductory webinar every Thurs:
>                http://www.asterisk.org/hello
>
> asterisk-users mailing list
> To UNSUBSCRIBE or update options visit:
>    http://lists.digium.com/mailman/listinfo/asterisk-users

TCP shows you have no queue_member_table on your database.

http://www.voip-info.org/wiki/view/Asterisk+RealTime+Queue

You must create one with command:
CREATE TABLE queue_member_table (
uniqueid INT(10) UNSIGNED PRIMARY KEY AUTO_INCREMENT,
membername varchar(40),
queue_name varchar(128),
interface varchar(128),
penalty INT(11),
paused INT(11),
UNIQUE KEY queue_interface (queue_name, interface)
);

Regards

José Flores Galicia