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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of asterisk Sent: Wednesday, March 24, 2004 10:44 PM To: [EMAIL PROTECTED] 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 [EMAIL PROTECTED] 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 _______________________________________________ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
