Ask Your Question
0

Keystone error : CRITICAL keystone [-] NoSuchModuleError: Can't load plugin: sqlalchemy.dialects:ql.pymysql

asked 2016-10-25 04:56:45 -0600

vspvijay gravatar image

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 ... (more)

edit retag flag offensive close merge delete

Comments

First, an unrelated question: Why Liberty? Newton was just released.

Regarding the error, my guess is that something when wrong when you installed pymysql:

# apt-get install mariadb-server python-pymysql
Bernd Bausch gravatar imageBernd Bausch ( 2016-10-27 23:08:18 -0600 )edit

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.

vspvijay gravatar imagevspvijay ( 2016-10-28 03:30:59 -0600 )edit

Hi I am getting the same module error with Queens release. How to solve this ?

VarunNair gravatar imageVarunNair ( 2018-07-19 05:04:02 -0600 )edit
add a comment

1 answer

Sort by ยป oldest newest most voted
0

answered 2016-11-03 06:34:12 -0600

vspvijay gravatar image

updated 2016-11-05 02:17:20 -0600

Bernd Bausch gravatar image

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 ...
(more)
edit flag offensive delete link more

Comments

Checked 'keystone' user privileges by manually logging into the maria db and checked if keystone has privilege ? Keystone user had all privileges set for the keystone database.

Will share my keystone.conf file needed .

Any help will be much appreciated.

vspvijay gravatar imagevspvijay ( 2016-11-03 06:36:24 -0600 )edit

Looks like a database access problem. You either didn't set up the database correctly, or the database connection string in keystone.conf is wrong.

Bernd Bausch gravatar imageBernd Bausch ( 2016-11-05 02:20:58 -0600 )edit
add a comment

Get to know Ask OpenStack

Resources for moderators

Question Tools

1 follower

subscribe to rss feed

Stats

Asked: 2016-10-25 04:18:48 -0600

Seen: 3,635 times

Last updated: Nov 05 '16