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@OpenStack-Controller:~# hostname OpenStack-Controller root@OpenStack-Controller:~# root@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@OpenStack-Controller:~# root@OpenStack-Controller:~# root@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@OpenStack-Controller:~# root@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@OpenStack-Controller:~# root@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
_______________________________________________ Mailing list: http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack Post to : openstack@lists.openstack.org Unsubscribe : http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack
