CDR-Stats!

CDR-Stats has been renamed from Asterisk-Stat to reflect the fact that it can be developed to be telephony engine agnostic, and development is currently underway to support Freeswitch. Other telephony engines may be added as demand dictates.
CDR-Stats is built using the open source Django python based framework which enables the building of clean, maintainable web applications, and encourages rapid development with a clean and pragmatic design, which in turn, we hope will encourage community support and development of CDR-Stats.

More information, documentation and installation guides for CDR-Stats can be found at http://www.cdr-stats.org and commercial support and installation services are available from Star2Billing S.L. (http://www.star2billing.com/)

Asterisk-stat - This is an old application, please use the new CDR-Stats!

Pretty CDR Analyser, easy way to analyze your CDR records!

Asterisk-Stat is providing different reports & Graph to allow
the Asterisk-admin to analyse quickly and easily the traffic on their Asterisk server.
All the graphic & reports are based over the CDR database.


LAST RELEASE:

• V2.0 (03 March 2005)

FEATURES:

• - CDR REPORT (MONTHLY or DAILY)
• - MONTHLY TRAFFIC
• - DAILY LOAD
• - COMPARE CALL LOAD WITH PREVIOUS DAYS
• - MANY CRITERIAS TO DEFINE THE REPORT
• - EXPORT CDR REPORT TO PDF
• - EXPORT CDR REPORT TO CSV
• - SUPPORT MYSQL & POSTGRESQL
• - MANY OTHERS :)

REQUIREMENTS:

• - APACHE / HTTP SERVER
• - PHP
• - POSTGRESQL OR MYSQL
• - PHP-PGSQL OR PHP-MYSQL
• - NEED GD LIBRARY
• - JPGRAPH_LIB (included)

ADVICES:

• - IMPROVE SPEED RESULT WITH INDEX:

POSTGRESQL: CREATE INDEX calldate_ind ON cdr USING btree (calldate)
MYSQL: ALTER TABLE `cdr` ADD INDEX ( `calldate` )

• - OPTIONAL:

POSTGRESQL: CREATE INDEX dst_ind ON cdr USING btree (dst)
POSTGRESQL: CREATE INDEX accountcode_ind ON cdr USING btree (accountcode)
MYSQL: ALTER TABLE `cdr` ADD INDEX ( `dst` )
MYSQL: ALTER TABLE `cdr` ADD INDEX ( `accountcode` )


MORE INFO:

• http://areski.net/asterisk-stat-v2/about.php

DOWNLOAD:

• http://areski.net/asterisk-stat-v2/asterisk-stat-v2_0_1.tar.gz

INSTALL:

Edit defines.php files

• WEBROOT: This is the root URL of the application.

Example: http://youdomain.com/asterisk-stat/

• FSROOT: This is the server path which contain the application.

Example: /home/users/asterisk-stat/

• HOST: This is the Database host name.

Example: localhost

• PORT: Database port.

Example: 5432

• USER: Username to access to the database.

Example: username

• PASS: Database password of the user.

Example: password

• DBNAME: Name of the Database.

Example: asteriskcdr

• DB_TYPE: Database type.

support: mysql and postgres

• DB_TABLENAME: Table of the database containing the CDR.

Example: cdrtable

• appli_list: PHP array used to associate extension to a name. This can be useful if you want to give more signification during the CDR browsing

$appli_list['4677']=array("Voicemail");
$appli_list['6544']=array("Conference-MeetMe");

Finally:

Go to http://yourdomain.com/asterisk-stat/cdr.php

or you can do a symlink from cdr.php to index.php (ln -sf cdr.php index.php) and the URL would be:

http://yourdomain.com/asterisk-stat/

Tested with:
PHP Version 4.3.1
- psql (PostgreSQL) 7.2.4
- mysql Ver 11.18 Distrib 3.23.58,

Install on Fedora
To install depedencies under Fedora Core 4 use :
yum install php-gd
yum install php-mysql
yum install jpgraph (gmalsack could not find this in the default fedora yum repo. I downloaded it from DAG Wieers)

Contact : areski ($alt) gmail ($d.ot) com

Tiny bug in export_pdf.php

If you are having problems exporting to PDF, 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");

Tiny bug in call-log.php
If you are using MySQL with a different DB_TABLENAME other than the standard "cdr", On line 232 of call-log.php you will find the FROM table hard encoded to "cdr" in the sql query. either change it or define the variable.

See also

• Asterisk billing

---

• Asterisk | Tips & Tricks | FAQ