from:"Jayson Baker"

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

2014-11-20 Thread Jayson Baker

On Thu, Nov 20, 2014 at 9:47 AM, Jayson Baker 
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  > 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
>> termin

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

2014-11-20 Thread Jayson Baker

Well exactly where are we supposed to reply then?  Via US Mail?

On Thu, Nov 20, 2014 at 9:56 AM, A J Stiles 
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

2014-11-20 Thread Jayson Baker

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

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

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

2014-11-19 Thread Jayson Baker

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 
wrote:

> 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 
> wrote:
>
>> On Wed, Nov 19, 2014 at 8:30 AM, Jayson Baker 
>> 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   : 
>> >   MD5Secret: 
>> >   Remote Secret: 
>> >   Context  : outbound
>> >   Record On feature : automon
>> >   Record Off feature : automon
>> >   Subscr.Cont. : 
>> >   Language :
>> >   Tonezone : 
>> >   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 m

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  wrote:

> On Wed, Nov 19, 2014 at 8:30 AM, Jayson Baker 
> 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   : 
> >   MD5Secret: 
> >   Remote Secret: 
> >   Context  : outbound
> >   Record On feature : automon
> >   Record Off feature : automon
> >   Subscr.Cont. : 
> >   Language :
> >   Tonezone : 
> >   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

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 (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   : 
  MD5Secret: 
  Remote Secret: 
  Context  : outbound
  Record On feature : automon
  Record Off feature : automon
  Subscr.Cont. : 
  Language :
  Tonezone : 
  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  wrote:

> On Tue, Nov 18, 2014 at 6:36 PM, Jayson Baker 
> 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 extracte

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

2014-11-18 Thread Jayson Baker

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!
-- 
_
-- 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] Asterisk OUtbound IVR Recording

2010-10-09 Thread Jayson Baker

cmd record ?

On Sat, Oct 9, 2010 at 1:28 AM, Govind, Mahesh (NSN - IN/Bangalore) <
mahesh.gov...@nsn.com> wrote:

> HI,
> I have a scenario like the following .
>
> A user clicks on the web page  . This triggers an outbound call to users
> phone number .
> Now the user has to leave a message  .
>
> What is the best way of doing this ? Do we have any example of such a
> dial plan .
> Regards
> Mahesh
>
>
> --
> _
> -- 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] looking for a better ATA

2010-10-08 Thread Jayson Baker

Us too.  Tons of SPA2102's out there working fine!

On Fri, Oct 8, 2010 at 4:36 PM, Jeff LaCoursiere  wrote:

>
>
> On Fri, 8 Oct 2010, Bryant Zimmerman wrote:
>
>  I currently us Linksys/Ciscio, Grandstream and AudioCodes ata's. none of
>> the three perform well in all
>> enviroments. Between stablity issues, T38 and DTMF talkoff all three
>> suffer some combination of issues.
>>
>> I am looking at Patton and Innomedia. Has any one tried either brand and
>> what is your experience with them.
>> Which would be the base for stability, audio quality, provisioning, DTMF
>> talkoff and T38
>>
>> Any advise before I start testing with these brands would be apperciated.
>> Any better option you may know of.
>>
>> Thanks for any input
>>
>> Bryant
>>
>>
>>
> I'm curious which of the above ills you attribute to the Linksys (assuming
> an SPA2102?  The PAP2T does have the T38 problem I believe).  Its basically
> the defacto standard for all the giant ITSPs.  Perhaps your problem is one
> that could be rectified in some way.  I have also tried Grandstream and
> Audiocodes (still use the MP-124s in certain situations) and have found that
> the SPA2102s work the best for us...
>
> Cheers,
>
> j
> --
> _
> -- 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] Checking SIP Headers existence and content

2010-10-07 Thread Jayson Baker

Favorites?  voip-info.org should be your homepage.

On Thu, Oct 7, 2010 at 9:26 AM, Administrator TOOTAI wrote:

> Le 05/10/2010 05:13, VoIP Question a écrit :
> > Hello,
>
> Hi
>
> >
> > I would like to verify if a specific SIP header exists, and if yes,
> > extract the partial content from another header.
> >
> > 1. Is there a way to verify if a specific header exists?
> > 2. How do I extract data that is between the first : and the following
> > @? Specifically, The data looks like  > > and I would like to get only
> > the 1234567890
>
> Something like
>
> exten => s,1,Set(__DIALEDNUMBER=${SIP_HEADER(TO):5})
> exten => s,n,Set(__DIALEDNUMBER=${CUT(DIALEDNUMBER,@,1)})
> exten => s,n,GotoIf($["${DIALEDNUMBER:0:1}" != "+"]?numberIsOK)
> exten => s,n,Set(__DIALEDNUMBER=${CUT(DIALEDNUMBER,+,2)})
>
> Take a look here
>
> http://www.voip-info.org/wiki/view/Asterisk+func+sip_header
>
> voip-info.org should be in your favorites ;-)
>
> --
> Daniel
>
> --
> _
> -- 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] Asterisk Crashed - But why?

2010-08-27 Thread Jayson Baker

There is nothing in /var/log/asterisk... hmm, which log should I turn on?
 Debug?

On Fri, Aug 27, 2010 at 1:25 PM, Tim Nelson  wrote:

> What do the logs in /var/log/asterisk/* tell you?
>
> Tim Nelson
> Systems/Network Support
> Rockbochs Inc.
> (218)727-4332 x105
>
>
> - "Jayson Baker"  wrote:
> > Asterisk crashes from time to time and dumps core.  So... what do I do
> with it?
> > -- _
> -- 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
>
-- 
_
-- 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

[asterisk-users] Asterisk Crashed - But why?

2010-08-27 Thread Jayson Baker

Asterisk crashes from time to time and dumps core.  So... what do I do with
it?
-- 
_
-- 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

[asterisk-users] shrinkcallerid

2010-08-06 Thread Jayson Baker

Am I really the only one having problems with this new "shrinkcallerid"?  I
can't find anything on Google about it.
Was happening on 1.6.2.10 and now on 1.8.0-beta2

In sip.conf shrinkcallerid=no, yet a name like "Joe Smith" ends up being
"JoeSmith"

Whoever though this up anyway is stupid.  Why would you want to strip spaces
out of a caller ID?

Is there a fix?
-- 
_
-- 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

[asterisk-users] Missing Mailboxes on SIP

2010-08-05 Thread Jayson Baker

Suddenly a couple days ago all of our SIP registrations are missing the
Mailbox entry.  We are using MySQL Add-on for realtime.
Anyone have any idea why?  Mailbox is still in the mysql tables.
-- 
_
-- 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

[asterisk-users] No Mailbox Subscription in SIP Users Suddenly

2010-08-04 Thread Jayson Baker

Suddenly the other day we noticed MWI stopped working for SIP clients.

A "sip show peer X" returns this:

ast01*CLI> sip show peer 719XXX


  * Name   : 719XXX
  Realtime peer: Yes, cached
  Secret   : 
  MD5Secret: 
  Remote Secret: 
  Context  : peakinternet-outbound
  Subscr.Cont. : 
  Language : en
  AMA flags: Unknown
  Transfer mode: open
  CallingPres  : Presentation Allowed, Not Screened
  Callgroup:
  Pickupgroup  :
  Mailbox  :
  VM Extension : asterisk


As you can see, there is nothing for "Mailbox"

We are using MySQL Realtime Addon.  In the sip_buddies table, the "mailbox"
column is filled with "719...@default"

--

I thought maybe it was something weird with the SQL table so I backed it up,
deleted it, recreated it, added a single entry and registered that SIP
client.  Same thing.  Everything else in the table (caller ID, pickupgroup,
etc.) will show correctly on "sip show peer" but just not Mailbox.

So I figured maybe it was a bug in 1.6.2.10 so I upgraded to 1.6.2.11-rc2,
but the same thing is happening.



Is this something silly that I'm just overlooking?  I hope someone can help.


Thanks in advance for your help!!
Jayson
-- 
_
-- 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

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

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

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

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

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

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

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

Re: [asterisk-users] Asterisk OUtbound IVR Recording

Re: [asterisk-users] looking for a better ATA

Re: [asterisk-users] Checking SIP Headers existence and content

Re: [asterisk-users] Asterisk Crashed - But why?

[asterisk-users] Asterisk Crashed - But why?

[asterisk-users] shrinkcallerid

[asterisk-users] Missing Mailboxes on SIP

[asterisk-users] No Mailbox Subscription in SIP Users Suddenly

16 matches

Site Navigation

Mail list logo

Footer information