yahoo-eng-team team mailing list archive
-
yahoo-eng-team team
-
Mailing list archive
-
Message #75859
[Bug 1804510] [NEW] mysql_exceptions_OperationalError, "Authentication plugin 'caching_sha2_password' cannot be loaded:
Public bug reported:
Description
===========
I am following this link (https://docs.openstack.org/install-guide) to install the openstack Rocky release and successfully installed the all prerequisite.
I successfully configure the Keystone service now moving forward to compute service that is NOVA and I am following this link (https://docs.openstack.org/nova/rocky/install/compute-install-rdo.html) to configure the NOVA on controller node.
When I ran this command from root user
# /bin/sh -c "nova-manage api_db sync" nova
I got this error
/usr/lib/python2.7/site-packages/pymysql/cursors.py:170: Warning: (3719, u"'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.")
result = self._query(query)
An error has occurred:
Traceback (most recent call last):
File "/usr/lib/python2.7/site-packages/nova/cmd/manage.py", line 2310, in main
ret = fn(*fn_args, **fn_kwargs)
File "/usr/lib/python2.7/site-packages/nova/cmd/manage.py", line 866, in sync
return migration.db_sync(version2, database='api') and result
File "/usr/lib/python2.7/site-packages/nova/db/migration.py", line 26, in db_sync
return IMPL.db_sync(version=version, database=database, context=context)
File "/usr/lib/python2.7/site-packages/nova/db/sqlalchemy/migration.py", line 57, in db_sync
current_version = db_version(database, context=context)
File "/usr/lib/python2.7/site-packages/nova/db/sqlalchemy/migration.py", line 70, in db_version
return versioning_api.db_version(get_engine(database, context=context),
File "/usr/lib/python2.7/site-packages/nova/db/sqlalchemy/migration.py", line 45, in get_engine
return db_session.get_api_engine()
File "/usr/lib/python2.7/site-packages/nova/db/sqlalchemy/api.py", line 141, in get_api_engine
return api_context_manager.get_legacy_facade().get_engine()
File "/usr/lib/python2.7/site-packages/oslo_db/sqlalchemy/enginefacade.py", line 803, in get_legacy_facade
return self._factory.get_legacy_facade()
File "/usr/lib/python2.7/site-packages/oslo_db/sqlalchemy/enginefacade.py", line 352, in get_legacy_facade
self._start()
File "/usr/lib/python2.7/site-packages/oslo_db/sqlalchemy/enginefacade.py", line 496, in _start
engine_args, maker_args)
File "/usr/lib/python2.7/site-packages/oslo_db/sqlalchemy/enginefacade.py", line 520, in _setup_for_connection
sql_connection=sql_connection, **engine_kwargs)
File "/usr/lib/python2.7/site-packages/debtcollector/renames.py", line 43, in decorator
return wrapped(*args, **kwargs)
File "/usr/lib/python2.7/site-packages/oslo_db/sqlalchemy/engines.py", line 202, in create_engine
test_conn = _test_connection(engine, max_retries, retry_interval)
File "/usr/lib/python2.7/site-packages/oslo_db/sqlalchemy/engines.py", line 380, in _test_connection
return engine.connect()
File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 2102, in connect
return self._connection_cls(self, **kwargs)
File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 90, in __init__
if connection is not None else engine.raw_connection()
File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 2188, in raw_connection
self.pool.unique_connection, _connection)
File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 2162, in _wrap_pool_connect
e, dialect, self)
File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1472, in _handle_dbapi_exception_noconnection
util.raise_from_cause(newraise, exc_info)
File "/usr/lib64/python2.7/site-packages/sqlalchemy/util/compat.py", line 203, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb, cause=cause)
File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 2158, in _wrap_pool_connect
return fn()
File "/usr/lib64/python2.7/site-packages/sqlalchemy/pool.py", line 345, in unique_connection
return _ConnectionFairy._checkout(self)
File "/usr/lib64/python2.7/site-packages/sqlalchemy/pool.py", line 788, in _checkout
fairy = _ConnectionRecord.checkout(pool)
File "/usr/lib64/python2.7/site-packages/sqlalchemy/pool.py", line 532, in checkout
rec = pool._do_get()
File "/usr/lib64/python2.7/site-packages/sqlalchemy/pool.py", line 1193, in _do_get
self._dec_overflow()
File "/usr/lib64/python2.7/site-packages/sqlalchemy/util/langhelpers.py", line 66, in __exit__
compat.reraise(exc_type, exc_value, exc_tb)
File "/usr/lib64/python2.7/site-packages/sqlalchemy/pool.py", line 1190, in _do_get
return self._create_connection()
File "/usr/lib64/python2.7/site-packages/sqlalchemy/pool.py", line 350, in _create_connection
return _ConnectionRecord(self)
File "/usr/lib64/python2.7/site-packages/sqlalchemy/pool.py", line 477, in __init__
self.__connect(first_connect_check=True)
File "/usr/lib64/python2.7/site-packages/sqlalchemy/pool.py", line 671, in __connect
connection = pool._invoke_creator(self)
File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/strategies.py", line 106, in connect
return dialect.connect(*cargs, **cparams)
File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/default.py", line 410, in connect
return self.dbapi.connect(*cargs, **cparams)
File "/usr/lib64/python2.7/site-packages/MySQLdb/__init__.py", line 81, in Connect
return Connection(*args, **kwargs)
File "/usr/lib64/python2.7/site-packages/MySQLdb/connections.py", line 193, in __init__
super(Connection, self).__init__(*args, **kwargs2)
OperationalError: (_mysql_exceptions.OperationalError) (2059, "Authentication plugin 'caching_sha2_password' cannot be loaded: /usr/lib64/mysql/plugin/caching_sha2_password.so: cannot open shared object file: No such file or directory") (Background on this error at: http://sqlalche.me/e/e3q8)
###################Environment#########
# cat /etc/redhat-release
CentOS Linux release 7.5.1804 (Core)
# uname -a
Linux controller 3.10.0-862.14.4.el7.x86_64 #1 SMP Wed Sep 26 15:12:11 UTC 2018 x86_64 x86_64 x86_64 GNU/Linux
# yum list all | grep nova
openstack-nova.noarch 1:18.0.2-1.el7 @centos-openstack-rocky
openstack-nova-api.noarch 1:18.0.2-1.el7 @centos-openstack-rocky
openstack-nova-cells.noarch 1:18.0.2-1.el7 @centos-openstack-rocky
openstack-nova-common.noarch 1:18.0.2-1.el7 @centos-openstack-rocky
openstack-nova-compute.noarch 1:18.0.2-1.el7 @centos-openstack-rocky
openstack-nova-conductor.noarch 1:18.0.2-1.el7 @centos-openstack-rocky
openstack-nova-console.noarch 1:18.0.2-1.el7 @centos-openstack-rocky
openstack-nova-migration.noarch 1:18.0.2-1.el7 @centos-openstack-rocky
openstack-nova-network.noarch 1:18.0.2-1.el7 @centos-openstack-rocky
openstack-nova-novncproxy.noarch 1:18.0.2-1.el7 @centos-openstack-rocky
openstack-nova-placement-api.noarch 1:18.0.2-1.el7 @centos-openstack-rocky
openstack-nova-scheduler.noarch 1:18.0.2-1.el7 @centos-openstack-rocky
puppet-nova.noarch 13.3.1-1.el7 @centos-openstack-rocky
python-nova.noarch 1:18.0.2-1.el7 @centos-openstack-rocky
python2-novaclient.noarch 1:11.0.0-1.el7 @centos-openstack-rocky
libnova.x86_64 0.15.0-4.el7 epel
libnova-devel.x86_64 0.15.0-4.el7 epel
nova-agent.noarch 2.1.18-1.el7 epel
openstack-nova-doc.noarch 1:17.0.7-1.el7 openstack-queens
openstack-nova-serialproxy.noarch 1:18.0.2-1.el7 centos-openstack-rocky
openstack-nova-spicehtml5proxy.noarch 1:18.0.2-1.el7 centos-openstack-rocky
python-nova-tests.noarch 1:18.0.2-1.el7 centos-openstack-rocky
python-novaclient-doc.noarch 1:11.0.0-1.el7 centos-openstack-rocky
python-novajoin.noarch 1.0.19-1.el7 centos-openstack-rocky
python-novajoin-doc.noarch 1.0.19-1.el7 centos-openstack-rocky
python-novajoin-tests-tempest-doc.noarch 0.0.1-0.2.f657712git.el7 centos-openstack-rocky
python-novajoin-tests-unit.noarch 1.0.19-1.el7 centos-openstack-rocky
python2-novajoin-tests-tempest.noarch 0.0.1-0.2.f657712git.el7 centos-openstack-rocky
Q.Which hypervisor did you use?
libvirt+KVM
# lvm version
LVM version: 2.02.177(2)-RHEL7 (2018-01-22)
Library version: 1.02.146-RHEL7 (2018-01-22)
Driver version: 4.37.1
** Affects: nova
Importance: Undecided
Status: New
--
You received this bug notification because you are a member of Yahoo!
Engineering Team, which is subscribed to OpenStack Compute (nova).
https://bugs.launchpad.net/bugs/1804510
Title:
mysql_exceptions_OperationalError, "Authentication plugin
'caching_sha2_password' cannot be loaded:
Status in OpenStack Compute (nova):
New
Bug description:
Description
===========
I am following this link (https://docs.openstack.org/install-guide) to install the openstack Rocky release and successfully installed the all prerequisite.
I successfully configure the Keystone service now moving forward to compute service that is NOVA and I am following this link (https://docs.openstack.org/nova/rocky/install/compute-install-rdo.html) to configure the NOVA on controller node.
When I ran this command from root user
# /bin/sh -c "nova-manage api_db sync" nova
I got this error
/usr/lib/python2.7/site-packages/pymysql/cursors.py:170: Warning: (3719, u"'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.")
result = self._query(query)
An error has occurred:
Traceback (most recent call last):
File "/usr/lib/python2.7/site-packages/nova/cmd/manage.py", line 2310, in main
ret = fn(*fn_args, **fn_kwargs)
File "/usr/lib/python2.7/site-packages/nova/cmd/manage.py", line 866, in sync
return migration.db_sync(version2, database='api') and result
File "/usr/lib/python2.7/site-packages/nova/db/migration.py", line 26, in db_sync
return IMPL.db_sync(version=version, database=database, context=context)
File "/usr/lib/python2.7/site-packages/nova/db/sqlalchemy/migration.py", line 57, in db_sync
current_version = db_version(database, context=context)
File "/usr/lib/python2.7/site-packages/nova/db/sqlalchemy/migration.py", line 70, in db_version
return versioning_api.db_version(get_engine(database, context=context),
File "/usr/lib/python2.7/site-packages/nova/db/sqlalchemy/migration.py", line 45, in get_engine
return db_session.get_api_engine()
File "/usr/lib/python2.7/site-packages/nova/db/sqlalchemy/api.py", line 141, in get_api_engine
return api_context_manager.get_legacy_facade().get_engine()
File "/usr/lib/python2.7/site-packages/oslo_db/sqlalchemy/enginefacade.py", line 803, in get_legacy_facade
return self._factory.get_legacy_facade()
File "/usr/lib/python2.7/site-packages/oslo_db/sqlalchemy/enginefacade.py", line 352, in get_legacy_facade
self._start()
File "/usr/lib/python2.7/site-packages/oslo_db/sqlalchemy/enginefacade.py", line 496, in _start
engine_args, maker_args)
File "/usr/lib/python2.7/site-packages/oslo_db/sqlalchemy/enginefacade.py", line 520, in _setup_for_connection
sql_connection=sql_connection, **engine_kwargs)
File "/usr/lib/python2.7/site-packages/debtcollector/renames.py", line 43, in decorator
return wrapped(*args, **kwargs)
File "/usr/lib/python2.7/site-packages/oslo_db/sqlalchemy/engines.py", line 202, in create_engine
test_conn = _test_connection(engine, max_retries, retry_interval)
File "/usr/lib/python2.7/site-packages/oslo_db/sqlalchemy/engines.py", line 380, in _test_connection
return engine.connect()
File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 2102, in connect
return self._connection_cls(self, **kwargs)
File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 90, in __init__
if connection is not None else engine.raw_connection()
File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 2188, in raw_connection
self.pool.unique_connection, _connection)
File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 2162, in _wrap_pool_connect
e, dialect, self)
File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1472, in _handle_dbapi_exception_noconnection
util.raise_from_cause(newraise, exc_info)
File "/usr/lib64/python2.7/site-packages/sqlalchemy/util/compat.py", line 203, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb, cause=cause)
File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 2158, in _wrap_pool_connect
return fn()
File "/usr/lib64/python2.7/site-packages/sqlalchemy/pool.py", line 345, in unique_connection
return _ConnectionFairy._checkout(self)
File "/usr/lib64/python2.7/site-packages/sqlalchemy/pool.py", line 788, in _checkout
fairy = _ConnectionRecord.checkout(pool)
File "/usr/lib64/python2.7/site-packages/sqlalchemy/pool.py", line 532, in checkout
rec = pool._do_get()
File "/usr/lib64/python2.7/site-packages/sqlalchemy/pool.py", line 1193, in _do_get
self._dec_overflow()
File "/usr/lib64/python2.7/site-packages/sqlalchemy/util/langhelpers.py", line 66, in __exit__
compat.reraise(exc_type, exc_value, exc_tb)
File "/usr/lib64/python2.7/site-packages/sqlalchemy/pool.py", line 1190, in _do_get
return self._create_connection()
File "/usr/lib64/python2.7/site-packages/sqlalchemy/pool.py", line 350, in _create_connection
return _ConnectionRecord(self)
File "/usr/lib64/python2.7/site-packages/sqlalchemy/pool.py", line 477, in __init__
self.__connect(first_connect_check=True)
File "/usr/lib64/python2.7/site-packages/sqlalchemy/pool.py", line 671, in __connect
connection = pool._invoke_creator(self)
File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/strategies.py", line 106, in connect
return dialect.connect(*cargs, **cparams)
File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/default.py", line 410, in connect
return self.dbapi.connect(*cargs, **cparams)
File "/usr/lib64/python2.7/site-packages/MySQLdb/__init__.py", line 81, in Connect
return Connection(*args, **kwargs)
File "/usr/lib64/python2.7/site-packages/MySQLdb/connections.py", line 193, in __init__
super(Connection, self).__init__(*args, **kwargs2)
OperationalError: (_mysql_exceptions.OperationalError) (2059, "Authentication plugin 'caching_sha2_password' cannot be loaded: /usr/lib64/mysql/plugin/caching_sha2_password.so: cannot open shared object file: No such file or directory") (Background on this error at: http://sqlalche.me/e/e3q8)
###################Environment#########
# cat /etc/redhat-release
CentOS Linux release 7.5.1804 (Core)
# uname -a
Linux controller 3.10.0-862.14.4.el7.x86_64 #1 SMP Wed Sep 26 15:12:11 UTC 2018 x86_64 x86_64 x86_64 GNU/Linux
# yum list all | grep nova
openstack-nova.noarch 1:18.0.2-1.el7 @centos-openstack-rocky
openstack-nova-api.noarch 1:18.0.2-1.el7 @centos-openstack-rocky
openstack-nova-cells.noarch 1:18.0.2-1.el7 @centos-openstack-rocky
openstack-nova-common.noarch 1:18.0.2-1.el7 @centos-openstack-rocky
openstack-nova-compute.noarch 1:18.0.2-1.el7 @centos-openstack-rocky
openstack-nova-conductor.noarch 1:18.0.2-1.el7 @centos-openstack-rocky
openstack-nova-console.noarch 1:18.0.2-1.el7 @centos-openstack-rocky
openstack-nova-migration.noarch 1:18.0.2-1.el7 @centos-openstack-rocky
openstack-nova-network.noarch 1:18.0.2-1.el7 @centos-openstack-rocky
openstack-nova-novncproxy.noarch 1:18.0.2-1.el7 @centos-openstack-rocky
openstack-nova-placement-api.noarch 1:18.0.2-1.el7 @centos-openstack-rocky
openstack-nova-scheduler.noarch 1:18.0.2-1.el7 @centos-openstack-rocky
puppet-nova.noarch 13.3.1-1.el7 @centos-openstack-rocky
python-nova.noarch 1:18.0.2-1.el7 @centos-openstack-rocky
python2-novaclient.noarch 1:11.0.0-1.el7 @centos-openstack-rocky
libnova.x86_64 0.15.0-4.el7 epel
libnova-devel.x86_64 0.15.0-4.el7 epel
nova-agent.noarch 2.1.18-1.el7 epel
openstack-nova-doc.noarch 1:17.0.7-1.el7 openstack-queens
openstack-nova-serialproxy.noarch 1:18.0.2-1.el7 centos-openstack-rocky
openstack-nova-spicehtml5proxy.noarch 1:18.0.2-1.el7 centos-openstack-rocky
python-nova-tests.noarch 1:18.0.2-1.el7 centos-openstack-rocky
python-novaclient-doc.noarch 1:11.0.0-1.el7 centos-openstack-rocky
python-novajoin.noarch 1.0.19-1.el7 centos-openstack-rocky
python-novajoin-doc.noarch 1.0.19-1.el7 centos-openstack-rocky
python-novajoin-tests-tempest-doc.noarch 0.0.1-0.2.f657712git.el7 centos-openstack-rocky
python-novajoin-tests-unit.noarch 1.0.19-1.el7 centos-openstack-rocky
python2-novajoin-tests-tempest.noarch 0.0.1-0.2.f657712git.el7 centos-openstack-rocky
Q.Which hypervisor did you use?
libvirt+KVM
# lvm version
LVM version: 2.02.177(2)-RHEL7 (2018-01-22)
Library version: 1.02.146-RHEL7 (2018-01-22)
Driver version: 4.37.1
To manage notifications about this bug go to:
https://bugs.launchpad.net/nova/+bug/1804510/+subscriptions
Follow ups
