Keystone error : CRITICAL keystone [-] NoSuchModuleError: Can't load plugin: sqlalchemy.dialects:ql.pymysql
OS team,
Trying to setup dashboard service which inturn requires keystone + identiy service and hence followed the below instructions to install openstack packages,
http://docs.openstack.org/liberty/install-guide-ubuntu/environment-packages.html (http://docs.openstack.org/liberty/ins...)
After installing MySQL db, proceeded with steps mentioned in the below page,
http://docs.openstack.org/liberty/install-guide-ubuntu/keystone-install.html#prerequisites (http://docs.openstack.org/liberty/ins...)
Step 4 in the above page says,
Populate the Identity service database:
su -s /bin/sh -c "keystone-manage db_sync" keystone
AFter executing the above step, getting error like,
~~~ ERROR LOG ~~~~
su -s /bin/sh -c "keystone-manage db_sync" keystone No handlers could be found for logger "oslo_config.cfg" 2016-10-24 13:42:18.888 26932 CRITICAL keystone [-] NoSuchModuleError: Can't load plugin: sqlalchemy.dialects:ql.pymysql 2016-10-24 13:42:18.888 26932 ERROR keystone Traceback (most recent call last): 2016-10-24 13:42:18.888 26932 ERROR keystone File "/usr/bin/keystone-manage", line 10, in <module> 2016-10-24 13:42:18.888 26932 ERROR keystone sys.exit(main()) 2016-10-24 13:42:18.888 26932 ERROR keystone File "/usr/lib/python2.7/dist-packages/keystone/cmd/manage.py", line 47, in main 2016-10-24 13:42:18.888 26932 ERROR keystone cli.main(argv=sys.argv, config_files=config_files) 2016-10-24 13:42:18.888 26932 ERROR keystone File "/usr/lib/python2.7/dist-packages/keystone/cmd/cli.py", line 685, in main 2016-10-24 13:42:18.888 26932 ERROR keystone CONF.command.cmd_class.main() 2016-10-24 13:42:18.888 26932 ERROR keystone File "/usr/lib/python2.7/dist-packages/keystone/cmd/cli.py", line 77, in main 2016-10-24 13:42:18.888 26932 ERROR keystone migration_helpers.sync_database_to_version(extension, version) 2016-10-24 13:42:18.888 26932 ERROR keystone File "/usr/lib/python2.7/dist-packages/keystone/common/sql/migration_helpers.py", line 194, in sync_database_to_version 2016-10-24 13:42:18.888 26932 ERROR keystone _sync_common_repo(version) 2016-10-24 13:42:18.888 26932 ERROR keystone File "/usr/lib/python2.7/dist-packages/keystone/common/sql/migration_helpers.py", line 145, in _sync_common_repo 2016-10-24 13:42:18.888 26932 ERROR keystone engine = sql.get_engine() 2016-10-24 13:42:18.888 26932 ERROR keystone File "/usr/lib/python2.7/dist-packages/keystone/common/sql/core.py", line 188, in get_engine 2016-10-24 13:42:18.888 26932 ERROR keystone return _get_engine_facade().get_engine() 2016-10-24 13:42:18.888 26932 ERROR keystone File "/usr/lib/python2.7/dist-packages/keystone/common/sql/core.py", line 176, in _get_engine_facade 2016-10-24 13:42:18.888 26932 ERROR keystone _engine_facade = db_session.EngineFacade.from_config(CONF) 2016-10-24 13:42:18.888 26932 ERROR keystone File "/usr/lib/python2.7/dist-packages/oslo_db/sqlalchemy/enginefacade.py", line 1015, in from_config 2016-10-24 13:42:18.888 26932 ERROR keystone expire_on_commit=expire_on_commit, _conf=conf) 2016-10-24 13:42:18.888 26932 ERROR keystone File "/usr/lib/python2.7/dist-packages/oslo_db/sqlalchemy/enginefacade.py", line 943, in __init__ 2016-10-24 13:42:18.888 26932 ERROR keystone slave_connection=slave_connection) 2016-10-24 13:42:18.888 26932 ERROR keystone File "/usr/lib/python2.7/dist-packages/oslo_db/sqlalchemy/enginefacade.py", line 338, in _start 2016-10-24 13 ...
First, an unrelated question: Why Liberty? Newton was just released.
Regarding the error, my guess is that something when wrong when you installed pymysql:
Thanks for the reply. Will use newton release.
About that apt-get package install, apt-get didn't report a problem after the installation and installation was successful.
Hi I am getting the same module error with Queens release. How to solve this ?