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
When using mysql cdrs, are all legs of a call session logged in the cdr
table? i'm building an app that requires billing on both the incoming and
outgoing (3rd-party transfers) legs.
here's a snapshot of my cdr table:
+-+-+-+-++--+---
Outbound calls are not logged seperatly in the CDR. So the duration is
the time the hangup extension ends minus time someone dials in on *.
Although I think it could be usefull to seperatly log an outgoing
call-session when it was bridged... My .02 euro.
with kind regards,
Steven
On Wed,
Brian West wrote:
cdr_odbc is for logging CDR data to a database. Its pretty much blind to
the type of database you choose as long as it has an ODBC driver.
We had it speaking to an AS/400 running DB2... we also have it working
with MSSQL (not my goal but hey it works), mysql, pgsql and
WipeOut wrote:
I see the cdr_odbc stuff is now in the CVS but I did not see a sample
config file in the configs directory of the CVS.. Am I mising somthing?
How is cdr_odbc configured?
http://www.voip-info.org/wiki-Asterisk+cdr+odbc
/O
___
How can I download the asterisk-addons and setup CDR support for mysql?
I reviewed the wiki but did not find instructions on dowloading. Just a
sample of the cdr_mysql.conf file.
DaL
--
David A. Lauer
Network Engineer
Tristar Communications
[EMAIL PROTECTED]
954.977.8081 ext. 21
You can check it out via CVS. asterisk-addons
-Original Message-
From: David A. Lauer [mailto:[EMAIL PROTECTED]
Sent: Saturday, December 27, 2003 3:16 PM
To: Asterisk Users
Subject: [Asterisk-Users] mysql cdrs
How can I download the asterisk-addons and setup CDR support for mysql?
I
PROTECTED]
URL:www.evtmedia.com http://www.evtmedia.com
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
Sean Cheesman
Sent: Saturday, December 27, 2003 8:21 PM
To: '[EMAIL PROTECTED]'
Subject: RE: [Asterisk-Users] mysql cdrs
To: '[EMAIL PROTECTED]'
Subject: RE: [Asterisk-Users] mysql cdrs
You can check it out via CVS. asterisk-addons
-Original Message-
From: David A. Lauer [mailto:[EMAIL PROTECTED]
Sent: Saturday, December 27, 2003 3:16 PM
To: Asterisk Users
Subject: [Asterisk-Users] mysql cdrs
:14 -0600 (CST)
From: Brian West [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: RE: [Asterisk-Users] mysql cdrs
Reply-To: [EMAIL PROTECTED]
Or use cdr_odbc :P
___
Asterisk-Users mailing list
[EMAIL PROTECTED]
http://lists.digium.com
14 matches
Mail list logo
