Summary:	ASTERISK-11201: The issue 11726 was closed, but I am witness to the problem
Reporter:	Private Name (falves11)	Labels:
Date Opened:	2008-01-10 09:27:26.000-0600	Date Closed:	2008-01-10 11:36:31.000-0600
Priority:	Major	Regression?	No
Status:	Closed/Complete	Components:	CDR/cdr_odbc
Versions:		Frequency of Occurrence
Related Issues:
Environment:		Attachments:
Description:	In the latest Trunk, Lucher reported a bug in cdr-odbc (issue 11726) that I suffered this morning. The date field when inserting call got binary corruption, and inserts failed. Lurcher gave me the patch and it fixed the issue. Additionally, Lurcher made the ODBC driver from Easysoft uncrasahable, so he has some idea. I am the user who has a test bed where I can push the envelope to res_ODBC. I respectfully recommend that his patch be applied to trunk. It does not crash when it finds the issue but the record is not saved, which is terrible for the business. ****** ADDITIONAL INFORMATION ****** -= 16 extensions (66 priorities) in 6 contexts. =- sipserver*CLI> SQL Execute returned an error -1: 22007: [Easysoft][SQL Server Driver][SQL Server]Conversion failed when converting datetime from character string. (106) SQL Execute error -1! Attempting a reconnect... Connection is down attempting to reconnect... res_odbc: disconnected 0 from global [mssql] Connecting global res_odbc: Connected to global [mssql]
Comments:	By: Jared Smith (jsmith) 2008-01-10 09:38:42.000-0600 As I understand it, the 11726 bug was closed because the poster didn't sign the contributor license.  Without signing the license, the developers aren't allowed to look at the patch, so we're unable to fix the problem.  This protects the developers from having to worry about copyright issues, and ensures that Digium can continue to produce Asterisk under a dual-license situation, similar to the way MySQL and many other open-source projects are licensed. So, we have one of two choices... either get them to sign the license, or give us enough details about the patch (in plain English) that a developer can find the problem and fix it himself. By: Nick Gorham (lurcher) 2008-01-10 10:10:37.000-0600 I have uploaded the patch to the other ref. Oddly, I thought I had described the problem in good enough detail. Enough to be told I was wrong and it wasn't a bug anyway. By: Digium Subversion (svnbot) 2008-01-10 11:36:31.000-0600 Repository: asterisk Revision: 97805 U   trunk/cdr/cdr_odbc.c ------------------------------------------------------------------------ r97805 | tilghman | 2008-01-10 11:36:30 -0600 (Thu, 10 Jan 2008) | 3 lines Fix problem with timestr going out of scope (Closes issue ASTERISK-11196, closes issue ASTERISK-11201) ------------------------------------------------------------------------ http://svn.digium.com/view/asterisk?view=rev&revision=97805