<html><head><style type='text/css'>p { margin: 0; }</style></head><body><div style='font-family: Arial, Helvetica, sans-serif; font-size: 12pt; color: #000000'>More information: When I have "rtcachefriends = yes" in sip.conf, everything seems fine. With "rtcachefriends = no" I see this behavior. <br><br>I'd rather not cache. I'm aiming for as near real-time as possible. <br><br>Any thoughts?<br><br><div><span style="font-family: arial,helvetica,sans-serif;">Brett Woollum</span><br style="font-family: arial,helvetica,sans-serif;"><span style="font-family: arial,helvetica,sans-serif;">Brett@Woollum.com</span><br></div><br><br>----- Original Message -----<br>From: "Brett Woollum" <brett@woollum.com><br>To: "Asterisk Users Mailing List - Non-Commercial Discussion" <asterisk-users@lists.digium.com><br>Sent: Friday, November 12, 2010 5:34:03 AM GMT -08:00 US/Canada Pacific<br>Subject: Re: [asterisk-users] Official Documentation for Asterisk 1.6 Realtime ODBC Tables<br><br><style>p { margin: 0; }</style><div style="font-family: Arial,Helvetica,sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">Hi Brad,<br><br>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. <br><br>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. <br><br>When I set <font size="3"><span style="font-family: Courier New,courier,monaco,monospace,sans-serif;">rtcachefriends = yes</span></font> in sip.conf, I get the following for each peer:<br><br><font size="2"><span style="font-family: Courier New,courier,monaco,monospace,sans-serif;">ast01*CLI> sip show peer 412</span><br style="font-family: Courier New,courier,monaco,monospace,sans-serif;"><br style="font-family: Courier New,courier,monaco,monospace,sans-serif;"><br style="font-family: Courier New,courier,monaco,monospace,sans-serif;"><span style="font-family: Courier New,courier,monaco,monospace,sans-serif;"> * Name : 412</span><br style="font-family: Courier New,courier,monaco,monospace,sans-serif;"><span style="font-family: Courier New,courier,monaco,monospace,sans-serif;"> Realtime peer: Yes, cached</span><br style="font-family: Courier New,courier,monaco,monospace,sans-serif;"><span style="font-family: Courier New,courier,monaco,monospace,sans-serif;"> Secret : <Set></span><br style="font-family: Courier New,courier,monaco,monospace,sans-serif;"><span style="font-family: Courier New,courier,monaco,monospace,sans-serif;"> MD5Secret : <Not set></span><br style="font-family: Courier New,courier,monaco,monospace,sans-serif;"><span style="font-family: Courier New,courier,monaco,monospace,sans-serif;"> Remote Secret: <Not set></span><br style="font-family: Courier New,courier,monaco,monospace,sans-serif;"><span style="font-family: Courier New,courier,monaco,monospace,sans-serif;"> Context : sipphones</span><br style="font-family: Courier New,courier,monaco,monospace,sans-serif;"><span style="font-family: Courier New,courier,monaco,monospace,sans-serif;"> Subscr.Cont. : blf_subscriptions</span><br style="font-family: Courier New,courier,monaco,monospace,sans-serif;"><span style="font-family: Courier New,courier,monaco,monospace,sans-serif;"> Language : en</span><br style="font-family: Courier New,courier,monaco,monospace,sans-serif;"><span style="font-family: Courier New,courier,monaco,monospace,sans-serif;"> AMA flags : Unknown</span><br style="font-family: Courier New,courier,monaco,monospace,sans-serif;"><span style="font-family: Courier New,courier,monaco,monospace,sans-serif;"> Transfer mode: open</span><br style="font-family: Courier New,courier,monaco,monospace,sans-serif;"><span style="font-family: Courier New,courier,monaco,monospace,sans-serif;"> CallingPres : Presentation Allowed, Not Screened</span><br style="font-family: Courier New,courier,monaco,monospace,sans-serif;"><span style="font-family: Courier New,courier,monaco,monospace,sans-serif;"> Callgroup :</span><br style="font-family: Courier New,courier,monaco,monospace,sans-serif;"><span style="font-family: Courier New,courier,monaco,monospace,sans-serif;"> Pickupgroup :</span><br style="font-family: Courier New,courier,monaco,monospace,sans-serif;"><span style="font-family: Courier New,courier,monaco,monospace,sans-serif;"> Mailbox : vm_bob@default</span><br style="font-family: Courier New,courier,monaco,monospace,sans-serif;"><span style="font-family: Courier New,courier,monaco,monospace,sans-serif;"> VM Extension : asterisk</span><br style="font-family: Courier New,courier,monaco,monospace,sans-serif;"><span style="font-family: Courier New,courier,monaco,monospace,sans-serif;"> LastMsgsSent : 32767/65535</span><br style="font-family: Courier New,courier,monaco,monospace,sans-serif;"><span style="font-family: Courier New,courier,monaco,monospace,sans-serif;"> Call limit : 0</span><br style="font-family: Courier New,courier,monaco,monospace,sans-serif;"><span style="font-family: Courier New,courier,monaco,monospace,sans-serif;"> Dynamic : Yes</span><br style="font-family: Courier New,courier,monaco,monospace,sans-serif;"><span style="font-family: Courier New,courier,monaco,monospace,sans-serif;"> Callerid : "" <></span><br style="font-family: Courier New,courier,monaco,monospace,sans-serif;"><span style="font-family: Courier New,courier,monaco,monospace,sans-serif;"> MaxCallBR : 384 kbps</span><br style="font-family: Courier New,courier,monaco,monospace,sans-serif;"><span style="font-family: Courier New,courier,monaco,monospace,sans-serif;"> Expire : 69</span><br style="font-family: Courier New,courier,monaco,monospace,sans-serif;"><span style="font-family: Courier New,courier,monaco,monospace,sans-serif;"> Insecure : no</span><br style="font-family: Courier New,courier,monaco,monospace,sans-serif;"><span style="font-family: Courier New,courier,monaco,monospace,sans-serif;"> Nat : RFC3581</span><br style="font-family: Courier New,courier,monaco,monospace,sans-serif;"><span style="font-family: Courier New,courier,monaco,monospace,sans-serif;"> ACL : No</span><br style="font-family: Courier New,courier,monaco,monospace,sans-serif;"><span style="font-family: Courier New,courier,monaco,monospace,sans-serif;"> T.38 support : No</span><br style="font-family: Courier New,courier,monaco,monospace,sans-serif;"><span style="font-family: Courier New,courier,monaco,monospace,sans-serif;"> T.38 EC mode : Unknown</span><br style="font-family: Courier New,courier,monaco,monospace,sans-serif;"><span style="font-family: Courier New,courier,monaco,monospace,sans-serif;"> T.38 MaxDtgrm: -1</span><br style="font-family: Courier New,courier,monaco,monospace,sans-serif;"><span style="font-family: Courier New,courier,monaco,monospace,sans-serif;"> DirectMedia : Yes</span><br style="font-family: Courier New,courier,monaco,monospace,sans-serif;"><span style="font-family: Courier New,courier,monaco,monospace,sans-serif;"> PromiscRedir : No</span><br style="font-family: Courier New,courier,monaco,monospace,sans-serif;"><span style="font-family: Courier New,courier,monaco,monospace,sans-serif;"> User=Phone : No</span><br style="font-family: Courier New,courier,monaco,monospace,sans-serif;"><span style="font-family: Courier New,courier,monaco,monospace,sans-serif;"> Video Support: No</span><br style="font-family: Courier New,courier,monaco,monospace,sans-serif;"><span style="font-family: Courier New,courier,monaco,monospace,sans-serif;"> Text Support : No</span><br style="font-family: Courier New,courier,monaco,monospace,sans-serif;"><span style="font-family: Courier New,courier,monaco,monospace,sans-serif;"> Ign SDP ver : No</span><br style="font-family: Courier New,courier,monaco,monospace,sans-serif;"><span style="font-family: Courier New,courier,monaco,monospace,sans-serif;"> Trust RPID : No</span><br style="font-family: Courier New,courier,monaco,monospace,sans-serif;"><span style="font-family: Courier New,courier,monaco,monospace,sans-serif;"> Send RPID : No</span><br style="font-family: Courier New,courier,monaco,monospace,sans-serif;"><span style="font-family: Courier New,courier,monaco,monospace,sans-serif;"> Subscriptions: Yes</span><br style="font-family: Courier New,courier,monaco,monospace,sans-serif;"><span style="font-family: Courier New,courier,monaco,monospace,sans-serif;"> Overlap dial : Yes</span><br style="font-family: Courier New,courier,monaco,monospace,sans-serif;"><span style="font-family: Courier New,courier,monaco,monospace,sans-serif;"> Forward Loop : Yes</span><br style="font-family: Courier New,courier,monaco,monospace,sans-serif;"><span style="font-family: Courier New,courier,monaco,monospace,sans-serif;"> DTMFmode : rfc2833</span><br style="font-family: Courier New,courier,monaco,monospace,sans-serif;"><span style="font-family: Courier New,courier,monaco,monospace,sans-serif;"> Timer T1 : 500</span><br style="font-family: Courier New,courier,monaco,monospace,sans-serif;"><span style="font-family: Courier New,courier,monaco,monospace,sans-serif;"> Timer B : 32000</span><br style="font-family: Courier New,courier,monaco,monospace,sans-serif;"><span style="font-family: Courier New,courier,monaco,monospace,sans-serif;"> ToHost :</span><br style="font-family: Courier New,courier,monaco,monospace,sans-serif;"><span style="font-family: Courier New,courier,monaco,monospace,sans-serif;"> Addr->IP : 10.20.1.225 Port 5064</span><br style="font-family: Courier New,courier,monaco,monospace,sans-serif;"><span style="font-family: Courier New,courier,monaco,monospace,sans-serif;"> Defaddr->IP : 0.0.0.0 Port 5060</span><br style="font-family: Courier New,courier,monaco,monospace,sans-serif;"><span style="font-family: Courier New,courier,monaco,monospace,sans-serif;"> Prim.Transp. : UDP</span><br style="font-family: Courier New,courier,monaco,monospace,sans-serif;"><span style="font-family: Courier New,courier,monaco,monospace,sans-serif;"> Allowed.Trsp : UDP</span><br style="font-family: Courier New,courier,monaco,monospace,sans-serif;"><span style="font-family: Courier New,courier,monaco,monospace,sans-serif;"> Def. Username: 412</span><br style="font-family: Courier New,courier,monaco,monospace,sans-serif;"><span style="font-family: Courier New,courier,monaco,monospace,sans-serif;"> SIP Options : (none)</span><br style="font-family: Courier New,courier,monaco,monospace,sans-serif;"><span style="font-family: Courier New,courier,monaco,monospace,sans-serif;"> Codecs : 0x1004 (ulaw|g722)</span><br style="font-family: Courier New,courier,monaco,monospace,sans-serif;"><span style="font-family: Courier New,courier,monaco,monospace,sans-serif;"> Codec Order : (g722:20,ulaw:20)</span><br style="font-family: Courier New,courier,monaco,monospace,sans-serif;"><span style="font-family: Courier New,courier,monaco,monospace,sans-serif;"> Auto-Framing : No</span><br style="font-family: Courier New,courier,monaco,monospace,sans-serif;"><span style="font-family: Courier New,courier,monaco,monospace,sans-serif;"> 100 on REG : Yes</span><br style="font-family: Courier New,courier,monaco,monospace,sans-serif;"><span style="font-family: Courier New,courier,monaco,monospace,sans-serif;"> Status : Unmonitored</span><br style="font-family: Courier New,courier,monaco,monospace,sans-serif;"><span style="font-family: Courier New,courier,monaco,monospace,sans-serif;"> Useragent : Yealink SIP-T28P 2.50.0.52</span><br style="font-family: Courier New,courier,monaco,monospace,sans-serif;"><span style="font-family: Courier New,courier,monaco,monospace,sans-serif;"> Reg. Contact : sip:412@10.20.1.225:5064</span><br style="font-family: Courier New,courier,monaco,monospace,sans-serif;"><span style="font-family: Courier New,courier,monaco,monospace,sans-serif;"> Qualify Freq : 120000 ms</span><br style="font-family: Courier New,courier,monaco,monospace,sans-serif;"><span style="font-family: Courier New,courier,monaco,monospace,sans-serif;"> Sess-Timers : Accept</span><br style="font-family: Courier New,courier,monaco,monospace,sans-serif;"><span style="font-family: Courier New,courier,monaco,monospace,sans-serif;"> Sess-Refresh : uas</span><br style="font-family: Courier New,courier,monaco,monospace,sans-serif;"><span style="font-family: Courier New,courier,monaco,monospace,sans-serif;"> Sess-Expires : 1800 secs</span><br style="font-family: Courier New,courier,monaco,monospace,sans-serif;"><span style="font-family: Courier New,courier,monaco,monospace,sans-serif;"> Min-Sess : 90 secs</span><br style="font-family: Courier New,courier,monaco,monospace,sans-serif;"><span style="font-family: Courier New,courier,monaco,monospace,sans-serif;"> Parkinglot :</span></font><br><br>This is Asterisk 1.6.2.14 using the ODBC store for voicemail and ODBC for sip_peers.<br><br><div><span style="font-family: arial,helvetica,sans-serif;">Brett Woollum</span><br style="font-family: arial,helvetica,sans-serif;"><span style="font-family: arial,helvetica,sans-serif;">Brett@Woollum.com</span><br></div><br><br>----- Original Message -----<br>From: "Bradley Watkins" <Bradley.Watkins@compuware.com><br>To: "Asterisk Users Mailing List - Non-Commercial Discussion" <asterisk-users@lists.digium.com><br>Sent: Friday, November 12, 2010 5:14:49 AM GMT -08:00 US/Canada Pacific<br>Subject: Re: [asterisk-users] Official Documentation for Asterisk 1.6 Realtime ODBC Tables<br><br> <br><br>>-----Original Message-----<br>>From: asterisk-users-bounces@lists.digium.com <br>>[mailto:asterisk-users-bounces@lists.digium.com] On Behalf Of <br>>Paul Belanger<br>>Sent: Friday, November 12, 2010 7:58 AM<br>>To: Asterisk Users Mailing List - Non-Commercial Discussion<br>>Subject: Re: [asterisk-users] Official Documentation for <br>>Asterisk 1.6 Realtime ODBC Tables<br>><br>>On Fri, Nov 12, 2010 at 6:07 AM, Brett Woollum <br>><brett@woollum.com> wrote:<br>>> I'm having an issue where Asterisk continuously sends out a <br>>GAZILLION <br>>> "SIP NOTIFY" messages when a user has a voice message in <br>>their INBOX. <br>>> This issue is only present when my SIP users and peers are <br>>configured <br>>> from my ODBC backend (MySQL). A static configuration of users in <br>>> sip.conf resolves this and everything works fine.<br>>><br>>What version of 1.6? I _think_ this may have been a bug, that <br>>was fixed.<br>><br>>Don't hold me to that.<br><br>I agree with Paul, this sounds like a bugs that's been fixed.<br><br>What does the 'Mailbox :' line look like when you do a 'sip show peers'?<br><br>My guess is that there will be multiple entries of the same mailbox, and<br>that's why you're receiving a bunch of NOTIFY messages.<br><br>- Brad<br><br>-- <br>_____________________________________________________________________<br>-- Bandwidth and Colocation Provided by http://www.api-digital.com --<br>New to Asterisk? Join us for a live introductory webinar every Thurs:<br> http://www.asterisk.org/hello<br><br>asterisk-users mailing list<br>To UNSUBSCRIBE or update options visit:<br> http://lists.digium.com/mailman/listinfo/asterisk-users<br></div><br>--
_____________________________________________________________________
-- 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</div></body></html>