asterisk users - Mar 2004 - 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?

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@lists.digium.com
[mailto:asterisk-users-admin@lists.digium.com] On Behalf Of asterisk
Sent: Wednesday, March 24, 2004 10:44 PM
To: asterisk-users@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@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