Install Call Center Stats LITE

How to Install LITE version

These install instructions apply to the Lite version.

Download the software:

cd /usr/src
wget http://www.asternic.net/download/asternic-stats-1.4.tgz

Untar the file:

tar zvxf asternic-stats-1.4.tgz
cd asternic-stats

Create a mysql database:

mysqladmin -u root -p create qstats

Create the tables for the database:

mysql -u root -p qstats < sql/qstats.sql

Edit /usr/src/asternic-stats/html/config.php to set authenticate information for the database:

$dbhost = ‘localhost’;
$dbname = ‘qstats’;
$dbuser = ‘root’;
$dbpass = ”;

$manager_host = “127.0.0.1″;
$manager_user = “admin”;
$manager_secret = “admin”;

$language = “es”;

Edit /usr/src/asternic-stats/parselog/config.php with auth information for the database:

$queue_log_dir = ‘/var/log/asterisk/’;
$queue_log_file = ‘queue_log’;

$dbhost = ‘localhost’;
$dbname = ‘qstats’;
$dbuser = ‘root’;
$dbpass = ”;

Move the html directory to Apache DocumentRoot:

mv /usr/src/asternic-stats/html /var/www/html/queue-stats

Move the parselog directory to its new home:

mv /usr/src/asternic-stats/parselog /usr/local

Create a cron job to parse data from queue_log and populate the database:

crontab -e

And type this in your cronjob file:

0 * * * * php -q /usr/local/parselog/parselog.php convertlocal

You can save it by pressing “:x”

Finally, you can see the statistics and reports with your browser from http://ip.asterisk/queue-stats