<html><body><div style="color:#000; background-color:#fff; font-family:times new roman, new york, times, serif;font-size:12pt"><div><SPAN><BR class=yui-cursor></SPAN></div>
<div>
<DIV style="RIGHT: auto" dir=ltr><FONT size=2 face=Arial></FONT></DIV><BR>
<META content=off http-equiv=x-dns-prefetch-control></div>
<DIV style="FONT-FAMILY: times new roman, new york, times, serif; FONT-SIZE: 12pt">
<DIV style="FONT-FAMILY: times new roman, new york, times, serif; FONT-SIZE: 12pt">
<DIV style="RIGHT: auto" class=y_msg_container>
<DIV style="RIGHT: auto" id=yiv1889544746>
<DIV style="RIGHT: auto">
<DIV style="BACKGROUND-COLOR: #fff; FONT-FAMILY: times new roman, new york, times, serif; COLOR: #000; FONT-SIZE: 12pt">
<DIV><SPAN>Thanks again for replying, I got a wireshark capture with that command you provided. Please find attached the wireshark capture<VAR id=yiv1889544746yui-ie-cursor></VAR><BR class=yiv1889544746yui-cursor></SPAN></DIV>
<DIV><BR></DIV>
<DIV style="FONT-FAMILY: times new roman, new york, times, serif; FONT-SIZE: 12pt">
<DIV style="FONT-FAMILY: times new roman, new york, times, serif; FONT-SIZE: 12pt">
<DIV dir=ltr>----- Forwarded Message -----<BR><FONT size=2 face=Arial><B><SPAN style="FONT-WEIGHT: bold">From:</SPAN></B> Leandro Dardini <ldardini@gmail.com><BR><B><SPAN style="FONT-WEIGHT: bold">To:</SPAN></B> Tommy Cooper <tomcooper83@yahoo.com>; Asterisk Users Mailing List - Non-Commercial Discussion <asterisk-users@lists.digium.com> <BR><B><SPAN style="FONT-WEIGHT: bold">Sent:</SPAN></B> Thursday, April 18, 2013 11:32 PM<BR><B><SPAN style="FONT-WEIGHT: bold">Subject:</SPAN></B> Re: [asterisk-users] Dynamic realtime + queues<BR></FONT></DIV>
<DIV style="RIGHT: auto" class=yiv1889544746y_msg_container><BR>
<DIV style="RIGHT: auto" id=yiv1889544746>
<DIV style="RIGHT: auto" dir=ltr>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...
<DIV><BR></DIV>
<DIV>Leandro</DIV>
<DIV><BR></DIV>
<DIV>PS</DIV>
<DIV>tcpdump -i any -n -s 1500 -w /tmp/data.pcap port 3306</DIV>
<DIV style="RIGHT: auto"><BR></DIV>
<DIV><BR></DIV></DIV>
<DIV style="RIGHT: auto" class=yiv1889544746gmail_extra><BR><BR>
<DIV style="RIGHT: auto" class=yiv1889544746gmail_quote>2013/4/18 Tommy Cooper <SPAN dir=ltr><<A href="mailto:tomcooper83@yahoo.com" rel=nofollow target=_blank ymailto="mailto:tomcooper83@yahoo.com">tomcooper83@yahoo.com</A>></SPAN><BR>
<BLOCKQUOTE style="BORDER-LEFT: #ccc 1px solid; MARGIN: 0px 0px 0px 0.8ex; PADDING-LEFT: 1ex; RIGHT: auto" class=yiv1889544746gmail_quote>
<DIV>
<DIV style="FONT-FAMILY: times new roman, new york, times, serif; FONT-SIZE: 12pt">
<DIV><SPAN>Thank you for your response</SPAN></DIV>
<DIV><SPAN></SPAN> </DIV>
<DIV><SPAN>I already have a name column but my primary key is 'QueueID' instead of name<VAR></VAR></SPAN></DIV>
<DIV style="BACKGROUND-COLOR: transparent; FONT-STYLE: normal; FONT-FAMILY: times new roman, new york, times, serif; FONT-SIZE: 16px"><SPAN></SPAN> </DIV>
<DIV style="BACKGROUND-COLOR: transparent; FONT-STYLE: normal; FONT-FAMILY: times new roman, new york, times, serif; FONT-SIZE: 16px"><SPAN>+-----------------------------+-----------------------+------+-----+------------+----------------+<BR>| Field | Type | Null | Key | Default | Extra |<BR>+-----------------------------+-----------------------+------+-----+------------+----------------+<BR>| QueueID | mediumint(8) unsigned | NO | PRI | NULL | auto_increment |<BR>|
name | varchar(128) | NO | UNI | NULL | |<BR>| description | varchar(128) | YES | | NULL | |<BR>| maxlen | tinyint(4) | YES
| | NULL | |<BR>| reportholdtime | varchar(3) | YES | | no | |<BR>| periodic_announce_frequency | varchar(4) | YES | | NULL | |<BR>| periodic_announce | varchar(128) |
YES | | NULL | |<BR>| strategy | varchar(20) | NO | | rrmemory | |<BR>| joinempty | varchar(35) | YES | | no | |<BR>|
leavewhenempty | varchar(35) | YES | | no | |<BR>| autopause | varchar(3) | YES | | no | |<BR>| announce_round_seconds | varchar(4) | YES | | NULL
| |<BR>| retry | varchar(4) | YES | | NULL | |<BR>| wrapuptime | varchar(4) | YES | | NULL | |<BR>| announce_holdtime |
varchar(3) | YES | | no | |<BR>| announce_frequency | varchar(4) | YES | | 0 | |<BR>| timeout | varchar(4) | YES | | 60
| |<BR>| context | varchar(128) | NO | | NULL | |<BR>| musicclass | varchar(128) | YES | | default | |<BR>| autofill |
varchar(3) | YES | | yes | |<BR>| ringinuse | varchar(45) | YES | | no | |<BR>| musiconhold | varchar(128) | YES | | yes
| |<BR>| monitor_type | varchar(128) | YES | | MixMonitor | |<BR>| monitor_format | varchar(128) | YES | | wav | |<BR>| servicelevel | varchar(4) | YES
| | 60 | |<BR>| queue_thankyou | varchar(128) | YES | | | |<BR>| queue_youarenext | varchar(128) | YES | | | |<BR>|
queue_thereare | varchar(128) | YES | | | |<BR>| queue_callswaiting | varchar(128) | YES | | | |<BR>| queue_holdtime | varchar(128) | YES |
| | |<BR>| queue_minutes | varchar(128) | YES | | | |<BR>| queue_seconds | varchar(128) | YES | | | |<BR>|
queue_lessthan | varchar(128) | YES | | | |<BR>| queue_reporthold | varchar(128) | YES | | | |<BR>| relative_periodic_announce | varchar(4) | YES | | yes
| |<BR>+-----------------------------+-----------------------+------+-----+------------+----------------+<BR>35 rows in set (0.00 sec)<BR></SPAN></DIV>
<DIV><BR></DIV>
<DIV style="FONT-FAMILY: times new roman, new york, times, serif; FONT-SIZE: 12pt">
<DIV style="FONT-FAMILY: times new roman, new york, times, serif; FONT-SIZE: 12pt"><VAR id=yui-ie-cursor></VAR> </DIV></DIV></DIV></DIV></BLOCKQUOTE></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></div></body></html>