[asterisk-bugs] [Asterisk 0019040]: clid field empty in mysql table when using cdr_addon_mysql

[Asterisk Bug Tracker]

A NOTE has been added to this issue. 
====================================================================== 
https://issues.asterisk.org/view.php?id=19040 
====================================================================== 
Reported By:                wcselby
Assigned To:                tilghman
====================================================================== 
Project:                    Asterisk
Issue ID:                   19040
Category:                   Addons/cdr_addon_mysql
Reproducibility:            always
Severity:                   minor
Priority:                   normal
Status:                     closed
Asterisk Version:           1.8.4-rc2 
JIRA:                        
Regression:                 No 
Reviewboard Link:            
SVN Branch (only for SVN checkouts, not tarball releases): N/A 
SVN Revision (number only!):  
Request Review:              
Resolution:                 fixed
Fixed in Version:           
====================================================================== 
Date Submitted:             2011-03-29 21:12 CDT
Last Modified:              2011-03-31 01:44 CDT
====================================================================== 
Summary:                    clid field empty in mysql table when using
cdr_addon_mysql
Description: 
As reported by Eric Davenport on the asterisk mailing list and confirmed
tonight by myself:

The clid field is not being populated with any data for calls when using
mysql call detail records.  The same calls generate the clid field in the
Master.csv file.  Reproduced this tonight on fresh installs of asterisk
1.8.3.2 and asterisk 1.8.4-rc2 on a fresh install of ubuntu server 10.04,
installing everything from source.

Record from mysql table:
mysql> select * from asterisk.cdr;
+-------+---------------------+------+-------+-----+----------+--------------------+--------------------+---------+--------------+----------+---------+-------------+----------+-------------+--------------+-----------+
| recid | calldate            | clid | src   | dst | dcontext | channel   
        | dstchannel         | lastapp | lastdata     | duration | billsec
| disposition | amaflags | accountcode | uniqueid     | userfield |
+-------+---------------------+------+-------+-----+----------+--------------------+--------------------+---------+--------------+----------+---------+-------------+----------+-------------+--------------+-----------+
|     1 | 2011-03-29 20:25:45 |      | xlite | 100 | default  |
SIP/xlite-00000000 | SIP/isip-00000001  | Dial    | SIP/isip,60  |       15
|       9 | ANSWERED    |        3 |             | 1301448345.0 |          
|
|     2 | 2011-03-29 20:26:06 |      | isip  | 101 | default  |
SIP/isip-00000002  | SIP/xlite-00000003 | Dial    | SIP/xlite,60 |       33
|      21 | ANSWERED    |        3 |             | 1301448366.2 |          
|
+-------+---------------------+------+-------+-----+----------+--------------------+--------------------+---------+--------------+----------+---------+-------------+----------+-------------+--------------+-----------+
2 rows in set (0.00 sec)

Record from /var/log/asterisk/cdr-csv/Master.csv:
warren at astcdr:~$ cat /var/log/asterisk/cdr-csv/Master.csv
"","xlite","100","default","""xlite""
<xlite>","SIP/xlite-00000000","SIP/isip-00000001","Dial","SIP/isip,60","2011-03-30
01:25:45","2011-03-30 01:25:51","2011-03-30
01:26:00",15,9,"ANSWERED","DOCUMENTATION","1301448345.0",""
"","isip","101","default","""isip""
<isip>","SIP/isip-00000002","SIP/xlite-00000003","Dial","SIP/xlite,60","2011-03-30
01:26:06","2011-03-30 01:26:18","2011-03-30
01:26:39",33,21,"ANSWERED","DOCUMENTATION","1301448366.2",""


Relevant CLI (from a later call, when I remembered to set verbose and
debug to 10):
*CLI> core set verbose 10
Verbosity was 5 and is now 10
*CLI> core set debug 10
Core debug was 0 and is now 10
  == Using SIP RTP CoS mark 5
    -- Executing [101 at default:1] Verbose("SIP/isip-00000000", "Calling
xlite client") in new stack
Calling xlite client
    -- Executing [101 at default:2] Dial("SIP/isip-00000000", "SIP/xlite,60")
in new stack
  == Using SIP RTP CoS mark 5
    -- Called xlite
    -- SIP/xlite-00000001 is ringing
    -- SIP/xlite-00000001 answered SIP/isip-00000000
    -- Remotely bridging SIP/isip-00000000 and SIP/xlite-00000001
  == Spawn extension (default, 101, 2) exited non-zero on
'SIP/isip-00000000'
====================================================================== 

---------------------------------------------------------------------- 
 (0133191) svnbot (reporter) - 2011-03-31 01:44
 https://issues.asterisk.org/view.php?id=19040#c133191 
---------------------------------------------------------------------- 
Repository: asterisk
Revision: 311931

_U  trunk/
U   trunk/configs/cdr_mysql.conf.sample

------------------------------------------------------------------------
r311931 | tilghman | 2011-03-31 01:44:10 -0500 (Thu, 31 Mar 2011) | 13
lines

Merged revisions 311930 via svnmerge from 
https://origsvn.digium.com/svn/asterisk/branches/1.8

........
  r311930 | tilghman | 2011-03-31 01:43:18 -0500 (Thu, 31 Mar 2011) | 6
lines
  
  Incorrect default example; the field is actually internally named
"clid", not "callerid".
  
  (closes issue https://issues.asterisk.org/view.php?id=19040)
  Reported by: wcselby
  Tested by: tilghman
........

------------------------------------------------------------------------

http://svn.digium.com/view/asterisk?view=rev&revision=311931 

Issue History 
Date Modified    Username       Field                    Change               
====================================================================== 
2011-03-31 01:44 svnbot         Checkin                                      
2011-03-31 01:44 svnbot         Note Added: 0133191                          
======================================================================