login | register
Sat 17 of May, 2008 [05:40 UTC]

voip-info.org

Search with Google
Search this site with Google. Results may not include recent changes.
 
Google Ads
Shoutbox
  • Juan Ortega, Thu 15 of May, 2008 [10:33 UTC]: Hi everybody, I'm Juan, an ITCom student, and I need to know what basic elements I need to create a VoIP network. Can anybody helpme, please?,Thank you very much
  • gineta, Wed 14 of May, 2008 [03:58 UTC]: any here not fine the configuration of firewall juniper -screem for VOIP asterisk????
  • Anoop Prabhakaran, Tue 13 of May, 2008 [12:16 UTC]: I am developing Asterisk IVR, Whenever i make a internation call to the IVR system, the DTMF is not getting detected properly, this happens only for the first time, second call onwards system works fine. why this is happening
  • joe, Mon 12 of May, 2008 [04:27 UTC]: Is there an opensource browser based softphone, or a system like Busta where everything is not manages through their website?
  • Nick Barnes, Fri 09 of May, 2008 [11:36 UTC]: Christopher - yesterday I tried an Asterisk install on a CentOS 5.1 box with stock GUI and it all worked fine. Sorry I can't help.
  • aero, Fri 09 of May, 2008 [08:20 UTC]: can someone help me out on this, i tried to play some sound files on my asterisk box and this is the error message i got. WARNING[4429]: format_wav.c:169 check_header: Unexpected freqency 22050 May 8 11:17:39 WARNING[4433]: codec_gsm.c:194 gsmtolin_fra
  • Christopher Faust, Thu 08 of May, 2008 [14:15 UTC]: I beleive that I may have to change something in the xserver configuration. Please advise
  • Christopher Faust, Thu 08 of May, 2008 [14:14 UTC]: Everything was perfect. In the bios I have increased the memory allocated Still receive input not supported on my display.
  • Christopher Faust, Thu 08 of May, 2008 [14:13 UTC]: This would not be my main box. I am doing some testing to see if I can install zaptel and asterisk 1.4 on a full centos 5.1 box with development software Its bizzare, because before I went through the asterisk and zaptel installation everything was perfe
  • Nick Barnes, Thu 08 of May, 2008 [13:44 UTC]: Christopher - I can't see any way in which an Asterisk installation would muck your GUI, but remember that it is advised not to use a GUI on an Asterisk box anyway.
Server Stats
  • Execution time: 0.39s
  • Memory usage: 2.24MB
  • Database queries: 33
  • GZIP: Disabled
  • Server load: 0.44

Asterisk CDR Areski GUI

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:


DOWNLOAD:


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


Image

Image

Image

Image
Created by jht2, Last modification by gregory malsack on Wed 22 of Aug, 2007 [16:46 UTC]

Comments Filter

Re: Watch Call Graph Problem

by Adam Gundy on Monday 23 of July, 2007 [22:05:26 UTC]
you can make the graphs work with PHP5 by downloading the latest version of jpgraph and dropping the source files in the jpgraph_lib directory. alternatively, downgrade to PHP4...


Call Monitor add-on

by splante on Tuesday 06 of March, 2007 [05:26:41 UTC]
Thanks for a great utility. We use it bundled with FreePBX and TrixBox. We needed to be able to listen to the recording of the call, if it was available. We created a patch that allows this, in conjunction with the ARI package by Little John Consulting (also included with TrixBox). If you have a need for this, you can download it from our website. Perhaps it could get added into the main code base at some time.
<p>
<a href="http://insightsys.com/freepbx/">http://insightsys.com/freepbx/</a>

bug in call-log.php

by bartek on Friday 02 of March, 2007 [21:17:49 UTC]
Hi
I find this package a GREAT utility.
small bug: if the name of billing table is different than "cdr" then utility fails, while in one place "cdr" is hardcoded.
To fix it just change the line:

$QUERY = "SELECT substring(calldate,1,10) AS day, sum(duration) AS calltime, count(*) as nbcall FROM cdr WHERE ".$FG_TABLE_CLAUSE." GROUP BY substring(calldate,1,10)";

to

$QUERY = "SELECT substring(calldate,1,10) AS day, sum(duration) AS calltime, count(*) as nbcall FROM $FG_TABLE_NAME WHERE ".$FG_TABLE_CLAUSE." GROUP BY substring(calldate,1,10)";

Watch Call Graph Problem

by Walter Perris on Wednesday 21 of June, 2006 [15:38:09 UTC]
There seems to be a problem with watch call graph with PHP5/Postgres SQL.

WP

Incoming Calls Only?

by bmct on Thursday 04 of May, 2006 [13:26:11 UTC]
Is there a way to get the stat package to show graphs, etc of incoming calls only? I've tried every way, can't seem to figure it out.....

Bug in time counting

by Mindaugas Kezys on Thursday 23 of February, 2006 [07:50:43 UTC]
This great app counts call time in the wrong way. Try to call to this context:

Answer
Wait(10)
Dial(somewhere)

And in Areski CDR you will see call length ~= actual call + 10s

Because this app counts not real call time between call parties, but the time between caller ant the system.

Fix:

In files:

call-comp.php
call-daily-load.php
call-last-month.php
call-log.php

In line:

$FG_COL_QUERY='calldate, channel, src, clid, lastapp, lastdata, dst, dst, disposition, duration, userfield, accountcode';

Change 'duration' to 'billsec'

Mindaugas

Bug in export_pdf.php

by Stegie on Tuesday 04 of October, 2005 [21:33:58 UTC]
Hi all,

There is a little bug in export_pdf.php provide in v2.1 package (I don't know if that bug was in other version)
To fix it, just correct that line in export_pdf.php file :
include_once(dirname(FILE) . "/lib/fpdf.php');

to

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

Hope this help....

Re: Excellent....

by rchinchilla on Tuesday 26 of July, 2005 [04:45:24 UTC]
Were can I get detailed information regarding installation?

Thanks
Edit

Brilliant!

by Anonymous on Monday 03 of January, 2005 [12:37:41 UTC]
Absolutely brilliant. As if Asterisk wasn't good enough already, this app is a must-have - can't believe we ever lived without it.

I'm using it on Debian GNU/Linux 3.1 for i386 w/TDM400 cards at two offices.

Thanks!

Postgresql 7.4.x

by syncros on Saturday 18 of September, 2004 [23:39:23 UTC]
LIMIT #,# syntax is obsolete. (:exclaim:)

edit call-comp.php and call-log.php
replace this line:
$list = $instance_table -> Get_list ($FG_TABLE_CLAUSE, $order, $sens, null, null, $FG_LIMITE_DISPLAY, $current_page*$FG_LIMITE_DISPLAY);
with this line:
$list = $instance_table -> Get_list ($FG_TABLE_CLAUSE, $order, $sens, null, null, $FG_LIMITE_DISPLAY, OFFSET, $current_page*$FG_LIMITE_DISPLAY);

Please update this page with new information, just login and click on the "Edit" or "Add Comment" button above. Get a free login here: Register Thanks! - support@voip-info.org

Page Changes | Comments

Sponsored by:

Terms of Service Privacy Policy
© 2003-2008 VOIP-Info.org LLC

Powered by bitweaver