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 2192969 - Better handling of the command line and web UI cert search and/or list features
Summary: Better handling of the command line and web UI cert search and/or list features
Keywords:
Status: CLOSED ERRATA
Alias: None
Product: Red Hat Enterprise Linux 9
Classification: Red Hat
Component: ipa
Version: 9.2
Hardware: Unspecified
OS: Unspecified
unspecified
unspecified
Target Milestone: rc
: ---
Assignee: Rob Crittenden
QA Contact: Mohammad Rizwan
URL:
Whiteboard:
Depends On: 1959057 2164349
Blocks: 2164347
TreeView+ depends on / blocked
 
Reported: 2023-05-03 18:23 UTC by Rob Crittenden
Modified: 2023-11-07 09:55 UTC (History)
15 users (show)

Fixed In Version: ipa-4.10.2-2.el9
Doc Type: No Doc Update
Doc Text:
Clone Of: 2164349
Environment:
Last Closed: 2023-11-07 08:34:04 UTC
Type: Bug
Target Upstream Version:
Embargoed:

Attachments (Terms of Use)


Links
System ID Private Priority Status Summary Last Updated
Red Hat Issue Tracker FREEIPA-9840 0 None None None 2023-05-03 18:23:51 UTC
Red Hat Issue Tracker RHELPLAN-156331 0 None None None 2023-05-03 18:24:02 UTC
Red Hat Product Errata RHBA-2023:6477 0 None None None 2023-11-07 08:34:39 UTC

Comment 6 Florence Blanc-Renaud 2023-06-20 11:34:25 UTC 
Moving back to POST as a different fix was provided.

The initial fix was relying on python-OpenSSL which is not available in RHEL 9.
The new fix removes this dependency and uses a different approach to improve the perfs.

master:
https://pagure.io/freeipa/c/2a605c5d07906e157e79458724be098aab28cc7c
https://pagure.io/freeipa/c/8a250201494fa0864c81ba0bb2d16a485cdd2533
https://pagure.io/freeipa/c/fa3a69f91fcb4e15714f78a6eee4944bb8ca5e1b

ipa-4-10:
https://pagure.io/freeipa/c/276138087158c6b2ea76b43c754084144e543c0b
https://pagure.io/freeipa/c/d83a4b0babdc7beb124d3748b5815ce309739eb7
https://pagure.io/freeipa/c/d9aa75459d650e5282a160a3eef09ed175dc5b51

ipa-4-9:
https://pagure.io/freeipa/c/9fe30f21c987bdccf80ef5f6d645fdc59b393bdb
https://pagure.io/freeipa/c/3b1dbcdba2994bf57908f530913998e9ab888e4c
https://pagure.io/freeipa/c/d00fd3398c32beb2c3e72f4878c87f9d2c0e833d
Comment 10 Mohammad Rizwan 2023-07-05 10:39:46 UTC 
version:
ipa-server-4.10.2-2.el9.x86_64

Steps:
1. install ipa-server
2. generate 4000 certificate
3. $ time ipa cert-find



time take on old version:

[root@master ~]# time ipa cert-find
ipa: WARNING: Search result has been truncated: Configured size limit exceeded
------------------------
100 certificates matched
------------------------
[..]

real	0m16.550s
user	0m0.526s
sys	0m0.051s



time taken on latest version:

[root@master ~]# time ipa cert-find
------------------------
100 certificates matched
------------------------
[..]
------------------------------
Number of entries returned 100
------------------------------

real	0m2.708s
user	0m0.577s
sys	0m0.057s


when ipa cert-find without sizelimit
/var/log/httpd/access_log

xx.xx.xx.xx - - [05/Jul/2023:06:30:17 -0400] "POST /ca/rest/certs/search?size=100 HTTP/1.1" 200 55091
xx.xx.xx.xx - admin [05/Jul/2023:06:30:17 -0400] "POST /ipa/session/json HTTP/1.1" 200 2001

--sizelimit=5
xx.xx.xx.xx - - [05/Jul/2023:06:34:42 -0400] "POST /ca/rest/certs/search?size=5 HTTP/1.1" 200 2903
xx.xx.xx.xx - admin [05/Jul/2023:06:34:42 -0400] "POST /ipa/session/json HTTP/1.1" 200 407


--sizelimit=abc
[root@master ~]# ipa cert-find --sizelimit=abc
ipa: ERROR: invalid 'sizelimit': must be an integer
[root@master ~]# ipa cert-find --sizelimit=-1
ipa: ERROR: invalid 'sizelimit': must be at least 0
[root@master ~]#

--sizelimit=120

xx.xx.xx.xx - - [05/Jul/2023:06:36:14 -0400] "POST /ca/rest/certs/search?size=120 HTTP/1.1" 200 66082
xx.xx.xx.xx - admin [05/Jul/2023:06:36:14 -0400] "POST /ipa/session/json HTTP/1.1" 200 2326

[root@master ~]# ipa cert-find --sizelimit=120
------------------------
120 certificates matched
------------------------
[..]




There is significant difference between time taken on old and new version, hence marking the bug as verified.
Comment 15 errata-xmlrpc 2023-11-07 08:34: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 (ipa 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:6477
Note You need to log in before you can comment on or make changes to this bug.