[Bug 1300814] [NEW] Tables "migrate_version" have non utf8 collation,

[Maximiliano Osorio]

Public bug reported:

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;

** Affects: keystone (Ubuntu)
     Importance: Undecided
         Status: New


** Tags: keystone

-- 
You received this bug notification because you are a member of Ubuntu
Server Team, which is subscribed to keystone in Ubuntu.
https://bugs.launchpad.net/bugs/1300814

Title:
  Tables "migrate_version" have non utf8 collation,

To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/keystone/+bug/1300814/+subscriptions