sql connection failed. 10 attempts left

asked 2016-07-05 14:10:23 -0500

kaleem gravatar image

I'm running openstack liberty on Ubuntu 14.04 trying to install keystone using this guide. http://docs.openstack.org/liberty/install-guide-ubuntu/keystone-install.html (http://docs.openstack.org/liberty/ins...)

When I type /bin/sh -c "keystone-manage db_sync" keystone from root I get SQL connection failed. 10 attempts left, 9 attempts left, 8 attempts left, etc.

output of netstat -anut|grep 35357 is: "mycontrollerip":35357 CLOSE_WAIT 7297/python "mycontrollerip":35357 CLOSE_WAIT 6291/python "mycontrollerip":35357 CLOSE_WAIT 6360/python "mycontrollerip":35357 CLOSE_WAIT 6316/python "mycontrollerip":35357 CLOSE_WAIT 6380/python "mycontrollerip":35357 CLOSE_WAIT 5915/python "mycontrollerip":35357 CLOSE_WAIT 6331/python

edit retag flag offensive close merge delete

1 answer

Sort by ยป oldest newest most voted
2

answered 2016-07-05 22:07:24 -0500

james-denton gravatar image

I would check the following:

  • MySQL is running on port 3306
  • You are able to connect to MySQL using the mysql client
  • The connection URL is properly configured:

The example in the install guide assumes you have a /etc/hosts file entry for 'controller' to the IP of the host, preferably the management IP and not 127.0.0.1:

connection = mysql+pymysql://keystone:KEYSTONE_DBPASS@controller/keystone

  • Check the password. Replace the KEYSTONE_DBPASS in the connection string with the SQL keystone user password set while following the guide
edit flag offensive delete link more

Get to know Ask OpenStack

Resources for moderators

Question Tools

1 follower

Stats

Asked: 2016-07-05 14:10:23 -0500

Seen: 6,634 times

Last updated: Jul 05 '16