CDR writing / Call log

wayne106 · Post by **wayne106** » Mon Apr 07, 2008 7:48 am

BSS 2.1.6.6 Standard

Does anyone know of a way to get CDR's out of BSS ideally into SQL?

I see that there is a way to do this with radius, but ideally I need them in SQL, or even as a HTTP push (maybe via a plugin)

Any suggestions much appreciated.

Thanks,

Wayne

redroof · Post by **redroof** » Mon Apr 07, 2008 10:36 am

Hi Wayne
You can find a text based call-log in the log folder. (e,g: session.20080407.log)
<INSTALL_DIRECTORY>/webapps/proxy/WEB-INF/work/sv/log

And I think you can create own logging scheme by Accounting Plugin.

voipwell.com · Post by **voipwell.com** » Tue Apr 08, 2008 6:45 am

I do it by using radius and an a third party DB (mssql 2005). Now with pal, you can also use pal to put the calls in a db.

wayne106 · Post by **wayne106** » Wed Apr 09, 2008 7:19 am

voipwell.com wrote:I do it by using radius and an a third party DB (mssql 2005). Now with pal, you can also use pal to put the calls in a db.

Hi Nick, are you using some middleware to receive the radius info then insert it into SQL? If so do you mind me asking which package you are using?

Also I thought PAL only worked with PBX or does it work with BSS as well?

I have looked at the log file as well, thanks for that Redroof

Thanks

Wayne