yahoo-eng-team team mailing list archive

[Thierry Carrez <thierry.carrez+lp@xxxxxxxxx>]

** Changed in: keystone
       Status: Fix Committed => Fix Released

** Changed in: keystone
    Milestone: None => juno-3

-- 
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):
  Fix Released

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.

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