yahoo-eng-team team mailing list archive

[Launchpad Bug Tracker <1649601@xxxxxxxxxxxxxxxxxx>]

[Expired for OpenStack Identity (keystone) because there has been no
activity for 60 days.]

** Changed in: keystone
       Status: Incomplete => Expired

-- 
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/1649601

Title:
  Postgresql case sensitiveness not honoured

Status in OpenStack Identity (keystone):
  Expired

Bug description:
  I installed Keystone with the ubuntu guide
  (http://docs.openstack.org/newton/install-guide-ubuntu/index.html),
  but with postgresql backend.

  At http://docs.openstack.org/newton/install-guide-ubuntu/keystone-
  users.html I get following reported error:

  https://ask.openstack.org/en/question/67398/error-openstack-the-
  request-you-have-made-requires-authentication-http-401/ --> ERROR:
  openstack The request you have made requires authentication. (HTTP
  401)

  After some deeper debugging and comparing of databases I found out
  that following query:

  SELECT project.id AS project_id, project.name AS project_name, project.domain_id AS project_domain_id, project.description AS project_description, project.enabled AS project_enabled, project.extra AS project_extra, project.parent_id AS project_parent_id, project.is_domain AS project_is_domain
  FROM project
  WHERE project.name = 'default' AND project.domain_id = '<<keystone.domain.root>>'

  does not work on postgresql and gives an empty result back. MySQL
  works here successful and a creation of the project works.

  There are several ways to solve this issue (citext field type or
  lower() function), but I'm not a programmer nor I found the possible
  location in the code yet.

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