[Asterisk-Users] Extensions - Realtime

[Matthew Boehm]

The wiki doc's are correct. You are trying to combine two different methods
of pulling RealTime extensions and that is why it isn't working as you are
expecting.

Pick 1 method and all will be revealed. Both are very simple to do.

-Matthew

> From: Flobi <flobi.com at gmail.com>
> Reply-To: <flobi at flobi.com>, Asterisk Users Mailing List - Non-Commercial
> Discussion <asterisk-users at lists.digium.com>
> Date: Wed, 7 Sep 2005 13:00:26 -0400
> To: Asterisk Users Mailing List - Non-Commercial Discussion
> <asterisk-users at lists.digium.com>
> Subject: Re: [Asterisk-Users] Extensions - Realtime
> 
> Nevermind, I figured out that the table is used way differently when
> doing static.  Here's my fixed table.  I'll try to explain this in the
> voip-info doc.
> 
>   id  cat_metric  var_metric  commented  filename  category  var_name  var_val
>       1 0 0 0 extensions.conf default exten _.,1,NoOp(Testing)
> 
> 
> On 9/7/05, Flobi <flobi.com at gmail.com> wrote:
>> Okay, after noticing an error on this mysql statement after i switched to
>> odbc:
>> SELECT * FROM
>> pbx_realtime_extensions
>> WHERE filename='extensions.conf' and commented=0
>> ORDER BY filename,cat_metric desc,var_metric asc,category,var_name,var_val,id
>> 
>> I added those fields and reloaded...* immediately crashed.  I
>> restarted.  Now, I'm getting this:
>> *CLI> show dialplan
>> [ Context 'NoOp' created by 'pbx_config' ]
>> 
>> [ Context 'parkedcalls' created by 'res_features' ]
>>  '700' =>          1. Park()
>> [res_features]
>> 
>> -= 1 extensions (1 priorities) in 2 contexts. =-
>> 
>> 
>> out of this table:
>>  id  name  context  exten  priority  app  appdata  filename
>> commented  cat_metric  var_metric  category  var_name  var_val
>>      1 default default _. 1 NoOp Testing. extensions.conf 0 NULL NULL
>> NULL NULL NULL
>> 
>> 
>> On 9/7/05, Flobi <flobi.com at gmail.com> wrote:
>>> Okay, this doesn't seem to be working.  I've gone and deleted my ael
>>> file also.  I do know my MySQL is set up cause I have my sip, iax and
>>> voicemail going through it too.
>>> 
>>> here's the line in extconfig.conf:
>>> [settings]
>>> extensions.conf => mysql,asterisk,pbx_realtime_extensions
>>> 
>>> 
>>> in pbx_realtime_extensions, my db table:
>>> id  name  context  exten  priority  app  appdata
>>> 1  default  default  _.  1  NoOp  Testing
>>> 
>>> 
>>> CLI> show dialplan
>>> [ Context 'parkedcalls' created by 'res_features' ]
>>>  '700' =>          1. Park()
>>> [res_features]
>>> 
>>> -= 1 extensions (1 priorities) in 1 contexts. =-
>>> 
>>> And when I try to call, I get:
>>> Sep  7 12:16:30 NOTICE[14330]: chan_iax2.c:7052 socket_read: Rejected
>>> connect attempt from 206.180.254.97, request '29 at default' does not
>>> exist
>>> 
>>> Also, this message keeps popping up even when calls aren't going through:
>>> Sep  7 12:15:12 NOTICE[14330]: pbx.c:1688 pbx_extension_helper: Cannot
>>> find extension context 'default'
>>> 
>>> 
>>> On 9/7/05, Flobi <flobi.com at gmail.com> wrote:
>>>> 
>>>> It states that the conf file overrides the static db info, but what about
>>>> the ael file?  Does that override also?
>>>> 
>>>> BTW, "RealTime Static"...talk about oxymoron :-)  Gotta love it!
>>>> 
>>>> Flobi
>>>> 
>>>> 
>>>> On 9/7/05, Matthew Boehm <mboehm at cytelcom.com> wrote:
>>>>>> CVS HEAD/Asterisk 1.2: Is there a way to have the entire
>>>>>> extensions.conffile coming from the realtime?
>>>>> 
>>>>>    Yes. Go read the wiki on RealTime Static.
>>>>> 
>>>>> -Matthew
>>>>> 
>>>>> 
>>>>> _______________________________________________
>>>>> --Bandwidth and Colocation sponsored by Easynews.com --
>>>>> 
>>>>> Asterisk-Users mailing list
>>>>> Asterisk-Users at lists.digium.com
>>>>> http://lists.digium.com/mailman/listinfo/asterisk-users
>>>>> To UNSUBSCRIBE or update options visit:
>>>>>   http://lists.digium.com/mailman/listinfo/asterisk-users
>>>>> 
>>>> 
>>>> 
>>>> 
>>>> 
>>>> --
>>>> Automated Signature: This message is from Flobi of Flobi.com.
>>>> Visit my website if you like: http://www.flobi.com/
>>>> 
>>>> Please remember to tip your waitress and bartender.  They are doing their
>>>> best to serve you and your indignant, malcontent attitude.
>>>> --
>>> 
>>> 
>>> 
>>> --
>>> Automated Signature: This message is from Flobi of Flobi.com.
>>> Visit my website if you like: http://www.flobi.com/
>>> 
>>> Please remember to tip your waitress and bartender.  They are doing
>>> their best to serve you and your indignant, malcontent attitude.
>>> --
>>> 
>> 
>> 
>> --
>> Automated Signature: This message is from Flobi of Flobi.com.
>> Visit my website if you like: http://www.flobi.com/
>> 
>> Please remember to tip your waitress and bartender.  They are doing
>> their best to serve you and your indignant, malcontent attitude.
>> --
>> 
> 
> 
> -- 
> Automated Signature: This message is from Flobi of Flobi.com.
> Visit my website if you like: http://www.flobi.com/
> 
> Please remember to tip your waitress and bartender.  They are doing
> their best to serve you and your indignant, malcontent attitude.
> --
> _______________________________________________
> --Bandwidth and Colocation sponsored by Easynews.com --
> 
> Asterisk-Users mailing list
> Asterisk-Users at lists.digium.com
> http://lists.digium.com/mailman/listinfo/asterisk-users
> To UNSUBSCRIBE or update options visit:
>    http://lists.digium.com/mailman/listinfo/asterisk-users