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

[Thomas Goirand]

On 04/16/2014 04:45 AM, Ronny Aasen wrote:
> 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

Hi Ronny,

Thanks for your bug report. This was already spotted and corrected, but
it's very nice that you send me a reminder about it, as I forgot to
upload openstack-pkg-tools version 10 (I just did that...).

The bug is in fact fixed in openstack-pkg-tools (version 10), which is
the package that contains the code. Unfortunately, fixing the issue
means that all packages needs to be rebuilt. Since OpenStack Icehouse
will be released tomorrow (US time I believe), I will *not* fix the
current RC packages, and will provide the fix on the final release.

Note that the backport packages maintained in the GPLHost repos are
already fixed.

Cheers,

Thomas Goirand (zigo)