Installing a web-based Asterisk CDR analyzer

[global]
hostname=localhost
dbname=asteriskcdrdb
table=cdr
password=password
user=asterisk
port=3306

Then edit your /etc/asterisk/modules.conf and add the cdr_addon_mysql.so under the [global] section.

[global]
load => cdr_addon_mysql.so

Login to your MySQL server and create a root password to secure your server then create a database to store your CDR records.

Create Asterisk CDR databases and user to the databases.

Create a table called cdr under the database name you will be using the following schema.

Restart your Asterisk PBX, start making a call and check if the CDR is written in your database.

You can also check in Asterisk console by typing this Asterisk command:

It will display the message that look exactly like this:

If you see the message similar from above, you have successfully installed asterisk-addon.

Go to /var/www/html/ directory and grab asterisk-stats package from http://areski.net.

Rename asterisk-stat-v2_0_1 to asterisk-stats and edit the defines.php in /lib directory.

define ("WEBROOT", "http://hostname/asterisk-stats/");
define ("FSROOT", "/var/www/html/asterisk-stats/");



define ("LIBDIR", FSROOT."lib/");


define ("HOST", "localhost");
define ("PORT", "3306");
define ("USER", "asterisk");
define ("PASS", "password");
define ("DBNAME", "asteriskcdrdb");
define ("DB_TYPE", "mysql");


define ("DB_TABLENAME", "cdr");

Create a symlink from cdr.php to index.php

And the URL would be:
http://hostname/asterisk-stats

The asterisk-stats v2.0.1 has a bug when you are exporting CDR in pdf format.
To fix the bug, you need to change line 5 of export_pdf.php from:

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

to:

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

It should be fine now, you can export your CDR to PDF files.

Your Asterisk-stat is done, however it is not yet secured, everybody can login without any authentication. If you want to put an authentication to your Asterisk-stat, just follow this howto. It will require web site visitors to login with a user id and password.

You can delete the CDR in your MySQL database using phpMyAdmin.