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

[Seyeong Kim]

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/

[OpenStack Infra (hudson-openstack)]

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

[Edward Hope-Morley (hopem)]

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

[Alan Baghumian (alanbach)]

Hello! Any progress updates on this?

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

[Seyeong Kim (seyeongkim)]

@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.

[OpenStack Infra (hudson-openstack)]

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

[OpenStack Infra (hudson-openstack)]

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

[OpenStack Infra (hudson-openstack)]

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)