Bug 2051462
Summary: | Unable to correctly search for User field in Advanced view of Events pane | ||
---|---|---|---|
Product: | [oVirt] ovirt-engine | Reporter: | Gianluca Cecchi <gianluca.cecchi> |
Component: | Search-Backend | Assignee: | Eli Mesika <emesika> |
Status: | CLOSED CURRENTRELEASE | QA Contact: | Guilherme Santos <gdeolive> |
Severity: | medium | Docs Contact: | |
Priority: | medium | ||
Version: | 4.4.10.6 | CC: | bugs, emesika, mperina |
Target Milestone: | ovirt-4.5.0 | Flags: | mperina:
ovirt-4.5+
|
Target Release: | 4.5.0.1 | ||
Hardware: | Unspecified | ||
OS: | Unspecified | ||
Whiteboard: | |||
Fixed In Version: | ovirt-engine-4.5.0.1 | Doc Type: | Bug Fix |
Doc Text: |
Cause: search by user not supported in advanced event view due to value mismatch in DB
Consequence:
Fix:
Add search vy user_and_domain in advanced event view
Result:
problem solved
|
Story Points: | --- |
Clone Of: | Environment: | ||
Last Closed: | 2022-04-28 09:26:34 UTC | Type: | Bug |
Regression: | --- | Mount Type: | --- |
Documentation: | --- | CRM: | |
Verified Versions: | Category: | --- | |
oVirt Team: | Infra | RHEL 7.3 requirements from Atomic Host: | |
Cloudforms Team: | --- | Target Upstream Version: | |
Embargoed: |
Description
Gianluca Cecchi
2022-02-07 10:13:34 UTC
The documentation text flag should only be set after 'doc text' field is provided. Please provide the documentation text and set the flag to '?' again. The cause of this problem is that the events advanced view get its data from two tables : audit_log vdc_users_with_tags The search engine joins those tables based on the user_id However while in audit_log the user_name column is of the format <username@domain> (for example admin@internal) in vdc_users_with_tags the corresponding name column is of the format <username> only (without @domain for example admin) This cause empty results when searching for a <user@domain> format because only <user> exists in the vdc_users_with_tags joined table I see no easy fix for that. I am thinking about Option A 1. Adjusting name in vdc_users_with_tags to have <username@domain> format 2. Remove the domain from vdc_users_with_tags 3. Handle DB upgrade 4. Adjusting search engine to work with that Option B 1. Renaming the current "User" in events advanced view to domain and display only the domain name (i.e. "internal" for example) 2. renaming audit_log:user_name to be something like user_name_and_domain (this will not be retrieved) 3. Adding a computed user_name DB column on audit_log table displaying only the user part of user_name_and_domain 4. Adding a computed user_domain DB column on audit_log table displaying only the domain part of user_name_and_domain 5. Handle DB upgrade 6. Adjusting search engine to work with that Any other idea ? In both we should do cross project tests to verify that we don't have backward compatibility issues Solution suggests adding a 'user_and_domain' column to the users table , include it in 'vdc_users' and 'vdc_users_with_tags' views and enhance the search engine mechanism to support this column. In addition, renaming for clarity the 'User' column in the Events Advance View to be 'User & Domain' This bugzilla is included in oVirt 4.5.0 release, published on April 20th 2022. Since the problem described in this bug report should be resolved in oVirt 4.5.0 release, it has been closed with a resolution of CURRENT RELEASE. If the solution does not work for you, please open a new bug report. |