yahoo-eng-team team mailing list archive

[Alexey Stupnikov <1586289@xxxxxxxxxxxxxxxxxx>]

As of now structure of project table is very different. There are no heat/magnum projects and table basically contains a hierarchical structure of domains and projects:
mysql> select * from project;
+----------------------------------+--------------------------+-------+-----------------------------------------------+---------+--------------------------+-----------+-----------+
| id                               | name                     | extra | description                                   | enabled | domain_id                | parent_id | is_domain |
+----------------------------------+--------------------------+-------+-----------------------------------------------+---------+--------------------------+-----------+-----------+
| 0c5d38c32a82460083536764e3914f42 | admin                    | {}    | Bootstrap project for initializing the cloud. |       1 | default                  | default   |         0 |
| 4934121a645a47a18513d39a1bd06c09 | demo                     | {}    |                                               |       1 | default                  | default   |         0 |
| 5bb8b8ea865849278da8f937cb459cf1 | invisible_to_admin       | {}    |                                               |       1 | default                  | default   |         0 |
| 7de0ef5d154d42f6a9d77680310438ec | test1                    | {}    | NULL                                          |       1 | <<keystone.domain.root>> | NULL      |         1 |
| 91bb8d71c6f64140aa488b58aa7105a5 | alt_demo                 | {}    |                                               |       1 | default                  | default   |         0 |
| <<keystone.domain.root>>         | <<keystone.domain.root>> | {}    |                                               |       0 | <<keystone.domain.root>> | NULL      |         1 |
| ce2258f9ca144adb9f1532dfd1b3eae0 | service                  | {}    |                                               |       1 | default                  | default   |         0 |
| default                          | Default                  | {}    | The default domain                            |       1 | <<keystone.domain.root>> | NULL      |         1 |
+----------------------------------+--------------------------+-------+-----------------------------------------------+---------+--------------------------+-----------+-----------+

Also, there are two different commands to list projects (openstack
project list) and domains (openstack domain list) + there are different
API endpoints for this on keystone side as well. So this looks quite
consistently on openstackclient side.

Since bug is very old, I will go ahead and close it. Please re-open and
provide more information about use case if needed.

** Changed in: python-openstackclient
       Status: Confirmed => Invalid

-- 
You received this bug notification because you are a member of Yahoo!
Engineering Team, which is subscribed to OpenStack Identity (keystone).
https://bugs.launchpad.net/bugs/1586289

Title:
  openstack project list can not list the project which is domain.

Status in OpenStack Identity (keystone):
  Fix Released
Status in python-openstackclient:
  Invalid

Bug description:
  version:mitaka
  question:
  In project table of keystone database, there are following projects:
  +----------------------------------+--------------------------+-------+-----------------------------------------------+---------+--------------------------+-----------+-----------+
  | id                               | name                     | extra | description                                   | enabled | domain_id                | parent_id | is_domain |
  +----------------------------------+--------------------------+-------+-----------------------------------------------+---------+--------------------------+-----------+-----------+
  | 1e424dd1844b4a7d81d5b167f188192d | heat                     | {}    | Owns users and projects created by heat       |       1 | <<keystone.domain.root>> | NULL      |         1 |
  | 388ba5efe7c24cd6b4762b9c6f60a5d5 | magnum                   | {}    | Owns users and projects created by magnum     |       1 | <<keystone.domain.root>> | NULL      |         1 |
  | 4d6e4e79ea1f4ec392475308e11a895d | admin                    | {}    | Bootstrap project for initializing the cloud. |       1 | default                  | default   |         0 |
  | 749e9ebce1d24c4aa5463382c6d2c526 | demo                     | {}    |                                               |       1 | default                  | default   |         0 |
  | 9314197e00bc43e197995681cff786cc | alt_demo                 | {}    |                                               |       1 | default                  | default   |         0 |
  | <<keystone.domain.root>>         | <<keystone.domain.root>> | {}    |                                               |       0 | <<keystone.domain.root>> | NULL      |         1 |
  | b79ace1760194778916e18cfb053a6d1 | service                  | {}    |                                               |       1 | default                  | default   |         0 |
  | cf443a4f9b9749c9a172915ce48d7989 | project_a                | {}    |                                               |       1 | default                  | default   |         0 |
  | d076df0e55d24881a61325cd6bb7f6f4 | project_b                | {}    |                                               |       1 | default                  | default   |         0 |
  | d90353b3872749719e2a5c9343f9acce | invisible_to_admin       | {}    |                                               |       1 | default                  | default   |         0 |
  | default                          | Default                  | {}    | The default domain                            |       1 | <<keystone.domain.root>> | NULL      |         1 |
  +----------------------------------+--------------------------+-------+-----------------------------------------------+---------+--------------------------+-----------+-----------+

  But when I execute openstack project list, I got following result:
  +----------------------------------+--------------------+
  | ID                               | Name               |
  +----------------------------------+--------------------+
  | 4d6e4e79ea1f4ec392475308e11a895d | admin              |
  | 749e9ebce1d24c4aa5463382c6d2c526 | demo               |
  | 9314197e00bc43e197995681cff786cc | alt_demo           |
  | b79ace1760194778916e18cfb053a6d1 | service            |
  | cf443a4f9b9749c9a172915ce48d7989 | project_a          |
  | d076df0e55d24881a61325cd6bb7f6f4 | project_b          |
  | d90353b3872749719e2a5c9343f9acce | invisible_to_admin |
  +----------------------------------+--------------------+

  The project which is domain can not list, such as heat, magnum,
  <<keystone.domain.root>>, Default.

To manage notifications about this bug go to:
https://bugs.launchpad.net/keystone/+bug/1586289/+subscriptions