Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

How to use FreeTDS for Asterisk CDR Storage to MS Sql Server?

April 26, 2017Asterisk CDR FreeTDS MS SQL Server storage

0

Posted

How to use FreeTDS for Asterisk CDR Storage to MS Sql Server?

1 Answer

0

Posted

MSSQL Asterisk can currently store CDRs into an MSSQL database two different ways: cdr_odbc.c or cdr_tds.c Call Data Records can be stored using unixODBC (which requires the FreeTDS package) cdr_odbc.c or directly by using just the FreeTDS package cdr_tds.c The following provide some examples known to get asterisk working with mssql. NOTE: Only choose one db connector. ODBC cdr_odbc.c Compile, configure, and install the latest unixODBC package: tar -zxvf unixODBC-2.2.9.tar.gz && cd unixODBC-2.2.9 && ./configure –sysconfdir=/etc –prefix=/usr –disable-gui && make && make install Compile, configure, and install the latest FreeTDS package: tar -zxvf freetds-0.62.4.tar.gz && cd freetds-0.62.4 && ./configure –prefix=/usr –with -tdsver=7.0 \ –with-unixodbc=/usr/lib && make && make install Compile, or recompile, Asterisk so that it will now add support for cdr_odbc.c make clean && make update && make && make install Setup odbc configuration files. These are working examples from my syste