Installing foreman_openscap plugin failing

**Problem:foreman-installer --enable-foreman-plugin-openscap not succesfully installing the openscap plugin

**Expected outcome:Install the plugin successfully

**Foreman and Proxy versions:foreman version is 3.1, Openscap plugin version is 0.8

Foreman and Proxy plugin versions:

**Distribution and version:centos 7.9.2009 (Core)

**Other relevant data:*foreman-rake db:migrate failing
$ sudo foreman-installer --enable-foreman-plugin-openscap
2022-03-04 04:49:58 [NOTICE] [root] Loading installer configuration. This will take some time.
2022-03-04 04:50:02 [NOTICE] [root] Running installer with log based terminal output at level NOTICE.
2022-03-04 04:50:02 [NOTICE] [root] Use -l to set the terminal output log level to ERROR, WARN, NOTICE, INFO, or DEBUG. See --full-help for definitions.
2022-03-04 04:50:10 [NOTICE] [configure] Starting system configuration.
2022-03-04 04:50:19 [NOTICE] [configure] 250 configuration steps out of 1362 steps complete.
2022-03-04 04:50:19 [NOTICE] [configure] 500 configuration steps out of 1364 steps complete.
2022-03-04 04:50:19 [NOTICE] [configure] 750 configuration steps out of 1370 steps complete.
2022-03-04 04:50:34 [ERROR ] [configure] ā€˜/usr/sbin/foreman-rake db:migrateā€™ returned 1 instead of one of [0]
2022-03-04 04:50:34 [ERROR ] [configure] /Stage[main]/Foreman::Database/Foreman::Rake[db:migrate]/Exec[foreman-rake-db:migrate]/returns: change from ā€˜notrunā€™ to [ā€˜0ā€™] failed: ā€˜/usr/sbin/foreman-rake db:migrateā€™ returned 1 instead of one of [0]
2022-03-04 04:50:40 [NOTICE] [configure] 1000 configuration steps out of 1371 steps complete.
2022-03-04 04:50:41 [NOTICE] [configure] 1250 configuration steps out of 1371 steps complete.
2022-03-04 04:50:43 [NOTICE] [configure] System configuration has finished.

There were errors detected during install.
Please address the errors and re-run the installer to ensure the system is properly configured.
Failing to do so is likely to result in broken functionality.

The full log is at /var/log/foreman-installer/foreman.log


$ sudo foreman-rake db:migrate
API controllers newer than Apipie cache! Run apipie:cache rake task to regenerate cache.
== 20200803065041 MigratePortOverridesForAnsible: migrating ===================
rake aborted!
StandardError: An error has occurred, this and all later migrations canceled:

uninitialized constant MigratePortOverridesForAnsible::AnsibleRole
/opt/theforeman/tfm/root/usr/share/gems/gems/foreman_openscap-5.1.1/db/migrate/20200803065041_migrate_port_overrides_for_ansible.rb:14:in transform_lookup_values' /opt/theforeman/tfm/root/usr/share/gems/gems/foreman_openscap-5.1.1/db/migrate/20200803065041_migrate_port_overrides_for_ansible.rb:3:in upā€™
/opt/theforeman/tfm/root/usr/share/gems/gems/activerecord-6.0.3.7/lib/active_record/migration.rb:831:in exec_migration' /opt/theforeman/tfm/root/usr/share/gems/gems/activerecord-6.0.3.7/lib/active_record/migration.rb:812:in block (2 levels) in migrateā€™
/opt/theforeman/tfm/root/usr/share/gems/gems/activerecord-6.0.3.7/lib/active_record/migration.rb:811:in block in migrate' /opt/theforeman/tfm/root/usr/share/gems/gems/activerecord-6.0.3.7/lib/active_record/connection_adapters/abstract/connection_pool.rb:471:in with_connectionā€™
/opt/theforeman/tfm/root/usr/share/gems/gems/activerecord-6.0.3.7/lib/active_record/migration.rb:810:in migrate' /opt/theforeman/tfm/root/usr/share/gems/gems/activerecord-6.0.3.7/lib/active_record/migration.rb:1002:in migrateā€™
/opt/theforeman/tfm/root/usr/share/gems/gems/activerecord-6.0.3.7/lib/active_record/migration.rb:1310:in block in execute_migration_in_transaction' /opt/theforeman/tfm/root/usr/share/gems/gems/activerecord-6.0.3.7/lib/active_record/migration.rb:1361:in block in ddl_transactionā€™
/opt/theforeman/tfm/root/usr/share/gems/gems/activerecord-6.0.3.7/lib/active_record/connection_adapters/abstract/database_statements.rb:280:in block in transaction' /opt/theforeman/tfm/root/usr/share/gems/gems/activerecord-6.0.3.7/lib/active_record/connection_adapters/abstract/transaction.rb:280:in block in within_new_transactionā€™
/opt/theforeman/tfm/root/usr/share/gems/gems/activesupport-6.0.3.7/lib/active_support/concurrency/load_interlock_aware_monitor.rb:26:in block (2 levels) in synchronize' /opt/theforeman/tfm/root/usr/share/gems/gems/activesupport-6.0.3.7/lib/active_support/concurrency/load_interlock_aware_monitor.rb:25:in handle_interruptā€™
/opt/theforeman/tfm/root/usr/share/gems/gems/activesupport-6.0.3.7/lib/active_support/concurrency/load_interlock_aware_monitor.rb:25:in block in synchronize' /opt/theforeman/tfm/root/usr/share/gems/gems/activesupport-6.0.3.7/lib/active_support/concurrency/load_interlock_aware_monitor.rb:21:in handle_interruptā€™
/opt/theforeman/tfm/root/usr/share/gems/gems/activesupport-6.0.3.7/lib/active_support/concurrency/load_interlock_aware_monitor.rb:21:in synchronize' /opt/theforeman/tfm/root/usr/share/gems/gems/activerecord-6.0.3.7/lib/active_record/connection_adapters/abstract/transaction.rb:278:in within_new_transactionā€™
/opt/theforeman/tfm/root/usr/share/gems/gems/activerecord-6.0.3.7/lib/active_record/connection_adapters/abstract/database_statements.rb:280:in transaction' /opt/theforeman/tfm/root/usr/share/gems/gems/activerecord-6.0.3.7/lib/active_record/transactions.rb:212:in transactionā€™
/opt/theforeman/tfm/root/usr/share/gems/gems/activerecord-6.0.3.7/lib/active_record/migration.rb:1361:in ddl_transaction' /opt/theforeman/tfm/root/usr/share/gems/gems/activerecord-6.0.3.7/lib/active_record/migration.rb:1309:in execute_migration_in_transactionā€™
/opt/theforeman/tfm/root/usr/share/gems/gems/activerecord-6.0.3.7/lib/active_record/migration.rb:1281:in block in migrate_without_lock' /opt/theforeman/tfm/root/usr/share/gems/gems/activerecord-6.0.3.7/lib/active_record/migration.rb:1280:in eachā€™
/opt/theforeman/tfm/root/usr/share/gems/gems/activerecord-6.0.3.7/lib/active_record/migration.rb:1280:in migrate_without_lock' /opt/theforeman/tfm/root/usr/share/gems/gems/activerecord-6.0.3.7/lib/active_record/migration.rb:1229:in block in migrateā€™
/opt/theforeman/tfm/root/usr/share/gems/gems/activerecord-6.0.3.7/lib/active_record/migration.rb:1382:in with_advisory_lock' /opt/theforeman/tfm/root/usr/share/gems/gems/activerecord-6.0.3.7/lib/active_record/migration.rb:1229:in migrateā€™
/opt/theforeman/tfm/root/usr/share/gems/gems/activerecord-6.0.3.7/lib/active_record/migration.rb:1061:in up' /opt/theforeman/tfm/root/usr/share/gems/gems/activerecord-6.0.3.7/lib/active_record/migration.rb:1036:in migrateā€™
/opt/theforeman/tfm/root/usr/share/gems/gems/activerecord-6.0.3.7/lib/active_record/tasks/database_tasks.rb:238:in migrate' /opt/theforeman/tfm/root/usr/share/gems/gems/activerecord-6.0.3.7/lib/active_record/railties/databases.rake:86:in block (3 levels) in <top (required)>ā€™
/opt/theforeman/tfm/root/usr/share/gems/gems/activerecord-6.0.3.7/lib/active_record/railties/databases.rake:84:in each' /opt/theforeman/tfm/root/usr/share/gems/gems/activerecord-6.0.3.7/lib/active_record/railties/databases.rake:84:in block (2 levels) in <top (required)>ā€™
/opt/rh/rh-ruby27/root/usr/share/gems/gems/rake-13.0.1/exe/rake:27:in `<top (required)>ā€™

Caused by:
NameError: uninitialized constant MigratePortOverridesForAnsible::AnsibleRole
/opt/theforeman/tfm/root/usr/share/gems/gems/foreman_openscap-5.1.1/db/migrate/20200803065041_migrate_port_overrides_for_ansible.rb:14:in transform_lookup_values' /opt/theforeman/tfm/root/usr/share/gems/gems/foreman_openscap-5.1.1/db/migrate/20200803065041_migrate_port_overrides_for_ansible.rb:3:in upā€™
/opt/theforeman/tfm/root/usr/share/gems/gems/activerecord-6.0.3.7/lib/active_record/migration.rb:831:in exec_migration' /opt/theforeman/tfm/root/usr/share/gems/gems/activerecord-6.0.3.7/lib/active_record/migration.rb:812:in block (2 levels) in migrateā€™
/opt/theforeman/tfm/root/usr/share/gems/gems/activerecord-6.0.3.7/lib/active_record/migration.rb:811:in block in migrate' /opt/theforeman/tfm/root/usr/share/gems/gems/activerecord-6.0.3.7/lib/active_record/connection_adapters/abstract/connection_pool.rb:471:in with_connectionā€™
/opt/theforeman/tfm/root/usr/share/gems/gems/activerecord-6.0.3.7/lib/active_record/migration.rb:810:in migrate' /opt/theforeman/tfm/root/usr/share/gems/gems/activerecord-6.0.3.7/lib/active_record/migration.rb:1002:in migrateā€™
/opt/theforeman/tfm/root/usr/share/gems/gems/activerecord-6.0.3.7/lib/active_record/migration.rb:1310:in block in execute_migration_in_transaction' /opt/theforeman/tfm/root/usr/share/gems/gems/activerecord-6.0.3.7/lib/active_record/migration.rb:1361:in block in ddl_transactionā€™
/opt/theforeman/tfm/root/usr/share/gems/gems/activerecord-6.0.3.7/lib/active_record/connection_adapters/abstract/database_statements.rb:280:in block in transaction' /opt/theforeman/tfm/root/usr/share/gems/gems/activerecord-6.0.3.7/lib/active_record/connection_adapters/abstract/transaction.rb:280:in block in within_new_transactionā€™
/opt/theforeman/tfm/root/usr/share/gems/gems/activesupport-6.0.3.7/lib/active_support/concurrency/load_interlock_aware_monitor.rb:26:in block (2 levels) in synchronize' /opt/theforeman/tfm/root/usr/share/gems/gems/activesupport-6.0.3.7/lib/active_support/concurrency/load_interlock_aware_monitor.rb:25:in handle_interruptā€™
/opt/theforeman/tfm/root/usr/share/gems/gems/activesupport-6.0.3.7/lib/active_support/concurrency/load_interlock_aware_monitor.rb:25:in block in synchronize' /opt/theforeman/tfm/root/usr/share/gems/gems/activesupport-6.0.3.7/lib/active_support/concurrency/load_interlock_aware_monitor.rb:21:in handle_interruptā€™
/opt/theforeman/tfm/root/usr/share/gems/gems/activesupport-6.0.3.7/lib/active_support/concurrency/load_interlock_aware_monitor.rb:21:in synchronize' /opt/theforeman/tfm/root/usr/share/gems/gems/activerecord-6.0.3.7/lib/active_record/connection_adapters/abstract/transaction.rb:278:in within_new_transactionā€™
/opt/theforeman/tfm/root/usr/share/gems/gems/activerecord-6.0.3.7/lib/active_record/connection_adapters/abstract/database_statements.rb:280:in transaction' /opt/theforeman/tfm/root/usr/share/gems/gems/activerecord-6.0.3.7/lib/active_record/transactions.rb:212:in transactionā€™
/opt/theforeman/tfm/root/usr/share/gems/gems/activerecord-6.0.3.7/lib/active_record/migration.rb:1361:in ddl_transaction' /opt/theforeman/tfm/root/usr/share/gems/gems/activerecord-6.0.3.7/lib/active_record/migration.rb:1309:in execute_migration_in_transactionā€™
/opt/theforeman/tfm/root/usr/share/gems/gems/activerecord-6.0.3.7/lib/active_record/migration.rb:1281:in block in migrate_without_lock' /opt/theforeman/tfm/root/usr/share/gems/gems/activerecord-6.0.3.7/lib/active_record/migration.rb:1280:in eachā€™
/opt/theforeman/tfm/root/usr/share/gems/gems/activerecord-6.0.3.7/lib/active_record/migration.rb:1280:in migrate_without_lock' /opt/theforeman/tfm/root/usr/share/gems/gems/activerecord-6.0.3.7/lib/active_record/migration.rb:1229:in block in migrateā€™
/opt/theforeman/tfm/root/usr/share/gems/gems/activerecord-6.0.3.7/lib/active_record/migration.rb:1382:in with_advisory_lock' /opt/theforeman/tfm/root/usr/share/gems/gems/activerecord-6.0.3.7/lib/active_record/migration.rb:1229:in migrateā€™
/opt/theforeman/tfm/root/usr/share/gems/gems/activerecord-6.0.3.7/lib/active_record/migration.rb:1061:in up' /opt/theforeman/tfm/root/usr/share/gems/gems/activerecord-6.0.3.7/lib/active_record/migration.rb:1036:in migrateā€™
/opt/theforeman/tfm/root/usr/share/gems/gems/activerecord-6.0.3.7/lib/active_record/tasks/database_tasks.rb:238:in migrate' /opt/theforeman/tfm/root/usr/share/gems/gems/activerecord-6.0.3.7/lib/active_record/railties/databases.rake:86:in block (3 levels) in <top (required)>ā€™
/opt/theforeman/tfm/root/usr/share/gems/gems/activerecord-6.0.3.7/lib/active_record/railties/databases.rake:84:in each' /opt/theforeman/tfm/root/usr/share/gems/gems/activerecord-6.0.3.7/lib/active_record/railties/databases.rake:84:in block (2 levels) in <top (required)>ā€™
/opt/rh/rh-ruby27/root/usr/share/gems/gems/rake-13.0.1/exe/rake:27:in `<top (required)>ā€™
Tasks: TOP => db:migrate
(See full trace by running task with --trace)


/var/log/foreman-installer/foreman.log

$ sudo cat /var/log/foreman-installer/foreman.log | grep -i error
2022-03-04 04:50:02 [NOTICE] [root] Use -l to set the terminal output log level to ERROR, WARN, NOTICE, INFO, or DEBUG. See --full-help for definitions.
2022-03-04 04:50:12 [DEBUG ] [configure] Facter: Error reading file: No such file or directory
2022-03-04 04:50:12 [DEBUG ] [configure] -D DEFAULT_ERRORLOG=ā€œlogs/error_logā€
2022-03-04 04:50:12 [DEBUG ] [configure] -D DEFAULT_ERRORLOG=ā€œlogs/error_logā€
2022-03-04 04:50:13 [DEBUG ] [configure] Error Correction Type: Multi-bit ECC
2022-03-04 04:50:13 [DEBUG ] [configure] Error Information Handle: Not Provided
2022-03-04 04:50:13 [DEBUG ] [configure] Error Information Handle: 0x0000
2022-03-04 04:50:13 [DEBUG ] [configure] Status: No errors detected
2022-03-04 04:50:13 [DEBUG ] [configure] Facter: unreachable ::/96 dev lo metric 1024 error -113 pref medium
2022-03-04 04:50:13 [DEBUG ] [configure] Facter: unreachable ::ffff:0.0.0.0/96 dev lo metric 1024 error -113 pref medium
2022-03-04 04:50:13 [DEBUG ] [configure] Facter: unreachable 2002:a00::/24 dev lo metric 1024 error -113 pref medium
2022-03-04 04:50:13 [DEBUG ] [configure] Facter: unreachable 2002:7f00::/24 dev lo metric 1024 error -113 pref medium
2022-03-04 04:50:13 [DEBUG ] [configure] Facter: unreachable 2002:a9fe::/32 dev lo metric 1024 error -113 pref medium
2022-03-04 04:50:13 [DEBUG ] [configure] Facter: unreachable 2002:ac10::/28 dev lo metric 1024 error -113 pref medium
2022-03-04 04:50:13 [DEBUG ] [configure] Facter: unreachable 2002:c0a8::/32 dev lo metric 1024 error -113 pref medium
2022-03-04 04:50:13 [DEBUG ] [configure] Facter: unreachable 2002:e000::/19 dev lo metric 1024 error -113 pref medium
2022-03-04 04:50:13 [DEBUG ] [configure] Facter: unreachable 3ffe:ffff::/32 dev lo metric 1024 error -113 pref medium
2022-03-04 04:50:15 [DEBUG ] [configure] Automatic Parameter Lookup of ā€˜foreman_proxy::log_buffer_errorsā€™
2022-03-04 04:50:15 [DEBUG ] [configure] Searching for ā€œforeman_proxy::log_buffer_errorsā€
2022-03-04 04:50:15 [DEBUG ] [configure] No such key: ā€œforeman_proxy::log_buffer_errorsā€
2022-03-04 04:50:15 [DEBUG ] [configure] Found key: ā€œforeman_proxy::log_buffer_errorsā€ value: 1000
2022-03-04 04:50:34 [INFO ] [configure] /Stage[main]/Foreman::Database/Foreman::Rake[db:migrate]/Exec[foreman-rake-db:migrate]/returns: StandardError: An error has occurred, this and all later migrations canceled:
2022-03-04 04:50:34 [INFO ] [configure] /Stage[main]/Foreman::Database/Foreman::Rake[db:migrate]/Exec[foreman-rake-db:migrate]/returns: NameError: uninitialized constant MigratePortOverridesForAnsible::AnsibleRole
2022-03-04 04:50:34 [ERROR ] [configure] ā€˜/usr/sbin/foreman-rake db:migrateā€™ returned 1 instead of one of [0]
2022-03-04 04:50:34 [ERROR ] [configure] /Stage[main]/Foreman::Database/Foreman::Rake[db:migrate]/Exec[foreman-rake-db:migrate]/returns: change from ā€˜notrunā€™ to [ā€˜0ā€™] failed: ā€˜/usr/sbin/foreman-rake db:migrateā€™ returned 1 instead of one of [0]

Please helpā€¦

This looks similar to the problem with the ansible plugin. I have posted a workaround in Enabling ansible plugin results in failure of db:migrate - #7 by Dirk and Ondrej the fix for it one post later. I hope you can fix this in a similar way.

1 Like

I have tried the workaround provided here: [Enabling ansible plugin results in failure of db:migrate - #5 by dafsjr], but I am not winning

I executed the ff commands:
mv /opt/theforeman/tfm/root/usr/share/gems/gems/foreman_openscap-5.2.1/app/graphql /tmp

Unfortunately I could not find the register.rb file:

[root@foreman foreman_openscap]# ls -ltr /opt/theforeman/tfm/root/usr/share/gems/gems/foreman_openscap-5.2.1/lib/foreman_openscap/
total 40
-rw-r--r--. 1 root root    54 Feb  4 01:29 version.rb
-rw-r--r--. 1 root root  1028 Feb  4 01:29 message_cleaner.rb
-rw-r--r--. 1 root root   717 Feb  4 01:29 helper.rb
-rw-r--r--. 1 root root  3096 Feb  4 01:29 data_migration.rb
-rw-r--r--. 1 root root  2849 Feb  4 01:29 bulk_upload.rb
-rw-r--r--. 1 root root 18545 Mar 29 12:32 engine.rb
[root@foreman foreman_openscap]#

I could only find the graphql code bolded in the contents of the engine.rb file below:

module ForemanOpenscap
def self.with_katello?
defined?(::Katello)
end

class Engine < ::Rails::Engine
engine_name ā€˜foreman_openscapā€™
config.autoload_paths += Dir["#{config.root}/app/controllers/concerns"]
config.autoload_paths += Dir["#{config.root}/app/helpers/concerns"]
config.autoload_paths += Dir["#{config.root}/app/models/concerns"]
config.autoload_paths += Dir["#{config.root}/app/models"]
config.autoload_paths += Dir["#{config.root}/app/graphql"]
config.autoload_paths += Dir["#{config.root}/app/lib"]
config.autoload_paths += Dir["#{config.root}/app/services"]
config.autoload_paths += Dir["#{config.root}/lib"]
config.autoload_paths += Dir["#{config.root}/test/"]

# Add any db migrations
initializer "foreman_openscap.load_app_instance_data" do |app|
  ForemanOpenscap::Engine.paths['db/migrate'].existent.each do |path|
    app.config.paths['db/migrate'] << path
  end
end

assets_to_precompile =
  Dir.chdir(root) do
    Dir['app/assets/javascripts/foreman_openscap/**/*', 'app/assets/stylesheets/foreman_openscap/**/*'].map do |f|
      f.split(File::SEPARATOR, 4).last
    end
  end

initializer 'foreman_openscap.assets.precompile' do |app|
  app.config.assets.precompile += assets_to_precompile
end

initializer 'foreman_openscap.configure_assets', :group => :assets do
  SETTINGS[:foreman_openscap] =
    { :assets => { :precompile => assets_to_precompile } }
end

initializer 'foreman_openscap.apipie' do
  Apipie.configuration.checksum_path += ['/compliance/']
end

initializer 'foreman_openscap.filter_large_params' do |app|
  app.config.filter_parameters += %i[logs scap_file oval_results] if app.config.filter_parameters
end

initializer 'foreman_openscap.register_plugin', :before => :finisher_hook do |app|
  Foreman::Plugin.register :foreman_openscap do
    requires_foreman '>= 1.24'

    apipie_documented_controllers ["#{ForemanOpenscap::Engine.root}/app/controllers/api/v2/compliance/*.rb"]

    register_custom_status ForemanOpenscap::ComplianceStatus
    register_custom_status ForemanOpenscap::OvalStatus

    # Add permissions
    security_block :foreman_openscap do
      permission :view_arf_reports, { :arf_reports => %i[index show parse_html show_html
                                                         parse_bzip auto_complete_search download_html],
                                      'api/v2/compliance/arf_reports' => %i[index show download download_html],
                                      :compliance_hosts => [:show] },
                 :resource_type => 'ForemanOpenscap::ArfReport'
      permission :destroy_arf_reports, { :arf_reports => %i[destroy delete_multiple submit_delete_multiple],
                                         'api/v2/compliance/arf_reports' => [:destroy] },
                 :resource_type => 'ForemanOpenscap::ArfReport'
      permission :create_arf_reports, { 'api/v2/compliance/arf_reports' => [:create] },
                 :resource_type => 'ForemanOpenscap::ArfReport'

      permission :view_policies, { :policies => %i[index show parse auto_complete_search],
                                   :policy_dashboard => [:index],
                                   :compliance_dashboard        => [:index],
                                   'api/v2/compliance/policies' => %i[index show content] },
                 :resource_type => 'ForemanOpenscap::Policy'
      permission :edit_policies, { :policies => %i[edit update scap_content_selected],
                                   'api/v2/compliance/policies' => [:update] },
                 :resource_type => 'ForemanOpenscap::Policy'
      permission :create_policies, { :policies => %i[new create],
                                     'api/v2/compliance/policies' => [:create] },
                 :resource_type => 'ForemanOpenscap::Policy'
      permission :destroy_policies, { :policies => [:destroy],
                                      'api/v2/compliance/policies' => [:destroy] },
                 :resource_type => 'ForemanOpenscap::Policy'
      permission :assign_policies, { :policies => %i[select_multiple_hosts update_multiple_hosts
                                                     disassociate_multiple_hosts
                                                     remove_policy_from_multiple_hosts] },
                 :resource_type => 'ForemanOpenscap::Policy'
      permission :view_scap_contents, { :scap_contents => %i[index show auto_complete_search],
                                        'api/v2/compliance/scap_contents' => %i[index show xml],
                                        'api/v2/compliance/scap_content_profiles' => %i[index] },
                 :resource_type => 'ForemanOpenscap::ScapContent'
      permission :edit_scap_contents, { :scap_contents => %i[edit update],
                                        'api/v2/compliance/scap_contents' => [:update] },
                 :resource_type => 'ForemanOpenscap::ScapContent'
      permission :create_scap_contents, { :scap_contents => %i[new create],
                                          'api/v2/compliance/scap_contents' => %i[create bulk_upload] },
                 :resource_type => 'ForemanOpenscap::ScapContent'
      permission :destroy_scap_contents, { :scap_contents => [:destroy],
                                           'api/v2/compliance/scap_contents' => [:destroy] },
                 :resource_type => 'ForemanOpenscap::ScapContent'
      permission :edit_hosts, { :hosts => %i[openscap_proxy_changed
                                             select_multiple_openscap_proxy
                                             update_multiple_openscap_proxy] },
                 :resource_type => "Host"
      permission :view_hosts, { 'api/v2/hosts' => [:policies_enc] }, :resource_type => 'Host'
      permission :edit_hostgroups, { :hostgroups => [:openscap_proxy_changed] }, :resource_type => "Hostgroup"
      permission :create_tailoring_files, { :tailoring_files => %i[create new],
                                            'api/v2/compliance/tailoring_files' => [:create] },
                 :resource_type => 'ForemanOpenscap::TailoringFile'
      permission :view_tailoring_files, { :tailoring_files => %i[index auto_complete_search xml],
                                          :policies => [:tailoring_file_selected],
                                          'api/v2/compliance/tailoring_files' => %i[show xml index],
                                          'api/v2/compliance/policies' => [:tailoring],
                                          'api/v2/compliance/scap_content_profiles' => %i[index] },
                 :resource_type => 'ForemanOpenscap::TailoringFile'
      permission :edit_tailoring_files, { :tailoring_files => %i[edit update],
                                          'api/v2/compliance/tailoring_files' => [:update] },
                 :resource_type => 'ForemanOpenscap::TailoringFile'
      permission :destroy_tailoring_files, { :tailoring_files => [:destroy],
                                             'api/v2/compliance/tailoring_files' => [:destroy] },
                 :resource_type => 'ForemanOpenscap::TailoringFile'
      permission :view_openscap_proxies, { :openscap_proxies => [:openscap_spool] },
                 :resource_type => 'SmartProxy'
      permission :view_oval_contents, { 'api/v2/compliance/oval_contents' => %i[index show] },
                 :resource_type => 'ForemanOpenscap::OvalContent'
      permission :edit_oval_contents, { 'api/v2/compliance/oval_contents' => %i[update sync] },
                 :resource_type => 'ForemanOpenscap::OvalContent'
      permission :create_oval_contents, { 'api/v2/compliance/oval_contents' => %i[create] },
                 :resource_type => 'ForemanOpenscap::OvalContent'
      permission :destroy_oval_contents, { 'api/v2/compliance/oval_contents' => %i[destroy] },
                 :resource_type => 'ForemanOpenscap::OvalContent'
      permission :view_oval_policies, { 'api/v2/compliance/oval_policies' => %i[index show oval_content] },
                 :resource_type => 'ForemanOpenscap::OvalPolicy'
      permission :edit_oval_policies, { 'api/v2/compliance/oval_policies' => %i[update assign_hosts assign_hostgroups] },
                 :resource_type => 'ForemanOpenscap::OvalPolicy'
      permission :create_oval_policies, { 'api/v2/compliance/oval_policies' => %i[create] },
                 :resource_type => 'ForemanOpenscap::OvalPolicy'
      permission :destroy_oval_policies, { 'api/v2/compliance/oval_policies' => %i[destroy] },
                 :resource_type => 'ForemanOpenscap::OvalPolicy'
      permission :create_oval_policies, { 'api/v2/compliance/oval_reports' => %i[create] },
                 :resource_type => 'ForemanOpenscap::Cve'
    end

    role "Compliance viewer", %i[view_arf_reports view_policies view_scap_contents view_tailoring_files view_openscap_proxies],
         "Role granting read permissions to policy configuration, scan results and downloading reports."
    role "Compliance manager", %i[view_arf_reports view_policies view_scap_contents
                                  destroy_arf_reports edit_policies edit_scap_contents assign_policies
                                  create_policies create_scap_contents destroy_policies destroy_scap_contents
                                  create_tailoring_files view_tailoring_files edit_tailoring_files destroy_tailoring_files
                                  view_openscap_proxies],
         "Role granting all permissions to compliance features to non-admin users."
    role "Create ARF report", [:create_arf_reports] # special as only Proxy can create

    add_all_permissions_to_default_roles

    # add menu entries
    divider :top_menu, :caption => N_('Compliance'), :parent => :hosts_menu
    menu :top_menu, :compliance_policies, :caption => N_('Policies'),
                                          :url_hash => { :controller => :policies, :action => :index },
                                          :parent => :hosts_menu
    menu :top_menu, :compliance_contents, :caption => N_('SCAP contents'),
                                          :url_hash => { :controller => :scap_contents, :action => :index },
                                          :parent => :hosts_menu
    menu :top_menu, :compliance_reports, :caption => N_('Reports'),
                                         :url_hash => { :controller => :arf_reports, :action => :index },
                                         :parent => :hosts_menu
    menu :top_menu, :compliance_files, :caption => N_('Tailoring Files'),
                                       :url_hash => { :controller => :tailoring_files, :action => :index },
                                       :parent => :hosts_menu
    menu :labs_menu, :oval_contents, :caption => N_('OVAL Contents'),
                                     :url_hash => { :controller => 'react', :action => 'index' },
                                     :url => '/experimental/compliance/oval_contents',
                                     :parent => :lab_features_menu

    menu :labs_menu, :oval_policies, :caption => N_('OVAL Policies'),
                                     :url_hash => { :controller => 'react', :action => 'index' },
                                     :url => '/experimental/compliance/oval_policies',
                                     :parent => :lab_features_menu
    # add dashboard widget
    widget 'compliance_host_reports_widget',
           :name => N_('Latest Compliance Reports'), :sizex => 6, :sizey => 1
    widget 'compliance_reports_breakdown_widget',
           :name => N_('Compliance Reports Breakdown'), :sizex => 4, :sizey => 1

    # As 'arf_report_breakdowns' is a view and does not appear in schema.rb, db:test:prepare will not create the view
    # which will make the following tests fail.
    tests_to_skip({ "DashboardIntegrationTest" => ["dashboard page", "dashboard link hosts that had performed modifications",
                                                   "dashboard link hosts in error state", "dashboard link good host reports",
                                                   "dashboard link hosts that had pending changes", "dashboard link out of sync hosts",
                                                   "dashboard link hosts with no reports", "dashboard link hosts with alerts disabled",
                                                   "widgets not in dashboard show up in list"] })
    # strong params
    parameter_filter ::Host::Managed, :openscap_proxy_id, :openscap_proxy
    parameter_filter ::Hostgroup, :openscap_proxy_id, :openscap_proxy
    parameter_filter Log, :result

    proxy_description = N_('OpenSCAP Proxy to use for fetching SCAP content and uploading ARF reports. Leave blank and override appropriate parameters when using proxy load balancer.')

    smart_proxy_for ::Hostgroup, :openscap_proxy,
                    :feature => 'Openscap',
                    :label => N_('OpenSCAP Proxy'),
                    :description => proxy_description,
                    :api_description => N_('ID of OpenSCAP Proxy')
    smart_proxy_for Host::Managed, :openscap_proxy,
                    :feature => 'Openscap',
                    :label => N_('OpenSCAP Proxy'),
                    :description => proxy_description,
                    :api_description => N_('ID of OpenSCAP Proxy')

    add_controller_action_scope('Api::V2::HostsController', :index) do |base_scope|
      base_scope.preload(:policies)
    end

    add_controller_action_scope('HostsController', :index) do |base_scope|
      base_scope.preload(:policies)
    end

    register_global_js_file 'global'

    **register_graphql_query_field :oval_contents, '::Types::OvalContent', :collection_field**

** register_graphql_query_field :oval_content, ā€˜::Types::OvalContentā€™, :record_field**
** register_graphql_query_field :oval_policies, ā€˜::Types::OvalPolicyā€™, :collection_field**
** register_graphql_query_field :oval_policy, ā€˜::Types::OvalPolicyā€™, :record_field**
** register_graphql_query_field :cves, ā€˜::Types::Cveā€™, :collection_field**

** register_graphql_mutation_field :delete_oval_policy, ::Mutations::OvalPolicies::Delete**
** register_graphql_mutation_field :delete_oval_content, ::Mutations::OvalContents::Delete**
** register_graphql_mutation_field :update_oval_policy, ::Mutations::OvalPolicies::Update**
** register_graphql_mutation_field :create_oval_policy, ::Mutations::OvalPolicies::Create**

    register_facet ForemanOpenscap::Host::OvalFacet, :oval_facet do
      configure_host do
        extend_model ForemanOpenscap::OvalFacetHostExtensions
      end

      configure_hostgroup(ForemanOpenscap::Hostgroup::OvalFacet) do
        extend_model ForemanOpenscap::OvalFacetHostgroupExtensions
      end
    end

    describe_host do
      multiple_actions_provider :compliance_host_multiple_actions
      overview_buttons_provider :compliance_host_overview_button
    end
  end
end

initializer 'foreman_openscap.register_gettext', after: :load_config_initializers do |_app|
  locale_dir = File.join(File.expand_path('../../..', __FILE__), 'locale')
  locale_domain = 'foreman_openscap'
  Foreman::Gettext::Support.add_text_domain locale_domain, locale_dir
end

# Include concerns in this config.to_prepare block
config.to_prepare do
  ::Api::V2::HostsController.send(:include, ForemanOpenscap::Api::V2::HostsControllerExtensions)
  ::Host::Managed.send(:include, ForemanOpenscap::OpenscapProxyExtensions)
  ::Host::Managed.send(:include, ForemanOpenscap::OpenscapProxyCoreExtensions)
  ::Host::Managed.send(:prepend, ForemanOpenscap::HostExtensions)
  HostsHelper.send(:prepend, ForemanOpenscap::HostsHelperExtensions)
  ::Hostgroup.send(:include, ForemanOpenscap::OpenscapProxyExtensions)
  ::Hostgroup.send(:include, ForemanOpenscap::OpenscapProxyCoreExtensions)
  ::Hostgroup.send(:include, ForemanOpenscap::HostgroupExtensions)
  SmartProxy.send(:include, ForemanOpenscap::SmartProxyExtensions)
  HostsController.send(:prepend, ForemanOpenscap::HostsControllerExtensions)
  HostsController.send(:include, ForemanOpenscap::HostsAndHostgroupsControllerExtensions)
  HostgroupsController.send(:include, ForemanOpenscap::HostsAndHostgroupsControllerExtensions)
  Log.send(:include, ForemanOpenscap::LogExtensions)
  BookmarkControllerValidator.send(:prepend, ForemanOpenscap::BookmarkControllerValidatorExtensions)
  ProxyStatus.status_registry.add(ProxyStatus::OpenscapSpool)

  if ForemanOpenscap.with_remote_execution?
    options = {
      :description => N_("Run OpenSCAP scan"),
      :provided_inputs => "policies"
    }

    oval_options = {
      :description => N_("Run OVAL scan")
    }

    if Gem::Version.new(ForemanRemoteExecution::VERSION) >= Gem::Version.new('1.2.3')
      options[:host_action_button] = true
      oval_options[:host_action_button] = (!::Foreman.in_rake? && ActiveRecord::Base.connection.table_exists?(:settings)) ? (Setting.find_by(:name => 'lab_features')&.value || false) : false
    end

    RemoteExecutionFeature.register(:foreman_openscap_run_scans, N_("Run OpenSCAP scan"), options)
    RemoteExecutionFeature.register(:foreman_openscap_run_oval_scans, N_("Run OVAL scan"), oval_options)
  end
end

rake_tasks do
  Rake::Task['db:seed'].enhance do
    ForemanOpenscap::Engine.load_seed
  end
end

end

def self.table_name_prefix
ā€œforeman_openscap_ā€
end

def self.use_relative_model_naming?
true
end

def self.with_remote_execution?
RemoteExecutionFeature rescue false
end
end

The problem has been solved by installing the centos-release-ansible-29.noarch package as a prerequisite on a fresh OS install.

All thanks to @gyokiss: [ERROR ] [configure] /usr/sbin/foreman-rake db:migrate' returned 1 instead of one of [0] - #7 by gyokiss