[Libreoffice-bugs] [Bug 135202] LO 6.4.6.1 and 7.0.1 fail with error 1045 when accessing MySQL database using native connector

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #37 from Alex Thurgood <iplaw67 at tuta.io> ---
(In reply to Dan Lewis from comment #36)

> 
> MySQL(Native) is the connection that I use. I have no idea what you are
> asking. Are you referring to the older version of sending the password
> (standard authorization)? If so, I created another user using standard
> authorization. When connecting to the MySQL database, I got the same error
> message.

@Dan :

(1) Julien's patch only relates to the Windows version of LibreOffice, so if
you are using a Linux version, which I believe you are, then the patch will
have solved nothing for you.

(2) Julien's question to you does indeed refer to the old standard mysql
authentication method. However, simply creating a new mysql user and
configuring that user account to use the old authentication method won't
necessarily work with a mysql server that is configured to use the new
authentication method by default. This will very much depend on how you have
configured your mysql/mariadb server.

The SHA caching plugin problem in general is linked to the lack of
implementation for SHA authentication in the libmariadb connector (and possibly
also the libariadbclient code, although I haven't check the MariaDB bug
repository), which LibreOffice uses to connect to a mysql instance using the
native connector.

There is additionally, what appears to be path error in recent builds of
LibreOffice on all platforms, which attempts to load the SHA caching plugin
from a location that does not exist on most users machines. Whether this path
error stems from the LibreOffice build platform, or whether it is a fallback
search path that is activated due to the lack of SHA caching support in the
libmariadb client/connector code is, to me at least, unclear.

SHA2 caching support (or rather, the lack thereof) per se is bug 122560.

-- 
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/20201011/a84ba6a7/attachment.htm>