Bug#219450: marked as done (openoffice.org: Crashes with database (ODBC/FreeTDS/MSSQL7))
Your message dated Thu, 29 Jan 2004 16:12:56 +0100
with message-id <1075389176.8104.76.camel@scooby.cmt>
and subject line Bug #219450 - Crashes with database (ODBC/FreeTDS/MSSQL7) - bug in FreeTDS
has caused the attached Bug report to be marked as done.
This means that you claim that the problem has been dealt with.
If this is not the case it is now your responsibility to reopen the
Bug report if necessary, and/or fix the problem forthwith.
(NB: If you are a system administrator and have no idea what I am
talking about this indicates a serious mail system misconfiguration
somewhere. Please contact me immediately.)
Debian bug tracking system administrator
(administrator, Debian Bugs database)
--------------------------------------
Received: (at submit) by bugs.debian.org; 6 Nov 2003 16:38:51 +0000
>From wt@electro-mechanical.com Thu Nov 06 10:38:26 2003
Return-path: <wt@electro-mechanical.com>
Received: from internal-bristol34.naxs.com (mail.electro-mechanical.com) [216.98.66.34]
by master.debian.org with esmtp (Exim 3.35 1 (Debian))
id 1AHn9N-00072i-00; Thu, 06 Nov 2003 10:38:26 -0600
Received: from root by mail.electro-mechanical.com with local (Exim 4.20 #1 (Debian))
id 1AHn9M-0001hT-PV
for submit@bugs.debian.org; Thu, 06 Nov 2003 11:38:24 -0500
Date: Thu, 6 Nov 2003 11:38:24 -0500
From: William Thompson <wt@electro-mechanical.com>
To: submit@bugs.debian.org
Subject: openoffice.org: Crashes with database (ODBC/FreeTDS/MSSQL7)
Message-ID: <20031106163824.GY14037@electro-mechanical.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
User-Agent: Mutt/1.3.28i
Delivered-To: submit@bugs.debian.org
X-Spam-Status: No, hits=-5.0 required=4.0
tests=HAS_PACKAGE
version=2.53-bugs.debian.org_2003_11_03
X-Spam-Level:
X-Spam-Checker-Version: SpamAssassin 2.53-bugs.debian.org_2003_11_03 (1.174.2.15-2003-03-30-exp)
Subject: openoffice.org: Crashes with database (ODBC/FreeTDS/MSSQL7)
Package: openoffice.org
Version: 1.1.0-1
Severity: important
I attempt to retrieve tables from a database that is in an MSSQL7 server and
oo crashes with sig 11. I also downloaded OO precompiled from openoffice.org
to see if this was debian specific or an OO problem. It's an OO problem.
I'm using unixODBC with FreeTDS. I tested the ODBC with isql first. I
started OO immediately after installation with a new spreadsheet. I added
the data base into OO's data sources with username set and password required.
When I expand tables, it asks for the password and once I enter it, OO
crashes.
The database has 92 tables defined. I am unable to test against another
database or another mssql server as this is all I have access to.
-- System Information
Debian Release: 3.0
Kernel Version: Linux potato 2.4.20 #3 SMP Wed Dec 11 08:49:36 EST 2002 i686 unknown
Versions of the packages openoffice.org depends on:
ii dictionaries-c 0.15.7 Common utilities for spelling dictionary too
ii openoffice.org 1.1.0-1 English (US) language package for openoffice
ii openoffice.org 1.1.0-1 OpenOffice.org office suite binary files
ii openoffice.org 1.1.0-1+2 Debian specific parts of OpenOffice.org
ii openoffice.org 1.1.0-1 English (US) language package for openoffice
^^^ (Provides virtual package openoffice.org-l10n-1.1.0)
openoffice.org-updatedicts Not installed or no info
---------------------------------------
Received: (at 219450-close) by bugs.debian.org; 29 Jan 2004 15:12:40 +0000
>From halls@debian.org Thu Jan 29 07:12:40 2004
Return-path: <halls@debian.org>
Received: from (rover24.cmt) [217.110.227.19]
by spohr.debian.org with esmtp (Exim 3.35 1 (Debian))
id 1AmDqS-000515-00; Thu, 29 Jan 2004 07:12:40 -0800
Received: from scooby.cmt (scooby [192.168.60.70])
by rover24.cmt (Postfix) with ESMTP id B5581C7A1F
for <219450-close@bugs.debian.org>; Thu, 29 Jan 2004 16:12:39 +0100 (CET)
Received: by scooby.cmt (Postfix, from userid 1050)
id 722E03B95E; Thu, 29 Jan 2004 16:12:56 +0100 (CET)
Subject: Bug #219450 - Crashes with database (ODBC/FreeTDS/MSSQL7) - bug in
FreeTDS
From: Chris Halls <halls@debian.org>
To: 219450-close@bugs.debian.org
Content-Type: text/plain
Content-Transfer-Encoding: 7bit
Message-Id: <1075389176.8104.76.camel@scooby.cmt>
Mime-Version: 1.0
X-Mailer: Ximian Evolution 1.4.5
Date: Thu, 29 Jan 2004 16:12:56 +0100
Delivered-To: 219450-close@bugs.debian.org
X-Spam-Checker-Version: SpamAssassin 2.60-bugs.debian.org_2004_01_27
(1.212-2003-09-23-exp) on spohr.debian.org
X-Spam-Status: No, hits=0.0 required=4.0 tests=none autolearn=no
version=2.60-bugs.debian.org_2004_01_27
X-Spam-Level:
------- Additional comments from oj Wed Dec 3 05:04:28 -0800 2003 -------
It's a driver bug, when calling SQLGetInfo for SQL_FILE_USAGE, they
write their value in a unsigned interger which should be by definition
of ODBC a usigned small integer. This leads to the GPF.
------- Additional comments from oj Wed Dec 3 23:08:08 -0800 2003 -------
The bug is fixed in the FreeTDS driver (cvs version). I set this one
to invalid, because the bug doesn't occur inside the OpenOffice.org
source code.
@see
"
>>
>> Hi all,
>>
>> I encounter a bug in the function SQLGetInfo. When asking for
>> SQL_FILE_USAGE, the return value is inserted into a
>> SQL_UINTEGER which
>> overwrites some stack variables since the type for
>> SQL_DFILE_USAGE is a
>> SQL_USMALLINT. This leads to GPF when using it with OpenOffice.org.
>>
>> For a brief discussion please have a look at
>> http://www.openoffice.org/issues/show_bug.cgi?id=22232&frame=true
>>
>> Best regards,
>>
>> Ocke
>>
>> PS: I don't know if this is the only one
>>
Fixed. Noted that 0.62 version (current CVS) do not have the bug...
Reply to: