[asterisk-users] Official Documentation for Asterisk 1.6 Realtime ODBC Tables

Brett Woollum brett at woollum.com
Fri Nov 12 07:34:03 CST 2010


Hi Brad, 

I did notice that bug in the bug tracker. That's different from the behavior I am seeing. I don't get multiple values in the "Mailbox". I just upgraded to 1.6.2.14 and it's still there. 

By the way, the quantity of SIP NOTIFY's generated is significant. It appears to be way more that the number of peers I have (3) times a handful of duplicates per peer. I've been doing a Wireshark capture, and it appears as though any time there is a new message in the ODBC voicemail store for a mailbox that has been subscribed to, Asterisk continually generates as many of the messages as possible. At one point I noticed my CPU jump from 0% to ~50% just by moving one message from an mailbox that hadn't been subscribed to to a mailbox that was subscribed to by the 3 peers. It only came back to ~0-1% by moving the message back to an unsubscribed user. 

When I set rtcachefriends = yes in sip.conf, I get the following for each peer: 

ast01*CLI> sip show peer 412 


* Name : 412 
Realtime peer: Yes, cached 
Secret : <Set> 
MD5Secret : <Not set> 
Remote Secret: <Not set> 
Context : sipphones 
Subscr.Cont. : blf_subscriptions 
Language : en 
AMA flags : Unknown 
Transfer mode: open 
CallingPres : Presentation Allowed, Not Screened 
Callgroup : 
Pickupgroup : 
Mailbox : vm_bob at default 
VM Extension : asterisk 
LastMsgsSent : 32767/65535 
Call limit : 0 
Dynamic : Yes 
Callerid : "" <> 
MaxCallBR : 384 kbps 
Expire : 69 
Insecure : no 
Nat : RFC3581 
ACL : No 
T.38 support : No 
T.38 EC mode : Unknown 
T.38 MaxDtgrm: -1 
DirectMedia : Yes 
PromiscRedir : No 
User=Phone : No 
Video Support: No 
Text Support : No 
Ign SDP ver : No 
Trust RPID : No 
Send RPID : No 
Subscriptions: Yes 
Overlap dial : Yes 
Forward Loop : Yes 
DTMFmode : rfc2833 
Timer T1 : 500 
Timer B : 32000 
ToHost : 
Addr->IP : 10.20.1.225 Port 5064 
Defaddr->IP : 0.0.0.0 Port 5060 
Prim.Transp. : UDP 
Allowed.Trsp : UDP 
Def. Username: 412 
SIP Options : (none) 
Codecs : 0x1004 (ulaw|g722) 
Codec Order : (g722:20,ulaw:20) 
Auto-Framing : No 
100 on REG : Yes 
Status : Unmonitored 
Useragent : Yealink SIP-T28P 2.50.0.52 
Reg. Contact : sip:412 at 10.20.1.225:5064 
Qualify Freq : 120000 ms 
Sess-Timers : Accept 
Sess-Refresh : uas 
Sess-Expires : 1800 secs 
Min-Sess : 90 secs 
Parkinglot : 

This is Asterisk 1.6.2.14 using the ODBC store for voicemail and ODBC for sip_peers. 


Brett Woollum 
Brett at Woollum.com 


----- Original Message ----- 
From: "Bradley Watkins" <Bradley.Watkins at compuware.com> 
To: "Asterisk Users Mailing List - Non-Commercial Discussion" <asterisk-users at lists.digium.com> 
Sent: Friday, November 12, 2010 5:14:49 AM GMT -08:00 US/Canada Pacific 
Subject: Re: [asterisk-users] Official Documentation for Asterisk 1.6 Realtime ODBC Tables 



>-----Original Message----- 
>From: asterisk-users-bounces at lists.digium.com 
>[mailto:asterisk-users-bounces at lists.digium.com] On Behalf Of 
>Paul Belanger 
>Sent: Friday, November 12, 2010 7:58 AM 
>To: Asterisk Users Mailing List - Non-Commercial Discussion 
>Subject: Re: [asterisk-users] Official Documentation for 
>Asterisk 1.6 Realtime ODBC Tables 
> 
>On Fri, Nov 12, 2010 at 6:07 AM, Brett Woollum 
><brett at woollum.com> wrote: 
>> I'm having an issue where Asterisk continuously sends out a 
>GAZILLION 
>> "SIP NOTIFY" messages when a user has a voice message in 
>their INBOX. 
>> This issue is only present when my SIP users and peers are 
>configured 
>> from my ODBC backend (MySQL). A static configuration of users in 
>> sip.conf resolves this and everything works fine. 
>> 
>What version of 1.6? I _think_ this may have been a bug, that 
>was fixed. 
> 
>Don't hold me to that. 

I agree with Paul, this sounds like a bugs that's been fixed. 

What does the 'Mailbox :' line look like when you do a 'sip show peers'? 

My guess is that there will be multiple entries of the same mailbox, and 
that's why you're receiving a bunch of NOTIFY messages. 

- Brad 

-- 
_____________________________________________________________________ 
-- 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 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20101112/12f8055d/attachment.htm 


More information about the asterisk-users mailing list