Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Tried setting up openstack using newton release in ubuntu 16.04 and getting the below error while setting up user privileges for the keystone error,

root@oschncontroller:/home/chncontroller# su -s /bin/sh -c "keystone-manage db_sync" keystone 2016-11-03 11:56:35.004 4260 CRITICAL keystone [-] OperationalError: (pymysql.err.OperationalError) (1045, u"Access denied for user 'keystone'@'oschncontroller' (using password: YES)") 2016-11-03 11:56:35.004 4260 ERROR keystone Traceback (most recent call last): 2016-11-03 11:56:35.004 4260 ERROR keystone File "/usr/bin/keystone-manage", line 10, in <module> 2016-11-03 11:56:35.004 4260 ERROR keystone sys.exit(main()) 2016-11-03 11:56:35.004 4260 ERROR keystone File "/usr/lib/python2.7/dist-packages/keystone/cmd/manage.py", line 44, in main 2016-11-03 11:56:35.004 4260 ERROR keystone cli.main(argv=sys.argv, config_files=config_files) 2016-11-03 11:56:35.004 4260 ERROR keystone File "/usr/lib/python2.7/dist-packages/keystone/cmd/cli.py", line 1254, in main 2016-11-03 11:56:35.004 4260 ERROR keystone CONF.command.cmd_class.main() 2016-11-03 11:56:35.004 4260 ERROR keystone File "/usr/lib/python2.7/dist-packages/keystone/cmd/cli.py", line 445, in main 2016-11-03 11:56:35.004 4260 ERROR keystone CONF.command.version) 2016-11-03 11:56:35.004 4260 ERROR keystone File "/usr/lib/python2.7/dist-packages/keystone/common/sql/migration_helpers.py", line 207, in offline_sync_database_to_version 2016-11-03 11:56:35.004 4260 ERROR keystone expand_schema() 2016-11-03 11:56:35.004 4260 ERROR keystone File "/usr/lib/python2.7/dist-packages/keystone/common/sql/migration_helpers.py", line 232, in expand_schema 2016-11-03 11:56:35.004 4260 ERROR keystone _sync_common_repo(version=None) 2016-11-03 11:56:35.004 4260 ERROR keystone File "/usr/lib/python2.7/dist-packages/keystone/common/sql/migration_helpers.py", line 123, in _sync_common_repo 2016-11-03 11:56:35.004 4260 ERROR keystone with sql.session_for_write() as session: 2016-11-03 11:56:35.004 4260 ERROR keystone File "/usr/lib/python2.7/contextlib.py", line 17, in __enter__ 2016-11-03 11:56:35.004 4260 ERROR keystone return self.gen.next() 2016-11-03 11:56:35.004 4260 ERROR keystone File "/usr/lib/python2.7/dist-packages/oslo_db/sqlalchemy/enginefacade.py", line 874, in _transaction_scope 2016-11-03 11:56:35.004 4260 ERROR keystone allow_async=self._allow_async) as resource: 2016-11-03 11:56:35.004 4260 ERROR keystone File "/usr/lib/python2.7/contextlib.py", line 17, in __enter__ 2016-11-03 11:56:35.004 4260 ERROR keystone return self.gen.next() 2016-11-03 11:56:35.004 4260 ERROR keystone File "/usr/lib/python2.7/dist-packages/oslo_db/sqlalchemy/enginefacade.py", line 518, in _session 2016-11-03 11:56:35.004 4260 ERROR keystone bind=self.connection, mode=self.mode) 2016-11-03 11:56:35.004 4260 ERROR keystone File "/usr/lib/python2.7/dist-packages/oslo_db/sqlalchemy/enginefacade.py", line 277, in _create_session 2016-11-03 11:56:35.004 4260 ERROR keystone self._start() 2016-11-03 11:56:35.004 4260 ERROR keystone File "/usr/lib/python2.7/dist-packages/oslo_db/sqlalchemy/enginefacade.py", line 363, in _start 2016-11-03 11:56:35.004 4260 ERROR keystone engine_args, maker_args) 2016-11-03 11:56:35.004 4260 ERROR keystone File "/usr/lib/python2.7/dist-packages/oslo_db/sqlalchemy/enginefacade.py", line 387, in _setup_for_connection 2016-11-03 11:56:35.004 4260 ERROR keystone sql_connection=sql_connection, *engine_kwargs) 2016-11-03 11:56:35.004 4260 ERROR keystone File "/usr/lib/python2.7/dist-packages/oslo_db/sqlalchemy/engines.py", line 155, in create_engine 2016-11-03 11:56:35.004 4260 ERROR keystone test_conn = _test_connection(engine, max_retries, retry_interval) 2016-11-03 11:56:35.004 4260 ERROR keystone File "/usr/lib/python2.7/dist-packages/oslo_db/sqlalchemy/engines.py", line 331, in _test_connection 2016-11-03 11:56:35.004 4260 ERROR keystone return engine.connect() 2016-11-03 11:56:35.004 4260 ERROR keystone File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 2018, in connect 2016-11-03 11:56:35.004 4260 ERROR keystone return self._connection_cls(self, *kwargs) 2016-11-03 11:56:35.004 4260 ERROR keystone File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 72, in __init__ 2016-11-03 11:56:35.004 4260 ERROR keystone if connection is not None else engine.raw_connection() 2016-11-03 11:56:35.004 4260 ERROR keystone File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 2104, in raw_connection 2016-11-03 11:56:35.004 4260 ERROR keystone self.pool.unique_connection, _connection) 2016-11-03 11:56:35.004 4260 ERROR keystone File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 2078, in _wrap_pool_connect 2016-11-03 11:56:35.004 4260 ERROR keystone e, dialect, self) 2016-11-03 11:56:35.004 4260 ERROR keystone File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1401, in _handle_dbapi_exception_noconnection 2016-11-03 11:56:35.004 4260 ERROR keystone util.raise_from_cause(newraise, exc_info) 2016-11-03 11:56:35.004 4260 ERROR keystone File "/usr/lib/python2.7/dist-packages/sqlalchemy/util/compat.py", line 200, in raise_from_cause 2016-11-03 11:56:35.004 4260 ERROR keystone reraise(type(exception), exception, tb=exc_tb) 2016-11-03 11:56:35.004 4260 ERROR keystone File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 2074, in _wrap_pool_connect 2016-11-03 11:56:35.004 4260 ERROR keystone return fn() 2016-11-03 11:56:35.004 4260 ERROR keystone File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 318, in unique_connection 2016-11-03 11:56:35.004 4260 ERROR keystone return _ConnectionFairy._checkout(self) 2016-11-03 11:56:35.004 4260 ERROR keystone File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 713, in _checkout 2016-11-03 11:56:35.004 4260 ERROR keystone fairy = _ConnectionRecord.checkout(pool) 2016-11-03 11:56:35.004 4260 ERROR keystone File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 480, in checkout 2016-11-03 11:56:35.004 4260 ERROR keystone rec = pool._do_get() 2016-11-03 11:56:35.004 4260 ERROR keystone File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 1060, in _do_get 2016-11-03 11:56:35.004 4260 ERROR keystone self._dec_overflow() 2016-11-03 11:56:35.004 4260 ERROR keystone File "/usr/lib/python2.7/dist-packages/sqlalchemy/util/langhelpers.py", line 60, in __exit__ 2016-11-03 11:56:35.004 4260 ERROR keystone compat.reraise(exc_type, exc_value, exc_tb) 2016-11-03 11:56:35.004 4260 ERROR keystone File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 1057, in _do_get 2016-11-03 11:56:35.004 4260 ERROR keystone return self._create_connection() 2016-11-03 11:56:35.004 4260 ERROR keystone File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 323, in _create_connection 2016-11-03 11:56:35.004 4260 ERROR keystone return _ConnectionRecord(self) 2016-11-03 11:56:35.004 4260 ERROR keystone File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 449, in __init__ 2016-11-03 11:56:35.004 4260 ERROR keystone self.connection = self.__connect() 2016-11-03 11:56:35.004 4260 ERROR keystone File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 607, in __connect 2016-11-03 11:56:35.004 4260 ERROR keystone connection = self.__pool._invoke_creator(self) 2016-11-03 11:56:35.004 4260 ERROR keystone File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/strategies.py", line 97, in connect 2016-11-03 11:56:35.004 4260 ERROR keystone return dialect.connect(cargs, *cparams) 2016-11-03 11:56:35.004 4260 ERROR keystone File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 385, in connect 2016-11-03 11:56:35.004 4260 ERROR keystone return self.dbapi.connect(cargs, *cparams) 2016-11-03 11:56:35.004 4260 ERROR keystone File "/usr/lib/python2.7/dist-packages/pymysql/__init__.py", line 88, in Connect 2016-11-03 11:56:35.004 4260 ERROR keystone return Connection(args, *kwargs) 2016-11-03 11:56:35.004 4260 ERROR keystone File "/usr/lib/python2.7/dist-packages/pymysql/connections.py", line 679, in __init__ 2016-11-03 11:56:35.004 4260 ERROR keystone self.connect() 2016-11-03 11:56:35.004 4260 ERROR keystone File "/usr/lib/python2.7/dist-packages/pymysql/connections.py", line 891, in connect 2016-11-03 11:56:35.004 4260 ERROR keystone self._request_authentication() 2016-11-03 11:56:35.004 4260 ERROR keystone File "/usr/lib/python2.7/dist-packages/pymysql/connections.py", line 1097, in _request_authentication 2016-11-03 11:56:35.004 4260 ERROR keystone auth_packet = self._read_packet() 2016-11-03 11:56:35.004 4260 ERROR keystone File "/usr/lib/python2.7/dist-packages/pymysql/connections.py", line 966, in _read_packet 2016-11-03 11:56:35.004 4260 ERROR keystone packet.check_error() 2016-11-03 11:56:35.004 4260 ERROR keystone File "/usr/lib/python2.7/dist-packages/pymysql/connections.py", line 394, in check_error 2016-11-03 11:56:35.004 4260 ERROR keystone err.raise_mysql_exception(self._data) 2016-11-03 11:56:35.004 4260 ERROR keystone File "/usr/lib/python2.7/dist-packages/pymysql/err.py", line 120, in raise_mysql_exception 2016-11-03 11:56:35.004 4260 ERROR keystone _check_mysql_exception(errinfo) 2016-11-03 11:56:35.004 4260 ERROR keystone File "/usr/lib/python2.7/dist-packages/pymysql/err.py", line 112, in _check_mysql_exception 2016-11-03 11:56:35.004 4260 ERROR keystone raise errorclass(errno, errorvalue) 2016-11-03 11:56:35.004 4260 ERROR keystone OperationalError: (pymysql.err.OperationalError) (1045, u"Access denied for user 'keystone'@'oschncontroller' (using password: YES)") 2016-11-03 11:56:35.004 4260 ERROR keystone root@oschncontroller:/home/chncontroller#

Tried setting up openstack using newton release in ubuntu 16.04 and getting the below error while setting up user privileges for the keystone error,

root@oschncontroller:/home/chncontroller# su -s /bin/sh -c "keystone-manage db_sync" keystone
2016-11-03 11:56:35.004 4260 CRITICAL keystone [-] OperationalError: (pymysql.err.OperationalError) (1045, u"Access denied for user 'keystone'@'oschncontroller' (using password: YES)")
2016-11-03 11:56:35.004 4260 ERROR keystone Traceback (most recent call last):
2016-11-03 11:56:35.004 4260 ERROR keystone   File "/usr/bin/keystone-manage", line 10, in <module>
2016-11-03 11:56:35.004 4260 ERROR keystone     sys.exit(main())
2016-11-03 11:56:35.004 4260 ERROR keystone   File "/usr/lib/python2.7/dist-packages/keystone/cmd/manage.py", line 44, in main
2016-11-03 11:56:35.004 4260 ERROR keystone     cli.main(argv=sys.argv, config_files=config_files)
2016-11-03 11:56:35.004 4260 ERROR keystone   File "/usr/lib/python2.7/dist-packages/keystone/cmd/cli.py", line 1254, in main
2016-11-03 11:56:35.004 4260 ERROR keystone     CONF.command.cmd_class.main()
2016-11-03 11:56:35.004 4260 ERROR keystone   File "/usr/lib/python2.7/dist-packages/keystone/cmd/cli.py", line 445, in main
2016-11-03 11:56:35.004 4260 ERROR keystone     CONF.command.version)
2016-11-03 11:56:35.004 4260 ERROR keystone   File "/usr/lib/python2.7/dist-packages/keystone/common/sql/migration_helpers.py", line 207, in offline_sync_database_to_version
2016-11-03 11:56:35.004 4260 ERROR keystone     expand_schema()
2016-11-03 11:56:35.004 4260 ERROR keystone   File "/usr/lib/python2.7/dist-packages/keystone/common/sql/migration_helpers.py", line 232, in expand_schema
2016-11-03 11:56:35.004 4260 ERROR keystone     _sync_common_repo(version=None)
2016-11-03 11:56:35.004 4260 ERROR keystone   File "/usr/lib/python2.7/dist-packages/keystone/common/sql/migration_helpers.py", line 123, in _sync_common_repo
2016-11-03 11:56:35.004 4260 ERROR keystone     with sql.session_for_write() as session:
2016-11-03 11:56:35.004 4260 ERROR keystone   File "/usr/lib/python2.7/contextlib.py", line 17, in __enter__
2016-11-03 11:56:35.004 4260 ERROR keystone     return self.gen.next()
2016-11-03 11:56:35.004 4260 ERROR keystone   File "/usr/lib/python2.7/dist-packages/oslo_db/sqlalchemy/enginefacade.py", line 874, in _transaction_scope
2016-11-03 11:56:35.004 4260 ERROR keystone     allow_async=self._allow_async) as resource:
2016-11-03 11:56:35.004 4260 ERROR keystone   File "/usr/lib/python2.7/contextlib.py", line 17, in __enter__
2016-11-03 11:56:35.004 4260 ERROR keystone     return self.gen.next()
2016-11-03 11:56:35.004 4260 ERROR keystone   File "/usr/lib/python2.7/dist-packages/oslo_db/sqlalchemy/enginefacade.py", line 518, in _session
2016-11-03 11:56:35.004 4260 ERROR keystone     bind=self.connection, mode=self.mode)
2016-11-03 11:56:35.004 4260 ERROR keystone   File "/usr/lib/python2.7/dist-packages/oslo_db/sqlalchemy/enginefacade.py", line 277, in _create_session
2016-11-03 11:56:35.004 4260 ERROR keystone     self._start()
2016-11-03 11:56:35.004 4260 ERROR keystone   File "/usr/lib/python2.7/dist-packages/oslo_db/sqlalchemy/enginefacade.py", line 363, in _start
2016-11-03 11:56:35.004 4260 ERROR keystone     engine_args, maker_args)
2016-11-03 11:56:35.004 4260 ERROR keystone   File "/usr/lib/python2.7/dist-packages/oslo_db/sqlalchemy/enginefacade.py", line 387, in _setup_for_connection
2016-11-03 11:56:35.004 4260 ERROR keystone     sql_connection=sql_connection, *engine_kwargs)
**engine_kwargs)
2016-11-03 11:56:35.004 4260 ERROR keystone   File "/usr/lib/python2.7/dist-packages/oslo_db/sqlalchemy/engines.py", line 155, in create_engine
2016-11-03 11:56:35.004 4260 ERROR keystone     test_conn = _test_connection(engine, max_retries, retry_interval)
2016-11-03 11:56:35.004 4260 ERROR keystone   File "/usr/lib/python2.7/dist-packages/oslo_db/sqlalchemy/engines.py", line 331, in _test_connection
2016-11-03 11:56:35.004 4260 ERROR keystone     return engine.connect()
2016-11-03 11:56:35.004 4260 ERROR keystone   File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 2018, in connect
2016-11-03 11:56:35.004 4260 ERROR keystone     return self._connection_cls(self, *kwargs)
**kwargs)
2016-11-03 11:56:35.004 4260 ERROR keystone   File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 72, in __init__
2016-11-03 11:56:35.004 4260 ERROR keystone     if connection is not None else engine.raw_connection()
2016-11-03 11:56:35.004 4260 ERROR keystone   File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 2104, in raw_connection
2016-11-03 11:56:35.004 4260 ERROR keystone     self.pool.unique_connection, _connection)
2016-11-03 11:56:35.004 4260 ERROR keystone   File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 2078, in _wrap_pool_connect
2016-11-03 11:56:35.004 4260 ERROR keystone     e, dialect, self)
2016-11-03 11:56:35.004 4260 ERROR keystone   File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1401, in _handle_dbapi_exception_noconnection
2016-11-03 11:56:35.004 4260 ERROR keystone     util.raise_from_cause(newraise, exc_info)
2016-11-03 11:56:35.004 4260 ERROR keystone   File "/usr/lib/python2.7/dist-packages/sqlalchemy/util/compat.py", line 200, in raise_from_cause
2016-11-03 11:56:35.004 4260 ERROR keystone     reraise(type(exception), exception, tb=exc_tb)
2016-11-03 11:56:35.004 4260 ERROR keystone   File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 2074, in _wrap_pool_connect
2016-11-03 11:56:35.004 4260 ERROR keystone     return fn()
2016-11-03 11:56:35.004 4260 ERROR keystone   File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 318, in unique_connection
2016-11-03 11:56:35.004 4260 ERROR keystone     return _ConnectionFairy._checkout(self)
2016-11-03 11:56:35.004 4260 ERROR keystone   File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 713, in _checkout
2016-11-03 11:56:35.004 4260 ERROR keystone     fairy = _ConnectionRecord.checkout(pool)
2016-11-03 11:56:35.004 4260 ERROR keystone   File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 480, in checkout
2016-11-03 11:56:35.004 4260 ERROR keystone     rec = pool._do_get()
2016-11-03 11:56:35.004 4260 ERROR keystone   File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 1060, in _do_get
2016-11-03 11:56:35.004 4260 ERROR keystone     self._dec_overflow()
2016-11-03 11:56:35.004 4260 ERROR keystone   File "/usr/lib/python2.7/dist-packages/sqlalchemy/util/langhelpers.py", line 60, in __exit__
2016-11-03 11:56:35.004 4260 ERROR keystone     compat.reraise(exc_type, exc_value, exc_tb)
2016-11-03 11:56:35.004 4260 ERROR keystone   File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 1057, in _do_get
2016-11-03 11:56:35.004 4260 ERROR keystone     return self._create_connection()
2016-11-03 11:56:35.004 4260 ERROR keystone   File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 323, in _create_connection
2016-11-03 11:56:35.004 4260 ERROR keystone     return _ConnectionRecord(self)
2016-11-03 11:56:35.004 4260 ERROR keystone   File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 449, in __init__
2016-11-03 11:56:35.004 4260 ERROR keystone     self.connection = self.__connect()
2016-11-03 11:56:35.004 4260 ERROR keystone   File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 607, in __connect
2016-11-03 11:56:35.004 4260 ERROR keystone     connection = self.__pool._invoke_creator(self)
2016-11-03 11:56:35.004 4260 ERROR keystone   File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/strategies.py", line 97, in connect
2016-11-03 11:56:35.004 4260 ERROR keystone     return dialect.connect(cargs, *cparams)
dialect.connect(*cargs, **cparams)
2016-11-03 11:56:35.004 4260 ERROR keystone   File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 385, in connect
2016-11-03 11:56:35.004 4260 ERROR keystone     return self.dbapi.connect(cargs, *cparams)
self.dbapi.connect(*cargs, **cparams)
2016-11-03 11:56:35.004 4260 ERROR keystone   File "/usr/lib/python2.7/dist-packages/pymysql/__init__.py", line 88, in Connect
2016-11-03 11:56:35.004 4260 ERROR keystone     return Connection(args, *kwargs)
Connection(*args, **kwargs)
2016-11-03 11:56:35.004 4260 ERROR keystone   File "/usr/lib/python2.7/dist-packages/pymysql/connections.py", line 679, in __init__
2016-11-03 11:56:35.004 4260 ERROR keystone     self.connect()
2016-11-03 11:56:35.004 4260 ERROR keystone   File "/usr/lib/python2.7/dist-packages/pymysql/connections.py", line 891, in connect
2016-11-03 11:56:35.004 4260 ERROR keystone     self._request_authentication()
2016-11-03 11:56:35.004 4260 ERROR keystone   File "/usr/lib/python2.7/dist-packages/pymysql/connections.py", line 1097, in _request_authentication
2016-11-03 11:56:35.004 4260 ERROR keystone     auth_packet = self._read_packet()
2016-11-03 11:56:35.004 4260 ERROR keystone   File "/usr/lib/python2.7/dist-packages/pymysql/connections.py", line 966, in _read_packet
2016-11-03 11:56:35.004 4260 ERROR keystone     packet.check_error()
2016-11-03 11:56:35.004 4260 ERROR keystone   File "/usr/lib/python2.7/dist-packages/pymysql/connections.py", line 394, in check_error
2016-11-03 11:56:35.004 4260 ERROR keystone     err.raise_mysql_exception(self._data)
2016-11-03 11:56:35.004 4260 ERROR keystone   File "/usr/lib/python2.7/dist-packages/pymysql/err.py", line 120, in raise_mysql_exception
2016-11-03 11:56:35.004 4260 ERROR keystone     _check_mysql_exception(errinfo)
2016-11-03 11:56:35.004 4260 ERROR keystone   File "/usr/lib/python2.7/dist-packages/pymysql/err.py", line 112, in _check_mysql_exception
2016-11-03 11:56:35.004 4260 ERROR keystone     raise errorclass(errno, errorvalue)
2016-11-03 11:56:35.004 4260 ERROR keystone OperationalError: (pymysql.err.OperationalError) (1045, u"Access denied for user 'keystone'@'oschncontroller' (using password: YES)")
2016-11-03 11:56:35.004 4260 ERROR keystone
root@oschncontroller:/home/chncontroller#

root@oschncontroller:/home/chncontroller#