@skip_if_github_validation @scope_reportdb @bug_reported @sle_minion

Feature: 0109 - Report database

Description: * Related GitHub Card: https://github.com/SUSE/spacewalk/issues/29433
In order to use reporting tools
As an authorized user
I want to access and use the report database named "ReportDB"

File name: srv_reportdb.feature

Relative path: secondary/srv_reportdb.feature

Scenarios

Chart

Status

Progress

Passed	90.00 %
Failed	10.00 %

Total duration:

00:01:33.688

@skip_if_github_validation @scope_reportdb @bug_reported

Scenario: Log in as admin user

@skip_if_github_validation @scope_reportdb @bug_reported

Scenario: Populate the report database after bootstrapping minions

@skip_if_github_validation @scope_reportdb @bug_reported

Scenario: Connect to the ReportDB on the server with admin user

Then I should be able to connect to the ReportDB on the server 00:00:03.006

And there should be a user allowed to create roles on the ReportDB 00:00:04.504

@skip_if_github_validation @scope_reportdb @bug_reported

Scenario: Create read-only user

When I create a read-only user for the ReportDB 00:00:03.974

Then I should see the read-only user listed on the ReportDB user accounts 00:00:02.575

@skip_if_github_validation @scope_reportdb @bug_reported

Scenario: External read-only user can connect to ReportDB and make queries

When I connect to the ReportDB with read-only user from external machine 00:00:00.069

Then I should be able to query the ReportDB 00:00:00.001

@skip_if_github_validation @scope_reportdb @bug_reported

Scenario: Read-only user can't make changes in the ReportDB

Then I should not be able to "insert" data in a ReportDB "table" as a read-only user 00:00:00.002

And I should not be able to "update" data in a ReportDB "table" as a read-only user 00:00:00.001

And I should not be able to "delete" data in a ReportDB "table" as a read-only user 00:00:00.000

And I should not be able to "insert" data in a ReportDB "view" as a read-only user 00:00:00.000

And I should not be able to "update" data in a ReportDB "view" as a read-only user 00:00:00.000

And I should not be able to "delete" data in a ReportDB "view" as a read-only user 00:00:00.000

@skip_if_github_validation @scope_reportdb @bug_reported

Scenario: ReportDB admin user can't access product database from external machine

1
2
Duration: 00:00:05.364

Given I know the ReportDB admin user credentials 00:00:05.219

Then I should be able to connect to the ReportDB with the ReportDB admin user 00:00:00.060

And I should not be able to connect to product database with the ReportDB admin user 00:00:00.084

+ Show Error + Screenshot

connection to server at "172.16.3.6", port 5432 failed: FATAL:  no pg_hba.conf entry for host "172.16.3.5", user "pythia_susemanager", database "susemanager", SSL encryption
connection to server at "172.16.3.6", port 5432 failed: FATAL:  no pg_hba.conf entry for host "172.16.3.5", user "pythia_susemanager", database "susemanager", no encryption
 (PG::ConnectionBad)
./features/step_definitions/command_steps.rb:1512:in `/^I should not be able to connect to product database with the ReportDB admin user$/'
features/secondary/srv_reportdb.feature:41:in `I should not be able to connect to product database with the ReportDB admin user'

@skip_if_github_validation @scope_reportdb @bug_reported

Scenario: The systems should match between the UI and the ReportDB

When I follow the left menu "Systems > System List > All" 00:00:00.217

And I make a list of the existing systems 00:00:10.005

Then I should find the systems from the UI in the ReportDB 00:00:00.000

@skip_if_github_validation @scope_reportdb @bug_reported @sle_minion

Scenario: System changes should be reflected in systems, on ReportDB

Given I have a property "City" with value "Arrakeen" on "sle_minion" 00:00:16.634

+ Show Info

Search by hostname: uyuni-master-suse-minion
[{"last_boot"=>"2026-05-21T17:04:12Z", "name"=>"uyuni-master-suse-minion.sumaci.aws", "id"=>1000010019, "last_checkin"=>"2026-05-21T19:23:06Z"}]

And I know the current synced_date for "sle_minion" 00:00:00.001

When I schedule a task to update ReportDB 00:00:22.092

Then I should find the updated "City" property as "Arrakeen" on the "sle_minion", on ReportDB 00:00:00.005

@skip_if_github_validation @scope_reportdb @bug_reported @bug_reported

Scenario: Cleanup: delete read-only user

When I delete the read-only user for the ReportDB 00:00:05.466

Then I shouldn't see the read-only user listed on the ReportDB user accounts 00:00:02.920