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