bahjons.com

Okay, so you have got your asterisk box online. You have all the configuration done according to your needs. And now you are starting to develop applications to generate graphs and reports based on your call volume and flow. You’ll probably want to have your CDR logs entered into a database for easier management.

You will first need to install Asterisk-Addons. If you already have this installed, great. But we’ll probably need to make a quick change in order to have the uniqueid logged within the CDR. So you will edit the ‘cdr_addon_mysql.c’ and compile/recompile Asterisk-Addons. If you followed my quick installation guide, you will do the following:

nano /usr/src/asterisk-addons/cdr/cdr_addon_mysql.c

Add the following line to the top:

#define MYSQL_LOGUNIQUEID

Recompile Asterisk-Addons:

cd /usr/src/asterisk-addons/
make clean
make
make install 

Now, we’ll copy our configuration file over to the Asterisk directory:

cp /usr/src/asterisk-addons/configs/cdr_mysql.conf.sample /etc/asterisk/cdr_mysql.conf

Once this is complete, we’ll edit to to match the database settings for our asterisk database:

[global]
hostname=localhost
dbname=asterisk
password=yourpassword
user=asterisk
loguniqueid=yes

And now we setup our tables within the database…

CREATE TABLE `cdr` (
`calldate` datetime NOT NULL default '0000-00-00 00:00:00',
`clid` varchar(80) NOT NULL default '',
`src` varchar(80) NOT NULL default '',
`dst` varchar(80) NOT NULL default '',
`dcontext` varchar(80) NOT NULL default '',
`channel` varchar(80) NOT NULL default '',
`dstchannel` varchar(80) NOT NULL default '',
`lastapp` varchar(80) NOT NULL default '',
`lastdata` varchar(80) NOT NULL default '',
`duration` int(11) NOT NULL default '0',
`billsec` int(11) NOT NULL default '0',
`disposition` varchar(45) NOT NULL default '',
`amaflags` int(11) NOT NULL default '0',
`accountcode` varchar(20) NOT NULL default '',
`userfield` varchar(255) NOT NULL default '',
`uniqueid` varchar(100) NOT NULL default ''
);

ALTER TABLE `cdr` ADD INDEX ( `calldate` );
ALTER TABLE `cdr` ADD INDEX ( `dst` );
ALTER TABLE `cdr` ADD INDEX ( `accountcode` );

Now just reload Asterisk from the Asterisk Cli:

reload

You’re done! Now you can write applications to query the database for the data you need. I’ll include some examples of this shortly.

UPDATE 12/10/08: Not sure which version brought this change… but if you want unanswered calls to be logged in the CDR database, you need to add the following to the cdr.conf:

unanswered = yes