Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

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

After installing MySQL db, proceeded with steps mentioned in the below page,

http://docs.openstack.org/liberty/install-guide-ubuntu/keystone-install.html#prerequisites

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:42:18.888 26932 ERROR keystone engine_args, maker_args) 2016-10-24 13:42:18.888 26932 ERROR keystone File "/usr/lib/python2.7/dist-packages/oslo_db/sqlalchemy/enginefacade.py", line 362, in _setup_for_connection 2016-10-24 13:42:18.888 26932 ERROR keystone sql_connection=sql_connection, *engine_kwargs) 2016-10-24 13:42:18.888 26932 ERROR keystone File "/usr/lib/python2.7/dist-packages/oslo_db/sqlalchemy/engines.py", line 128, in create_engine 2016-10-24 13:42:18.888 26932 ERROR keystone pool_timeout=pool_timeout 2016-10-24 13:42:18.888 26932 ERROR keystone File "/usr/lib/python2.7/dist-packages/oslo_db/sqlalchemy/utils.py", line 913, in __call__ 2016-10-24 13:42:18.888 26932 ERROR keystone self._url_from_target(target), target, arg, kw) 2016-10-24 13:42:18.888 26932 ERROR keystone File "/usr/lib/python2.7/dist-packages/oslo_db/sqlalchemy/utils.py", line 950, in _dispatch_on 2016-10-24 13:42:18.888 26932 ERROR keystone return self._dispatch_on_db_driver(dbname, driver, arg, kw) 2016-10-24 13:42:18.888 26932 ERROR keystone File "/usr/lib/python2.7/dist-packages/oslo_db/sqlalchemy/utils.py", line 1004, in _dispatch_on_db_driver 2016-10-24 13:42:18.888 26932 ERROR keystone if self._invoke_fn(fn, arg, kw) is not None: 2016-10-24 13:42:18.888 26932 ERROR keystone File "/usr/lib/python2.7/dist-packages/oslo_db/sqlalchemy/utils.py", line 953, in _invoke_fn 2016-10-24 13:42:18.888 26932 ERROR keystone return fn(arg, *kw) 2016-10-24 13:42:18.888 26932 ERROR keystone File "/usr/lib/python2.7/dist-packages/oslo_db/sqlalchemy/engines.py", line 163, in _init_connection_args 2016-10-24 13:42:18.888 26932 ERROR keystone pool_class = url.get_dialect().get_pool_class(url) 2016-10-24 13:42:18.888 26932 ERROR keystone File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/url.py", line 146, in get_dialect 2016-10-24 13:42:18.888 26932 ERROR keystone entrypoint = self._get_entrypoint() 2016-10-24 13:42:18.888 26932 ERROR keystone File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/url.py", line 131, in _get_entrypoint 2016-10-24 13:42:18.888 26932 ERROR keystone cls = registry.load(name) 2016-10-24 13:42:18.888 26932 ERROR keystone File "/usr/lib/python2.7/dist-packages/sqlalchemy/util/langhelpers.py", line 205, in load 2016-10-24 13:42:18.888 26932 ERROR keystone (self.group, name)) 2016-10-24 13:42:18.888 26932 ERROR keystone NoSuchModuleError: Can't load plugin: sqlalchemy.dialects:ql.pymysql 2016-10-24 13:42:18.888 26932 ERROR keystone*

Please let me know how to proceed further on this.