<html><body><div style="color:#000; background-color:#fff; font-family:times new roman, new york, times, serif;font-size:12pt"><div style="RIGHT: auto"><SPAN style="RIGHT: auto">Thank you all for your help </SPAN></div>
<div style="BACKGROUND-COLOR: transparent; FONT-STYLE: normal; FONT-FAMILY: times new roman, new york, times, serif; COLOR: rgb(0,0,0); FONT-SIZE: 16px; RIGHT: auto"><SPAN style="RIGHT: auto"></SPAN> </div>
<div style="BACKGROUND-COLOR: transparent; FONT-STYLE: normal; FONT-FAMILY: times new roman, new york, times, serif; COLOR: rgb(0,0,0); FONT-SIZE: 16px; RIGHT: auto"><SPAN style="RIGHT: auto">Mr. José Flores Galicia,</SPAN></div>
<div style="BACKGROUND-COLOR: transparent; FONT-STYLE: normal; FONT-FAMILY: times new roman, new york, times, serif; COLOR: rgb(0,0,0); FONT-SIZE: 16px; RIGHT: auto"><SPAN style="RIGHT: auto"><BR> </div></SPAN>
<div style="BACKGROUND-COLOR: transparent; FONT-STYLE: normal; FONT-FAMILY: times new roman, new york, times, serif; COLOR: rgb(0,0,0); FONT-SIZE: 16px; RIGHT: auto"><SPAN style="RIGHT: auto">I already have the queue_member_table and it has 1 record in it. I m not sure what interface I have to enter in the interface field.</SPAN></div>
<div style="BACKGROUND-COLOR: transparent; FONT-STYLE: normal; FONT-FAMILY: times new roman, new york, times, serif; COLOR: rgb(0,0,0); FONT-SIZE: 16px; RIGHT: auto"><SPAN style="RIGHT: auto">mysql> explain queue_member_table;<BR>+------------+------------------+------+-----+---------+----------------+<BR>| Field | Type | Null | Key | Default | Extra |<BR>+------------+------------------+------+-----+---------+----------------+<BR>| uniqueid | int(10) unsigned | NO | PRI | NULL | auto_increment |<BR>| membername | varchar(40) | YES | | NULL | |<BR>| queue_name |
varchar(128) | YES | MUL | NULL | |<BR>| interface | varchar(128) | YES | | NULL | |<BR>| penalty | int(11) | YES | | NULL | |<BR>| paused | int(11) | YES | | NULL |
|<BR>+------------+------------------+------+-----+---------+----------------+<BR style="RIGHT: auto">6 rows in set (0.00 sec)</SPAN></div>
<div style="BACKGROUND-COLOR: transparent; FONT-STYLE: normal; FONT-FAMILY: times new roman, new york, times, serif; COLOR: rgb(0,0,0); FONT-SIZE: 16px; RIGHT: auto"><SPAN style="RIGHT: auto"></SPAN> </div><SPAN style="RIGHT: auto">
<DIV style="RIGHT: auto"> </DIV>
<DIV style="RIGHT: auto">Lach,</DIV>
<DIV style="RIGHT: auto"> </DIV>
<DIV style="RIGHT: auto">"To me it looks like queue_name should be just name in your sql statement."</DIV>
<DIV style="RIGHT: auto"> </DIV>
<DIV style="RIGHT: auto">Are you refering to queue_name column in the queue_member_table?</DIV></SPAN>
<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> Lachlan Dunlop <lach@lach.net><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> Friday, April 19, 2013 12:02 AM<BR><B><SPAN style="FONT-WEIGHT: bold">Subject:</SPAN></B> Re: [asterisk-users] Dynamic realtime + queues<BR></FONT></DIV>
<DIV style="RIGHT: auto" class=y_msg_container><BR>
<META content=off http-equiv=x-dns-prefetch-control>
<DIV style="RIGHT: auto" id=yiv226337844>
<DIV style="RIGHT: auto">
<DIV>Tommy,</DIV>
<DIV><BR></DIV>
<DIV>To me it looks like queue_name should be just name in your sql statement.</DIV>
<DIV><BR></DIV>
<DIV style="RIGHT: auto">Lach</DIV>
<DIV style="RIGHT: auto"></DIV>
<DIV> </DIV>
<DIV style="RIGHT: auto"> </DIV>
<DIV style="RIGHT: auto">This is what i m getting when i m in the asterisk console:</DIV>
<DIV style="RIGHT: auto"> </DIV>
<DIV style="RIGHT: auto">node1*CLI> queue show <BR>support has 0 calls (max unlimited) in 'rrmemory' strategy (0s holdtime, 0s talktime), W:0, C:0, A:0, SL:0.0% within 60s<BR> No Members<BR> No Callers</DIV>
<DIV style="RIGHT: auto">[Apr 19 00:15:13] WARNING[57946]: res_odbc.c:645 ast_odbc_prepare_and_execute: SQL Execute returned an error -1: 42000: [MySQL][ODBC 5.1 Driver][mysqld-5.1.67]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''\' ORDER BY name' at line 1 (202)<BR>[Apr 19 00:15:13] WARNING[57946]: res_odbc.c:657 ast_odbc_prepare_and_execute: SQL Execute error -1! Verifying connection to asterisk [asterisk-connector]...<BR>[Apr 19 00:15:13] WARNING[57946]: res_odbc.c:761 ast_odbc_sanity_check: Connection is down attempting to reconnect...<BR>[Apr 19 00:15:13] NOTICE[57946]: res_odbc.c:1527 odbc_obj_connect: Connecting asterisk<BR>[Apr 19 00:15:13] NOTICE[57946]: res_odbc.c:1559 odbc_obj_connect: res_odbc: Connected to asterisk [asterisk-connector]<BR>[Apr 19 00:15:13] WARNING[57946]: res_odbc.c:645 ast_odbc_prepare_and_execute: SQL Execute returned an error -1:
42000: [MySQL][ODBC 5.1 Driver][mysqld-5.1.67]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''\' ORDER BY name' at line 1 (202)<BR>[Apr 19 00:15:13] WARNING[57946]: res_odbc.c:657 ast_odbc_prepare_and_execute: SQL Execute error -1! Verifying connection to asterisk [asterisk-connector]...<BR>[Apr 19 00:15:13] WARNING[57946]: res_odbc.c:761 ast_odbc_sanity_check: Connection is down attempting to reconnect...<BR>[Apr 19 00:15:13] NOTICE[57946]: res_odbc.c:1527 odbc_obj_connect: Connecting asterisk<BR>[Apr 19 00:15:13] NOTICE[57946]: res_odbc.c:1559 odbc_obj_connect: res_odbc: Connected to asterisk [asterisk-connector]<BR>[Apr 19 00:15:13] WARNING[57946]: res_odbc.c:645 ast_odbc_prepare_and_execute: SQL Execute returned an error -1: 42000: [MySQL][ODBC 5.1 Driver][mysqld-5.1.67]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server
version for the right syntax to use near ''\' AND queue_name = ? ORDER BY interface' at line 1 (226)<BR>[Apr 19 00:15:13] WARNING[57946]: res_odbc.c:657 ast_odbc_prepare_and_execute: SQL Execute error -1! Verifying connection to asterisk [asterisk-connector]...<BR>[Apr 19 00:15:13] WARNING[57946]: res_odbc.c:761 ast_odbc_sanity_check: Connection is down attempting to reconnect...<BR>[Apr 19 00:15:13] NOTICE[57946]: res_odbc.c:1527 odbc_obj_connect: Connecting asterisk<BR>[Apr 19 00:15:13] NOTICE[57946]: res_odbc.c:1559 odbc_obj_connect: res_odbc: Connected to asterisk [asterisk-connector]<BR>[Apr 19 00:15:13] WARNING[57946]: res_odbc.c:645 ast_odbc_prepare_and_execute: SQL Execute returned an error -1: 42000: [MySQL][ODBC 5.1 Driver][mysqld-5.1.67]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''\' AND queue_name = ? ORDER BY interface' at line 1 (226)<BR>[Apr 19
00:15:13] WARNING[57946]: res_odbc.c:657 ast_odbc_prepare_and_execute: SQL Execute error -1! Verifying connection to asterisk [asterisk-connector]...<BR>[Apr 19 00:15:13] WARNING[57946]: res_odbc.c:761 ast_odbc_sanity_check: Connection is down attempting to reconnect...<BR>[Apr 19 00:15:13] NOTICE[57946]: res_odbc.c:1527 odbc_obj_connect: Connecting asterisk<BR>[Apr 19 00:15:13] NOTICE[57946]: res_odbc.c:1559 odbc_obj_connect: res_odbc: Connected to asterisk [asterisk-connector]<BR>[Apr 19 00:16:09] WARNING[62511][C-00000008]: res_odbc.c:645 ast_odbc_prepare_and_execute: SQL Execute returned an error -1: 42000: [MySQL][ODBC 5.1 Driver][mysqld-5.1.67]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''\' AND queue_name = ? ORDER BY interface' at line 1 (226)<BR>[Apr 19 00:16:09] WARNING[62511][C-00000008]: res_odbc.c:657 ast_odbc_prepare_and_execute: SQL Execute error -1!
Verifying connection to asterisk [asterisk-connector]...<BR>[Apr 19 00:16:09] WARNING[62511][C-00000008]: res_odbc.c:761 ast_odbc_sanity_check: Connection is down attempting to reconnect...<BR>[Apr 19 00:16:09] NOTICE[62511][C-00000008]: res_odbc.c:1527 odbc_obj_connect: Connecting asterisk<BR>[Apr 19 00:16:09] NOTICE[62511][C-00000008]: res_odbc.c:1559 odbc_obj_connect: res_odbc: Connected to asterisk [asterisk-connector]<BR>[Apr 19 00:16:09] WARNING[62511][C-00000008]: res_odbc.c:645 ast_odbc_prepare_and_execute: SQL Execute returned an error -1: 42000: [MySQL][ODBC 5.1 Driver][mysqld-5.1.67]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''\' AND queue_name = ? ORDER BY interface' at line 1 (226)<BR>[Apr 19 00:16:09] WARNING[62511][C-00000008]: res_odbc.c:657 ast_odbc_prepare_and_execute: SQL Execute error -1! Verifying connection to asterisk
[asterisk-connector]...<BR>[Apr 19 00:16:09] WARNING[62511][C-00000008]: res_odbc.c:761 ast_odbc_sanity_check: Connection is down attempting to reconnect...<BR>[Apr 19 00:16:09] NOTICE[62511][C-00000008]: res_odbc.c:1527 odbc_obj_connect: Connecting asterisk<BR>[Apr 19 00:16:09] NOTICE[62511][C-00000008]: res_odbc.c:1559 odbc_obj_connect: res_odbc: Connected to asterisk [asterisk-connector]<BR>[Apr 19 00:16:09] WARNING[62511][C-00000008]: app_queue.c:7035 queue_exec: Unable to join queue 'support'</DIV><SPAN style="RIGHT: auto" id=yiv226337844OLK_SRC_BODY_SECTION>
<DIV style="BORDER-BOTTOM: medium none; TEXT-ALIGN: left; BORDER-LEFT: medium none; PADDING-BOTTOM: 0in; PADDING-LEFT: 0in; PADDING-RIGHT: 0in; FONT-FAMILY: Calibri; COLOR: black; FONT-SIZE: 11pt; BORDER-TOP: #b5c4df 1pt solid; BORDER-RIGHT: medium none; PADDING-TOP: 3pt"><SPAN style="FONT-WEIGHT: bold">From: </SPAN>Tommy Cooper <<A href="mailto:tomcooper83@yahoo.com" rel=nofollow target=_blank ymailto="mailto:tomcooper83@yahoo.com">tomcooper83@yahoo.com</A>><BR><SPAN style="FONT-WEIGHT: bold">Reply-To: </SPAN>Tommy Cooper <<A href="mailto:tomcooper83@yahoo.com" rel=nofollow target=_blank ymailto="mailto:tomcooper83@yahoo.com">tomcooper83@yahoo.com</A>>, Asterisk Users Mailing List - Non-Commercial Discussion <<A href="mailto:asterisk-users@lists.digium.com" rel=nofollow target=_blank ymailto="mailto:asterisk-users@lists.digium.com">asterisk-users@lists.digium.com</A>><BR><SPAN style="FONT-WEIGHT: bold">To: </SPAN>Asterisk Mailing List
- Non-Commercial Discussion <<A href="mailto:asterisk-users@lists.digium.com" rel=nofollow target=_blank ymailto="mailto:asterisk-users@lists.digium.com">asterisk-users@lists.digium.com</A>><BR><SPAN style="FONT-WEIGHT: bold">Subject: </SPAN>Re: [asterisk-users] Dynamic realtime + queues<BR></DIV>
<DIV><BR></DIV>
<DIV style="RIGHT: auto">
<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><BR class=yiv226337844yui-cursor></SPAN></DIV>
<DIV>
<DIV dir=ltr><FONT size=2 face=Arial></FONT></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 style="RIGHT: auto" class=yiv226337844y_msg_container>
<DIV style="RIGHT: auto" id=yiv226337844>
<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=yiv226337844yui-ie-cursor></VAR><BR class=yiv226337844yui-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 <<A href="mailto:ldardini@gmail.com" rel=nofollow target=_blank ymailto="mailto:ldardini@gmail.com">ldardini@gmail.com</A>><BR><B><SPAN style="FONT-WEIGHT: bold">To:</SPAN></B> Tommy Cooper <<A href="mailto:tomcooper83@yahoo.com" rel=nofollow target=_blank ymailto="mailto:tomcooper83@yahoo.com">tomcooper83@yahoo.com</A>>; Asterisk Users Mailing List - Non-Commercial Discussion <<A href="mailto:asterisk-users@lists.digium.com" rel=nofollow target=_blank ymailto="mailto:asterisk-users@lists.digium.com">asterisk-users@lists.digium.com</A>> <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=yiv226337844y_msg_container><BR>
<DIV style="RIGHT: auto" id=yiv226337844>
<DIV 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><BR></DIV>
<DIV><BR></DIV></DIV>
<DIV style="RIGHT: auto" class=yiv226337844gmail_extra><BR><VAR id=yui-ie-cursor></VAR><BR> </DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></SPAN></DIV></DIV></DIV></DIV></DIV></div></body></html>