Bug 170410 - MariaDB direct driver is missing
Summary: MariaDB direct driver is missing
Status: CLOSED FIXED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
26.2.0.0 alpha0+ master
Hardware: x86-64 (AMD64) Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard: target:26.8.0 target:26.2.2 target:26...
Keywords: bibisected, bisected, regression
Depends on:
Blocks: Database-Connectivity
  Show dependency treegraph
 
Reported: 2026-01-21 08:06 UTC by Robert Großkopf
Modified: 2026-03-07 11:35 UTC (History)
6 users (show)

See Also:
Crash report or crash signature:


Attachments
Tools - Options - LibreOffice Base - Connections (211.46 KB, image/png)
2026-02-06 15:49 UTC, Heiko
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Robert Großkopf 2026-01-21 08:06:10 UTC
Open 
Version: 26.2.0.1 (X86_64)
Build ID: 334ecff79a5ea28464a392deab1041cf2e705201
CPU threads: 6; OS: Linux 6.4; UI render: default; VCL: kf5 (cairo+xcb)
Locale: de-DE (de_DE.UTF-8); UI: de-DE
Calc: threaded

Start any Base file, which connects to MariaDB/MySQL in older version through direct connection.
You would get 
----
The connection to the external data source could not be established. No SDBC driver was found for the URL 'sdbc:mysql:mysqlc:192.168.178.20:3306/xrechnung'.
----
Base will connect to the URL with LO 25.8.4.2 and older without any problem. Driver isn't there for LO 26.2

You could test it without any database:
Press Base Database in main window.
Wizard for database appears.
Choose "Connect to an existing database" and → "MySQL/MariaDB"
Next: Choose "Connect directly"
Next: Database name 'test', Sever 'localhost'
Next: User name 'test', Password required. → Test connection (Password: some characters).
You will get
----
A driver is not registered for the URL sdbc:mysql:mysqlc:localhost:3306/test.
----
Driver isn't there
Comment 1 Alex Thurgood 2026-01-21 15:06:42 UTC
Works on macOS:

Version: 26.2.0.2 (AARCH64)
Build ID: 750d5fef117734aeeb00d37a069d6c814e9eb8ce
CPU threads: 8; OS: macOS 26.2; UI render: Skia/Metal; VCL: osx
Locale: fr-FR (fr_FR.UTF-8); UI: en-US
Calc: threaded


Maybe corrected in 26.2.0.2 or specific to Linux release ?
Comment 2 Robert Großkopf 2026-01-21 15:16:38 UTC
Also missing in
Version: 26.2.0.2 (X86_64)
Build ID: 750d5fef117734aeeb00d37a069d6c814e9eb8ce
CPU threads: 6; OS: Linux 6.4; UI render: default; VCL: kf5 (cairo+xcb)
Locale: de-DE (de_DE.UTF-8); UI: de-DE
Calc: threaded

Might be someone has forgotten this driver for *.rpm-packages?
Comment 3 Robert Großkopf 2026-01-21 15:40:04 UTC
Having a look at the installed files for MySQL/MariaDB: Seems there is no difference between LO 25.8.4.2 and LO 26.2.0.2. All files are there. Think the connection is lost somewhere.

Have also reset user profile: Same bug appears. Couldn't connect to MariaDB while I could connect (with the same system and same Base file) with LO 25.8.4.2 without any problem.

My system: OpenSUSE 15.6 64bit rpm Linux.
Comment 4 raal 2026-01-21 19:04:12 UTC
No repro with Version: 26.8.0.0.alpha0+ (X86_64)
Build ID: 8fb5be18f8febe88f7d0b72e4b30efd41891feb7
CPU threads: 4; OS: Linux 6.8; UI render: default; VCL: gtk3
Locale: cs-CZ (cs_CZ.UTF-8); UI: en-US
Calc: threaded

I have not MariaDB database, but when I try to connect to nonexistent server, I got error "server not found", not errors you mentioned.
Comment 5 Robert Großkopf 2026-01-21 20:15:25 UTC
(In reply to raal from comment #4)
> No repro with Version: 26.8.0.0.alpha0+ (X86_64)
> Build ID: 8fb5be18f8febe88f7d0b72e4b30efd41891feb7
> CPU threads: 4; OS: Linux 6.8; UI render: default; VCL: gtk3
> Locale: cs-CZ (cs_CZ.UTF-8); UI: en-US
> Calc: threaded
> 
> I have not MariaDB database, but when I try to connect to nonexistent
> server, I got error "server not found", not errors you mentioned.

Please test the version the bug is reported for.

I couldn't reproduce it with
Version: 26.8.0.0.alpha0+ (X86_64)
Build ID: 63e4293827a6ed112b2cda317f80938acb35849f
CPU threads: 6; OS: Linux 6.4; UI render: default; VCL: kf5 (cairo+xcb)
Locale: de-DE (de_DE.UTF-8); UI: en-US
Calc: threaded

but the bug appears here with LO 26.2.0.1 and LO 26.2.0.2
Might be it is a special bug of the rpm-packages.
Comment 6 jonson 2026-01-22 05:10:27 UTC Comment hidden (spam)
Comment 7 Robert Großkopf 2026-01-29 14:31:58 UTC
Bug still the same with
Version: 26.2.0.3 (X86_64)
Build ID: afbbd0df0edb6d40b450b0337ac646b0913a760c
CPU threads: 6; OS: Linux 6.4; UI render: default; VCL: kf5 (cairo+xcb)
Locale: de-DE (de_DE.UTF-8); UI: de-DE
Calc: threaded

Change component to "Base", because driver isn't listed in extensions.
Comment 8 Heiko 2026-02-06 15:49:56 UTC
Created attachment 205399 [details]
Tools - Options - LibreOffice Base - Connections

I can confirm this.

The driver file ./program/libmysqlclo.so is present but it is not being registered in LO (see attachment).
Comment 9 Saburo 2026-02-07 10:02:58 UTC
bibisected with linux-64-26.2
commit b1ec05b4b1928433cd8c9130b0ae78ba62269537
author	Caolán McNamara

cid#1662031 Variable copied when it could be moved

***
adding CC: Caolán McNamara
Please, take a look?
Comment 10 Caolán McNamara 2026-02-07 15:24:06 UTC
I'm not sure what could be in that bisect which would make a difference here, especially as:

@robert "I couldn't reproduce it with Version: 26.8.0.0.alpha0+ ... but the bug appears here with LO 26.2.0.1 and LO 26.2.0.2"

can you do...

$ ldd instdir/program/libmysqlclo.so|grep crypt

(or whatever path libmysqlclo in in) and we can see if there is some "libcrypt.so.2 => not found" issue that might be at play.

I wonder if it works in 26.8 and not 26.2 because of a726c634ac9cabedc1bbeb4ff655ff2f83fe8d8e (though I think that patch is flawed and essentially always drops -lcrypt from the link flags)
Comment 11 Robert Großkopf 2026-02-07 15:51:43 UTC
(In reply to Caolán McNamara from comment #10)
> I'm not sure what could be in that bisect which would make a difference
> here, especially as:
> 
> @robert "I couldn't reproduce it with Version: 26.8.0.0.alpha0+ ... but the
> bug appears here with LO 26.2.0.1 and LO 26.2.0.2"
> 
> can you do...
> 
> $ ldd instdir/program/libmysqlclo.so|grep crypt

Indeed:

LO 25.8.4.2 shows
robby@Robby:~/Programme/Lotest/LO2584/install/opt/libreoffice25.8/program> ldd libmysqlclo.so|grep crypt
        libcrypt.so.1 => /usr/lib64/libcrypt.so.1 (0x00007ff8f0d3a000)
        libk5crypto.so.3 => /usr/lib64/libk5crypto.so.3 (0x00007ff8f0c45000)
        libcrypto.so.3 => /usr/lib64/libcrypto.so.3 (0x00007ff8e7200000)
        libgcrypt.so.20 => /usr/lib64/libgcrypt.so.20 (0x00007ff8e70bc000)

LO 26.2.0.3 shows
robby@Robby:~/Programme/Lotest/LO2620/install/opt/libreoffice26.2/program> ldd libmysqlclo.so|grep crypt
        libcrypt.so.2 => not found
        libk5crypto.so.3 => /usr/lib64/libk5crypto.so.3 (0x00007f0d85fe9000)
        libcrypto.so.3 => /usr/lib64/libcrypto.so.3 (0x00007f0d82400000)
        libgcrypt.so.20 => /usr/lib64/libgcrypt.so.20 (0x00007f0d802bc000)

LO 26.8 Dev shows
robby@Robby:~/Programme/Lotest/LODev/install/opt/libreofficedev26.8/program> ldd libmysqlclo.so|grep crypt
        libk5crypto.so.3 => /usr/lib64/libk5crypto.so.3 (0x00007fc986cf5000)
        libcrypto.so.3 => /usr/lib64/libcrypto.so.3 (0x00007fc97d200000)
        libgcrypt.so.20 => /usr/lib64/libgcrypt.so.20 (0x00007fc97b0bc000)
Comment 12 Commit Notification 2026-02-07 19:16:46 UTC
Caolán McNamara committed a patch related to this issue.
It has been pushed to "master":

https://git.libreoffice.org/core/commit/a44fc53d055d414ca78e0020d125a73d4587f801

Related: tdf#170410 remove redundant CRYPT_LIBS

It will be available in 26.8.0.

The patch should be included in the daily builds available at
https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
https://wiki.documentfoundation.org/Testing_Daily_Builds

Affected users are encouraged to test the fix and report feedback.
Comment 13 Caolán McNamara 2026-02-07 19:21:19 UTC
Excellent.

So I presume that all appears to be well in 26.8 and tha this dependency on libcrypt might be spurious anyway. So...

https://gerrit.libreoffice.org/c/core/+/198888 to backport dropping -lcrypt from 26.2 too
Comment 14 Commit Notification 2026-02-09 08:35:14 UTC
Julien Nabet committed a patch related to this issue.
It has been pushed to "libreoffice-26-2":

https://git.libreoffice.org/core/commit/5f1f79b358cdb42ebcf35e05623801fcd1f81017

Resolves: tdf#170410 drop libmysqlclo dependency on libcrypt

It will be available in 26.2.2.

The patch should be included in the daily builds available at
https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
https://wiki.documentfoundation.org/Testing_Daily_Builds

Affected users are encouraged to test the fix and report feedback.
Comment 15 Commit Notification 2026-02-17 15:50:55 UTC
Julien Nabet committed a patch related to this issue.
It has been pushed to "libreoffice-26-2-1":

https://git.libreoffice.org/core/commit/99ae84cebfe4b2bbbd911515d67d9fb7eb3df2b7

Resolves: tdf#170410 drop libmysqlclo dependency on libcrypt

It will be available in 26.2.1.

The patch should be included in the daily builds available at
https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
https://wiki.documentfoundation.org/Testing_Daily_Builds

Affected users are encouraged to test the fix and report feedback.
Comment 16 Birth Certificate Check 2026-03-07 05:14:22 UTC Comment hidden (spam)