Openstack-Ansible setup-openstack.yml playbook fails at task Create DB for service

asked 2018-05-30 12:41:58 -0500

Valance23322 gravatar image

I get the error message:

fatal: [blade1_keystone_container-baa016ad ->]: 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( 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

edit retag flag offensive close merge delete

1 answer

Sort by ยป oldest newest most voted

answered 2018-05-31 06:54:40 -0500

Your deployment host is in the same network than the lxc containers? if not you will need to create an static route from the containers to the deployment hosts.

Another possible situation is your HAproxy configuration, try to execute basic SQL commans using the external/internal IPs to see if everything is working properly. You can also use 'nc' to verify the port.

edit flag offensive delete link more


I know this is a bit old, but I'm having the same problem. I am not using HAProxy though, should I be? and if its optional what would the solution be, since all my nodes are on the same network.

James Grow gravatar imageJames Grow ( 2018-09-05 08:45:16 -0500 )edit

I am seeing the same problem.

alvinstarr gravatar imagealvinstarr ( 2019-02-27 18:28:42 -0500 )edit

Get to know Ask OpenStack

Resources for moderators

Question Tools

1 follower


Asked: 2018-05-30 12:41:58 -0500

Seen: 723 times

Last updated: May 30 '18