[asterisk-users] Dynamic realtime + queues
Tommy Cooper
tomcooper83 at yahoo.com
Thu Apr 18 16:52:40 CDT 2013
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)
>
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.digium.com/pipermail/asterisk-users/attachments/20130418/dc8bd483/attachment.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: data.pcap
Type: application/octet-stream
Size: 8343 bytes
Desc: not available
URL: <http://lists.digium.com/pipermail/asterisk-users/attachments/20130418/dc8bd483/attachment.obj>
More information about the asterisk-users
mailing list