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 <ldard...@gmail.com> To: Tommy Cooper <tomcoope...@yahoo.com>; Asterisk Users Mailing List - Non-Commercial Discussion <asterisk-users@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 <tomcoope...@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) > > > >
data.pcap
Description: Binary data
-- _____________________________________________________________________ -- 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
