[asterisk-users] Upgraded to 13 and now "Mailbox" is empty in sip show peers

[Jayson Baker]

This same issue has happened on 1.8 as well.  And so far on all 6 of our
systems we upgraded to 13.  It must be something simple?  How can we
diagnose it?

On Wed, Nov 19, 2014 at 9:12 AM, Jayson Baker <jayson at spectrasurf.com>
wrote:

> res_mysql connecting to a MySQL database.  Is that what you're asking?
> It's all MySQL.
>
> On Wed, Nov 19, 2014 at 8:43 AM, Matthew Jordan <mjordan at digium.com>
> wrote:
>
>> On Wed, Nov 19, 2014 at 8:30 AM, Jayson Baker <jayson at spectrasurf.com>
>> wrote:
>> > It was originally varchar(50) and contained mailbox at 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 at context now.
>> >
>> > Everything else seems to be working properly, yes.
>> >
>> > Here's one entry from our realtime table (MySQL):
>> >
>> > 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 at 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,
>> > 'sip:7191111111 at 10.105.14.7:5060', '10.105.14.7', 5060, NULL,
>> 1416407370, 6,
>> > '7196868170', NULL, 'Linksys/SPA2102-5.2.10', NULL);
>> >
>> > And then what "sip show peer 7191111111" shows:
>> >
>> > *CLI> sip show peer 7196868100
>> >
>> >   * Name       : 7191111111
>> >   Description  :
>> >   Realtime peer: Yes, cached
>> >   Secret       : <Set>
>> >   MD5Secret    : <Not set>
>> >   Remote Secret: <Not set>
>> >   Context      : outbound
>> >   Record On feature : automon
>> >   Record Off feature : automon
>> >   Subscr.Cont. : <Not set>
>> >   Language     :
>> >   Tonezone     : <Not set>
>> >   AMA flags    : Unknown
>> >   Transfer mode: open
>> >   CallingPres  : Presentation Allowed, Not Screened
>> >   Callgroup    :
>> >   Pickupgroup  :
>> >   Named Callgr :
>> >   Nam. Pickupgr:
>> >   MOH Suggest  :
>> >   Mailbox      :
>> >   VM Extension : *98
>> >   LastMsgsSent : 32767/65535
>> >   Call limit   : 2
>> >   Max forwards : 0
>> >   Dynamic      : Yes
>> >   Callerid     : "" <>
>> >   MaxCallBR    : 384 kbps
>> >   Expire       : 53
>> >   Insecure     : no
>> >   Force rport  : Yes
>> >   Symmetric RTP: Yes
>> >   ACL          : No
>> >   DirectMedACL : No
>> >   T.38 support : No
>> >   T.38 EC mode : Unknown
>> >   T.38 MaxDtgrm: 4294967295
>> >   DirectMedia  : No
>> >   PromiscRedir : No
>> >   User=Phone   : No
>> >   Video Support: No
>> >   Text Support : No
>> >   Ign SDP ver  : No
>> >   Trust RPID   : Yes
>> >   Send RPID    : Yes
>> >   Path support : No
>> >   Path         : N/A
>> >   TrustIDOutbnd: Legacy
>> >   Subscriptions: Yes
>> >   Overlap dial : Yes
>> >   DTMFmode     : rfc2833
>> >   Timer T1     : 500
>> >   Timer B      : 32000
>> >   ToHost       :
>> >   Addr->IP     : (null)
>> >   Defaddr->IP  : (null)
>> >   Prim.Transp. : UDP
>> >   Allowed.Trsp : UDP
>> >   Reg. exten   :
>> >   Def. Username: 7191111111
>> >   SIP Options  : (none)
>> >   Codecs       : (ulaw)
>> >   Auto-Framing : No
>> >   Status       : UNKNOWN
>> >   Useragent    : Linksys/SPA2102-5.2.10
>> >   Reg. Contact : sip:7191111111 at 10.106.1.17:5060
>> >   Qualify Freq : 60000 ms
>> >   Keepalive    : 0 ms
>> >   Sess-Timers  : Accept
>> >   Sess-Refresh : uas
>> >   Sess-Expires : 1800 secs
>> >   Min-Sess     : 90 secs
>> >   RTP Engine   : asterisk
>> >   Parkinglot   :
>> >   Use Reason   : No
>> >   Encryption   : No
>> >
>>
>> Which realtime backend are you using? (MySQL can be interfaced to with
>> a variety of backends)
>>
>>
>> --
>> Matthew Jordan
>> Digium, Inc. | Engineering Manager
>> 445 Jan Davis Drive NW - Huntsville, AL 35806 - USA
>> Check us out at: http://digium.com & http://asterisk.org
>>
>> --
>> _____________________________________________________________________
>> -- 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/20141119/e2c0d24e/attachment.html>