Re: unixodbc-bin is not available - what to do?
On Sat, Jun 21, 2025 at 05:58:30PM +0100, Chris Green wrote:
> Greg Wooledge <greg@wooledge.org> wrote:
> > On Sat, Jun 21, 2025 at 15:37:38 +0100, Chris Green wrote:
> > > I'm trying to install the libraries and drivers required to use a
> > > sqlite3 database with libreoffice writer. However when I try to
> > > install the required packages I get an error:-
> > >
> > > root@t470# apt install unixodbc-dev unixodbc-bin unixodbc
> >
> > Why did you type that command?
>
> Beacause that's what several of the places (admittedly old) that tell
> you what you need to do say that these packages are needed.
`apt show libreoffice` says unixodbc
is the package for ODBC database support.
For what it is worth: sqlite3 and ODBC are not the same.
> > > Reading package lists... Done
> > > Building dependency tree... Done
> > > Reading state information... Done
> > > Package unixodbc-bin is not available, but is referred to by another
> > > package.
> > > This may mean that the package is missing, has been obsoleted, or
> > > is only available from another source
> > >
> > > E: Package 'unixodbc-bin' has no installation candidate
> > > root@t470#
> > >
> > > So what do I need to do to get this working? Ignoring the error and
> > > continuing fails.
> > >
> > > What I suspect I need is an up to date guide on how to get sqlite3
> > > working with libreoffice base but I can't find one. All the guides I
> > > can find are many years out of date and I suspect that may be the
> > > reason I'm getting the above error.
> >
> > Oh, you're blindly following some ancient third-party "guide". Well,
> > maybe the packages were merged or something. Does it work if you
> > simply omit the -bin package?
> >
> No, it doesn't work if I just carry on without unixodbc-bin.
Please elaborate. For https://xyproblem.info reasons.
Groeten
Geert Stappers
$ apt show libreoffice
Package: libreoffice
Version: 4:25.2.3-2
Priority: optional
Section: metapackages
Maintainer: Debian LibreOffice Maintainers <debian-openoffice@lists.debian.org>
Installed-Size: 74.8 kB
Depends: libreoffice-base, libreoffice-calc, libreoffice-core (=
4:25.2.3-2), libreoffice-draw, libreoffice-impress, libreoffice-math,
libreoffice-report-builder-bin, libreoffice-writer, python3-uno
Recommends: fonts-crosextra-caladea, fonts-crosextra-carlito,
fonts-dejavu, fonts-linuxlibertine, fonts-noto-core, fonts-noto-extra,
fonts-noto-mono, fonts-noto-ui-core, fonts-sil-gentium-basic,
libreoffice-nlpsolver, libreoffice-report-builder,
libreoffice-script-provider-bsh, libreoffice-script-provider-js,
libreoffice-script-provider-python, libreoffice-sdbc-mysql,
libreoffice-sdbc-postgresql, libreoffice-wiki-publisher,
libreoffice-java-common (>= 4:25.2.3~), fonts-liberation (>= 1:2),
fonts-liberation-sans-narrow
Suggests: cups-bsd, firefox-esr | thunderbird | firefox, ghostscript,
gnupg, gpa, hunspell-dictionary, hyphen-hyphenation-patterns,
imagemagick | graphicsmagick-imagemagick-compat, libgl1,
libreoffice-gnome | libreoffice-plasma, libreoffice-grammarcheck,
libreoffice-help (= 25.2), libreoffice-l10n (= 25.2),
libreoffice-librelogo, libxrender1, myspell-dictionary,
mythes-thesaurus, openclipart-libreoffice, pstoedit,
unixodbc, gstreamer1.0-plugins-base, gstreamer1.0-plugins-good,
gstreamer1.0-plugins-ugly, gstreamer1.0-plugins-bad, gstreamer1.0-libav,
default-jre (>= 2:1.8) | java-runtime (>= 8) | java8-runtime | jre,
libsane1, libofficebean-java
Conflicts: libreoffice-dev (<= 1:5.0.3~rc1-2), libreoffice-dev-doc (<= 1:5.0.3~rc1-2)
Homepage: http://www.libreoffice.org
Tag: role::metapackage
Download-Size: 48.7 kB
APT-Sources: http://deb.debian.org/debian unstable/main amd64 Packages
Description: office productivity suite (metapackage)
LibreOffice is a full-featured office productivity suite that provides
a near drop-in replacement for Microsoft(R) Office.
.
This metapackage installs all components of libreoffice:
* libreoffice-writer: Word processor
* libreoffice-calc: Spreadsheet
* libreoffice-impress: Presentation
* libreoffice-draw: Drawing
* libreoffice-base: Database
* libreoffice-math: Equation editor
It also recommends additional packages (e.g. fonts) in order to match an
upstream LibreOffice install as closely as possible.
.
You can extend the functionality of LibreOffice by installing these
packages:
* hunspell-*/myspell-*: Hunspell/Myspell dictionaries
for use with LibreOffice
* libreoffice-l10n-*: UI interface translation
* libreoffice-help-*: User help
* mythes-*: Thesauri for the use with LibreOffice
* hyphen-*: Hyphenation patterns for LibreOffice
* libreoffice-gtk(2|3): Gtk UI Plugin, GNOME File Picker support
* libreoffice-gnome: GIO backend
* unixodbc: ODBC database support
* cups-bsd: Allows LibreOffice to detect your CUPS printer queues
automatically
* libsane: Use your sane-supported scanner with LibreOffice
* libxrender1: Speed up display by using Xrender library
* libgl1: OpenGL support
* openclipart-libreoffice: Open Clip Art Gallery with LibreOffice index
files
* firefox-esr | thunderbird | firefox:
Mozilla profile with Certificates needed for XML Security...
* openjdk-11-jre | openjdk-8-jre | java8-runtime:
Java Runtime Environment for use with LibreOffice
* pstoedit / imagemagick / ghostscript: helper tools for EPS
* gstreamer0.10-plugins-*: GStreamer plugins for use with LibreOffices
media backend
* libpaper-utils: papersize detection support via paperconf
* bluez: Bluetooth support for Impress (slideshow remote control)
$
--
Silence is hard to parse
Reply to: