<div dir="ltr">It was originally varchar(50) and contained mailbox@context -- but that didn't work, so we tried changing it to bigint(10). It's been changed back and does contain varchar(50) with mailbox@context now.<div><br></div><div>Everything else seems to be working properly, yes.</div><div><br></div><div>Here's one entry from our realtime table (MySQL):</div><div><br></div><div><div>INSERT INTO `` (`id`, `name`, `username`, `secret`, `callerid`, `context`, `mailbox`, `mwi`, `host`, `setvar`, `nat`, `type`, `accountcode`, `amaflags`, `call-limit`, `callgroup`, `cancallforward`, `canreinvite`, `defaultip`, `dtmfmode`, `fromuser`, `fromdomain`, `insecure`, `language`, `md5secret`, `deny`, `permit`, `mask`, `musiconhold`, `pickupgroup`, `qualify`, `regexten`, `restrictcid`, `rtpholdtimeout`, `rtptimeout`, `disallow`, `allow`, `parkinglot`, `fullcontact`, `ipaddr`, `port`, `regserver`, `regseconds`, `lastms`, `defaultuser`, `subscribecontext`, `useragent`, `limitonpeers`) VALUES (96, '7191111111', '7191111111', '000000000000000000000000', NULL, 'outbound', '7191111111@default', NULL, 'dynamic', NULL, 'yes', 'friend', NULL, NULL, 2, NULL, 'yes', 'no', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'all', 'ulaw', NULL, '<a href="http://sip:7191111111@10.105.14.7:5060">sip:7191111111@10.105.14.7:5060</a>', '10.105.14.7', 5060, NULL, 1416407370, 6, '7196868170', NULL, 'Linksys/SPA2102-5.2.10', NULL);</div></div><div><br></div><div>And then what "sip show peer 7191111111" shows:</div><div><br></div><div><div>*CLI> sip show peer 7196868100</div><div><br></div><div> * Name : 7191111111</div><div> Description :</div><div> Realtime peer: Yes, cached</div><div> Secret : <Set></div><div> MD5Secret : <Not set></div><div> Remote Secret: <Not set></div><div> Context : outbound</div><div> Record On feature : automon</div><div> Record Off feature : automon</div><div> Subscr.Cont. : <Not set></div><div> Language :</div><div> Tonezone : <Not set></div><div> AMA flags : Unknown</div><div> Transfer mode: open</div><div> CallingPres : Presentation Allowed, Not Screened</div><div> Callgroup :</div><div> Pickupgroup :</div><div> Named Callgr :</div><div> Nam. Pickupgr:</div><div> MOH Suggest :</div><div> Mailbox : </div><div> VM Extension : *98</div><div> LastMsgsSent : 32767/65535</div><div> Call limit : 2</div><div> Max forwards : 0</div><div> Dynamic : Yes</div><div> Callerid : "" <></div><div> MaxCallBR : 384 kbps</div><div> Expire : 53</div><div> Insecure : no</div><div> Force rport : Yes</div><div> Symmetric RTP: Yes</div><div> ACL : No</div><div> DirectMedACL : No</div><div> T.38 support : No</div><div> T.38 EC mode : Unknown</div><div> T.38 MaxDtgrm: 4294967295</div><div> DirectMedia : No</div><div> PromiscRedir : No</div><div> User=Phone : No</div><div> Video Support: No</div><div> Text Support : No</div><div> Ign SDP ver : No</div><div> Trust RPID : Yes</div><div> Send RPID : Yes</div><div> Path support : No</div><div> Path : N/A</div><div> TrustIDOutbnd: Legacy</div><div> Subscriptions: Yes</div></div><div><div> Overlap dial : Yes</div><div> DTMFmode : rfc2833</div><div> Timer T1 : 500</div><div> Timer B : 32000</div><div> ToHost :</div><div> Addr->IP : (null)</div><div> Defaddr->IP : (null)</div><div> Prim.Transp. : UDP</div><div> Allowed.Trsp : UDP</div><div> Reg. exten :</div><div> Def. Username: 7191111111</div><div> SIP Options : (none)</div><div> Codecs : (ulaw)</div><div> Auto-Framing : No</div><div> Status : UNKNOWN</div><div> Useragent : Linksys/SPA2102-5.2.10</div><div> Reg. Contact : <a href="http://sip:7191111111@10.106.1.17:5060">sip:7191111111@10.106.1.17:5060</a></div><div> Qualify Freq : 60000 ms</div><div> Keepalive : 0 ms</div><div> Sess-Timers : Accept</div><div> Sess-Refresh : uas</div><div> Sess-Expires : 1800 secs</div><div> Min-Sess : 90 secs</div><div> RTP Engine : asterisk</div><div> Parkinglot :</div><div> Use Reason : No</div><div> Encryption : No</div></div><div><br></div><div><br></div></div><div class="gmail_extra"><br><div class="gmail_quote">On Wed, Nov 19, 2014 at 7:12 AM, Matthew Jordan <span dir="ltr"><<a href="mailto:mjordan@digium.com" target="_blank">mjordan@digium.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><span class="">On Tue, Nov 18, 2014 at 6:36 PM, Jayson Baker <<a href="mailto:jayson@spectrasurf.com">jayson@spectrasurf.com</a>> wrote:<br>
> Using realtime for SIP.<br>
> Using standard DB schema.<br>
> Tried mailbox as varchar(50) and bigint(10)<br>
> "sip show peer XXX" shows "Mailbox: " (empty)<br>
> So MWI isn't working<br>
<br>
</span>The "mailbox" column in a database schema should be varchar, and big<br>
enough to hold a fully qualified mailbox name.<br>
<span class=""><br>
> This happened before when we tried to go up to 1.8, so we stayed at 1.4<br>
> We're forced to go to 13 now. Obviously a lack of MWI is a big issue for<br>
> 500 units.<br>
><br>
> Any idea why we're not getting it?<br>
> We're tried filling it into MySQL like "xxx@context" or just "xxx"<br>
> No matter what, it doesn't work.<br>
<br>
</span>Per the CHANGES notes, you must now fully qualify a mailbox:<br>
<br>
* Mailboxes defined by app_voicemail MUST be referenced by the rest of the<br>
system as mailbox@context. The rest of the system cannot add @default<br>
to mailbox identifiers for app_voicemail that do not specify a context<br>
any longer. It is a mailbox identifier format that should only be<br>
interpreted by app_voicemail.<br>
<br>
So, if using app_voicemail, your mailboxes should always be<br>
'xxx@vm_context' where appropriate. I don't think this is your problem<br>
however.<br>
<span class=""><br>
> Or maybe some how to debug/diagnose this?<br>
><br>
<br>
</span>Are the rest of the fields in your peers being extracted correctly?<br>
Can you provide the output from your database for one of your peers?<br>
Which realtime backend are you using?<br>
<span class="HOEnZb"><font color="#888888"><br>
<br>
--<br>
Matthew Jordan<br>
Digium, Inc. | Engineering Manager<br>
445 Jan Davis Drive NW - Huntsville, AL 35806 - USA<br>
Check us out at: <a href="http://digium.com" target="_blank">http://digium.com</a> & <a href="http://asterisk.org" target="_blank">http://asterisk.org</a><br>
<br>
--<br>
_____________________________________________________________________<br>
-- Bandwidth and Colocation Provided by <a href="http://www.api-digital.com" target="_blank">http://www.api-digital.com</a> --<br>
New to Asterisk? Join us for a live introductory webinar every Thurs:<br>
<a href="http://www.asterisk.org/hello" target="_blank">http://www.asterisk.org/hello</a><br>
<br>
asterisk-users mailing list<br>
To UNSUBSCRIBE or update options visit:<br>
<a href="http://lists.digium.com/mailman/listinfo/asterisk-users" target="_blank">http://lists.digium.com/mailman/listinfo/asterisk-users</a><br>
</font></span></blockquote></div><br></div>