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

[Asterisk Bug Tracker]

The following issue has been RESOLVED. 
====================================================================== 
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:                     resolved
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:43 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'
====================================================================== 

---------------------------------------------------------------------- 
 (0133190) svnbot (reporter) - 2011-03-31 01:43
 https://issues.asterisk.org/view.php?id=19040#c133190 
---------------------------------------------------------------------- 
Repository: asterisk
Revision: 311930

U   branches/1.8/configs/cdr_mysql.conf.sample

------------------------------------------------------------------------
r311930 | tilghman | 2011-03-31 01:43:19 -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=311930 

Issue History 
Date Modified    Username       Field                    Change               
====================================================================== 
2011-03-31 01:43 svnbot         Checkin                                      
2011-03-31 01:43 svnbot         Note Added: 0133190                          
2011-03-31 01:43 svnbot         Status                   new => assigned     
2011-03-31 01:43 svnbot         Assigned To               => tilghman        
2011-03-31 01:43 svnbot         Status                   assigned => resolved
2011-03-31 01:43 svnbot         Resolution               open => fixed       
======================================================================