Ask Your Question
0

Error in glance while installing controller node

asked 2014-09-03 11:36:27 -0600

aloksingh gravatar image

updated 2014-09-03 11:52:56 -0600

mpetason gravatar image

Hi All, I am installing Openstack (using Ubuntu 14.x) and currently configuring Controller node in VMware virtual environment. While installing and configuring Glance, I am getting below error. Can you please help how can I resolve it? 

alok@controller:~$ sudo glance-manage db_sync 
2014-09-03 09:23:03.598 2354 CRITICAL glance [-] ValueError: Tables "migrate_version" have non utf8 collation, please make sure all tables are CHARSET=utf8

Thanks
Alok Email: aks82info@gmail.com

edit retag flag offensive close merge delete
add a comment

2 answers

Sort by ยป oldest newest most voted
0

answered 2014-09-03 11:41:53 -0600

rahulrajvn gravatar image

updated 2014-09-03 11:42:11 -0600

please try adding following to my.cnf and recreating the database .

collation-server = utf8_general_ci

init-connect = 'SET NAMES utf8'

character-set-server = utf8

edit flag offensive delete link more
add a comment
0

answered 2014-09-04 04:19:45 -0600

aloksingh gravatar image

After a few googling , while I run below commands, the issue got fixed:

mysql -u root -p glance

mysql> alter table migrate_version convert to character set utf8 collate utf8_unicode_ci; mysql> flush privileges; mysql> quit #

edit flag offensive delete link more
add a comment

Get to know Ask OpenStack

Resources for moderators

Question Tools

1 follower

subscribe to rss feed

Stats

Asked: 2014-09-03 11:36:27 -0600

Seen: 144 times

Last updated: Sep 03 '14