Thank you all for your help
Mr. José Flores Galicia,
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.
mysql> explain queue_member_table;
+------------+------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+------------+------------------+------+-----+---------+----------------+
| uniqueid | int(10) unsigned | NO | PRI | NULL | auto_increment |
| membername | varchar(40) | YES | | NULL | |
| queue_name | varchar(128) | YES | MUL | NULL | |
| interface | varchar(128) | YES | | NULL | |
| penalty | int(11) | YES | | NULL | |
| paused | int(11) | YES | | NULL | |
+------------+------------------+------+-----+---------+----------------+
6 rows in set (0.00 sec)
Lach,
"To me it looks like queue_name should be just name in your sql statement."
Are you refering to queue_name column in the queue_member_table?
----- Forwarded Message -----
From: Lachlan Dunlop <[email protected]>
To: Tommy Cooper <[email protected]>; Asterisk Users Mailing List -
Non-Commercial Discussion <[email protected]>
Sent: Friday, April 19, 2013 12:02 AM
Subject: Re: [asterisk-users] Dynamic realtime + queues
Tommy,
To me it looks like queue_name should be just name in your sql statement.
Lach
This is what i m getting when i m in the asterisk console:
node1*CLI> queue show
support has 0 calls (max unlimited) in 'rrmemory' strategy (0s holdtime, 0s
talktime), W:0, C:0, A:0, SL:0.0% within 60s
No Members
No Callers
[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)
[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]...
[Apr 19 00:15:13] WARNING[57946]: res_odbc.c:761 ast_odbc_sanity_check:
Connection is down attempting to reconnect...
[Apr 19 00:15:13] NOTICE[57946]: res_odbc.c:1527 odbc_obj_connect: Connecting
asterisk
[Apr 19 00:15:13] NOTICE[57946]: res_odbc.c:1559 odbc_obj_connect: res_odbc:
Connected to asterisk [asterisk-connector]
[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)
[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]...
[Apr 19 00:15:13] WARNING[57946]: res_odbc.c:761 ast_odbc_sanity_check:
Connection is down attempting to reconnect...
[Apr 19 00:15:13] NOTICE[57946]: res_odbc.c:1527 odbc_obj_connect: Connecting
asterisk
[Apr 19 00:15:13] NOTICE[57946]: res_odbc.c:1559 odbc_obj_connect: res_odbc:
Connected to asterisk [asterisk-connector]
[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)
[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]...
[Apr 19 00:15:13] WARNING[57946]: res_odbc.c:761 ast_odbc_sanity_check:
Connection is down attempting to reconnect...
[Apr 19 00:15:13] NOTICE[57946]: res_odbc.c:1527 odbc_obj_connect: Connecting
asterisk
[Apr 19 00:15:13] NOTICE[57946]: res_odbc.c:1559 odbc_obj_connect: res_odbc:
Connected to asterisk [asterisk-connector]
[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)
[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]...
[Apr 19 00:15:13] WARNING[57946]: res_odbc.c:761 ast_odbc_sanity_check:
Connection is down attempting to reconnect...
[Apr 19 00:15:13] NOTICE[57946]: res_odbc.c:1527 odbc_obj_connect: Connecting
asterisk
[Apr 19 00:15:13] NOTICE[57946]: res_odbc.c:1559 odbc_obj_connect: res_odbc:
Connected to asterisk [asterisk-connector]
[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)
[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]...
[Apr 19 00:16:09] WARNING[62511][C-00000008]: res_odbc.c:761
ast_odbc_sanity_check: Connection is down attempting to reconnect...
[Apr 19 00:16:09] NOTICE[62511][C-00000008]: res_odbc.c:1527 odbc_obj_connect:
Connecting asterisk
[Apr 19 00:16:09] NOTICE[62511][C-00000008]: res_odbc.c:1559 odbc_obj_connect:
res_odbc: Connected to asterisk [asterisk-connector]
[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)
[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]...
[Apr 19 00:16:09] WARNING[62511][C-00000008]: res_odbc.c:761
ast_odbc_sanity_check: Connection is down attempting to reconnect...
[Apr 19 00:16:09] NOTICE[62511][C-00000008]: res_odbc.c:1527 odbc_obj_connect:
Connecting asterisk
[Apr 19 00:16:09] NOTICE[62511][C-00000008]: res_odbc.c:1559 odbc_obj_connect:
res_odbc: Connected to asterisk [asterisk-connector]
[Apr 19 00:16:09] WARNING[62511][C-00000008]: app_queue.c:7035 queue_exec:
Unable to join queue 'support'From: Tommy Cooper <[email protected]>
Reply-To: Tommy Cooper <[email protected]>, Asterisk Users Mailing List -
Non-Commercial Discussion <[email protected]>
To: Asterisk Mailing List - Non-Commercial Discussion
<[email protected]>
Subject: Re: [asterisk-users] Dynamic realtime + queues
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 <[email protected]>
To: Tommy Cooper <[email protected]>; Asterisk Users Mailing List -
Non-Commercial Discussion <[email protected]>
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
--
_____________________________________________________________________
-- 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
