[SR-Users] adding new column in the CDRS table?

[arun Jayaprakash]

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 at switchsoft.com>
To: arun Jayaprakash <jayaprakasharun at yahoo.com>; Kamailio (SER) - Users Mailing List <sr-users at 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 at 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 at lists.sip-router.org
>http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20131126/7cef265f/attachment.html>