[Rdo-list] Glance problems...

[Erich Weiler]

Hi Y'all,

I was able to set up RDO Openstack just fine with Icehouse RC1, and then 
I wiped it out and am trying again with the official stable release 
(2014.1) and am having weird problems.  It seems there were many changes 
between this and RC1 unless I'm mistaken.

The main issue I'm having now is that I can't seem to create the glance 
database properly, and I was able to do this before no problem.  I do:

$ mysql -u root -p
mysql> CREATE DATABASE glance;
mysql> GRANT ALL PRIVILEGES ON glance.* TO 'glance'@'localhost' \
IDENTIFIED BY 'GLANCE_DBPASS';
mysql> GRANT ALL PRIVILEGES ON glance.* TO 'glance'@'%' \
IDENTIFIED BY 'GLANCE_DBPASS';

(Obviously 'GLANCE_DBPASS' is replaced with the real password).

Then:

su -s /bin/sh -c "glance-manage db_sync" glance

And it creates the 'glance' database and only one table, 
"migrate_version".  I can't get it to create the rest of the tables it 
needs.  I've tried also:

openstack-db --init --service glance --password GLANCE_DBPASS

And that returned success but in reality nothing happened...  Any idea 
what's going on?

In the api.conf and registry.conf the correct database credentials are 
listed, and I can connect to the database as the mysql glance user on 
the command line just fine using those credentials.

When I run any glance commands I get this in the registry log:

ProgrammingError: (ProgrammingError) (1146, "Table 'glance.images' 
doesn't exist") 'SELECT anon_1.anon_2_images_created_at AS 
anon_1_anon_2_images_created_at, anon_1.anon_2_images_updated_at AS 
anon_1_anon_2_images_updated_at, anon_1.anon_2_images_deleted_at AS 
anon_1_anon_2_images_deleted_at, anon_1.anon_2_images_deleted AS 
anon_1_anon_2_images_deleted, anon_1.anon_2_images_id AS 
anon_1_anon_2_images_id, anon_1.anon_2_images_name AS 
anon_1_anon_2_images_name, anon_1.anon_2_images_disk_format AS 
anon_1_anon_2_images_disk_format, anon_1.anon_2_images_container_format 
AS anon_1_anon_2_images_container_format, anon_1.anon_2_images_size AS 
anon_1_anon_2_images_size, anon_1.anon_2_images_virtual_size AS 
anon_1_anon_2_images_virtual_size, anon_1.anon_2_images_status AS 
anon_1_anon_2_images_status, anon_1.anon_2_images_is_public AS 
anon_1_anon_2_images_is_public, anon_1.anon_2_images_checksum AS 
anon_1_anon_2_images_checksum, anon_1.anon_2_images_min_disk AS 
anon_1_anon_2_images_min_disk, anon_1.anon_2_images_min_ram AS 
anon_1_anon_2_images_min_ram, anon_1.anon_2_images_owner AS 
anon_1_anon_2_images_owner, anon_1.anon_2_images_protected AS 
anon_1_anon_2_images_protected, image_properties_1.created_at AS 
image_properties_1_created_at, image_properties_1.updated_at AS 
image_properties_1_updated_at, image_properties_1.deleted_at AS 
image_properties_1_deleted_at, image_properties_1.deleted AS 
image_properties_1_deleted, image_properties_1.id AS 
image_properties_1_id, image_properties_1.image_id AS 
image_properties_1_image_id, image_properties_1.name AS 
image_properties_1_name, image_properties_1.value AS 
image_properties_1_value, image_locations_1.created_at AS 
image_locations_1_created_at, image_locations_1.updated_at AS 
image_locations_1_updated_at, image_locations_1.deleted_at AS 
image_locations_1_deleted_at, image_locations_1.deleted AS 
image_locations_1_deleted, image_locations_1.id AS image_locations_1_id, 
image_locations_1.image_id AS image_locations_1_image_id, 
image_locations_1.value AS image_locations_1_value, 
image_locations_1.meta_data AS image_locations_1_meta_data, 
image_locations_1.status AS image_locations_1_status \nFROM (SELECT 
anon_2.images_created_at AS anon_2_images_created_at, 
anon_2.images_updated_at AS anon_2_images_updated_at, 
anon_2.images_deleted_at AS anon_2_images_deleted_at, 
anon_2.images_deleted AS anon_2_images_deleted, anon_2.images_id AS 
anon_2_images_id, anon_2.images_name AS anon_2_images_name, 
anon_2.images_disk_format AS anon_2_images_disk_format, 
anon_2.images_container_format AS anon_2_images_container_format, 
anon_2.images_size AS anon_2_images_size, anon_2.images_virtual_size AS 
anon_2_images_virtual_size, anon_2.images_status AS 
anon_2_images_status, anon_2.images_is_public AS 
anon_2_images_is_public, anon_2.images_checksum AS 
anon_2_images_checksum, anon_2.images_min_disk AS 
anon_2_images_min_disk, anon_2.images_min_ram AS anon_2_images_min_ram, 
anon_2.images_owner AS anon_2_images_owner, anon_2.images_protected AS 
anon_2_images_protected \nFROM (SELECT images.created_at AS 
images_created_at, images.updated_at AS images_updated_at, 
images.deleted_at AS images_deleted_at, images.deleted AS 
images_deleted, images.id AS images_id, images.name AS images_name, 
images.disk_format AS images_disk_format, images.container_format AS 
images_container_format, images.size AS images_size, images.virtual_size 
AS images_virtual_size, images.status AS images_status, images.is_public 
AS images_is_public, images.checksum AS images_checksum, images.min_disk 
AS images_min_disk, images.min_ram AS images_min_ram, images.owner AS 
images_owner, images.protected AS images_protected \nFROM images \nWHERE 
images.deleted = %s AND images.status IN (%s, %s, %s, %s, %s) AND 
images.is_public = %s UNION SELECT images.created_at AS 
images_created_at, images.updated_at AS images_updated_at, 
images.deleted_at AS images_deleted_at, images.deleted AS 
images_deleted, images.id AS images_id, images.name AS images_name, 
images.disk_format AS images_disk_format, images.container_format AS 
images_container_format, images.size AS images_size, images.virtual_size 
AS images_virtual_size, images.status AS images_status, images.is_public 
AS images_is_public, images.checksum AS images_checksum, images.min_disk 
AS images_min_disk, images.min_ram AS images_min_ram, images.owner AS 
images_owner, images.protected AS images_protected \nFROM images \nWHERE 
images.owner = %s AND images.deleted = %s AND images.status IN (%s, %s, 
%s, %s, %s) UNION SELECT images.created_at AS images_created_at, 
images.updated_at AS images_updated_at, images.deleted_at AS 
images_deleted_at, images.deleted AS images_deleted, images.id AS 
images_id, images.name AS images_name, images.disk_format AS 
images_disk_format, images.container_format AS images_container_format, 
images.size AS images_size, images.virtual_size AS images_virtual_size, 
images.status AS images_status, images.is_public AS images_is_public, 
images.checksum AS images_checksum, images.min_disk AS images_min_disk, 
images.min_ram AS images_min_ram, images.owner AS images_owner, 
images.protected AS images_protected \nFROM images INNER JOIN 
image_members ON images.id = image_members.image_id \nWHERE 
images.deleted = %s AND images.status IN (%s, %s, %s, %s, %s) AND 
image_members.deleted = %s AND image_members.member = %s) AS anon_2 
ORDER BY anon_2.images_name ASC, anon_2.images_created_at ASC, 
anon_2.images_id ASC \n LIMIT %s) AS anon_1 LEFT OUTER JOIN 
image_properties AS image_properties_1 ON anon_1.anon_2_images_id = 
image_properties_1.image_id LEFT OUTER JOIN image_locations AS 
image_locations_1 ON anon_1.anon_2_images_id = 
image_locations_1.image_id ORDER BY anon_1.anon_2_images_name ASC, 
anon_1.anon_2_images_created_at ASC, anon_1.anon_2_images_id ASC' (0, 
'active', 'saving', 'queued', 'pending_delete', 'deleted', 1, 
'7c1980078e044cb08250f628cbe73d29', 0, 'active', 'saving', 'queued', 
'pending_delete', 'deleted', 0, 'active', 'saving', 'queued', 
'pending_delete', 'deleted', 0, '7c1980078e044cb08250f628cbe73d29', 20)

Sure, enough, all the rest of the tables are missing from mysql so it 
complains.


Also, I tried this:

keystone user-create --name=glance --pass=GLANCE_PASS --tenant=service 
--email=glance at myco.com
exceptions must be old-style classes or derived from BaseException, not 
NoneType (HTTP 400)

Creating the glance user was easy last time, now it doesn't work...  Any 
insight would be greatly appreciated!!

cheers,
erich