[asterisk-bugs] [Asterisk 0018560]: CEL logging to ODBC field not being stored.

[Asterisk Bug Tracker]

A NOTE has been added to this issue. 
====================================================================== 
https://issues.asterisk.org/view.php?id=18560 
====================================================================== 
Reported By:                zktech
Assigned To:                murf
====================================================================== 
Project:                    Asterisk
Issue ID:                   18560
Category:                   CEL/General
Reproducibility:            always
Severity:                   minor
Priority:                   normal
Status:                     assigned
Asterisk Version:           SVN 
JIRA:                        
Regression:                 No 
Reviewboard Link:            
SVN Branch (only for SVN checkouts, not tarball releases): 1.8 
SVN Revision (number only!): 297535 
Request Review:              
====================================================================== 
Date Submitted:             2010-12-30 10:35 CST
Last Modified:              2010-12-30 14:59 CST
====================================================================== 
Summary:                    CEL logging to ODBC field not being stored.
Description: 
CEL fields not being updated in ODBC storage.

eventextra field not being stored.
peer field not being stored.

Documentation is incorrect.
https://wiki.asterisk.org/wiki/display/AST/CEL+Events+and+Fields
cel_odbc.conf

Neither have the eventextra field listed but the cel_custom.conf has it
listed.
The wiki does not have the userdeftype field listed. 
====================================================================== 

---------------------------------------------------------------------- 
 (0130058) murf (manager) - 2010-12-30 14:59
 https://issues.asterisk.org/view.php?id=18560#c130058 
---------------------------------------------------------------------- 
OK, an inspection of the code says that one problem is because of 
"misdocumentation" (probably because of ME). The name of the var in the 
CEL world is not "peer", but rather "BRIDGEPEER". I will update the config
files
to correct this; I apologize. If I change it back to "peer", then everyone
with working s/w will be hurt. The fix involves editing
cel_custom.conf.sample by trading ${CHANNEL(peer)} for ${BRIGEPEER}. In
configs/cel_sqliste3_custom.conf.sample, the same replacement, but the
columns spec can retain the "peer" name. In the case of the cel_odbc config
file, I replaced the comment about "peer" with "BRIDGEPEER" instead, and
added eventextra to the list of fields. I would think you could call the
column "peer" by using some mapping in the cel_odbc config file, right?

Similar changes in the cel_pgsql.conf.sample file.



Next, the "eventextra". This field was not being copied into the field via
the code in cel_odbc.c; I will endeavor to add the missing two lines of
code.

Can you update the wiki entry when this bug is closed? 

Issue History 
Date Modified    Username       Field                    Change               
====================================================================== 
2010-12-30 14:59 murf           Note Added: 0130058                          
======================================================================