but i do not know how to interface the CDRs.
has anyone used this tool or any other similar tool?
how about something like this:
pbx@pbx:~$ grep -v ^; /etc/asterisk/cdr_mysql.conf
[global]
hostname=localhost
dbname=dbname
table=tablename
password=password
user=username
port=3306
Στις 26/9/2013 2:48 μμ, ο/η ad...@3a.hu έγραψε:
but i do not know how to interface the CDRs.
has anyone used this tool or any other similar tool?
how about something like this:
pbx@pbx:~$ grep -v ^; /etc/asterisk/cdr_mysql.conf
[global]
hostname=localhost
dbname=dbname
table=tablename
Hi. i am running asterisk 11.5.1 in my system (debian squeeze) and i do get
the CDRs through the csv file, that asterisk creates.
i would like to have the CDRs in a nice web based tool and after some
search i have found
http://acdr.com.au/
i do have it installed with all the dependencies (apache,
but i do not know how to interface the CDRs. has anyone used this tool or
any other similar tool?
It expects your CDR to be located in a mysql database. You'll either need to
figure out how to import your .csv into mysql, or have Asterisk send the CDR
directly to the mysql database.
Doug
i have uploaded two files for you
one is the php script that reads Master.csv and loads data in the database
you have to change
$locale_db_name = 'databasename';
$locale_db_login = 'user';
$locale_db_pass = 'password';
this how you run the script
php /path/cdrmysql.php