Grygoriy Dobrovolskyy
2008-Aug-29 09:35 UTC
[asterisk-users] Asterisk cdr_mysql inexact values
I have a simple cdr configured with the default tables, here is a row of a good cdr report calldate | clid | src | dst | dcontext | channel | ect ..... ect .... 2008-08-29 10:16:49 | "C. BOUTON" <40> | 40 | XXXXXXXXXXX | phonesystems | SIP/40-08776938 | ect ..... ect .... I have replaced the number by XXXXXXXXXXXXXX, but it is there. But sometimes i get this: calldate | clid | src | dst | dcontext | channel | ect ..... ect .... 2008-08-29 10:17:06 | "C. SAGNIER" <60> | 60 | s | phonesystems | SIP/111-08799690 | ect ..... ect .... You see that s in dst ? I know from where it is coming but i have no idea how to remove it. I am using one macro for dial out, it is easy for me to manage multiple outgoing peers and max channels for them. I am using spriority inside that macro, so somehow cdr SOMETIMES report s as dst. If you can help me to arange my macro to remove that s from cdr or by any advice i would be gratefull. My macro: [macro-phonesystems] exten => s,1,NoOp(We are calling=${ARG1}) exten => s,2,GotoIf($[${GROUP_COUNT(ph0)}>=1]?100:3) exten => s,3,Set(GROUP()=ph0) exten => s,4,Dial(Sip/${ARG1:1}@ovh1,40,TwW) exten => s,5,NoOP(PH0) exten => s,100,GotoIf($[${GROUP_COUNT(ph1)}>=1]?200:101) exten => s,101,Set(GROUP()=ph1) exten => s,102,Dial(Sip/${ARG1:1}@ovh2,40,Tw) exten => s,103,NoOp(PH1) exten => s,200,GotoIf($[${GROUP_COUNT(ph2)}>=2]?300:201) exten => s,201,Set(GROUP()=ph2) exten => s,202,Dial(Sip/${ARG1:1}@phonesystems1,40,Tw) exten => s,203,NoOp(PH2) exten => s,300,GotoIf($[${GROUP_COUNT(ph3)}>=2]?400:301) exten => s,301,Set(GROUP()=ph3) exten => s,302,Dial(Sip/${ARG1:1}@phonesystems2,40,Tw) exten => s,303,NoOp(PH3) exten => s,400,GotoIf($[${GROUP_COUNT(ph4)}>=2]?400:500) exten => s,401,Set(GROUP()=ph4) exten => s,402,Dial(Sip/${ARG1:1}@phonesystems3,40,Tw) exten => s,403,NoOp(PH4) exten => s,500,Playback(all-circuits-busy-now) And my portion of extensions.conf from where we are jumping to that macro exten => _00[123459]XXXXXXXX!,1,Monitor(gsm,${CALLERID(num)}APP-${EXTEN}-${STRFTIME(${EPOCH},,%Y%m%d-%H%M%S)}) exten => _00[123459]XXXXXXXX!,2,GotoIf($[${DB(internet/disponible)}=1]?3:7) exten => _00[123459]XXXXXXXX!,3,GotoIf($[${DB(moyende/telecom)}=0]?4:6) exten => _00[123459]XXXXXXXX!,4,Macro(phonesystems,${EXTEN}) exten => _00[123459]XXXXXXXX!,5,Hangup() ;this hangup is for marcro returning exten => _00[123459]XXXXXXXX!,6,GotoIf($[${DB(moyende/telecom)}=1]?7:8) ;case 8 should never happen, just in case. exten => _00[123459]XXXXXXXX!,7,Dial(mISDN/g:intern-out/${EXTEN:1}) exten => _00[123459]XXXXXXXX!,8,Dial(mISDN/g:intern-out/${EXTEN:1}) Thank you. -------------- next part -------------- An HTML attachment was scrubbed... URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20080829/c1c68671/attachment-0001.htm