Venus not working with proxysql turned on

[Michal Arbet]

Hi,

We have a bug in defaults which causes venus to be not working with proxysql turned on.

TASK [venus : include_tasks] **************************************************************************************************************************************************************************************
skipping: [controller0]
skipping: [controller1]
skipping: [controller2]

TASK [venus : Creating venus database] ****************************************************************************************************************************************************************************
fatal: [controller0]: FAILED! => {"action": "mysql_db", "changed": false, "msg": "unable to find /var/lib/ansible/.my.cnf. Exception message: (1045, \"ProxySQL Error: Access denied for user 'root'@'192.168.205.10' (using password: YES)\")"}

NO MORE HOSTS LEFT ************************************************************************************************************************************************************************************************

PLAY RECAP ********************************************************************************************************************************************************************************************************
ceph0 : ok=36 changed=10 unreachable=0 failed=0 skipped=13 rescued=0 ignored=0
ceph1 : ok=36 changed=10 unreachable=0 failed=0 skipped=13 rescued=0 ignored=0
ceph2 : ok=36 changed=10 unreachable=0 failed=0 skipped=13 rescued=0 ignored=0
compute0 : ok=83 changed=21 unreachable=0 failed=0 skipped=60 rescued=0 ignored=0
compute1 : ok=85 changed=38 unreachable=0 failed=0 skipped=65 rescued=0 ignored=0
controller0 : ok=531 changed=139 unreachable=0 failed=1 skipped=280 rescued=0 ignored=0
controller1 : ok=377 changed=110 unreachable=0 failed=0 skipped=263 rescued=0 ignored=0
controller2 : ok=377 changed=110 unreachable=0 failed=0 skipped=263 rescued=0 ignored=0
localhost : ok=3 changed=0 unreachable=0 failed=0 skipped=2 rescued=0 ignored=0

[OpenStack Infra (hudson-openstack)]

Fix proposed to branch: master
Review: https://review.opendev.org/c/openstack/kolla-ansible/+/920297

[OpenStack Infra (hudson-openstack)]

Reviewed: https://review.opendev.org/c/openstack/kolla-ansible/+/920297
Committed: https://opendev.org/openstack/kolla-ansible/commit/39fa523be425c95c877458af786b9c02979ce0a4
Submitter: "Zuul (22348)"
Branch: master

commit 39fa523be425c95c877458af786b9c02979ce0a4
Author: Michal Arbet <email address hidden>
Date: Thu May 23 17:32:54 2024 +0200

    Fix venus when proxysql used

    This patch fixes defaults for venus
    so it can be used with proxysql turned on

    Closes-Bug: #2066937
    Change-Id: I0d2eb3ea6c50801a94139312399c8f8df092b4d3