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

2014-11-19 Thread Matthew Jordan
On Tue, Nov 18, 2014 at 6:36 PM, Jayson Baker jay...@spectrasurf.com wrote: Using realtime for SIP. Using standard DB schema. Tried mailbox as varchar(50) and bigint(10) sip show peer XXX shows Mailbox: (empty) So MWI isn't working The mailbox column in a database schema should be varchar,

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

2014-11-19 Thread Jayson Baker
It was originally varchar(50) and contained mailbox@context -- but that didn't work, so we tried changing it to bigint(10). It's been changed back and does contain varchar(50) with mailbox@context now. Everything else seems to be working properly, yes. Here's one entry from our realtime table

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

2014-11-19 Thread Matthew Jordan
On Wed, Nov 19, 2014 at 8:30 AM, Jayson Baker jay...@spectrasurf.com wrote: It was originally varchar(50) and contained mailbox@context -- but that didn't work, so we tried changing it to bigint(10). It's been changed back and does contain varchar(50) with mailbox@context now. Everything

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

2014-11-19 Thread Jayson Baker
res_mysql connecting to a MySQL database. Is that what you're asking? It's all MySQL. On Wed, Nov 19, 2014 at 8:43 AM, Matthew Jordan mjor...@digium.com wrote: On Wed, Nov 19, 2014 at 8:30 AM, Jayson Baker jay...@spectrasurf.com wrote: It was originally varchar(50) and contained

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

2014-11-19 Thread Steve Edwards
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

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

2014-11-19 Thread Jayson Baker
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