[Asterisk-Users] CDR and Mysql (or Postgre)

Joe Dennick joe at dennick.net
Thu Mar 25 05:38:44 MST 2004


Download asterisk-addons from the CVS.  Compile it the same way you
compile asterisk and it's other modules.  Make sure you have MySQL
installed and running.  Then read the file
/usr/src/asterisk-addons/doc/cdr_mysql.txt for information on how to
create the necessary tables in your database.  The last step is to copy
the config file: /usr/src/asterisk-addons/cdr_mysql.conf.sample to
/etc/asterisk/cdr_mysql.conf and edit it with the username, database,
password, etc. for your particular environment.  Its really that simple,
and all calls are then inserted into the database when they end.

-----Original Message-----
From: asterisk-users-admin at lists.digium.com
[mailto:asterisk-users-admin at lists.digium.com] On Behalf Of asterisk
Sent: Wednesday, March 24, 2004 10:44 PM
To: asterisk-users at lists.digium.com
Subject: [Asterisk-Users] CDR and Mysql (or Postgre)


I have been researching using mysql as a database to manage the cdr's.

However, I do not see how to get asterisk to insert the records directly
in the database. All I can see from my searches is some scripts to copy
the master.csv text file into the database. However I think this would
be problematic. If you copy at midnight, then do you erase the file
after you copy it? What about calls that are still ongoing? Where do
they get logged?

How are other people moving the CDR's into a database in real time for
billing either pre-paid or post-paid?

_______________________________________________
Asterisk-Users mailing list
Asterisk-Users at lists.digium.com
http://lists.digium.com/mailman/listinfo/asterisk-users
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users

---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.614 / Virus Database: 393 - Release Date: 3/5/2004
 

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.614 / Virus Database: 393 - Release Date: 3/5/2004
 




More information about the asterisk-users mailing list