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

[Jayson Baker]

As the MySQL DB is on the same servers as the Asterisk software, I'm afraid
a tcpdump won't show much.  We have looked at the SQL traffic and all we
see is the usual "SELECT * FROM sip_buddies WHERE..." -- well that doesn't
do much good, as we know the "mailbox" column is being returned properly
during a SQL SELECT.

It seems like Asterisk is just throwing that field away.  But not always.
Sometimes after a sip reload a few SIP registrations will have the Mailbox
field populated.

Looking at debug in Asterisk doesn't show anything other than that Asterisk
found the SQL fields (including "mailbox") and what SQL SELECT statements
it's running.

This just seems so simple!  Has to be something we have contextually wrong
somewhere or something.  Thanks for the help.

On Wed, Nov 19, 2014 at 3:31 PM, Steve Edwards <asterisk.org at sedwards.com>
wrote:

> Please don't top-post.
>
> On Wed, 19 Nov 2014, Jayson Baker wrote:
>
>  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?
>>
>
> Coming late to the party, but...
>
> I'd run tcpdump ('sudo tcpdump -A -s 0 port 3306') and see:
>
> 1) Are packets flowing back and forth like you'd expect.
>
> 2) Can you capture an insert statement so you can apply it in the MySQL
> command line client? You may get a meaningful error message or observe
> something funky in one of the columns.
>
> --
> Thanks in advance,
> -------------------------------------------------------------------------
> Steve Edwards       sedwards at sedwards.com      Voice: +1-760-468-3867 PST
> Newline                                              Fax: +1-760-731-3000
> --
> _____________________________________________________________________
> -- 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/14615ee4/attachment.html>