This one looks like a backend issue: “Backtrace for ‘Action failed’ error (ActionView::Template::Error): PG::UndefinedColumn: ERROR: column ansible_roles.permission does not exist”
OK, meanwhile I have installed a CentOS 8 Stream machine (instead of a Stream 9) with Foreman 3.10 & Katello 4.12. Now I don’t get an error on the hostgroup - ansible tab but an empty one.
2024-04-18T12:28:32 [I|app|c74957d5] Started GET "/hostgroups/1-test/edit" for 10.5.177.144 at 2024-04-18 12:28:32 +0200
2024-04-18T12:28:32 [I|app|c74957d5] Processing by HostgroupsController#edit as HTML
2024-04-18T12:28:32 [I|app|c74957d5] Parameters: {"id"=>"1-test"}
2024-04-18T12:28:32 [I|app|c74957d5] ^[[1;32mDeface: [WARNING]^[[0m No :original defined for 'add_activation_keys_tab', you should change its definition to include:
c74957d5 | :original => 'aefc8e355300ccc5af0592fb2e7c1e5eb7a2ba6d'
2024-04-18T12:28:32 [I|app|c74957d5] ^[[1;32mDeface: [WARNING]^[[0m No :original defined for 'add_activation_keys_tab_pane', you should change its definition to include:
c74957d5 | :original => 'ce4076956541552b74e2f8cbca1656e439822d95'
2024-04-18T12:28:32 [I|app|c74957d5] ^[[1;32mDeface: [WARNING]^[[0m No :original defined for 'hostgroups_update_environments_select', you should change its definition to include:
c74957d5 | :original => 'c351571f7755090ebfd1b86f4057e0b32c0ba15e'
2024-04-18T12:28:32 [I|app|c74957d5] ^[[1;32mDeface: [WARNING]^[[0m No :original defined for 'hostgroup_ansible_roles_tab', you should change its definition to include:
c74957d5 | :original => 'a428ce0f87a47c79e5b57992242203dce92baf92'
2024-04-18T12:28:32 [I|app|c74957d5] ^[[1;32mDeface: [WARNING]^[[0m No :original defined for 'hostgroup_ansible_roles_tab_content', you should change its definition to include:
c74957d5 | :original => '6558ba826b68bee9f1a6f1bca19f765f3dd6a670'
2024-04-18T12:28:32 [I|app|c74957d5] ^[[1;32mDeface: [WARNING]^[[0m No :original defined for 'hosts_select_media_type', you should change its definition to include:
c74957d5 | :original => '2d9ab0e830d51c8cd4271ea3f3ade95cfbf3de75'
2024-04-18T12:28:32 [I|app|c74957d5] ^[[1;32mDeface: [WARNING]^[[0m No :original defined for 'hosts_select_synced_content', you should change its definition to include:
c74957d5 | :original => '2d9ab0e830d51c8cd4271ea3f3ade95cfbf3de75'
2024-04-18T12:28:32 [I|app|c74957d5] Rendered hostgroups/edit.html.erb within layouts/application (Duration: 160.2ms | Allocations: 73312)
2024-04-18T12:28:32 [I|app|c74957d5] Rendered layouts/base.html.erb (Duration: 17.0ms | Allocations: 15956)
2024-04-18T12:28:32 [I|app|c74957d5] Rendered layout layouts/application.html.erb (Duration: 178.6ms | Allocations: 89801)
2024-04-18T12:28:32 [I|app|c74957d5] Completed 200 OK in 194ms (Views: 164.5ms | ActiveRecord: 16.9ms | Allocations: 93806)
2024-04-18T12:28:33 [I|app|397a5fc7] Started GET "/notification_recipients" for 10.5.177.144 at 2024-04-18 12:28:33 +0200
2024-04-18T12:28:33 [I|app|397a5fc7] Processing by NotificationRecipientsController#index as JSON
2024-04-18T12:28:33 [I|app|397a5fc7] Completed 200 OK in 7ms (Views: 0.1ms | ActiveRecord: 0.8ms | Allocations: 1877)
2024-04-18T12:28:43 [I|app|ec5efaed] Started GET "/notification_recipients" for 10.5.177.144 at 2024-04-18 12:28:43 +0200
2024-04-18T12:28:43 [I|app|ec5efaed] Processing by NotificationRecipientsController#index as JSON
2024-04-18T12:28:43 [I|app|ec5efaed] Completed 200 OK in 7ms (Views: 0.1ms | ActiveRecord: 0.9ms | Allocations: 1877)
2024-04-18T12:28:53 [I|app|8b7abf2f] Started GET "/notification_recipients" for 10.5.177.144 at 2024-04-18 12:28:53 +0200
2024-04-18T12:28:53 [I|app|8b7abf2f] Processing by NotificationRecipientsController#index as JSON
2024-04-18T12:28:53 [I|app|8b7abf2f] Completed 200 OK in 7ms (Views: 0.1ms | ActiveRecord: 0.8ms | Allocations: 1877)
don’ know why, but situation has changed. After reinstallation of CentOS 9 Stream and Foreman 3.10 the error message within the hostgroup - ansible roles is no longer visible. Now I have the same behavior like CentOS 8 Stream and Foreman 3.10. The tab is empty. No roles, no error message. Strange
2024-04-19T07:19:44 [I|app|fbc58321] Started GET "/hostgroups/1-de01fedora38default/edit" for 10.5.177.144 at 2024-04-19 07:19:44 +0200
2024-04-19T07:19:44 [I|app|fbc58321] Processing by HostgroupsController#edit as HTML
2024-04-19T07:19:44 [I|app|fbc58321] Parameters: {"id"=>"1-de01fedora38default"}
2024-04-19T07:19:44 [I|app|fbc58321] ^[[1;32mDeface: [WARNING]^[[0m No :original defined for 'hostgroup_ansible_roles_tab', you should change its definition to include:
fbc58321 | :original => 'a428ce0f87a47c79e5b57992242203dce92baf92'
2024-04-19T07:19:44 [I|app|fbc58321] ^[[1;32mDeface: [WARNING]^[[0m No :original defined for 'hostgroup_ansible_roles_tab_content', you should change its definition to include:
fbc58321 | :original => 'fa3f6b5661bb4064206e0c56aa70865d6867d07c'
2024-04-19T07:19:44 [I|app|fbc58321] ^[[1;32mDeface: [WARNING]^[[0m No :original defined for 'add_activation_keys_tab', you should change its definition to include:
fbc58321 | :original => 'aefc8e355300ccc5af0592fb2e7c1e5eb7a2ba6d'
2024-04-19T07:19:44 [I|app|fbc58321] ^[[1;32mDeface: [WARNING]^[[0m No :original defined for 'add_activation_keys_tab_pane', you should change its definition to include:
fbc58321 | :original => 'ce4076956541552b74e2f8cbca1656e439822d95'
2024-04-19T07:19:44 [I|app|fbc58321] ^[[1;32mDeface: [WARNING]^[[0m No :original defined for 'hostgroups_update_environments_select', you should change its definition to include:
fbc58321 | :original => 'c351571f7755090ebfd1b86f4057e0b32c0ba15e'
2024-04-19T07:19:45 [I|app|fbc58321] ^[[1;32mDeface: [WARNING]^[[0m No :original defined for 'hosts_select_media_type', you should change its definition to include:
fbc58321 | :original => '2d9ab0e830d51c8cd4271ea3f3ade95cfbf3de75'
2024-04-19T07:19:45 [I|app|fbc58321] ^[[1;32mDeface: [WARNING]^[[0m No :original defined for 'hosts_select_synced_content', you should change its definition to include:
fbc58321 | :original => '2d9ab0e830d51c8cd4271ea3f3ade95cfbf3de75'
2024-04-19T07:19:45 [I|app|fbc58321] Rendered hostgroups/edit.html.erb within layouts/application (Duration: 322.5ms | Allocations: 105698)
2024-04-19T07:19:45 [I|app|fbc58321] Rendered layouts/base.html.erb (Duration: 32.0ms | Allocations: 30233)
2024-04-19T07:19:45 [I|app|fbc58321] Rendered layout layouts/application.html.erb (Duration: 358.3ms | Allocations: 137317)
2024-04-19T07:19:45 [I|app|fbc58321] Completed 200 OK in 389ms (Views: 246.1ms | ActiveRecord: 129.4ms | Allocations: 144268)
2024-04-19T07:19:45 [I|app|8f54d963] Started GET "/notification_recipients" for 10.5.177.144 at 2024-04-19 07:19:45 +0200
2024-04-19T07:19:45 [I|app|8f54d963] Processing by NotificationRecipientsController#index as JSON
2024-04-19T07:19:45 [I|app|8f54d963] Completed 200 OK in 23ms (Views: 0.2ms | ActiveRecord: 12.6ms | Allocations: 4134)
2024-04-19T07:19:49 [I|app|6aaa000f] Started GET "/hostgroups" for 10.5.177.144 at 2024-04-19 07:19:49 +0200
2024-04-19T07:19:49 [I|app|6aaa000f] Processing by HostgroupsController#index as HTML
2024-04-19T07:19:49 [I|app|6aaa000f] Rendered hostgroups/index.html.erb within layouts/application (Duration: 15.6ms | Allocations: 6196)
2024-04-19T07:19:49 [I|app|6aaa000f] Rendered layouts/base.html.erb (Duration: 14.6ms | Allocations: 15647)
2024-04-19T07:19:49 [I|app|6aaa000f] Rendered layout layouts/application.html.erb (Duration: 31.3ms | Allocations: 22507)
2024-04-19T07:19:49 [I|app|6aaa000f] Completed 200 OK in 46ms (Views: 30.1ms | ActiveRecord: 6.3ms | Allocations: 26689)
OK, I see there is a updatet version. After the upgrade to “rubygem-foreman_ansible-14.0.0-1.fm3_11.el9.noarch.rpm” nothing has changed. Within the hostgroup no Ansible-Roles are visible and also the Activation-Key edit box is missing.
2024-04-22T08:06:39 [I|app|aff733e6] Started GET "/hostgroups/1-de01fedora38default/edit" for 10.5.177.144 at 2024-04-22 08:06:39 +0200
2024-04-22T08:06:39 [I|app|aff733e6] Processing by HostgroupsController#edit as HTML
2024-04-22T08:06:39 [I|app|aff733e6] Parameters: {"id"=>"1-de01fedora38default"}
2024-04-22T08:06:39 [I|app|aff733e6] ^[[1;32mDeface: [WARNING]^[[0m No :original defined for 'hostgroup_ansible_roles_tab', you should change its definition to include:
aff733e6 | :original => 'a428ce0f87a47c79e5b57992242203dce92baf92'
2024-04-22T08:06:39 [I|app|aff733e6] ^[[1;32mDeface: [WARNING]^[[0m No :original defined for 'hostgroup_ansible_roles_tab_content', you should change its definition to include:
aff733e6 | :original => 'fa3f6b5661bb4064206e0c56aa70865d6867d07c'
2024-04-22T08:06:39 [I|app|aff733e6] ^[[1;32mDeface: [WARNING]^[[0m No :original defined for 'add_activation_keys_tab', you should change its definition to include:
aff733e6 | :original => 'aefc8e355300ccc5af0592fb2e7c1e5eb7a2ba6d'
2024-04-22T08:06:39 [I|app|aff733e6] ^[[1;32mDeface: [WARNING]^[[0m No :original defined for 'add_activation_keys_tab_pane', you should change its definition to include:
aff733e6 | :original => 'ce4076956541552b74e2f8cbca1656e439822d95'
2024-04-22T08:06:39 [I|app|aff733e6] ^[[1;32mDeface: [WARNING]^[[0m No :original defined for 'hostgroups_update_environments_select', you should change its definition to include:
aff733e6 | :original => 'c351571f7755090ebfd1b86f4057e0b32c0ba15e'
2024-04-22T08:06:39 [I|app|aff733e6] ^[[1;32mDeface: [WARNING]^[[0m No :original defined for 'hosts_select_media_type', you should change its definition to include:
aff733e6 | :original => '2d9ab0e830d51c8cd4271ea3f3ade95cfbf3de75'
2024-04-22T08:06:39 [I|app|aff733e6] ^[[1;32mDeface: [WARNING]^[[0m No :original defined for 'hosts_select_synced_content', you should change its definition to include:
aff733e6 | :original => '2d9ab0e830d51c8cd4271ea3f3ade95cfbf3de75'
2024-04-22T08:06:39 [I|app|aff733e6] Rendered hostgroups/edit.html.erb within layouts/application (Duration: 194.3ms | Allocations: 107001)
2024-04-22T08:06:39 [I|app|aff733e6] Rendered layouts/base.html.erb (Duration: 13.6ms | Allocations: 15684)
2024-04-22T08:06:39 [I|app|aff733e6] Rendered layout layouts/application.html.erb (Duration: 209.2ms | Allocations: 123270)
2024-04-22T08:06:39 [I|app|aff733e6] Completed 200 OK in 225ms (Views: 181.3ms | ActiveRecord: 31.3ms | Allocations: 128091)
2024-04-22T08:06:39 [I|app|64eff241] Started GET "/notification_recipients" for 10.5.177.144 at 2024-04-22 08:06:39 +0200
2024-04-22T08:06:39 [I|app|64eff241] Processing by NotificationRecipientsController#index as JSON
2024-04-22T08:06:39 [I|app|64eff241] Completed 200 OK in 6ms (Views: 0.2ms | ActiveRecord: 0.6ms | Allocations: 1495)
2024-04-22T08:06:44 [I|app|4db217e8] Started GET "/hostgroups" for 10.5.177.144 at 2024-04-22 08:06:44 +0200
2024-04-22T08:06:44 [I|app|4db217e8] Processing by HostgroupsController#index as HTML
2024-04-22T08:06:44 [I|app|4db217e8] Rendered hostgroups/index.html.erb within layouts/application (Duration: 13.3ms | Allocations: 5592)
2024-04-22T08:06:44 [I|app|4db217e8] Rendered layouts/base.html.erb (Duration: 13.7ms | Allocations: 15638)
2024-04-22T08:06:44 [I|app|4db217e8] Rendered layout layouts/application.html.erb (Duration: 27.9ms | Allocations: 21840)
2024-04-22T08:06:44 [I|app|4db217e8] Completed 200 OK in 37ms (Views: 25.9ms | ActiveRecord: 3.7ms | Allocations: 25100)
2024-04-22T08:06:44 [I|app|7dbbdac1] Started GET "/notification_recipients" for 10.5.177.144 at 2024-04-22 08:06:44 +0200
2024-04-22T08:06:44 [I|app|7dbbdac1] Processing by NotificationRecipientsController#index as JSON
2024-04-22T08:06:44 [I|app|7dbbdac1] Completed 200 OK in 5ms (Views: 0.2ms | ActiveRecord: 0.6ms | Allocations: 1497)
2024-04-22T08:06:44 [I|app|f3fcb144] Started GET "/hostgroups/auto_complete_search?search=" for 10.5.177.144 at 2024-04-22 08:06:44 +0200
2024-04-22T08:06:44 [I|app|f3fcb144] Processing by HostgroupsController#auto_complete_search as JSON
2024-04-22T08:06:44 [I|app|f3fcb144] Parameters: {"search"=>""}
2024-04-22T08:06:44 [I|app|f3fcb144] Completed 200 OK in 6ms (Views: 0.6ms | ActiveRecord: 0.7ms | Allocations: 3811)
2024-04-22T08:06:46 [I|app|db14dbb5] Started GET "/hostgroups/new" for 10.5.177.144 at 2024-04-22 08:06:46 +0200
2024-04-22T08:06:46 [I|app|db14dbb5] Processing by HostgroupsController#new as HTML
2024-04-22T08:06:46 [I|app|db14dbb5] Rendered hostgroups/new.html.erb within layouts/application (Duration: 43.9ms | Allocations: 24551)
2024-04-22T08:06:46 [I|app|db14dbb5] Rendered layouts/base.html.erb (Duration: 14.8ms | Allocations: 15635)
2024-04-22T08:06:46 [I|app|db14dbb5] Rendered layout layouts/application.html.erb (Duration: 59.7ms | Allocations: 40658)
2024-04-22T08:06:46 [I|app|db14dbb5] Completed 200 OK in 67ms (Views: 56.3ms | ActiveRecord: 4.6ms | Allocations: 43305)
2024-04-22T08:06:46 [I|app|0ebef979] Started GET "/notification_recipients" for 10.5.177.144 at 2024-04-22 08:06:46 +0200
2024-04-22T08:06:46 [I|app|0ebef979] Processing by NotificationRecipientsController#index as JSON
2024-04-22T08:06:46 [I|app|0ebef979] Completed 200 OK in 7ms (Views: 0.2ms | ActiveRecord: 0.8ms | Allocations: 1497)
2024-04-22T08:06:52 [I|app|d5c0c11b] Started GET "/hostgroups" for 10.5.177.144 at 2024-04-22 08:06:52 +0200
2024-04-22T08:06:52 [I|app|d5c0c11b] Processing by HostgroupsController#index as HTML
2024-04-22T08:06:52 [I|app|d5c0c11b] Rendered hostgroups/index.html.erb within layouts/application (Duration: 11.7ms | Allocations: 5603)
2024-04-22T08:06:52 [I|app|d5c0c11b] Rendered layouts/base.html.erb (Duration: 13.6ms | Allocations: 15640)