PyMySQL is not installed on utility container when using distro method

[Flavio Picci]

Hello everyone,

when installing OpenStack using the `distro` method, python3 package `PyMySQL` is not installed in the "utility" container. Thus, the `Create database for service` target in `os_keystone/tasks/db_setup.yml` playbook fails complaining that the above package is missing.

The workaround I used is to manually install `PyMySQL` package on the utility container:
`lxc-attach $(lxc-ls -1 | grep _utility_) -- /usr/libexec/platform-python -m pip install PyMySQL`

Environment: test infrastructure with single node
OS: CentOS 8
OpenStack Ansible: stable/victoria

Thanks,
Flavio

[Dmitriy Rabotyagov (noonedeadpunk)]

Hi,

This bug has been introduced with https://review.opendev.org/c/openstack/openstack-ansible/+/742100/6/inventory/group_vars/utility_all.yml

Fix has been pushed with https://review.opendev.org/c/openstack/openstack-ansible/+/784957

[OpenStack Infra (hudson-openstack)]

Fix proposed to branch: stable/victoria
Review: https://review.opendev.org/c/openstack/openstack-ansible/+/786107

[OpenStack Infra (hudson-openstack)]

Reviewed: https://review.opendev.org/c/openstack/openstack-ansible/+/786107
Committed: https://opendev.org/openstack/openstack-ansible/commit/f9eb0af8acacc1b48503fbd0bbeb1149cc31fd11
Submitter: "Zuul (22348)"
Branch: stable/victoria

commit f9eb0af8acacc1b48503fbd0bbeb1149cc31fd11
Author: Dmitriy Rabotyagov <email address hidden>
Date: Tue Apr 6 16:38:53 2021 +0300

    Return PyMySQL installation for distro installs

    Due to error, PyMySQL installation for distro based installs was removed
    with [1]

    We return this behaviour back and fixing LXC distro deployments.

    [1] https://review.opendev.org/c/openstack/openstack-ansible/+/742100

    Change-Id: Ic03e6271695bbfd5e7166994a44af46cc0134bbd
    Closes-Bug: #1922701
    (cherry picked from commit b42ab487a8c0ac1798c5fc9cc7fd78615d1a6ad5)

[OpenStack Infra (hudson-openstack)]

This issue was fixed in the openstack/openstack-ansible 22.1.2 release.

[OpenStack Infra (hudson-openstack)]

This issue was fixed in the openstack/openstack-ansible 23.0.0.0b1 development milestone.