VoIP Mailing List Archives

[jayson at spectrasurf.com]

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


Or maybe some how to debug/diagnose this?


Thanks!

[mjordan at digium.com]

On Tue, Nov 18, 2014 at 6:36 PM, Jayson Baker <jayson@spectrasurf.com> wrote:

[jayson at spectrasurf.com]

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, '7191111111', '7191111111', '000000000000000000000000', NULL, 'outbound', '7191111111@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:7191111111@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 7191111111" shows:


*CLI> sip show peer 7196868100


  * Name       : 7191111111
  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: 7191111111
  SIP Options  : (none)
  Codecs       : (ulaw)
  Auto-Framing : No
  Status       : UNKNOWN
  Useragent    : Linksys/SPA2102-5.2.10
  Reg. Contact : sip:7191111111@10.106.1.17:5060
  Qualify Freq : 60000 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 <mjordan@digium.com (mjordan@digium.com)> wrote:

[mjordan at digium.com]

On Wed, Nov 19, 2014 at 8:30 AM, Jayson Baker <jayson@spectrasurf.com> wrote:

[jayson at spectrasurf.com]

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 <mjordan@digium.com (mjordan@digium.com)> wrote:

[jayson at spectrasurf.com]

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?

On Wed, Nov 19, 2014 at 9:12 AM, Jayson Baker <jayson@spectrasurf.com (jayson@spectrasurf.com)> wrote:

[asterisk.org at sedwar...]

Please don't top-post.

On Wed, 19 Nov 2014, Jayson Baker wrote:

[jayson at spectrasurf.com]

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.org@sedwards.com (asterisk.org@sedwards.com)> wrote:

[asterisk_list at earth...]

********** THIS IS NOT WHERE YOUR REPLY BELONGS **********

On Wednesday 19 Nov 2014, Jayson Baker wrote:

[jayson at spectrasurf.com]

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_list@earthshod.co.uk (asterisk_list@earthshod.co.uk)> wrote:

[asterisk_list at earth...]

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

[jayson at spectrasurf.com]

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_list@earthshod.co.uk (asterisk_list@earthshod.co.uk)> wrote:

[asterisk_list at earth...]

********** THIS IS NOT WHERE YOUR REPLY BELONGS **********

On Thursday 20 Nov 2014, Jayson Baker wrote:

[jayson at spectrasurf.com]

On Thu, Nov 20, 2014 at 9:47 AM, Jayson Baker <jayson@spectrasurf.com (jayson@spectrasurf.com)> wrote:

[jnovack at stromberg-c...]

Eric Wieling wrote: