On Sat, Jun 21, 2025 at 05:58:30PM +0100, Chris Green wrote: > Greg Wooledge <[email protected]> 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 <[email protected]> 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
