Asterisk-stat!

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");

See also

• Asterisk billing

---

• Asterisk | Tips & Tricks | FAQ