[asterisk-bugs] [Asterisk 0019040]: clid field empty in mysql table when using cdr_addon_mysql
Asterisk Bug Tracker
noreply at bugs.digium.com
Thu Mar 31 01:44:10 CDT 2011
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
======================================================================
More information about the asterisk-bugs
mailing list