[Openstack] 回复: keystone fail

dongjh at ahope.com.cn dongjh at ahope.com.cn
Wed Dec 28 16:35:23 UTC 2016 

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 at controller keystone]#



=========================================
董 建 华
地址：杭州滨江区南环路3766号新世纪办公楼
邮编：310053
手机：13857132818
总机：0571-28996000
传真：0571-28996001
热线：4006728686
网址：www.ahope.com.cn
Email：dongjh at ahope.com.cn
 
发件人： dongjh at ahope.com.cn
发送时间： 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 at controller ~]$ export OS_USERNAME=admin
[admin at controller ~]$ export OS_PASSWORD=Ahope2016
[admin at controller ~]$ export OS_PROJECT_NAME=admin
[admin at controller ~]$ export OS_USER_DOMAIN_NAME=default
[admin at controller ~]$ export OS_PROJECT_DOMAIN_NAME=default
[admin at controller ~]$ export OS_AUTH_URL=http://controller:35357/v3
[admin at controller ~]$ export OS_IDENTITY_API_VERSION=3
[admin at controller ~]$
[admin at 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 at controller ~]$
[admin at 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 at 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 at controller ~]$



=========================================
董 建 华
地址：杭州滨江区南环路3766号新世纪办公楼
邮编：310053
手机：13857132818
总机：0571-28996000
传真：0571-28996001
热线：4006728686
网址：www.ahope.com.cn
Email：dongjh at ahope.com.cn
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstack.org/pipermail/openstack/attachments/20161229/518e8d61/attachment.html>

More information about the Openstack mailing list