Openstack-Ansible setup-openstack.yml playbook fails at task Create DB for service
I get the error message:
fatal: [blade1_keystone_container-baa016ad -> 172.29.237.64]: FAILED! => {"changed": false, "failed": true, "msg": "unable to connect to database, check login_user and login_password are correct or /root/.my.cnf has the credentials. Exception message: (2013, 'Lost connection to MySQL server at \\'reading initial communication packet\\', system error: 0 \"Internal error/check (Not system error)\"')"}
Running the verify command as specified here(https://docs.openstack.org/project-deploy-guide/openstack-ansible/latest/run-playbooks.html) gives the following output
ansible galera_container -m shell -a "mysql -h localhost -e 'show status like \"wsrep_cluster_%\";'" Variable files: "-e @/etc/openstack_deploy/user_secrets.yml -e @/etc/openstack_deploy/user_variables.yml " blade1_galera_container-fe12a1f5 | SUCCESS | rc=0 >> Variable_name Value wsrep_cluster_conf_id 1 wsrep_cluster_size 1 wsrep_cluster_state_uuid 242be378-584f-11e8-9b9b-1f10339d89ee wsrep_cluster_status Primary
Does anyone know what may be causing this issue/how to resolve it