According to the docs (Asterisk MSSQL CDR Logging), it should be easy to get CDRs logged to a remote MS SQL Server.
It does not seem to work with Asterisk 1.8 though. Is that correct?
Here is what I tried:
I have the module cdr_tds.so installed and showing in Asterisk with “module show”.
Config files are:
host = SIPCDR1
port = 1360
tds version = 7.3
[global] connection=cdrSQL dbname=PhoneList table=cdrCurrent user=asterisk password=(veryverysecret) language=us_english
The table “cdrCurrent” exists in the database “PhoneList” on the server.
I can connect to the server with:
tsql -S cdrSQL -U asterisk -P (veryverysecret)
CDR logging is enabled in /etc/asterisk/cdr.conf.
In fact Asterisk logs all CDRs to Master.csv in the cdr_custom directory.
What I want that it additionally logs them to that MSSQL server but there is no output to the table, and there is no error message in any log, no trace of any problem but no data gets logged.
I enabled dump file in freetds.conf but I do not understand anything what it logs or if this even has anything to do with Asterisk.
As a note, the same server uses FreeTDS to save data from a web app to another MS SQL server but it has no configuration settings in /etc/freetds. I guess the app has its own config to do so.
What is the procedure to track something like this down?