Hello Will, thank you for getting back to me. Yes, I have added the fields but how do I populate those fields which are not a part of the default cdrs table? Where do I make the modification in the kamailio config file to update the cdrs table? Again, thanks for the help.

Regards,
Arun


From: Will Ferrer <will.ferrer@switchsoft.com>
To: arun Jayaprakash <jayaprakasharun@yahoo.com>; Kamailio (SER) - Users Mailing List <sr-users@lists.sip-router.org>
Sent: Tuesday, November 26, 2013 5:06 PM
Subject: Re: [SR-Users] adding new column in the CDRS table?

Hi Arun

We have added several columns to our cdr table simple by connecting to the database through mysql workbench and adding them, and then modifying the mysql routine: kamailio_cdrs to populate in the required data to the new fields. We are however also using siremis which is where these cdr generation routines come from -- http://siremis.asipto.com/

Some info on cdr generation for the acc module can be found here:

I hope that helps.

All the best.

Will Ferrer




On Tue, Nov 26, 2013 at 9:29 AM, arun Jayaprakash <jayaprakasharun@yahoo.com> wrote:
Hello, can someone let me know how I can add a new field in the cdrs table? I would like to set a flag depending if a call is make to another extension number of if the call is made to a PSTN line. Thank you for the help.

Arun

_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users