CDR Analyser

Asterisk-Stat

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.

Create SQL Indexes

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

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

Install httpd and php requirements

Install WEB services and PHP.

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

Download Asterisk-Stat

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 config file

Edit the configuration file.

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

WEB Location

Change the define statements to suite

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

Databse Details

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

Table Details

Change the table name if required

define ("DB_TABLENAME", "cdr");

Bugs

Table not CDR

If your table is called cdr then you do not have a problem. If you have created a table called something different then you need to edit call-log.php on line 232 column 103 and change cdr to the name of your table.

Output to PDF

To be able to export to PDF you need to edit the file /var/www/html/cdr/export_pdf.php
Change the Line 5 from:

include_once(dirname(FILE) . "/lib/fpdf.php');

to:

include_once(dirname(FILE) . "/lib/fpdf.php");