search

iesgn / openstack-debian-ansible

Ansible playbooks for installing OpenStack on Debian
GNU General Public License v3.0
17 stars 16 forks source link

Problem with enconding of table glance utf8 #5

Closed josedom24 closed 10 years ago

josedom24 commented 10 years ago

In a new installation:

TASK: [glance_init | ensure glance db is initialized] ***** failed: [controller] => {"changed": true, "cmd": ["/usr/bin/glance-manage", "db_sync"], "delta": "0:00:00.431699", "end": "2014-06-10 16:16:20.085178", "item": "", "rc": 1, "start": "2014-06-10 16:16:19.653479"} stderr: 2014-06-10 16:16:20.058 12384 CRITICAL glance [-] ValueError: Tables "migrate_version" have non utf8 collation, please make sure all tables are CHARSET=utf8

vagrant ssh Delete the table glance and rexecute playbook.

josedom24 commented 10 years ago

Delete the database glance!!!

albertomolina commented 10 years ago

SOLVED

MySQL restart was done after databse creation so default character set (Latin1) was used.

Database configuration is now in a separated playbook