-
-
Save csschwe/ce6024a107fd6f6844cb to your computer and use it in GitHub Desktop.
foreman non adminusers unable to see config reports
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 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