********** 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