direct connection no more working in LibreOffice new release

Problems with the Linux version of XAMPP, questions, comments, and anything related.

direct connection no more working in LibreOffice new release

Postby doctorsubtilis » 11. September 2020 15:54

After upgrading KDE Neon to 20.04 I noticed that LibreBase (either 64 or 7) cannot directly connecting with mysql, as it used in the past.
I reported it as a bug here: https://bugs.documentfoundation.org/show_bug.cgi?id=134982 and here: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1892635.
this the error message:
Code: Select all
SQL Status: HY000
    Error code: 2003
    Can't connect to MySQL server on 'localhost' (111) /build/libreoffice-ron9it/libreoffice-7.0.0~rc3/connectivity/source/drivers/mysqlc/mysqlc_general.cxx:119

Someone there said that it could be solved modifying my.cnf and setting tcp instaead of socket as mysql, but I don't know if it will work and how to do it.
Consider that in browsers mysql works perfectly with php, no problem.
Thank
doctorsubtilis
 
Posts: 3
Joined: 11. September 2020 15:44
XAMPP version: 7.4.9.0
Operating System: Linux - KDE Neon 20.04

Re: direct connection no more working in LibreOffice new rel

Postby doctorsubtilis » 14. September 2020 15:57

This is the answer of the developer of LO (https://bugs.documentfoundation.org/show_bug.cgi?id=134982#c24):
I am closing this report as NOTOURBUG.

Both Sylvain and Duns need to learn to configure their mariadb/mysql server with the relevant authentication plugin for each user and assign them a corresponding password, and then try and connect from LO with a supported password authentication mechanism before filing a report here.


Therefore what should I do?
doctorsubtilis
 
Posts: 3
Joined: 11. September 2020 15:44
XAMPP version: 7.4.9.0
Operating System: Linux - KDE Neon 20.04

Re: direct connection no more working in LibreOffice new rel

Postby Nobbie » 14. September 2020 15:59

Sorry, but this is not a LibreOffice Forum. I have no clue which authorization plugin is required by LibreOffice. Here is an article about known plugins: https://mariadb.com/kb/en/authentication-plugins/
Nobbie
 
Posts: 11673
Joined: 09. March 2008 13:04

Re: direct connection no more working in LibreOffice new rel

Postby doctorsubtilis » 14. September 2020 16:23

Ok, thanks, I will see.
doctorsubtilis
 
Posts: 3
Joined: 11. September 2020 15:44
XAMPP version: 7.4.9.0
Operating System: Linux - KDE Neon 20.04


Return to XAMPP for Linux

Who is online

Users browsing this forum: No registered users and 8 guests