horizon: Ensure mysqldb client is installed

[Emil Salib]

* OS : Ubuntu 22.04.03
* Kernel (e.g. `uname -a`): Linux checkout 5.15.0-86-generic #96-Ubuntu SMP Wed Sep 20 08:23:49 UTC 2023 x86_64 x86_64 x86_64 GNU/Linux
* Docker version if applicable (e.g. `docker version`): Client: Docker Engine - Community
 Version: 24.0.6
* Kolla version (e.g. `git head or tag or stable branch` or pip package version if using release): kolla-ansible --version 15.2.1

This is in regard to the following issue: Horizon bootstrap fails when murano enabled due to missing MySQL-Python

"horizon: Ensure mysqldb client is installed
Impacts ubuntu-binary based built images.

Django has no way to change the driver for MySQL backed session
management in Horizon.

Ensure that the supported MySQLDB driver is installed for use.

Change-Id: If006a75b97b336242d2d458d0a85f75a5d450635
Closes-Bug: 1840903
changes/20/867620/2"

This bug still persists in stable/zed release. I would appreciate your assistance in making the fix of kolla 14.9.0 available in stable/zed and 2023.1.

[Emil Salib (salibeh)]

An update.

I have checked the alleged fix in yoga and found out that the issue was not fixed in kolla-ansible 14.9.1.

*OS : Ubuntu 20.04.03
* Kernel (e.g. `uname -a`): Linux checkout 5.4.0-164-generic #181-Ubuntu SMP Fri Sep 1 13:41:22 UTC 2023 x86_64 x86_64 x86_64 GNU/Linux
* Docker version if applicable (e.g. `docker version`): Docker version 24.0.6, build ed223bc
* Kolla version (e.g. `git head or tag or stable branch` or pip package version if using release): kolla-ansible --version
14.9.1

Below is the debug message(s) when the kolla-ansible -i all-in-one deploy failed.

You help will be greatly appreciated

TASK [horizon : Running Horizon bootstrap container] ****
fatal: [localhost]: FAILED! => {"changed": true, "msg": "Container exited with non-zero return code 1", "rc": 1, "stderr": "+ sudo -E kolla_set_configs\nINFO:__main__:Loading config file at /var/lib/kolla/config_files/config.json\nINFO:__main__:Validating config file\nINFO:__main__:Kolla config strategy set to: COPY_ALWAYS\nINFO:__main__:Copying service configuration files\nINFO:__main__:Copying /var/lib/kolla/config_files/horizon.conf to /etc/apache2/conf-enabled/000-default.conf\nINFO:__main__:Setting permission for /etc/apache2/conf-enabled/000-default.conf\nINFO:__main__:Deleting /etc/openstack-dashboard/local_settings\nINFO:__main__:Copying /var/lib/kolla/config_files/local_settings to /etc/openstack-dashboard/local_settings\nINFO:__main__:Setting permission for /etc/openstack-dashboard/local_settings\nINFO:__main__:Copying /var/lib/kolla/config_files/custom_local_settings to /etc/openstack-dashboard/custom_local_settings\nINFO:__main__:Setting permission for /etc/openstack-dashboard/custom_local_settings\nINFO:__main__:Writing out command to execute\n++ cat /run_command\n+ CMD='/usr/sbin/apache2 -DFOREGROUND'\n+ ARGS=\n+ sudo kolla_copy_cacerts\n+ [[ ! -n '' ]]\n+ . kolla_extend_start\n++ set -o errexit\n++ FORCE_GENERATE=no\n++ HASH_PATH=/var/lib/kolla/.settings.md5sum.txt\n++ [[ source == \\b\\i\\n\\a\\r\\y ]]\n++ [[ source == \\s\\o\\u\\r\\c\\e ]]\n++ SITE_PACKAGES=/var/lib/kolla/venv/lib/python3.8/site-packages\n++ [[ -f /var/lib/kolla/venv/bin/python ]]\n++ MANAGE_PY='/var/lib/kolla/venv/bin/python /var/lib/kolla/venv/bin/manage.py'\n++ [[ source == \\s\\o\\u\\r\\c\\e ]]\n++ [[ ! -f /var/lib/kolla/venv/lib/python3.8/site-packages/openstack_dashboard/local/local_settings.py ]]\n++ ln -s /etc/openstack-dashboard/local_settings /var/lib/kolla/venv/lib/python3.8/site-packages/openstack_dashboard/local/local_settings.py\n++ [[ -f /etc/openstack-dashboard/custom_local_settings ]]\n++ CUSTOM_SETTINGS_FILE=/var/lib/kolla/venv/lib/python3.8/site-packages/openstack_dashboard/local/custom_local_settings.py\n++ [[ source == \\b\\i\\n\\a\\r\\y ]]\n++ [[ ! -L /var/lib/kolla/venv/lib/python3.8/site-packages/openstack_dashboard/local/custom_local_settings.py ]]\n++ ln -s /etc/openstack-dashboard/custom_local_settings /var/lib/kolla/venv/lib/python3.8/site-packages/openstack_dashboard/local/custom_local_settings.py\n++ [[ -n 0 ]]\n++ /var/lib/kolla/venv/bin/python /var/lib/kolla/venv/bin/manage.py migrate --noinput\n/var/lib/kolla/venv/lib/python3.8/site-packages/openstack_dashboa...

[Michal Nasiadka (mnasiadka)]

The related patch was merged in Yoga for binary images, if you have the same problem in Zed/Yoga source images - please deliver more logs (docker logs horizon output)

[Emil Salib (salibeh)]

Attached is the docker logs horizon output for zed environment.

[Emil Salib (salibeh)]

This has been resolved by recreating the horizon docker image with appending the 'python3-mysqldb' package.