I have configured my mysql database by following this link
<br />http://www.voip-info.org/wiki/view/Asterisk+RealTime+Queue
<br />The only difference is that I am using ODBC instead of MySQL with Realtime.
<br />
<br />Within extensions.conf I have the following for my queue
<br />
<br />exten => 9**2**1611,1,Answer
<br />exten => 9**2**1611,2,Queue(irock.com,tT,,,300)
<br />
<br />
<br />exten => *50,1,Answer
<br />exten => *50,n,Macro(queue-login,${EXTEN},${EXTEN:0:4})
<br />exten => *50,n,Hangup
<br />
<br />exten => *51,1,Answer
<br />exten => *51,n,Macro(queue-logout,${EXTEN},${EXTEN:0:4})
<br />exten => *51,n,Hangup
<br />
<br />
<br />[macro-queue-login]
<br />exten => s,1,Set(agent=${EXTEN:4})
<br />exten => s,n,Set(queue=irock.com)
<br />exten => s,n,NoOp(Queue login agent ${EXTEN:4} to queue ${phone});
<br />exten => s,n,AddQueueMember(${queue});
<br />exten => s,n,Playback(agent-loginok)
<br />
<br />[macro-queue-logout]
<br />exten => s,1,Set(agent=${EXTEN:4})
<br />exten => s,n,Set(queue=irock.com)
<br />exten => s,n,NoOp(Queue logout agent ${EXTEN:4} from queue ${phone});
<br />exten => s,n,RemoveQueueMember(${queue});
<br />exten => s,n,Playback(agent-loggedoff)
<br />
<br />
<br />When I call 9**2**1611 I get the following error when debugging
<br />
<br /> -- Goto (irock.com,9012211611,1)
<br /> -- Executing [9012211611@irock.com:1] Answer("SIP/9012732004-00000001", "") in new stack
<br /> -- Executing [9012211611@irock.com:2] Queue("SIP/9012732004-00000001", "irock.com,tT,,,300") in new stack
<br />[Dec 26 16:39:57] WARNING[5264]: app_queue.c:5732 queue_exec: Unable to join queue 'irock.com'
<br /> -- Executing [9012211611@irock.com:3] GotoIf("SIP/9012732004-00000001", "irock.com != irock.com?irock.com,9012211611,1") in new stack
<br />
<br />
<br />If I do a "show queue" I don't see the irock.com queue
<br />
<br />Here is what I have in my MySQL database
<br />+------------+-------------+----------+-----------+---------+--------------+----------------+------------------+----------------+--------------------+----------------+---------------+---------------+----------------+----------------+------------------+--------------------+------------------------+-------------------+-------+------------+--------+--------------+-------------+-----------+----------------+-------------------+-----------------+----------------+-------------+--------+----------------+-----------+-----------------+
<br />| 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 |
<br />+------------+-------------+----------+-----------+---------+--------------+----------------+------------------+----------------+--------------------+----------------+---------------+---------------+----------------+----------------+------------------+--------------------+------------------------+-------------------+-------+------------+--------+--------------+-------------+-----------+----------------+-------------------+-----------------+----------------+-------------+--------+----------------+-----------+-----------------+
<br />| 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 |
<br />+------------+-------------+----------+-----------+---------+--------------+----------------+------------------+----------------+--------------------+----------------+---------------+---------------+----------------+----------------+------------------+--------------------+------------------------+-------------------+-------+------------+--------+--------------+-------------+-----------+----------------+-------------------+-----------------+----------------+-------------+--------+----------------+-----------+-----------------+
<br />
<br />
<br />
<br />My other realtime stuff like sipusers and vmusers works just fine.
<br />
<br />extconfig.conf
<br />; Primary Database Connection
<br />sipusers => odbc,proxy01,sipusers,1
<br />sippeers => odbc,proxy01,sipusers,1
<br />voicemail => odbc,proxy01,vmusers,1
<br />meetme => odbc,proxy01,meetme,1
<br />queues => odbc,proxy01,queue_table,1
<br />queue_members => odbc,proxy01,queue_member_table,1
<br />extensions => odbc,proxy01,extensions,1