Bug#1031329: unixodbc-dev: /usr/include/sqltypes.h refers to unixodbc.h, which is no longer included!

[Michael Shipper]

Package: unixodbc-dev
Version: 2.3.11
Severity: important
X-Debbugs-Cc: Michael...@Charter.com

Dear Maintainer,

*** Reporter, please consider answering these questions, where appropriate ***

* What led up to the situation?
I maintain a custom perl build at the cuompany I work for and when
I tried to build DBD::ODBC, the build process stopped working as of
the latest update.
It looks like unixodbc.h was removed from the pakcage?
make
"/opt/apps/charter-perl/bin/perl" -MExtUtils::Command::MM -e 'cp_nonempty' -- ODBC.bs blib/arch/auto/DBD/ODBC/ODBC.bs 644
gcc -c -I/usr/include -I. -I/opt/apps/charter-perl/lib/site_perl/5.34.0/x86_64-linux-multi/auto/DBI -fwrapv -DDEBUGGING -fno-strict-aliasing -pipe -fstack-protector-strong -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -D_FORTIFY_SOURCE=2 -g -O2 -ffile-prefix-map=/build/repos/charter-perl_1.0-000047_amd64.build/charter-perl-5.34.0=. -fstack-protector-strong -Wformat -Werror=format-security -DVERSION=\"1.61\" -DXS_VERSION=\"1.61\" -fPIC "-I/opt/apps/charter-perl/lib/5.34.0/x86_64-linux-multi/CORE" -I/usr/include ODBC.c
In file included from /usr/include/sql.h:19,
from dbdodbc.h:6,
from ODBC.h:8,
from ODBC.xs:1:
/usr/include/sqltypes.h:56:10: fatal error: unixodbc.h: No such file or directory
56 | #include "unixodbc.h"
| ^~~~~~~~~~~~
compilation terminated.
make: *** [Makefile:394: ODBC.o] Error 1

* What exactly did you do (or not do) that was effective (or
ineffective)?
used apt-file to find unixodbc.h.. there is no such file right
now??
* What was the outcome of this action?
file not found
* What outcome did you expect instead?
I expected this header to be included in unixodbc-dev

Please let me know if I should be installing a different package.
This was working a few weeks ago, but it seems the header files have
changed.
*** End of the template - remove these template lines ***


-- System Information:
Debian Release: 11.6
APT prefers stable-updates
APT policy: (500, 'stable-updates'), (500, 'stable-security'), (500, 'stable')
Architecture: amd64 (x86_64)

Kernel: Linux 5.10.0-21-amd64 (SMP w/4 CPU threads)
Kernel taint flags: TAINT_OOT_MODULE, TAINT_UNSIGNED_MODULE
Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8), LANGUAGE not set
Shell: /bin/sh linked to /usr/bin/dash
Init: systemd (via /run/systemd/system)
LSM: AppArmor: enabled

Versions of packages unixodbc-dev depends on:
ii libltdl-dev [libltdl3-dev] 2.4.6-15
ii odbcinst1debian2 2.3.11
ii unixodbc 2.3.11

unixodbc-dev recommends no packages.

unixodbc-dev suggests no packages.

-- no debconf information

[Shipper, Michael]

Huh,

So it looks like this is a problem with the Microsoft Debian package, not with the package provided by Debian.

Please disregard my previous email.

-----Original Message-----
From: Michael Shipper <Michael...@Charter.com>
Sent: Tuesday, February 14, 2023 7:07 PM
To: Debian Bug Tracking System <sub...@bugs.debian.org>
Subject: [EXTERNAL] Bug#1031329: unixodbc-dev: /usr/include/sqltypes.h refers to unixodbc.h, which is no longer included!

CAUTION: The e-mail below is from an external source. Please exercise caution before opening attachments, clicking links, or following guidance.

[Shipper, Michael]

So,

 

It looks like the bug is in the Microsoft odbc package not the Debian odbc package.

Please close this ticket.

 

I apologize for any inconvenience.

The contents of this e-mail message and
any attachments are intended solely for the
addressee(s) and may contain confidential
and/or legally privileged information. If you
are not the intended recipient of this message
or if this message has been addressed to you
in error, please immediately alert the sender
by reply e-mail and then delete this message
and any attachments. If you are not the
intended recipient, you are notified that
any use, dissemination, distribution, copying,
or storage of this message or any attachment
is strictly prohibited.