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

[Jayson Baker]

On Thu, Nov 20, 2014 at 9:47 AM, Jayson Baker <jayson at spectrasurf.com>
wrote:

> 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
>>
>
>
Mailbox continues to be missing most times.  Touching (or rm'ing) the file
in /var/spool/asterisk/voicemail does nothing until a "core restart now"
then as soon as the phone registers the light is sync'ed.   MySQL or CURL,
doesn't matter, anything realtime.  Seems so odd to have this issue on 6
installations, 3 different versions, and nobody knows.  We've even stripped
it down barebones, loading only about 7 modules and clean config files.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.digium.com/pipermail/asterisk-users/attachments/20141120/ba5d5df7/attachment.html>