CDR Analyser

Asterisk-Stat : CDR Analyser is a PHP WEB application allowing you to view CDR details and do custom searches.

Let's start by installing all the prerequiste programs and tools.

Add indexing to some fields for the Asterisk Databse.
Replace asterisk-cdr with your databse name and replace cdr with your table name.

mysql
use asteirsk
ALTER TABLE `cdr` ADD INDEX ( `calldate` );
ALTER TABLE `cdr` ADD INDEX ( `dst` );
ALTER TABLE `cdr` ADD INDEX ( `accountcode` );
exit

Install WEB services and PHP.

yum install httpd
service httpd start
chkconfig httpd on
yum install php php-gd php-mysql

Download and extract Asterisk-Stat

cd /var/www/html
wget http://www.areski.net/asterisk-stat-v2/asterisk-stat-v2_0_1.tar.gz
tar xvzf asterisk-stat-v2_0_1.tar.gz
mv asterisk-stat-v2/ cdr/

Edit the configuration file.

vi /var/www/html/cdr/lib/defines.php

Change the first to define statements to suite

define ("WEBROOT", "http://asterisk.klaverstyn.com/stat/");
define ("FSROOT", "/var/www/html/cdr/");

Change the databse connection details

define ("HOST", "localhost");
define ("PORT", "5432");
define ("USER", "username");
define ("PASS", "password");
define ("DBNAME", "asteirsk");
define ("DB_TYPE", "mysql"); // mysql or postgres

Change the table name if required

define ("DB_TABLENAME", "cdr");