Re: [asterisk-users] Upgraded to 13 and now Mailbox is empty in sip show peers
On Thursday 20 Nov 2014, Jayson Baker wrote: 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. It's not clear from your descriptions; but if you have at least one machine where it's working properly, then you need to work out what is different between that working and your non-working installations. The fact of it not responding to realtime changes certainly suggests a misconfiguration somewhere; one or more modules is not expecting things to change, and so picking up on it when they do. So the question now becomes: What is the minimum you need to do, to persuade your Asterisk to accept the new configuration? core restart now is a pretty big sledgehammer to be using to crack the nut of a configuration file not being reread. Try core reload or even voicemail reload. And then once you've found the module whose config you need to reload explicitly, that is where the misconfiguration most probably resides. -- 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
Re: [asterisk-users] Upgraded to 13 and now Mailbox is empty in sip show peers
** 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
Re: [asterisk-users] Upgraded to 13 and now Mailbox is empty in sip show peers
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
--
_
-- 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
Re: [asterisk-users] Upgraded to 13 and now Mailbox is empty in sip show peers
** THIS IS NOT WHERE YOUR REPLY BELONGS ** Which part of THIS IS NOT WHERE YOUR REPLY BELONGS do you not understand? -- 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
Re: [asterisk-users] Upgraded to 13 and now Mailbox is empty in sip show peers
Well exactly where are we supposed to reply then? Via US Mail? On Thu, Nov 20, 2014 at 9:56 AM, A J Stiles asterisk_l...@earthshod.co.uk wrote: ** THIS IS NOT WHERE YOUR REPLY BELONGS ** Which part of THIS IS NOT WHERE YOUR REPLY BELONGS do you not understand? -- 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 -- _ -- 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
Re: [asterisk-users] Upgraded to 13 and now Mailbox is empty in sip show peers
** THIS IS NOT WHERE YOUR REPLY BELONGS ** On Thursday 20 Nov 2014, Jayson Baker wrote: On Thu, Nov 20, 2014 at 9:56 AM, A J Stiles asterisk_l...@earthshod.co.uk wrote: ** THIS IS NOT WHERE YOUR REPLY BELONGS ** Which part of THIS IS NOT WHERE YOUR REPLY BELONGS do you not understand? Well exactly where are we supposed to reply then? Via US Mail? You are supposed to reply *after* the thing you are replying to. Like this. So the conversation flows neatly. -- 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
Re: [asterisk-users] Upgraded to 13 and now Mailbox is empty in sip show peers
I doubt the person cares, if you don't like people top posting then stop reading their messages. If someone top posts, nothing you do will make them stop top posting. Complaining about something you cannot change just wastes everyone's time.I have a rule which deletes messages with top post in them so I don't usually see these silly messages. -Original Message- From: asterisk-users-boun...@lists.digium.com [mailto:asterisk-users-boun...@lists.digium.com] On Behalf Of A J Stiles Sent: Thursday, November 20, 2014 11:57 AM To: Asterisk Users Mailing List - Non-Commercial Discussion Subject: Re: [asterisk-users] Upgraded to 13 and now Mailbox is empty in sip show peers ** THIS IS NOT WHERE YOUR REPLY BELONGS ** Which part of THIS IS NOT WHERE YOUR REPLY BELONGS do you not understand? -- 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 -- _ -- 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
Re: [asterisk-users] Upgraded to 13 and now Mailbox is empty in sip show peers
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
Re: [asterisk-users] Upgraded to 13 and now Mailbox is empty in sip show peers
Eric Wieling wrote: I doubt the person cares, if you don't like people top posting then stop reading their messages. If someone top posts, nothing you do will make them stop top posting. Complaining about something you cannot change just wastes everyone's time.I have a rule which deletes messages with top post in them so I don't usually see these silly messages. Some might even say that the constant complaining about top posting, expecting different results, is a definition of insanity! Some of the same folks who constantly complain about top posting will leave many many footers from the list in place, which makes the neatly flowing conversation nearly impossible. Peg Leg O'Brien -Original Message- From: asterisk-users-boun...@lists.digium.com [mailto:asterisk-users-boun...@lists.digium.com] On Behalf Of A J Stiles Sent: Thursday, November 20, 2014 11:57 AM To: Asterisk Users Mailing List - Non-Commercial Discussion Subject: Re: [asterisk-users] Upgraded to 13 and now Mailbox is empty in sip show peers ** THIS IS NOT WHERE YOUR REPLY BELONGS ** Which part of THIS IS NOT WHERE YOUR REPLY BELONGS do you not understand? -- Dog is my Co-pilot -- _ -- 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
Re: [asterisk-users] Upgraded to 13 and now Mailbox is empty in sip show peers
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, and big enough to hold a fully qualified mailbox name. This happened before when we tried to go up to 1.8, so we stayed at 1.4 We're forced to go to 13 now. Obviously a lack of MWI is a big issue for 500 units. Any idea why we're not getting it? We're tried filling it into MySQL like xxx@context or just xxx No matter what, it doesn't work. Per the CHANGES notes, you must now fully qualify a mailbox: * Mailboxes defined by app_voicemail MUST be referenced by the rest of the system as mailbox@context. The rest of the system cannot add @default to mailbox identifiers for app_voicemail that do not specify a context any longer. It is a mailbox identifier format that should only be interpreted by app_voicemail. So, if using app_voicemail, your mailboxes should always be 'xxx@vm_context' where appropriate. I don't think this is your problem however. Or maybe some how to debug/diagnose this? Are the rest of the fields in your peers being extracted correctly? Can you provide the output from your database for one of your peers? Which realtime backend are you using? -- Matthew Jordan Digium, Inc. | Engineering Manager 445 Jan Davis Drive NW - Huntsville, AL 35806 - USA Check us out at: http://digium.com http://asterisk.org -- _ -- 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
Re: [asterisk-users] Upgraded to 13 and now Mailbox is empty in sip show peers
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 (MySQL): INSERT INTO `` (`id`, `name`, `username`, `secret`, `callerid`, `context`, `mailbox`, `mwi`, `host`, `setvar`, `nat`, `type`, `accountcode`, `amaflags`, `call-limit`, `callgroup`, `cancallforward`, `canreinvite`, `defaultip`, `dtmfmode`, `fromuser`, `fromdomain`, `insecure`, `language`, `md5secret`, `deny`, `permit`, `mask`, `musiconhold`, `pickupgroup`, `qualify`, `regexten`, `restrictcid`, `rtpholdtimeout`, `rtptimeout`, `disallow`, `allow`, `parkinglot`, `fullcontact`, `ipaddr`, `port`, `regserver`, `regseconds`, `lastms`, `defaultuser`, `subscribecontext`, `useragent`, `limitonpeers`) VALUES (96, '719111', '719111', '', NULL, 'outbound', '719111@default', NULL, 'dynamic', NULL, 'yes', 'friend', NULL, NULL, 2, NULL, 'yes', 'no', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'all', 'ulaw', NULL, ' sip:719111@10.105.14.7:5060', '10.105.14.7', 5060, NULL, 1416407370, 6, '7196868170', NULL, 'Linksys/SPA2102-5.2.10', NULL); And then what sip show peer 719111 shows: *CLI sip show peer 7196868100 * Name : 719111 Description : Realtime peer: Yes, cached Secret : Set MD5Secret: Not set Remote Secret: Not set Context : outbound Record On feature : automon Record Off feature : automon Subscr.Cont. : Not set Language : Tonezone : Not set AMA flags: Unknown Transfer mode: open CallingPres : Presentation Allowed, Not Screened Callgroup: Pickupgroup : Named Callgr : Nam. Pickupgr: MOH Suggest : Mailbox : VM Extension : *98 LastMsgsSent : 32767/65535 Call limit : 2 Max forwards : 0 Dynamic : Yes Callerid : MaxCallBR: 384 kbps Expire : 53 Insecure : no Force rport : Yes Symmetric RTP: Yes ACL : No DirectMedACL : No T.38 support : No T.38 EC mode : Unknown T.38 MaxDtgrm: 4294967295 DirectMedia : No PromiscRedir : No User=Phone : No Video Support: No Text Support : No Ign SDP ver : No Trust RPID : Yes Send RPID: Yes Path support : No Path : N/A TrustIDOutbnd: Legacy Subscriptions: Yes Overlap dial : Yes DTMFmode : rfc2833 Timer T1 : 500 Timer B : 32000 ToHost : Addr-IP : (null) Defaddr-IP : (null) Prim.Transp. : UDP Allowed.Trsp : UDP Reg. exten : Def. Username: 719111 SIP Options : (none) Codecs : (ulaw) Auto-Framing : No Status : UNKNOWN Useragent: Linksys/SPA2102-5.2.10 Reg. Contact : sip:719111@10.106.1.17:5060 Qualify Freq : 6 ms Keepalive: 0 ms Sess-Timers : Accept Sess-Refresh : uas Sess-Expires : 1800 secs Min-Sess : 90 secs RTP Engine : asterisk Parkinglot : Use Reason : No Encryption : No On Wed, Nov 19, 2014 at 7:12 AM, Matthew Jordan mjor...@digium.com wrote: 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, and big enough to hold a fully qualified mailbox name. This happened before when we tried to go up to 1.8, so we stayed at 1.4 We're forced to go to 13 now. Obviously a lack of MWI is a big issue for 500 units. Any idea why we're not getting it? We're tried filling it into MySQL like xxx@context or just xxx No matter what, it doesn't work. Per the CHANGES notes, you must now fully qualify a mailbox: * Mailboxes defined by app_voicemail MUST be referenced by the rest of the system as mailbox@context. The rest of the system cannot add @default to mailbox identifiers for app_voicemail that do not specify a context any longer. It is a mailbox identifier format that should only be interpreted by app_voicemail. So, if using app_voicemail, your mailboxes should always be 'xxx@vm_context' where appropriate. I don't think this is your problem however. Or maybe some how to debug/diagnose this? Are the rest of the fields in your peers being extracted correctly? Can you provide the output from your database for one of your peers? Which realtime backend are you using? -- Matthew Jordan Digium, Inc. | Engineering Manager 445 Jan Davis Drive NW - Huntsville, AL 35806 - USA Check us out at: http://digium.com http://asterisk.org -- _ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to
Re: [asterisk-users] Upgraded to 13 and now Mailbox is empty in sip show peers
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 else seems to be working properly, yes. Here's one entry from our realtime table (MySQL): INSERT INTO `` (`id`, `name`, `username`, `secret`, `callerid`, `context`, `mailbox`, `mwi`, `host`, `setvar`, `nat`, `type`, `accountcode`, `amaflags`, `call-limit`, `callgroup`, `cancallforward`, `canreinvite`, `defaultip`, `dtmfmode`, `fromuser`, `fromdomain`, `insecure`, `language`, `md5secret`, `deny`, `permit`, `mask`, `musiconhold`, `pickupgroup`, `qualify`, `regexten`, `restrictcid`, `rtpholdtimeout`, `rtptimeout`, `disallow`, `allow`, `parkinglot`, `fullcontact`, `ipaddr`, `port`, `regserver`, `regseconds`, `lastms`, `defaultuser`, `subscribecontext`, `useragent`, `limitonpeers`) VALUES (96, '719111', '719111', '', NULL, 'outbound', '719111@default', NULL, 'dynamic', NULL, 'yes', 'friend', NULL, NULL, 2, NULL, 'yes', 'no', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'all', 'ulaw', NULL, 'sip:719111@10.105.14.7:5060', '10.105.14.7', 5060, NULL, 1416407370, 6, '7196868170', NULL, 'Linksys/SPA2102-5.2.10', NULL); And then what sip show peer 719111 shows: *CLI sip show peer 7196868100 * Name : 719111 Description : Realtime peer: Yes, cached Secret : Set MD5Secret: Not set Remote Secret: Not set Context : outbound Record On feature : automon Record Off feature : automon Subscr.Cont. : Not set Language : Tonezone : Not set AMA flags: Unknown Transfer mode: open CallingPres : Presentation Allowed, Not Screened Callgroup: Pickupgroup : Named Callgr : Nam. Pickupgr: MOH Suggest : Mailbox : VM Extension : *98 LastMsgsSent : 32767/65535 Call limit : 2 Max forwards : 0 Dynamic : Yes Callerid : MaxCallBR: 384 kbps Expire : 53 Insecure : no Force rport : Yes Symmetric RTP: Yes ACL : No DirectMedACL : No T.38 support : No T.38 EC mode : Unknown T.38 MaxDtgrm: 4294967295 DirectMedia : No PromiscRedir : No User=Phone : No Video Support: No Text Support : No Ign SDP ver : No Trust RPID : Yes Send RPID: Yes Path support : No Path : N/A TrustIDOutbnd: Legacy Subscriptions: Yes Overlap dial : Yes DTMFmode : rfc2833 Timer T1 : 500 Timer B : 32000 ToHost : Addr-IP : (null) Defaddr-IP : (null) Prim.Transp. : UDP Allowed.Trsp : UDP Reg. exten : Def. Username: 719111 SIP Options : (none) Codecs : (ulaw) Auto-Framing : No Status : UNKNOWN Useragent: Linksys/SPA2102-5.2.10 Reg. Contact : sip:719111@10.106.1.17:5060 Qualify Freq : 6 ms Keepalive: 0 ms Sess-Timers : Accept Sess-Refresh : uas Sess-Expires : 1800 secs Min-Sess : 90 secs RTP Engine : asterisk Parkinglot : Use Reason : No Encryption : No Which realtime backend are you using? (MySQL can be interfaced to with a variety of backends) -- Matthew Jordan Digium, Inc. | Engineering Manager 445 Jan Davis Drive NW - Huntsville, AL 35806 - USA Check us out at: http://digium.com http://asterisk.org -- _ -- 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
Re: [asterisk-users] Upgraded to 13 and now Mailbox is empty in sip show peers
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 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 (MySQL): INSERT INTO `` (`id`, `name`, `username`, `secret`, `callerid`, `context`, `mailbox`, `mwi`, `host`, `setvar`, `nat`, `type`, `accountcode`, `amaflags`, `call-limit`, `callgroup`, `cancallforward`, `canreinvite`, `defaultip`, `dtmfmode`, `fromuser`, `fromdomain`, `insecure`, `language`, `md5secret`, `deny`, `permit`, `mask`, `musiconhold`, `pickupgroup`, `qualify`, `regexten`, `restrictcid`, `rtpholdtimeout`, `rtptimeout`, `disallow`, `allow`, `parkinglot`, `fullcontact`, `ipaddr`, `port`, `regserver`, `regseconds`, `lastms`, `defaultuser`, `subscribecontext`, `useragent`, `limitonpeers`) VALUES (96, '719111', '719111', '', NULL, 'outbound', '719111@default', NULL, 'dynamic', NULL, 'yes', 'friend', NULL, NULL, 2, NULL, 'yes', 'no', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'all', 'ulaw', NULL, 'sip:719111@10.105.14.7:5060', '10.105.14.7', 5060, NULL, 1416407370, 6, '7196868170', NULL, 'Linksys/SPA2102-5.2.10', NULL); And then what sip show peer 719111 shows: *CLI sip show peer 7196868100 * Name : 719111 Description : Realtime peer: Yes, cached Secret : Set MD5Secret: Not set Remote Secret: Not set Context : outbound Record On feature : automon Record Off feature : automon Subscr.Cont. : Not set Language : Tonezone : Not set AMA flags: Unknown Transfer mode: open CallingPres : Presentation Allowed, Not Screened Callgroup: Pickupgroup : Named Callgr : Nam. Pickupgr: MOH Suggest : Mailbox : VM Extension : *98 LastMsgsSent : 32767/65535 Call limit : 2 Max forwards : 0 Dynamic : Yes Callerid : MaxCallBR: 384 kbps Expire : 53 Insecure : no Force rport : Yes Symmetric RTP: Yes ACL : No DirectMedACL : No T.38 support : No T.38 EC mode : Unknown T.38 MaxDtgrm: 4294967295 DirectMedia : No PromiscRedir : No User=Phone : No Video Support: No Text Support : No Ign SDP ver : No Trust RPID : Yes Send RPID: Yes Path support : No Path : N/A TrustIDOutbnd: Legacy Subscriptions: Yes Overlap dial : Yes DTMFmode : rfc2833 Timer T1 : 500 Timer B : 32000 ToHost : Addr-IP : (null) Defaddr-IP : (null) Prim.Transp. : UDP Allowed.Trsp : UDP Reg. exten : Def. Username: 719111 SIP Options : (none) Codecs : (ulaw) Auto-Framing : No Status : UNKNOWN Useragent: Linksys/SPA2102-5.2.10 Reg. Contact : sip:719111@10.106.1.17:5060 Qualify Freq : 6 ms Keepalive: 0 ms Sess-Timers : Accept Sess-Refresh : uas Sess-Expires : 1800 secs Min-Sess : 90 secs RTP Engine : asterisk Parkinglot : Use Reason : No Encryption : No Which realtime backend are you using? (MySQL can be interfaced to with a variety of backends) -- Matthew Jordan Digium, Inc. | Engineering Manager 445 Jan Davis Drive NW - Huntsville, AL 35806 - USA Check us out at: http://digium.com http://asterisk.org -- _ -- 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 -- _ -- 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
Re: [asterisk-users] Upgraded to 13 and now Mailbox is empty in sip show peers
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.
--
Thanks in advance,
-
Steve Edwards sedwa...@sedwards.com Voice: +1-760-468-3867 PST
Newline Fax: +1-760-731-3000--
_
-- 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
Re: [asterisk-users] Upgraded to 13 and now Mailbox is empty in sip show peers
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.
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.
--
Thanks in advance,
-
Steve Edwards sedwa...@sedwards.com Voice: +1-760-468-3867 PST
Newline Fax: +1-760-731-3000
--
_
-- 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
--
_
-- 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
