[PKG-Openstack-devel] Bug#744892: glance-common configures a latin1 collation mysql database, glance-manage db-sync failes during installation.

[Ronny Aasen]

Package: glance-common
Version: 2014.1~rc1-1
Severity: normal

Dear Maintainer,

   * What led up to the situation? : Running apt-get install glance on a machine with a default mysql-server installation. 
   * What was the outcome of this action?  : the mysql was unpopulated after installation
   * What outcome did you expect instead?  : a populated mysql database


-- log snippet from apt-get install glance --

Setting up glance-common (2014.1~rc1-1) ...
PKG-Openstack now calling: dbc_go glance-common configure
dbconfig-common: writing config to /etc/dbconfig-common/glance-common.conf

Creating config file /etc/dbconfig-common/glance-common.conf with new version
granting access to database glancedb for glance-common at localhost: success.
verifying access for glance-common at localhost: success.
creating database glancedb: success.
verifying database glancedb exists: success.
dbconfig-common: flushing administrative password
Now doing glance-manage db_sync: this may take a while...
2014-04-15 22:17:45.938 20767 CRITICAL glance [-] ValueError: Tables "migrate_version" have non utf8 collation, please make sure all tables are CHARSET=utf8


there is a new variable in dbconfig-common. Adding the line 
dbc_mysql_createdb_encoding="utf8"
to the file /etc/dbconfig-common/glance-common.conf solved the problem.


kind regards
Ronny Aasen



-- System Information:
Debian Release: jessie/sid
  APT prefers unstable
  APT policy: (500, 'unstable'), (1, 'experimental')
Architecture: amd64 (x86_64)

Kernel: Linux 3.13-1-amd64 (SMP w/16 CPU cores)
Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/dash

Versions of packages glance-common depends on:
ii  adduser                3.113+nmu3
ii  dbconfig-common        1.8.47+nmu1
ii  debconf [debconf-2.0]  1.5.52
ii  dpkg                   1.17.6
ii  python-glance          2014.1~rc1-1
ii  python-glanceclient    1:0.10.0-2

glance-common recommends no packages.

glance-common suggests no packages.

-- debconf information excluded