[Libreoffice-bugs] [Bug 134982] Base - cannot connect via native mysql connector to XAMMP mysql/mariadb instance installed on Ubuntu 18.04

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=134982

--- Comment #17 from Alex Thurgood <iplaw67 at tuta.io> ---
(In reply to Duns from comment #16)
> To sum up I think that fixing this issue should be made by LibreOffice
> developers: either go back to the previous relase of mysql-connector or
> (better) developing a new release *working*. A not working app is useless,
> isn't it?

You are assuming that the issue is a LibreOffice one, and not an issue caused
by packaging and/or library version decisions made by Ubuntu...

Having just gone through the native connector setup dialog again on macOS this
morning and yesterday on Linux Ubuntu 20.04, when you set up the database, you
get to indicate the path of the of the socket.

If the entry you type here isn't registered for some reason, that would be a
bug in that dialog, or the parsing of information by LO which handled by that
dialog.


The alternative suggestion to use TCP connectivity instead of Unix socket,
relies on you knowing how to activate TCP connections in your mysql server
instance, by modifying the relevant configuration file. That information can be
found all over the internet, and has absolutely nothing to do with LibreOffice.
By default these days, current versions of mysql server provided on Linux
platforms do not allow TCP access via Class C IP addresses. Again, this is
nothing to do with LibreOffice, but decisions made by the packager and provider
of the mysql server.

Telling the LibreOffice project that they have to fix a bug which is as yet
undetermined to be within the LO project's remit, is a bit like saying "I can't
fly to the moon, it's your fault, fix it for me."

For all we know, this might indeed be a LO problem, then again, it might not. I
have yet to see any information from any of the posters complaining about the
problem, that they have attempted to at least try and solve it by themselves,
and report back here what exactly they have done.

For starters, one might try installing standard Linux distribution provided
mysql server packages rather than some weird separate bundle that someone
thought might conveniently go in /opt ? Where did you get that XAMPP bundle
from ? How is the server configured in that bundle ? How can you get it to
accept TCP connections over IP ? All of these questions are the responsibility
of the person who chooses to install that particular bundle, and have
zero/zilch/nada to do with LO. Once you know the answer to these questions, how
the XAMPP bundle is supposed to function, the attempts you have tried to
resolve the problem, and still come up with a failure of LO to connect, then we
can start trying to see where there might be an issue with LO.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200904/7a49363e/attachment.htm>