[Asterisk-bugs] [Asterisk 0009279]: fields "start", "answer" and "end" are always empty.

[noreply at bugs.digium.com]

email_notification_title_for_action_bugnote_submitted 
====================================================================== 
http://bugs.digium.com/view.php?id=9279 
====================================================================== 
Reported By:                rottenroddy
Assigned To:                junky
====================================================================== 
Project:                    Asterisk
Issue ID:                   9279
Category:                   CDR/cdr_pgsql
Reproducibility:            always
Severity:                   minor
Priority:                   normal
Status:                     feedback
Asterisk Version:           1.4.1 
SVN Branch (only for SVN checkouts, not tarball releases): N/A 
SVN Revision (number only!):  
Disclaimer on File?:        No 
Request Review:              
====================================================================== 
Date Submitted:             03-14-2007 13:35 CDT
Last Modified:              06-29-2007 22:09 CDT
====================================================================== 
Summary:                    fields "start", "answer" and "end" are always empty.
Description: 
CDR format and content are different between given interfaces and
documentation is inconsistent. Default CDR construction in cdr-csv is 18
fields and matches the documentation for the module(see below). For the
remaining non-configurable interfaces, mysql,mssql and pgsql, mssql is the
only documentation matching the standard format while the others do not.
mssql was not tested for functionality. cdr_pgsql.so should match the
output of the single standard cdr format for 1.4x. It does not. Fields
"start", "answer" and "end" are always empty.
====================================================================== 

---------------------------------------------------------------------- 
 juggie - 06-29-07 22:09  
---------------------------------------------------------------------- 
Try the patch i just uploaded, its not really tested only that it compiles.
 See if that provides you with the information you are looking for using
cdr_pgsql.  Please note that calldate is no longer used, its previous
contents go in start (as requested) and answer and end are also populated.

Let me know if this works. 

Issue History 
Date Modified   Username       Field                    Change               
====================================================================== 
03-14-07 13:35  rottenroddy    New Issue                                    
03-14-07 13:35  rottenroddy    Issue Monitored: rottenroddy                    
03-14-07 13:35  rottenroddy    Asterisk Version          => 1.4.1           
03-14-07 13:35  rottenroddy    SVN Branch (only for SVN checkou => N/A          
  
03-14-07 13:35  rottenroddy    Disclaimer on File?       => No              
03-14-07 14:30  junky          Note Added: 0060874                          
03-14-07 14:30  junky          Status                   new => assigned     
03-14-07 14:30  junky          Assigned To               => junky           
03-14-07 15:19  rottenroddy    Note Added: 0060876                          
03-14-07 15:21  junky          Note Added: 0060877                          
03-14-07 15:42  rottenroddy    File Added: modules.conf_cdrtest.txt             
      
03-14-07 15:42  rottenroddy    File Added: extensions.conf_cdrtest.txt          
         
03-14-07 15:43  rottenroddy    File Added: sip.conf_cdrtest.txt                 
  
03-14-07 15:46  rottenroddy    Note Added: 0060879                          
03-14-07 16:00  rottenroddy    Note Added: 0060880                          
06-14-07 08:39  Mithraen       Issue Monitored: Mithraen                    
06-27-07 17:31  file           Status                   assigned => resolved
06-27-07 17:31  file           Resolution               open => no change
required
06-27-07 17:31  file           Note Added: 0065818                          
06-27-07 17:31  file           Status                   resolved => closed  
06-28-07 16:25  rottenroddy    Status                   closed => feedback  
06-28-07 16:25  rottenroddy    Resolution               no change required =>
reopened
06-28-07 16:25  rottenroddy    Note Added: 0065871                          
06-28-07 16:35  file           Note Added: 0065875                          
======================================================================