for the record
(added to http://www.voip-info.org/wiki/view/Asterisk+cdr+mysql)

some_context
;dial trunk
exten => _X.,1,Dial(SIP/trunk/${EXTEN})

;exten h must be in same context!
exten => h,1,noop("extended CDR")
exten => h,n,set(CDR(hangupcause)=${HANGUPCAUSE})                  ; hangupcause
exten => h,n,set(CDR(peerip)=${CHANNEL(peerip)})                   ; like 
10.0.0.5 if behind nat
exten => h,n,set(CDR(recvip)=${CHANNEL(recvip)})                   ; like 
194.79.52.192 - public ip
exten => h,n,set(CDR(from)=${CHANNEL(from)})                       ; like 
sip:[email protected]
exten => h,n,set(CDR(uri)=${CHANNEL(uri)})                         ; like 
sip:[email protected]
exten => h,n,set(CDR(useragent)=${CHANNEL(useragent)})             ; useragent 
like Aastra_57i
exten => h,n,set(CDR(codec1)=${CHANNEL(audioreadformat)})          ; codec *
exten => h,n,set(CDR(codec2)=${CHANNEL(audiowriteformat)})         ;
exten => h,n,set(CDR(llp)=${CHANNEL(rtpqos,audio,local_lostpackets)})   ; lost 
packets by local end **
exten => h,n,set(CDR(rlp)=${CHANNEL(rtpqos,audio,remote_lostpackets)})  ; lost 
packets by remote end
exten => h,n,set(CDR(ljitt)=${CHANNEL(rtpqos,audio,local_jitter)})      ; the 
same for jitter
exten => h,n,set(CDR(rjitt)=${CHANNEL(rtpqos,audio,remote_jitter)})

* i dont know if the same channel can have different audioreadformat and 
audiowriteformat. imho not

** RTPAUDIOQOS isnt ok. check 
http://lists.digium.com/pipermail/asterisk-biz/2009-November/031910.html

known problem:
it is only for caller. i dont know how to log call leg B


>> -----Original Message-----
>> From: [email protected]
>> [mailto:[email protected]] On Behalf Of marek cervenka
>> Sent: Monday, November 16, 2009 8:50 AM
>> To: [email protected]
>> Subject: [asterisk-users] asterisk cdr - remote ip address
>>
>> hi,
>>
>> i want add info about remote party ip address to the asterisk cdr table
>>
>> can you recommend me "the system way"?

---------------------------------------
Marek Cervenka
=======================================


_______________________________________________
-- Bandwidth and Colocation Provided by http://www.api-digital.com --

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

Reply via email to