duane.larson at gmail.com
2010-Dec-26 23:01 UTC
[asterisk-users] Asterisk 1.8 Realtime Queue not working
I have configured my mysql database by following this link
http://www.voip-info.org/wiki/view/Asterisk+RealTime+Queue
The only difference is that I am using ODBC instead of MySQL with Realtime.
Within extensions.conf I have the following for my queue
exten => 9**2**1611,1,Answer
exten => 9**2**1611,2,Queue(irock.com,tT,,,300)
exten => *50,1,Answer
exten => *50,n,Macro(queue-login,${EXTEN},${EXTEN:0:4})
exten => *50,n,Hangup
exten => *51,1,Answer
exten => *51,n,Macro(queue-logout,${EXTEN},${EXTEN:0:4})
exten => *51,n,Hangup
[macro-queue-login]
exten => s,1,Set(agent=${EXTEN:4})
exten => s,n,Set(queue=irock.com)
exten => s,n,NoOp(Queue login agent ${EXTEN:4} to queue ${phone});
exten => s,n,AddQueueMember(${queue});
exten => s,n,Playback(agent-loginok)
[macro-queue-logout]
exten => s,1,Set(agent=${EXTEN:4})
exten => s,n,Set(queue=irock.com)
exten => s,n,NoOp(Queue logout agent ${EXTEN:4} from queue ${phone});
exten => s,n,RemoveQueueMember(${queue});
exten => s,n,Playback(agent-loggedoff)
When I call 9**2**1611 I get the following error when debugging
-- Goto (irock.com,9012211611,1)
-- Executing [9012211611 at irock.com:1]
Answer("SIP/9012732004-00000001", "")
in new stack
-- Executing [9012211611 at irock.com:2]
Queue("SIP/9012732004-00000001", "irock.com,tT,,,300") in
new stack
[Dec 26 16:39:57] WARNING[5264]: app_queue.c:5732 queue_exec: Unable to
join queue 'irock.com'
-- Executing [9012211611 at irock.com:3]
GotoIf("SIP/9012732004-00000001", "irock.com !=
irock.com?irock.com,9012211611,1") in new stack
If I do a "show queue" I don't see the irock.com queue
Here is what I have in my MySQL database
+------------+-------------+----------+-----------+---------+--------------+----------------+------------------+----------------+--------------------+----------------+---------------+---------------+----------------+----------------+------------------+--------------------+------------------------+-------------------+-------+------------+--------+--------------+-------------+-----------+----------------+-------------------+-----------------+----------------+-------------+--------+----------------+-----------+-----------------+
| name | musiconhold | announce | context | timeout | monitor_join |
monitor_format | queue_youarenext | queue_thereare | queue_callswaiting |
queue_holdtime | queue_minutes | queue_seconds | queue_lessthan |
queue_thankyou | queue_reporthold | announce_frequency |
announce_round_seconds | announce_holdtime | retry | wrapuptime | maxlen |
servicelevel | strategy | joinempty | leavewhenempty | eventmemberstatus |
eventwhencalled | reportholdtime | memberdelay | weight | timeoutrestart |
ringinuse | setinterfacevar |
+------------+-------------+----------+-----------+---------+--------------+----------------+------------------+----------------+--------------------+----------------+---------------+---------------+----------------+----------------+------------------+--------------------+------------------------+-------------------+-------+------------+--------+--------------+-------------+-----------+----------------+-------------------+-----------------+----------------+-------------+--------+----------------+-----------+-----------------+
| 9**2**1611 | NULL | NULL | irock.com | NULL | NULL | NULL |
queue-youarenext | queue-thereare | queue-callswaiting | queue-holdtime |
queue-minutes | queue-seconds | NULL | queue-thankyou | queue-reporthold |
30 | NULL | yes | NULL | NULL | NULL | NULL | leastrecent | yes | no | NULL
| NULL | NULL | NULL | NULL | NULL | 0 | NULL |
+------------+-------------+----------+-----------+---------+--------------+----------------+------------------+----------------+--------------------+----------------+---------------+---------------+----------------+----------------+------------------+--------------------+------------------------+-------------------+-------+------------+--------+--------------+-------------+-----------+----------------+-------------------+-----------------+----------------+-------------+--------+----------------+-----------+-----------------+
My other realtime stuff like sipusers and vmusers works just fine.
extconfig.conf
; Primary Database Connection
sipusers => odbc,proxy01,sipusers,1
sippeers => odbc,proxy01,sipusers,1
voicemail => odbc,proxy01,vmusers,1
meetme => odbc,proxy01,meetme,1
queues => odbc,proxy01,queue_table,1
queue_members => odbc,proxy01,queue_member_table,1
extensions => odbc,proxy01,extensions,1
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
<http://lists.digium.com/pipermail/asterisk-users/attachments/20101226/aad633ff/attachment.htm>
Sherwood McGowan
2010-Dec-27 01:02 UTC
[asterisk-users] Asterisk 1.8 Realtime Queue not working
On Sun, Dec 26, 2010 at 5:01 PM, <duane.larson at gmail.com> wrote:> I have configured my mysql database by following this link > http://www.voip-info.org/wiki/view/Asterisk+RealTime+Queue > The only difference is that I am using ODBC instead of MySQL with Realtime. > > Within extensions.conf I have the following for my queue > > exten => 9**2**1611,1,Answer > exten => 9**2**1611,2,Queue(irock.com,tT,,,300) > > > exten => *50,1,Answer > exten => *50,n,Macro(queue-login,${EXTEN},${EXTEN:0:4}) > exten => *50,n,Hangup > > exten => *51,1,Answer > exten => *51,n,Macro(queue-logout,${EXTEN},${EXTEN:0:4}) > exten => *51,n,Hangup > > > [macro-queue-login] > exten => s,1,Set(agent=${EXTEN:4}) > exten => s,n,Set(queue=irock.com) > exten => s,n,NoOp(Queue login agent ${EXTEN:4} to queue ${phone}); > exten => s,n,AddQueueMember(${queue}); > exten => s,n,Playback(agent-loginok) > > [macro-queue-logout] > exten => s,1,Set(agent=${EXTEN:4}) > exten => s,n,Set(queue=irock.com) > exten => s,n,NoOp(Queue logout agent ${EXTEN:4} from queue ${phone}); > exten => s,n,RemoveQueueMember(${queue}); > exten => s,n,Playback(agent-loggedoff) > > > When I call 9**2**1611 I get the following error when debugging > > -- Goto (irock.com,9012211611,1) > -- Executing [9012211611 at irock.com:1] Answer("SIP/9012732004-00000001", "") > in new stack > -- Executing [9012211611 at irock.com:2] Queue("SIP/9012732004-00000001", > "irock.com,tT,,,300") in new stack > [Dec 26 16:39:57] WARNING[5264]: app_queue.c:5732 queue_exec: Unable to join > queue 'irock.com' > -- Executing [9012211611 at irock.com:3] GotoIf("SIP/9012732004-00000001", > "irock.com != irock.com?irock.com,9012211611,1") in new stack > > > If I do a "show queue" I don't see the irock.com queue > > Here is what I have in my MySQL database > +------------+-------------+----------+-----------+---------+--------------+----------------+------------------+----------------+--------------------+----------------+---------------+---------------+----------------+----------------+------------------+--------------------+------------------------+-------------------+-------+------------+--------+--------------+-------------+-----------+----------------+-------------------+-----------------+----------------+-------------+--------+----------------+-----------+-----------------+ > | name | musiconhold | announce | context | timeout | monitor_join | > monitor_format | queue_youarenext | queue_thereare | queue_callswaiting | > queue_holdtime | queue_minutes | queue_seconds | queue_lessthan | > queue_thankyou | queue_reporthold | announce_frequency | > announce_round_seconds | announce_holdtime | retry | wrapuptime | maxlen | > servicelevel | strategy | joinempty | leavewhenempty | eventmemberstatus | > eventwhencalled | reportholdtime | memberdelay | weight | timeoutrestart | > ringinuse | setinterfacevar | > +------------+-------------+----------+-----------+---------+--------------+----------------+------------------+----------------+--------------------+----------------+---------------+---------------+----------------+----------------+------------------+--------------------+------------------------+-------------------+-------+------------+--------+--------------+-------------+-----------+----------------+-------------------+-----------------+----------------+-------------+--------+----------------+-----------+-----------------+ > | 9**2**1611 | NULL | NULL | irock.com | NULL | NULL | NULL | > queue-youarenext | queue-thereare | queue-callswaiting | queue-holdtime | > queue-minutes | queue-seconds | NULL | queue-thankyou | queue-reporthold | > 30 | NULL | yes | NULL | NULL | NULL | NULL | leastrecent | yes | no | NULL > | NULL | NULL | NULL | NULL | NULL | 0 | NULL | > +------------+-------------+----------+-----------+---------+--------------+----------------+------------------+----------------+--------------------+----------------+---------------+---------------+----------------+----------------+------------------+--------------------+------------------------+-------------------+-------+------------+--------+--------------+-------------+-----------+----------------+-------------------+-----------------+----------------+-------------+--------+----------------+-----------+-----------------+ > > > > My other realtime stuff like sipusers and vmusers works just fine. > > extconfig.conf > ; Primary Database Connection > sipusers => odbc,proxy01,sipusers,1 > sippeers => odbc,proxy01,sipusers,1 > voicemail => odbc,proxy01,vmusers,1 > meetme => odbc,proxy01,meetme,1 > queues => odbc,proxy01,queue_table,1 > queue_members => odbc,proxy01,queue_member_table,1 > extensions => odbc,proxy01,extensions,1 > -- > _____________________________________________________________________ > -- 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 >What does res_config_mysql.conf have in it?