[asterisk-users] Reporting for Asterisk Call Center

[bilal ghayyad]

Dear Tark;

The asterisk version I am running is 1.8 and I can select mysql from menuselect when I am compiling. 

But when I googled for cdr-mysql, I discovered that I have to login for mysql and create the database and run a script to create this and give the grants. All what I found in google is related to other asterisk versions, while mine is 1.8, so the problem is how to know the required script to create the database and give the right grants to be used for CDR that suite the version I am running? From where I can get this?

One more thing, I found there is asterisk-stat and cdr-stats, can I use those with asterisk 1.8? And I will be able to use them to generate basic call center reports (reports related to queuing and number of logged in agents)?

Appreciate the kindly help.
Regards
Bilal

--------------------- 
> 
> 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