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(a)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

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;

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

> I think the issue is due to a change to enforce utf-8 encoding. > Can you try again with the above line changed to: > > CREATE DATABASE glance DEFAULT CHARACTER SET utf8; > >> 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: Awesome! Glad it's something easy. >> openstack-db --init --service glance --password GLANCE_DBPASS > > openstack-db has not been updated yet to enforce the new encoding. > That will be happening today at some stage. Can you send a note to the list when that's done? Also, is the code being updated here when it's released? http://repos.fedorapeople.org/repos/openstack/openstack-icehouse/epel-6/ Such that the fix will be pushed out with an rpm from the repository today? If so, I'll just resync my local repo when the fix is out.

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.