Top System Posted February 1, 2010 Report Share Posted February 1, 2010 I read lots of topics, where people were asking to store the cdr informations to a SQL database. (mySql, MS Sql) So I decided to write a small windows service to capture the cdr sent by pbxnsip and to store these cdr in a Sql database ( mySQL, MS SQL, Orcacle : depending on your db provider). Not all versions of MS Sql supports SOAP, and there is less informations available in the SOAP cdr format. All the fields described in the simple CDR format or long CDR format can be used in cdr2sql. http://www.pbxnsipsupport.com/index.php?_m...kbarticleid=464 The application is working by receiving the cdr logs on a specific TCPIP port. It's simple to install and there is no latency between the end of the call and the availability of the information in the database. The only think you have to do after installing the application and configuring the credentials to connect the database, is to configure pbxnsip : - to send the cdr to the tcp ip address and port where the cdr2sql service is installed - to adapt the pbx.xml file to the format you like PBXNSIP cdr2sql (screenshots) Quote Link to comment Share on other sites More sharing options...
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.