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

[Asterisk Bug Tracker]

The following issue has been SUBMITTED. 
====================================================================== 
https://issues.asterisk.org/view.php?id=19040 
====================================================================== 
Reported By:                wcselby
Assigned To:                
====================================================================== 
Project:                    Asterisk
Issue ID:                   19040
Category:                   Addons/cdr_addon_mysql
Reproducibility:            always
Severity:                   minor
Priority:                   normal
Status:                     new
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:              
====================================================================== 
Date Submitted:             2011-03-29 21:12 CDT
Last Modified:              2011-03-29 21:12 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'
====================================================================== 

Issue History 
Date Modified    Username       Field                    Change               
====================================================================== 
2011-03-29 21:12 wcselby        New Issue                                    
2011-03-29 21:12 wcselby        Asterisk Version          => 1.8.4-rc2       
2011-03-29 21:12 wcselby        Regression                => No              
2011-03-29 21:12 wcselby        SVN Branch (only for SVN checkouts, not tarball
releases) => N/A             
======================================================================