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 -- Mailing list: https://launchpad.net/~yahoo-eng-team Post to : [email protected] Unsubscribe : https://launchpad.net/~yahoo-eng-team More help : https://help.launchpad.net/ListHelp
