<html><head><meta http-equiv="content-type" content="text/html; charset=GB2312"><style>body { line-height: 1.5; }blockquote { margin-top: 0px; margin-bottom: 0px; margin-left: 0.5em; }div.foxdiv20161229003118163521 { }body { font-size: 10.5pt; font-family: 微软雅黑; color: rgb(0, 0, 0); line-height: 1.5; }</style></head><body>
<div><b><span></span>Please see the log file below. Looks like no SQL access ? but i'm sure i did the access grant.</b></div><div><br></div><div><span style="color: rgb(0, 0, 0); background-color: rgba(0, 0, 0, 0);">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).<br>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.<br>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.<br>2016-12-29 00:27:10.424 1824 INFO keystone.common.wsgi [req-8d1c8ca9-89ae-41b9-bbb8-81be1076335d - - - - -] GET http://controller:35357/v3/<br>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).<br>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.<br>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.<br>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<br>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)")<br>2016-12-29 00:27:13.006 1825 ERROR keystone.common.wsgi Traceback (most recent call last):<br>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__<br>2016-12-29 00:27:13.006 1825 ERROR keystone.common.wsgi result = method(req, **params)<br>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<br>2016-12-29 00:27:13.006 1825 ERROR keystone.common.wsgi auth_info = AuthInfo.create(auth=auth)<br>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<br>2016-12-29 00:27:13.006 1825 ERROR keystone.common.wsgi auth_info._validate_and_normalize_auth_data(scope_only)<br>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<br>2016-12-29 00:27:13.006 1825 ERROR keystone.common.wsgi self._validate_and_normalize_scope_data()<br>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<br>2016-12-29 00:27:13.006 1825 ERROR keystone.common.wsgi project_ref = self._lookup_project(self.auth['scope']['project'])<br>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<br>2016-12-29 00:27:13.006 1825 ERROR keystone.common.wsgi domain_ref = self._lookup_domain(project_info['domain'])<br>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<br>2016-12-29 00:27:13.006 1825 ERROR keystone.common.wsgi domain_name)<br>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<br>2016-12-29 00:27:13.006 1825 ERROR keystone.common.wsgi __ret_val = __f(*args, **kwargs)<br>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<br>2016-12-29 00:27:13.006 1825 ERROR keystone.common.wsgi should_cache_fn)<br>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<br>2016-12-29 00:27:13.006 1825 ERROR keystone.common.wsgi async_creator) as value:<br>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__<br>2016-12-29 00:27:13.006 1825 ERROR keystone.common.wsgi return self._enter()<br>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<br>2016-12-29 00:27:13.006 1825 ERROR keystone.common.wsgi generated = self._enter_create(createdtime)<br>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<br>2016-12-29 00:27:13.006 1825 ERROR keystone.common.wsgi created = self.creator()<br>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<br>2016-12-29 00:27:13.006 1825 ERROR keystone.common.wsgi created_value = creator()<br>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<br>2016-12-29 00:27:13.006 1825 ERROR keystone.common.wsgi return fn(*arg, **kw)<br>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<br>2016-12-29 00:27:13.006 1825 ERROR keystone.common.wsgi domain_id=None)<br>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<br>2016-12-29 00:27:13.006 1825 ERROR keystone.common.wsgi with sql.session_for_read() as session:<br>2016-12-29 00:27:13.006 1825 ERROR keystone.common.wsgi File "/usr/lib64/python2.7/contextlib.py", line 17, in __enter__<br>2016-12-29 00:27:13.006 1825 ERROR keystone.common.wsgi return self.gen.next()<br>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<br>2016-12-29 00:27:13.006 1825 ERROR keystone.common.wsgi allow_async=self._allow_async) as resource:<br>2016-12-29 00:27:13.006 1825 ERROR keystone.common.wsgi File "/usr/lib64/python2.7/contextlib.py", line 17, in __enter__<br>2016-12-29 00:27:13.006 1825 ERROR keystone.common.wsgi return self.gen.next()<br>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<br>2016-12-29 00:27:13.006 1825 ERROR keystone.common.wsgi bind=self.connection, mode=self.mode)<br>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<br>2016-12-29 00:27:13.006 1825 ERROR keystone.common.wsgi self._start()<br>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<br>2016-12-29 00:27:13.006 1825 ERROR keystone.common.wsgi engine_args, maker_args)<br>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<br>2016-12-29 00:27:13.006 1825 ERROR keystone.common.wsgi sql_connection=sql_connection, **engine_kwargs)<br>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<br>2016-12-29 00:27:13.006 1825 ERROR keystone.common.wsgi test_conn = _test_connection(engine, max_retries, retry_interval)<br>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<br>2016-12-29 00:27:13.006 1825 ERROR keystone.common.wsgi return engine.connect()<br>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<br>2016-12-29 00:27:13.006 1825 ERROR keystone.common.wsgi return self._connection_cls(self, **kwargs)<br>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__<br>2016-12-29 00:27:13.006 1825 ERROR keystone.common.wsgi if connection is not None else engine.raw_connection()<br>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<br>2016-12-29 00:27:13.006 1825 ERROR keystone.common.wsgi self.pool.unique_connection, _connection)<br>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<br>2016-12-29 00:27:13.006 1825 ERROR keystone.common.wsgi e, dialect, self)<br>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<br>2016-12-29 00:27:13.006 1825 ERROR keystone.common.wsgi util.raise_from_cause(newraise, exc_info)<br>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<br>2016-12-29 00:27:13.006 1825 ERROR keystone.common.wsgi reraise(type(exception), exception, tb=exc_tb)<br>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<br>2016-12-29 00:27:13.006 1825 ERROR keystone.common.wsgi return fn()<br>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<br>2016-12-29 00:27:13.006 1825 ERROR keystone.common.wsgi return _ConnectionFairy._checkout(self)<br>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<br>2016-12-29 00:27:13.006 1825 ERROR keystone.common.wsgi fairy = _ConnectionRecord.checkout(pool)<br>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<br>2016-12-29 00:27:13.006 1825 ERROR keystone.common.wsgi rec = pool._do_get()<br>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<br>2016-12-29 00:27:13.006 1825 ERROR keystone.common.wsgi self._dec_overflow()<br>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__<br>2016-12-29 00:27:13.006 1825 ERROR keystone.common.wsgi compat.reraise(exc_type, exc_value, exc_tb)<br>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<br>2016-12-29 00:27:13.006 1825 ERROR keystone.common.wsgi return self._create_connection()<br>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<br>2016-12-29 00:27:13.006 1825 ERROR keystone.common.wsgi return _ConnectionRecord(self)<br>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__<br>2016-12-29 00:27:13.006 1825 ERROR keystone.common.wsgi self.connection = self.__connect()<br>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<br>2016-12-29 00:27:13.006 1825 ERROR keystone.common.wsgi connection = self.__pool._invoke_creator(self)<br>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<br>2016-12-29 00:27:13.006 1825 ERROR keystone.common.wsgi return dialect.connect(*cargs, **cparams)<br>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<br>2016-12-29 00:27:13.006 1825 ERROR keystone.common.wsgi return self.dbapi.connect(*cargs, **cparams)<br>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<br>2016-12-29 00:27:13.006 1825 ERROR keystone.common.wsgi return Connection(*args, **kwargs)<br>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__<br>2016-12-29 00:27:13.006 1825 ERROR keystone.common.wsgi self.connect()<br>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<br>2016-12-29 00:27:13.006 1825 ERROR keystone.common.wsgi self._request_authentication()<br>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<br>2016-12-29 00:27:13.006 1825 ERROR keystone.common.wsgi auth_packet = self._read_packet()<br>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<br>2016-12-29 00:27:13.006 1825 ERROR keystone.common.wsgi packet.check_error()<br>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<br>2016-12-29 00:27:13.006 1825 ERROR keystone.common.wsgi err.raise_mysql_exception(self._data)<br>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<br>2016-12-29 00:27:13.006 1825 ERROR keystone.common.wsgi raise errorclass(errno, errval)<br>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)")<br>2016-12-29 00:27:13.006 1825 ERROR keystone.common.wsgi<br>[root@controller keystone]#<br></span></div>
<div><br></div><hr style="width: 210px; height: 1px;" color="#b5c4df" size="1" align="left">
<div><span><div style="MARGIN: 10px; FONT-FAMILY: verdana; FONT-SIZE: 10pt"><div style="margin: 10px; font-size: 10pt;">=========================================</div><div style="margin: 10px; font-size: 10pt;"><span style="color: rgb(0, 0, 0); background-color: rgba(0, 0, 0, 0);">董 建 华<br>地址：杭州滨江区南环路3766号新世纪办公楼<br>邮编：310053<br>手机：13857132818<br>总机：0571-28996000<br>传真：0571-28996001<br>热线：4006728686<br>网址：www.ahope.com.cn<br>Email：dongjh@</span><span style="font-size: 10pt; line-height: 1.5; background-color: window;">ahope.com.cn</span></div></div></span></div>
<blockquote style="margin-top: 0px; margin-bottom: 0px; margin-left: 0.5em;"><div> </div><div style="border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm"><div style="PADDING-RIGHT: 8px; PADDING-LEFT: 8px; FONT-SIZE: 12px;FONT-FAMILY:tahoma;COLOR:#000000; BACKGROUND: #efefef; PADDING-BOTTOM: 8px; PADDING-TOP: 8px"><div><b>发件人：</b> <a href="mailto:dongjh@ahope.com.cn">dongjh@ahope.com.cn</a></div><div><b>发送时间：</b> 2016-12-28 23:42</div><div><b>收件人：</b> <a href="mailto:openstack@lists.openstack.org">openstack</a></div><div><b>主题：</b> keystone fail</div></div></div><div><div class="FoxDiv20161229003118163521"><div><b><span></span>Hi all,</b></div><div><b><br></b></div><div><b>I'm installing the openstack newton on centos 7, totally follow the <span style="background-color: rgba(0, 0, 0, 0); font-size: 10.5pt; line-height: 1.5;">Newton Installation Tutorials, but failed to create the service project, what is the issue ? Thanks.</span></b></div><div><span style="background-color: rgba(0, 0, 0, 0); font-size: 10.5pt; line-height: 1.5;"><br></span></div><div><span style="background-color: rgba(0, 0, 0, 0); font-size: 10.5pt; line-height: 1.5;">[admin@controller ~]$ export OS_USERNAME=admin</span></div><div><span style="color: rgb(0, 0, 0);">[admin@controller ~]$ export OS_PASSWORD=Ahope2016<br>[admin@controller ~]$ export OS_PROJECT_NAME=admin<br>[admin@controller ~]$ export OS_USER_DOMAIN_NAME=default<br>[admin@controller ~]$ export OS_PROJECT_DOMAIN_NAME=default<br>[admin@controller ~]$ export OS_AUTH_URL=http://controller:35357/v3<br>[admin@controller ~]$ export OS_IDENTITY_API_VERSION=3<br>[admin@controller ~]$<br>[admin@controller ~]$ openstack project create --domain default \<br>> --description "Service Project" service<br><span style="background-color: rgb(255, 0, 0);"><i>An unexpected error prevented the server from fulfilling your request. (HTTP 500) (Request-ID: req-806af2ab-dabe-461a-8c21-ba309527d4aa)</i></span><br>[admin@controller ~]$<br>[admin@controller ~]$ uname -a<br>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<br>[admin@controller ~]$ cat /etc/*lease<br>CentOS Linux release 7.3.1611 (Core)<br>NAME="CentOS Linux"<br>VERSION="7 (Core)"<br>ID="centos"<br>ID_LIKE="rhel fedora"<br>VERSION_ID="7"<br>PRETTY_NAME="CentOS Linux 7 (Core)"<br>ANSI_COLOR="0;31"<br>CPE_NAME="cpe:/o:centos:centos:7"<br>HOME_URL="https://www.centos.org/"<br>BUG_REPORT_URL="https://bugs.centos.org/"<br><br>CENTOS_MANTISBT_PROJECT="CentOS-7"<br>CENTOS_MANTISBT_PROJECT_VERSION="7"<br>REDHAT_SUPPORT_PRODUCT="centos"<br>REDHAT_SUPPORT_PRODUCT_VERSION="7"<br><br>CentOS Linux release 7.3.1611 (Core)<br>CentOS Linux release 7.3.1611 (Core)<br>[admin@controller ~]$<br></span></div>
<div><br></div><hr style="width: 210px; height: 1px;" color="#b5c4df" size="1" align="left">
<div><span><div style="MARGIN: 10px; FONT-FAMILY: verdana; FONT-SIZE: 10pt"><div style="margin: 10px; font-size: 10pt;">=========================================</div><div style="margin: 10px; font-size: 10pt;"><span style="color: rgb(0, 0, 0); background-color: rgba(0, 0, 0, 0);">董 建 华<br>地址：杭州滨江区南环路3766号新世纪办公楼<br>邮编：310053<br>手机：13857132818<br>总机：0571-28996000<br>传真：0571-28996001<br>热线：4006728686<br>网址：www.ahope.com.cn<br>Email：dongjh@</span><span style="font-size: 10pt; line-height: 1.5; background-color: window;">ahope.com.cn</span></div></div></span></div>
</div></div></blockquote>
</body></html>