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, php, mysql), but i do not know how to interface the CDRs. has anyone used this tool or any other similar tool? Sincerely yours, -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://lists.digium.com/pipermail/asterisk-users/attachments/20130925/c30a6345/attachment-0001.html>
>> 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 -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://lists.digium.com/pipermail/asterisk-users/attachments/20130925/2a80564d/attachment-0001.html>
> 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 at pbx:~$ grep -v "^;" /etc/asterisk/cdr_mysql.conf [global] hostname=localhost dbname=dbname table=tablename password=password user=username port=3306 sock=/tmp/mysql.sock timezone=CET ; Previously called usegmtime [columns] alias start => calldate pbx at pbx:~$