Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
foreman non adminusers unable to see config reports
2016-02-29 14:06:27 [app] [I] Started GET "/hosts/testserver.domain.com/config_reports/last" for 10.37.7.84 at 2016-02-29 14:06:27 +0000
2016-02-29 14:06:27 [app] [I] Processing by ConfigReportsController#show as HTML
2016-02-29 14:06:27 [app] [I] Parameters: {"host_id"=>"testserver.domain.com", "id"=>"last"}
2016-02-29 14:06:27 [sql] [D] User Load (0.9ms) SELECT "users".* FROM "users" WHERE "users"."id" = $1 LIMIT 1 [["id", 65]]
2016-02-29 14:06:27 [sql] [D] AuthSource Load (0.6ms) SELECT "auth_sources".* FROM "auth_sources" WHERE "auth_sources"."id" = $1 LIMIT 1 [["id", 1]]
2016-02-29 14:06:27 [sql] [D] Usergroup Load (0.8ms) SELECT "usergroups".* FROM "usergroups" INNER JOIN "cached_usergroup_members" ON "usergroups"."id" = "cached_usergroup_members"."usergroup_id" WHERE "cached_usergroup_members"."user_id" = $1 ORDER BY usergroups.name [["user_id", 65]]
2016-02-29 14:06:27 [sql] [D] Role Load (2.8ms) 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", 65]]
2016-02-29 14:06:27 [sql] [D] (1.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", 8]]
2016-02-29 14:06:27 [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", 10]]
2016-02-29 14:06:27 [permissions] [D] checking permission view_hosts
2016-02-29 14:06:27 [sql] [D] Filter Load (2.0ms) SELECT "filters".* FROM "filters" INNER JOIN "filterings" ON "filterings"."filter_id" = "filters"."id" INNER JOIN "permissions" ON "permissions"."id" = "filterings"."permission_id" INNER JOIN "roles" ON "filters"."role_id" = "roles"."id" INNER JOIN "cached_user_roles" ON "roles"."id" = "cached_user_roles"."role_id" WHERE "cached_user_roles"."user_id" = $1 AND (permissions.resource_type = 'Host') AND (permissions.name = 'view_hosts') ORDER BY filters.role_id, filters.id [["user_id", 65]]
2016-02-29 14:06:27 [permissions] [D] filter with role_id: 10 limited: false search: taxonomy_search:
2016-02-29 14:06:27 [sql] [D] (54.6ms) SELECT COUNT(*) FROM "hosts" WHERE "hosts"."type" IN ('Host::Managed')
2016-02-29 14:06:27 [sql] [D] SQL (0.9ms) SELECT "hosts"."id" AS t0_r0, "hosts"."name" AS t0_r1, "hosts"."last_compile" AS t0_r2, "hosts"."last_report" AS t0_r3, "hosts"."updated_at" AS t0_r4, "hosts"."created_at" AS t0_r5, "hosts"."root_pass" AS t0_r6, "hosts"."architecture_id" AS t0_r7, "hosts"."operatingsystem_id" AS t0_r8, "hosts"."environment_id" AS t0_r9, "hosts"."ptable_id" AS t0_r10, "hosts"."medium_id" AS t0_r11, "hosts"."build" AS t0_r12, "hosts"."comment" AS t0_r13, "hosts"."disk" AS t0_r14, "hosts"."installed_at" AS t0_r15, "hosts"."model_id" AS t0_r16, "hosts"."hostgroup_id" AS t0_r17, "hosts"."owner_id" AS t0_r18, "hosts"."owner_type" AS t0_r19, "hosts"."enabled" AS t0_r20, "hosts"."puppet_ca_proxy_id" AS t0_r21, "hosts"."managed" AS t0_r22, "hosts"."use_image" AS t0_r23, "hosts"."image_file" AS t0_r24, "hosts"."uuid" AS t0_r25, "hosts"."compute_resource_id" AS t0_r26, "hosts"."puppet_proxy_id" AS t0_r27, "hosts"."certname" AS t0_r28, "hosts"."image_id" AS t0_r29, "hosts"."organization_id" AS t0_r30, "hosts"."location_id" AS t0_r31, "hosts"."type" AS t0_r32, "hosts"."otp" AS t0_r33, "hosts"."realm_id" AS t0_r34, "hosts"."compute_profile_id" AS t0_r35, "hosts"."provision_method" AS t0_r36, "hosts"."grub_pass" AS t0_r37, "hosts"."global_status" AS t0_r38, "hosts"."lookup_value_matcher" AS t0_r39 FROM "hosts" WHERE "hosts"."type" IN ('Host::Managed') AND "hosts"."name" = 'testserver.domain.com' LIMIT 1
2016-02-29 14:06:27 [permissions] [D] checking permission view_config_reports
2016-02-29 14:06:27 [sql] [D] Filter Load (1.4ms) SELECT "filters".* FROM "filters" INNER JOIN "filterings" ON "filterings"."filter_id" = "filters"."id" INNER JOIN "permissions" ON "permissions"."id" = "filterings"."permission_id" INNER JOIN "roles" ON "filters"."role_id" = "roles"."id" INNER JOIN "cached_user_roles" ON "roles"."id" = "cached_user_roles"."role_id" WHERE "cached_user_roles"."user_id" = $1 AND (permissions.resource_type = 'Report') AND (permissions.name = 'view_config_reports') ORDER BY filters.role_id, filters.id [["user_id", 65]]
2016-02-29 14:06:27 [permissions] [D]
2016-02-29 14:06:27 [permissions] [D] no filters found for given permission
2016-02-29 14:06:27 [permissions] [D] checking permission view_hosts
2016-02-29 14:06:27 [sql] [D] CACHE (0.0ms) SELECT "filters".* FROM "filters" INNER JOIN "filterings" ON "filterings"."filter_id" = "filters"."id" INNER JOIN "permissions" ON "permissions"."id" = "filterings"."permission_id" INNER JOIN "roles" ON "filters"."role_id" = "roles"."id" INNER JOIN "cached_user_roles" ON "roles"."id" = "cached_user_roles"."role_id" WHERE "cached_user_roles"."user_id" = $1 AND (permissions.resource_type = 'Host') AND (permissions.name = 'view_hosts') ORDER BY filters.role_id, filters.id [["user_id", 65]]
2016-02-29 14:06:27 [permissions] [D] filter with role_id: 10 limited: false search: taxonomy_search:
2016-02-29 14:06:27 [sql] [D] (0.7ms) SELECT MAX("reports"."id") AS max_id FROM "reports" INNER JOIN "hosts" ON "hosts"."id" = "reports"."host_id" AND "hosts"."type" IN ('Host::Managed') WHERE "reports"."type" IN ('ConfigReport') AND (1=0) AND "reports"."host_id" = 177861
2016-02-29 14:06:27 [app] [I] Rendered common/404.html.erb within layouts/application (2.1ms)
2016-02-29 14:06:27 [app] [I] Rendered layouts/_application_content.html.erb (0.3ms)
2016-02-29 14:06:27 [app] [I] Rendered home/_user_dropdown.html.erb (3.3ms)
2016-02-29 14:06:27 [app] [I] Read fragment views/tabs_and_title_records-65 (0.7ms)
2016-02-29 14:06:27 [app] [I] Rendered home/_topbar.html.erb (5.0ms)
2016-02-29 14:06:27 [app] [I] Rendered layouts/base.html.erb (6.3ms)
2016-02-29 14:06:27 [app] [I] Completed 404 Not Found in 117ms (Views: 11.3ms | ActiveRecord: 67.6ms)
2016-02-29 14:06:27 [app] [I] Started GET "/hosts/testserver.domain.com/config_reports/last" for 10.37.7.84 at 2016-02-29 14:06:27 +0000
2016-02-29 14:06:27 [app] [I] Processing by ConfigReportsController#show as HTML
2016-02-29 14:06:27 [app] [I] Parameters: {"host_id"=>"testserver.domain.com", "id"=>"last"}
2016-02-29 14:06:27 [sql] [D] User Load (0.7ms) SELECT "users".* FROM "users" WHERE "users"."id" = $1 LIMIT 1 [["id", 65]]
2016-02-29 14:06:27 [sql] [D] AuthSource Load (0.8ms) SELECT "auth_sources".* FROM "auth_sources" WHERE "auth_sources"."id" = $1 LIMIT 1 [["id", 1]]
2016-02-29 14:06:27 [sql] [D] Usergroup Load (0.6ms) SELECT "usergroups".* FROM "usergroups" INNER JOIN "cached_usergroup_members" ON "usergroups"."id" = "cached_usergroup_members"."usergroup_id" WHERE "cached_usergroup_members"."user_id" = $1 ORDER BY usergroups.name [["user_id", 65]]
2016-02-29 14:06:27 [sql] [D] Role Load (0.7ms) 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", 65]]
2016-02-29 14:06:27 [sql] [D] (0.9ms) 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]]
2016-02-29 14:06:27 [sql] [D] (0.9ms) 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]]
2016-02-29 14:06:27 [permissions] [D] checking permission view_hosts
2016-02-29 14:06:27 [sql] [D] Filter Load (1.5ms) SELECT "filters".* FROM "filters" INNER JOIN "filterings" ON "filterings"."filter_id" = "filters"."id" INNER JOIN "permissions" ON "permissions"."id" = "filterings"."permission_id" INNER JOIN "roles" ON "filters"."role_id" = "roles"."id" INNER JOIN "cached_user_roles" ON "roles"."id" = "cached_user_roles"."role_id" WHERE "cached_user_roles"."user_id" = $1 AND (permissions.resource_type = 'Host') AND (permissions.name = 'view_hosts') ORDER BY filters.role_id, filters.id [["user_id", 65]]
2016-02-29 14:06:27 [permissions] [D] filter with role_id: 10 limited: false search: taxonomy_search:
2016-02-29 14:06:27 [sql] [D] (37.6ms) SELECT COUNT(*) FROM "hosts" WHERE "hosts"."type" IN ('Host::Managed')
2016-02-29 14:06:27 [sql] [D] SQL (0.9ms) SELECT "hosts"."id" AS t0_r0, "hosts"."name" AS t0_r1, "hosts"."last_compile" AS t0_r2, "hosts"."last_report" AS t0_r3, "hosts"."updated_at" AS t0_r4, "hosts"."created_at" AS t0_r5, "hosts"."root_pass" AS t0_r6, "hosts"."architecture_id" AS t0_r7, "hosts"."operatingsystem_id" AS t0_r8, "hosts"."environment_id" AS t0_r9, "hosts"."ptable_id" AS t0_r10, "hosts"."medium_id" AS t0_r11, "hosts"."build" AS t0_r12, "hosts"."comment" AS t0_r13, "hosts"."disk" AS t0_r14, "hosts"."installed_at" AS t0_r15, "hosts"."model_id" AS t0_r16, "hosts"."hostgroup_id" AS t0_r17, "hosts"."owner_id" AS t0_r18, "hosts"."owner_type" AS t0_r19, "hosts"."enabled" AS t0_r20, "hosts"."puppet_ca_proxy_id" AS t0_r21, "hosts"."managed" AS t0_r22, "hosts"."use_image" AS t0_r23, "hosts"."image_file" AS t0_r24, "hosts"."uuid" AS t0_r25, "hosts"."compute_resource_id" AS t0_r26, "hosts"."puppet_proxy_id" AS t0_r27, "hosts"."certname" AS t0_r28, "hosts"."image_id" AS t0_r29, "hosts"."organization_id" AS t0_r30, "hosts"."location_id" AS t0_r31, "hosts"."type" AS t0_r32, "hosts"."otp" AS t0_r33, "hosts"."realm_id" AS t0_r34, "hosts"."compute_profile_id" AS t0_r35, "hosts"."provision_method" AS t0_r36, "hosts"."grub_pass" AS t0_r37, "hosts"."global_status" AS t0_r38, "hosts"."lookup_value_matcher" AS t0_r39 FROM "hosts" WHERE "hosts"."type" IN ('Host::Managed') AND "hosts"."name" = 'testserver.domain.com' LIMIT 1
2016-02-29 14:06:27 [permissions] [D] checking permission view_config_reports
2016-02-29 14:06:27 [sql] [D] Filter Load (2.2ms) SELECT "filters".* FROM "filters" INNER JOIN "filterings" ON "filterings"."filter_id" = "filters"."id" INNER JOIN "permissions" ON "permissions"."id" = "filterings"."permission_id" INNER JOIN "roles" ON "filters"."role_id" = "roles"."id" INNER JOIN "cached_user_roles" ON "roles"."id" = "cached_user_roles"."role_id" WHERE "cached_user_roles"."user_id" = $1 AND (permissions.resource_type = 'Report') AND (permissions.name = 'view_config_reports') ORDER BY filters.role_id, filters.id [["user_id", 65]]
2016-02-29 14:06:27 [permissions] [D]
2016-02-29 14:06:27 [permissions] [D] no filters found for given permission
2016-02-29 14:06:27 [permissions] [D] checking permission view_hosts
2016-02-29 14:06:27 [sql] [D] CACHE (0.0ms) SELECT "filters".* FROM "filters" INNER JOIN "filterings" ON "filterings"."filter_id" = "filters"."id" INNER JOIN "permissions" ON "permissions"."id" = "filterings"."permission_id" INNER JOIN "roles" ON "filters"."role_id" = "roles"."id" INNER JOIN "cached_user_roles" ON "roles"."id" = "cached_user_roles"."role_id" WHERE "cached_user_roles"."user_id" = $1 AND (permissions.resource_type = 'Host') AND (permissions.name = 'view_hosts') ORDER BY filters.role_id, filters.id [["user_id", 65]]
2016-02-29 14:06:27 [permissions] [D] filter with role_id: 10 limited: false search: taxonomy_search:
2016-02-29 14:06:27 [sql] [D] (0.9ms) SELECT MAX("reports"."id") AS max_id FROM "reports" INNER JOIN "hosts" ON "hosts"."id" = "reports"."host_id" AND "hosts"."type" IN ('Host::Managed') WHERE "reports"."type" IN ('ConfigReport') AND (1=0) AND "reports"."host_id" = 177861
2016-02-29 14:06:27 [app] [I] Rendered common/404.html.erb within layouts/application (0.9ms)
2016-02-29 14:06:27 [app] [I] Rendered layouts/_application_content.html.erb (0.2ms)
2016-02-29 14:06:27 [app] [I] Rendered home/_user_dropdown.html.erb (3.6ms)
2016-02-29 14:06:27 [app] [I] Read fragment views/tabs_and_title_records-65 (0.8ms)
2016-02-29 14:06:27 [app] [I] Rendered home/_topbar.html.erb (5.3ms)
2016-02-29 14:06:27 [app] [I] Rendered layouts/base.html.erb (6.7ms)
2016-02-29 14:06:27 [app] [I] Completed 404 Not Found in 90ms (Views: 9.2ms | ActiveRecord: 47.6ms)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.