Re: [asterisk-users] Overriding global voicemail options on a per-mailbox basis

2014-08-21 Thread Jairo
Hi John,

Em 17/08/2014 12:04, Tech Support aster...@voipbusiness.us escreveu:

 So my question is this: Does anyone know which options can and can't
be overridden on a per-mailbox basis? Are there 9 options, are there 39, or
are there 26? Where can I find a definitive answer? It would be extremely
time consuming to test each option individually.


This is not an answer, just an observation ...

The fourth edition of The Asterisk book is based on Asterisk 11.

Best.
-- 
_
-- 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] 'restart when convenient'

2014-05-29 Thread Jairo
Hi Matthew,

Em 28/05/2014 15:09, Matthew Jordan mjor...@digium.com escreveu:

 * now - tell all CDRs to go submit themselves. Tell all channels to

Where CDR is quoted is it also valid for CEL?

Tks.
-- 
_
-- 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] CEL Park APP_START and APP_END events

2014-04-09 Thread Jairo
Dear friends,

In Asterisk 11.7.0, is it possible to receive CEL APP_START and
APP_END events from Park application?

Queue and Dial apps are generation these events, but Park no. It
doesn't seem to make difference when configured.

cel.conf

...
apps = dial,queue,confbridge,park
events = ALL
...

localhost*CLI cel show status
...
CEL Tracking Application: queue
CEL Tracking Application: confbridge
CEL Tracking Application: dial
CEL Tracking Application: park
...

Tks.

-- 
_
-- 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] No voice when the calls come from Internet

2014-04-09 Thread Jairo
 Do you have any idea when the voice is heard only when the call is from my
 local network to the Internet and not in the other direction ?

Hi Neo,

In the documentation look for this options:

externip
localnet
nat

It helps to understand them because this kind of situation is common with VOIP.

Best.

-- 
_
-- 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 11, CEL and ConfBridge recordings

2014-03-07 Thread Jairo
Thank you very much Rusty.

It really works. Even if ${MyCustomFileName} gets a different value when
the second participant enters the conference, the filename remains the name
defined when the first participant enters (because he started the
conference).

Another thing, if I need to know the time a conference ended should I use
CEL or is there another better approach?

Best.


2014-03-06 21:28 GMT-03:00 Rusty Newton rnew...@digium.com:

 On Wed, Mar 5, 2014 at 1:30 PM, Jairo jairomolin...@gmail.com wrote:
  Dear friends,
 
  Need to know filenames of conference recordings in Asterisk 11.
 
  Besides directory scanning the recordings could use CEL:
 
  Filter MySQL rows with eventtype equal CHAN_START and channame like
  ConfBridgeRecorder and then get the eventtime field and convert to
 timestamp
  to complete filename(s).
 
  Would you suggest any other approaches?

 You might set the record file path yourself through the CONFBRIDGE
 function, for example, in dialplan:

 ...stuff up here to build a unique file name into MyCustomFileName...
 exten = 1,n,Set(CONFBRIDGE(user,record_file)=${MyCustomFileName}.wav)

 Then of course you now know the file name so you could do whatever you
 wanted with it afterwards.

 https://wiki.asterisk.org/wiki/display/AST/Asterisk+11+Function_CONFBRIDGE

 --
 Rusty Newton
 Digium, Inc. | Community Support Manager
 445 Jan Davis Drive NW - Huntsville, AL 35806 - US
 direct: +1 256 428 6200

 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] Asterisk 11, CEL and ConfBridge recordings

2014-03-07 Thread Jairo
Great :)

Thank you very much.

Best.


2014-03-07 18:07 GMT-03:00 Rusty Newton rnew...@digium.com:

 On Fri, Mar 7, 2014 at 7:21 AM, Jairo jairomolin...@gmail.com wrote:
  Thank you very much Rusty.
 
  It really works. Even if ${MyCustomFileName} gets a different value when
 the
  second participant enters the conference, the filename remains the name
  defined when the first participant enters (because he started the
  conference).
 
  Another thing, if I need to know the time a conference ended should I use
  CEL or is there another better approach?

 If you can get it from CEL, there is that, otherwise you can track
 when you receive the AMI event ConfbridgeEnd


 https://wiki.asterisk.org/wiki/display/AST/Asterisk+11+ManagerEvent_ConfbridgeEnd

 That is all I got from poking around the docs. :)

 --
 Rusty Newton
 Digium, Inc. | Community Support Manager
 445 Jan Davis Drive NW - Huntsville, AL 35806 - US
 direct: +1 256 428 6200

 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

[asterisk-users] Asterisk 11, CEL and ConfBridge recordings

2014-03-05 Thread Jairo
Dear friends,

Need to know filenames of conference recordings in Asterisk 11.

Besides directory scanning the recordings could use CEL:

Filter MySQL rows with eventtype equal CHAN_START and channame like
ConfBridgeRecorder and then get the eventtime field and convert to
timestamp to complete filename(s).

Would you suggest any other approaches?

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] how to selectively disable callerid block?

2014-02-13 Thread Jairo
Hi Eric,

Take a look at the call pickup code, maybe you need to change it to not
conflict with your dialplan:

localhost*CLI features show
Builtin Feature   Default Current
---   --- ---
Pickup*8  *8
Blind Transfer#   #1
Attended Transfer #2
One Touch Monitor
Disconnect Call   *   *
Park Call #3
One Touch MixMonitor



2014-02-12 21:23 GMT-02:00 Eric Cooper e...@cmu.edu:

 In Asterisk 1.8, I used the following line in extensions.conf to allow
 me to pass *82 in front of a dialed number, to disable the callerid
 block that's normally on that POTS line:

 ; disable callerid block
 exten = _*82.,1,Dial(${POTS}/${EXTEN})

 But this seems to have stopped working when I upgraded to Asterisk
 11.7.  I get the following debug output, with a no call pickup
 possible message as soon as I press the '8':

 [Feb 12 18:17:39] -- Starting simple switch on 'DAHDI/2-1'
 [Feb 12 18:17:39] DEBUG[2339]: devicestate.c:442 devstate_event: device
 'DAHDI/2' state '2'
 [Feb 12 18:17:42] DEBUG[5898][C-000e]: sig_analog.c:1600
 analog_handle_dtmf: Begin DTMF digit: 0x2A '*' on DAHDI/2-1
 [Feb 12 18:17:42] DEBUG[5898][C-000e]: chan_dahdi.c:2145
 my_handle_dtmf: Begin DTMF digit: 0x2A '*' on DAHDI/2-1
 [Feb 12 18:17:42] DEBUG[5898][C-000e]: sig_analog.c:1600
 analog_handle_dtmf: End DTMF digit: 0x2A '*' on DAHDI/2-1
 [Feb 12 18:17:42] DEBUG[5898][C-000e]: chan_dahdi.c:2145
 my_handle_dtmf: End DTMF digit: 0x2A '*' on DAHDI/2-1
 [Feb 12 18:17:42] DEBUG[5898][C-000e]: sig_analog.c:2121
 __analog_ss_thread: waitfordigit returned '*' (42), timeout = 0
 [Feb 12 18:17:44] DEBUG[5898][C-000e]: sig_analog.c:1600
 analog_handle_dtmf: Begin DTMF digit: 0x38 '8' on DAHDI/2-1
 [Feb 12 18:17:44] DEBUG[5898][C-000e]: chan_dahdi.c:2145
 my_handle_dtmf: Begin DTMF digit: 0x38 '8' on DAHDI/2-1
 [Feb 12 18:17:44] DEBUG[5898][C-000e]: sig_analog.c:1600
 analog_handle_dtmf: End DTMF digit: 0x38 '8' on DAHDI/2-1
 [Feb 12 18:17:44] DEBUG[5898][C-000e]: chan_dahdi.c:2145
 my_handle_dtmf: End DTMF digit: 0x38 '8' on DAHDI/2-1
 [Feb 12 18:17:44] DEBUG[5898][C-000e]: sig_analog.c:2121
 __analog_ss_thread: waitfordigit returned '8' (56), timeout = 0
 [Feb 12 18:17:44] DEBUG[5898][C-000e]: chan_dahdi.c:5075
 dahdi_enable_ec: Enabled echo cancellation on channel 2
 [Feb 12 18:17:44] DEBUG[5898][C-000e]: features.c:7880
 ast_pickup_call: pickup attempt by DAHDI/2-1
 [Feb 12 18:17:44] DEBUG[5898][C-000e]: features.c:7900
 ast_pickup_call: No call pickup possible... for DAHDI/2-1
 [Feb 12 18:17:44] DEBUG[5898][C-000e]: sig_analog.c:2211
 __analog_ss_thread: No call pickup possible...

 and then a busy signal.

 I didn't pay much attention to the differences between Asterisk 1.8
 and 11.7 since everything seemed to still work ... Can someone point
 me in the right direction?

 --
 Eric Cooper e c c @ c m u . e d u

 --
 _
 -- 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] how to selectively disable callerid block?

2014-02-13 Thread Jairo
Thanks for the feedback.

Best.


2014-02-13 13:16 GMT-02:00 Eric Cooper e...@cmu.edu:

 On Thu, Feb 13, 2014 at 10:09:04AM -0200, Jairo wrote:
  Take a look at the call pickup code, maybe you need to change it to not
 conflict
  with your dialplan:
  localhost*CLI features show
  Builtin Feature Default Current
  --- --- ---
  Pickup *8 *8
  Blind Transfer # #1
  Attended Transfer #2
  One Touch Monitor
  Disconnect Call * *
  Park Call #3
  One Touch MixMonitor

 Thank you, that was indeed the issue.

 --
 Eric Cooper e c c @ c m u . e d u

 --
 _
 -- 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] CEL for attented transfer

2013-11-20 Thread Jairo
Hi Jean.

I am not sure but believe the sequence of CEL events should be considered
for a more detailed understanding of a call.

Replicating the case you described I got this CEL event and fields:

*** 17. row ***
 id: 27984
  eventtype: ATTENDEDTRANSFER
  eventtime: 2013-11-20 15:05:33
userdeftype:
   cid_name: Jairo desktop
cid_num: 311
cid_ani: 311
  cid_rdnis:
   cid_dnid: 310
  exten: 310
context: entrada-canal
   channame: SIP/311-351096-048d
appname: Dial
appdata: SIP/310-777940,40,kKtT
   amaflags: 3
accountcode:
peeraccount:
   uniqueid: 1384967109.1184
   linkedid: 1384967109.1184
  userfield:
   peer: Local/321@entrada-canal-0001;1

The 3 extensions can be found in the event. Does it help?


2013/11/19 Jean-Denis Girard jd.gir...@sysnux.pf

 -BEGIN PGP SIGNED MESSAGE-
 Hash: SHA1

 Hi Jairo,

 Le 19/11/2013 01:36, Jairo a écrit :
  https://wiki.asterisk.org/wiki/display/AST/CEL+Events+and+Fields

 Thanks for your reply, but I have read this page of the wiki, I know
 what the fields mean.

 What I don't understand is how the events in my example can be used to
 determine 107 was attended transferred to 103 by 100.

 Or I do know that Local/103@100-0042;1 and Local/103@100-0042;2 were
 created by asterisk when SIP/100-0275 asked for atxfer?

 How does the event ATTENDEDTRANSFER/ SIP/107-0274/ Local/103@100-0042;1
 show that 107 is transferred to 103?


 Thanks,
 - --
 Jean-Denis Girard

 SysNux  Systèmes  Linux  en Polynésie française
 http://www.sysnux.pf/   Tél: +689 50 10 40 / GSM: +689 79 75 27
 -BEGIN PGP SIGNATURE-

 iEYEARECAAYFAlKLi74ACgkQuu7Rv+oOo/hbXQCfbznLU4gcYBlz2OTATRQxrZlv
 0DoAoLLYF+ykKuQtRPusTsVOrk/BcQQI
 =eO3S
 -END PGP SIGNATURE-

 --
 _
 -- 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] CEL for attented transfer

2013-11-19 Thread Jairo
Hi Jean, you mean what each event indicates? As this link explain?

https://wiki.asterisk.org/wiki/display/AST/CEL+Events+and+Fields



2013/11/19 Jean-Denis Girard jd.gir...@sysnux.pf

 -BEGIN PGP SIGNED MESSAGE-
 Hash: SHA1

 Nobody, really?


 Thanks,
 - --
 Jean-Denis Girard

 SysNux  Systèmes  Linux  en Polynésie française
 http://www.sysnux.pf/   Tél: +689 50 10 40 / GSM: +689 79 75 27

 Le 17/11/2013 19:03, Jean-Denis Girard a écrit :
  Hi list,
 
  I'm trying to use CEL to display channel information in real time. It
  works fine for simple calls, blind transfers, or SIP attended transfers
  (initiated from the SIP phone). My problem is for Asterisk attended
  transfers (atxfer as configured in features.conf).
 
  The scenario is:
   . phone 107 calls phone 100,
   . 100 dials the atxfer code,
   . 107 is on hold, and 100 hears the transfer message,
   . 100 dials phone 103,
   . 103 answers,
   . 100 hangups,
   . 107 and 103 are connected,
   . 107 hangups.
 
  CEL is configured with apps=all and events=ALL, and events are stored in
  a database via cel_pgsql.
 
  This is the list of events in the database for this call:
 
 eventtype |channame| peer
  -
 
 -++---
  CHAN_START   | SIP/107-0274   |
  CHAN_START   | SIP/100-0275   |
  ANSWER   | SIP/100-0275   |
  ANSWER   | SIP/107-0274   |
  BRIDGE_START | SIP/107-0274   | SIP/100-0275
  CHAN_START   | Local/103@100-0042;1   |
  CHAN_START   | Local/103@100-0042;2   |
  CHAN_START   | SIP/103-0276   |
  ANSWER   | SIP/103-0276   |
  ANSWER   | Local/103@100-0042;2   |
  BRIDGE_START | Local/103@100-0042;2   | SIP/103-0276
  ANSWER   | Local/103@100-0042;1   |
  BRIDGE_START | SIP/100-0275   | Local/103@100-0042;1
  BRIDGE_END   | SIP/100-0275   | Local/103@100-0042;1
  ATTENDEDTRANSFER | SIP/107-0274   | Local/103@100-0042;1
  CHAN_START   | Transfered/SIP/107-0274|
  BRIDGE_END   | Transfered/SIP/107-0274ZOMBIE| SIP/100-0275
  BRIDGE_START | SIP/107-0274   | Local/103@100-0042;1
  HANGUP   | SIP/100-0275   |
  CHAN_END | SIP/100-0275   |
  HANGUP   | Transfered/SIP/107-0274ZOMBIE|
  CHAN_END | Transfered/SIP/107-0274ZOMBIE|
  BRIDGE_END   | SIP/107-0274   | Local/103@100-0042;1
  HANGUP   | Local/103@100-0042;1   |
  CHAN_END | Local/103@100-0042;1   |
  HANGUP   | SIP/107-0274   |
  CHAN_END | SIP/107-0274   |
  BRIDGE_END   | Local/103@100-0042;2   | SIP/103-0276
  HANGUP   | SIP/103-0276   |
  CHAN_END | SIP/103-0276   |
  HANGUP   | Local/103@100-0042;2   |
  CHAN_END | Local/103@100-0042;2   |
  LINKEDID_END | Local/103@100-0042;2   |
  (33 lignes)
 
  How should these events be interpreted?
 
 
  Asterisk version is 11.6.0.
 
 
  Thanks,
 
 -BEGIN PGP SIGNATURE-

 iEYEARECAAYFAlKK6p0ACgkQuu7Rv+oOo/heAACeN0eMR1qwRLcdV+Tsgn9fA+6c
 RKcAn246hmNUU2dxivPFEziueHYRTWcS
 =q196
 -END PGP SIGNATURE-

 --
 _
 -- 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] CEL events

2013-07-03 Thread Jairo
Dear list.

This is probably a complex subject but is that right to consider:

a) each distinct linkedid field value in a mysql CEL table as a unique call?

b) the duration of a call as the period (eventtime fields) between
BRIDGE_END and BRIDGE_START events of the same linkedid sequence? (not
considering transfers)

Just a start ...

Tks.
--
_
-- 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 fax in debian

2013-06-13 Thread Jairo
Maybe this can help:

http://ofps.oreilly.com/titles/9781449332426/asterisk-Fax.html

Best.


2013/6/13 vortex binary.vor...@gmail.com

 Hello. i am running debian 6 with asterisk 11.4. The system has exim4 to
 send to email the voicemails.
 i would like to get rid of the analog fax machine and use asterisk to
 send/receive faxes.
 I do have a PSTN line with a SPA3102 adapter to interface it to asterisk.
 The number of the PSTN line is dedicated to faxing only. So i would like to:
 -receive faxes to asterisk and then send it as PDFs to an email address
 -Send from my PC a fax directly.

 is there any guide on how to do that since i got lost with all of 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-**usershttp://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] Is uniqueid/sequence a safe CDR table primary key ?

2013-06-11 Thread Jairo
Hello,

Still about CDR and MySQL table, should the calldate field be inserted by
Asterisk?

This is the table structure we are using, based on Asterisk wiki:

mysql describe cdr;
+-+---+--+-+-++
| Field   | Type  | Null | Key | Default |
Extra  |
+-+---+--+-+-++
| id  | mediumint(8) unsigned | NO   | PRI | NULL|
auto_increment |
| calldate| datetime  | NO   | | -00-00 00:00:00
||
| clid| varchar(80)   | NO   | |
||
| src | varchar(80)   | NO   | |
||
| dst | varchar(80)   | NO   | |
||
| dcontext| varchar(80)   | NO   | |
||
| channel | varchar(80)   | NO   | |
||
| dstchannel  | varchar(80)   | NO   | |
||
| lastapp | varchar(80)   | NO   | |
||
| lastdata| varchar(80)   | NO   | |
||
| duration| int(11)   | NO   | | 0
||
| billsec | int(11)   | NO   | | 0
||
| disposition | varchar(45)   | NO   | |
||
| amaflags| int(11)   | NO   | | 0
||
| accountcode | varchar(20)   | NO   | |
||
| uniqueid| varchar(32)   | NO   | |
||
| userfield   | varchar(255)  | NO   | |
||
| peeraccount | varchar(20)   | NO   | |
||
| linkedid| varchar(32)   | NO   | |
||
| sequence| int(11)   | NO   | | 0
||
+-+---+--+-+-++
20 rows in set (0.01 sec)

Thank you!



2013/6/4 Olivier oza_4...@yahoo.fr

 OK, then I'll go with linkedid, uniqueid and sequence number.

 Thanks for sharing this on this list


 2013/6/3 Matthew Jordan mjor...@digium.com

 On 06/03/2013 11:20 AM, Olivier wrote:
  Hi,
 
  When dealing with CDR SQL tables, I always added an auto-incremented
  cdr_id key as a primary key, just in case provided uniqueid key went
 wrong.
 
  Now I'm facing a situation where I need to insert into a database's
  table and from the dialplan, a reference to the CDR record which is
  currently processed.
 
  So my questions are:
 
  1. Can uniqueid/sequence (or uniqueid/sequence/calldate) bundle be
  safely used as CDR's table primary key  (ie I cannot have any
  uniqueid/sequence combination from one CDR record to match a past
  uniqueid/sequence combination) ?

 Possibly. Things to keep in mind:

 * You can run into uniqueid collisions across multiple systems if you do
 not specify a system name in asterisk.conf or do not specify a unique
 system name in asterisk.conf.
 * You can run into uniqueid collisions if your system clock goes
 backwards for any reason (the uniqueid for a channel happens to use a
 timestamp for its uniqueness)

 Whether or not this is unique enough will be completely dependent on
 your overall system configuration.

 In general, the recommended combination that *should* uniquely specify a
 CDR (when configured correctly) is linkedid (which should be enabled and
 added to your schema), uniqueid, and sequence number, with the asterisk
 system name specified.

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




-- 
Jairo Molina Jr∴
http://www.intermol.com.br
--
_
-- 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

Re: [asterisk-users] Is uniqueid/sequence a safe CDR table primary key ?

2013-06-11 Thread Jairo
Yes, using cdr_adaptive_odbc.conf.

As it is a new table, just changed the name from calldate to start and now
it is inserting the field ok.

Thank you very much for your help.

Best.


2013/6/11 Kevin Larsen kevin.lar...@pioneerballoon.com

 Are you using cdr_adaptive_odbc.conf to populate it? If so, there is no
 Asterisk analog to calldate. You would need an alias set up. Mine looks
 like:

 alias start = calldate

 so that the start of my call is what gets logged to the database as the
 calldate.

 Kevin Larsen



 From:Jairo ja...@intermol.com.br
 To:Asterisk Users Mailing List - Non-Commercial Discussion 
 asterisk-users@lists.digium.com,
 Date:06/11/2013 08:28 AM
 Subject:Re: [asterisk-users] Is uniqueid/sequence a safe CDR
 table primary key ?
 Sent by:asterisk-users-boun...@lists.digium.com
 --



 Hello,

 Still about CDR and MySQL table, should the calldate field be inserted by
 Asterisk?

 This is the table structure we are using, based on Asterisk wiki:

 mysql describe cdr;

 +-+---+--+-+-++
 | Field   | Type  | Null | Key | Default |
 Extra  |

 +-+---+--+-+-++
 | id  | mediumint(8) unsigned | NO   | PRI | NULL|
 auto_increment |
 | calldate| datetime  | NO   | | -00-00 00:00:00
 ||
 | clid| varchar(80)   | NO   | |
 ||
 | src | varchar(80)   | NO   | |
 ||
 | dst | varchar(80)   | NO   | |
 ||
 | dcontext| varchar(80)   | NO   | |
 ||
 | channel | varchar(80)   | NO   | |
 ||
 | dstchannel  | varchar(80)   | NO   | |
 ||
 | lastapp | varchar(80)   | NO   | |
 ||
 | lastdata| varchar(80)   | NO   | |
 ||
 | duration| int(11)   | NO   | | 0
 ||
 | billsec | int(11)   | NO   | | 0
 ||
 | disposition | varchar(45)   | NO   | |
 ||
 | amaflags| int(11)   | NO   | | 0
 ||
 | accountcode | varchar(20)   | NO   | |
 ||
 | uniqueid| varchar(32)   | NO   | |
 ||
 | userfield   | varchar(255)  | NO   | |
 ||
 | peeraccount | varchar(20)   | NO   | |
 ||
 | linkedid| varchar(32)   | NO   | |
 ||
 | sequence| int(11)   | NO   | | 0
 ||

 +-+---+--+-+-++
 20 rows in set (0.01 sec)

 Thank you!



 2013/6/4 Olivier *oza_4...@yahoo.fr* oza_4...@yahoo.fr
 OK, then I'll go with linkedid, uniqueid and sequence number.

 Thanks for sharing this on this list


 2013/6/3 Matthew Jordan *mjor...@digium.com* mjor...@digium.com
 On 06/03/2013 11:20 AM, Olivier wrote:
  Hi,
 
  When dealing with CDR SQL tables, I always added an auto-incremented
  cdr_id key as a primary key, just in case provided uniqueid key went
 wrong.
 
  Now I'm facing a situation where I need to insert into a database's
  table and from the dialplan, a reference to the CDR record which is
  currently processed.
 
  So my questions are:
 
  1. Can uniqueid/sequence (or uniqueid/sequence/calldate) bundle be
  safely used as CDR's table primary key  (ie I cannot have any
  uniqueid/sequence combination from one CDR record to match a past
  uniqueid/sequence combination) ?

 Possibly. Things to keep in mind:

 * You can run into uniqueid collisions across multiple systems if you do
 not specify a system name in asterisk.conf or do not specify a unique
 system name in asterisk.conf.
 * You can run into uniqueid collisions if your system clock goes
 backwards for any reason (the uniqueid for a channel happens to use a
 timestamp for its uniqueness)

 Whether or not this is unique enough will be completely dependent on
 your overall system configuration.

 In general, the recommended combination that *should* uniquely specify a
 CDR (when configured correctly) is linkedid (which should be enabled and
 added to your schema), uniqueid, and sequence number, with the asterisk
 system name specified.

 --
 Matthew Jordan
 Digium, Inc. | Engineering Manager
 445 Jan Davis Drive NW - Huntsville, AL 35806 - USA
 Check us out at: *http://digium.com* http://digium.com/  *
 http://asterisk.org* http://asterisk.org/



 --
 _
 -- Bandwidth and Colocation Provided by 
 *http://www.api-digital.com*http://www.api-digital.com/--
 New

[Asterisk-Users] Unable to reconfigure channel

2005-06-20 Thread Jairo Barahona








Hi all,



I have a problem with the cvs head zaptel library: I cannot
update my zapata.conf into asterisk when I issue the reload command from the
CLI prompt; only when I stop and restart the asterisk service.



The system sends the following message:



 Jun 20 09:49:14 WARNING[3754]:
chan_zap.c:10364 setup_zap: Ignoring switchtype

Jun 20 09:49:14 WARNING[3754]: chan_zap.c:10364 setup_zap: Ignoring
signalling

 -- Reconfigured channel 1, FXS Kewlstart
signalling

 -- Reconfigured channel 2, FXS Kewlstart
signalling

 -- Reconfigured channel 3, FXS Kewlstart
signalling

Jun 20 09:49:14 ERROR[3754]: chan_zap.c:9827 setup_zap: Unable to
reconfigure channel '4'

Jun 20 09:49:14 WARNING[3754]: chan_zap.c:10567 reload: Reload of
chan_zap.so is unsuccessful!



I have the simplest configuration:



 [trunkgroups]

[channels]

language=en

context=default

switchtype=national

 

signalling=fxs_ks

channel = 1

channel = 2

channel = 3



I was using the cvs head version because I need the
wctdm driver for the TDM04B (4*fxo modules)

Does anybody know what is wrong?



Thanks in advance!!



Jairo Barahona Garita

inCom Developer 






___
Asterisk-Users mailing list
Asterisk-Users@lists.digium.com
http://lists.digium.com/mailman/listinfo/asterisk-users
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users

[Asterisk-Users] E1 (Digium E100P) problem : B-channel succesfully restarted.

2005-05-10 Thread Jairo Buendia
Hi!
I have an Asterisk Box with one E1. This is connected
with PSTN. My problem is that periodically the
Asterisk console shows the following message.

-- B-channel 0/1 succesfully restarted on span 1
-- B-channel 0/2 succesfully restarted on span 1
-- B-channel 0/3 succesfully restarted on span 1
-- B-channel 0/4 succesfully restarted on span 1
-- B-channel 0/5 succesfully restarted on span 1
-- B-channel 0/6 succesfully restarted on span 1
-- B-channel 0/7 succesfully restarted on span 1
-- B-channel 0/8 succesfully restarted on span 1
-- B-channel 0/9 succesfully restarted on span 1
-- B-channel 0/10 succesfully restarted on span 1
-- B-channel 0/11 succesfully restarted on span 1
-- B-channel 0/12 succesfully restarted on span 1
-- B-channel 0/13 succesfully restarted on span 1
-- B-channel 0/14 succesfully restarted on span 1
-- B-channel 0/15 succesfully restarted on span 1
-- B-channel 0/16 succesfully restarted on span 1
-- B-channel 0/17 succesfully restarted on span 1
-- B-channel 0/18 succesfully restarted on span 1
-- B-channel 0/19 succesfully restarted on span 1
-- B-channel 0/20 succesfully restarted on span 1
-- B-channel 0/21 succesfully restarted on span 1
-- B-channel 0/22 succesfully restarted on span 1
-- B-channel 0/23 succesfully restarted on span 1
-- B-channel 0/24 succesfully restarted on span 1
-- B-channel 0/25 succesfully restarted on span 1
-- B-channel 0/26 succesfully restarted on span 1
-- B-channel 0/27 succesfully restarted on span 1
-- B-channel 0/28 succesfully restarted on span 1
-- B-channel 0/29 succesfully restarted on span 1
-- B-channel 0/30 succesfully restarted on span 1
-- B-channel 0/31 succesfully restarted on span 1

I have look for in the source code to check the
meaning  of this message but I haven't found anything.
The only thing that I could check, It's that T203=10
seg and T200=1 seg. For example, Cisco has T203=30
seg. 

In http://www.acacia-net.com/wwwcla/protocol/q921.htm
I  read the meaning of those timers. Could Asterisk
restart E1 because It don't recieve anything before
T203 finished?

My configuration is:

/etc/zaptel.conf
span=1,1,0,ccs,hdb3
bchan=1-15,17-31
dchan=16

I don't know if this behavior is correct. Can someone
help me?

Thanks in advance.





__ 
Renovamos el Correo Yahoo!: ¡250 MB GRATIS! 
Nuevos servicios, más seguridad 
http://correo.yahoo.es
___
Asterisk-Users mailing list
Asterisk-Users@lists.digium.com
http://lists.digium.com/mailman/listinfo/asterisk-users
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users


Re: [Asterisk-Users] Re: E1 (Digium E100P) problem : B-channel succesfully restarted

2005-05-10 Thread Jairo Buendia
 Hi!
 I have an Asterisk Box with one E1. This is
connected
 with PSTN. My problem is that periodically the
 Asterisk console shows the following message.
 
 -- B-channel 0/1 succesfully restarted on span 1
 -- B-channel 0/2 succesfully restarted on span 1
 [..etc...]
 
 I don't know if this behavior is correct. Can
someone
 help me?

Perfectly normal behaviour. Once an hour, idle
channels are restarted,
but active channels are left undisturbed.

Thanks tony,
why are the idle channels restarted?, the PSTN could
think that my box has some problem. Perhaps, other
equipments also make the same but I don't know
anything about it. I used Access Server of Cisco and I
think that the channels weren't restarted.







__ 
Renovamos el Correo Yahoo! 
Nuevos servicios, más seguridad 
http://correo.yahoo.es
___
Asterisk-Users mailing list
Asterisk-Users@lists.digium.com
http://lists.digium.com/mailman/listinfo/asterisk-users
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users


[Asterisk-Users] Stun codec

2005-05-10 Thread Jairo Buendia
You can use Ethereal to see what your phone (stun) is
sending. Of this way you can see the RTP ports and IP
public that your phones are going to use. You can see
that information in INVITE and OK packets.

For other hand, If you use one router with symmetrical
NAT then Stun won't work
http://www.networkmagazine.com/shared/article/showArticle.jhtml?articleId=17602009classroom=




__ 
Renovamos el Correo Yahoo! 
Nuevos servicios, más seguridad 
http://correo.yahoo.es
___
Asterisk-Users mailing list
Asterisk-Users@lists.digium.com
http://lists.digium.com/mailman/listinfo/asterisk-users
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users


[Asterisk-Users] Asterisk and T.38.

2005-04-21 Thread Jairo Buendia
Hi Rafa!


Hi Jairo,

Try with other values for the jitter in your Gateway
(H323). 

One customer have a scenario like this:

Phone/Fax  Gateways H323 -with 16/8/2/1 Port
FXS-  --- GNUGK
--- Asterisk --- Zap (E1) 

We have the same configuration, and I think that our
problem is the jitter in Asterisk, since we have
jitterMin=0ms and jitterMax=0ms. We changed
chan_oh323.c because it didn't accept jitter less than
20ms (We used Asterisk to translate SIP --
H323--Cisco, and the Cisco have jitter buffer, so we
didn't need jitter buffer in Asterisk).

Now, we have put:

oh323.conf ---
jitterMin=20ms
jitterMax=20ms

codec=G711A
frames=20

zapata.conf ---
jitterbuffers=20ms

but fax still doesn't work. Anyideas?

Other question.
If Asterisk hasn't T.38 then Fax will need 64Kbps
(G711)+ 16Kbps (IP+UDP+RTP) bandwidth, and that is
much bandwidth. Is this correct?, Do you know any
comercial implementation of T.38 to Asterisk?

Thanks.










__ 
Renovamos el Correo Yahoo!: ¡250 MB GRATIS! 
Nuevos servicios, más seguridad 
http://correo.yahoo.es
___
Asterisk-Users mailing list
Asterisk-Users@lists.digium.com
http://lists.digium.com/mailman/listinfo/asterisk-users
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users


[Asterisk-Users] Asterisk and T.38.

2005-04-19 Thread Jairo Buendia
Hi!
I want to send fax to PSTN with Asterisk, but by now I
can't. 
I am using the following boxs:

  Internet  Zap E1
 Phone/Fax Gateway(H323)--- Asterisk--- PSTN

The gateway H323 has T38 and T30. Before I began with
Asterisk, I used Cisco to connect with PSTN, and the
Fax worked very well in T38 (T30 didn't work, I think
the reason is the jitter). 

I have read that Asterisk doesn't support T.38, is
this correct?, is there any comercial implementation
in Asterisk?.

If Asterisk doesn't support T.38, how can I use it to
send fax to PSTN?

Thanks in advance.



__ 
Renovamos el Correo Yahoo!: ¡250 MB GRATIS! 
Nuevos servicios, más seguridad 
http://correo.yahoo.es
___
Asterisk-Users mailing list
Asterisk-Users@lists.digium.com
http://lists.digium.com/mailman/listinfo/asterisk-users
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users


[Asterisk-Users] Asterisk Clients

2004-06-15 Thread Jairo Cavanus
Hello,


I am new in Asterisk... and I didn't get to find this information in the
site or in the links that appears in the support section...

The one that I want to know is which are the compatible softwares with
Asterisk (PC working as an extension of the PBX)...

Theoretically, every H.323 client could be connected to Asterisk... am I
right?

With for instance, the projects of the openh323 (http://www.openh323.org)???


Thank you,

Jairo Cavanus

___
Asterisk-Users mailing list
[EMAIL PROTECTED]
http://lists.digium.com/mailman/listinfo/asterisk-users
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users