Note: This bug is displayed in read-only format because
the product is no longer active in Red Hat Bugzilla.
Red Hat Satellite engineering is moving the tracking of its product development work on Satellite 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 "Satellite project" in Red Hat Jira and file new tickets here. Individual Bugzilla bugs will be migrated starting at the end of May. 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 "Satellite project" in Red Hat Jira (issue links are of type "https://issues.redhat.com/browse/SAT-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.
Description of problem:
Remote execution with non-admin user having role 'Remote Execution User' or 'Remote Execution Manager' do not work and fails with error "rendering 403 because of missing permission ".
Version-Release number of selected component (if applicable):
How reproducible:
Always
Steps to Reproduce:
1. From satellite webui create non-admin user.
2. Assign role 'Remote Execution User' or 'Remote Execution Manager' or can assign all roles except 'Administrator' check mark.
3. Login satellite as non-admin user --> Hosts --> Host Collection --> Click on host collection name --> Collection actions --> Errata installation --> Select errata --> click on drop down of 'install selected' --> select 'via remote execution' or 'via remote execution -customize first'
Actual results:
On satellite webui:
*********************
Permission denied You are not authorized to perform this action.
Please request one of the required permissions listed below from a Satellite administrator:
*********************
Debug log entries from satellite terminal.
*********************
==> /var/log/foreman/production.log <==
2017-04-17 07:13:05 [sql] [D] (1.0ms) SELECT "katello_events"."object_id" FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' ORDER BY "katello_events"."
created_at" ASC LIMIT 1
2017-04-17 07:13:05 [sql] [D] (0.3ms) SELECT "katello_events"."event_type" FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' ORDER BY "katello_events".
"created_at" ASC LIMIT 1
2017-04-17 07:13:05 [sql] [D] Katello::Event Load (0.5ms) SELECT "katello_events".* FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' AND 1=0 AND 1=0 OR
DER BY "katello_events"."created_at" DESC LIMIT 1
2017-04-17 07:13:05 [sql] [D] SQL (0.6ms) UPDATE "katello_events" SET "in_progress" = 't' WHERE "katello_events"."id" IN (SELECT "katello_events"."id" FROM "katello_event
s" WHERE "katello_events"."in_progress" = 'f' AND 1=0 AND 1=0 ORDER BY "katello_events"."created_at" ASC)
2017-04-17 07:13:05 [app] [I] Started POST "/katello/remote_execution" for 10.76.1.49 at 2017-04-17 07:13:05 +0530
2017-04-17 07:13:05 [app] [I] Processing by Katello::RemoteExecutionController#create as HTML
2017-04-17 07:13:05 [app] [I] Parameters: {"name"=>"RHEA-2016:2832", "remote_action"=>"errata_install", "scoped_search"=>"", "host_ids"=>"37", "authenticity_token"=>"5Gkwl
WUAsZt7YnMHlotnGuqn9+Mp/v6zzj3JEgAYGMk=", "customize"=>"true"}
2017-04-17 07:13:05 [sql] [D] ActiveRecord::SessionStore::Session Load (0.9ms) SELECT "sessions".* FROM "sessions" WHERE "sessions"."session_id" = '735b9268eeb1f72303f0
d8fa64131868' ORDER BY "sessions"."id" ASC LIMIT 1
2017-04-17 07:13:05 [sql] [D] User Load (0.3ms) SELECT "users".* FROM "users" WHERE "users"."id" = $1 LIMIT 1 [["id", 5]]
2017-04-17 07:13:05 [sql] [D] Usergroup Load (0.7ms) SELECT "usergroups".* FROM "usergroups" INNER JOIN "cached_usergroup_members" ON "usergroups"."id" = "cached_usergrou
p_members"."usergroup_id" WHERE "cached_usergroup_members"."user_id" = $1 ORDER BY usergroups.name [["user_id", 5]]
2017-04-17 07:13:05 [sql] [D] Taxonomy Load (0.8ms) SELECT "taxonomies".* FROM "taxonomies" INNER JOIN "taxable_taxonomies" ON "taxonomies"."id" = "taxable_taxonomies"."t
axonomy_id" WHERE "taxonomies"."type" IN ('Organization') AND "taxonomies"."type" = 'Organization' AND "taxable_taxonomies"."taxable_id" = $1 AND "taxable_taxonomies"."taxab
le_type" = $2 ORDER BY "taxonomies"."title" ASC [["taxable_id", 5], ["taxable_type", "User"]]
2017-04-17 07:13:05 [sql] [D] Organization Load (0.6ms) SELECT "taxonomies"."id" FROM "taxonomies" WHERE "taxonomies"."type" IN ('Organization') AND (taxonomies.id = 1 o
r taxonomies.ancestry like '1/%' or taxonomies.ancestry = '1') ORDER BY "taxonomies"."title" ASC
2017-04-17 07:13:05 [sql] [D] (4.1ms) SELECT COUNT(*) FROM "taxonomies" WHERE "taxonomies"."type" IN ('Organization') AND ( (taxonomies.id in (1)))
2017-04-17 07:13:05 [sql] [D] Organization Load (0.3ms) SELECT "taxonomies".* FROM "taxonomies" WHERE "taxonomies"."type" IN ('Organization') AND ( (taxonomies.id in (1
))) ORDER BY "taxonomies"."title" ASC LIMIT 1
2017-04-17 07:13:05 [sql] [D] Taxonomy Load (0.6ms) SELECT "taxonomies".* FROM "taxonomies" INNER JOIN "taxable_taxonomies" ON "taxonomies"."id" = "taxable_taxonomies"."t
axonomy_id" WHERE "taxonomies"."type" IN ('Location') AND "taxonomies"."type" = 'Location' AND "taxable_taxonomies"."taxable_id" = $1 AND "taxable_taxonomies"."taxable_type"
= $2 ORDER BY "taxonomies"."title" ASC [["taxable_id", 5], ["taxable_type", "User"]]
2017-04-17 07:13:05 [sql] [D] Location Load (0.5ms) SELECT "taxonomies"."id" FROM "taxonomies" WHERE "taxonomies"."type" IN ('Location') AND (taxonomies.id = 5 or taxono
mies.ancestry like '5/%' or taxonomies.ancestry = '5') ORDER BY "taxonomies"."title" ASC
2017-04-17 07:13:05 [sql] [D] Location Load (0.4ms) SELECT "taxonomies"."id" FROM "taxonomies" WHERE "taxonomies"."type" IN ('Location') AND (taxonomies.id = 2 or taxono
mies.ancestry like '2/%' or taxonomies.ancestry = '2') ORDER BY "taxonomies"."title" ASC
2017-04-17 07:13:05 [sql] [D] (0.4ms) SELECT COUNT(*) FROM "taxonomies" WHERE "taxonomies"."type" IN ('Location') AND ( (taxonomies.id in (5,2)))
2017-04-17 07:13:05 [sql] [D] Location Load (0.3ms) SELECT "taxonomies".* FROM "taxonomies" WHERE "taxonomies"."type" IN ('Location') AND ( (taxonomies.id in (5,2))) AND "taxonomies"."id" = 2 ORDER BY "taxonomies"."title" ASC LIMIT 1
2017-04-17 07:13:06 [sql] [D] AuthSource Load (0.3ms) SELECT "auth_sources".* FROM "auth_sources" WHERE "auth_sources"."id" = $1 LIMIT 1 [["id", 1]]
2017-04-17 07:13:06 [sql] [D] Role Load (0.5ms) SELECT DISTINCT "roles".* FROM "roles" INNER JOIN "cached_user_roles" ON "roles"."id" = "cached_user_roles"."role_id" WHERE "cached_user_roles"."user_id" = $1 [["user_id", 5]]
2017-04-17 07:13:06 [sql] [D] (0.6ms) SELECT permissions.name FROM "permissions" INNER JOIN "filterings" ON "permissions"."id" = "filterings"."permission_id" INNER JOIN "filters" ON "filterings"."filter_id" = "filters"."id" WHERE "filters"."role_id" = $1 ORDER BY filters.role_id, filters.id [["role_id", 5]]
2017-04-17 07:13:06 [sql] [D] (0.6ms) SELECT permissions.name FROM "permissions" INNER JOIN "filterings" ON "permissions"."id" = "filterings"."permission_id" INNER JOIN "filters" ON "filterings"."filter_id" = "filters"."id" WHERE "filters"."role_id" = $1 ORDER BY filters.role_id, filters.id [["role_id", 18]]
2017-04-17 07:13:06 [sql] [D] (0.5ms) SELECT permissions.name FROM "permissions" INNER JOIN "filterings" ON "permissions"."id" = "filterings"."permission_id" INNER JOIN "filters" ON "filterings"."filter_id" = "filters"."id" WHERE "filters"."role_id" = $1 ORDER BY filters.role_id, filters.id [["role_id", 19]]
2017-04-17 07:13:06 [sql] [D] (0.5ms) SELECT permissions.name FROM "permissions" INNER JOIN "filterings" ON "permissions"."id" = "filterings"."permission_id" INNER JOIN "filters" ON "filterings"."filter_id" = "filters"."id" WHERE "filters"."role_id" = $1 ORDER BY filters.role_id, filters.id [["role_id", 8]]
2017-04-17 07:13:06 [sql] [D] (0.4ms) SELECT permissions.name FROM "permissions" INNER JOIN "filterings" ON "permissions"."id" = "filterings"."permission_id" INNER JOIN "filters" ON "filterings"."filter_id" = "filters"."id" WHERE "filters"."role_id" = $1 ORDER BY filters.role_id, filters.id [["role_id", 15]]
2017-04-17 07:13:06 [sql] [D] (0.3ms) SELECT permissions.name FROM "permissions" INNER JOIN "filterings" ON "permissions"."id" = "filterings"."permission_id" INNER JOIN "filters" ON "filterings"."filter_id" = "filters"."id" WHERE "filters"."role_id" = $1 ORDER BY filters.role_id, filters.id [["role_id", 3]]
2017-04-17 07:13:06 [sql] [D] (0.5ms) SELECT permissions.name FROM "permissions" INNER JOIN "filterings" ON "permissions"."id" = "filterings"."permission_id" INNER JOIN "filters" ON "filterings"."filter_id" = "filters"."id" WHERE "filters"."role_id" = $1 ORDER BY filters.role_id, filters.id [["role_id", 10]]
2017-04-17 07:13:06 [sql] [D] (0.4ms) SELECT permissions.name FROM "permissions" INNER JOIN "filterings" ON "permissions"."id" = "filterings"."permission_id" INNER JOIN "filters" ON "filterings"."filter_id" = "filters"."id" WHERE "filters"."role_id" = $1 ORDER BY filters.role_id, filters.id [["role_id", 12]]
2017-04-17 07:13:06 [sql] [D] (0.3ms) SELECT permissions.name FROM "permissions" INNER JOIN "filterings" ON "permissions"."id" = "filterings"."permission_id" INNER JOIN "filters" ON "filterings"."filter_id" = "filters"."id" WHERE "filters"."role_id" = $1 ORDER BY filters.role_id, filters.id [["role_id", 16]]
2017-04-17 07:13:06 [sql] [D] (0.3ms) SELECT permissions.name FROM "permissions" INNER JOIN "filterings" ON "permissions"."id" = "filterings"."permission_id" INNER JOIN "filters" ON "filterings"."filter_id" = "filters"."id" WHERE "filters"."role_id" = $1 ORDER BY filters.role_id, filters.id [["role_id", 14]]
2017-04-17 07:13:06 [sql] [D] (0.5ms) SELECT permissions.name FROM "permissions" INNER JOIN "filterings" ON "permissions"."id" = "filterings"."permission_id" INNER JOIN "filters" ON "filterings"."filter_id" = "filters"."id" WHERE "filters"."role_id" = $1 ORDER BY filters.role_id, filters.id [["role_id", 29]]
2017-04-17 07:13:06 [sql] [D] (0.3ms) SELECT permissions.name FROM "permissions" INNER JOIN "filterings" ON "permissions"."id" = "filterings"."permission_id" INNER JOIN "filters" ON "filterings"."filter_id" = "filters"."id" WHERE "filters"."role_id" = $1 ORDER BY filters.role_id, filters.id [["role_id", 4]]
2017-04-17 07:13:06 [sql] [D] (0.6ms) SELECT permissions.name FROM "permissions" INNER JOIN "filterings" ON "permissions"."id" = "filterings"."permission_id" INNER JOIN "filters" ON "filterings"."filter_id" = "filters"."id" WHERE "filters"."role_id" = $1 ORDER BY filters.role_id, filters.id [["role_id", 6]]
2017-04-17 07:13:06 [sql] [D] (0.4ms) SELECT permissions.name FROM "permissions" INNER JOIN "filterings" ON "permissions"."id" = "filterings"."permission_id" INNER JOIN "filters" ON "filterings"."filter_id" = "filters"."id" WHERE "filters"."role_id" = $1 ORDER BY filters.role_id, filters.id [["role_id", 20]]
2017-04-17 07:13:06 [sql] [D] (0.4ms) SELECT permissions.name FROM "permissions" INNER JOIN "filterings" ON "permissions"."id" = "filterings"."permission_id" INNER JOIN "filters" ON "filterings"."filter_id" = "filters"."id" WHERE "filters"."role_id" = $1 ORDER BY filters.role_id, filters.id [["role_id", 9]]
2017-04-17 07:13:06 [sql] [D] (0.3ms) SELECT permissions.name FROM "permissions" INNER JOIN "filterings" ON "permissions"."id" = "filterings"."permission_id" INNER JOIN "filters" ON "filterings"."filter_id" = "filters"."id" WHERE "filters"."role_id" = $1 ORDER BY filters.role_id, filters.id [["role_id", 21]]
2017-04-17 07:13:06 [sql] [D] (0.4ms) SELECT permissions.name FROM "permissions" INNER JOIN "filterings" ON "permissions"."id" = "filterings"."permission_id" INNER JOIN "filters" ON "filterings"."filter_id" = "filters"."id" WHERE "filters"."role_id" = $1 ORDER BY filters.role_id, filters.id [["role_id", 2]]
2017-04-17 07:13:06 [sql] [D] (0.4ms) SELECT permissions.name FROM "permissions" INNER JOIN "filterings" ON "permissions"."id" = "filterings"."permission_id" INNER JOIN
"filters" ON "filterings"."filter_id" = "filters"."id" WHERE "filters"."role_id" = $1 ORDER BY filters.role_id, filters.id [["role_id", 11]]
2017-04-17 07:13:06 [sql] [D] (0.5ms) SELECT permissions.name FROM "permissions" INNER JOIN "filterings" ON "permissions"."id" = "filterings"."permission_id" INNER JOIN "filters" ON "filterings"."filter_id" = "filters"."id" WHERE "filters"."role_id" = $1 ORDER BY filters.role_id, filters.id [["role_id", 17]]
2017-04-17 07:13:06 [sql] [D] (1.4ms) SELECT permissions.name FROM "permissions" INNER JOIN "filterings" ON "permissions"."id" = "filterings"."permission_id" INNER JOIN "filters" ON "filterings"."filter_id" = "filters"."id" WHERE "filters"."role_id" = $1 ORDER BY filters.role_id, filters.id [["role_id", 1]]
2017-04-17 07:13:06 [sql] [D] (0.6ms) SELECT permissions.name FROM "permissions" INNER JOIN "filterings" ON "permissions"."id" = "filterings"."permission_id" INNER JOIN "filters" ON "filterings"."filter_id" = "filters"."id" WHERE "filters"."role_id" = $1 ORDER BY filters.role_id, filters.id [["role_id", 7]]
2017-04-17 07:13:06 [permissions] [D] rendering 403 because of missing permission
2017-04-17 07:13:06 [app] [I] Rendered common/403.html.erb within layouts/application (23.5ms)
2017-04-17 07:13:06 [app] [I] Rendered layouts/_application_content.html.erb (2.6ms)
*********************
Expected results:
With 'Remote Execution User' or 'Remote Execution Manager' role, non-admin user should be able to perform remote actions on host systems.
Additional info:
Though user have all other default roles from satellite assigned i.e user can access organization, location, dashboard, hosts, host collections, content hosts, etc... still issue persist.
But if same user performs action from All Host, it works.
Login webui as non-admin user(with Remote exection user/manager role) Hosts --> All Hosts --> select host --> Select Action --> Run Job --> "Job category: Katello" --> "Job template: Install Errata - Katello SSH Default" --> "errata: mention errata to install" --> Submit
Debug logs:
*********************
2017-04-20 09:35:32 [sql] [D] Katello::Event Load (0.3ms) SELECT "katello_events".* FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' AND 1=0 AND 1=0 OR
DER BY "katello_events"."created_at" DESC LIMIT 1
2017-04-20 09:35:32 [sql] [D] SQL (0.5ms) UPDATE "katello_events" SET "in_progress" = 't' WHERE "katello_events"."id" IN (SELECT "katello_events"."id" FROM "katello_event
s" WHERE "katello_events"."in_progress" = 'f' AND 1=0 AND 1=0 ORDER BY "katello_events"."created_at" ASC)
2017-04-20 09:35:33 [app] [I] Started GET "/content-hosts/content/views/content-host-errata.html" for 10.76.0.19 at 2017-04-20 09:35:33 +0530
2017-04-20 09:35:33 [app] [I] Started GET "/layouts/details-nutupane.html" for 10.76.0.19 at 2017-04-20 09:35:33 +0530
2017-04-20 09:35:33 [app] [I] Started GET "/api/v2/hosts/37/errata?page=1&search=" for 10.76.0.19 at 2017-04-20 09:35:33 +0530
2017-04-20 09:35:34 [sql] [D] (0.8ms) SELECT "katello_events"."object_id" FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' ORDER BY "katello_events"."
created_at" ASC LIMIT 1
2017-04-20 09:35:34 [sql] [D] (0.3ms) SELECT "katello_events"."event_type" FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' ORDER BY "katello_events".
"created_at" ASC LIMIT 1
2017-04-20 09:35:35 [sql] [D] Katello::Event Load (0.7ms) SELECT "katello_events".* FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' AND 1=0 AND 1=0 OR
DER BY "katello_events"."created_at" DESC LIMIT 1
2017-04-20 09:35:35 [sql] [D] SQL (0.6ms) UPDATE "katello_events" SET "in_progress" = 't' WHERE "katello_events"."id" IN (SELECT "katello_events"."id" FROM "katello_event
s" WHERE "katello_events"."in_progress" = 'f' AND 1=0 AND 1=0 ORDER BY "katello_events"."created_at" ASC)
2017-04-20 09:35:36 [app] [I] Processing by Katello::Api::V2::HostErrataController#index as JSON
2017-04-20 09:35:36 [app] [I] Parameters: {"page"=>"1", "search"=>"", "api_version"=>"v2", "host_id"=>"37"}
2017-04-20 09:35:37 [sql] [D] (0.9ms) SELECT "katello_events"."object_id" FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' ORDER BY "katello_events"."
created_at" ASC LIMIT 1
2017-04-20 09:35:37 [sql] [D] (0.3ms) SELECT "katello_events"."event_type" FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' ORDER BY "katello_events".
"created_at" ASC LIMIT 1
2017-04-20 09:35:37 [sql] [D] Katello::Event Load (1.8ms) SELECT "katello_events".* FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' AND 1=0 AND 1=0 OR
DER BY "katello_events"."created_at" DESC LIMIT 1
2017-04-20 09:35:37 [sql] [D] SQL (0.5ms) UPDATE "katello_events" SET "in_progress" = 't' WHERE "katello_events"."id" IN (SELECT "katello_events"."id" FROM "katello_event
s" WHERE "katello_events"."in_progress" = 'f' AND 1=0 AND 1=0 ORDER BY "katello_events"."created_at" ASC)
2017-04-20 09:35:39 [sql] [D] (0.6ms) SELECT "katello_events"."object_id" FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' ORDER BY "katello_events"."
created_at" ASC LIMIT 1
2017-04-20 09:35:39 [sql] [D] (0.2ms) SELECT "katello_events"."event_type" FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' ORDER BY "katello_events".
"created_at" ASC LIMIT 1
2017-04-20 09:35:39 [sql] [D] Katello::Event Load (0.3ms) SELECT "katello_events".* FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' AND 1=0 AND 1=0 OR
DER BY "katello_events"."created_at" DESC LIMIT 1
2017-04-20 09:35:39 [sql] [D] SQL (0.5ms) UPDATE "katello_events" SET "in_progress" = 't' WHERE "katello_events"."id" IN (SELECT "katello_events"."id" FROM "katello_event
s" WHERE "katello_events"."in_progress" = 'f' AND 1=0 AND 1=0 ORDER BY "katello_events"."created_at" ASC)
2017-04-20 09:35:41 [sql] [D] (0.9ms) SELECT "katello_events"."object_id" FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' ORDER BY "katello_events"."
created_at" ASC LIMIT 1
2017-04-20 09:35:41 [sql] [D] (0.6ms) SELECT "katello_events"."event_type" FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' ORDER BY "katello_events".
"created_at" ASC LIMIT 1
2017-04-20 09:35:39 [sql] [D] (0.2ms) SELECT "katello_events"."event_type" FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' ORDER BY "katello_events".
"created_at" ASC LIMIT 1
2017-04-20 09:35:39 [sql] [D] Katello::Event Load (0.3ms) SELECT "katello_events".* FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' AND 1=0 AND 1=0 OR
DER BY "katello_events"."created_at" DESC LIMIT 1
2017-04-20 09:35:39 [sql] [D] SQL (0.5ms) UPDATE "katello_events" SET "in_progress" = 't' WHERE "katello_events"."id" IN (SELECT "katello_events"."id" FROM "katello_event
s" WHERE "katello_events"."in_progress" = 'f' AND 1=0 AND 1=0 ORDER BY "katello_events"."created_at" ASC)
2017-04-20 09:35:41 [sql] [D] (0.9ms) SELECT "katello_events"."object_id" FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' ORDER BY "katello_events"."
created_at" ASC LIMIT 1
2017-04-20 09:35:41 [sql] [D] (0.6ms) SELECT "katello_events"."event_type" FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' ORDER BY "katello_events".
"created_at" ASC LIMIT 1
2017-04-20 09:35:41 [sql] [D] Katello::Event Load (0.6ms) SELECT "katello_events".* FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' AND 1=0 AND 1=0 ORDER BY "katello_events"."created_at" DESC LIMIT 1
2017-04-20 09:35:41 [sql] [D] SQL (0.5ms) UPDATE "katello_events" SET "in_progress" = 't' WHERE "katello_events"."id" IN (SELECT "katello_events"."id" FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' AND 1=0 AND 1=0 ORDER BY "katello_events"."created_at" ASC)
2017-04-20 09:35:43 [sql] [D] (0.7ms) SELECT "katello_events"."object_id" FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' ORDER BY "katello_events"."created_at" ASC LIMIT 1
2017-04-20 09:35:43 [sql] [D] (0.4ms) SELECT "katello_events"."event_type" FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' ORDER BY "katello_events"."created_at" ASC LIMIT 1
2017-04-20 09:35:43 [sql] [D] Katello::Event Load (0.3ms) SELECT "katello_events".* FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' AND 1=0 AND 1=0 ORDER BY "katello_events"."created_at" DESC LIMIT 1
2017-04-20 09:35:43 [sql] [D] SQL (0.6ms) UPDATE "katello_events" SET "in_progress" = 't' WHERE "katello_events"."id" IN (SELECT "katello_events"."id" FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' AND 1=0 AND 1=0 ORDER BY "katello_events"."created_at" ASC)
2017-04-20 09:35:43 [app] [I] Rendered /opt/theforeman/tfm/root/usr/share/gems/gems/katello-3.0.0.105/app/views/katello/api/v2/host_errata/index.json.rabl within katello/api/v2/layouts/collection (3158.3ms)
2017-04-20 09:35:43 [app] [I] Completed 200 OK in 7159ms (Views: 3201.4ms | ActiveRecord: 520.0ms)
2017-04-20 09:35:45 [sql] [D] (0.8ms) SELECT "katello_events"."object_id" FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' ORDER BY "katello_events"."created_at" ASC LIMIT 1
2017-04-20 09:35:45 [sql] [D] (0.3ms) SELECT "katello_events"."event_type" FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' ORDER BY "katello_events"."created_at" ASC LIMIT 1
2017-04-20 09:35:45 [sql] [D] Katello::Event Load (0.3ms) SELECT "katello_events".* FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' AND 1=0 AND 1=0 ORDER BY "katello_events"."created_at" DESC LIMIT 1
2017-04-20 09:35:45 [sql] [D] SQL (0.4ms) UPDATE "katello_events" SET "in_progress" = 't' WHERE "katello_events"."id" IN (SELECT "katello_events"."id" FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' AND 1=0 AND 1=0 ORDER BY "katello_events"."created_at" ASC)
2017-04-20 09:35:47 [sql] [D] (24.7ms) SELECT "katello_events"."object_id" FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' ORDER BY "katello_events"."created_at" ASC LIMIT 1
2017-04-20 09:35:47 [sql] [D] (0.6ms) SELECT "katello_events"."event_type" FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' ORDER BY "katello_events"."created_at" ASC LIMIT 1
2017-04-20 09:35:47 [sql] [D] Katello::Event Load (0.3ms) SELECT "katello_events".* FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' AND 1=0 AND 1=0 ORDER BY "katello_events"."created_at" DESC LIMIT 1
2017-04-20 09:35:47 [sql] [D] SQL (0.4ms) UPDATE "katello_events" SET "in_progress" = 't' WHERE "katello_events"."id" IN (SELECT "katello_events"."id" FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' AND 1=0 AND 1=0 ORDER BY "katello_events"."created_at" ASC)
2017-04-20 09:35:49 [sql] [D] (35.7ms) SELECT "katello_events"."object_id" FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' ORDER BY "katello_events"."created_at" ASC LIMIT 1
2017-04-20 09:35:49 [sql] [D] (0.6ms) SELECT "katello_events"."event_type" FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' ORDER BY "katello_events"."created_at" ASC LIMIT 1
2017-04-20 09:35:49 [sql] [D] Katello::Event Load (0.3ms) SELECT "katello_events".* FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' AND 1=0 AND 1=0 ORDER BY "katello_events"."created_at" DESC LIMIT 1
2017-04-20 09:35:49 [sql] [D] SQL (4.6ms) UPDATE "katello_events" SET "in_progress" = 't' WHERE "katello_events"."id" IN (SELECT "katello_events"."id" FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' AND 1=0 AND 1=0 ORDER BY "katello_events"."created_at" ASC)
2017-04-20 09:35:51 [sql] [D] (22.2ms) SELECT "katello_events"."object_id" FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' ORDER BY "katello_events"."created_at" ASC LIMIT 1
2017-04-20 09:35:51 [sql] [D] (0.5ms) SELECT "katello_events"."event_type" FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' ORDER BY "katello_events"."created_at" ASC LIMIT 1
2017-04-20 09:35:51 [sql] [D] Katello::Event Load (0.3ms) SELECT "katello_events".* FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' AND 1=0 AND 1=0 ORDER BY "katello_events"."created_at" DESC LIMIT 1
2017-04-20 09:35:51 [sql] [D] SQL (0.4ms) UPDATE "katello_events" SET "in_progress" = 't' WHERE "katello_events"."id" IN (SELECT "katello_events"."id" FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' AND 1=0 AND 1=0 ORDER BY "katello_events"."created_at" ASC)
2017-04-20 09:35:53 [sql] [D] (56.0ms) SELECT "katello_events"."object_id" FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' ORDER BY "katello_events"."created_at" ASC LIMIT 1
2017-04-20 09:35:53 [sql] [D] (0.5ms) SELECT "katello_events"."event_type" FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' ORDER BY "katello_events"."created_at" ASC LIMIT 1
2017-04-20 09:35:53 [sql] [D] Katello::Event Load (0.4ms) SELECT "katello_events".* FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' AND 1=0 AND 1=0 ORDER BY "katello_events"."created_at" DESC LIMIT 1
2017-04-20 09:35:53 [sql] [D] SQL (12.3ms) UPDATE "katello_events" SET "in_progress" = 't' WHERE "katello_events"."id" IN (SELECT "katello_events"."id" FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' AND 1=0 AND 1=0 ORDER BY "katello_events"."created_at" ASC)
2017-04-20 09:35:54 [app] [I] Started GET "/content-hosts/content/views/content-host-packages.html" for 10.76.0.19 at 2017-04-20 09:35:54 +0530
2017-04-20 09:35:54 [app] [I] Started GET "/api/v2/hosts/37/packages?page=1&search=" for 10.76.0.19 at 2017-04-20 09:35:54 +0530
2017-04-20 09:35:55 [sql] [D] (1.2ms) SELECT "katello_events"."object_id" FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' ORDER BY "katello_events"."created_at" ASC LIMIT 1
2017-04-20 09:35:55 [sql] [D] (0.6ms) SELECT "katello_events"."event_type" FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' ORDER BY "katello_events"."created_at" ASC LIMIT 1
2017-04-20 09:35:55 [sql] [D] Katello::Event Load (0.3ms) SELECT "katello_events".* FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' AND 1=0 AND 1=0 ORDER BY "katello_events"."created_at" DESC LIMIT 1
2017-04-20 09:35:55 [sql] [D] SQL (6.0ms) UPDATE "katello_events" SET "in_progress" = 't' WHERE "katello_events"."id" IN (SELECT "katello_events"."id" FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' AND 1=0 AND 1=0 ORDER BY "katello_events"."created_at" ASC)
2017-04-20 09:35:57 [app] [I] Processing by Katello::Api::V2::HostPackagesController#index as JSON
2017-04-20 09:35:57 [app] [I] Parameters: {"page"=>"1", "search"=>"", "api_version"=>"v2", "host_id"=>"37"}
2017-04-20 09:35:57 [sql] [D] (0.9ms) SELECT "katello_events"."object_id" FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' ORDER BY "katello_events"."
created_at" ASC LIMIT 1
2017-04-20 09:35:58 [app] [I] Started GET "/api/v2/hosts/37/errata?page=1&search=" for 10.76.0.19 at 2017-04-20 09:35:58 +0530
2017-04-20 09:35:58 [app] [I] Processing by Katello::Api::V2::HostErrataController#index as JSON
2017-04-20 09:35:58 [app] [I] Parameters: {"page"=>"1", "search"=>"", "api_version"=>"v2", "host_id"=>"37"}
2017-04-20 09:35:58 [app] [I] Rendered /opt/theforeman/tfm/root/usr/share/gems/gems/katello-3.0.0.105/app/views/katello/api/v2/host_errata/index.json.rabl within katello/api/v2/layouts/collection (250.0ms)
2017-04-20 09:35:58 [app] [I] Completed 200 OK in 330ms (Views: 234.4ms | ActiveRecord: 30.4ms)
2017-04-20 09:35:59 [sql] [D] (0.9ms) SELECT "katello_events"."event_type" FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' ORDER BY "katello_events"."created_at" ASC LIMIT 1
2017-04-20 09:35:59 [sql] [D] Katello::Event Load (0.4ms) SELECT "katello_events".* FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' AND 1=0 AND 1=0 ORDER BY "katello_events"."created_at" DESC LIMIT 1
2017-04-20 09:35:59 [sql] [D] SQL (0.7ms) UPDATE "katello_events" SET "in_progress" = 't' WHERE "katello_events"."id" IN (SELECT "katello_events"."id" FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' AND 1=0 AND 1=0 ORDER BY "katello_events"."created_at" ASC)
2017-04-20 09:36:00 [app] [I] Rendered /opt/theforeman/tfm/root/usr/share/gems/gems/katello-3.0.0.105/app/views/katello/api/v2/host_packages/index.json.rabl within katello/api/v2/layouts/collection (475.5ms)
2017-04-20 09:36:00 [app] [I] Completed 200 OK in 3606ms (Views: 651.7ms | ActiveRecord: 387.8ms)
2017-04-20 09:36:01 [sql] [D] (0.7ms) SELECT "katello_events"."object_id" FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' ORDER BY "katello_events"."created_at" ASC LIMIT 1
2017-04-20 09:36:01 [sql] [D] (0.3ms) SELECT "katello_events"."event_type" FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' ORDER BY "katello_events"."created_at" ASC LIMIT 1
2017-04-20 09:36:01 [sql] [D] Katello::Event Load (17.7ms) SELECT "katello_events".* FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' AND 1=0 AND 1=0 ORDER BY "katello_events"."created_at" DESC LIMIT 1
2017-04-20 09:36:01 [sql] [D] SQL (0.8ms) UPDATE "katello_events" SET "in_progress" = 't' WHERE "katello_events"."id" IN (SELECT "katello_events"."id" FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' AND 1=0 AND 1=0 ORDER BY "katello_events"."created_at" ASC)
2017-04-20 09:36:03 [sql] [D] (0.7ms) SELECT "katello_events"."object_id" FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' ORDER BY "katello_events"."created_at" ASC LIMIT 1
2017-04-20 09:36:03 [sql] [D] (0.4ms) SELECT "katello_events"."event_type" FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' ORDER BY "katello_events"."created_at" ASC LIMIT 1
2017-04-20 09:36:03 [sql] [D] Katello::Event Load (0.5ms) SELECT "katello_events".* FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' AND 1=0 AND 1=0 ORDER BY "katello_events"."created_at" DESC LIMIT 1
2017-04-20 09:36:03 [sql] [D] SQL (0.7ms) UPDATE "katello_events" SET "in_progress" = 't' WHERE "katello_events"."id" IN (SELECT "katello_events"."id" FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' AND 1=0 AND 1=0 ORDER BY "katello_events"."created_at" ASC)
2017-04-20 09:36:05 [sql] [D] (1.0ms) SELECT "katello_events"."object_id" FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' ORDER BY "katello_events"."created_at" ASC LIMIT 1
2017-04-20 09:36:05 [sql] [D] (0.5ms) SELECT "katello_events"."event_type" FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' ORDER BY "katello_events"."created_at" ASC LIMIT 1
2017-04-20 09:36:05 [sql] [D] Katello::Event Load (0.4ms) SELECT "katello_events".* FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' AND 1=0 AND 1=0 OR:
DER BY "katello_events"."created_at" DESC LIMIT 1
2017-04-20 09:36:05 [sql] [D] SQL (0.4ms) UPDATE "katello_events" SET "in_progress" = 't' WHERE "katello_events"."id" IN (SELECT "katello_events"."id" FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' AND 1=0 AND 1=0 ORDER BY "katello_events"."created_at" ASC)
2017-04-20 09:36:07 [sql] [D] (0.8ms) SELECT "katello_events"."object_id" FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' ORDER BY "katello_events"."created_at" ASC LIMIT 1
2017-04-20 09:36:07 [sql] [D] (0.3ms) SELECT "katello_events"."event_type" FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' ORDER BY "katello_events"."created_at" ASC LIMIT 1
2017-04-20 09:36:07 [sql] [D] Katello::Event Load (0.3ms) SELECT "katello_events".* FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' AND 1=0 AND 1=0 ORDER BY "katello_events"."created_at" DESC LIMIT 1
2017-04-20 09:36:07 [sql] [D] SQL (0.4ms) UPDATE "katello_events" SET "in_progress" = 't' WHERE "katello_events"."id" IN (SELECT "katello_events"."id" FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' AND 1=0 AND 1=0 ORDER BY "katello_events"."created_at" ASC)
2017-04-20 09:36:09 [sql] [D] (0.7ms) SELECT "katello_events"."object_id" FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' ORDER BY "katello_events"."created_at" ASC LIMIT 1
2017-04-20 09:36:09 [sql] [D] (0.6ms) SELECT "katello_events"."event_type" FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' ORDER BY "katello_events"."created_at" ASC LIMIT 1
2017-04-20 09:36:09 [sql] [D] Katello::Event Load (0.5ms) SELECT "katello_events".* FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' AND 1=0 AND 1=0 ORDER BY "katello_events"."created_at" DESC LIMIT 1
2017-04-20 09:36:09 [sql] [D] SQL (0.9ms) UPDATE "katello_events" SET "in_progress" = 't' WHERE "katello_events"."id" IN (SELECT "katello_events"."id" FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' AND 1=0 AND 1=0 ORDER BY "katello_events"."created_at" ASC)
2017-04-20 09:36:11 [sql] [D] (6.7ms) SELECT "katello_events"."object_id" FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' ORDER BY "katello_events"."created_at" ASC LIMIT 1
2017-04-20 09:36:11 [sql] [D] (0.2ms) SELECT "katello_events"."event_type" FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' ORDER BY "katello_events"."created_at" ASC LIMIT 1
2017-04-20 09:36:11 [sql] [D] Katello::Event Load (8.5ms) SELECT "katello_events".* FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' AND 1=0 AND 1=0 ORDER BY "katello_events"."created_at" DESC LIMIT 1
2017-04-20 09:36:11 [sql] [D] SQL (5.5ms) UPDATE "katello_events" SET "in_progress" = 't' WHERE "katello_events"."id" IN (SELECT "katello_events"."id" FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' AND 1=0 AND 1=0 ORDER BY "katello_events"."created_at" ASC)
2017-04-20 09:36:13 [sql] [D] (1.1ms) SELECT "katello_events"."object_id" FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' ORDER BY "katello_events"."created_at" ASC LIMIT 1
2017-04-20 09:36:13 [sql] [D] (0.5ms) SELECT "katello_events"."event_type" FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' ORDER BY "katello_events"."created_at" ASC LIMIT 1
2017-04-20 09:36:13 [sql] [D] Katello::Event Load (0.7ms) SELECT "katello_events".* FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' AND 1=0 AND 1=0 ORDER BY "katello_events"."created_at" DESC LIMIT 1
2017-04-20 09:36:13 [sql] [D] SQL (0.7ms) UPDATE "katello_events" SET "in_progress" = 't' WHERE "katello_events"."id" IN (SELECT "katello_events"."id" FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' AND 1=0 AND 1=0 ORDER BY "katello_events"."created_at" ASC)
2017-04-20 09:36:15 [sql] [D] (0.7ms) SELECT "katello_events"."object_id" FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' ORDER BY "katello_events"."created_at" ASC LIMIT 1
2017-04-20 09:36:15 [sql] [D] (0.5ms) SELECT "katello_events"."event_type" FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' ORDER BY "katello_events"."created_at" ASC LIMIT 1
2017-04-20 09:36:15 [sql] [D] Katello::Event Load (0.3ms) SELECT "katello_events".* FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' AND 1=0 AND 1=0 OR:
DER BY "katello_events"."created_at" DESC LIMIT 1
2017-04-20 09:36:15 [sql] [D] SQL (0.5ms) UPDATE "katello_events" SET "in_progress" = 't' WHERE "katello_events"."id" IN (SELECT "katello_events"."id" FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' AND 1=0 AND 1=0 ORDER BY "katello_events"."created_at" ASC)
2017-04-20 09:36:17 [sql] [D] (0.7ms) SELECT "katello_events"."object_id" FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' ORDER BY "katello_events"."created_at" ASC LIMIT 1
2017-04-20 09:36:17 [sql] [D] (0.5ms) SELECT "katello_events"."event_type" FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' ORDER BY "katello_events"."created_at" ASC LIMIT 1
2017-04-20 09:36:17 [sql] [D] Katello::Event Load (0.4ms) SELECT "katello_events".* FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' AND 1=0 AND 1=0 ORDER BY "katello_events"."created_at" DESC LIMIT 1
2017-04-20 09:36:17 [sql] [D] SQL (0.4ms) UPDATE "katello_events" SET "in_progress" = 't' WHERE "katello_events"."id" IN (SELECT "katello_events"."id" FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' AND 1=0 AND 1=0 ORDER BY "katello_events"."created_at" ASC)
*********************
I was not able to verify this bug as the reproduction path is blocked by a new bug which I have opened: https://bugzilla.redhat.com/show_bug.cgi?id=1487402
Failed against Satellite 6.3 Snap 13 following the reproduction steps above.
Comment 9Satellite Program
2017-09-01 06:08:00 UTC
Comment 13Satellite Program
2017-12-11 17:09:36 UTC
Upstream bug assigned to inecas
Comment 14Satellite Program
2018-02-21 16:54:37 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, 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/RHSA-2018:0336
Description of problem: Remote execution with non-admin user having role 'Remote Execution User' or 'Remote Execution Manager' do not work and fails with error "rendering 403 because of missing permission ". Version-Release number of selected component (if applicable): How reproducible: Always Steps to Reproduce: 1. From satellite webui create non-admin user. 2. Assign role 'Remote Execution User' or 'Remote Execution Manager' or can assign all roles except 'Administrator' check mark. 3. Login satellite as non-admin user --> Hosts --> Host Collection --> Click on host collection name --> Collection actions --> Errata installation --> Select errata --> click on drop down of 'install selected' --> select 'via remote execution' or 'via remote execution -customize first' Actual results: On satellite webui: ********************* Permission denied You are not authorized to perform this action. Please request one of the required permissions listed below from a Satellite administrator: ********************* Debug log entries from satellite terminal. ********************* ==> /var/log/foreman/production.log <== 2017-04-17 07:13:05 [sql] [D] (1.0ms) SELECT "katello_events"."object_id" FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' ORDER BY "katello_events"." created_at" ASC LIMIT 1 2017-04-17 07:13:05 [sql] [D] (0.3ms) SELECT "katello_events"."event_type" FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' ORDER BY "katello_events". "created_at" ASC LIMIT 1 2017-04-17 07:13:05 [sql] [D] Katello::Event Load (0.5ms) SELECT "katello_events".* FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' AND 1=0 AND 1=0 OR DER BY "katello_events"."created_at" DESC LIMIT 1 2017-04-17 07:13:05 [sql] [D] SQL (0.6ms) UPDATE "katello_events" SET "in_progress" = 't' WHERE "katello_events"."id" IN (SELECT "katello_events"."id" FROM "katello_event s" WHERE "katello_events"."in_progress" = 'f' AND 1=0 AND 1=0 ORDER BY "katello_events"."created_at" ASC) 2017-04-17 07:13:05 [app] [I] Started POST "/katello/remote_execution" for 10.76.1.49 at 2017-04-17 07:13:05 +0530 2017-04-17 07:13:05 [app] [I] Processing by Katello::RemoteExecutionController#create as HTML 2017-04-17 07:13:05 [app] [I] Parameters: {"name"=>"RHEA-2016:2832", "remote_action"=>"errata_install", "scoped_search"=>"", "host_ids"=>"37", "authenticity_token"=>"5Gkwl WUAsZt7YnMHlotnGuqn9+Mp/v6zzj3JEgAYGMk=", "customize"=>"true"} 2017-04-17 07:13:05 [sql] [D] ActiveRecord::SessionStore::Session Load (0.9ms) SELECT "sessions".* FROM "sessions" WHERE "sessions"."session_id" = '735b9268eeb1f72303f0 d8fa64131868' ORDER BY "sessions"."id" ASC LIMIT 1 2017-04-17 07:13:05 [sql] [D] User Load (0.3ms) SELECT "users".* FROM "users" WHERE "users"."id" = $1 LIMIT 1 [["id", 5]] 2017-04-17 07:13:05 [sql] [D] Usergroup Load (0.7ms) SELECT "usergroups".* FROM "usergroups" INNER JOIN "cached_usergroup_members" ON "usergroups"."id" = "cached_usergrou p_members"."usergroup_id" WHERE "cached_usergroup_members"."user_id" = $1 ORDER BY usergroups.name [["user_id", 5]] 2017-04-17 07:13:05 [sql] [D] Taxonomy Load (0.8ms) SELECT "taxonomies".* FROM "taxonomies" INNER JOIN "taxable_taxonomies" ON "taxonomies"."id" = "taxable_taxonomies"."t axonomy_id" WHERE "taxonomies"."type" IN ('Organization') AND "taxonomies"."type" = 'Organization' AND "taxable_taxonomies"."taxable_id" = $1 AND "taxable_taxonomies"."taxab le_type" = $2 ORDER BY "taxonomies"."title" ASC [["taxable_id", 5], ["taxable_type", "User"]] 2017-04-17 07:13:05 [sql] [D] Organization Load (0.6ms) SELECT "taxonomies"."id" FROM "taxonomies" WHERE "taxonomies"."type" IN ('Organization') AND (taxonomies.id = 1 o r taxonomies.ancestry like '1/%' or taxonomies.ancestry = '1') ORDER BY "taxonomies"."title" ASC 2017-04-17 07:13:05 [sql] [D] (4.1ms) SELECT COUNT(*) FROM "taxonomies" WHERE "taxonomies"."type" IN ('Organization') AND ( (taxonomies.id in (1))) 2017-04-17 07:13:05 [sql] [D] Organization Load (0.3ms) SELECT "taxonomies".* FROM "taxonomies" WHERE "taxonomies"."type" IN ('Organization') AND ( (taxonomies.id in (1 ))) ORDER BY "taxonomies"."title" ASC LIMIT 1 2017-04-17 07:13:05 [sql] [D] Taxonomy Load (0.6ms) SELECT "taxonomies".* FROM "taxonomies" INNER JOIN "taxable_taxonomies" ON "taxonomies"."id" = "taxable_taxonomies"."t axonomy_id" WHERE "taxonomies"."type" IN ('Location') AND "taxonomies"."type" = 'Location' AND "taxable_taxonomies"."taxable_id" = $1 AND "taxable_taxonomies"."taxable_type" = $2 ORDER BY "taxonomies"."title" ASC [["taxable_id", 5], ["taxable_type", "User"]] 2017-04-17 07:13:05 [sql] [D] Location Load (0.5ms) SELECT "taxonomies"."id" FROM "taxonomies" WHERE "taxonomies"."type" IN ('Location') AND (taxonomies.id = 5 or taxono mies.ancestry like '5/%' or taxonomies.ancestry = '5') ORDER BY "taxonomies"."title" ASC 2017-04-17 07:13:05 [sql] [D] Location Load (0.4ms) SELECT "taxonomies"."id" FROM "taxonomies" WHERE "taxonomies"."type" IN ('Location') AND (taxonomies.id = 2 or taxono mies.ancestry like '2/%' or taxonomies.ancestry = '2') ORDER BY "taxonomies"."title" ASC 2017-04-17 07:13:05 [sql] [D] (0.4ms) SELECT COUNT(*) FROM "taxonomies" WHERE "taxonomies"."type" IN ('Location') AND ( (taxonomies.id in (5,2))) 2017-04-17 07:13:05 [sql] [D] Location Load (0.3ms) SELECT "taxonomies".* FROM "taxonomies" WHERE "taxonomies"."type" IN ('Location') AND ( (taxonomies.id in (5,2))) AND "taxonomies"."id" = 2 ORDER BY "taxonomies"."title" ASC LIMIT 1 2017-04-17 07:13:06 [sql] [D] AuthSource Load (0.3ms) SELECT "auth_sources".* FROM "auth_sources" WHERE "auth_sources"."id" = $1 LIMIT 1 [["id", 1]] 2017-04-17 07:13:06 [sql] [D] Role Load (0.5ms) SELECT DISTINCT "roles".* FROM "roles" INNER JOIN "cached_user_roles" ON "roles"."id" = "cached_user_roles"."role_id" WHERE "cached_user_roles"."user_id" = $1 [["user_id", 5]] 2017-04-17 07:13:06 [sql] [D] (0.6ms) SELECT permissions.name FROM "permissions" INNER JOIN "filterings" ON "permissions"."id" = "filterings"."permission_id" INNER JOIN "filters" ON "filterings"."filter_id" = "filters"."id" WHERE "filters"."role_id" = $1 ORDER BY filters.role_id, filters.id [["role_id", 5]] 2017-04-17 07:13:06 [sql] [D] (0.6ms) SELECT permissions.name FROM "permissions" INNER JOIN "filterings" ON "permissions"."id" = "filterings"."permission_id" INNER JOIN "filters" ON "filterings"."filter_id" = "filters"."id" WHERE "filters"."role_id" = $1 ORDER BY filters.role_id, filters.id [["role_id", 18]] 2017-04-17 07:13:06 [sql] [D] (0.5ms) SELECT permissions.name FROM "permissions" INNER JOIN "filterings" ON "permissions"."id" = "filterings"."permission_id" INNER JOIN "filters" ON "filterings"."filter_id" = "filters"."id" WHERE "filters"."role_id" = $1 ORDER BY filters.role_id, filters.id [["role_id", 19]] 2017-04-17 07:13:06 [sql] [D] (0.5ms) SELECT permissions.name FROM "permissions" INNER JOIN "filterings" ON "permissions"."id" = "filterings"."permission_id" INNER JOIN "filters" ON "filterings"."filter_id" = "filters"."id" WHERE "filters"."role_id" = $1 ORDER BY filters.role_id, filters.id [["role_id", 8]] 2017-04-17 07:13:06 [sql] [D] (0.4ms) SELECT permissions.name FROM "permissions" INNER JOIN "filterings" ON "permissions"."id" = "filterings"."permission_id" INNER JOIN "filters" ON "filterings"."filter_id" = "filters"."id" WHERE "filters"."role_id" = $1 ORDER BY filters.role_id, filters.id [["role_id", 15]] 2017-04-17 07:13:06 [sql] [D] (0.3ms) SELECT permissions.name FROM "permissions" INNER JOIN "filterings" ON "permissions"."id" = "filterings"."permission_id" INNER JOIN "filters" ON "filterings"."filter_id" = "filters"."id" WHERE "filters"."role_id" = $1 ORDER BY filters.role_id, filters.id [["role_id", 3]] 2017-04-17 07:13:06 [sql] [D] (0.5ms) SELECT permissions.name FROM "permissions" INNER JOIN "filterings" ON "permissions"."id" = "filterings"."permission_id" INNER JOIN "filters" ON "filterings"."filter_id" = "filters"."id" WHERE "filters"."role_id" = $1 ORDER BY filters.role_id, filters.id [["role_id", 10]] 2017-04-17 07:13:06 [sql] [D] (0.4ms) SELECT permissions.name FROM "permissions" INNER JOIN "filterings" ON "permissions"."id" = "filterings"."permission_id" INNER JOIN "filters" ON "filterings"."filter_id" = "filters"."id" WHERE "filters"."role_id" = $1 ORDER BY filters.role_id, filters.id [["role_id", 12]] 2017-04-17 07:13:06 [sql] [D] (0.3ms) SELECT permissions.name FROM "permissions" INNER JOIN "filterings" ON "permissions"."id" = "filterings"."permission_id" INNER JOIN "filters" ON "filterings"."filter_id" = "filters"."id" WHERE "filters"."role_id" = $1 ORDER BY filters.role_id, filters.id [["role_id", 16]] 2017-04-17 07:13:06 [sql] [D] (0.3ms) SELECT permissions.name FROM "permissions" INNER JOIN "filterings" ON "permissions"."id" = "filterings"."permission_id" INNER JOIN "filters" ON "filterings"."filter_id" = "filters"."id" WHERE "filters"."role_id" = $1 ORDER BY filters.role_id, filters.id [["role_id", 14]] 2017-04-17 07:13:06 [sql] [D] (0.5ms) SELECT permissions.name FROM "permissions" INNER JOIN "filterings" ON "permissions"."id" = "filterings"."permission_id" INNER JOIN "filters" ON "filterings"."filter_id" = "filters"."id" WHERE "filters"."role_id" = $1 ORDER BY filters.role_id, filters.id [["role_id", 29]] 2017-04-17 07:13:06 [sql] [D] (0.3ms) SELECT permissions.name FROM "permissions" INNER JOIN "filterings" ON "permissions"."id" = "filterings"."permission_id" INNER JOIN "filters" ON "filterings"."filter_id" = "filters"."id" WHERE "filters"."role_id" = $1 ORDER BY filters.role_id, filters.id [["role_id", 4]] 2017-04-17 07:13:06 [sql] [D] (0.6ms) SELECT permissions.name FROM "permissions" INNER JOIN "filterings" ON "permissions"."id" = "filterings"."permission_id" INNER JOIN "filters" ON "filterings"."filter_id" = "filters"."id" WHERE "filters"."role_id" = $1 ORDER BY filters.role_id, filters.id [["role_id", 6]] 2017-04-17 07:13:06 [sql] [D] (0.4ms) SELECT permissions.name FROM "permissions" INNER JOIN "filterings" ON "permissions"."id" = "filterings"."permission_id" INNER JOIN "filters" ON "filterings"."filter_id" = "filters"."id" WHERE "filters"."role_id" = $1 ORDER BY filters.role_id, filters.id [["role_id", 20]] 2017-04-17 07:13:06 [sql] [D] (0.4ms) SELECT permissions.name FROM "permissions" INNER JOIN "filterings" ON "permissions"."id" = "filterings"."permission_id" INNER JOIN "filters" ON "filterings"."filter_id" = "filters"."id" WHERE "filters"."role_id" = $1 ORDER BY filters.role_id, filters.id [["role_id", 9]] 2017-04-17 07:13:06 [sql] [D] (0.3ms) SELECT permissions.name FROM "permissions" INNER JOIN "filterings" ON "permissions"."id" = "filterings"."permission_id" INNER JOIN "filters" ON "filterings"."filter_id" = "filters"."id" WHERE "filters"."role_id" = $1 ORDER BY filters.role_id, filters.id [["role_id", 21]] 2017-04-17 07:13:06 [sql] [D] (0.4ms) SELECT permissions.name FROM "permissions" INNER JOIN "filterings" ON "permissions"."id" = "filterings"."permission_id" INNER JOIN "filters" ON "filterings"."filter_id" = "filters"."id" WHERE "filters"."role_id" = $1 ORDER BY filters.role_id, filters.id [["role_id", 2]] 2017-04-17 07:13:06 [sql] [D] (0.4ms) SELECT permissions.name FROM "permissions" INNER JOIN "filterings" ON "permissions"."id" = "filterings"."permission_id" INNER JOIN "filters" ON "filterings"."filter_id" = "filters"."id" WHERE "filters"."role_id" = $1 ORDER BY filters.role_id, filters.id [["role_id", 11]] 2017-04-17 07:13:06 [sql] [D] (0.5ms) SELECT permissions.name FROM "permissions" INNER JOIN "filterings" ON "permissions"."id" = "filterings"."permission_id" INNER JOIN "filters" ON "filterings"."filter_id" = "filters"."id" WHERE "filters"."role_id" = $1 ORDER BY filters.role_id, filters.id [["role_id", 17]] 2017-04-17 07:13:06 [sql] [D] (1.4ms) SELECT permissions.name FROM "permissions" INNER JOIN "filterings" ON "permissions"."id" = "filterings"."permission_id" INNER JOIN "filters" ON "filterings"."filter_id" = "filters"."id" WHERE "filters"."role_id" = $1 ORDER BY filters.role_id, filters.id [["role_id", 1]] 2017-04-17 07:13:06 [sql] [D] (0.6ms) SELECT permissions.name FROM "permissions" INNER JOIN "filterings" ON "permissions"."id" = "filterings"."permission_id" INNER JOIN "filters" ON "filterings"."filter_id" = "filters"."id" WHERE "filters"."role_id" = $1 ORDER BY filters.role_id, filters.id [["role_id", 7]] 2017-04-17 07:13:06 [permissions] [D] rendering 403 because of missing permission 2017-04-17 07:13:06 [app] [I] Rendered common/403.html.erb within layouts/application (23.5ms) 2017-04-17 07:13:06 [app] [I] Rendered layouts/_application_content.html.erb (2.6ms) ********************* Expected results: With 'Remote Execution User' or 'Remote Execution Manager' role, non-admin user should be able to perform remote actions on host systems. Additional info: Though user have all other default roles from satellite assigned i.e user can access organization, location, dashboard, hosts, host collections, content hosts, etc... still issue persist. But if same user performs action from All Host, it works. Login webui as non-admin user(with Remote exection user/manager role) Hosts --> All Hosts --> select host --> Select Action --> Run Job --> "Job category: Katello" --> "Job template: Install Errata - Katello SSH Default" --> "errata: mention errata to install" --> Submit Debug logs: ********************* 2017-04-20 09:35:32 [sql] [D] Katello::Event Load (0.3ms) SELECT "katello_events".* FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' AND 1=0 AND 1=0 OR DER BY "katello_events"."created_at" DESC LIMIT 1 2017-04-20 09:35:32 [sql] [D] SQL (0.5ms) UPDATE "katello_events" SET "in_progress" = 't' WHERE "katello_events"."id" IN (SELECT "katello_events"."id" FROM "katello_event s" WHERE "katello_events"."in_progress" = 'f' AND 1=0 AND 1=0 ORDER BY "katello_events"."created_at" ASC) 2017-04-20 09:35:33 [app] [I] Started GET "/content-hosts/content/views/content-host-errata.html" for 10.76.0.19 at 2017-04-20 09:35:33 +0530 2017-04-20 09:35:33 [app] [I] Started GET "/layouts/details-nutupane.html" for 10.76.0.19 at 2017-04-20 09:35:33 +0530 2017-04-20 09:35:33 [app] [I] Started GET "/api/v2/hosts/37/errata?page=1&search=" for 10.76.0.19 at 2017-04-20 09:35:33 +0530 2017-04-20 09:35:34 [sql] [D] (0.8ms) SELECT "katello_events"."object_id" FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' ORDER BY "katello_events"." created_at" ASC LIMIT 1 2017-04-20 09:35:34 [sql] [D] (0.3ms) SELECT "katello_events"."event_type" FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' ORDER BY "katello_events". "created_at" ASC LIMIT 1 2017-04-20 09:35:35 [sql] [D] Katello::Event Load (0.7ms) SELECT "katello_events".* FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' AND 1=0 AND 1=0 OR DER BY "katello_events"."created_at" DESC LIMIT 1 2017-04-20 09:35:35 [sql] [D] SQL (0.6ms) UPDATE "katello_events" SET "in_progress" = 't' WHERE "katello_events"."id" IN (SELECT "katello_events"."id" FROM "katello_event s" WHERE "katello_events"."in_progress" = 'f' AND 1=0 AND 1=0 ORDER BY "katello_events"."created_at" ASC) 2017-04-20 09:35:36 [app] [I] Processing by Katello::Api::V2::HostErrataController#index as JSON 2017-04-20 09:35:36 [app] [I] Parameters: {"page"=>"1", "search"=>"", "api_version"=>"v2", "host_id"=>"37"} 2017-04-20 09:35:37 [sql] [D] (0.9ms) SELECT "katello_events"."object_id" FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' ORDER BY "katello_events"." created_at" ASC LIMIT 1 2017-04-20 09:35:37 [sql] [D] (0.3ms) SELECT "katello_events"."event_type" FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' ORDER BY "katello_events". "created_at" ASC LIMIT 1 2017-04-20 09:35:37 [sql] [D] Katello::Event Load (1.8ms) SELECT "katello_events".* FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' AND 1=0 AND 1=0 OR DER BY "katello_events"."created_at" DESC LIMIT 1 2017-04-20 09:35:37 [sql] [D] SQL (0.5ms) UPDATE "katello_events" SET "in_progress" = 't' WHERE "katello_events"."id" IN (SELECT "katello_events"."id" FROM "katello_event s" WHERE "katello_events"."in_progress" = 'f' AND 1=0 AND 1=0 ORDER BY "katello_events"."created_at" ASC) 2017-04-20 09:35:39 [sql] [D] (0.6ms) SELECT "katello_events"."object_id" FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' ORDER BY "katello_events"." created_at" ASC LIMIT 1 2017-04-20 09:35:39 [sql] [D] (0.2ms) SELECT "katello_events"."event_type" FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' ORDER BY "katello_events". "created_at" ASC LIMIT 1 2017-04-20 09:35:39 [sql] [D] Katello::Event Load (0.3ms) SELECT "katello_events".* FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' AND 1=0 AND 1=0 OR DER BY "katello_events"."created_at" DESC LIMIT 1 2017-04-20 09:35:39 [sql] [D] SQL (0.5ms) UPDATE "katello_events" SET "in_progress" = 't' WHERE "katello_events"."id" IN (SELECT "katello_events"."id" FROM "katello_event s" WHERE "katello_events"."in_progress" = 'f' AND 1=0 AND 1=0 ORDER BY "katello_events"."created_at" ASC) 2017-04-20 09:35:41 [sql] [D] (0.9ms) SELECT "katello_events"."object_id" FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' ORDER BY "katello_events"." created_at" ASC LIMIT 1 2017-04-20 09:35:41 [sql] [D] (0.6ms) SELECT "katello_events"."event_type" FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' ORDER BY "katello_events". "created_at" ASC LIMIT 1 2017-04-20 09:35:39 [sql] [D] (0.2ms) SELECT "katello_events"."event_type" FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' ORDER BY "katello_events". "created_at" ASC LIMIT 1 2017-04-20 09:35:39 [sql] [D] Katello::Event Load (0.3ms) SELECT "katello_events".* FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' AND 1=0 AND 1=0 OR DER BY "katello_events"."created_at" DESC LIMIT 1 2017-04-20 09:35:39 [sql] [D] SQL (0.5ms) UPDATE "katello_events" SET "in_progress" = 't' WHERE "katello_events"."id" IN (SELECT "katello_events"."id" FROM "katello_event s" WHERE "katello_events"."in_progress" = 'f' AND 1=0 AND 1=0 ORDER BY "katello_events"."created_at" ASC) 2017-04-20 09:35:41 [sql] [D] (0.9ms) SELECT "katello_events"."object_id" FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' ORDER BY "katello_events"." created_at" ASC LIMIT 1 2017-04-20 09:35:41 [sql] [D] (0.6ms) SELECT "katello_events"."event_type" FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' ORDER BY "katello_events". "created_at" ASC LIMIT 1 2017-04-20 09:35:41 [sql] [D] Katello::Event Load (0.6ms) SELECT "katello_events".* FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' AND 1=0 AND 1=0 ORDER BY "katello_events"."created_at" DESC LIMIT 1 2017-04-20 09:35:41 [sql] [D] SQL (0.5ms) UPDATE "katello_events" SET "in_progress" = 't' WHERE "katello_events"."id" IN (SELECT "katello_events"."id" FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' AND 1=0 AND 1=0 ORDER BY "katello_events"."created_at" ASC) 2017-04-20 09:35:43 [sql] [D] (0.7ms) SELECT "katello_events"."object_id" FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' ORDER BY "katello_events"."created_at" ASC LIMIT 1 2017-04-20 09:35:43 [sql] [D] (0.4ms) SELECT "katello_events"."event_type" FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' ORDER BY "katello_events"."created_at" ASC LIMIT 1 2017-04-20 09:35:43 [sql] [D] Katello::Event Load (0.3ms) SELECT "katello_events".* FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' AND 1=0 AND 1=0 ORDER BY "katello_events"."created_at" DESC LIMIT 1 2017-04-20 09:35:43 [sql] [D] SQL (0.6ms) UPDATE "katello_events" SET "in_progress" = 't' WHERE "katello_events"."id" IN (SELECT "katello_events"."id" FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' AND 1=0 AND 1=0 ORDER BY "katello_events"."created_at" ASC) 2017-04-20 09:35:43 [app] [I] Rendered /opt/theforeman/tfm/root/usr/share/gems/gems/katello-3.0.0.105/app/views/katello/api/v2/host_errata/index.json.rabl within katello/api/v2/layouts/collection (3158.3ms) 2017-04-20 09:35:43 [app] [I] Completed 200 OK in 7159ms (Views: 3201.4ms | ActiveRecord: 520.0ms) 2017-04-20 09:35:45 [sql] [D] (0.8ms) SELECT "katello_events"."object_id" FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' ORDER BY "katello_events"."created_at" ASC LIMIT 1 2017-04-20 09:35:45 [sql] [D] (0.3ms) SELECT "katello_events"."event_type" FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' ORDER BY "katello_events"."created_at" ASC LIMIT 1 2017-04-20 09:35:45 [sql] [D] Katello::Event Load (0.3ms) SELECT "katello_events".* FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' AND 1=0 AND 1=0 ORDER BY "katello_events"."created_at" DESC LIMIT 1 2017-04-20 09:35:45 [sql] [D] SQL (0.4ms) UPDATE "katello_events" SET "in_progress" = 't' WHERE "katello_events"."id" IN (SELECT "katello_events"."id" FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' AND 1=0 AND 1=0 ORDER BY "katello_events"."created_at" ASC) 2017-04-20 09:35:47 [sql] [D] (24.7ms) SELECT "katello_events"."object_id" FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' ORDER BY "katello_events"."created_at" ASC LIMIT 1 2017-04-20 09:35:47 [sql] [D] (0.6ms) SELECT "katello_events"."event_type" FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' ORDER BY "katello_events"."created_at" ASC LIMIT 1 2017-04-20 09:35:47 [sql] [D] Katello::Event Load (0.3ms) SELECT "katello_events".* FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' AND 1=0 AND 1=0 ORDER BY "katello_events"."created_at" DESC LIMIT 1 2017-04-20 09:35:47 [sql] [D] SQL (0.4ms) UPDATE "katello_events" SET "in_progress" = 't' WHERE "katello_events"."id" IN (SELECT "katello_events"."id" FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' AND 1=0 AND 1=0 ORDER BY "katello_events"."created_at" ASC) 2017-04-20 09:35:49 [sql] [D] (35.7ms) SELECT "katello_events"."object_id" FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' ORDER BY "katello_events"."created_at" ASC LIMIT 1 2017-04-20 09:35:49 [sql] [D] (0.6ms) SELECT "katello_events"."event_type" FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' ORDER BY "katello_events"."created_at" ASC LIMIT 1 2017-04-20 09:35:49 [sql] [D] Katello::Event Load (0.3ms) SELECT "katello_events".* FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' AND 1=0 AND 1=0 ORDER BY "katello_events"."created_at" DESC LIMIT 1 2017-04-20 09:35:49 [sql] [D] SQL (4.6ms) UPDATE "katello_events" SET "in_progress" = 't' WHERE "katello_events"."id" IN (SELECT "katello_events"."id" FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' AND 1=0 AND 1=0 ORDER BY "katello_events"."created_at" ASC) 2017-04-20 09:35:51 [sql] [D] (22.2ms) SELECT "katello_events"."object_id" FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' ORDER BY "katello_events"."created_at" ASC LIMIT 1 2017-04-20 09:35:51 [sql] [D] (0.5ms) SELECT "katello_events"."event_type" FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' ORDER BY "katello_events"."created_at" ASC LIMIT 1 2017-04-20 09:35:51 [sql] [D] Katello::Event Load (0.3ms) SELECT "katello_events".* FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' AND 1=0 AND 1=0 ORDER BY "katello_events"."created_at" DESC LIMIT 1 2017-04-20 09:35:51 [sql] [D] SQL (0.4ms) UPDATE "katello_events" SET "in_progress" = 't' WHERE "katello_events"."id" IN (SELECT "katello_events"."id" FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' AND 1=0 AND 1=0 ORDER BY "katello_events"."created_at" ASC) 2017-04-20 09:35:53 [sql] [D] (56.0ms) SELECT "katello_events"."object_id" FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' ORDER BY "katello_events"."created_at" ASC LIMIT 1 2017-04-20 09:35:53 [sql] [D] (0.5ms) SELECT "katello_events"."event_type" FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' ORDER BY "katello_events"."created_at" ASC LIMIT 1 2017-04-20 09:35:53 [sql] [D] Katello::Event Load (0.4ms) SELECT "katello_events".* FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' AND 1=0 AND 1=0 ORDER BY "katello_events"."created_at" DESC LIMIT 1 2017-04-20 09:35:53 [sql] [D] SQL (12.3ms) UPDATE "katello_events" SET "in_progress" = 't' WHERE "katello_events"."id" IN (SELECT "katello_events"."id" FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' AND 1=0 AND 1=0 ORDER BY "katello_events"."created_at" ASC) 2017-04-20 09:35:54 [app] [I] Started GET "/content-hosts/content/views/content-host-packages.html" for 10.76.0.19 at 2017-04-20 09:35:54 +0530 2017-04-20 09:35:54 [app] [I] Started GET "/api/v2/hosts/37/packages?page=1&search=" for 10.76.0.19 at 2017-04-20 09:35:54 +0530 2017-04-20 09:35:55 [sql] [D] (1.2ms) SELECT "katello_events"."object_id" FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' ORDER BY "katello_events"."created_at" ASC LIMIT 1 2017-04-20 09:35:55 [sql] [D] (0.6ms) SELECT "katello_events"."event_type" FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' ORDER BY "katello_events"."created_at" ASC LIMIT 1 2017-04-20 09:35:55 [sql] [D] Katello::Event Load (0.3ms) SELECT "katello_events".* FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' AND 1=0 AND 1=0 ORDER BY "katello_events"."created_at" DESC LIMIT 1 2017-04-20 09:35:55 [sql] [D] SQL (6.0ms) UPDATE "katello_events" SET "in_progress" = 't' WHERE "katello_events"."id" IN (SELECT "katello_events"."id" FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' AND 1=0 AND 1=0 ORDER BY "katello_events"."created_at" ASC) 2017-04-20 09:35:57 [app] [I] Processing by Katello::Api::V2::HostPackagesController#index as JSON 2017-04-20 09:35:57 [app] [I] Parameters: {"page"=>"1", "search"=>"", "api_version"=>"v2", "host_id"=>"37"} 2017-04-20 09:35:57 [sql] [D] (0.9ms) SELECT "katello_events"."object_id" FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' ORDER BY "katello_events"." created_at" ASC LIMIT 1 2017-04-20 09:35:58 [app] [I] Started GET "/api/v2/hosts/37/errata?page=1&search=" for 10.76.0.19 at 2017-04-20 09:35:58 +0530 2017-04-20 09:35:58 [app] [I] Processing by Katello::Api::V2::HostErrataController#index as JSON 2017-04-20 09:35:58 [app] [I] Parameters: {"page"=>"1", "search"=>"", "api_version"=>"v2", "host_id"=>"37"} 2017-04-20 09:35:58 [app] [I] Rendered /opt/theforeman/tfm/root/usr/share/gems/gems/katello-3.0.0.105/app/views/katello/api/v2/host_errata/index.json.rabl within katello/api/v2/layouts/collection (250.0ms) 2017-04-20 09:35:58 [app] [I] Completed 200 OK in 330ms (Views: 234.4ms | ActiveRecord: 30.4ms) 2017-04-20 09:35:59 [sql] [D] (0.9ms) SELECT "katello_events"."event_type" FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' ORDER BY "katello_events"."created_at" ASC LIMIT 1 2017-04-20 09:35:59 [sql] [D] Katello::Event Load (0.4ms) SELECT "katello_events".* FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' AND 1=0 AND 1=0 ORDER BY "katello_events"."created_at" DESC LIMIT 1 2017-04-20 09:35:59 [sql] [D] SQL (0.7ms) UPDATE "katello_events" SET "in_progress" = 't' WHERE "katello_events"."id" IN (SELECT "katello_events"."id" FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' AND 1=0 AND 1=0 ORDER BY "katello_events"."created_at" ASC) 2017-04-20 09:36:00 [app] [I] Rendered /opt/theforeman/tfm/root/usr/share/gems/gems/katello-3.0.0.105/app/views/katello/api/v2/host_packages/index.json.rabl within katello/api/v2/layouts/collection (475.5ms) 2017-04-20 09:36:00 [app] [I] Completed 200 OK in 3606ms (Views: 651.7ms | ActiveRecord: 387.8ms) 2017-04-20 09:36:01 [sql] [D] (0.7ms) SELECT "katello_events"."object_id" FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' ORDER BY "katello_events"."created_at" ASC LIMIT 1 2017-04-20 09:36:01 [sql] [D] (0.3ms) SELECT "katello_events"."event_type" FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' ORDER BY "katello_events"."created_at" ASC LIMIT 1 2017-04-20 09:36:01 [sql] [D] Katello::Event Load (17.7ms) SELECT "katello_events".* FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' AND 1=0 AND 1=0 ORDER BY "katello_events"."created_at" DESC LIMIT 1 2017-04-20 09:36:01 [sql] [D] SQL (0.8ms) UPDATE "katello_events" SET "in_progress" = 't' WHERE "katello_events"."id" IN (SELECT "katello_events"."id" FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' AND 1=0 AND 1=0 ORDER BY "katello_events"."created_at" ASC) 2017-04-20 09:36:03 [sql] [D] (0.7ms) SELECT "katello_events"."object_id" FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' ORDER BY "katello_events"."created_at" ASC LIMIT 1 2017-04-20 09:36:03 [sql] [D] (0.4ms) SELECT "katello_events"."event_type" FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' ORDER BY "katello_events"."created_at" ASC LIMIT 1 2017-04-20 09:36:03 [sql] [D] Katello::Event Load (0.5ms) SELECT "katello_events".* FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' AND 1=0 AND 1=0 ORDER BY "katello_events"."created_at" DESC LIMIT 1 2017-04-20 09:36:03 [sql] [D] SQL (0.7ms) UPDATE "katello_events" SET "in_progress" = 't' WHERE "katello_events"."id" IN (SELECT "katello_events"."id" FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' AND 1=0 AND 1=0 ORDER BY "katello_events"."created_at" ASC) 2017-04-20 09:36:05 [sql] [D] (1.0ms) SELECT "katello_events"."object_id" FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' ORDER BY "katello_events"."created_at" ASC LIMIT 1 2017-04-20 09:36:05 [sql] [D] (0.5ms) SELECT "katello_events"."event_type" FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' ORDER BY "katello_events"."created_at" ASC LIMIT 1 2017-04-20 09:36:05 [sql] [D] Katello::Event Load (0.4ms) SELECT "katello_events".* FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' AND 1=0 AND 1=0 OR: DER BY "katello_events"."created_at" DESC LIMIT 1 2017-04-20 09:36:05 [sql] [D] SQL (0.4ms) UPDATE "katello_events" SET "in_progress" = 't' WHERE "katello_events"."id" IN (SELECT "katello_events"."id" FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' AND 1=0 AND 1=0 ORDER BY "katello_events"."created_at" ASC) 2017-04-20 09:36:07 [sql] [D] (0.8ms) SELECT "katello_events"."object_id" FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' ORDER BY "katello_events"."created_at" ASC LIMIT 1 2017-04-20 09:36:07 [sql] [D] (0.3ms) SELECT "katello_events"."event_type" FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' ORDER BY "katello_events"."created_at" ASC LIMIT 1 2017-04-20 09:36:07 [sql] [D] Katello::Event Load (0.3ms) SELECT "katello_events".* FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' AND 1=0 AND 1=0 ORDER BY "katello_events"."created_at" DESC LIMIT 1 2017-04-20 09:36:07 [sql] [D] SQL (0.4ms) UPDATE "katello_events" SET "in_progress" = 't' WHERE "katello_events"."id" IN (SELECT "katello_events"."id" FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' AND 1=0 AND 1=0 ORDER BY "katello_events"."created_at" ASC) 2017-04-20 09:36:09 [sql] [D] (0.7ms) SELECT "katello_events"."object_id" FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' ORDER BY "katello_events"."created_at" ASC LIMIT 1 2017-04-20 09:36:09 [sql] [D] (0.6ms) SELECT "katello_events"."event_type" FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' ORDER BY "katello_events"."created_at" ASC LIMIT 1 2017-04-20 09:36:09 [sql] [D] Katello::Event Load (0.5ms) SELECT "katello_events".* FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' AND 1=0 AND 1=0 ORDER BY "katello_events"."created_at" DESC LIMIT 1 2017-04-20 09:36:09 [sql] [D] SQL (0.9ms) UPDATE "katello_events" SET "in_progress" = 't' WHERE "katello_events"."id" IN (SELECT "katello_events"."id" FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' AND 1=0 AND 1=0 ORDER BY "katello_events"."created_at" ASC) 2017-04-20 09:36:11 [sql] [D] (6.7ms) SELECT "katello_events"."object_id" FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' ORDER BY "katello_events"."created_at" ASC LIMIT 1 2017-04-20 09:36:11 [sql] [D] (0.2ms) SELECT "katello_events"."event_type" FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' ORDER BY "katello_events"."created_at" ASC LIMIT 1 2017-04-20 09:36:11 [sql] [D] Katello::Event Load (8.5ms) SELECT "katello_events".* FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' AND 1=0 AND 1=0 ORDER BY "katello_events"."created_at" DESC LIMIT 1 2017-04-20 09:36:11 [sql] [D] SQL (5.5ms) UPDATE "katello_events" SET "in_progress" = 't' WHERE "katello_events"."id" IN (SELECT "katello_events"."id" FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' AND 1=0 AND 1=0 ORDER BY "katello_events"."created_at" ASC) 2017-04-20 09:36:13 [sql] [D] (1.1ms) SELECT "katello_events"."object_id" FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' ORDER BY "katello_events"."created_at" ASC LIMIT 1 2017-04-20 09:36:13 [sql] [D] (0.5ms) SELECT "katello_events"."event_type" FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' ORDER BY "katello_events"."created_at" ASC LIMIT 1 2017-04-20 09:36:13 [sql] [D] Katello::Event Load (0.7ms) SELECT "katello_events".* FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' AND 1=0 AND 1=0 ORDER BY "katello_events"."created_at" DESC LIMIT 1 2017-04-20 09:36:13 [sql] [D] SQL (0.7ms) UPDATE "katello_events" SET "in_progress" = 't' WHERE "katello_events"."id" IN (SELECT "katello_events"."id" FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' AND 1=0 AND 1=0 ORDER BY "katello_events"."created_at" ASC) 2017-04-20 09:36:15 [sql] [D] (0.7ms) SELECT "katello_events"."object_id" FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' ORDER BY "katello_events"."created_at" ASC LIMIT 1 2017-04-20 09:36:15 [sql] [D] (0.5ms) SELECT "katello_events"."event_type" FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' ORDER BY "katello_events"."created_at" ASC LIMIT 1 2017-04-20 09:36:15 [sql] [D] Katello::Event Load (0.3ms) SELECT "katello_events".* FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' AND 1=0 AND 1=0 OR: DER BY "katello_events"."created_at" DESC LIMIT 1 2017-04-20 09:36:15 [sql] [D] SQL (0.5ms) UPDATE "katello_events" SET "in_progress" = 't' WHERE "katello_events"."id" IN (SELECT "katello_events"."id" FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' AND 1=0 AND 1=0 ORDER BY "katello_events"."created_at" ASC) 2017-04-20 09:36:17 [sql] [D] (0.7ms) SELECT "katello_events"."object_id" FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' ORDER BY "katello_events"."created_at" ASC LIMIT 1 2017-04-20 09:36:17 [sql] [D] (0.5ms) SELECT "katello_events"."event_type" FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' ORDER BY "katello_events"."created_at" ASC LIMIT 1 2017-04-20 09:36:17 [sql] [D] Katello::Event Load (0.4ms) SELECT "katello_events".* FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' AND 1=0 AND 1=0 ORDER BY "katello_events"."created_at" DESC LIMIT 1 2017-04-20 09:36:17 [sql] [D] SQL (0.4ms) UPDATE "katello_events" SET "in_progress" = 't' WHERE "katello_events"."id" IN (SELECT "katello_events"."id" FROM "katello_events" WHERE "katello_events"."in_progress" = 'f' AND 1=0 AND 1=0 ORDER BY "katello_events"."created_at" ASC) *********************