yahoo-eng-team team mailing list archive

[Kanagaraj Manickam <mkr1481@xxxxxxxxx>]

Public bug reported:

Keystone is provided with region table as given here for storing the region details :
mysql> desc region
    -> ;
+------------------+--------------+------+-----+---------+-------+
| Field            | Type         | Null | Key | Default | Extra |
+------------------+--------------+------+-----+---------+-------+
| id               | varchar(64)  | NO   | PRI | NULL    |       |
| description      | varchar(255) | NO   |     | NULL    |       |
| parent_region_id | varchar(64)  | YES  |     | NULL    |       |
| extra            | text         | YES  |     | NULL    |       |
+------------------+--------------+------+-----+---------+-------+

But  it is not consumed in the endpoint table as shown below, "region"
column is still having the endpoint name


mysql> desc endpoint;
+--------------------+--------------+------+-----+---------+-------+
| Field              | Type         | Null | Key | Default | Extra |
+--------------------+--------------+------+-----+---------+-------+
| id                 | varchar(64)  | NO   | PRI | NULL    |       |
| legacy_endpoint_id | varchar(64)  | YES  |     | NULL    |       |
| interface          | varchar(8)   | NO   |     | NULL    |       |
| region             | varchar(255) | YES  |     | NULL    |       |
| service_id         | varchar(64)  | NO   | MUL | NULL    |       |
| url                | text         | NO   |     | NULL    |       |
| extra              | text         | YES  |     | NULL    |       |
| enabled            | tinyint(1)   | NO   |     | 1       |       |
+--------------------+--------------+------+-----+---------+-------+

And this "region" column should be renamed to "region_id" and should be
referring to the region table.

This bug is filed to address this issue.

As part of this model change, 
1. the python-keystoneclient to consider the region_id in addition to the region name
2. keystone endpoint-xxx commands needs to be updated to consider the region_id in place of region

** Affects: keystone
     Importance: Undecided
     Assignee: Kanagaraj Manickam (kanagaraj-manickam)
         Status: New

** Changed in: keystone
     Assignee: (unassigned) => Kanagaraj Manickam (kanagaraj-manickam)

-- 
You received this bug notification because you are a member of Yahoo!
Engineering Team, which is subscribed to Keystone.
https://bugs.launchpad.net/bugs/1332196

Title:
  endpoint table is missing reference to region table

Status in OpenStack Identity (Keystone):
  New

Bug description:
  Keystone is provided with region table as given here for storing the region details :
  mysql> desc region
      -> ;
  +------------------+--------------+------+-----+---------+-------+
  | Field            | Type         | Null | Key | Default | Extra |
  +------------------+--------------+------+-----+---------+-------+
  | id               | varchar(64)  | NO   | PRI | NULL    |       |
  | description      | varchar(255) | NO   |     | NULL    |       |
  | parent_region_id | varchar(64)  | YES  |     | NULL    |       |
  | extra            | text         | YES  |     | NULL    |       |
  +------------------+--------------+------+-----+---------+-------+

  But  it is not consumed in the endpoint table as shown below, "region"
  column is still having the endpoint name

  
  mysql> desc endpoint;
  +--------------------+--------------+------+-----+---------+-------+
  | Field              | Type         | Null | Key | Default | Extra |
  +--------------------+--------------+------+-----+---------+-------+
  | id                 | varchar(64)  | NO   | PRI | NULL    |       |
  | legacy_endpoint_id | varchar(64)  | YES  |     | NULL    |       |
  | interface          | varchar(8)   | NO   |     | NULL    |       |
  | region             | varchar(255) | YES  |     | NULL    |       |
  | service_id         | varchar(64)  | NO   | MUL | NULL    |       |
  | url                | text         | NO   |     | NULL    |       |
  | extra              | text         | YES  |     | NULL    |       |
  | enabled            | tinyint(1)   | NO   |     | 1       |       |
  +--------------------+--------------+------+-----+---------+-------+

  And this "region" column should be renamed to "region_id" and should
  be referring to the region table.

  This bug is filed to address this issue.

  As part of this model change, 
  1. the python-keystoneclient to consider the region_id in addition to the region name
  2. keystone endpoint-xxx commands needs to be updated to consider the region_id in place of region

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