[asterisk-users] Fw: Stress testing Asterisk
>From the little experience I have I do not think that that is a good way of >testing the quality of voice. SIP only initiates and eventually terminates the >call, once that the call is connected, SIP and therefore Asterisk are no >longer involved. Once the call is connected it is assigned to a trapsport >layer protocol such as RTP. RTP is the actual protocol that delivers the voice >call between endpoints. I believe that the setup of your network, QoS, codecs >etc... determine the voice quality of your system. - Forwarded Message - From: Mitul Limbani To: Tommy Cooper ; Asterisk Users Mailing List - Non-Commercial Discussion Sent: Wednesday, May 22, 2013 3:23 PM Subject: Re: [asterisk-users] Stress testing Asterisk I have a question here. How can we test the quality of voice upon increasing the call load? Can we try passing a voice file using sipp and record the same in dial plan record application ? Is this reliable enough to simulate near real world scenario? Mitul On Wednesday, May 22, 2013, Tommy Cooper wrote: Thank you for your help I finally solved this issue. Is it possible that my setup can achieve 212 concurrent calls, I am running Asterisk on just 1 core using 3.5 GHz, and 1Gb of RAM? > > > >- Forwarded Message - >From: Marie Fischer >To: Asterisk Users Mailing List - Non-Commercial Discussion > >Sent: Wednesday, May 22, 2013 1:16 PM >Subject: Re: [asterisk-users] Stress testing Asterisk > > > >On 21.05.2013, at 0:05, Tommy Cooper wrote: > >> Hi, >> I just installed Sipp 3.3 on CentOS 6.3 and all of the calls Sipp is >> generating are failing. I am trying to run Sipp on the same machine as >> Asterisk PBX using the ./sipp -sn uac 192.168.1.115 command. > >Do you have a peer and extension configured for SIPP in your Asterisk >configuration? You also needat least the -s option on your >sipp command line. >http://hasnainali.wordpress.com/2009/03/12/using-sipp-for-stress-testing-asterisk/has > some simple instructions which should get you started. >If the calls still fail, Asterisk console output would be helpful. > > > >-- >_ >-- 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 > > > -- Regards, Mitul Limbani, Chief Architech & Founder, Enterux Solutions Pvt. Ltd. 110 Reena Complex, Opp. Nathani Steel, Vidyavihar (W), Mumbai - 400 086. India http://www.enterux.com/ http://www.entvoice.com/ email: mi...@enterux.in DID: +91-22-71967121 Cell: +91-9820332422-- _ -- 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
[asterisk-users] Fw: Stress testing Asterisk
Thank you for your help I finally solved this issue. Is it possible that my setup can achieve 212 concurrent calls, I am running Asterisk on just 1 core using 3.5 GHz, and 1Gb of RAM? - Forwarded Message - From: Marie Fischer To: Asterisk Users Mailing List - Non-Commercial Discussion Sent: Wednesday, May 22, 2013 1:16 PM Subject: Re: [asterisk-users] Stress testing Asterisk On 21.05.2013, at 0:05, Tommy Cooper wrote: > Hi, > I just installed Sipp 3.3 on CentOS 6.3 and all of the calls Sipp is > generating are failing. I am trying to run Sipp on the same machine as > Asterisk PBX using the ./sipp -sn uac 192.168.1.115 command. Do you have a peer and extension configured for SIPP in your Asterisk configuration? You also needat least the -s option on your sipp command line. http://hasnainali.wordpress.com/2009/03/12/using-sipp-for-stress-testing-asterisk/has some simple instructions which should get you started. If the calls still fail, Asterisk console output would be helpful. -- _ -- 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-- _ -- 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
[asterisk-users] Stress testing Asterisk
Hi, I just installed Sipp 3.3 on CentOS 6.3 and all of the calls Sipp is generating are failing. I am trying to run Sipp on the same machine as Asterisk PBX using the ./sipp -sn uac 192.168.1.115 command. SIpp output: - Statistics Screen --- [1-9]: Change Screen -- Start Time | 2013-05-20 22:53:08:637 1369083188.637273 Last Reset Time | 2013-05-20 22:55:17:676 1369083317.676598 Current Time | 2013-05-20 22:55:17:676 1369083317.676651 -+---+-- Counter Name | Periodic value | Cumulative value -+---+-- Elapsed Time | 00:00:00:000 | 00:02:09:039 Call Rate | 0.000 cps | 0.930 cps -+---+-- Incoming call created | 0 | 0 OutGoing call created | 0 | 120 Total Call created | | 120 Current Call | 0 | -+---+-- Successful call | 0 | 0 Failed call | 0 | 120 -+---+-- Response Time 1 | 00:00:00:000 | 00:00:00:000 Call Length | 00:00:00:000 | 00:00:31:509 -- Test Terminated 2013-05-20 22:55:17:675 1369083317.675242: Aborting call on UDP retransmission timeout for Call-ID '120-60749@192.168.1.114'. sipp: There were more errors, enable -trace_err to log them. This an error message I get when I use -trace_err: 2013-05-20 23:00:59:021 1369083659.021771: Aborting call on UDP retransmission timeout for Call-ID '33-60833@192.168.1.114 Thanks in advance. Regards, Tom-- _ -- 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
[asterisk-users] Device states
Hi, I am using Corosync v1.4.1 to distribute device states between 2 Asterisk servers. I am getting 4 different nodes but I only have 2 running and in my /etc/corosync/corosync.conf I only defined 2 nodes which are 192.168.1.110 and 192.168.1.111. How do I remove the other 2? I also created a hint in extensions.conf to test my config and changed its state from the asterisk cli and its state did not even show up on the other Asterisk server. Thank you. node2*CLI> corosync show members = === Cluster members = = === === Node 1 === --> Group: asterisk === --> Address 1: 192.168.1.110 === Node 2 === --> Group: asterisk === --> Address 1: 192.168.1.111 === Node 3 === --> Group: pcmk === --> Address 1: 192.168.1.110 === Node 4 === --> Group: pcmk === --> Address 1: 192.168.1.111 === node2*CLI> corosync show config = === res_corosync config = = === === ==> Publishing Event Type: device_state === ==> Subscribing to Event Type: device_state === ==> Publishing Event Type: ping === ==> Subscribing to Event Type: ping === =-- _ -- 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
[asterisk-users] Dynamic realtime + queues.conf Unresolved
Hi, I want queues.conf to be stored on a MySQL database using dynamic realtime. I am using asterisk 11.2.1 and MySQL 5.1.67, the MySQL database is hosted on another server but I can access the database via ODBC. I have created the following tables: SQL> show tables; +-+ | Tables_in_asterisk | +-+ | QueueDialplanParameters | | Queues | | queue_log | | queue_member_table | +-+ SQLRowCount returns 4 4 rows fetched Each table has all of the required fields, some people suggested that queue_name is missing but it's not. I am getting the following errors from the asterisk console: node1*CLI> queue show support 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 22:37:05] WARNING[18366]: 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 22:37:05] WARNING[18366]: res_odbc.c:657 ast_odbc_prepare_and_execute: SQL Execute error -1! Verifying connection to asterisk [asterisk-connector]... [Apr 19 22:37:05] WARNING[18366]: res_odbc.c:761 ast_odbc_sanity_check: Connection is down attempting to reconnect... [Apr 19 22:37:05] NOTICE[18366]: res_odbc.c:1527 odbc_obj_connect: Connecting asterisk [Apr 19 22:37:05] NOTICE[18366]: res_odbc.c:1559 odbc_obj_connect: res_odbc: Connected to asterisk [asterisk-connector] [Apr 19 22:37:05] WARNING[18366]: 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 22:37:05] WARNING[18366]: res_odbc.c:657 ast_odbc_prepare_and_execute: SQL Execute error -1! Verifying connection to asterisk [asterisk-connector]... [Apr 19 22:37:05] WARNING[18366]: res_odbc.c:761 ast_odbc_sanity_check: Connection is down attempting to reconnect... [Apr 19 22:37:05] NOTICE[18366]: res_odbc.c:1527 odbc_obj_connect: Connecting asterisk [Apr 19 22:37:05] NOTICE[18366]: res_odbc.c:1559 odbc_obj_connect: res_odbc: Connected to asterisk [asterisk-connector] [Apr 19 22:37:05] WARNING[18366]: 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 22:37:05] WARNING[18366]: res_odbc.c:657 ast_odbc_prepare_and_execute: SQL Execute error -1! Verifying connection to asterisk [asterisk-connector]... [Apr 19 22:37:05] WARNING[18366]: res_odbc.c:761 ast_odbc_sanity_check: Connection is down attempting to reconnect... [Apr 19 22:37:05] NOTICE[18366]: res_odbc.c:1527 odbc_obj_connect: Connecting asterisk [Apr 19 22:37:05] NOTICE[18366]: res_odbc.c:1559 odbc_obj_connect: res_odbc: Connected to asterisk [asterisk-connector] [Apr 19 22:37:05] WARNING[18366]: 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 22:37:05] WARNING[18366]: res_odbc.c:657 ast_odbc_prepare_and_execute: SQL Execute error -1! Verifying connection to asterisk [asterisk-connector]... [Apr 19 22:37:05] WARNING[18366]: res_odbc.c:761 ast_odbc_sanity_check: Connection is down attempting to reconnect... [Apr 19 22:37:05] NOTICE[18366]: res_odbc.c:1527 odbc_obj_connect: Connecting asterisk [Apr 19 22:37:05] NOTICE[18366]: res_odbc.c:1559 odbc_obj_connect: res_odbc: Connected to asterisk [asterisk-connector] The following error suggests that my syntax is incorrect, that syntax seems to be part of an SQL query. I do not have any SQL queries anywhere within my configuration. 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
[asterisk-users] Fw: Dynamic realtime + queues
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 To: Tommy Cooper ; Asterisk Users Mailing List - Non-Commercial Discussion 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: Conne
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 To: Tommy Cooper ; Asterisk Users Mailing List - Non-Commercial Discussion 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 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
[asterisk-users] Dynamic realtime + queues
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) - Forwarded Message - From: Leandro Dardini To: Tommy Cooper ; Asterisk Users Mailing List - Non-Commercial Discussion Sent: Thursday, April 18, 2013 11:04 PM Subject: Re: [asterisk-users] Dynamic realtime + queues You need a "name" column. This is my queue table: CREATE TABLE IF NOT EXISTS `queue` ( `name` varchar(128) NOT NULL, `musiconhold` varchar(128) DEFAULT NULL, `announce` varchar(128) DEFAULT NULL, `context` varchar(128) DEFAULT NULL, `timeout` int(11) DEFAULT NULL, `monitor_join` tinyint(1) DEFAULT NULL, `monitor_format` varchar(128) DEFAULT NULL, `queue_youarenext` varchar(128) DEFAULT NULL, `queue_thereare` varchar(128) DEFAULT NULL, `queue_callswaiting` varchar(128) DEFAULT NULL, `queue_holdtime` varchar(128) DEFAULT NULL, `queue_minutes` varchar(128) DEFAULT NULL, `queue_seconds` varchar(128) DEFAULT NULL, `queue_lessthan` varchar(128) DEFAULT NULL, `queue_thankyou`
[asterisk-users] Dynamic realtime + queues
Hi, I am trying to store queues.conf to a MySQL database using dynamic realtime. I have a working ODBC connection and the queueing system already works but I want to store the queues.conf file to a database. I am following the guide from Asterisk the definitive guide, the ebook can be found at: http://ofps.oreilly.com/titles/9781449332426/asterisk-DB.html I have a database called asterisk which contains 2 main tables: Queues and queue_member_table, both tables have sample data. mysql> select * from queue_member_table; +--+++---+-++ | uniqueid | membername | queue_name | interface | penalty | paused | +--+++---+-++ | 1 | SIP/1000 | support | SIP/1000 | NULL | 0 | +--+++---+-++ SQL> select QueueID,name,strategy from Queues; |QueueID| name strategy 1 support rrmemory There are more fields but these are the most important I keep getting this error: node1*CLI> queue show No queues. [Apr 18 22:41:06] WARNING[18599]: 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 18 22:41:06] WARNING[18599]: res_odbc.c:657 ast_odbc_prepare_and_execute: SQL Execute error -1! Verifying connection to asterisk [asterisk-connector]... [Apr 18 22:41:06] WARNING[18599]: res_odbc.c:761 ast_odbc_sanity_check: Connection is down attempting to reconnect... [Apr 18 22:41:06] NOTICE[18599]: res_odbc.c:1527 odbc_obj_connect: Connecting asterisk [Apr 18 22:41:06] NOTICE[18599]: res_odbc.c:1559 odbc_obj_connect: res_odbc: Connected to asterisk [asterisk-connector] [Apr 18 22:41:06] WARNING[18599]: 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 18 22:41:06] WARNING[18599]: res_odbc.c:657 ast_odbc_prepare_and_execute: SQL Execute error -1! Verifying connection to asterisk [asterisk-connector]... [Apr 18 22:41:06] WARNING[18599]: res_odbc.c:761 ast_odbc_sanity_check: Connection is down attempting to reconnect... [Apr 18 22:41:06] NOTICE[18599]: res_odbc.c:1527 odbc_obj_connect: Connecting asterisk [Apr 18 22:41:06] NOTICE[18599]: res_odbc.c:1559 odbc_obj_connect: res_odbc: Connected to asterisk [asterisk-connector] extensions.conf: [general] autofallthrough=yes [default] exten => 1000,1, Dial (SIP/1000) exten => 1001,1, Dial (SIP/1001) [Queues] exten => 1000,1,Verbose(1,Call entering queue named ${support) same => n,Set(QueueParameters=${GET_QUEUE_DETAILS(support)}) same => n,Queue(${QueueParameters}) [LocalSets] include => Queues [sip-phone] ;This is the context setup for outgoing calls exten => _3.,1,Dial(SIP/myprovider/${EXTEN:1},60) ;working config [from-myprovider] ;This is the context setup for incoming calls exten => *mynumber*,1,Answer exten => *mynumber*,2,Queue(support) exten => *mynumber*,4,Hangup queues.conf [general] autofill=yes ; distribute all waiting callers to available members shared_lastcall=yes ; respect the wrapup time for members logged into more ; than one queue realtime_family = queue, Queues Thank you and sorry for the long post-- _ -- 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
[asterisk-users] Dynamic realtime + queues
Hi, I am trying to store queues.conf to a MySQL database using dynamic realtime. I have a working ODBC connection and the queueing system already works but I want to store the queues.conf file to a database. I am following the guide from Asterisk the definitive guide, the ebook can be found at: http://ofps.oreilly.com/titles/9781449332426/asterisk-DB.html I have a database called asterisk which contains 2 main tables: Queues and queue_member_table, both tables have sample data. mysql> select * from queue_member_table; +--+++---+-++ | uniqueid | membername | queue_name | interface | penalty | paused | +--+++---+-++ | 1 | SIP/1000 | support | SIP/1000 | NULL | 0 | +--+++---+-++ SQL> select QueueID,name,strategy from Queues; |QueueID| name strategy 1 support rrmemory There are more fields but these are the most important I keep getting this error: node1*CLI> queue show No queues. [Apr 18 22:41:06] WARNING[18599]: 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 18 22:41:06] WARNING[18599]: res_odbc.c:657 ast_odbc_prepare_and_execute: SQL Execute error -1! Verifying connection to asterisk [asterisk-connector]... [Apr 18 22:41:06] WARNING[18599]: res_odbc.c:761 ast_odbc_sanity_check: Connection is down attempting to reconnect... [Apr 18 22:41:06] NOTICE[18599]: res_odbc.c:1527 odbc_obj_connect: Connecting asterisk [Apr 18 22:41:06] NOTICE[18599]: res_odbc.c:1559 odbc_obj_connect: res_odbc: Connected to asterisk [asterisk-connector] [Apr 18 22:41:06] WARNING[18599]: 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 18 22:41:06] WARNING[18599]: res_odbc.c:657 ast_odbc_prepare_and_execute: SQL Execute error -1! Verifying connection to asterisk [asterisk-connector]... [Apr 18 22:41:06] WARNING[18599]: res_odbc.c:761 ast_odbc_sanity_check: Connection is down attempting to reconnect... [Apr 18 22:41:06] NOTICE[18599]: res_odbc.c:1527 odbc_obj_connect: Connecting asterisk [Apr 18 22:41:06] NOTICE[18599]: res_odbc.c:1559 odbc_obj_connect: res_odbc: Connected to asterisk [asterisk-connector] extensions.conf: [general] autofallthrough=yes [default] exten => 1000,1, Dial (SIP/1000) exten => 1001,1, Dial (SIP/1001) [Queues] exten => 1000,1,Verbose(1,Call entering queue named ${support) same => n,Set(QueueParameters=${GET_QUEUE_DETAILS(support)}) same => n,Queue(${QueueParameters}) [LocalSets] include => Queues [sip-phone] ;This is the context setup for outgoing calls exten => _3.,1,Dial(SIP/myprovider/${EXTEN:1},60) ;working config [from-myprovider] ;This is the context setup for incoming calls exten => *mynumber*,1,Answer exten => *mynumber*,2,Queue(support) exten => *mynumber*,4,Hangup queues.conf [general] autofill=yes ; distribute all waiting callers to available members shared_lastcall=yes ; respect the wrapup time for members logged into more ; than one queue realtime_family = queue, Queues Thank you and sorry for the long post-- _ -- 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
Re: [asterisk-users] ACD problem & outbound calls
Thank you for your prompt reply. I removed that redundant line and now everything seems to work fine. Except outgoing calls that is, whenever i try to call an outside number the phone rings, the user can even answer back but then it hangs up after about 5 sec. extensions.conf: [sip-phone] ;This is the context setup for outgoing calls;exten => _NXXX.,2,Set(CALLERID(name)=*my number*) ;exten => _NXXX.,3,Set(CALLERID(num)=*my number*) ;exten => _NXX,1,Dial(mailto:SIP/$%7bexten...@myprovider.com) ;exten => _3.,1,Answer exten => _3.,1,Dial(SIP/myprovider/${EXTEN:1},60) ;This is the only line that seems to work but the phone hangs up shortly after answering, as described above ;exten => _3.,5,Hangup ;exten => _X.,1,Answer ;exten => _X.,2,Set(CALLERID(name)=*my number*) ;exten => _X.,3,Set(CALLERID(num)=*my number*) ;exten => _X.,4,Dial(SIP/${EXTEN}@myprovider,30,Tt) ;exten => _X.,5,Hangup ____ From: Salman Zafar To: Tommy Cooper ; Asterisk Users Mailing List - Non-Commercial Discussion Sent: Wednesday, April 10, 2013 10:27 PM Subject: Re: [asterisk-users] ACD problem This line : exten => *DID number*,2,Dial(SIP/1000) is redundant and useless when you are already using Queues. So just remove it and it should work. What happen is, your dial-plan executes at 2nd priority DIAL a SIP extension 1000 .. produce a call and at hang-up finishes no Queue/ACD functionality is executed. On Thu, Apr 11, 2013 at 1:08 AM, Tommy Cooper wrote: Hi, > >I am working on a small inbound call center solution that uses an ACD system. >I might add an IVR system later on. I only have 2 extensions set up >(extensions 1000 and 1001), I want the system to put new calls in a queue if >both extensions are busy. I am currently subscribed with a SIP trunk provider >and can successfully recieve calls. I want to design a system where customers >can call my number, that call will then be directed to either extension 1000 >or 1001. If both extensions are in use, I want that 3rd call to be queued. > >I don't think that the config below will direct calls to extension 1001 >because the second line states that any incomming calls should be routed to >extension 1000. How do I change this so that calls are directed to all of my >exensions? > > >extensions.conf >[from-myprovider] >exten => *DID number*,1,Answer >exten => *DID number*,2,Dial(SIP/1000) >exten => *DID number*,3,Queue(support) ;not sure if this line belongs here >exten => *DID number*,4,Hangup > >queues.conf > >[general] >[support] > >musicclass=default >strategy=rrmemory >joinempty=no >leavewhenempty=yes >ringinuse=no >Member => SIP/1000 >Member => SIP/1001 > >agent => 1000,1000 >agent => 1001,1001 > >When using the current config the caller will listen to the 'music on hold' >until the agent answers but calls are only being forwarded to extension 1000 >as stated above > >-- >_ >-- 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 > -- Regards ** Muhammad Salman *** -- _ -- 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
[asterisk-users] ACD problem
Hi, I am working on a small inbound call center solution that uses an ACD system. I might add an IVR system later on. I only have 2 extensions set up (extensions 1000 and 1001), I want the system to put new calls in a queue if both extensions are busy. I am currently subscribed with a SIP trunk provider and can successfully recieve calls. I want to design a system where customers can call my number, that call will then be directed to either extension 1000 or 1001. If both extensions are in use, I want that 3rd call to be queued. I don't think that the config below will direct calls to extension 1001 because the second line states that any incomming calls should be routed to extension 1000. How do I change this so that calls are directed to all of my exensions? extensions.conf [from-myprovider] exten => *DID number*,1,Answer exten => *DID number*,2,Dial(SIP/1000) exten => *DID number*,3,Queue(support) ;not sure if this line belongs here exten => *DID number*,4,Hangup queues.conf [general] [support] musicclass=default strategy=rrmemory joinempty=no leavewhenempty=yes ringinuse=no Member => SIP/1000 Member => SIP/1001 agent => 1000,1000 agent => 1001,1001 When using the current config the caller will listen to the 'music on hold' until the agent answers but calls are only being forwarded to extension 1000 as stated above -- _ -- 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