← Back to team overview

yahoo-eng-team team mailing list archive

[Bug 1649601] [NEW] Postgresql case sensitiveness not honoured

 

Public bug reported:

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.

** Affects: keystone
     Importance: Undecided
         Status: New

-- 
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):
  New

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


Follow ups