[asterisk-bugs] [JIRA] (ASTERISK-15049) Callerid is not recorded in database

[Matt Jordan (JIRA)]

    [ https://issues.asterisk.org/jira/browse/ASTERISK-15049?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=201563#comment-201563 ] 

Matt Jordan commented on ASTERISK-15049:
----------------------------------------

Confirmed that in 1.8 at least, {{alias callerid => clid}} is no longer in cdr_mysql.conf.sample.
                
> Callerid is not recorded in database
> ------------------------------------
>
>                 Key: ASTERISK-15049
>                 URL: https://issues.asterisk.org/jira/browse/ASTERISK-15049
>             Project: Asterisk
>          Issue Type: Bug
>          Components: Addons/cdr_mysql
>            Reporter: cursor
>            Severity: Minor
>
> The callerid is not recorded into the CDR database using Asterisk Addons 1.6.2.0-rc1.  All other fields work as expected.
> ****** ADDITIONAL INFORMATION ******
> CREATE TABLE `cdr` (
>   `id` bigint(20) unsigned NOT NULL auto_increment,
>   `calldate` datetime NOT NULL default '0000-00-00 00:00:00',
>   `start` datetime NOT NULL default '0000-00-00 00:00:00',
>   `answer` datetime NOT NULL default '0000-00-00 00:00:00',
>   `end` datetime NOT NULL default '0000-00-00 00:00:00',
>   `clid` varchar(80) collate utf8_unicode_ci NOT NULL,
>   `callerid` varchar(80) collate utf8_unicode_ci NOT NULL,
>   `src` varchar(80) character set latin1 NOT NULL default '',
>   `dst` varchar(80) character set latin1 NOT NULL default '',
>   `dcontext` varchar(80) character set latin1 NOT NULL default '',
>   `channel` varchar(80) character set latin1 NOT NULL default '',
>   `dstchannel` varchar(80) character set latin1 NOT NULL default '',
>   `lastapp` varchar(80) character set latin1 NOT NULL default '',
>   `lastdata` varchar(80) character set latin1 NOT NULL default '',
>   `duration` int(11) NOT NULL default '0',
>   `billsec` int(11) NOT NULL default '0',
>   `disposition` varchar(45) character set latin1 NOT NULL default '',
>   `amaflags` int(11) NOT NULL default '0',
>   `accountcode` varchar(20) collate utf8_unicode_ci NOT NULL,
>   `uniqueid` varchar(149) collate utf8_unicode_ci NOT NULL,
>   `userfield` varchar(255) collate utf8_unicode_ci NOT NULL,
>   `cost` decimal(10,4) default '0.0000',
>   `vendor` varchar(20) collate utf8_unicode_ci NOT NULL default 'none',
>   `route` varchar(80) collate utf8_unicode_ci default NULL,
>   `routecost` decimal(10,4) default NULL,
>   PRIMARY KEY  (`id`),
>   KEY `src` (`src`),
>   KEY `start` (`start`)
> ) ENGINE=MyISAM AUTO_INCREMENT=39114 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira