Re: [asterisk-users] How to add custom CDR fields to MySQL

[Michael Silveus]

Hi Alex,

I'm having the same problem and there is an open problem report about 
it. However, if you modify your /etc/asterisk/cdr_custom.conf file to 
add the field it will show up in your Master.csv log file but still not 
in the DB record. You could in essence use the log file to rebuilt your 
cdr DB through an external script which you could call through cron or 
possibly at the end of you context inside of asterisk. I haven't written 
the script yet but I bet someone out there has.

Regards,
Mike

Emanuele Carbone wrote:
 Hi,

 i think that you should modify the cdr_addon_mysql module, otherwise 
 you can add it in the userfield.

 2010/3/11 Alejandro Recarey alexreca...@gmail.com 
 mailto:alexreca...@gmail.com

 Hi all,

 I've been trying to add a custom mysql field to my CDR's, but I must
 be doing something wrong.

 I am using asterisk 1.4 and asterisk 1.6, in extensions.conf I add:

 exten = h,1,Set(CDR(q931)=${HANGUPCAUSE})

 This extension is executed, I can see it in the asterisk console.

 I have added a new column in my MySQL database called q931. However,
 the new field does not show up in my database or in the Master.csv
 file.

 Any help would be greatly appreciated.

 Regards,

 Alex

 --
 _
 -- 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] auto-dail for ZAP channel, the application gets executed before the call attended

[Michael Silveus]

I'm still trying to accomplish the same thing and a solution might come from
Newman Telecom but I'm still waiting to see. Note: I have no affiliation
with Newman Telecom but they're application code appears to be the closest
to what I'm looking for.

The problem is because asterisk needs a way of emulating answer supervision
on the FXO circuit, which it does not currently have. If you tested your
callout on a local extension or VOIP it works because it traps events
internally for all extensions. But once you do a handoff to an outside line
that's the end of asterisk knowledge base until someone out there creates an
addon patch to do answer supervision for those outside lines. The problem is
that world wide there is no standard signaling tones for ringing, busy, fax,
answering machines, etc. The indications file does a great job of defining
the basics but let's say you're in the US so * is defined for US but if you
are calling internationally the ring back tones you receive will vary
greatly.

Mike

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of John Joseph
Sent: Monday, May 01, 2006 9:18 AM
To: Asterisk Users
Subject: [Asterisk-Users] auto-dail for ZAP channel,the application gets
executed before the call attended 



Hi All 
   when I try to use auto-dial to connect to
outside phone , my applications get executed before
the caller attend the calls , this happens only when I
call outside no , ie when I use 
Channel: ZAP/1/050745 in my sample.call file , if 
I use Channel:SIP/326 ,  it works  fine 
  my sample.call file contains 
Channel: ZAP/1/050745
Callerid: Asterisk
MaxRetries: 2
RetryTime: 10
WaitTime: 60
Context: outboundmsg1
Extension: s
Priority: 1

and my extensions.conf file  contains
[outboundmsg1]
exten = s,1,DigitTimeout,5
exten = s,2,ResponseTimeout,30   
exten = s,3,Answer
exten = s,4,Wait(1)
exten = s,5,Cepstral(Hi ,, Hope u are getting this
voices, It is text to Voice  conversation , did u hear
it  )  
exten = 1,1,Goto(s,5)   ; replay message
exten = 2,1,Goto(msgack,s,1) ; acknowledge message
exten = t,1,Playback(vm-goodbye)
exten = t,2,Hangup

  Guidance requested , to know the
reason , why the  Ceptral  application is executed ,
before the call is attended when I user ZAP channel .
But  for  SIP channel (only SIP internal call , I made
) it is working fine 
Thanks 
Joseph John 



 





___ 
Win tickets to the 2006 FIFA World Cup Germany with Yahoo! Messenger.
http://advision.webevents.yahoo.com/fifaworldcup_uk/
___
--Bandwidth and Colocation provided by Easynews.com --

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


___
--Bandwidth and Colocation provided by Easynews.com --

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