Thank you very much for that debugging information Tony. That's exactly what I was looking for, I just didn't know how to ask for it. You understand Noobian very well ;). It lead me right to the problem.
Unfortunately, it was not a dazzling problem, it was a hard (for me) to spot typo in a column name (dsst rather than dst). Thanks for the other suggestions too from Colin and Duane, I had done those already and that's why I was at my wits end without knowing how to get a more detailed error log. Cheers, Phil >>>It's probably a database or SQL Server configuration problem. The module works, because I'm using it in production. If you are using safe_asterisk to start up, put the following lines into /usr/sbin/safe_asterisk near the top, just after the DUMPDROP definition: TDSDUMP=/tmp/tdsdump.$$.log TDSDUMPCONFIG=/tmp/tdsdumpconfig.$$.log export TDSDUMP TDSDUMPCONFIG Then look for those files in the /tmp directory when asterisk is running. They will contain a lot more debugging information from the FreeTDS libraries. If you're not using safe_asterisk, then just call the above lines from your shell before you invoke asterisk. Hope this helps Cheers Tony -- Tony Mountifield Work: [EMAIL PROTECTED] - http://www.softins.co.uk Play: [EMAIL PROTECTED] - http://tony.mountifield.org >I am trying to get * to write CDR records to an MS SQL table. I am used >the freeTDS set up (not using UNIX ODBC), and it appears to be making the >connection to the database, but I make a call, I get this error: > > WARNING[3369]: cdr_tds.c:180 tds_log: Reconnected to SQL database. > ERROR[3369]: cdr_tds.c:191 tds_log: Failed to insert Call Data Records > into SQL database. > > I've assigned all rights to the cdr table in SQL to the user. I am not > sure how to troubleshoot this from this point. Does anyone know else > these errors are? Thanks for any direction. > > Phil > > > _______________________________________________ > Asterisk-Users mailing list > [email protected] > http://lists.digium.com/mailman/listinfo/asterisk-users > To UNSUBSCRIBE or update options visit: > http://lists.digium.com/mailman/listinfo/asterisk-users > _______________________________________________ Asterisk-Users mailing list [email protected] http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
