Note: This bug is displayed in read-only format because the product is no longer active in Red Hat Bugzilla.
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 781208

Summary: ipa user-find --manager does not find matches
Product: Red Hat Enterprise Linux 6 Reporter: Scott Poore <spoore>
Component: ipaAssignee: Rob Crittenden <rcritten>
Status: CLOSED ERRATA QA Contact: Namita Soman <nsoman>
Severity: unspecified Docs Contact:
Priority: medium    
Version: 6.2CC: jgalipea, mkosek
Target Milestone: rc   
Target Release: ---   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: ipa-3.0.0-1.el6 Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2013-02-21 09:09:04 UTC Type: ---
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:

Description Scott Poore 2012-01-12 23:46:40 UTC
Description of problem:

Cannot search user list by manager name using user-find --manager.

More in Additional Info section.

Version-Release number of selected component (if applicable):
This test was run on Fedora 16 with latest(?) freeipa rpms.

# rpm -qa|grep freeipa
freeipa-server-2.1.4-3.fc16.x86_64
freeipa-client-2.1.4-3.fc16.x86_64
freeipa-admintools-2.1.4-3.fc16.x86_64
freeipa-python-2.1.4-3.fc16.x86_64
freeipa-server-selinux-2.1.4-3.fc16.x86_64

How reproducible:
always?

Steps to Reproduce:
1. ipa user-add --first=first --last=last testmanager
2. ipa user-add --first=first --last=last testuser
3. ipa user-mod testuser --manager=testmanager
<should see "Manager: testmanager" in output here>
4. ipa user-find testuser --manager=testmanager
  
Actual results:

# ipa user-find testuser --manager=testmanager
---------------
0 users matched
---------------
----------------------------
Number of entries returned 0
----------------------------

Expected results:

Should return 1 match for testuser.

Additional info:

I'm not sure if this is intentional or even matters here but, thought I would note also that in my testing the following seems to match all users:

ipa user-find --manager=""

Full (sanitized) output from failure tests below:

# ipa user-add --first=first --last=last testmanager
------------------------
Added user "testmanager"
------------------------
  User login: testmanager
  First name: first
  Last name: last
  Full name: first last
  Display name: first last
  Initials: fl
  Home directory: /home/testmanager
  GECOS field: first last
  Login shell: /bin/sh
  Kerberos principal: testmanager@TESTRELM
  UID: 1798000033
  GID: 1798000033
  Keytab: False
  Password: False

# ipa user-add --first=first --last=last testuser
---------------------
Added user "testuser"
---------------------
  User login: testuser
  First name: first
  Last name: last
  Full name: first last
  Display name: first last
  Initials: fl
  Home directory: /home/testuser
  GECOS field: first last
  Login shell: /bin/sh
  Kerberos principal: testuser@TESTRELM
  UID: 1798000034
  GID: 1798000034
  Keytab: False
  Password: False

# ipa user-mod testuser --manager=testmanager
------------------------
Modified user "testuser"
------------------------
  User login: testuser
  First name: first
  Last name: last
  Home directory: /home/testuser
  Login shell: /bin/sh
  UID: 1798000034
  GID: 1798000034
  Manager: testmanager
  Account disabled: False
  Keytab: False
  Password: False
  Member of groups: ipausers

# ipa user-find testuser --manager=testmanager
---------------
0 users matched
---------------
----------------------------
Number of entries returned 0
----------------------------

Comment 2 Jenny Severance 2012-01-13 12:46:47 UTC
Hey Scott:

The default user search attributes do not include manager.

# ipa config-show
  Max. username length: 32
  Home directory base: /home
  Default shell: /bin/sh
  Default users group: ipausers
  Default e-mail domain for new users: testrelm
  Search time limit: 2
  Search size limit: 100
  User search fields: uid,givenname,sn,telephonenumber,ou,title  <===============
  Group search fields: cn,description
  Enable migration mode: FALSE
  Certificate Subject base: O=TESTRELM
  Password Expiration Notification (days): 4


You could modify this and check that the user is found if the search attributes include manager.

# ipa config-mod --usersearch="uid,givenname,sn,telephonenumber,ou,title,manager"
  Max. username length: 32
  Home directory base: /home
  Default shell: /bin/sh
  Default users group: ipausers
  Default e-mail domain for new users: testrelm
  Search time limit: 2
  Search size limit: 100
  User search fields: uid,givenname,sn,telephonenumber,ou,title,manager
  Group search fields: cn,description
  Enable migration mode: FALSE
  Certificate Subject base: O=TESTRELM
  Password Expiration Notification (days): 4

Comment 3 Rob Crittenden 2012-01-13 14:20:53 UTC
No, the problem is that the data is stored as a DN and we are not converting the manager value into a DN before creating the filter.

In this case we do a query like this:

(&(objectClass=posixaccount)(manager=testmanager))

We need to convert the incoming manager value into a DN before creating the search filter.

As a demonstration, this will work (but is unwieldy):

ipa user-find testuser --manager="uid=testmanager,cn=users,cn=accounts,dc=testrelm"

When no options are provided to a find then the default search fields are used. When some criteria is provided we use only that.

Comment 4 Jenny Severance 2012-01-13 15:01:08 UTC
Got it ... bug :-)

Comment 5 Martin Kosek 2012-01-16 11:34:47 UTC
Upstream ticket:
https://fedorahosted.org/freeipa/ticket/2264

Comment 9 Scott Poore 2012-10-08 23:23:10 UTC
Verified.

Version ::

[root@vm1 quickinstall]# rpm -q ipa-server
ipa-server-3.0.0-2.el6.x86_64

Manual Test Results ::

[root@vm1 quickinstall]# ipa user-add --first=first --last=last testmanager
------------------------
Added user "testmanager"
------------------------
  User login: testmanager
  First name: first
  Last name: last
  Full name: first last
  Display name: first last
  Initials: fl
  Home directory: /home/testmanager
  GECOS field: first last
  Login shell: /bin/sh
  Kerberos principal: testmanager
  Email address: testmanager
  UID: 378000001
  GID: 378000001
  Password: False
  Kerberos keys available: False
[root@vm1 quickinstall]# ipa user-add --first=first --last=last testuser
---------------------
Added user "testuser"
---------------------
  User login: testuser
  First name: first
  Last name: last
  Full name: first last
  Display name: first last
  Initials: fl
  Home directory: /home/testuser
  GECOS field: first last
  Login shell: /bin/sh
  Kerberos principal: testuser
  Email address: testuser
  UID: 378000003
  GID: 378000003
  Password: False
  Kerberos keys available: False
[root@vm1 quickinstall]# ipa user-mod testuser --manager=testmanager
------------------------
Modified user "testuser"
------------------------
  User login: testuser
  First name: first
  Last name: last
  Home directory: /home/testuser
  Login shell: /bin/sh
  Email address: testuser
  UID: 378000003
  GID: 378000003
  Manager: testmanager
  Account disabled: False
  Password: False
  Member of groups: ipausers
  Kerberos keys available: False
[root@vm1 quickinstall]# ipa user-find testuser --manager=testmanager
--------------
1 user matched
--------------
  User login: testuser
  First name: first
  Last name: last
  Home directory: /home/testuser
  Login shell: /bin/sh
  Email address: testuser
  UID: 378000003
  GID: 378000003
  Manager: testmanager
  Account disabled: False
  Password: False
  Kerberos keys available: False
----------------------------
Number of entries returned 1
----------------------------

Comment 12 errata-xmlrpc 2013-02-21 09:09:04 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, and where to find the updated
files, follow the link below.

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

http://rhn.redhat.com/errata/RHSA-2013-0528.html