[asterisk-bugs] [Asterisk 0018407]: [patch] 'usegmtime=yes' is ignored and CDR(end) is not inserted

[Asterisk Bug Tracker]

A NOTE has been added to this issue. 
====================================================================== 
https://issues.asterisk.org/view.php?id=18407 
====================================================================== 
Reported By:                joscas
Assigned To:                
====================================================================== 
Project:                    Asterisk
Issue ID:                   18407
Category:                   CDR/cdr_pgsql
Reproducibility:            always
Severity:                   trivial
Priority:                   normal
Status:                     feedback
Asterisk Version:           1.8.0 
JIRA:                       SWP-2678 
Regression:                 No 
Reviewboard Link:            
SVN Branch (only for SVN checkouts, not tarball releases): N/A 
SVN Revision (number only!):  
Request Review:              
====================================================================== 
Date Submitted:             2010-12-01 06:44 CST
Last Modified:              2010-12-21 04:21 CST
====================================================================== 
Summary:                    [patch] 'usegmtime=yes' is ignored and CDR(end) is
not inserted
Description: 
CDRs get inserted on the server local time and it doesn't insert the
CDR(end).
====================================================================== 

---------------------------------------------------------------------- 
 (0129829) joscas (reporter) - 2010-12-21 04:21
 https://issues.asterisk.org/view.php?id=18407#c129829 
---------------------------------------------------------------------- 
As I see it, the situation is as follows:

- The pgsql driver doesn't pay attention neither to a [pgsql] section of
cdr.conf nor to a [columns] section of cdr_pgsql.conf

- 'start' is a reserved sql word and the pgsql driver is inserting the
CDR(start) field as "calldate" and this is hardcoded in the driver since no
alias for this word can be indicated.

- 'end' is a reserved sql word and the pgsql driver is not inserting the
CDR(end) field since no hardcoding for an alternative word is available and
no attention is paid to any alias indicated by the user.

In my opinion, the patch provided by snuffy is good because it at least
allows for the insertion of an end of call to the CDR in the same way it is
done currently with the start of the call. Otherwise, no end of call
indication can be inserted.

A better alternative would be to raise the overall quality of this driver
so that it matches the set of features provided by alternative drivers
allowing a [columns] section and some control from cdr.conf but perhaps
this should be a feature request. 

Issue History 
Date Modified    Username       Field                    Change               
====================================================================== 
2010-12-21 04:21 joscas         Note Added: 0129829                          
======================================================================