<div dir="ltr">Well we've ruled out that this is in anyway MySQL or even res_config_mysql related.<div><br></div><div>This morning our guys wrote a backend for res_config_curl to return static information (in no way touching anything SQL at all).</div><div><br></div><div>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.</div><div><br></div><div>Since we've totally ruled out this being at all a problem with MySQL that helps somewhat (I guess?).</div><div><br></div><div>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).</div><div><br></div><div>Or maybe this is something in the realtime engine? Is there something "realtime" shared between mysql and curl?</div><div><br></div><div>Thanks for help!!</div><div><br></div><div>sip.conf:</div><div><div>[general]</div><div>progressinband=never</div><div>rtcachefriends=yes</div><div>rtupdate=yes</div><div>ignoreregexpire=yes</div><div>checkmwi=60</div><div>trustrpid=yes</div><div>sendrpid=yes</div><div>sendrpid=rpid</div><div>rpid_update=yes</div><div>shrinkcallerid=no</div><div>t38pt_udptl=yes,redundancy,maxdatagram=400</div><div>vmexten=*98</div><div>canreinvite=no</div><div>qualify=yes</div><div>tos_sip=cs3</div><div>tos_audio=ef</div><div>tos_video=af41</div><div>accept_outofcall_messages = yes</div><div>outofcall_message_context = dpma_message_context</div><div>auth_message_requests = no</div><div>callcounter=yes</div><div>callevents=yes</div></div><div><br></div></div><div class="gmail_extra"><br><div class="gmail_quote">On Thu, Nov 20, 2014 at 8:51 AM, A J Stiles <span dir="ltr"><<a href="mailto:asterisk_list@earthshod.co.uk" target="_blank">asterisk_list@earthshod.co.uk</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">********** THIS IS NOT WHERE YOUR REPLY BELONGS **********<br>
<div><div class="h5"><br>
On Wednesday 19 Nov 2014, Jayson Baker wrote:<br>
> On Wed, Nov 19, 2014 at 3:31 PM, Steve Edwards <<a href="mailto:asterisk.org@sedwards.com">asterisk.org@sedwards.com</a>><br>
><br>
> wrote:<br>
> > Please don't top-post.<br>
> ><br>
> > On Wed, 19 Nov 2014, Jayson Baker wrote:<br>
> > This same issue has happened on 1.8 as well. And so far on all 6 of our<br>
> ><br>
> >> systems we upgraded to 13. It must be something simple? How can we<br>
> >> diagnose it?<br>
> ><br>
> > Coming late to the party, but...<br>
> ><br>
> > I'd run tcpdump ('sudo tcpdump -A -s 0 port 3306') and see:<br>
> ><br>
> > 1) Are packets flowing back and forth like you'd expect.<br>
> ><br>
> > 2) Can you capture an insert statement so you can apply it in the MySQL<br>
> > command line client? You may get a meaningful error message or observe<br>
> > something funky in one of the columns.<br>
> ><br>
> As the MySQL DB is on the same servers as the Asterisk software, I'm afraid<br>
> a tcpdump won't show much. We have looked at the SQL traffic and all we<br>
> see is the usual "SELECT * FROM sip_buddies WHERE..." -- well that doesn't<br>
> do much good, as we know the "mailbox" column is being returned properly<br>
> during a SQL SELECT.<br>
><br>
> It seems like Asterisk is just throwing that field away. But not always.<br>
> Sometimes after a sip reload a few SIP registrations will have the Mailbox<br>
> field populated.<br>
><br>
> Looking at debug in Asterisk doesn't show anything other than that Asterisk<br>
> found the SQL fields (including "mailbox") and what SQL SELECT statements<br>
> it's running.<br>
><br>
> This just seems so simple! Has to be something we have contextually wrong<br>
> somewhere or something. Thanks for the help.<br>
<br>
</div></div>First try this;<br>
<br>
mysql> SHOW VARIABLES LIKE "general_log%" ;<br>
+------------------+---------------------------+<br>
| Variable_name | Value |<br>
+------------------+---------------------------+<br>
| general_log | OFF |<br>
| general_log_file | /var/lib/mysql/debian.log |<br>
+------------------+---------------------------+<br>
2 rows in set (0.00 sec)<br>
<br>
Note the value for "general_log_file". Now enter<br>
<br>
mysql> SET GLOBAL general_log = 1;<br>
<br>
Exit out of mysql (if you're not using screen, or multiple tabs in your<br>
terminal emulator) and run<br>
<br>
$ tail -fn0 /var/lib/mysql/debian.log<br>
<br>
(or whatever the log file is called). Now you will get every SQL query<br>
executed on the server scroling past, and you might get a clue from this what<br>
might be the matter.<br>
<span class="HOEnZb"><font color="#888888"><br>
<br>
<br>
--<br>
AJS<br>
<br>
Note: Originating address only accepts e-mail from list! If replying off-<br>
list, change address to asterisk1list at earthshod dot co dot uk .<br>
</font></span><div class="HOEnZb"><div class="h5"><br>
--<br>
_____________________________________________________________________<br>
-- Bandwidth and Colocation Provided by <a href="http://www.api-digital.com" target="_blank">http://www.api-digital.com</a> --<br>
New to Asterisk? Join us for a live introductory webinar every Thurs:<br>
<a href="http://www.asterisk.org/hello" target="_blank">http://www.asterisk.org/hello</a><br>
<br>
asterisk-users mailing list<br>
To UNSUBSCRIBE or update options visit:<br>
<a href="http://lists.digium.com/mailman/listinfo/asterisk-users" target="_blank">http://lists.digium.com/mailman/listinfo/asterisk-users</a><br>
</div></div></blockquote></div><br></div>