[Libreoffice-bugs] [Bug 122560] Mysql Native Connector - failure to connect to mysql 8 server instance with SHA2 caching

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #3 from Alex Thurgood <iplaw67 at tuta.io> ---
(In reply to Alex Thurgood from comment #0)
> Description:
> The latest release of mysql community server implements SHA2 caching for
> passwordk encryption when connecting to the server.
> 
> This is not supported by the libmysqlconnector.
> 
> Attempting to create an ODB file connecting directly to a 8.0 mysql server
> using SHA2 caching leads to the error :
> 
> Statut SQL: HY000
> Code d'erreur: 2058
> 
> Plugin caching_sha2_password could not be loaded:
> 
> The ODB file can not be created.
> 
> 
> Steps to Reproduce:
> 1. Try to create an ODB file connecting directly to a 8.0 mysql server
> instance that uses SHA2 caching for password management (default setting on
> 8.x servers) 
> 
> 2. Enter IP address, user name and click on password required box in the
> relevant dialogs using the wizard.
> 
> 3. Click on Test connection. Enter the user password.
> 
> 4) Error message : Statut SQL: HY000
> Code d'erreur: 2058
> 
> Plugin caching_sha2_password could not be loaded:
> 
> 5) No ODB file can be created.
> 

Actually, point 5 above is incorrect, the file can be createdby ignoring the
test, clicking on Next and saving the ODB file, but no connection to the server
will ever be established to read the databases/tables when that ODB file is
reloaded into 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/20190108/08ba5c2d/attachment.html>