Re: [libreoffice-users] Failure to connect LOBase client to Mariadb host server

On 10/05/2026 09:40, Harvey Nimmo wrote:
> On Sun, 2026-05-10 at 09:12 +1200, Steve Edmonds wrote
> > Hi Harvey. What version of openSUSE are you running, what is your
> > output
> > from  ~> cat /proc/cpuinfo
> >
> > I have Leap 16 which installed Libreoffice 25.2.5.2 from the SUSE
> > repository.
> > Steve
> Hi Steve,
>
> I am running OpenSUSE Tumbleweed on 2x Intel(R) Pentium(R) D CPU
> 2.80GHz.
>
> ~> cat /proc/cpuinfo
> processor       : 0
> vendor_id       : GenuineIntel
> cpu family      : 15
> model           : 4
> model name      : Intel(R) Pentium(R) D CPU 2.80GHz
> stepping        : 7
> microcode       : 0x3
> cpu MHz         : 2793.076
> cache size      : 1024 KB
> physical id     : 0
> siblings        : 2
> core id         : 0
> cpu cores       : 2
> apicid          : 0
> initial apicid  : 0
> fpu             : yes
> fpu_exception   : yes
> cpuid level     : 5
> wp              : yes
> flags           : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge
> mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm pbe
> syscall nx lm constant_tsc pebs bts rep_good nopl cpuid pni dtes64
> monitor ds_cpl cid cx16 xtpr lahf_lm pti
> bugs            : cpu_meltdown spectre_v1 spectre_v2 spec_store_bypass
> l1tf mds swapgs itlb_multihit spectre_v2_user old_microcode
> bogomips        : 5586.15
> clflush size    : 64
> cache_alignment : 128
> address sizes   : 36 bits physical, 48 bits virtual
> power management:
>
> processor       : 1
> vendor_id       : GenuineIntel
> cpu family      : 15
> model           : 4
> model name      : Intel(R) Pentium(R) D CPU 2.80GHz
> stepping        : 7
> microcode       : 0x3
> cpu MHz         : 2793.076
> cache size      : 1024 KB
> physical id     : 0
> siblings        : 2
> core id         : 1
> cpu cores       : 2
> apicid          : 1
> initial apicid  : 1
> fpu             : yes
> fpu_exception   : yes
> cpuid level     : 5
> wp              : yes
> flags           : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge
> mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm pbe
> syscall nx lm constant_tsc pebs bts rep_good nopl cpuid pni dtes64
> monitor ds_cpl cid cx16 xtpr lahf_lm pti
> bugs            : cpu_meltdown spectre_v1 spectre_v2 spec_store_bypass
> l1tf mds swapgs itlb_multihit spectre_v2_user old_microcode
> bogomips        : 5586.15
> clflush size    : 64
> cache_alignment : 128
> address sizes   : 36 bits physical, 48 bits virtual
> power management:
>
>
> Cheers
> harvey
I don't think I can help much. /lib64/ld-linux-x86-64.so.2 --help showed 
nothing on a couple of machines I have but cat /proc/cpuinfo shows they 
are at least V2 from the below.

ISA Level,   Key Required Flags to Look For
v1    Basic x86-64 instructions (default for all 64-bit CPUs)
v2    popcnt, sse4_1, sse4_2, ssse3
v3    avx, avx2, bmi1, bmi2, f16c, fma, movbe
v4    avx512f, avx512bw, avx512cd, avx512dq, avx512vl

I would have thought that if Tumbleweed was built with support for V1 
processors then Libreoffice connectors for Tumbleweed would have been also.
Is your MariaDB set up for SSL/TLS connections to bypass the "TLS/SSL 
error: SSL is required..." error.

From a google I got;
To connect LibreOffice Base to a MySQL database without using SSL (TLS), 
you can use the *Direct Connect* method or specific connection 
parameters in the *JDBC* string.
Option 1: Use the "Connect Directly" Method
The simplest way to bypass complex SSL/TLS configurations is to use the 
native LibreOffice MySQL driver.

1. *Install the driver*: On Linux (Ubuntu/Mint), ensure the driver is
   installed via terminal:
   |sudo apt install libreoffice-sdbc-mysql|.
2. *Open LibreOffice Base*: Select *Connect to an existing database*
   and choose *MySQL* from the dropdown menu.
3. *Choose Connection Type*: On the next screen, select *Connect directly*.
4. *Enter Server Details*: Provide the server address, port (default is
   3306), and database name.
5. *Test Connection*: Enter your username and password. This method
   typically defaults to a standard connection without requiring SSL
   certificates.

I also see discussions below which might provide some light;
https://forums.linuxmint.com/viewtopic.php?t=416269
https://forums.opensuse.org/t/tsl-ssl-connection-to-mariadb-from-libreoffice-base/186388/12

Steve
--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy