[Bug 2084531] [NEW] Can't open cursor lib '/etc/libodbccr.so' : file not found

garblixa 2084531 at bugs.launchpad.net
Tue Oct 15 10:18:55 UTC 2024


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<<
##################

unixodbc or libodbc2 may be searching for libodbccr.so in the wrong
place. Perhaps it should be searching for libodbccr.so.2.0.0.

Setting the following symbolic link fixes the problem:
ln -s /usr/lib/x86_64-linux-gnu/libodbccr.so.2.0.0 /usr/lib/x86_64-linux-gnu/libodbccr.so


ProblemType: Bug
ApportVersion: 2.20.11-0ubuntu82.6
Architecture: amd64
CasperMD5CheckResult: pass
Date: Tue Oct 15 12:09:03 2024
Dependencies:
 gcc-12-base 12.3.0-1ubuntu1~22.04
 libc6 2.35-0ubuntu3.8
 libcrypt1 1:4.4.27-1
 libgcc-s1 12.3.0-1ubuntu1~22.04
 libidn2-0 2.3.2-2build1
 libltdl7 2.4.6-15build2
 libunistring2 1.0-1
DistroRelease: Ubuntu 22.04
InstallationDate: Installed on 2023-02-28 (595 days ago)
InstallationMedia: Ubuntu-Server 22.04.2 LTS "Jammy Jellyfish" - Release amd64 (20230217.1)
NonfreeKernelModules: bmhook tmhook
Package: libodbc2:amd64 2.3.9-5ubuntu0.1
PackageArchitecture: amd64
ProcCpuinfoMinimal:
 processor      : 1
 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    : 2
 siblings       : 1
 core id                : 0
 cpu cores      : 1
 apicid         : 2
 initial apicid : 2
 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)
 LANG=de_DE.UTF-8
 SHELL=/bin/bash
ProcVersionSignature: Ubuntu 5.15.0-122.132-generic 5.15.163
SourcePackage: unixodbc
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
Foundations Bugs, which is subscribed to unixodbc in Ubuntu.
https://bugs.launchpad.net/bugs/2084531

Title:
  Can't open cursor lib '/etc/libodbccr.so' : file not found

Status in unixodbc package in Ubuntu:
  New

Bug description:
  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<<
  ##################

  unixodbc or libodbc2 may be searching for libodbccr.so in the wrong
  place. Perhaps it should be searching for libodbccr.so.2.0.0.

  Setting the following symbolic link fixes the problem:
  ln -s /usr/lib/x86_64-linux-gnu/libodbccr.so.2.0.0 /usr/lib/x86_64-linux-gnu/libodbccr.so

  
  ProblemType: Bug
  ApportVersion: 2.20.11-0ubuntu82.6
  Architecture: amd64
  CasperMD5CheckResult: pass
  Date: Tue Oct 15 12:09:03 2024
  Dependencies:
   gcc-12-base 12.3.0-1ubuntu1~22.04
   libc6 2.35-0ubuntu3.8
   libcrypt1 1:4.4.27-1
   libgcc-s1 12.3.0-1ubuntu1~22.04
   libidn2-0 2.3.2-2build1
   libltdl7 2.4.6-15build2
   libunistring2 1.0-1
  DistroRelease: Ubuntu 22.04
  InstallationDate: Installed on 2023-02-28 (595 days ago)
  InstallationMedia: Ubuntu-Server 22.04.2 LTS "Jammy Jellyfish" - Release amd64 (20230217.1)
  NonfreeKernelModules: bmhook tmhook
  Package: libodbc2:amd64 2.3.9-5ubuntu0.1
  PackageArchitecture: amd64
  ProcCpuinfoMinimal:
   processor      : 1
   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    : 2
   siblings       : 1
   core id                : 0
   cpu cores      : 1
   apicid         : 2
   initial apicid : 2
   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)
   LANG=de_DE.UTF-8
   SHELL=/bin/bash
  ProcVersionSignature: Ubuntu 5.15.0-122.132-generic 5.15.163
  SourcePackage: unixodbc
  Tags:  jammy
  Uname: Linux 5.15.0-122-generic x86_64
  UpgradeStatus: No upgrade log present (probably fresh install)
  _MarkForUpload: True

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




More information about the foundations-bugs mailing list