<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>Bug ID</th>
<td><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - Mysql Native Connector - failure to connect to mysql 8 server instance with SHA2 caching"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=122560">122560</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>Mysql Native Connector - failure to connect to mysql 8 server instance with SHA2 caching
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>6.1.4.2 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>x86-64 (AMD64)
</td>
</tr>
<tr>
<th>OS</th>
<td>Mac OS X (All)
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<th>Severity</th>
<td>normal
</td>
</tr>
<tr>
<th>Priority</th>
<td>medium
</td>
</tr>
<tr>
<th>Component</th>
<td>Base
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>iplaw67@tuta.io
</td>
</tr></table>
<p>
<div>
<pre>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:</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>