keystone permission denied database

asked 2018-04-18 14:20:57 -0600

justlikeef gravatar image

Trying to get OpenStack installed on Centos7, and I am following the installation instructions for Keystone located here:

https://docs.openstack.org/keystone/queens/install/keystone-install-rdo.html (https://docs.openstack.org/keystone/q...)

All of the commands seem to complete successfully and the database is created. Once I have done all of the exports at the bottom of the page and go to the next page:

https://docs.openstack.org/keystone/queens/install/keystone-users-rdo.html (https://docs.openstack.org/keystone/q...)

all of the commands fail. In the keystone.log, I get:

2018-04-18 15:00:59.292 2637 INFO keystone.common.wsgi [req-4450fa82-e7fd-4bbc-9cb3-9f938c5ad64c - - - - -] POST http://osctrl001.local.domain:35357/v3/auth/tokens (http://osctrl001.local.domain:35357/v...) 2018-04-18 15:00:59.311 2637 WARNING oslo_db.sqlalchemy.engines [req-4450fa82-e7fd-4bbc-9cb3-9f938c5ad64c - - - - -] SQL connection failed. 10 attempts left.: DBConnectionError: (pymysql.err.OperationalError) (2003, "Can't connect to MySQL server on 'osctrl001.local.domain' ([Errno 13] Permission denied)") (Background on this error at: http://sqlalche.me/e/e3q8)

/etc/keystone/keystone.conf has the following entry:

connection = mysql+pymysql://keystone:password@osctrl001.local.domain/keystone

I can connect and read the database using the mysql command line and copying and pasting the username and password from the connection string, and it works.

edit retag flag offensive close merge delete