RE: [Asterisk-Users] cdr_odbc not logging integers eg duration
Hi Iain, -Original Message- I've just noticed that since swapping from the direct mysql cdr driver to cdr_odbc, the call duration (and anything else that's an integer) isn't logged - anyone else seen this and know the reason. The cdr_odbc driver gives no error messages and records any string based fields correctly. Hm, my bet would be to check if the database definition is correct, this has been modified slightly in the recent past. It works just fine for me (after I figured out I needed that userfield appended)... Florian ___ 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
RE: [Asterisk-Users] cdr_odbc not logging integers eg duration
Hi! I've just noticed that since swapping from the direct mysql cdr driver to cdr_odbc, the call duration (and anything else that's an integer) isn't logged - anyone else seen this and know the reason. The cdr_odbc driver gives no error messages and records any string based fields correctly. Hm, my bet would be to check if the database definition is correct, this has been modified slightly in the recent past. It works just fine for me (after I figured out I needed that userfield appended)... This could also be an issue with unixODBC or mySQL or their interplay with cdr_odbc, so better make sure to check all sides and maybe use the occasion to upgrade mySQL. Cheers, Philipp ___ 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
Re: [Asterisk-Users] cdr_odbc not logging integers eg duration
I tried that - no errors reported. I checked one or two of the SQL calls and none returns an error. I rebuilt and reinstalled mysql and all the ODBC drivers - still no integers written! The direct MySQL driver logs calls fine. So it looks like there's a deeper problem with ODBC to sort out - at least on my system. Iain --On Saturday, January 17, 2004 6:25 pm -0600 Brian West [EMAIL PROTECTED] wrote: Check your tables. I logged everything as integer. set verbose 10 and make a call and watch it.. then do reload and watch the output. It will unload and reload and you can check to make sure your accually connetcing to the database. bkw On Sat, 17 Jan 2004, Iain Stevenson wrote: I've just noticed that since swapping from the direct mysql cdr driver to cdr_odbc, the call duration (and anything else that's an integer) isn't logged - anyone else seen this and know the reason. The cdr_odbc driver gives no error messages and records any string based fields correctly. Iain ___ 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 ___ 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
Re: [Asterisk-Users] cdr_odbc not logging integers eg duration
Check your tables. I logged everything as integer. set verbose 10 and make a call and watch it.. then do reload and watch the output. It will unload and reload and you can check to make sure your accually connetcing to the database. bkw On Sat, 17 Jan 2004, Iain Stevenson wrote: I've just noticed that since swapping from the direct mysql cdr driver to cdr_odbc, the call duration (and anything else that's an integer) isn't logged - anyone else seen this and know the reason. The cdr_odbc driver gives no error messages and records any string based fields correctly. Iain ___ 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