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

[Sergio Durigan Junior]

Thanks for taking the time to file a bug report and improve Ubuntu.

The /usr/lib/x86_64-linux-gnu/libodbccr.so is actually part of the
unixodbc-dev package, so you don't need to create it by hand.

It's not clear from the description whether the code you're referring to
comes from a package or if it's part of a third-party project.  If it's
the latter, then it's the user's responsibility to install the necessary
dependencies for the project to run.  If it's the former, then this is
probably a bug in the package as it should correctly depend on unixodbc-
dev out of the box.

Could you clarify this, please?  Meanwhile, I will mark this bug as
Incomplete.  Please feel free to revert its status back to New once you
have provided the requested information.

Thanks.

** Changed in: unixodbc (Ubuntu)
       Status: New => Incomplete

-- 
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:
  Incomplete

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