Bug 997290

Description of problem:
Setup glance using "openstack-db --init" command fails

Version-Release number of selected component (if applicable):
RHOS3.0 on RHEL4.x - openstack-glance-2013.1.3-1.el6ost.noarch.rpm

The following .ini files are missing:
/etc/glance/glance-api-paste.ini
/etc/glance/glance-registry-paste.ini

The default /etc/glance/glance-registry.conf is not working

How reproducible:

Steps to Reproduce:
1. yum install -y mysql mysql-server openstack-glance
2. /usr/bin/openstack-db --init --service glance -p glance -r ""

Actual results:
---------
# /usr/bin/openstack-db --init --service glance -p glance -r ""
Verified connectivity to MySQL.
Creating 'glance' database.
Initializing the glance database, please wait...
2013-08-15 06:13:05.796 12957 CRITICAL glance [-] (OperationalError) unable to open database file None None
ERROR 1146 (42S02) at line 1: Table 'glance.migrate_version' doesn't exist
Final sanity check failed.
Please file a bug report on bugzilla.redhat.com against the openstack-glance package.
---------

Expected results:
---------
# /usr/bin/openstack-db --init --service glance -p glance -r ""
Verified connectivity to MySQL.
Creating 'glance' database.
Initializing the glance database, please wait...
Complete!
---------

Additional info:
BZ# 912143 seems to be same problem minus the .ini files (?)

Work around:

1. Add 2 missing ini files

$ cat > /etc/glance/glance-registry-paste.ini <<EOF
# Use this pipeline for no auth - DEFAULT
[pipeline:glance-registry]
pipeline = unauthenticated-context registryapp

# Use this pipeline for keystone auth
[pipeline:glance-registry-keystone]
pipeline = authtoken context registryapp

[app:registryapp]
paste.app_factory = glance.registry.api.v1:API.factory

[filter:context]
paste.filter_factory = glance.api.middleware.context:ContextMiddleware.factory

[filter:unauthenticated-context]
paste.filter_factory = glance.api.middleware.context:UnauthenticatedContextMiddleware.factory

[filter:authtoken]
paste.filter_factory = keystoneclient.middleware.auth_token:filter_factory
EOF

$ cat > /etc/glance/glance-api-paste.ini <<EOF
# Use this pipeline for no auth or image caching - DEFAULT
[pipeline:glance-api]
pipeline = versionnegotiation unauthenticated-context rootapp

# Use this pipeline for image caching and no auth
[pipeline:glance-api-caching]
pipeline = versionnegotiation unauthenticated-context cache rootapp

# Use this pipeline for caching w/ management interface but no auth
[pipeline:glance-api-cachemanagement]
pipeline = versionnegotiation unauthenticated-context cache cachemanage rootapp

# Use this pipeline for keystone auth
[pipeline:glance-api-keystone]
pipeline = versionnegotiation authtoken context rootapp

# Use this pipeline for keystone auth with image caching
[pipeline:glance-api-keystone+caching]
pipeline = versionnegotiation authtoken context cache rootapp

# Use this pipeline for keystone auth with caching and cache management
[pipeline:glance-api-keystone+cachemanagement]
pipeline = versionnegotiation authtoken context cache cachemanage rootapp

[composite:rootapp]
paste.composite_factory = glance.api:root_app_factory
/: apiversions
/v1: apiv1app
/v2: apiv2app

[app:apiversions]
paste.app_factory = glance.api.versions:create_resource

[app:apiv1app]
paste.app_factory = glance.api.v1.router:API.factory

[app:apiv2app]
paste.app_factory = glance.api.v2.router:API.factory

[filter:versionnegotiation]
paste.filter_factory = glance.api.middleware.version_negotiation:VersionNegotiationFilter.factory

[filter:cache]
paste.filter_factory = glance.api.middleware.cache:CacheFilter.factory

[filter:cachemanage]
paste.filter_factory = glance.api.middleware.cache_manage:CacheManageFilter.factory

[filter:context]
paste.filter_factory = glance.api.middleware.context:ContextMiddleware.factory

[filter:unauthenticated-context]
paste.filter_factory = glance.api.middleware.context:UnauthenticatedContextMiddleware.factory

[filter:authtoken]
paste.filter_factory = keystoneclient.middleware.auth_token:filter_factory
delay_auth_decision = true
EOF

$ chmod 640 /etc/glance/glance-registry-paste.ini /etc/glance/glance-api-paste.ini
$ chown root.glance /etc/glance/glance-registry-paste.ini /etc/glance/glance-api-paste.ini

2. Copy provided (or create your own) /etc/glance/glance-registry.conf file:
$ cp /usr/share/glance/glance-registry-dist.conf /etc/glance/glance-registry.conf

3. Run (or re-run) openstack-db (drop the database glance if needed)

$  /usr/bin/openstack-db --init --service glance -p glance -r ""
Verified connectivity to MySQL.
Database 'glance' already exists. Please consider first running:
/usr/bin/openstack-db --drop --service glance

$ /usr/bin/openstack-db --drop --service glance
Please enter the password for the 'root' MySQL user: 
Verified connectivity to MySQL.
Dropping 'glance' database.
Complete!

$ /usr/bin/openstack-db --init --service glance -p glance -r ""
Verified connectivity to MySQL.
Creating 'glance' database.
Initializing the glance database, please wait...
Complete!