[Asterisk-Users] missing cdr records

[Paul Traue, Jr.]

Rosario,

Unfortunately this problem doesn't just affect you, I'm also affected 
and have been since 1.0.5.  If you set the debugging high enough and use 
mysql, you'll see the insert statements being generated by asterisk, but 
they never make it to the DB.

I'm glad to know I'm not the only one affected.  Any others experiencing 
this problem or have a fix?

Paul

Rosario Pingaro wrote:
> I am experiencing a very wired problem.
>  
> Some of my cdr are lost.
>  
> I use logging cdr to csv, mysql and odbc. But some of them are lost. 
> They miss in csv mysql and odbc, so i'm pretty sure it is related to 
> asterisk functioning.
>  
> I am running asterisk 1.0.7; this is simple configuration file:
>  
> extensions.conf
> [general]
> static=yes
> writeprotect=no
>  
> [macro-gw-voipjet]
> exten => s,1,SetCallerID(${CALLERIDNAME})
> exten => s,2,Dial,IAX2/XXXX at voipjet/${ARG1}
> exten => s,3,Goto(s-${DIALSTATUS},1)
> exten => s-BUSY,1,Busy
> exten => s-CHANUNAVAIL,1,Noop
> exten => _s-.,1,Congestion
> [macro-gw-nufone]
> exten => s,1,SetCallerID(${CALLERIDNAME})
> exten => s,2,Dial,IAX2/rpingar at NuFone/${ARG1}
> exten => s,3,Goto(s-${DIALSTATUS},1)
> exten => s-BUSY,1,Busy
> exten => s-CHANUNAVAIL,1,Noop
> exten => _s-.,1,Congestion
> [ser]
> ; combinazione 81 - per provider americani - destinaione usa e canada
> exten => _81.,1,Macro(gw-nufone,${EXTEN:1})  ; NuFone
> exten => _81.,2,Macro(gw-voipjet,${EXTEN:1}) ; VoipJet.com
> exten => _81.,3,Congestion
>  
> ; combinazione 8011 - per provider americani - destinaione 
> rotteinternazionali
> exten => _8011.,1,Macro(gw-voipjet,${EXTEN:1}) ; VoipJet.com
> exten => _8011.,2,Macro(gw-nufone,${EXTEN:1})  ; NuFone
> exten => _8011.,3,Congestion
>  
>  
> the percentage of cdr lost is around 5% and they are pretty concentrate 
> in the meaning that if I loose 5 cdrs they are lost 3 in around 2 
> minutes interval and 2 in anothe short interval.
>  
> Any advice on how to debug ?
>  
> thanks
> Rosario
>  
> 
> 
> ------------------------------------------------------------------------
> 
> _______________________________________________
> Asterisk-Users mailing list
> Asterisk-Users at lists.digium.com
> http://lists.digium.com/mailman/listinfo/asterisk-users
> To UNSUBSCRIBE or update options visit:
>    http://lists.digium.com/mailman/listinfo/asterisk-users