Install and configure in keystone connection mysql

[fuckubuntu1]

This bug tracker is for errors with the documentation, use the following as a template and remove or add fields as you see fit. Convert [ ] into [x] to check boxes:

- [ ] This doc is inaccurate in this way: ______
- [ ] This is a doc addition request.
- [x] I have a fix to the document that I can paste below including example: input and output.

[database]
# ...
connection = mysql+pymysql://keystone:KEYSTONE_DBPASS@controller/keystone

should be :

[database]
# ...
connection = mysql+pymysql://keystone:KEYSTONE_DBPASS@localhost/keystone

because mysql daemon listens on 127.0.0.1:3306

With @controller, Identitiy service population silently fails.

Thank you.

If you have a troubleshooting or support issue, use the following resources:

 - Ask OpenStack: http://ask.openstack.org
 - The mailing list: http://lists.openstack.org
 - IRC: 'openstack' channel on Freenode

-----------------------------------
Release: 13.0.2.dev1 on 2018-09-10 23:21
SHA: 7693b84c0692f9b9ec756c73df7456d87f54f0cb
Source: https://git.openstack.org/cgit/openstack/keystone/tree/doc/source/install/keystone-install-ubuntu.rst
URL: https://docs.openstack.org/keystone/queens/install/keystone-install-ubuntu.html

[Chason Chan (chen-xing)]

Have you completed this section[1]?

[1]https://docs.openstack.org/install-guide/environment-networking-controller.html#configure-name-resolution

[fuckubuntu1 (fuckubuntu1)]

Hi, thanks for the reply.
I've just found out that my mysql server listens on localhost instead of the management interface. For some reason, my /etc/mysql/mysql.conf.d/99-openstack.cnf, which contains the "bind-address = mgmt interface ip" directive, is ignored. I'll fix that.
My bad, the actual doc is correct. With a properly configured mysql server, the "connection = mysql+pymysql://keystone:KEYSTONE_DBPASS@controller/keystone" should work.
Please close this bug, this is not an issue.

[fuckubuntu1 (fuckubuntu1)]

Confirmed: there is no issue here. With a properly configured sql server (as specified in the openstack/sql doc), keystone works as expected.
Regards.

[Gage Hugo (gagehugo)]

Closing out then.