Public bug reported:

unixodbc is used with freetds to connect to mssql databases with PHP.

The following PHP connect string is used:
odbc_connect(DSN, USER, PASSWORD, SQL_CUR_USE_ODBC);

SQL_CUR_USE_ODBC is used to speed up database access. The following
error occurs:

##################
PHP Warning: odbc_connect(): SQL error: [unixODBC][Driver Manager]Can't open 
cursor lib ‘/etc/libodbccr.so’ : file not found, SQL state 01000 in SQLConnect
Error: >>[unixODBC][Driver Manager]Can't open cursor lib ‘/etc/libodbccr.so’ : 
file not found<<
##################

When you install unixodbc-dev, a symbolic link /usr/lib/x86_64-linux-
gnu/libodbccr.so -> libodbccr.so.2.0.0 is installed by the package,
which fixes the problem.

So I think that php8.1-odbc should have a dependency on unixodbc-dev.

##################################

ProblemType: Bug
ApportVersion: 2.20.11-0ubuntu82.6
Architecture: amd64
CasperMD5CheckResult: unknown
Date: Tue Oct 29 09:40:54 2024
Dependencies:
 adduser 3.118ubuntu5
 apt 2.4.13
 apt-utils 2.4.13
 ca-certificates 20240203~22.04.1
 coreutils 8.32-4.1ubuntu1.2
 debconf 1.5.79ubuntu1
 debconf-i18n 1.5.79ubuntu1
 dpkg 1.21.1ubuntu2.3
 gcc-12-base 12.3.0-1ubuntu1~22.04
 gpgv 2.2.27-3ubuntu2.1
 libacl1 2.3.1-1
 libapt-pkg6.0 2.4.13
 libattr1 1:2.5.1-1build1
 libaudit-common 1:3.0.7-1build1
 libaudit1 1:3.0.7-1build1
 libbz2-1.0 1.0.8-5build1
 libc6 2.35-0ubuntu3.8
 libcap-ng0 0.7.9-2.2build3
 libcap2 1:2.44-1ubuntu0.22.04.1
 libcom-err2 1.46.5-2ubuntu1.2
 libcrypt1 1:4.4.27-1
 libdb5.3 5.3.28+dfsg1-0.8ubuntu3
 libffi8 3.4.2-4
 libgcc-s1 12.3.0-1ubuntu1~22.04
 libgcrypt20 1.9.4-3ubuntu3
 libgmp10 2:6.2.1+dfsg-3ubuntu1
 libgnutls30 3.7.3-4ubuntu1.5
 libgpg-error0 1.43-3
 libgssapi-krb5-2 1.19.2-2ubuntu0.4
 libhogweed6 3.7.3-1build2
 libidn2-0 2.3.2-2build1
 libk5crypto3 1.19.2-2ubuntu0.4
 libkeyutils1 1.6.1-2ubuntu3
 libkrb5-3 1.19.2-2ubuntu0.4
 libkrb5support0 1.19.2-2ubuntu0.4
 liblocale-gettext-perl 1.07-4build3
 libltdl7 2.4.6-15build2
 liblz4-1 1.9.3-2build2
 liblzma5 5.2.5-2ubuntu1
 libnettle8 3.7.3-1build2
 libnsl2 1.3.0-2build2
 libodbc2 2.3.9-5ubuntu0.1
 libp11-kit0 0.24.0-6build1
 libpam-modules 1.4.0-11ubuntu2.4
 libpam-modules-bin 1.4.0-11ubuntu2.4
 libpam0g 1.4.0-11ubuntu2.4
 libpcre2-8-0 10.39-3ubuntu0.1
 libseccomp2 2.5.3-2ubuntu2
 libselinux1 3.3-1build2
 libsemanage-common 3.3-1build2
 libsemanage2 3.3-1build2
 libsepol2 3.3-1build1
 libssl3 3.0.2-0ubuntu1.18
 libstdc++6 12.3.0-1ubuntu1~22.04
 libsystemd0 249.11-0ubuntu3.12
 libtasn1-6 4.18.0-4build1
 libtext-charwidth-perl 0.04-10build3
 libtext-iconv-perl 1.7-7build3
 libtext-wrapi18n-perl 0.06-9
 libtinfo6 6.3-2ubuntu0.1
 libtirpc-common 1.3.2-2ubuntu0.1
 libtirpc3 1.3.2-2ubuntu0.1
 libudev1 249.11-0ubuntu3.12
 libunistring2 1.0-1
 libxxhash0 0.8.1-1
 libzstd1 1.4.8+dfsg-3build1
 openssl 3.0.2-0ubuntu1.18
 passwd 1:4.8.1-2ubuntu2.2
 perl-base 5.34.0-3ubuntu1.3
 php-common 2:92ubuntu1
 php8.1-common 8.1.2-1ubuntu2.19
 psmisc 23.4-2build3
 sensible-utils 0.0.17
 tar 1.34+dfsg-1ubuntu0.1.22.04.2
 ubuntu-keyring 2021.03.26
 ucf 3.0043
 zlib1g 1:1.2.11.dfsg-2ubuntu9.2
DistroRelease: Ubuntu 22.04
NonfreeKernelModules: bmhook tmhook
Package: php8.1-odbc 8.1.2-1ubuntu2.19
PackageArchitecture: amd64
ProcCpuinfoMinimal:
 processor      : 3
 vendor_id      : GenuineIntel
 cpu family     : 6
 model          : 63
 model name     : Intel(R) Xeon(R) Gold 6354 CPU @ 3.00GHz
 stepping       : 0
 microcode      : 0xd0003b9
 cpu MHz                : 2992.968
 cache size     : 39936 KB
 physical id    : 6
 siblings       : 1
 core id                : 0
 cpu cores      : 1
 apicid         : 6
 initial apicid : 6
 fpu            : yes
 fpu_exception  : yes
 cpuid level    : 13
 wp             : yes
 flags          : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov 
pat pse36 clflush mmx fxsr sse sse2 ss syscall nx pdpe1gb rdtscp lm 
constant_tsc arch_perfmon nopl xtopology tsc_reliable nonstop_tsc cpuid 
tsc_known_freq pni pclmulqdq ssse3 fma cx16 pcid sse4_1 sse4_2 x2apic movbe 
popcnt tsc_deadline_timer aes xsave avx f16c rdrand hypervisor lahf_lm abm 
invpcid_single pti ssbd ibrs ibpb stibp fsgsbase tsc_adjust bmi1 avx2 smep bmi2 
invpcid xsaveopt arat md_clear flush_l1d arch_capabilities
 bugs           : cpu_meltdown spectre_v1 spectre_v2 spec_store_bypass l1tf mds 
swapgs itlb_multihit mmio_stale_data retbleed bhi
 bogomips       : 5985.93
 clflush size   : 64
 cache_alignment        : 64
 address sizes  : 43 bits physical, 48 bits virtual
 power management:
ProcEnviron:
 LANGUAGE=
 TERM=linux
 PATH=(custom, no user)
 XDG_RUNTIME_DIR=<set>
 LANG=de_DE.UTF-8
 SHELL=/bin/bash
ProcVersionSignature: Ubuntu 5.15.0-122.132-generic 5.15.163
SourcePackage: php8.1
Tags:  jammy
Uname: Linux 5.15.0-122-generic x86_64
UpgradeStatus: No upgrade log present (probably fresh install)
_MarkForUpload: True

** Affects: unixodbc (Ubuntu)
     Importance: Undecided
         Status: New

-- 
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/2085815

Title:
  php8.1-odbc missing dependency to unixodbc-dev

To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/unixodbc/+bug/2085815/+subscriptions


-- 
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs

Reply via email to