[Freeswitch-users] mod_cdr_csv missing timestamps in A-LEG

[Michael Jerris]

Can you get these same values in xml-cdr?  I don't think csv was ever  
intended to work with different cdrs for a and b leg, it was more  
intended as a more familiar interface for those coming over from  
asterisk.

Mike

On Sep 24, 2009, at 6:10 AM, Tihomir Culjaga wrote:

> hello,
>
> i'm on latest trunk and for some reason i cannot get timestamps  
> dumped in my cdrs. I use mod_cdr_csv with default settings plus i  
> enabled to get both a and b legs dumped.
>
>
> cdr_csv.conf.xml:
>
> <configuration name="cdr_csv.conf" description="CDR CSV Format">
>   <settings>
>     <!-- 'cdr-csv' will always be appended to log-base -->
>     <!--<param name="log-base" value="/var/log"/>-->
>     <param name="default-template" value="example"/>
>     <!-- This is like the info app but after the call is hung up -->
>     <!--<param name="debug" value="true"/>-->
>     <param name="rotate-on-hup" value="true"/>
>     <!-- may be a b or ab -->
>     <param name="legs" value="ab"/>
>   </settings>
>   <templates>
>     <template name="sql">INSERT INTO cdr VALUES ("$ 
> {caller_id_name}","${caller_id_number}","${destination_number}","$ 
> {context}","${s
> tart_stamp}","${answer_stamp}","${end_stamp}","${duration}","$ 
> {billsec}","${hangup_cause}","${uuid}","${bleg_uuid}", "${accountcode}
> ");</template>
>     <template name="example">"${caller_id_name}","$ 
> {caller_id_number}","${destination_number}","${context}","$ 
> {start_stamp}","${answ
> er_stamp}","${end_stamp}","${duration}","${billsec}","$ 
> {hangup_cause}","${uuid}","${bleg_uuid}","${accountcode}","$ 
> {read_codec}","${
> write_codec}"</template>
>     <template name="snom">"${caller_id_name}","$ 
> {caller_id_number}","${destination_number}","${context}","$ 
> {start_stamp}","${answer_
> stamp}","${end_stamp}","${duration}","${billsec}","$ 
> {hangup_cause}","${uuid}","${bleg_uuid}", "${accountcode}","$ 
> {read_codec}","${wr
> ite_codec}","${sip_user_agent}","${call_clientcode}","$ 
> {sip_rtp_rxstat}","${sip_rtp_txstat}","${sofia_record_file}"</ 
> template>
>     <template name="linksys">"${caller_id_name}","$ 
> {caller_id_number}","${destination_number}","${context}","$ 
> {start_stamp}","${answ
> er_stamp}","${end_stamp}","${duration}","${billsec}","$ 
> {hangup_cause}","${uuid}","${bleg_uuid}","${accountcode}","$ 
> {read_codec}","${
> write_codec}","${sip_user_agent}","${sip_p_rtp_stat}"</template>
>     <template name="asterisk">"${accountcode}","$ 
> {caller_id_number}","${destination_number}","${context}","$ 
> {caller_id}","${channel_
> name}","${bridge_channel}","${last_app}","${last_arg}","$ 
> {start_stamp}","${answer_stamp}","${end_stamp}","${duration}","$ 
> {billsec}",
> "${hangup_cause}","${amaflags}","${uuid}","${userfield}"</template>
>   </templates>
> </configuration>
>
>
>
>
>
> call flow is the following:
>
>
> CALLER => FS =>  CALLED
>
>
> FS answers the call from CALLER, plays an announcement and bridges  
> towards CALLED.
>
>
> I get different behavior when the call is released by Caller and by  
> Called.
>
>
> Released by Caller:   the CDR is ok having all timestamps
>
> OK CDR:
>
> Outbound LEG =>  
> "016659280","016659280","0914392122","public","2009-09-24  
> 12:02:48","2009-09-24 12:02:54","2009-09-24  
> 12:03:01","13","7","NORMAL_CLEARING","699cc2d0-a8f1-11de-962a- 
> e328afdb9d8d","","","PCMA","PCMA"
> Inbound LEG  =>  
> "016659280","016659280","05000403","public","2009-09-24  
> 12:02:27","2009-09-24 12:02:41","2009-09-24  
> 12:03:01","34","20","NORMAL_CLEARING","5d530192-a8f1-11de-962a- 
> e328afdb9d8d","699cc2d0-a8f1-11de-962a-e328afdb9d8d","","PCMA","PCMA"
>
>
> Released by Called:  the CDR is NOT OK as timestamps are missing
>
>
> NOT OK CDR:
>
> Inbound LEG =>  
> "016659280","016659280","0914392122","public","2009-09-24  
> 12:05:20","2009-09-24 12:05:30","2009-09-24  
> 12:05:39","19","9","NORMAL_CLEARING","c479411a-a8f1-11de-962a- 
> e328afdb9d8d","","","PCMA","PCMA"
> Outbound LEG  
> = 
> > 
> "016659280 
> ","016659280 
> ","015000403","public","","","","0","0","NORMAL_CLEARING","b82f2046- 
> a8f1-11de-962a-e328afdb9d8d","c479411a-a8f1-11de-962a- 
> e328afdb9d8d","","PCMA","PCMA"
>
>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20090925/cf7ad034/attachment-0002.html