Bug 1687309 - [RFE]RHOSPin mariadb with 'Authentication Plugin - ed25519' support need.
Summary: [RFE]RHOSPin mariadb with 'Authentication Plugin - ed25519' support need.
Keywords:
Status: CLOSED CANTFIX
Alias: None
Product: Red Hat OpenStack
Classification: Red Hat
Component: mariadb
Version: 16.0 (Train)
Hardware: x86_64
OS: Linux
medium
medium
Target Milestone: ---
: ---
Assignee: Damien Ciabrini
QA Contact: pkomarov
URL:
Whiteboard:
Depends On: 1820628
Blocks:
TreeView+ depends on / blocked
 
Reported: 2019-03-11 08:58 UTC by youngcheol
Modified: 2022-04-12 14:19 UTC (History)
9 users (show)

Fixed In Version:
Doc Type: If docs needed, set a value
Doc Text:
Clone Of:
Environment:
Last Closed: 2022-04-12 14:14:52 UTC
Target Upstream Version:
Embargoed:


Attachments (Terms of Use)


Links
System ID Private Priority Status Summary Last Updated
Github PyMySQL PyMySQL issues 786 0 'None' closed add ed22519 support 2021-02-19 14:34:32 UTC
Red Hat Issue Tracker OSP-2683 0 None None None 2022-04-12 14:19:02 UTC

Description youngcheol 2019-03-11 08:58:26 UTC
Description of problem:
RHOSP13 in mariadb with 'Authentication Plugin - SHA-256' support need.

Version-Release number of selected component (if applicable):
RHOSP13
mariadb )

How reproducible:
Red Hat do not support higher version of mariadb with 'Authentication Plugin - SHA-256'.

https://mariadb.com/kb/en/library/authentication-plugin-ed25519/

Steps to Reproduce:
1.
2.
3.

Actual results:
The latest mariadb in RHOSP virsion is 'mariadb-10.1.20-2.el7ost.x86_64.rpm'.

Expected results:
Need to integrate RHOSP with MariaDB over 10.1.35 to support 'Authentication Plugin - SHA-256'.



Additional info:
Customer needs is very high about 'Authentication Plugin - SHA256' in mariadb. 

Not only this customer but also others need it too.

Because customer necessary certificate from country to do public services.

One of requirement is 'Authentication Plugin - SHA256'.

Comment 1 Michael Bayer 2019-03-12 14:03:20 UTC
hi there -

the link you refer to is the "ed25519" plugin.  Per this document, MariaDB does not support the MySQL SHA-256 plugin: https://mariadb.com/kb/en/library/authentication-plugin-sha-256/  "MariaDB Server does not currently support either of these authentication plugins."

Can you clarify which plugin is being requested?

Comment 2 youngcheol 2019-03-14 01:48:01 UTC
Hi Michael,

Thank you for your answer.

I have asked to customer and got answer. 

she said that it is needed used "ed25519" plugin with RHOSP13 to get certificate.

Thank you!

Regards,
YoungCheol.

Comment 19 Damien Ciabrini 2020-05-26 11:54:13 UTC
Quick status update for this RFE.

All OpenStack developments for enabling ed25519 in tripleo have been done upstream in ussuri. This work currently depends on two additional developments in external upstream libraries: PyNaCl for the cryptographic dependencies, and PyMySQL for authenticating with mysql with the auth_ed25519 protocol.

Currently RDO packages have rpm built with patches backported from those two upstream projects to test the feature. However until now PyNaCl and PyMySQL have not release any official release that contains those developments.

As of today, The PyNaCl development has just been published in version 1.4.0 [1].
This should unblock the review of the last development in PyMySQL [2].

[1] https://github.com/pyca/pynacl/issues/573
[2] https://github.com/PyMySQL/PyMySQL/pull/791

Comment 20 Damien Ciabrini 2020-09-22 11:37:57 UTC
(In reply to Damien Ciabrini from comment #19)

> This should unblock the review of the last development in PyMySQL [2].
> 

PyMySQL has merged the support for ed25519 as well.
All bits are available upstream for consumption. We now need to backport the necessary bits downstream in RHEL and RHOSP

Comment 21 Chris Jones 2022-04-12 14:14:52 UTC
I am closing this RFE as we will not be able to implement it in any currently scheduled release of OSP.

The reason being that we will soon be switching to RHEL9 and part of that involves a greater focus on FIPS compliance. The ed25519 implementation requires PyNaCl, which depends on libsodium and it is not possible to use libsodium in a FIPS compliant system, leaving us with no way to implement this RFE, unfortunately.


Note You need to log in before you can comment on or make changes to this bug.