Re: [asterisk-users] Asterisk 1.8 Realtime Queue not working

2010-12-26 Thread Sherwood McGowan
On Sun, Dec 26, 2010 at 5:01 PM,   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 [9012211...@irock.com:1] Answer("SIP/9012732004-0001", "")
> in new stack
> -- Executing [9012211...@irock.com:2] Queue("SIP/9012732004-0001",
> "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 [9012211...@irock.com:3] GotoIf("SIP/9012732004-0001",
> "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:
>   h

[asterisk-users] Asterisk 1.8 Realtime Queue not working

2010-12-26 Thread duane . larson

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 [9012211...@irock.com:1] Answer("SIP/9012732004-0001", "")  
in new stack
-- Executing [9012211...@irock.com:2]  
Queue("SIP/9012732004-0001", "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 [9012211...@irock.com:3]  
GotoIf("SIP/9012732004-0001", "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