bilal ghayyad
2011-Oct-25 16:17 UTC
[asterisk-users] Asterisk 1.8 and CDR Mysql: Unqiue ID and if any commands required in extensions.conf
Hi All;
I am using asterisk version 1.8 and I selected CDR mysql from the menuselect
when I was doing the compilation and installation.
How can I know if the unique id will be added to the cdr, and how I can know
which information will be logged, also from where I can new field to be logged
and its location (before or after specific field)?
One more thing: to have cdr, then do I have to write any syntax in the
extensions.conf or there is a defualt fields will be logged without need to
write any syntax? For example I found the below lines and I need to know if I
have to add them or not (actually it might be used only for trunk version which
I am not use but I need to confirm):
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:1111 at sip.proxy.cz
exten => h,n,set(CDR(uri)=${CHANNEL(uri)}) ; like sip:1111 at 10.0.0.5
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)})
Regards
Bilal