[asterisk-users] Reporting for Asterisk Call Center

[Tarek Sawah]

actually Bilal, 
the Asteirsk CDR reports are placed on a different Database than the configurations .. you will need to install asterisk-addons which includes a module for cdr reporting to MYSQL DB. so you don't have to do the configs from the DB at all 
second.. in regards to the Flash Operator Panel you can have a look at a demo here: 
http://www.asternic.org/demo.php
its a nice web interface gives you a live look at your call center .. who is active who is idle .. how many in Queue .. who is online and who is offline.. what trunks are busy ... etc

third: theoretically you can set all Asterisk boxes to load from one database server (never done it myself).. actually it's one of the methods used for redundancy (somebody correct me if i'm wrong?). my only concern is with DB Management systems there is what we call it "LOCK" where a process locks the whole db or a part or it in order to do it's manipulation.. so i'm not sure if the database will be "locked" by one of the asterisk boxes when writing to it? which prevents the rest from writing to it at the same time?
regards



Tarek Sawah

Information Technology  Adviser

Integrated Digital Systems

CCNP, MCSE, RHCE, TELECOM

USA: +1 386 492 9993



> Date: Tue, 13 Sep 2011 02:43:05 -0700
> From: bilmar_gh at yahoo.com
> To: asterisk-users at lists.digium.com
> Subject: Re: [asterisk-users] Reporting for Asterisk Call Center
> 
> 
> Dear Tareq;
> 
> I am not using mysql, the configuration on the text configuratoin files and the logs are existed under the directory (/var/log/asterisk).
> 
> Well, to use mysql: then it means the configuration will be also in the database or I can use mysql only for reporting?
> 
> What is the Flash Operator?
> 
> By the way, I have another question if you can help me if you used the database with sql, actually I was facing one time a case and maybe the Database usage will help me if you can advise me:
> 
> If I have multiple Asterisk servers are running, and I need them to work centralized (I mean from one configuration) so to work as one system, then if I have database for configuration, I can acheive this by making all the servers read and write the configuration from the database server? 
> 
> Thanks for your help Tareq.
> 
> Regards
> Bilal
> 
> 
> ---------------
> > 
> > those reports can be easiely extracted from the MYSQL
> > database my friend.. and you can add the Flash Operator
> > Panel if you want to monitor live activities like how many
> > in queue and how many ON CALL .. etc
> > 
> > anyway the Elastix is a stand alone distribution you can
> > find more info and downloads at : http://elastix.org/
> > regards
> > 
> > 
> > Tarek Sawah
> > 
> > Information Technology  Adviser
> > 
> > Integrated Digital Systems
> > 
> > CCNP, MCSE, RHCE, TELECOM
> > 
> > USA: +1 386 492 9993
> > 
> > 
> > 
> 
> 
> --
> _____________________________________________________________________
> -- Bandwidth and Colocation Provided by http://www.api-digital.com --
> New to Asterisk? Join us for a live introductory webinar every Thurs:
>                http://www.asterisk.org/hello
> 
> asterisk-users mailing list
> To UNSUBSCRIBE or update options visit:
>    http://lists.digium.com/mailman/listinfo/asterisk-users