MySQL Router Charm

Error when upgrading MySQL router charm if mysql-router pkg is upgraded from prior to 8.0.23

Bug #1959861 reported by Seyeong Kim
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
MySQL Router Charm
Fix Committed
Undecided
Seyeong Kim

Bug Description

mysql router prior to 8.0.23 doesn't support tls, so it doesn't have proper configuration for tls
e.g client_ssl_cert, client_ssl_mode

If mysql-router is upgraded from 8.0.19 to latest, it still doesn't have TLS conf in mysql-router configuration file.
So far so good.

But, if we upgrade mysql-router charm, it puts client_ssl_mode (only) to configuration file.

Then error pops up.[1] as no client_ssl_cert conf and files in proper directory.

[1] https://pastebin.canonical.com/p/WDSQTrgxfz/

See original description
Seyeong Kim (seyeongkim)
description: updated
OpenStack Infra (hudson-openstack)
Changed in charm-mysql-router:
status: New → In Progress
Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Change abandoned on charm-mysql-router (master)

Change abandoned by "Seyeong Kim <email address hidden>" on branch: master
Review: https://review.opendev.org/c/openstack/charm-mysql-router/+/827592
Reason: I need to put some condition check

Seyeong Kim (seyeongkim)
Changed in charm-mysql-router:
assignee: nobody → Seyeong Kim (seyeongkim)
Revision history for this message
Edward Hope-Morley (hopem) wrote :

Patch https://review.opendev.org/c/openstack/charm-mysql-router/+/827592 is no longer abandoned fwiw.

Revision history for this message
Alan Baghumian (alanbach) wrote :

Hello! Any progress updates on this?

This is affecting clients who are running <= 8.0.23. Thank you!

Revision history for this message
Seyeong Kim (seyeongkim) wrote :

@Alan

Hey, The review process is in progress nowadays. https://review.opendev.org/c/openstack/charm-mysql-router/+/827592

Canonical CI has some high load issue so, it takes time.

Thanks.

Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix merged to charm-mysql-router (master)

Reviewed: https://review.opendev.org/c/openstack/charm-mysql-router/+/827592
Committed: https://opendev.org/openstack/charm-mysql-router/commit/e3fcc5c96c4c635e2dc1147323fcd416785d26ba
Submitter: "Zuul (22348)"
Branch: master

commit e3fcc5c96c4c635e2dc1147323fcd416785d26ba
Author: Seyeong Kim <email address hidden>
Date: Thu Feb 3 15:06:30 2022 +0900

    Check mysql-router pkg version and adjust ssl option

    Only affect mysql-router >= 8.0.23
    If there is no client_ssl_cert, remove client_ssl_mode anyway.

    Change-Id: I24fdfe0b4de6c5681e4576ca6840a882da1682e3
    Closes-Bug: #1959861

Changed in charm-mysql-router:
status: In Progress → Fix Committed
Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix proposed to charm-mysql-router (stable/jammy)

Fix proposed to branch: stable/jammy
Review: https://review.opendev.org/c/openstack/charm-mysql-router/+/851760

Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix merged to charm-mysql-router (stable/jammy)

Reviewed: https://review.opendev.org/c/openstack/charm-mysql-router/+/851760
Committed: https://opendev.org/openstack/charm-mysql-router/commit/4cccd1ccc80989795c7f12a46d32db775785ec09
Submitter: "Zuul (22348)"
Branch: stable/jammy

commit 4cccd1ccc80989795c7f12a46d32db775785ec09
Author: Seyeong Kim <email address hidden>
Date: Thu Feb 3 15:06:30 2022 +0900

    Check mysql-router pkg version and adjust ssl option

    Only affect mysql-router >= 8.0.23
    If there is no client_ssl_cert, remove client_ssl_mode anyway.

    Change-Id: I24fdfe0b4de6c5681e4576ca6840a882da1682e3
    Closes-Bug: #1959861
    (cherry picked from commit e3fcc5c96c4c635e2dc1147323fcd416785d26ba)

tags: added: in-stable-jammy
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.
Subscribing...

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.