[asterisk-users] mysql CDRs in web based tool

[Bob Kyeyune]

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 /var/log/asterisk/cdr-csv/Master.csv

path is the location where your cdrmysql.php is located


second is the database already truncated for you


hope this helps

Regards.
Kyeyune Bob
VOIP Engineer
+256 774 702 258






On Wed, Sep 25, 2013 at 5:02 PM, Doug Lytle <support at drdos.info> wrote:

> >> 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
>
>
> --
> _____________________________________________________________________
> -- 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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.digium.com/pipermail/asterisk-users/attachments/20130925/997d6fe7/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: database.sql
Type: application/octet-stream
Size: 5906 bytes
Desc: not available
URL: <http://lists.digium.com/pipermail/asterisk-users/attachments/20130925/997d6fe7/attachment-0001.obj>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: cdrmysql.php
Type: application/x-httpd-php
Size: 3265 bytes
Desc: not available
URL: <http://lists.digium.com/pipermail/asterisk-users/attachments/20130925/997d6fe7/attachment-0001.php>