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

noreply at bugs.diguim.com noreply at bugs.diguim.com
Thu Jun 28 16:35:41 CDT 2007


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 
====================================================================== 
Date Submitted:             03-14-2007 13:35 CDT
Last Modified:              06-28-2007 16:35 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.
====================================================================== 

---------------------------------------------------------------------- 
 junky - 03-14-07 14:30  
---------------------------------------------------------------------- 
Do you use any specific CDR stuff (like ForkCDR, etc) ? 

---------------------------------------------------------------------- 
 rottenroddy - 03-14-07 15:19  
---------------------------------------------------------------------- 
I did some error checking with plpgsql and the fields are not sent as part
of the new record. ie. they are not in the SQL formatted by the client. Not
"empty" as I had first assumed. 
Junky - no ForkCDR in dialplan just Set(CDR(accountcode)=123456),
Set(CDR(amaflags)="BILLING") and Set(CDR(userfield)=16048720002)

cdr_manager.conf; enable=yes 

---------------------------------------------------------------------- 
 junky - 03-14-07 15:21  
---------------------------------------------------------------------- 
I will take a look at this, but if you could attach a quick dialplan
invoking this, that will be useful.
Also, do you use cdr batch mode? 

---------------------------------------------------------------------- 
 rottenroddy - 03-14-07 15:46  
---------------------------------------------------------------------- 
CLI 
CDR logging: enabled
CDR mode: simple
CDR registered backend: pgsql

for this run I had not loaded cdr_manager but it made no difference.

Thanks and have fun 

---------------------------------------------------------------------- 
 rottenroddy - 03-14-07 16:00  
---------------------------------------------------------------------- 
Just a short update: 

I had the field names wrong -"startdate", "answerdate" and "enddate" and
they are in the SQL insert but they are NULL as first reported. 

---------------------------------------------------------------------- 
 file - 06-27-07 17:31  
---------------------------------------------------------------------- 
I'm closing this out, the schema for pgsql does not show those fields being
part of it. 

---------------------------------------------------------------------- 
 rottenroddy - 06-28-07 16:25  
---------------------------------------------------------------------- 
Interesting rational; Are you saying that you are deciding not to support
the pgsql interface for the 1.4x product, or are you saying that the 1.4x
product does not have a standard interface across databases? Either way the
results diminish the Asterisk product. By not carrying these fields forward
you are cutting off all  integration with realtime billing systems
utilizing pgsq. Oh, and by the by, why,  if the schema does not contain the
fields, are they in the insert statement? I find your decision shortsighted
and inconsistent. 

---------------------------------------------------------------------- 
 file - 06-28-07 16:35  
---------------------------------------------------------------------- 
It was up to the developer, Matthew D. Hardeman, in this case to determine
what they wanted to write the module to insert. The module also does not
have it as part of the INSERT. It has the calldate, clid, src, dst,
dcontext, channel, dstchannel, lastapp, lastdata, duration, billsec,
disposition, amaflags, accountcode, uniqueid, and userfield. 

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                          
======================================================================




More information about the Asterisk-bugs mailing list