[asterisk-users] Asterisk cdr_mysql inexact values

Grygoriy Dobrovolskyy megahohol at gmail.com
Fri Aug 29 04:35:20 CDT 2008


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 


More information about the asterisk-users mailing list