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

[Jayson Baker]

Well we've ruled out that this is in anyway MySQL or even res_config_mysql
related.

This morning our guys wrote a backend for res_config_curl to return static
information (in no way touching anything SQL at all).

Still we are getting intermittent "Mailbox" results in a "sip show peer".
Sometimes it's there for some endpoints.  Sometimes it's not.  Sometimes
it'll show up (or disappear) after the endpoint's registry expires.  Or if
we do a "sip reload" it'll come and go.

Since we've totally ruled out this being at all a problem with MySQL that
helps somewhat (I guess?).

Could this in any way be related to the endpoint themselves?  All
Linksys/Sipura stuff.  I wouldn't think so, but maybe the endpoint's are
all misconfigured?  Or could it be a setting in sip.conf that is
incorrect?  Here's the total of the sip.conf (again since we're using
realtime it's mostly empty).

Or maybe this is something in the realtime engine?  Is there something
"realtime" shared between mysql and curl?

Thanks for help!!

sip.conf:
[general]
progressinband=never
rtcachefriends=yes
rtupdate=yes
ignoreregexpire=yes
checkmwi=60
trustrpid=yes
sendrpid=yes
sendrpid=rpid
rpid_update=yes
shrinkcallerid=no
t38pt_udptl=yes,redundancy,maxdatagram=400
vmexten=*98
canreinvite=no
qualify=yes
tos_sip=cs3
tos_audio=ef
tos_video=af41
accept_outofcall_messages = yes
outofcall_message_context = dpma_message_context
auth_message_requests = no
callcounter=yes
callevents=yes


On Thu, Nov 20, 2014 at 8:51 AM, A J Stiles <asterisk_list at earthshod.co.uk>
wrote:

> **********  THIS IS NOT WHERE YOUR REPLY BELONGS  **********
>
> On Wednesday 19 Nov 2014, Jayson Baker wrote:
> > 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.
> > >
> > 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.
>
> First try this;
>
> mysql> SHOW VARIABLES LIKE "general_log%" ;
> +------------------+---------------------------+
> | Variable_name    | Value                     |
> +------------------+---------------------------+
> | general_log      | OFF                       |
> | general_log_file | /var/lib/mysql/debian.log |
> +------------------+---------------------------+
> 2 rows in set (0.00 sec)
>
> Note the value for "general_log_file".  Now enter
>
> mysql> SET GLOBAL general_log = 1;
>
> Exit out of mysql  (if you're not using screen, or multiple tabs in your
> terminal emulator)  and run
>
> $ tail -fn0 /var/lib/mysql/debian.log
>
> (or whatever the log file is called).  Now you will get every SQL query
> executed on the server scroling past, and you might get a clue from this
> what
> might be the matter.
>
>
>
> --
> AJS
>
> Note:  Originating address only accepts e-mail from list!  If replying off-
> list, change address to asterisk1list at earthshod dot co dot uk .
>
> --
> _____________________________________________________________________
> -- 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/20141120/53964cc2/attachment.html>