Open Stack

Dear All!

Would you please help to find out why below error messages is happened when
i installed keystone?

when i ran the "su -s /bin/sh -c "keystone-manage db_sync" keystone"
command, it can't connected to DATABASE correctly.

Kevin

root at OpenStack-Controller:~# hostname
OpenStack-Controller
root at OpenStack-Controller:~#
root at OpenStack-Controller:~# cat /etc/hosts
127.0.0.1       localhost
192.168.56.101  OpenStack-Controller
192.168.56.102  OpenStack-Compute01
192.168.56.103  OpenStack-Compute02
192.168.56.104  OpenStack-Storage

# The following lines are desirable for IPv6 capable hosts
::1     localhost ip6-localhost ip6-loopback
ff02::1 ip6-allnodes
ff02::2 ip6-allrouters
root at OpenStack-Controller:~#
root at OpenStack-Controller:~#
root at OpenStack-Controller:~# ping OpenStack-Controller
PING OpenStack-Controller (192.168.56.101) 56(84) bytes of data.
64 bytes from OpenStack-Controller (192.168.56.101): icmp_seq=1 ttl=64
time=0.052 ms
64 bytes from OpenStack-Controller (192.168.56.101): icmp_seq=2 ttl=64
time=0.050 ms
64 bytes from OpenStack-Controller (192.168.56.101): icmp_seq=3 ttl=64
time=0.052 ms
^C
--- OpenStack-Controller ping statistics ---
3 packets transmitted, 3 received, 0% packet loss, time 2006ms
rtt min/avg/max/mdev = 0.050/0.051/0.052/0.006 ms
root at OpenStack-Controller:~#



root at OpenStack-Controller:~# cat /etc/keystone/keystone.conf
[DEFAULT]
log_dir = /var/log/keystone
[application_credential]
[assignment]
[auth]
[cache]
[catalog]
[cors]
[credential]
[database]
connection = mysql+pymysql://keystone:password@OpenStack-Controller/keystone
[domain_config]
[endpoint_filter]
[endpoint_policy]
[eventlet_server]
[extra_headers]
[federation]
[fernet_tokens]
[healthcheck]
[identity]
[identity_mapping]
[ldap]
[matchmaker_redis]
[memcache]
[oauth1]
[oslo_messaging_amqp]
[oslo_messaging_kafka]
[oslo_messaging_notifications]
[oslo_messaging_rabbit]
[oslo_messaging_zmq]
[oslo_middleware]
[oslo_policy]
[paste_deploy]
[policy]
[profiler]
[resource]
[revoke]
[role]
[saml]
[security_compliance]
[shadow_users]
[signing]
[token]
provider = fernet
[tokenless_auth]
[trust]
[unified_limit]

root at OpenStack-Controller:~#


root at OpenStack-Controller:~# cat /var/log/keystone/keystone-manage.log
2018-06-30 16:44:24.543 5917 WARNING oslo_db.sqlalchemy.engines [-] SQL
connection failed. 10 attempts left.: DBConnectionError:
(pymysql.err.OperationalError) (2003, "Can't connect to MySQL server on
'OpenStack-Controller' ([Errno 111] Connection refused)")
2018-06-30 16:44:34.555 5917 WARNING oslo_db.sqlalchemy.engines [-] SQL
connection failed. 9 attempts left.: DBConnectionError:
(pymysql.err.OperationalError) (2003, "Can't connect to MySQL server on
'OpenStack-Controller' ([Errno 111] Connection refused)")
2018-06-30 16:44:44.558 5917 WARNING oslo_db.sqlalchemy.engines [-] SQL
connection failed. 8 attempts left.: DBConnectionError:
(pymysql.err.OperationalError) (2003, "Can't connect to MySQL server on
'OpenStack-Controller' ([Errno 111] Connection refused)")
2018-06-30 16:44:54.571 5917 WARNING oslo_db.sqlalchemy.engines [-] SQL
connection failed. 7 attempts left.: DBConnectionError:
(pymysql.err.OperationalError) (2003, "Can't connect to MySQL server on
'OpenStack-Controller' ([Errno 111] Connection refused)")
2018-06-30 16:45:04.577 5917 WARNING oslo_db.sqlalchemy.engines [-] SQL
connection failed. 6 attempts left.: DBConnectionError:
(pymysql.err.OperationalError) (2003, "Can't connect to MySQL server on
'OpenStack-Controller' ([Errno 111] Connection refused)")
2018-06-30 16:45:14.584 5917 WARNING oslo_db.sqlalchemy.engines [-] SQL
connection failed. 5 attempts left.: DBConnectionError:
(pymysql.err.OperationalError) (2003, "Can't connect to MySQL server on
'OpenStack-Controller' ([Errno 111] Connection refused)")
2018-06-30 16:45:24.596 5917 WARNING oslo_db.sqlalchemy.engines [-] SQL
connection failed. 4 attempts left.: DBConnectionError:
(pymysql.err.OperationalError) (2003, "Can't connect to MySQL server on
'OpenStack-Controller' ([Errno 111] Connection refused)")
2018-06-30 16:45:34.609 5917 WARNING oslo_db.sqlalchemy.engines [-] SQL
connection failed. 3 attempts left.: DBConnectionError:
(pymysql.err.OperationalError) (2003, "Can't connect to MySQL server on
'OpenStack-Controller' ([Errno 111] Connection refused)")
2018-06-30 16:45:44.621 5917 WARNING oslo_db.sqlalchemy.engines [-] SQL
connection failed. 2 attempts left.: DBConnectionError:
(pymysql.err.OperationalError) (2003, "Can't connect to MySQL server on
'OpenStack-Controller' ([Errno 111] Connection refused)")
2018-06-30 16:45:54.634 5917 WARNING oslo_db.sqlalchemy.engines [-] SQL
connection failed. 1 attempts left.: DBConnectionError:
(pymysql.err.OperationalError) (2003, "Can't connect to MySQL server on
'OpenStack-Controller' ([Errno 111] Connection refused)")
2018-06-30 16:46:04.642 5917 CRITICAL keystone [-] Unhandled error:
DBConnectionError: (pymysql.err.OperationalError) (2003, "Can't connect to
MySQL server on 'OpenStack-Controller' ([Errno 111] Connection refused)")
2018-06-30 16:46:04.642 5917 ERROR keystone Traceback (most recent call
last):
2018-06-30 16:46:04.642 5917 ERROR keystone   File
"/usr/bin/keystone-manage", line 10, in <module>
2018-06-30 16:46:04.642 5917 ERROR keystone     sys.exit(main())
2018-06-30 16:46:04.642 5917 ERROR keystone   File
"/usr/lib/python2.7/dist-packages/keystone/cmd/manage.py", line 45, in main
2018-06-30 16:46:04.642 5917 ERROR keystone     cli.main(argv=sys.argv,
config_files=config_files)
2018-06-30 16:46:04.642 5917 ERROR keystone   File
"/usr/lib/python2.7/dist-packages/keystone/cmd/cli.py", line 1349, in main
2018-06-30 16:46:04.642 5917 ERROR keystone
 CONF.command.cmd_class.main()
2018-06-30 16:46:04.642 5917 ERROR keystone   File
"/usr/lib/python2.7/dist-packages/keystone/cmd/cli.py", line 548, in main
2018-06-30 16:46:04.642 5917 ERROR keystone     CONF.command.version)
2018-06-30 16:46:04.642 5917 ERROR keystone   File
"/usr/lib/python2.7/dist-packages/keystone/common/sql/upgrades.py", line
250, in offline_sync_database_to_version
2018-06-30 16:46:04.642 5917 ERROR keystone     expand_schema()
2018-06-30 16:46:04.642 5917 ERROR keystone   File
"/usr/lib/python2.7/dist-packages/keystone/common/sql/upgrades.py", line
323, in expand_schema
2018-06-30 16:46:04.642 5917 ERROR keystone
 _sync_common_repo(version=None)
2018-06-30 16:46:04.642 5917 ERROR keystone   File
"/usr/lib/python2.7/dist-packages/keystone/common/sql/upgrades.py", line
166, in _sync_common_repo
2018-06-30 16:46:04.642 5917 ERROR keystone     with
sql.session_for_write() as session:
2018-06-30 16:46:04.642 5917 ERROR keystone   File
"/usr/lib/python2.7/contextlib.py", line 17, in __enter__
2018-06-30 16:46:04.642 5917 ERROR keystone     return self.gen.next()
2018-06-30 16:46:04.642 5917 ERROR keystone   File
"/usr/lib/python2.7/dist-packages/oslo_db/sqlalchemy/enginefacade.py", line
1035, in _transaction_scope
2018-06-30 16:46:04.642 5917 ERROR keystone     context=context) as
resource:
2018-06-30 16:46:04.642 5917 ERROR keystone   File
"/usr/lib/python2.7/contextlib.py", line 17, in __enter__
2018-06-30 16:46:04.642 5917 ERROR keystone     return self.gen.next()
2018-06-30 16:46:04.642 5917 ERROR keystone   File
"/usr/lib/python2.7/dist-packages/oslo_db/sqlalchemy/enginefacade.py", line
638, in _session
2018-06-30 16:46:04.642 5917 ERROR keystone     bind=self.connection,
mode=self.mode)
2018-06-30 16:46:04.642 5917 ERROR keystone   File
"/usr/lib/python2.7/dist-packages/oslo_db/sqlalchemy/enginefacade.py", line
403, in _create_session
2018-06-30 16:46:04.642 5917 ERROR keystone     self._start()
2018-06-30 16:46:04.642 5917 ERROR keystone   File
"/usr/lib/python2.7/dist-packages/oslo_db/sqlalchemy/enginefacade.py", line
489, in _start
2018-06-30 16:46:04.642 5917 ERROR keystone     engine_args, maker_args)
2018-06-30 16:46:04.642 5917 ERROR keystone   File
"/usr/lib/python2.7/dist-packages/oslo_db/sqlalchemy/enginefacade.py", line
513, in _setup_for_connection
2018-06-30 16:46:04.642 5917 ERROR keystone
 sql_connection=sql_connection, **engine_kwargs)
2018-06-30 16:46:04.642 5917 ERROR keystone   File
"/usr/lib/python2.7/dist-packages/debtcollector/renames.py", line 45, in
wrapper
2018-06-30 16:46:04.642 5917 ERROR keystone     return f(*args, **kwargs)
2018-06-30 16:46:04.642 5917 ERROR keystone   File
"/usr/lib/python2.7/dist-packages/oslo_db/sqlalchemy/engines.py", line 184,
in create_engine
2018-06-30 16:46:04.642 5917 ERROR keystone     test_conn =
_test_connection(engine, max_retries, retry_interval)
2018-06-30 16:46:04.642 5917 ERROR keystone   File
"/usr/lib/python2.7/dist-packages/oslo_db/sqlalchemy/engines.py", line 370,
in _test_connection
2018-06-30 16:46:04.642 5917 ERROR keystone     six.reraise(type(de_ref),
de_ref)
2018-06-30 16:46:04.642 5917 ERROR keystone   File "<string>", line 3, in
reraise
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstack.org/pipermail/openstack/attachments/20180630/3b3e53e5/attachment.html>