openstack的搭建中 执行同步数据库的命令后 出现下面问题 是哪里配错了？

Question

2020-10-30 10:36:11.544 3211 CRITICAL keystone [-] DBConnectionError: (pymysql.err.OperationalError) (2003, "Can't connect to MySQL server on 'controller' ([Errno -2] Name or service not known)")
2020-10-30 10:36:11.544 3211 ERROR keystone Traceback (most recent call last):
2020-10-30 10:36:11.544 3211 ERROR keystone File "/usr/bin/keystone-manage", line 10, in
2020-10-30 10:36:11.544 3211 ERROR keystone sys.exit(main())
2020-10-30 10:36:11.544 3211 ERROR keystone File "/usr/lib/python2.7/dist-packages/keystone/cmd/manage.py", line 45, in main
2020-10-30 10:36:11.544 3211 ERROR keystone cli.main(argv=sys.argv, config_files=config_files)
2020-10-30 10:36:11.544 3211 ERROR keystone File "/usr/lib/python2.7/dist-packages/keystone/cmd/cli.py", line 1312, in main
2020-10-30 10:36:11.544 3211 ERROR keystone CONF.command.cmd_class.main()
2020-10-30 10:36:11.544 3211 ERROR keystone File "/usr/lib/python2.7/dist-packages/keystone/cmd/cli.py", line 380, in main
2020-10-30 10:36:11.544 3211 ERROR keystone klass.do_bootstrap()
2020-10-30 10:36:11.544 3211 ERROR keystone File "/usr/lib/python2.7/dist-packages/keystone/cmd/cli.py", line 190, in do_bootstrap
2020-10-30 10:36:11.544 3211 ERROR keystone domain=default_domain)
2020-10-30 10:36:11.544 3211 ERROR keystone File "/usr/lib/python2.7/dist-packages/keystone/common/manager.py", line 123, in wrapped
2020-10-30 10:36:11.544 3211 ERROR keystone ret_val = __f(*args, **kwargs)
2020-10-30 10:36:11.544 3211 ERROR keystone File "/usr/lib/python2.7/dist-packages/keystone/resource/core.py", line 713, in create_domain
2020-10-30 10:36:11.544 3211 ERROR keystone domain_id, project_from_domain, initiator)
2020-10-30 10:36:11.544 3211 ERROR keystone File "/usr/lib/python2.7/dist-packages/keystone/common/manager.py", line 123, in wrapped
2020-10-30 10:36:11.544 3211 ERROR keystone __ret_val = __f(*args, **kwargs)
2020-10-30 10:36:11.544 3211 ERROR keystone File "/usr/lib/python2.7/dist-packages/keystone/resource/core.py", line 203, in create_project
2020-10-30 10:36:11.544 3211 ERROR keystone ret = self.driver.create_project(project_id, project)
2020-10-30 10:36:11.544 3211 ERROR keystone File "/usr/lib/python2.7/dist-packages/keystone/common/sql/core.py", line 436, in wrapper
2020-10-30 10:36:11.544 3211 ERROR keystone return method(*args, **kwargs)
2020-10-30 10:36:11.544 3211 ERROR keystone File "/usr/lib/python2.7/dist-packages/keystone/resource/backends/sql.py", line 177, in create_project
2020-10-30 10:36:11.544 3211 ERROR keystone with sql.session_for_write() as session:
2020-10-30 10:36:11.544 3211 ERROR keystone File "/usr/lib/python2.7/contextlib.py", line 17, in __enter
2020-10-30 10:36:11.544 3211 ERROR keystone return self.gen.next()
2020-10-30 10:36:11.544 3211 ERROR keystone File "/usr/lib/python2.7/dist-packages/oslo_db/sqlalchemy/enginefacade.py", line 944, in transaction_scope
2020-10-30 10:36:11.544 3211 ERROR keystone allow_async=self._allow_async) as resource:
2020-10-30 10:36:11.544 3211 ERROR keystone File "/usr/lib/python2.7/contextlib.py", line 17, in __enter_
2020-10-30 10:36:11.544 3211 ERROR keystone return self.gen.next()
2020-10-30 10:36:11.544 3211 ERROR keystone File "/usr/lib/python2.7/dist-packages/oslo_db/sqlalchemy/enginefacade.py", line 558, in _session
2020-10-30 10:36:11.544 3211 ERROR keystone bind=self.connection, mode=self.mode)
2020-10-30 10:36:11.544 3211 ERROR keystone File "/usr/lib/python2.7/dist-packages/oslo_db/sqlalchemy/enginefacade.py", line 317, in _create_session
2020-10-30 10:36:11.544 3211 ERROR keystone self._start()
2020-10-30 10:36:11.544 3211 ERROR keystone File "/usr/lib/python2.7/dist-packages/oslo_db/sqlalchemy/enginefacade.py", line 403, in _start
2020-10-30 10:36:11.544 3211 ERROR keystone engine_args, maker_args)
2020-10-30 10:36:11.544 3211 ERROR keystone File "/usr/lib/python2.7/dist-packages/oslo_db/sqlalchemy/enginefacade.py", line 427, in _setup_for_connection
2020-10-30 10:36:11.544 3211 ERROR keystone sql_connection=sql_connection, **engine_kwargs)
2020-10-30 10:36:11.544 3211 ERROR keystone File "/usr/lib/python2.7/dist-packages/oslo_db/sqlalchemy/engines.py", line 155, in create_engine
2020-10-30 10:36:11.544 3211 ERROR keystone test_conn = _test_connection(engine, max_retries, retry_interval)
2020-10-30 10:36:11.544 3211 ERROR keystone File "/usr/lib/python2.7/dist-packages/oslo_db/sqlalchemy/engines.py", line 339, in _test_connection
2020-10-30 10:36:11.544 3211 ERROR keystone six.reraise(type(de_ref), de_ref)
2020-10-30 10:36:11.544 3211 ERROR keystone File "", line 2, in reraise
2020-10-30 10:36:11.544 3211 ERROR keystone DBConnectionError: (pymysql.err.OperationalError) (2003, "Can't connect to MySQL server on 'controller' ([Errno -2] Name or service not known)")
2020-10-30 10:36:11.544 3211 ERROR keystone

Answer 1

不知道你这个问题是否已经解决, 如果还没有解决的话:

• 看下这篇博客，也许你就懂了，链接：使用openstack中遇到的报错和使用笔记

如果你已经解决了该问题, 非常希望你能够分享一下解决方案, 写成博客, 将相关链接放在评论区, 以帮助更多的人 ^-^