[Rdo-list] Glance problems...

[Erich Weiler]

Actually, maybe my problem is related to the following:

https://bugzilla.redhat.com/show_bug.cgi?id=1089611

If so - is there any way to manually create the tables in the meantime 
until this bug is fixed?

Thanks,
erich

On 4/23/14, 4:40 PM, Erich Weiler wrote:
> 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
>
>