Please see the log file below. Looks like no SQL access ? but i'm sure i did the access grant.
2016-12-29 00:27:09.679 1824 WARNING keystone.assignment.core [-] Deprecated: Use of the identity driver config to automatically configure the same assignment driver has been deprecated, in the "O" release, the assignment driver will need to be expicitly configured if different than the default (SQL). 2016-12-29 00:27:10.146 1824 WARNING keystone.middleware.core [-] The admin_token_auth middleware presents a security risk and should be removed from the [pipeline:api_v3], [pipeline:admin_api], and [pipeline:public_api] sections of your paste ini file. 2016-12-29 00:27:10.281 1824 WARNING keystone.middleware.core [-] The admin_token_auth middleware presents a security risk and should be removed from the [pipeline:api_v3], [pipeline:admin_api], and [pipeline:public_api] sections of your paste ini file. 2016-12-29 00:27:10.424 1824 INFO keystone.common.wsgi [req-8d1c8ca9-89ae-41b9-bbb8-81be1076335d - - - - -] GET http://controller:35357/v3/ 2016-12-29 00:27:12.229 1825 WARNING keystone.assignment.core [-] Deprecated: Use of the identity driver config to automatically configure the same assignment driver has been deprecated, in the "O" release, the assignment driver will need to be expicitly configured if different than the default (SQL). 2016-12-29 00:27:12.579 1825 WARNING keystone.middleware.core [-] The admin_token_auth middleware presents a security risk and should be removed from the [pipeline:api_v3], [pipeline:admin_api], and [pipeline:public_api] sections of your paste ini file. 2016-12-29 00:27:12.714 1825 WARNING keystone.middleware.core [-] The admin_token_auth middleware presents a security risk and should be removed from the [pipeline:api_v3], [pipeline:admin_api], and [pipeline:public_api] sections of your paste ini file. 2016-12-29 00:27:12.858 1825 INFO keystone.common.wsgi [req-60648bff-12b1-48b4-85fd-64fb31b38e15 - - - - -] POST http://controller:35357/v3/auth/tokens 2016-12-29 00:27:13.006 1825 ERROR keystone.common.wsgi [req-60648bff-12b1-48b4-85fd-64fb31b38e15 - - - - -] (pymysql.err.OperationalError) (1045, u"Access denied for user 'keystone'@'controller' (using password: YES)") 2016-12-29 00:27:13.006 1825 ERROR keystone.common.wsgi Traceback (most recent call last): 2016-12-29 00:27:13.006 1825 ERROR keystone.common.wsgi File "/usr/lib/python2.7/site-packages/keystone/common/wsgi.py", line 225, in __call__ 2016-12-29 00:27:13.006 1825 ERROR keystone.common.wsgi result = method(req, **params) 2016-12-29 00:27:13.006 1825 ERROR keystone.common.wsgi File "/usr/lib/python2.7/site-packages/keystone/auth/controllers.py", line 397, in authenticate_for_token 2016-12-29 00:27:13.006 1825 ERROR keystone.common.wsgi auth_info = AuthInfo.create(auth=auth) 2016-12-29 00:27:13.006 1825 ERROR keystone.common.wsgi File "/usr/lib/python2.7/site-packages/keystone/auth/controllers.py", line 137, in create 2016-12-29 00:27:13.006 1825 ERROR keystone.common.wsgi auth_info._validate_and_normalize_auth_data(scope_only) 2016-12-29 00:27:13.006 1825 ERROR keystone.common.wsgi File "/usr/lib/python2.7/site-packages/keystone/auth/controllers.py", line 310, in _validate_and_normalize_auth_data 2016-12-29 00:27:13.006 1825 ERROR keystone.common.wsgi self._validate_and_normalize_scope_data() 2016-12-29 00:27:13.006 1825 ERROR keystone.common.wsgi File "/usr/lib/python2.7/site-packages/keystone/auth/controllers.py", line 252, in _validate_and_normalize_scope_data 2016-12-29 00:27:13.006 1825 ERROR keystone.common.wsgi project_ref = self._lookup_project(self.auth['scope']['project']) 2016-12-29 00:27:13.006 1825 ERROR keystone.common.wsgi File "/usr/lib/python2.7/site-packages/keystone/auth/controllers.py", line 215, in _lookup_project 2016-12-29 00:27:13.006 1825 ERROR keystone.common.wsgi domain_ref = self._lookup_domain(project_info['domain']) 2016-12-29 00:27:13.006 1825 ERROR keystone.common.wsgi File "/usr/lib/python2.7/site-packages/keystone/auth/controllers.py", line 187, in _lookup_domain 2016-12-29 00:27:13.006 1825 ERROR keystone.common.wsgi domain_name) 2016-12-29 00:27:13.006 1825 ERROR keystone.common.wsgi File "/usr/lib/python2.7/site-packages/keystone/common/manager.py", line 124, in wrapped 2016-12-29 00:27:13.006 1825 ERROR keystone.common.wsgi __ret_val = __f(*args, **kwargs) 2016-12-29 00:27:13.006 1825 ERROR keystone.common.wsgi File "/usr/lib/python2.7/site-packages/dogpile/cache/region.py", line 1220, in decorate 2016-12-29 00:27:13.006 1825 ERROR keystone.common.wsgi should_cache_fn) 2016-12-29 00:27:13.006 1825 ERROR keystone.common.wsgi File "/usr/lib/python2.7/site-packages/dogpile/cache/region.py", line 825, in get_or_create 2016-12-29 00:27:13.006 1825 ERROR keystone.common.wsgi async_creator) as value: 2016-12-29 00:27:13.006 1825 ERROR keystone.common.wsgi File "/usr/lib/python2.7/site-packages/dogpile/lock.py", line 154, in __enter__ 2016-12-29 00:27:13.006 1825 ERROR keystone.common.wsgi return self._enter() 2016-12-29 00:27:13.006 1825 ERROR keystone.common.wsgi File "/usr/lib/python2.7/site-packages/dogpile/lock.py", line 94, in _enter 2016-12-29 00:27:13.006 1825 ERROR keystone.common.wsgi generated = self._enter_create(createdtime) 2016-12-29 00:27:13.006 1825 ERROR keystone.common.wsgi File "/usr/lib/python2.7/site-packages/dogpile/lock.py", line 145, in _enter_create 2016-12-29 00:27:13.006 1825 ERROR keystone.common.wsgi created = self.creator() 2016-12-29 00:27:13.006 1825 ERROR keystone.common.wsgi File "/usr/lib/python2.7/site-packages/dogpile/cache/region.py", line 792, in gen_value 2016-12-29 00:27:13.006 1825 ERROR keystone.common.wsgi created_value = creator() 2016-12-29 00:27:13.006 1825 ERROR keystone.common.wsgi File "/usr/lib/python2.7/site-packages/dogpile/cache/region.py", line 1216, in creator 2016-12-29 00:27:13.006 1825 ERROR keystone.common.wsgi return fn(*arg, **kw) 2016-12-29 00:27:13.006 1825 ERROR keystone.common.wsgi File "/usr/lib/python2.7/site-packages/keystone/resource/core.py", line 721, in get_domain_by_name 2016-12-29 00:27:13.006 1825 ERROR keystone.common.wsgi domain_id=None) 2016-12-29 00:27:13.006 1825 ERROR keystone.common.wsgi File "/usr/lib/python2.7/site-packages/keystone/resource/backends/sql.py", line 52, in get_project_by_name 2016-12-29 00:27:13.006 1825 ERROR keystone.common.wsgi with sql.session_for_read() as session: 2016-12-29 00:27:13.006 1825 ERROR keystone.common.wsgi File "/usr/lib64/python2.7/contextlib.py", line 17, in __enter__ 2016-12-29 00:27:13.006 1825 ERROR keystone.common.wsgi return self.gen.next() 2016-12-29 00:27:13.006 1825 ERROR keystone.common.wsgi File "/usr/lib/python2.7/site-packages/oslo_db/sqlalchemy/enginefacade.py", line 874, in _transaction_scope 2016-12-29 00:27:13.006 1825 ERROR keystone.common.wsgi allow_async=self._allow_async) as resource: 2016-12-29 00:27:13.006 1825 ERROR keystone.common.wsgi File "/usr/lib64/python2.7/contextlib.py", line 17, in __enter__ 2016-12-29 00:27:13.006 1825 ERROR keystone.common.wsgi return self.gen.next() 2016-12-29 00:27:13.006 1825 ERROR keystone.common.wsgi File "/usr/lib/python2.7/site-packages/oslo_db/sqlalchemy/enginefacade.py", line 518, in _session 2016-12-29 00:27:13.006 1825 ERROR keystone.common.wsgi bind=self.connection, mode=self.mode) 2016-12-29 00:27:13.006 1825 ERROR keystone.common.wsgi File "/usr/lib/python2.7/site-packages/oslo_db/sqlalchemy/enginefacade.py", line 277, in _create_session 2016-12-29 00:27:13.006 1825 ERROR keystone.common.wsgi self._start() 2016-12-29 00:27:13.006 1825 ERROR keystone.common.wsgi File "/usr/lib/python2.7/site-packages/oslo_db/sqlalchemy/enginefacade.py", line 363, in _start 2016-12-29 00:27:13.006 1825 ERROR keystone.common.wsgi engine_args, maker_args) 2016-12-29 00:27:13.006 1825 ERROR keystone.common.wsgi File "/usr/lib/python2.7/site-packages/oslo_db/sqlalchemy/enginefacade.py", line 387, in _setup_for_connection 2016-12-29 00:27:13.006 1825 ERROR keystone.common.wsgi sql_connection=sql_connection, **engine_kwargs) 2016-12-29 00:27:13.006 1825 ERROR keystone.common.wsgi File "/usr/lib/python2.7/site-packages/oslo_db/sqlalchemy/engines.py", line 155, in create_engine 2016-12-29 00:27:13.006 1825 ERROR keystone.common.wsgi test_conn = _test_connection(engine, max_retries, retry_interval) 2016-12-29 00:27:13.006 1825 ERROR keystone.common.wsgi File "/usr/lib/python2.7/site-packages/oslo_db/sqlalchemy/engines.py", line 331, in _test_connection 2016-12-29 00:27:13.006 1825 ERROR keystone.common.wsgi return engine.connect() 2016-12-29 00:27:13.006 1825 ERROR keystone.common.wsgi File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 2018, in connect 2016-12-29 00:27:13.006 1825 ERROR keystone.common.wsgi return self._connection_cls(self, **kwargs) 2016-12-29 00:27:13.006 1825 ERROR keystone.common.wsgi File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 72, in __init__ 2016-12-29 00:27:13.006 1825 ERROR keystone.common.wsgi if connection is not None else engine.raw_connection() 2016-12-29 00:27:13.006 1825 ERROR keystone.common.wsgi File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 2104, in raw_connection 2016-12-29 00:27:13.006 1825 ERROR keystone.common.wsgi self.pool.unique_connection, _connection) 2016-12-29 00:27:13.006 1825 ERROR keystone.common.wsgi File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 2078, in _wrap_pool_connect 2016-12-29 00:27:13.006 1825 ERROR keystone.common.wsgi e, dialect, self) 2016-12-29 00:27:13.006 1825 ERROR keystone.common.wsgi File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1401, in _handle_dbapi_exception_noconnection 2016-12-29 00:27:13.006 1825 ERROR keystone.common.wsgi util.raise_from_cause(newraise, exc_info) 2016-12-29 00:27:13.006 1825 ERROR keystone.common.wsgi File "/usr/lib64/python2.7/site-packages/sqlalchemy/util/compat.py", line 200, in raise_from_cause 2016-12-29 00:27:13.006 1825 ERROR keystone.common.wsgi reraise(type(exception), exception, tb=exc_tb) 2016-12-29 00:27:13.006 1825 ERROR keystone.common.wsgi File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 2074, in _wrap_pool_connect 2016-12-29 00:27:13.006 1825 ERROR keystone.common.wsgi return fn() 2016-12-29 00:27:13.006 1825 ERROR keystone.common.wsgi File "/usr/lib64/python2.7/site-packages/sqlalchemy/pool.py", line 318, in unique_connection 2016-12-29 00:27:13.006 1825 ERROR keystone.common.wsgi return _ConnectionFairy._checkout(self) 2016-12-29 00:27:13.006 1825 ERROR keystone.common.wsgi File "/usr/lib64/python2.7/site-packages/sqlalchemy/pool.py", line 713, in _checkout 2016-12-29 00:27:13.006 1825 ERROR keystone.common.wsgi fairy = _ConnectionRecord.checkout(pool) 2016-12-29 00:27:13.006 1825 ERROR keystone.common.wsgi File "/usr/lib64/python2.7/site-packages/sqlalchemy/pool.py", line 480, in checkout 2016-12-29 00:27:13.006 1825 ERROR keystone.common.wsgi rec = pool._do_get() 2016-12-29 00:27:13.006 1825 ERROR keystone.common.wsgi File "/usr/lib64/python2.7/site-packages/sqlalchemy/pool.py", line 1060, in _do_get 2016-12-29 00:27:13.006 1825 ERROR keystone.common.wsgi self._dec_overflow() 2016-12-29 00:27:13.006 1825 ERROR keystone.common.wsgi File "/usr/lib64/python2.7/site-packages/sqlalchemy/util/langhelpers.py", line 60, in __exit__ 2016-12-29 00:27:13.006 1825 ERROR keystone.common.wsgi compat.reraise(exc_type, exc_value, exc_tb) 2016-12-29 00:27:13.006 1825 ERROR keystone.common.wsgi File "/usr/lib64/python2.7/site-packages/sqlalchemy/pool.py", line 1057, in _do_get 2016-12-29 00:27:13.006 1825 ERROR keystone.common.wsgi return self._create_connection() 2016-12-29 00:27:13.006 1825 ERROR keystone.common.wsgi File "/usr/lib64/python2.7/site-packages/sqlalchemy/pool.py", line 323, in _create_connection 2016-12-29 00:27:13.006 1825 ERROR keystone.common.wsgi return _ConnectionRecord(self) 2016-12-29 00:27:13.006 1825 ERROR keystone.common.wsgi File "/usr/lib64/python2.7/site-packages/sqlalchemy/pool.py", line 449, in __init__ 2016-12-29 00:27:13.006 1825 ERROR keystone.common.wsgi self.connection = self.__connect() 2016-12-29 00:27:13.006 1825 ERROR keystone.common.wsgi File "/usr/lib64/python2.7/site-packages/sqlalchemy/pool.py", line 607, in __connect 2016-12-29 00:27:13.006 1825 ERROR keystone.common.wsgi connection = self.__pool._invoke_creator(self) 2016-12-29 00:27:13.006 1825 ERROR keystone.common.wsgi File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/strategies.py", line 97, in connect 2016-12-29 00:27:13.006 1825 ERROR keystone.common.wsgi return dialect.connect(*cargs, **cparams) 2016-12-29 00:27:13.006 1825 ERROR keystone.common.wsgi File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/default.py", line 385, in connect 2016-12-29 00:27:13.006 1825 ERROR keystone.common.wsgi return self.dbapi.connect(*cargs, **cparams) 2016-12-29 00:27:13.006 1825 ERROR keystone.common.wsgi File "/usr/lib/python2.7/site-packages/pymysql/__init__.py", line 90, in Connect 2016-12-29 00:27:13.006 1825 ERROR keystone.common.wsgi return Connection(*args, **kwargs) 2016-12-29 00:27:13.006 1825 ERROR keystone.common.wsgi File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 694, in __init__ 2016-12-29 00:27:13.006 1825 ERROR keystone.common.wsgi self.connect() 2016-12-29 00:27:13.006 1825 ERROR keystone.common.wsgi File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 916, in connect 2016-12-29 00:27:13.006 1825 ERROR keystone.common.wsgi self._request_authentication() 2016-12-29 00:27:13.006 1825 ERROR keystone.common.wsgi File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 1124, in _request_authentication 2016-12-29 00:27:13.006 1825 ERROR keystone.common.wsgi auth_packet = self._read_packet() 2016-12-29 00:27:13.006 1825 ERROR keystone.common.wsgi File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 991, in _read_packet 2016-12-29 00:27:13.006 1825 ERROR keystone.common.wsgi packet.check_error() 2016-12-29 00:27:13.006 1825 ERROR keystone.common.wsgi File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 393, in check_error 2016-12-29 00:27:13.006 1825 ERROR keystone.common.wsgi err.raise_mysql_exception(self._data) 2016-12-29 00:27:13.006 1825 ERROR keystone.common.wsgi File "/usr/lib/python2.7/site-packages/pymysql/err.py", line 107, in raise_mysql_exception 2016-12-29 00:27:13.006 1825 ERROR keystone.common.wsgi raise errorclass(errno, errval) 2016-12-29 00:27:13.006 1825 ERROR keystone.common.wsgi OperationalError: (pymysql.err.OperationalError) (1045, u"Access denied for user 'keystone'@'controller' (using password: YES)") 2016-12-29 00:27:13.006 1825 ERROR keystone.common.wsgi [root@controller keystone]# ========================================= 董 建 华 地址：杭州滨江区南环路3766号新世纪办公楼 邮编：310053 手机：13857132818 总机：0571-28996000 传真：0571-28996001 热线：4006728686 网址：www.ahope.com.cn Email：[email protected] 发件人： [email protected] 发送时间： 2016-12-28 23:42 收件人： openstack 主题： keystone fail Hi all, I'm installing the openstack newton on centos 7, totally follow the Newton Installation Tutorials, but failed to create the service project, what is the issue ? Thanks. [admin@controller ~]$ export OS_USERNAME=admin [admin@controller ~]$ export OS_PASSWORD=Ahope2016 [admin@controller ~]$ export OS_PROJECT_NAME=admin [admin@controller ~]$ export OS_USER_DOMAIN_NAME=default [admin@controller ~]$ export OS_PROJECT_DOMAIN_NAME=default [admin@controller ~]$ export OS_AUTH_URL=http://controller:35357/v3 [admin@controller ~]$ export OS_IDENTITY_API_VERSION=3 [admin@controller ~]$ [admin@controller ~]$ openstack project create --domain default \ > --description "Service Project" service An unexpected error prevented the server from fulfilling your request. (HTTP 500) (Request-ID: req-806af2ab-dabe-461a-8c21-ba309527d4aa) [admin@controller ~]$ [admin@controller ~]$ uname -a Linux controller 3.10.0-514.2.2.el7.x86_64 #1 SMP Tue Dec 6 23:06:41 UTC 2016 x86_64 x86_64 x86_64 GNU/Linux [admin@controller ~]$ cat /etc/*lease CentOS Linux release 7.3.1611 (Core) NAME="CentOS Linux" VERSION="7 (Core)" ID="centos" ID_LIKE="rhel fedora" VERSION_ID="7" PRETTY_NAME="CentOS Linux 7 (Core)" ANSI_COLOR="0;31" CPE_NAME="cpe:/o:centos:centos:7" HOME_URL="https://www.centos.org/"; BUG_REPORT_URL="https://bugs.centos.org/"; CENTOS_MANTISBT_PROJECT="CentOS-7" CENTOS_MANTISBT_PROJECT_VERSION="7" REDHAT_SUPPORT_PRODUCT="centos" REDHAT_SUPPORT_PRODUCT_VERSION="7" CentOS Linux release 7.3.1611 (Core) CentOS Linux release 7.3.1611 (Core) [admin@controller ~]$ ========================================= 董 建 华 地址：杭州滨江区南环路3766号新世纪办公楼 邮编：310053 手机：13857132818 总机：0571-28996000 传真：0571-28996001 热线：4006728686 网址：www.ahope.com.cn Email：[email protected]
_______________________________________________ Mailing list: http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack Post to : [email protected] Unsubscribe : http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack
