Chee Foong,
 
Here is a cdr_mysql2.c I rewrote.  It captures all the billing information you will need.
 
You will need to change the Makefile to compile it.
 
Also attached is a script to create the database.
 
Erik
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Chee Foong
Sent: Monday, August 04, 2003 2:24 AM
To: [EMAIL PROTECTED]
Subject: [Asterisk-Users] Mysql CDR

hello all,
 
I am using the msql cdr module to store cdr in db, I realised that it does't capture the start and end time af a particular call record.
 
Therefore I dive into the source code to add the start and end time into the query (add something like cdr->start, cdr->end), but end up getting segfault.
 
the original version of cdr_mysql.so works fine but I need the start time and end time of calling as well.
 
I wonder what would I get with cdr->start? the start time field in my db  is of type date or should i use varchar?
 
 
thanks
 
Foong  

Attachment: cdr_mysql2.c
Description: Binary data

Attachment: billing.sql
Description: Binary data

Reply via email to