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: http://kamailio.org/docs/modules/3.3.x/modules_k/acc.html#idp89024

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