Ubuntu
unixodbc package

odbcinst1debian2 has PreDepends multiarch-support, but focal no longer supports 32-bit

Asked by Larry Reid

I'm trying to install libodbc1 and odbcinst1debian2 on Ubuntu Server 20.04, but they won't install because they have predepends on multiarch-support. Is this an error in the package, or do those packages not work on 64-bit LInux?

Question information

Language:
English Edit question
Status:
Solved
For:
Ubuntu unixodbc Edit question
Assignee:
No assignee Edit question
Solved by:
Larry Reid
Solved:
Last query:
Last reply:
Revision history for this message
actionparsnip (andrew-woodhead666) said : 		#1

Try:

sudo dpkg --add-architecture i386

I'd say it should all be 64bit though. Does the above command make it work OK?

Revision history for this message
Manfred Hampl (m-hampl) said : 		#2

I do not see such dependency on my system

For diagnostic purposes please provide the output of the commands

uname -a
lsb_release -crid
apt-cache policy odbcinst odbcinst1debian2 libodbcinst1
apt-cache depends odbcinst odbcinst1debian2 libodbcinst1

Revision history for this message
Larry Reid (lcreid) said : 		#3

Thanks for the answers and ideas!

I tried my install from a bare install of Focal, and it worked. So I expect there's something about the Microsoft repository for MS SQL Server that's changing the dependencies. (The Microsoft repository is not yet supported on Focal, so I can't blame them.)

I will pursue this further. Thanks again for your help!

@actionparsnip
Adding the architecture didn't make a difference.

@m-hampl:

```
ubuntu@mssql:~$ uname -a
Linux mssql 5.4.0-28-generic #32-Ubuntu SMP Wed Apr 22 17:40:10 UTC 2020 x86_64 x86_64 x86_64 GNU/Linux
ubuntu@mssql:~$ lsb_release -crid
Distributor ID: Ubuntu
Description: Ubuntu 20.04 LTS
Release: 20.04
Codename: focal
ubuntu@mssql:~$ apt-cache policy odbcinst odbcinst1debian2 libodbcinst1
odbcinst:
  Installed: (none)
  Candidate: 2.3.7
  Version table:
     2.3.7 500
        500 https://packages.microsoft.com/ubuntu/18.04/prod bionic/main amd64 Packages
     2.3.6-0.1build1 500
        500 http://archive.ubuntu.com/ubuntu focal/main amd64 Packages
odbcinst1debian2:
  Installed: (none)
  Candidate: 2.3.7
  Version table:
     2.3.7 500
        500 https://packages.microsoft.com/ubuntu/18.04/prod bionic/main amd64 Packages
     2.3.6-0.1build1 500
        500 http://archive.ubuntu.com/ubuntu focal/main amd64 Packages
N: Unable to locate package libodbcinst1
ubuntu@mssql:~$ apt-cache depends odbcinst odbcinst1debian2 libodbcinst1
odbcinst
  Depends: libc6
  Depends: odbcinst1debian2
  Conflicts: <odbcinst1>
  Replaces: <odbcinst1>
  Replaces: <odbcinst1debian1>
  Replaces: unixodbc
odbcinst1debian2
  PreDepends: <multiarch-support>
  Depends: libc6
  Depends: libltdl7
  Depends: odbcinst
  Conflicts: <odbcinst1>
  Conflicts: <odbcinst1debian1>
  Breaks: libiodbc2
  Breaks: <libmyodbc>
  Breaks: odbc-postgresql
  Breaks: tdsodbc
  Replaces: unixodbc
```

Revision history for this message
Manfred Hampl (m-hampl) said : 		#4

I fully agree with your judgement. The Microsoft repository is causing that problem, because it apparently does not have packages for focal, and the packages for bionic have dependencies that cannot be met on focal.

(Sorry for the typo in my commands, it should have been ... libodbc1 instead of libodbcinst1, but that does not change anything, and drawing the conclusion was possible also with the wrong ones.)