RHEL Engineering is moving the tracking of its product development work on RHEL 6 through RHEL 9 to Red Hat Jira (issues.redhat.com). If you're a Red Hat customer, please continue to file support cases via the Red Hat customer portal. If you're not, please head to the "RHEL project" in Red Hat Jira and file new tickets here. Individual Bugzilla bugs in the statuses "NEW", "ASSIGNED", and "POST" are being migrated throughout September 2023. Bugs of Red Hat partners with an assigned Engineering Partner Manager (EPM) are migrated in late September as per pre-agreed dates. Bugs against components "kernel", "kernel-rt", and "kpatch" are only migrated if still in "NEW" or "ASSIGNED". If you cannot log in to RH Jira, please consult article #7032570. That failing, please send an e-mail to the RH Jira admins at rh-issues@redhat.com to troubleshoot your issue as a user management inquiry. The email creates a ServiceNow ticket with Red Hat. Individual Bugzilla bugs that are migrated will be moved to status "CLOSED", resolution "MIGRATED", and set with "MigratedToJIRA" in "Keywords". The link to the successor Jira issue will be found under "Links", have a little "two-footprint" icon next to it, and direct you to the "RHEL project" in Red Hat Jira (issue links are of type "https://issues.redhat.com/browse/RHEL-XXXX", where "X" is a digit). This same link will be available in a blue banner at the top of the page informing you that that bug has been migrated.
Bug 2192708 - [RHEL8] [sssd] User lookup on IPA client fails with 's2n get_fqlist request failed'
Summary: [RHEL8] [sssd] User lookup on IPA client fails with 's2n get_fqlist request f...
Keywords:
Status: CLOSED ERRATA
Alias: None
Deadline: 2023-06-12
Product: Red Hat Enterprise Linux 8
Classification: Red Hat
Component: sssd
Version: 8.7
Hardware: Unspecified
OS: Unspecified
high
medium
Target Milestone: rc
: ---
Assignee: Sumit Bose
QA Contact: Madhuri
URL:
Whiteboard: sync-to-jira
Depends On:
Blocks: 2196838
TreeView+ depends on / blocked
 
Reported: 2023-05-02 19:54 UTC by Cesar Goslawski
Modified: 2023-11-14 18:08 UTC (History)
8 users (show)

Fixed In Version: sssd-2.9.1-1.el8
Doc Type: If docs needed, set a value
Doc Text:
Clone Of:
: 2196838 (view as bug list)
Environment:
Last Closed: 2023-11-14 15:50:01 UTC
Type: Bug
Target Upstream Version:
Embargoed:
pm-rhel: mirror+

Attachments (Terms of Use)


Links
System ID Private Priority Status Summary Last Updated
Github SSSD sssd issues 6720 0 None open [sssd] User lookup on IPA client fails with 's2n get_fqlist request failed' 2023-05-10 08:10:48 UTC
Github SSSD sssd pull 6721 0 None open sysdb: fix string comparison when checking for overrides 2023-05-10 10:13:06 UTC
Red Hat Issue Tracker RHELPLAN-156257 0 None None None 2023-05-02 19:56:03 UTC
Red Hat Issue Tracker SSSD-6051 0 None None None 2023-05-10 10:02:27 UTC
Red Hat Product Errata RHBA-2023:7127 0 None None None 2023-11-14 15:50:13 UTC

Description Cesar Goslawski 2023-05-02 19:54:22 UTC 
## Description of problem ##
Trusted AD user information cannot be retrieved from IPA clients if trusted user name contains upper/mixed case characters and is configured with overrides.
IDM server is able to see the user running the same pkg release.

Operation returns:
~~~
(2023-04-20 16:16:27): [be[ipa.example.com]] [ipa_s2n_get_list_next] (0x0040): [RID#2] s2n exop request failed.
(2023-04-20 16:16:27): [be[ipa.example.com]] [ipa_s2n_get_list_done] (0x0040): [RID#2] s2n get_fqlist request failed.
~~~

## Version-Release number of selected component (if applicable) ##
sssd-2.7.3-4.el8_7.3.x86_64


## How reproducible ##
Always


## Steps to Reproduce ##
1. Deploy a user in AD with uppercase/mixed chars name (e.g., Con81001)
2. Configure a override for this user in IPA (sshPublicKey)
3. Perform user lookup or authentication attempt


## Actual results ##
id: ‘con81001.com’: no such user


## Expected results ##
uid=645601103(con81001.com) gid=645601103(con81001.com) groups=645601103(con81001.com)


## Additional info ##

Request from client fails with:
~~~
(2023-04-20 16:16:27): [be[ipa.example.com]] [ipa_s2n_get_list_step] (0x0400): [RID#2] Sending request_type: [REQ_FULL_WITH_MEMBERS] for object [con81001.com].
(2023-04-20 16:16:27): [be[ipa.example.com]] [ipa_s2n_exop_send] (0x0400): [RID#2] Executing extended operation
(2023-04-20 16:16:27): [be[ipa.example.com]] [ipa_s2n_exop_send] (0x2000): [RID#2] ldap_extended_operation sent, msgid = 17
-- snip --
(2023-04-20 16:16:27): [be[ipa.example.com]] [sdap_call_op_callback] (0x20000): [RID#2] Handling LDAP operation [17][server: [172.20.90.211:389] IPA EXOP] took [207.742] milliseconds.
(2023-04-20 16:16:27): [be[ipa.example.com]] [ipa_s2n_exop_done] (0x0040): [RID#2] ldap_extended_operation result: No such object(32), (null).
(2023-04-20 16:16:27): [be[ipa.example.com]] [sdap_op_destructor] (0x2000): [RID#2] Operation 17 finished
(2023-04-20 16:16:27): [be[ipa.example.com]] [ipa_s2n_get_list_next] (0x0040): [RID#2] s2n exop request failed.
(2023-04-20 16:16:27): [be[ipa.example.com]] [ipa_s2n_get_list_done] (0x0040): [RID#2] s2n get_fqlist request failed.
(2023-04-20 16:16:27): [be[ipa.example.com]] [sdap_id_op_done] (0x4000): [RID#2] releasing operation connection
~~~
Comment 4 Sumit Bose 2023-05-10 08:26:09 UTC 
Hi,

the issue boils down to lookup up the user-private group of an AD user with a mixed-case (or only upper-case) name in AD which has an idoverride which does not override the name on the IPA server.

How to reproduce:
- setup IPA with trust to an AD forest with idrage type 'ipa-ad-trust'
- create an idoverride with a ssh key for the Administrator user, which by default has a mixed-case name:
    ipa idoverrideuser-add 'Default Trust View' Administrator --sshpubkey=AAAAB.....
- lookup the user-private group of the Administrator on the IPA server:
    getent group administrator
- without a fix the lookup will fail



The reason is a case-sensitive comparison in sysdb_getgrnam() in the check if the input name was the original AD group name or an overwritten one.

bye,
Sumit
Comment 5 Alexey Tikhonov 2023-05-10 10:06:41 UTC 
Upstream PR: https://github.com/SSSD/sssd/pull/6721
Comment 15 Alexey Tikhonov 2023-05-15 12:26:55 UTC 
Pushed PR: https://github.com/SSSD/sssd/pull/6721

* `master`
    * 01d02794e02f051ea9a78cd63b30384de3e7c9b0 - sysdb: fix string comparison when checking for overrides
* `sssd-2-9`
    * d104c01f1b3198779addee8178b10b047e64deb9 - sysdb: fix string comparison when checking for overrides
Comment 25 errata-xmlrpc 2023-11-14 15:50:01 UTC 
Since the problem described in this bug report should be
resolved in a recent advisory, it has been closed with a
resolution of ERRATA.

For information on the advisory (sssd bug fix and enhancement update), and where to find the updated
files, follow the link below.

If the solution does not work for you, open a new bug report.

https://access.redhat.com/errata/RHBA-2023:7127
Note You need to log in before you can comment on or make changes to this bug.