On Thu, Nov 20, 2014 at 9:47 AM, Jayson Baker <jay...@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_l...@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....@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.
-- _____________________________________________________________________ -- 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