Ubuntu 14.04 - Openstack ICEHOUSE release
During the installation of Glance I ran into what seems to be a common problem with this release (supposedly fixed as well) in this release, which is when you run the below command to initialize the database for glance:
# su -s /bin/sh -c "glance-manage db_sync" glance
You receive the below output error.
CRITICAL glance [-] ValueError: Tables "migrate_version" have non utf8 collation, please make sure all tables are CHARSET=utf8
In order to resolve this one (assuming you have access to the mysql database directly) run the commands below.
# mysql -u root -p glance mysql> alter table migrate_version convert to character set utf8 collate utf8_unicode_ci; mysql> flush privileges; mysql> quit #
You should now be able to run the command below successfully to create the database for glance.
# su -s /bin/sh -c "glance-manage db_sync" glance
Bug ID: https://bugs.launchpad.net/glance/+bug/1279000
