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