[Asterisk-Users] tds_CDR and MS SQL Server troubleshooting

[PA]

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: tony at softins.co.uk - http://www.softins.co.uk
Play: tony at mountifield.org - 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
> Asterisk-Users at lists.digium.com
> http://lists.digium.com/mailman/listinfo/asterisk-users
> To UNSUBSCRIBE or update options visit:
>   http://lists.digium.com/mailman/listinfo/asterisk-users
>