6:40 p.m.
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