yahoo-eng-team team mailing list archive
-
yahoo-eng-team team
-
Mailing list archive
-
Message #12958
[Bug 1300814] Re: Tables "migrate_version" have non utf8 collation
** Also affects: keystone
Importance: Undecided
Status: New
--
You received this bug notification because you are a member of Yahoo!
Engineering Team, which is subscribed to Keystone.
https://bugs.launchpad.net/bugs/1300814
Title:
Tables "migrate_version" have non utf8 collation
Status in OpenStack Identity (Keystone):
New
Status in “keystone” package in Ubuntu:
New
Bug description:
On ubuntu 14.04
I updated keystone to the version 1:2014.1~rc1-0ubuntu1.
I drop the database and re-create.
CREATE DATABASE keystone;
GRANT ALL PRIVILEGES ON keystone.* TO 'keystone'@'%' IDENTIFIED BY '$KEYSTONE_DBPASS';
GRANT ALL PRIVILEGES ON keystone.* TO 'keystone'@'localhost' IDENTIFIED BY '$KEYSTONE_DBPASS';
GRANT ALL PRIVILEGES ON keystone.* TO 'keystone'@'$' IDENTIFIED BY '$KEYSTONE_DBPASS';
And then,
keystone-manage db_sync
I got the next error
./keystone/keystone.log:2014-04-01 10:49:20.681 5423 CRITICAL keystone [-] ValueError: Tables "migrate_version" have non utf8 collation, please make sure all tables are CHARSET=utf8
./keystone/keystone.log:2014-04-01 10:49:20.681 5423 TRACE keystone ValueError: Tables "migrate_version" have non utf8 collation, please make sure all tables are CHARSET=utf8
Problem:
Bad charset
Solution:
alter table migrate_version charset=utf8;
To manage notifications about this bug go to:
https://bugs.launchpad.net/keystone/+bug/1300814/+subscriptions