Package unixodbc-dev has incorrect include #36

Danack · 2023-02-11T17:25:49Z

Describe the issue

The package unixodbc-dev is trying to include the file "unixodbc.h" in version 2.3.11. That file does not exist in the package so it fails.

In version 2.3.7 the file of "unixodbc_conf.h" is part of the installed package and is used.

In version 2.3.11 the file of "unixodbc_conf.h" is part of the installed package but for some reason, the file "unixodbc.h" is referenced in sqltypes.h which is also part of the unixodbc-dev package.

Also, the file "unixodbc_conf.h" in 2.3.11 looks like it has been generated for a particular computer, compared to the file in 2.3.7 that looks like a generic source file ready to be compiled.

When did the issue occur?

The problem was first noticed yesterday, but if you're asking when the problem originated, it is somewhere between unixodbc-dev_2.3.7 and unixodbc-dev_2.3.11.

unixodbc-dev_2.3.7/usr/include/sqltypes.h:

#ifndef SIZEOF_LONG_INT
#include "unixodbc_conf.h"
#endif

unixodbc-dev_2.3.11/usr/include/sqltypes.h line 55-57:

#ifndef SIZEOF_LONG_INT
#include "unixodbc.h"
#endif

If appplicable, what package did you attempt to install, and from which repo?

Package is unixodbc-dev and appears to be installed from:

https://packages.microsoft.com/ubuntu/20.04/prod focal/main amd64 unixodbc-dev amd64 2.3.11 [42.1 kB]

Debugging was done by manually downloading files from https://packages.microsoft.com/ubuntu/20.04/prod/pool/main/u/unixodbc/ and inspecting contents of files.

Steps to Reproduce
Short version, try to compile unixodbc into an application and it will fail

In file included from /usr/include/sql.h:19,
                 from /home/runner/work/php-src/php-src/ext/odbc/php_odbc_includes.h:107,
                 from /home/runner/work/php-src/php-src/ext/odbc/php_odbc.c:33:
/usr/include/sqltypes.h:56:[10](https://github.com/php/php-src/actions/runs/4148457300/jobs/7176463762#step:8:11): fatal error: unixodbc.h: No such file or directory
   56 | #include "unixodbc.h"
      |          ^~~~~~~~~~~~
compilation terminated.

I don't have a standalone test case.

Actual Result

Fails to find file as it is looking for the wrong file name.

Expected Result

Compilation succeeds

Screenshots

Additional context

This was noticed as part of PHP's ci

The text was updated successfully, but these errors were encountered:

AlexLinuxGallo91 · 2023-02-12T00:24:24Z

i have the same problem, when i install the package in my docker container (PHP-fpm 8.1) and enter to the path /usr/include, there's no the unixodbc.h in the listed files.

bjverde · 2023-02-12T01:07:41Z

I have the same problem, when i install the package in my docker container
the script works correctly until january 2023. Nothing has changed and now it has these issues.

This issue is happening with Debian 10 and 11 with Drive 5.10.0 or 5.10.1

With driver 5.9.0 and Debian 10, PHP 7.4 but repo microsoft debian 9. Its Works !!

My DockerFile
https://github.com/bjverde/formDocker/blob/master/debian10_php8.1_mssql/debian10_apache_php81_mssql.Dockerfile

bjverde · 2023-02-12T01:31:08Z

In Debian 10, with php 8.1 changing the repository from Debian 10 to Debian 9. It will create the Docker script, I haven't tested if it will connect to the database, I believe so.

Change
https://packages.microsoft.com/config/debian/10/prod.list
to
https://packages.microsoft.com/config/debian/9/prod.list

Korred · 2023-02-13T08:45:48Z

Yeah, this hit us as well when trying to deploy a python application that uses pyodbc

ylcdx · 2023-02-13T13:46:48Z

With PHP 8.1 and Debian 11, changing the repository from 11 to 10 or from 11 to 9 does not fix the problem. I still get the error :
/usr/include/sqltypes.h:56:10: fatal error: unixodbc.h: No such file or directory

Yaroslav285 · 2023-02-13T13:55:59Z

Hello,

Switching to the PHP image tag 8.1-apache-buster and changing the repository to 9 helped me.

https://packages.microsoft.com/config/debian/9/prod.list

https://hub.docker.com/_/php/tags?page=1&name=8.1-apache-buster

ylcdx · 2023-02-13T14:15:52Z

Unfortunately, I can only use php:8.1-fpm-bullseye, I don't have the possibility to change it :/

bogdanbradeanu · 2023-02-13T14:39:38Z

i have the same problem. App built using 8.1.12-fpm-bullseye and i cannot replace this with something else.

dbrmr · 2023-02-13T14:52:57Z

I also have this problem when trying to install SQL Server drivers for PHP 8.2 on Debian 11

sudo pecl install sqlsrv

jakeblatchford · 2023-02-13T14:57:58Z

I'm currently working around this on php:8.1-bullseye by forcing installation of the old version:

apt-get install unixodbc-dev=2.3.7 unixodbc=2.3.7 odbcinst1debian2=2.3.7 odbcinst=2.3.7

ylcdx · 2023-02-13T15:10:17Z

I confirm that Jake's solution works, thanks ;)

lucasfcnunes · 2023-02-13T17:17:22Z

I'm currently working around this on php:8.1-bullseye by forcing installation of the old version:
apt-get install unixodbc-dev=2.3.7 unixodbc=2.3.7 odbcinst1debian2=2.3.7 odbcinst=2.3.7

I had to run this on python:3.7-slim-buster:

apt-get install unixodbc-dev=2.3* unixodbc=2.3* odbcinst1debian2=2.3* odbcinst=2.3*

https://packages.debian.org/buster/unixodbc-dev 2.3.7 doesn't seem to exist on the official PPA...

adiel91 · 2023-02-13T18:39:14Z

I can confirm the issue occurs for me as well, when using docker container based on debian11 distribution,
and trying to install pyodbc module for python2.
For python3 on same docker - no issues.

The WA that worked for me for now is similar to suggested above - install 2.3.7 versions explicitly:
apt-get install unixodbc-dev=2.3.7 unixodbc=2.3.7 odbcinst1debian2=2.3.7 odbcinst=2.3.7

cl-m-furkan · 2023-02-14T04:26:18Z

Hit the same problem with pyodbc package (4.0.30) on python3.10.

For python3 on same docker - no issues.

Probably OK either because docker caches, or because using latest pyodbc version 4.0.35, which has binaries for x86_64_linux_glibc, so it skips compilation.. But the problem (broken include files) are still there.

Problem can still be reproduced by disabling binary downloads;

pip install --no-cache-dir --no-binary pyodbc --no-cache-dir pyodbc==4.0.35

Version pinning in apt-get install line helped our case as well, until this issue is fixed.

How to check the cause

$ grep -nir -e 'unixodbc.*\.h' /usr/include/sqltypes.h

should NOT return a line like following;

#include "unixodbc.h"

because that file (unixodbc.h) is not packaged.

Correct result;

# grep -e unixodbc.*\.h /usr/include/sqltypes.h 
 * the install creates a unixodbc_conf.h file that contains the current build settings
#include "unixodbc_conf.h"

yerlanamantaiuly · 2023-02-14T06:27:32Z

ubuntu 22.04 i confirm Jake's solution works too.

RUN ACCEPT_EULA=Y apt-get install -y
msodbcsql17
mssql-tools
unixodbc-dev=2.3.7
unixodbc=2.3.7
odbcinst1debian2=2.3.7
odbcinst=2.3.7

RUN echo 'export PATH="$PATH:/opt/mssql-tools17/bin"' >> ~/.bashrc RUN exec bash
RUN pecl install sqlsrv-5.8.0 RUN printf "; priority=20\nextension=sqlsrv.so\n" > /etc/php/7.3/mods-available/sqlsrv.ini

David-Engel · 2023-02-14T18:23:54Z

We are aware of the problem and are working on an updated 2.3.11 package for unixodbc-dev, ASAP.

Regards,
David

cdillmann · 2023-02-15T10:12:11Z

I could build my PHP Docker container with Debian 9.

curl https://packages.microsoft.com/keys/microsoft.asc | apt-key add -
&& curl https://packages.microsoft.com/config/debian/9/prod.list > /etc/apt/sources.list.d/mssql-release.list
&& apt-get -y update
&& ACCEPT_EULA=Y apt-get install -y gnupg2 msodbcsql17 unixodbc-dev
&& pecl install sqlsrv
&& docker-php-ext-enable sqlsrv
&& pecl install pdo_sqlsrv
&& docker-php-ext-enable pdo_sqlsrv

Kudos to Bjverde

[read here](microsoft/linux-package-repositories#36)

akalinux · 2023-02-15T15:16:04Z

I am having the same issue, is there a timeline for a fix?

rodrigomartinezar · 2023-02-15T15:28:26Z

I'm currently working around this on php:8.1-bullseye by forcing installation of the old version:
apt-get install unixodbc-dev=2.3.7 unixodbc=2.3.7 odbcinst1debian2=2.3.7 odbcinst=2.3.7
I had to run this on python:3.7-slim-buster:
apt-get install unixodbc-dev=2.3* unixodbc=2.3* odbcinst1debian2=2.3* odbcinst=2.3*
https://packages.debian.org/buster/unixodbc-dev 2.3.7 doesn't seem to exist on the official PPA...

On python:3.7.7-slim-buster I had to run:

apt-get --allow-downgrades -y install unixodbc-dev=2.3.7 unixodbc=2.3.7 odbcinst1debian2=2.3.7 odbcinst=2.3.7

Workaround microsoft/linux-package-repositories#36

kndale · 2023-02-16T12:46:49Z

This issue comes up when installing pdo_sqlsrv and sqlsrv PHP extensions on Ubuntu with PHP-FPM. Reproduced on 2 machines, making an upgrade to PHP8.1 not possible.

This documentation is currently not functional then:
https://learn.microsoft.com/en-us/sql/connect/php/installation-tutorial-linux-mac?view=sql-server-ver16

osimic · 2023-02-21T12:12:15Z

This is still an issue in python:3.10-buster when installing pyodbc==4.0.28.

I tried this:
unixodbc-dev=2.3.7 unixodbc=2.3.7 odbcinst1debian2=2.3.7 odbcinst=2.3.7

with https://packages.microsoft.com/config/debian/10/prod.list (and 11) without success.

Exception is the same:
/usr/include/sqltypes.h:56:10: fatal error: unixodbc.h: No such file or directory

When I downgrade to Debian 9 everything works as expected.

osimic · 2023-02-21T12:16:59Z

This is still an issue in python:3.10-buster when installing pyodbc==4.0.28.

I tried this: unixodbc-dev=2.3.7 unixodbc=2.3.7 odbcinst1debian2=2.3.7 odbcinst=2.3.7

with https://packages.microsoft.com/config/debian/10/prod.list (and 11) without success.

Exception is the same: /usr/include/sqltypes.h:56:10: fatal error: unixodbc.h: No such file or directory

When I downgrade to Debian 9 everything works as expected.

Update: works with pyodbc==4.0.35 and --allow-downgrades unixodbc-dev=2.3.7 unixodbc=2.3.7 odbcinst1debian2=2.3.7 odbcinst=2.3.7

hughmcmaster · 2023-02-21T12:31:16Z

Why has Microsoft started providing the unixodbc packages?

Why can't we use the packages provided by Ubuntu?

osimic · 2023-02-21T13:30:43Z

This is still an issue in python:3.10-buster when installing pyodbc==4.0.28.
I tried this: unixodbc-dev=2.3.7 unixodbc=2.3.7 odbcinst1debian2=2.3.7 odbcinst=2.3.7
with https://packages.microsoft.com/config/debian/10/prod.list (and 11) without success.
Exception is the same: /usr/include/sqltypes.h:56:10: fatal error: unixodbc.h: No such file or directory
When I downgrade to Debian 9 everything works as expected.

Update: works with pyodbc==4.0.35 and --allow-downgrades unixodbc-dev=2.3.7 unixodbc=2.3.7 odbcinst1debian2=2.3.7 odbcinst=2.3.7

Update: works with pyodbc==4.0.35, Debian 10 and no downgrades

jvitorinoj · 2023-02-21T13:32:21Z

In ubuntu 20 the solution was downgraded to

unixodbc-dev=2.3.6-0.1build1 unixodbc=2.3.6-0.1build1 odbcinst1debian2=2.3.6-0.1build1 odbcinst=2.3.6-0.1build1

mbearup · 2023-02-21T23:24:19Z

Closing as the original issue (unixodbc.h) has been resolved.
For issues with libodbc1 vs libodbc2, refer to this issue.

Update package dependencies. The installers update includes several changes: - Support for Fedora v34 and Ubuntu v18 has been discontinued. - Add support for Fedora v37 and Ubuntu v22. - Migrating dependencies to PHP 8.1. There is an issue with the include in the latest version of unixodbc-dev v2.3.11. As a temporary solution, we have reverted to a previous version that does not have this problem. For more information, please refer to the related issues: - microsoft/linux-package-repositories#36 - microsoft/linux-package-repositories#39

The package already installed on the system results in build errors when trying to use it: In file included from /usr/include/sql.h:19:0, from /usr/include/sqlext.h:43, from /home/runner/work/soci/soci/include/soci/odbc/soci-odbc.h:25, from /home/runner/work/soci/soci/src/backends/odbc/factory.cpp:9: /usr/include/sqltypes.h:56:10: fatal error: unixodbc.h: No such file or directory #include "unixodbc.h" ^~~~~~~~~~~~ so remove it before installing the Debian version. See microsoft/linux-package-repositories#36

Yaroslav285 · 2023-02-23T14:32:26Z

Hello, I tried to use Ubuntu's MS repo in Debian 11 and it works.

https://packages.microsoft.com/config/ubuntu/22.04/prod.list

For Debian's repo, it generates an error

#4 46.79 grep: /usr/lib/x86_64-linux-gnu/libltdl.la: No such file or directory
#4 46.79 /bin/sed: can't read /usr/lib/x86_64-linux-gnu/libltdl.la: No such file or directory
#4 46.79 libtool: link: '/usr/lib/x86_64-linux-gnu/libltdl.la' is not a valid libtool archive
#4 46.79 make: *** [Makefile:249: sqlsrv.la] Error 1
#4 46.79 ERROR: `make' failed```

after running the command

`pecl install sqlsrv`

The package already installed on the system results in build errors when trying to use it: In file included from /usr/include/sql.h:19:0, from /usr/include/sqlext.h:43, from /home/runner/work/soci/soci/include/soci/odbc/soci-odbc.h:25, from /home/runner/work/soci/soci/src/backends/odbc/factory.cpp:9: /usr/include/sqltypes.h:56:10: fatal error: unixodbc.h: No such file or directory #include "unixodbc.h" ^~~~~~~~~~~~ so remove it before installing the Debian version. See microsoft/linux-package-repositories#36

kndale · 2023-02-23T14:38:31Z

Hello, I tried to use Ubuntu's MS repo in Debian 11 and it works.

https://packages.microsoft.com/config/ubuntu/22.04/prod.list

For Debian's repo, it generates an error

#4 46.79 grep: /usr/lib/x86_64-linux-gnu/libltdl.la: No such file or directory
#4 46.79 /bin/sed: can't read /usr/lib/x86_64-linux-gnu/libltdl.la: No such file or directory
#4 46.79 libtool: link: '/usr/lib/x86_64-linux-gnu/libltdl.la' is not a valid libtool archive
#4 46.79 make: *** [Makefile:249: sqlsrv.la] Error 1
#4 46.79 ERROR: `make' failed```

after running the command

`pecl install sqlsrv`

I am running into this error now on Ubuntu 22.04

Edit: My bad, using the MS repo it failed. Using the Ubuntu repo it suceeded.

Update package dependencies Upgrade to Laravel 9 The installers update includes several changes: - Support of Fedora v34, v35 and Ubuntu v18 has been discontinued. - Add support for Fedora v37 and Ubuntu v22. - Upgrade dependencies to PHP 8.1. There is an issue with the include in the latest version of unixodbc-dev v2.3.11. As a temporary solution, we have reverted to a previous version that does not have this problem. For more information, please refer to the related issues: - microsoft/linux-package-repositories#36 - microsoft/linux-package-repositories#39

* try fix compilation for solaris * this commit for issue #3843 and #3643 changes in Types.h allow ignore problem with declaration of std::int8_t. int8_t can be defined as char or signed char. IMHO we need strong types for Poco::Int's Envelop.cpp contains initializer for EVP_CIPHER_CTX_init, because this function prototype depends on openssl version. Application.cpp contains includes especial for SOLARIS, for ioctl support ClassLoaderTest.cpp and SharedLibraryTest.cpp contains changes because loadlibrary(dlopen) doesn't load library from current directory by default LocalDateTimeTest.cpp contains changes because SOLARIS use std::tm without tm_gmtoff * fix : define of SOLARIOS OS in LocalDateTimeTest * remove unnecessary wrapper * fix output dir for windows build with multi-config build * try to fix bug with unixodbc version in linux-builds [read here](microsoft/linux-package-repositories#36) * try to fix bug with unixodbc version in linux-builds [read here](microsoft/linux-package-repositories#36) * fix : warning in main cmake for if-condition for multi-config build fix : error for linux-gcc-make-cxx20, use --allow-downgrades for unixodbc * fix : warning for cmake windows builds revert changes for linux-gcc-make-cxx20 * revert ci.yml, remove unixodbc version * try re-run build --------- Co-authored-by: Aleksandar Fabijanic <[email protected]>

Danack added the bug Something isn't working label Feb 11, 2023

Danack mentioned this issue Feb 11, 2023

unixodbc.h header not found php/php-src#10565

Closed

Amey2400 mentioned this issue Feb 13, 2023

pyodbc 4.0.32 installation getting failed in airflow 2.4.0 base docker image apache/airflow#29509

Closed

2 tasks

romeroalx mentioned this issue Feb 13, 2023

gh actions: added manual removal/installation of odbc packages PowerDNS/pdns#12544

Merged

8 tasks

Taragolis mentioned this issue Feb 14, 2023

Use MariaDB client binaries in arm64 image for support MySQL backend apache/airflow#29519

Merged

bas524 added a commit to bas524/poco that referenced this issue Feb 15, 2023

try to fix bug with unixodbc version in linux-builds

7350f04

[read here](microsoft/linux-package-repositories#36)

bas524 added a commit to bas524/poco that referenced this issue Feb 15, 2023

try to fix bug with unixodbc version in linux-builds

87d3172

[read here](microsoft/linux-package-repositories#36)

dpgaspar mentioned this issue Feb 15, 2023

ci: fix pyodbc install failure dpgaspar/Flask-AppBuilder#1992

Merged

6 tasks

martinburchell added a commit to ucam-department-of-psychiatry/crate that referenced this issue Feb 15, 2023

Pin versions of ODBC packages in Docker build

41432f0

Workaround microsoft/linux-package-repositories#36

martinburchell added a commit to martinburchell/crate that referenced this issue Feb 15, 2023

Pin versions of ODBC packages in Docker build

58a26b0

Workaround microsoft/linux-package-repositories#36

Taragolis mentioned this issue Feb 21, 2023

Disable unixodbc and related packages from Microsoft APT repo apache/airflow#29661

Closed

mbearup closed this as completed Feb 21, 2023

dpgaspar mentioned this issue Feb 22, 2023

fix: CI broken by pyodbc vs unixodbc dpgaspar/Flask-AppBuilder#1996

Merged

6 tasks

daniilly mentioned this issue Mar 3, 2023

DP-460 Upgrade to PHP 8.1 / Laravel 9 dreamfactorysoftware/dreamfactory#470

Merged

thekevinm mentioned this issue Mar 7, 2023

DP-460 Upgrade to PHP 8.1 / Laravel 9 dreamfactorysoftware/dreamfactory#473

Merged

detule mentioned this issue Mar 19, 2023

Add NANODBC_OVERALLOCATE_CHAR flag. nanodbc/nanodbc#380

Merged

github-actions bot locked as resolved and limited conversation to collaborators Apr 2, 2024

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Package unixodbc-dev has incorrect include #36

Package unixodbc-dev has incorrect include #36

Danack commented Feb 11, 2023 •

edited

Loading

AlexLinuxGallo91 commented Feb 12, 2023

bjverde commented Feb 12, 2023 •

edited

Loading

bjverde commented Feb 12, 2023

Korred commented Feb 13, 2023

ylcdx commented Feb 13, 2023

Yaroslav285 commented Feb 13, 2023

ylcdx commented Feb 13, 2023

bogdanbradeanu commented Feb 13, 2023

dbrmr commented Feb 13, 2023

jakeblatchford commented Feb 13, 2023

ylcdx commented Feb 13, 2023 •

edited

Loading

lucasfcnunes commented Feb 13, 2023 •

edited

Loading

adiel91 commented Feb 13, 2023

cl-m-furkan commented Feb 14, 2023

yerlanamantaiuly commented Feb 14, 2023

David-Engel commented Feb 14, 2023

cdillmann commented Feb 15, 2023 •

edited

Loading

akalinux commented Feb 15, 2023 •

edited

Loading

rodrigomartinezar commented Feb 15, 2023

kndale commented Feb 16, 2023

osimic commented Feb 21, 2023

osimic commented Feb 21, 2023

hughmcmaster commented Feb 21, 2023

osimic commented Feb 21, 2023

jvitorinoj commented Feb 21, 2023

mbearup commented Feb 21, 2023

Yaroslav285 commented Feb 23, 2023

kndale commented Feb 23, 2023 •

edited

Loading

Package unixodbc-dev has incorrect include #36

Package unixodbc-dev has incorrect include #36

Comments

Danack commented Feb 11, 2023 • edited Loading

AlexLinuxGallo91 commented Feb 12, 2023

bjverde commented Feb 12, 2023 • edited Loading

bjverde commented Feb 12, 2023

Korred commented Feb 13, 2023

ylcdx commented Feb 13, 2023

Yaroslav285 commented Feb 13, 2023

ylcdx commented Feb 13, 2023

bogdanbradeanu commented Feb 13, 2023

dbrmr commented Feb 13, 2023

jakeblatchford commented Feb 13, 2023

ylcdx commented Feb 13, 2023 • edited Loading

lucasfcnunes commented Feb 13, 2023 • edited Loading

adiel91 commented Feb 13, 2023

cl-m-furkan commented Feb 14, 2023

How to check the cause

yerlanamantaiuly commented Feb 14, 2023

David-Engel commented Feb 14, 2023

cdillmann commented Feb 15, 2023 • edited Loading

akalinux commented Feb 15, 2023 • edited Loading

rodrigomartinezar commented Feb 15, 2023

kndale commented Feb 16, 2023

osimic commented Feb 21, 2023

osimic commented Feb 21, 2023

hughmcmaster commented Feb 21, 2023

osimic commented Feb 21, 2023

jvitorinoj commented Feb 21, 2023

mbearup commented Feb 21, 2023

Yaroslav285 commented Feb 23, 2023

kndale commented Feb 23, 2023 • edited Loading

Danack commented Feb 11, 2023 •

edited

Loading

bjverde commented Feb 12, 2023 •

edited

Loading

ylcdx commented Feb 13, 2023 •

edited

Loading

lucasfcnunes commented Feb 13, 2023 •

edited

Loading

cdillmann commented Feb 15, 2023 •

edited

Loading

akalinux commented Feb 15, 2023 •

edited

Loading

kndale commented Feb 23, 2023 •

edited

Loading