[Libreoffice-bugs] [Bug 122560] New: 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

            Bug ID: 122560
           Summary: Mysql Native Connector - failure to connect to mysql 8
                    server instance with SHA2 caching
           Product: LibreOffice
           Version: 6.1.4.2 release
          Hardware: x86-64 (AMD64)
                OS: Mac OS X (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Base
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: iplaw67 at tuta.io

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.

Actual Results:
No ODB file can be created, the wizard doesn't finish.

Expected Results:
The connection should proceed and allow the user to register the ODB file.


Reproducible: Always


User Profile Reset: Yes



Additional Info:

-- 
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/10e91d2d/attachment.html>