Creating haproxy mysql failed

[caoyuan]

TASK [mariadb : Creating haproxy mysql user] ***********************************
FAILED - RETRYING: TASK: mariadb : Creating haproxy mysql user (10 retries left).
FAILED - RETRYING: TASK: mariadb : Creating haproxy mysql user (9 retries left).
FAILED - RETRYING: TASK: mariadb : Creating haproxy mysql user (8 retries left).
FAILED - RETRYING: TASK: mariadb : Creating haproxy mysql user (7 retries left).
FAILED - RETRYING: TASK: mariadb : Creating haproxy mysql user (6 retries left).
FAILED - RETRYING: TASK: mariadb : Creating haproxy mysql user (5 retries left).
FAILED - RETRYING: TASK: mariadb : Creating haproxy mysql user (4 retries left).
FAILED - RETRYING: TASK: mariadb : Creating haproxy mysql user (3 retries left).
FAILED - RETRYING: TASK: mariadb : Creating haproxy mysql user (2 retries left).
FAILED - RETRYING: TASK: mariadb : Creating haproxy mysql user (1 retries left).
fatal: [localhost]: FAILED! => {"changed": false, "cmd": ["docker", "exec", "-t", "kolla_toolbox", "/usr/bin/ansible", "localhost", "-m", "mysql_user", "-a", "login_host='172.16.130.120' login_port='3306' login_user='root' login_password='POyz3VRm9qk5VC91o7NbETLlfQiSAI2WlFgRdTGb' name='haproxy' password='' host='%' priv=*.*:USAGE"], "delta": "0:00:00.952583", "end": "2017-02-05 22:57:07.728533", "failed": true, "rc": 1, "start": "2017-02-05 22:57:06.775950", "stderr": "", "stdout": "localhost | FAILED! => {\r\n \"changed\": false, \r\n \"failed\": true, \r\n \"msg\": \"unable to connect to database, check login_user and login_password are correct or /home/ansible/.my.cnf has the credentials. Exception message: (1045, \\\"Access denied for user 'root'@'dnf' (using password: YES)\\\")\"\r\n}", "stdout_lines": ["localhost | FAILED! => {", " \"changed\": false, ", " \"failed\": true, ", " \"msg\": \"unable to connect to database, check login_user and login_password are correct or /home/ansible/.my.cnf has the credentials. Exception message: (1045, \\\"Access denied for user 'root'@'dnf' (using password: YES)\\\")\"", "}"], "warnings": []}

NO MORE HOSTS LEFT *************************************************************
 to retry, use: --limit @/usr/share/kolla/ansible/site.retry

PLAY RECAP *********************************************************************
localhost : ok=64 changed=0 unreachable=0 failed=1

[OpenStack Infra (hudson-openstack)]

Fix proposed to branch: master
Review: https://review.openstack.org/429390

[Jeffrey Zhang (jeffrey4l)]

seems like your mariadb is not created successfully. could u make sure of that?

[OpenStack Infra (hudson-openstack)]

Change abandoned by caoyuan ([e-mail]) on branch: master
Review: https://review.openstack.org/429390

[t.goto (t.goto)]

I had exactly same issue, but after building image and refreshing configs(globals, passwords, kolla-build.conf), it worked.

[Taeha Kim (kthguru)]

This issue has occurred on master branch. When the deployment VM deploys to other VM using all-in-one, it has been occurred as following logs.
In the mariadb container, we can use mysql console without password. For example,
# mysql
# mysql -u root
# mysql -u haproxy
These are all okay.

But the deployment VM cannot connectto the mariadb container's mysql.
I don't understand why this issue cannot be reproduced on your side.

TASK [mariadb : include] *********************************************************************************************************************************************************************
skipping: [192.168.122.112]

TASK [mariadb : include] *********************************************************************************************************************************************************************
skipping: [192.168.122.112]

TASK [mariadb : include] *********************************************************************************************************************************************************************
included: /usr/share/kolla-ansible/ansible/roles/mariadb/tasks/start.yml for 192.168.122.112

TASK [mariadb : Starting mariadb container] **************************************************************************************************************************************************
ok: [192.168.122.112]

TASK [mariadb : Waiting for MariaDB service to be ready] *************************************************************************************************************************************
ok: [192.168.122.112]

TASK [mariadb : include] *********************************************************************************************************************************************************************
included: /usr/share/kolla-ansible/ansible/roles/mariadb/tasks/register.yml for 192.168.122.112

TASK [mariadb : Creating haproxy mysql user] *************************************************************************************************************************************************
fatal: [192.168.122.112]: FAILED! => {"changed": false, "failed": true, "msg": "unable to connect to database, check login_user and login_password are correct or /var/lib/ansible/.my.cnf has the credentials. Exception message: (1045, \"Access denied for user 'root'@'nova2' (using password: YES)\")"}

NO MORE HOSTS LEFT ***************************************************************************************************************************************************************************
 to retry, use: --limit @/usr/share/kolla-ansible/ansible/site.retry

PLAY RECAP ***********************************************************************************************************************************************************************************
192.168.122.112 : ok=52 changed=0 unreachable=0 failed=1

[OpenStack Infra (hudson-openstack)]

Fix proposed to branch: master
Review: https://review.openstack.org/484717

[Taeha Kim (kthguru)]

We do not need login password for mariadb. So removed mariadb password for register.yml.
After that, the progress is ok.

TASK [mariadb : Cleaning up facts] ***********************************************************************************************************************************************************
ok: [192.168.122.112]

TASK [mariadb : include] *********************************************************************************************************************************************************************
included: /usr/share/kolla-ansible/ansible/roles/mariadb/tasks/start.yml for 192.168.122.112

TASK [mariadb : Starting mariadb container] **************************************************************************************************************************************************
ok: [192.168.122.112]

TASK [mariadb : Waiting for MariaDB service to be ready] *************************************************************************************************************************************
ok: [192.168.122.112]

TASK [mariadb : include] *********************************************************************************************************************************************************************
included: /usr/share/kolla-ansible/ansible/roles/mariadb/tasks/register.yml for 192.168.122.112

TASK [mariadb : Creating haproxy mysql user] *************************************************************************************************************************************************
ok: [192.168.122.112]

TASK [mariadb : Cleaning up facts] ***********************************************************************************************************************************************************
ok: [192.168.122.112]

TASK [mariadb : include] *********************************************************************************************************************************************************************
included: /usr/share/kolla-ansible/ansible/roles/mariadb/tasks/check.yml for 192.168.122.112

[OpenStack Infra (hudson-openstack)]

Change abandoned by Taeha Kim (<email address hidden>) on branch: master
Review: https://review.openstack.org/484717
Reason: useless patch