Actions
Bug #3530
closed
Unable to destroy a host when user have permissions to "destroy_hosts" but no premissions to "destroy_reports".
Added by Petter Hassberg over 10 years ago. Updated over 8 years ago.
Status:
Resolved
Priority:
Normal
Assignee:
-
Category:
Users, Roles and Permissions
Target version:
-
Description
When a user belongs to a group which have rights to
Hosts: destroy_hosts
But NO rights to:
Reports: destroy_reports
(Permissions ticked in the Foreman UI for that group)
That user won't be able to delete that host:
Operation FAILED: ERROR: update or delete on table "hosts" violates foreign key constraint "reports_host_id_fk" on table "reports"
DETAIL: Key (id)=(283) is still referenced from table "reports".
When the "destroy_reports" permission is added to that role, then destroying hosts works as expected.
Updated by Dominic Cleal over 10 years ago
- Category changed from Host creation to Users, Roles and Permissions
Updated by Dominic Cleal about 10 years ago
- Has duplicate Bug #5616: Delete of Host fails when Reports are present added
Updated by Kamjar Gerami over 8 years ago
I was unable to reproduce this (tested on 1.9.2)
2015-11-06 10:25:15 [app] [I] Processing by HostsController#destroy as HTML
2015-11-06 10:25:15 [app] [I] Parameters: {"authenticity_token"=>"GUStAxg1n2pFBG9wBnHTkvunIBZ8Fg/U/ywG0ItFu4k=", "id"=>"agent01.example.com"}
2015-11-06 10:25:15 [sql] [D] User Load (0.2ms) SELECT "users".* FROM "users" WHERE "users"."id" = $1 LIMIT 1 [["id", 4]]
2015-11-06 10:25:15 [app] [D] Setting current user thread-local variable to kamger
2015-11-06 10:25:15 [sql] [D] Setting Load (0.5ms) SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'authorize_login_delegation' ORDER BY name LIMIT 1
2015-11-06 10:25:15 [sql] [D] Setting Load (21.6ms) SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'idle_timeout' ORDER BY name LIMIT 1
2015-11-06 10:25:16 [sql] [D] SmartProxy Load (1.3ms) SELECT "smart_proxies".* FROM "smart_proxies" WHERE "smart_proxies"."id" = 1 ORDER BY smart_proxies.name LIMIT 1
2015-11-06 10:25:16 [sql] [D] Setting Load (11.1ms) SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'legacy_puppet_hostname' ORDER BY name LIMIT 1
2015-11-06 10:25:16 [sql] [D] Nic::Base Load (0.6ms) SELECT "nics".* FROM "nics" WHERE "nics"."host_id" = 6 ORDER BY identifier
2015-11-06 10:25:16 [app] [I] Processing by HostsController#destroy as HTML
2015-11-06 10:25:16 [app] [I] Parameters: {"authenticity_token"=>"GUStAxg1n2pFBG9wBnHTkvunIBZ8Fg/U/ywG0ItFu4k=", "id"=>"agent01.example.com"}
2015-11-06 10:25:16 [sql] [D] AuthSource Load (0.4ms) SELECT "auth_sources".* FROM "auth_sources" WHERE "auth_sources"."id" = 1 LIMIT 1
2015-11-06 10:25:16 [sql] [D] User Load (0.8ms) SELECT "users".* FROM "users" WHERE "users"."id" = $1 LIMIT 1 [["id", 4]]
2015-11-06 10:25:16 [app] [D] Setting current user thread-local variable to kamger
2015-11-06 10:25:16 [sql] [D] Usergroup Load (0.5ms) SELECT "usergroups".* FROM "usergroups" INNER JOIN "cached_usergroup_members" ON "usergroups"."id" = "cached_usergroup_members"."usergroup_id" WHERE "cached_usergroup_members"."user_id" = 4 ORDER BY usergroups.name
2015-11-06 10:25:16 [sql] [D] Role Load (1.4ms) SELECT DISTINCT "roles".* FROM "roles" INNER JOIN "cached_user_roles" ON "roles"."id" = "cached_user_roles"."role_id" WHERE "cached_user_roles"."user_id" = 4
2015-11-06 10:25:16 [sql] [D] (0.7ms) 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" = 8 ORDER BY role_id, filters.id
2015-11-06 10:25:16 [sql] [D] (1.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" = 4 ORDER BY role_id, filters.id
2015-11-06 10:25:16 [sql] [D] Filter Load (36.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" = 4 AND* (permissions.resource_type = 'Host') AND (permissions.name = 'destroy_hosts')* ORDER BY role_id, filters.id
2015-11-06 10:25:16 [sql] [D] Host::Managed Load (0.4ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."type" IN ('Host::Managed') AND "hosts"."name" = 'agent01.example.com' LIMIT 1
2015-11-06 10:25:17 [sql] [D] AuthSource Load (0.6ms) SELECT "auth_sources".* FROM "auth_sources" WHERE "auth_sources"."id" = 1 LIMIT 1
2015-11-06 10:25:17 [sql] [D] Domain Load (0.3ms) SELECT "domains".* FROM "domains" WHERE "domains"."id" = 1 ORDER BY domains.name LIMIT 1
2015-11-06 10:25:17 [sql] [D] Operatingsystem Load (21.1ms) SELECT "operatingsystems".* FROM "operatingsystems" WHERE "operatingsystems"."id" = 1 ORDER BY title LIMIT 1
2015-11-06 10:25:17 [app] [I] Processing by HostsController#externalNodes as YML
2015-11-06 10:25:17 [app] [I] Parameters: {"name"=>"agent01.example.com"}
2015-11-06 10:25:17 [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" = 4 ORDER BY usergroups.name
2015-11-06 10:25:17 [sql] [D] Role Load (0.6ms) SELECT DISTINCT "roles".* FROM "roles" INNER JOIN "cached_user_roles" ON "roles"."id" = "cached_user_roles"."role_id" WHERE "cached_user_roles"."user_id" = 4
2015-11-06 10:25:17 [sql] [D] (3.0ms) 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" = 8 ORDER BY role_id, filters.id
2015-11-06 10:25:17 [sql] [D] SmartProxy Load (0.8ms) SELECT "smart_proxies".* FROM "smart_proxies" INNER JOIN "features_smart_proxies" ON "features_smart_proxies"."smart_proxy_id" = "smart_proxies"."id" INNER JOIN "features" ON "features"."id" = "features_smart_proxies"."feature_id" WHERE "features"."name" IN ('Puppet') ORDER BY smart_proxies.name
2015-11-06 10:25:17 [app] [D] Verifying request from ["theforeman.example.com"] against ["theforeman.example.com"]
2015-11-06 10:25:17 [sql] [D] (15.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" = 4 ORDER BY role_id, filters.id
2015-11-06 10:25:17 [sql] [D] Filter Load (22.7ms) 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" = 4 AND (permissions.resource_type = 'Host') AND (permissions.name = 'destroy_hosts') ORDER BY role_id, filters.id
2015-11-06 10:25:17 [sql] [D] User Load (0.4ms) SELECT "users".* FROM "users" WHERE "users"."lower_login" = 'foreman_api_admin' LIMIT 1
2015-11-06 10:25:17 [app] [D] Setting current user thread-local variable to foreman_api_admin
2015-11-06 10:25:17 [sql] [D] Host::Managed Load (1.1ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."type" IN ('Host::Managed') AND "hosts"."name" = 'agent01.example.com' LIMIT 1
2015-11-06 10:25:17 [sql] [D] Host::Managed Load (1.1ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."type" IN ('Host::Managed') AND "hosts"."certname" = 'agent01.example.com' LIMIT 1
2015-11-06 10:25:17 [sql] [D] (11.6ms) BEGIN
2015-11-06 10:25:17 [sql] [D] Model Load (0.7ms) SELECT "models".* FROM "models" WHERE "models"."id" = 1 ORDER BY models.name LIMIT 1
2015-11-06 10:25:17 [sql] [D] SQL (11.4ms) UPDATE "models" SET "hosts_count" = COALESCE("hosts_count", 0) - 1 WHERE "models"."id" IN (SELECT "models"."id" FROM "models" WHERE "models"."id" = 1 ORDER BY models.name)
2015-11-06 10:25:17 [sql] [D] FactValue Load (0.7ms) SELECT "fact_values".* FROM "fact_values" WHERE "fact_values"."host_id" = 5
2015-11-06 10:25:17 [sql] [D] SQL (23.1ms) DELETE FROM "fact_values" WHERE "fact_values"."id" = $1 [["id", 412]]
2015-11-06 10:25:17 [sql] [D] SQL (1.1ms) DELETE FROM "fact_values" WHERE "fact_values"."id" = $1 [["id", 413]]
2015-11-06 10:25:17 [sql] [D] Setting Load (3.0ms) SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'root_pass' ORDER BY name LIMIT 1
2015-11-06 10:25:17 [sql] [D] SQL (5.7ms) DELETE FROM "fact_values" WHERE "fact_values"."id" = $1 [["id", 414]]
2015-11-06 10:25:17 [sql] [D] SQL (0.6ms) DELETE FROM "fact_values" WHERE "fact_values"."id" = $1 [["id", 415]]
2015-11-06 10:25:17 [sql] [D] SQL (0.5ms) DELETE FROM "fact_values" WHERE "fact_values"."id" = $1 [["id", 416]]
2015-11-06 10:25:17 [sql] [D] SQL (0.1ms) DELETE FROM "fact_values" WHERE "fact_values"."id" = $1 [["id", 417]]
2015-11-06 10:25:17 [sql] [D] SQL (0.2ms) DELETE FROM "fact_values" WHERE "fact_values"."id" = $1 [["id", 418]]
2015-11-06 10:25:17 [sql] [D] SQL (1.0ms) DELETE FROM "fact_values" WHERE "fact_values"."id" = $1 [["id", 420]]
2015-11-06 10:25:18 [sql] [D] SQL (12.2ms) DELETE FROM "fact_values" WHERE "fact_values"."id" = $1 [["id", 421]]
2015-11-06 10:25:18 [sql] [D] SQL (1.2ms) DELETE FROM "fact_values" WHERE "fact_values"."id" = $1 [["id", 422]]
2015-11-06 10:25:18 [sql] [D] SQL (1.6ms) DELETE FROM "fact_values" WHERE "fact_values"."id" = $1 [["id", 423]]
2015-11-06 10:25:18 [sql] [D] Environment Load (1.7ms) SELECT "environments".* FROM "environments" WHERE "environments"."id" = 4 ORDER BY environments.name LIMIT 1
2015-11-06 10:25:18 [sql] [D] SQL (12.3ms) DELETE FROM "fact_values" WHERE "fact_values"."id" = $1 [["id", 424]]
2015-11-06 10:25:18 [sql] [D] SQL (11.8ms) DELETE FROM "fact_values" WHERE "fact_values"."id" = $1 [["id", 425]]
2015-11-06 10:25:18 [sql] [D] SQL (0.4ms) DELETE FROM "fact_values" WHERE "fact_values"."id" = $1 [["id", 426]]
2015-11-06 10:25:18 [sql] [D] SQL (0.9ms) DELETE FROM "fact_values" WHERE "fact_values"."id" = $1 [["id", 427]]
2015-11-06 10:25:18 [sql] [D] SQL (0.4ms) DELETE FROM "fact_values" WHERE "fact_values"."id" = $1 [["id", 428]]
2015-11-06 10:25:18 [sql] [D] SQL (0.2ms) DELETE FROM "fact_values" WHERE "fact_values"."id" = $1 [["id", 429]]
2015-11-06 10:25:18 [sql] [D] SQL (0.2ms) DELETE FROM "fact_values" WHERE "fact_values"."id" = $1 [["id", 430]]
2015-11-06 10:25:18 [sql] [D] SQL (1.1ms) DELETE FROM "fact_values" WHERE "fact_values"."id" = $1 [["id", 431]]
2015-11-06 10:25:18 [sql] [D] SQL (0.5ms) DELETE FROM "fact_values" WHERE "fact_values"."id" = $1 [["id", 432]]
2015-11-06 10:25:18 [sql] [D] SQL (0.4ms) DELETE FROM "fact_values" WHERE "fact_values"."id" = $1 [["id", 433]]
2015-11-06 10:25:18 [sql] [D] SQL (0.5ms) DELETE FROM "fact_values" WHERE "fact_values"."id" = $1 [["id", 434]]
2015-11-06 10:25:18 [sql] [D] SQL (0.1ms) DELETE FROM "fact_values" WHERE "fact_values"."id" = $1 [["id", 435]]
2015-11-06 10:25:18 [sql] [D] SQL (0.5ms) DELETE FROM "fact_values" WHERE "fact_values"."id" = $1 [["id", 436]]
2015-11-06 10:25:18 [sql] [D] SQL (0.8ms) DELETE FROM "fact_values" WHERE "fact_values"."id" = $1 [["id", 437]]
2015-11-06 10:25:18 [sql] [D] SQL (0.4ms) DELETE FROM "fact_values" WHERE "fact_values"."id" = $1 [["id", 438]]
2015-11-06 10:25:18 [sql] [D] SQL (0.4ms) DELETE FROM "fact_values" WHERE "fact_values"."id" = $1 [["id", 439]]
2015-11-06 10:25:18 [sql] [D] SQL (10.8ms) DELETE FROM "fact_values" WHERE "fact_values"."id" = $1 [["id", 440]]
2015-11-06 10:25:18 [sql] [D] SQL (0.4ms) DELETE FROM "fact_values" WHERE "fact_values"."id" = $1 [["id", 441]]
2015-11-06 10:25:18 [sql] [D] SQL (4.6ms) DELETE FROM "fact_values" WHERE "fact_values"."id" = $1 [["id", 442]]
2015-11-06 10:25:18 [sql] [D] SQL (0.5ms) DELETE FROM "fact_values" WHERE "fact_values"."id" = $1 [["id", 443]]
2015-11-06 10:25:18 [sql] [D] SQL (11.9ms) DELETE FROM "fact_values" WHERE "fact_values"."id" = $1 [["id", 444]]
2015-11-06 10:25:18 [sql] [D] SQL (0.8ms) DELETE FROM "fact_values" WHERE "fact_values"."id" = $1 [["id", 445]]
2015-11-06 10:25:18 [sql] [D] SQL (2.9ms) DELETE FROM "fact_values" WHERE "fact_values"."id" = $1 [["id", 446]]
2015-11-06 10:25:18 [sql] [D] SQL (0.4ms) DELETE FROM "fact_values" WHERE "fact_values"."id" = $1 [["id", 447]]
2015-11-06 10:25:18 [sql] [D] Setting Load (20.5ms) SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'ignore_puppet_facts_for_provisioning' ORDER BY name LIMIT 1
2015-11-06 10:25:18 [sql] [D] SQL (5.8ms) DELETE FROM "fact_values" WHERE "fact_values"."id" = $1 [["id", 448]]
2015-11-06 10:25:18 [sql] [D] SQL (1.1ms) DELETE FROM "fact_values" WHERE "fact_values"."id" = $1 [["id", 449]]
2015-11-06 10:25:18 [sql] [D] SQL (0.5ms) DELETE FROM "fact_values" WHERE "fact_values"."id" = $1 [["id", 450]]
2015-11-06 10:25:18 [sql] [D] SQL (0.1ms) DELETE FROM "fact_values" WHERE "fact_values"."id" = $1 [["id", 451]]
2015-11-06 10:25:18 [sql] [D] SQL (0.5ms) DELETE FROM "fact_values" WHERE "fact_values"."id" = $1 [["id", 452]]
2015-11-06 10:25:18 [sql] [D] SQL (0.9ms) DELETE FROM "fact_values" WHERE "fact_values"."id" = $1 [["id", 453]]
2015-11-06 10:25:18 [sql] [D] SQL (0.4ms) DELETE FROM "fact_values" WHERE "fact_values"."id" = $1 [["id", 454]]
2015-11-06 10:25:18 [sql] [D] SQL (12.2ms) DELETE FROM "fact_values" WHERE "fact_values"."id" = $1 [["id", 455]]
2015-11-06 10:25:18 [sql] [D] SQL (0.4ms) DELETE FROM "fact_values" WHERE "fact_values"."id" = $1 [["id", 456]]
2015-11-06 10:25:18 [sql] [D] SQL (1.6ms) DELETE FROM "fact_values" WHERE "fact_values"."id" = $1 [["id", 457]]
2015-11-06 10:25:18 [sql] [D] CommonParameter Load (1.6ms) SELECT "parameters".* FROM "parameters" WHERE "parameters"."type" IN ('CommonParameter') ORDER BY parameters.name
2015-11-06 10:25:18 [sql] [D] SQL (7.6ms) DELETE FROM "fact_values" WHERE "fact_values"."id" = $1 [["id", 458]]
2015-11-06 10:25:18 [sql] [D] SQL (0.5ms) DELETE FROM "fact_values" WHERE "fact_values"."id" = $1 [["id", 459]]
2015-11-06 10:25:18 [sql] [D] SQL (0.5ms) DELETE FROM "fact_values" WHERE "fact_values"."id" = $1 [["id", 460]]
2015-11-06 10:25:18 [sql] [D] SQL (11.3ms) DELETE FROM "fact_values" WHERE "fact_values"."id" = $1 [["id", 461]]
2015-11-06 10:25:18 [sql] [D] SQL (0.4ms) DELETE FROM "fact_values" WHERE "fact_values"."id" = $1 [["id", 462]]
2015-11-06 10:25:18 [sql] [D] SQL (0.4ms) DELETE FROM "fact_values" WHERE "fact_values"."id" = $1 [["id", 463]]
2015-11-06 10:25:18 [sql] [D] SQL (0.2ms) DELETE FROM "fact_values" WHERE "fact_values"."id" = $1 [["id", 464]]
2015-11-06 10:25:18 [sql] [D] SQL (1.1ms) DELETE FROM "fact_values" WHERE "fact_values"."id" = $1 [["id", 465]]
2015-11-06 10:25:18 [sql] [D] SQL (0.5ms) DELETE FROM "fact_values" WHERE "fact_values"."id" = $1 [["id", 466]]
2015-11-06 10:25:18 [sql] [D] SQL (0.2ms) DELETE FROM "fact_values" WHERE "fact_values"."id" = $1 [["id", 467]]
2015-11-06 10:25:18 [sql] [D] DomainParameter Load (21.2ms) SELECT "parameters".* FROM "parameters" WHERE "parameters"."type" IN ('DomainParameter') AND "parameters"."reference_id" = 1 ORDER BY parameters.name
2015-11-06 10:25:18 [sql] [D] SQL (4.7ms) DELETE FROM "fact_values" WHERE "fact_values"."id" = $1 [["id", 468]]
2015-11-06 10:25:18 [sql] [D] SQL (0.3ms) DELETE FROM "fact_values" WHERE "fact_values"."id" = $1 [["id", 469]]
2015-11-06 10:25:18 [sql] [D] SQL (0.8ms) DELETE FROM "fact_values" WHERE "fact_values"."id" = $1 [["id", 470]]
2015-11-06 10:25:18 [sql] [D] SQL (0.5ms) DELETE FROM "fact_values" WHERE "fact_values"."id" = $1 [["id", 471]]
2015-11-06 10:25:18 [sql] [D] SQL (12.7ms) DELETE FROM "fact_values" WHERE "fact_values"."id" = $1 [["id", 473]]
2015-11-06 10:25:18 [sql] [D] OsParameter Load (18.4ms) SELECT "parameters".* FROM "parameters" WHERE "parameters"."type" IN ('OsParameter') AND "parameters"."reference_id" = 1 ORDER BY parameters.name
2015-11-06 10:25:18 [sql] [D] SQL (8.7ms) DELETE FROM "fact_values" WHERE "fact_values"."id" = $1 [["id", 474]]
2015-11-06 10:25:18 [sql] [D] SQL (0.4ms) DELETE FROM "fact_values" WHERE "fact_values"."id" = $1 [["id", 475]]
2015-11-06 10:25:18 [sql] [D] SQL (0.4ms) DELETE FROM "fact_values" WHERE "fact_values"."id" = $1 [["id", 477]]
2015-11-06 10:25:18 [sql] [D] SQL (0.6ms) DELETE FROM "fact_values" WHERE "fact_values"."id" = $1 [["id", 479]]
2015-11-06 10:25:18 [sql] [D] SQL (11.7ms) DELETE FROM "fact_values" WHERE "fact_values"."id" = $1 [["id", 480]]
2015-11-06 10:25:18 [sql] [D] SQL (0.4ms) DELETE FROM "fact_values" WHERE "fact_values"."id" = $1 [["id", 481]]
2015-11-06 10:25:18 [sql] [D] SQL (0.4ms) DELETE FROM "fact_values" WHERE "fact_values"."id" = $1 [["id", 482]]
2015-11-06 10:25:18 [sql] [D] SQL (0.1ms) DELETE FROM "fact_values" WHERE "fact_values"."id" = $1 [["id", 483]]
2015-11-06 10:25:18 [sql] [D] SQL (1.1ms) DELETE FROM "fact_values" WHERE "fact_values"."id" = $1 [["id", 484]]
2015-11-06 10:25:18 [sql] [D] SQL (0.3ms) DELETE FROM "fact_values" WHERE "fact_values"."id" = $1 [["id", 485]]
2015-11-06 10:25:18 [sql] [D] SQL (0.4ms) DELETE FROM "fact_values" WHERE "fact_values"."id" = $1 [["id", 486]]
2015-11-06 10:25:18 [sql] [D] SQL (0.4ms) DELETE FROM "fact_values" WHERE "fact_values"."id" = $1 [["id", 487]]
2015-11-06 10:25:18 [sql] [D] HostParameter Load (23.7ms) SELECT "parameters".* FROM "parameters" WHERE "parameters"."type" IN ('HostParameter') AND "parameters"."reference_id" = 6 ORDER BY parameters.name
2015-11-06 10:25:18 [sql] [D] SQL (3.2ms) DELETE FROM "fact_values" WHERE "fact_values"."id" = $1 [["id", 488]]
2015-11-06 10:25:18 [sql] [D] SQL (0.5ms) DELETE FROM "fact_values" WHERE "fact_values"."id" = $1 [["id", 489]]
2015-11-06 10:25:18 [sql] [D] Setting Load (3.4ms) SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'Enable_Smart_Variables_in_ENC' ORDER BY name LIMIT 1
2015-11-06 10:25:18 [sql] [D] SQL (9.8ms) DELETE FROM "fact_values" WHERE "fact_values"."id" = $1 [["id", 490]]
2015-11-06 10:25:18 [sql] [D] SQL (0.7ms) DELETE FROM "fact_values" WHERE "fact_values"."id" = $1 [["id", 491]]
2015-11-06 10:25:18 [sql] [D] SQL (0.1ms) DELETE FROM "fact_values" WHERE "fact_values"."id" = $1 [["id", 492]]
2015-11-06 10:25:18 [sql] [D] SQL (12.4ms) DELETE FROM "fact_values" WHERE "fact_values"."id" = $1 [["id", 493]]
2015-11-06 10:25:18 [sql] [D] SQL (0.7ms) DELETE FROM "fact_values" WHERE "fact_values"."id" = $1 [["id", 494]]
2015-11-06 10:25:18 [sql] [D] SQL (0.5ms) DELETE FROM "fact_values" WHERE "fact_values"."id" = $1 [["id", 495]]
2015-11-06 10:25:18 [sql] [D] SQL (0.5ms) DELETE FROM "fact_values" WHERE "fact_values"."id" = $1 [["id", 496]]
2015-11-06 10:25:18 [sql] [D] SQL (10.6ms) DELETE FROM "fact_values" WHERE "fact_values"."id" = $1 [["id", 498]]
2015-11-06 10:25:18 [sql] [D] SQL (0.5ms) DELETE FROM "fact_values" WHERE "fact_values"."id" = $1 [["id", 499]]
2015-11-06 10:25:18 [sql] [D] SQL (0.5ms) DELETE FROM "fact_values" WHERE "fact_values"."id" = $1 [["id", 501]]
2015-11-06 10:25:18 [sql] [D] SQL (0.4ms) DELETE FROM "fact_values" WHERE "fact_values"."id" = $1 [["id", 502]]
2015-11-06 10:25:18 [sql] [D] SQL (0.2ms) DELETE FROM "fact_values" WHERE "fact_values"."id" = $1 [["id", 500]]
2015-11-06 10:25:18 [sql] [D] SQL (0.9ms) DELETE FROM "fact_values" WHERE "fact_values"."id" = $1 [["id", 472]]
2015-11-06 10:25:18 [sql] [D] SQL (1.6ms) DELETE FROM "fact_values" WHERE "fact_values"."id" = $1 [["id", 478]]
2015-11-06 10:25:18 [sql] [D] SQL (1.8ms) DELETE FROM "fact_values" WHERE "fact_values"."id" = $1 [["id", 476]]
2015-11-06 10:25:18 [sql] [D] (1.7ms) SELECT "config_groups".id FROM "config_groups" INNER JOIN "host_config_groups" ON "config_groups"."id" = "host_config_groups"."config_group_id" WHERE "host_config_groups"."host_id" = 6 AND "host_config_groups"."host_type" = 'Host::Base' ORDER BY config_groups.name
2015-11-06 10:25:18 [sql] [D] SQL (2.0ms) DELETE FROM "fact_values" WHERE "fact_values"."id" = $1 [["id", 497]]
2015-11-06 10:25:18 [sql] [D] SQL (1.3ms) DELETE FROM "fact_values" WHERE "fact_values"."id" = $1 [["id", 503]]
2015-11-06 10:25:18 [sql] [D] (0.7ms) SELECT puppetclass_id FROM "config_group_classes" WHERE "config_group_classes"."config_group_id" IN (NULL)
2015-11-06 10:25:18 [sql] [D] SQL (3.2ms) DELETE FROM "fact_values" WHERE "fact_values"."id" = $1 [["id", 504]]
2015-11-06 10:25:18 [sql] [D] SQL (1.1ms) DELETE FROM "fact_values" WHERE "fact_values"."id" = $1 [["id", 505]]
2015-11-06 10:25:18 [sql] [D] (0.5ms) SELECT puppetclass_id FROM "hostgroup_classes" WHERE "hostgroup_classes"."hostgroup_id" IS NULL
2015-11-06 10:25:18 [sql] [D] SQL (18.0ms) DELETE FROM "fact_values" WHERE "fact_values"."id" = $1 [["id", 506]]
2015-11-06 10:25:18 [sql] [D] SQL (0.5ms) DELETE FROM "fact_values" WHERE "fact_values"."id" = $1 [["id", 507]]
2015-11-06 10:25:18 [sql] [D] SQL (10.8ms) DELETE FROM "fact_values" WHERE "fact_values"."id" = $1 [["id", 508]]
2015-11-06 10:25:18 [sql] [D] SQL (0.4ms) DELETE FROM "fact_values" WHERE "fact_values"."id" = $1 [["id", 419]]
2015-11-06 10:25:18 [sql] [D] SQL (0.3ms) DELETE FROM "fact_values" WHERE "fact_values"."id" = $1 [["id", 509]]
2015-11-06 10:25:18 [sql] [D] (0.8ms) SELECT puppetclass_id FROM "host_classes" WHERE "host_classes"."host_id" = 6
2015-11-06 10:25:18 [sql] [D] (0.9ms) SELECT DISTINCT puppetclasses.id FROM "puppetclasses" INNER JOIN "environment_classes" ON "puppetclasses"."id" = "environment_classes"."puppetclass_id" WHERE "environment_classes"."environment_id" = 4 AND "puppetclasses"."id" IN (NULL)
2015-11-06 10:25:18 [sql] [D] Nic::Base Load (10.7ms) SELECT "nics".* FROM "nics" WHERE "nics"."host_id" = 5 ORDER BY identifier
2015-11-06 10:25:18 [sql] [D] LookupKey Load (1.6ms) SELECT "lookup_keys".* FROM "lookup_keys" WHERE "lookup_keys"."puppetclass_id" IN (NULL) ORDER BY lookup_keys.key
2015-11-06 10:25:18 [sql] [D] Setting Load (0.8ms) SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'interpolate_erb_in_parameters' ORDER BY name LIMIT 1
2015-11-06 10:25:18 [sql] [D] Setting Load (35.6ms) SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'safemode_render' ORDER BY name LIMIT 1
2015-11-06 10:25:18 [sql] [D] (1.8ms) BEGIN
2015-11-06 10:25:18 [sql] [D] Model Load (0.4ms) SELECT "models".* FROM "models" WHERE "models"."id" = 1 ORDER BY models.name LIMIT 1
2015-11-06 10:25:18 [sql] [D] SmartProxy Load (22.2ms) SELECT "smart_proxies".* FROM "smart_proxies" WHERE "smart_proxies"."id" = 1 ORDER BY smart_proxies.name LIMIT 1
2015-11-06 10:25:18 [sql] [D] Nic::Base Load (0.6ms) SELECT "nics".* FROM "nics" WHERE "nics"."host_id" = 5 ORDER BY identifier
2015-11-06 10:25:18 [sql] [D] Setting Load (1.6ms) SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'Parametrized_Classes_in_ENC' ORDER BY name LIMIT 1
2015-11-06 10:25:18 [sql] [D] CACHE (0.0ms) SELECT "config_groups".id FROM "config_groups" INNER JOIN "host_config_groups" ON "config_groups"."id" = "host_config_groups"."config_group_id" WHERE "host_config_groups"."host_id" = 6 AND "host_config_groups"."host_type" = 'Host::Base' ORDER BY config_groups.name
2015-11-06 10:25:18 [sql] [D] CACHE (0.0ms) SELECT puppetclass_id FROM "config_group_classes" WHERE "config_group_classes"."config_group_id" IN (NULL)
2015-11-06 10:25:18 [sql] [D] CACHE (0.0ms) SELECT puppetclass_id FROM "hostgroup_classes" WHERE "hostgroup_classes"."hostgroup_id" IS NULL
2015-11-06 10:25:18 [sql] [D] CACHE (0.0ms) SELECT puppetclass_id FROM "host_classes" WHERE "host_classes"."host_id" = 6
2015-11-06 10:25:18 [sql] [D] CACHE (0.0ms) SELECT DISTINCT puppetclasses.id FROM "puppetclasses" INNER JOIN "environment_classes" ON "puppetclasses"."id" = "environment_classes"."puppetclass_id" WHERE "environment_classes"."environment_id" = 4 AND "puppetclasses"."id" IN (NULL)
2015-11-06 10:25:19 [sql] [D] Domain Load (0.3ms) SELECT "domains".* FROM "domains" WHERE "domains"."id" = 1 ORDER BY domains.name LIMIT 1
2015-11-06 10:25:19 [sql] [D] SQL (21.9ms) SELECT "lookup_keys"."id" AS t0_r0, "lookup_keys"."key" AS t0_r1, "lookup_keys"."created_at" AS t0_r2, "lookup_keys"."updated_at" AS t0_r3, "lookup_keys"."puppetclass_id" AS t0_r4, "lookup_keys"."default_value" AS t0_r5, "lookup_keys"."path" AS t0_r6, "lookup_keys"."description" AS t0_r7, "lookup_keys"."validator_type" AS t0_r8, "lookup_keys"."validator_rule" AS t0_r9, "lookup_keys"."is_param" AS t0_r10, "lookup_keys"."key_type" AS t0_r11, "lookup_keys"."override" AS t0_r12, "lookup_keys"."required" AS t0_r13, "lookup_keys"."lookup_values_count" AS t0_r14, "lookup_keys"."merge_overrides" AS t0_r15, "lookup_keys"."avoid_duplicates" AS t0_r16, "lookup_keys"."use_puppet_default" AS t0_r17, "environment_classes"."id" AS t1_r0, "environment_classes"."puppetclass_id" AS t1_r1, "environment_classes"."environment_id" AS t1_r2, "environment_classes"."lookup_key_id" AS t1_r3 FROM "lookup_keys" INNER JOIN "environment_classes" ON "environment_classes"."lookup_key_id" = "lookup_keys"."id" WHERE "lookup_keys"."override" = 't' AND "environment_classes"."puppetclass_id" IN (NULL) AND "environment_classes"."environment_id" = 4 ORDER BY lookup_keys.key
2015-11-06 10:25:19 [sql] [D] CACHE (0.0ms) SELECT "config_groups".id FROM "config_groups" INNER JOIN "host_config_groups" ON "config_groups"."id" = "host_config_groups"."config_group_id" WHERE "host_config_groups"."host_id" = 6 AND "host_config_groups"."host_type" = 'Host::Base' ORDER BY config_groups.name
2015-11-06 10:25:19 [sql] [D] CACHE (0.0ms) SELECT puppetclass_id FROM "config_group_classes" WHERE "config_group_classes"."config_group_id" IN (NULL)
2015-11-06 10:25:19 [sql] [D] CACHE (0.0ms) SELECT puppetclass_id FROM "hostgroup_classes" WHERE "hostgroup_classes"."hostgroup_id" IS NULL
2015-11-06 10:25:19 [sql] [D] CACHE (0.0ms) SELECT puppetclass_id FROM "host_classes" WHERE "host_classes"."host_id" = 6
2015-11-06 10:25:19 [sql] [D] Puppetclass Load (1.3ms) SELECT DISTINCT "puppetclasses".* FROM "puppetclasses" INNER JOIN "environment_classes" ON "puppetclasses"."id" = "environment_classes"."puppetclass_id" WHERE "environment_classes"."environment_id" = 4 AND "puppetclasses"."id" IN (NULL) ORDER BY puppetclasses.name
2015-11-06 10:25:19 [sql] [D] SQL (9.0ms) UPDATE "domains" SET "hosts_count" = COALESCE("hosts_count", 0) - 1 WHERE "domains"."id" IN (SELECT "domains"."id" FROM "domains" WHERE "domains"."id" = 1 ORDER BY domains.name)
2015-11-06 10:25:19 [sql] [D] Setting Load (2.4ms) SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'enc_environment' ORDER BY name LIMIT 1
2015-11-06 10:25:19 [sql] [D] SQL (9.3ms) DELETE FROM "nics" WHERE "nics"."type" IN ('Nic::Managed', 'Nic::BMC', 'Nic::Bond', 'Nic::Bootable') AND "nics"."id" = $1 [["id", 11]]
2015-11-06 10:25:19 [sql] [D] Using host queue
2015-11-06 10:25:19 [sql] [D] SQL (11.0ms) DELETE FROM "nics" WHERE "nics"."type" IN ('Nic::Managed', 'Nic::BMC', 'Nic::Bond', 'Nic::Bootable') AND "nics"."id" = $1 [["id", 12]]
2015-11-06 10:25:19 [sql] [D] Using host queue
2015-11-06 10:25:19 [sql] [D] Puppetclass Load (0.5ms) SELECT "puppetclasses".* FROM "puppetclasses" INNER JOIN "host_classes" ON "puppetclasses"."id" = "host_classes"."puppetclass_id" WHERE "host_classes"."host_id" = 5 ORDER BY puppetclasses.name
2015-11-06 10:25:19 [sql] [D] HostParameter Load (0.5ms) SELECT "parameters".* FROM "parameters" WHERE "parameters"."type" IN ('HostParameter') AND "parameters"."reference_id" = 5 ORDER BY parameters.name
2015-11-06 10:25:19 [sql] [D] CACHE (0.0ms) SELECT "parameters".* FROM "parameters" WHERE "parameters"."type" IN ('HostParameter') AND "parameters"."reference_id" = 5 ORDER BY parameters.name
2015-11-06 10:25:19 [sql] [D] Domain Load (0.5ms) SELECT "domains".* FROM "domains" WHERE "domains"."id" = 1 ORDER BY domains.name LIMIT 1
2015-11-06 10:25:19 [sql] [D] Operatingsystem Load (0.5ms) SELECT "operatingsystems".* FROM "operatingsystems" WHERE "operatingsystems"."id" = 1 ORDER BY title LIMIT 1
2015-11-06 10:25:19 [sql] [D] Setting Load (0.4ms) SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'root_pass' ORDER BY name LIMIT 1
2015-11-06 10:25:19 [sql] [D] Environment Load (1.0ms) SELECT "environments".* FROM "environments" WHERE "environments"."id" = 4 ORDER BY environments.name LIMIT 1
2015-11-06 10:25:19 [sql] [D] Token Load (25.0ms) SELECT "tokens".* FROM "tokens" WHERE "tokens"."host_id" = 5 LIMIT 1
2015-11-06 10:25:19 [sql] [D] (0.4ms) SELECT COUNT(*) FROM "reports" WHERE "reports"."host_id" = 5
2015-11-06 10:25:19 [sql] [D] (0.4ms) SELECT id FROM "reports" WHERE "reports"."host_id" = 5
2015-11-06 10:25:19 [sql] [D] SQL (25.5ms) DELETE FROM "logs" WHERE (report_id IN (128,126,124,122,120))
2015-11-06 10:25:19 [sql] [D] SQL (0.7ms) DELETE FROM "reports" WHERE (host_id = 5)
2015-11-06 10:25:19 [sql] [D] Architecture Load (1.8ms) SELECT "architectures".* FROM "architectures" WHERE "architectures"."id" = 1 LIMIT 1
2015-11-06 10:25:19 [sql] [D] SQL (0.5ms) UPDATE "architectures" SET "hosts_count" = COALESCE("hosts_count", 0) - 1 WHERE "architectures"."id" = 1
2015-11-06 10:25:19 [sql] [D] Environment Load (0.4ms) SELECT "environments".* FROM "environments" WHERE "environments"."id" = 4 ORDER BY environments.name LIMIT 1
2015-11-06 10:25:19 [sql] [D] SQL (23.7ms) UPDATE "environments" SET "hosts_count" = COALESCE("hosts_count", 0) - 1 WHERE "environments"."id" IN (SELECT "environments"."id" FROM "environments" WHERE "environments"."id" = 4 ORDER BY environments.name)
2015-11-06 10:25:19 [sql] [D] Operatingsystem Load (0.6ms) SELECT "operatingsystems".* FROM "operatingsystems" WHERE "operatingsystems"."id" = 1 ORDER BY title LIMIT 1
2015-11-06 10:25:19 [sql] [D] CommonParameter Load (0.5ms) SELECT "parameters".* FROM "parameters" WHERE "parameters"."type" IN ('CommonParameter') ORDER BY parameters.name
2015-11-06 10:25:19 [sql] [D] DomainParameter Load (1.0ms) SELECT "parameters".* FROM "parameters" WHERE "parameters"."type" IN ('DomainParameter') AND "parameters"."reference_id" = 1 ORDER BY parameters.name
2015-11-06 10:25:19 [sql] [D] OsParameter Load (1.6ms) SELECT "parameters".* FROM "parameters" WHERE "parameters"."type" IN ('OsParameter') AND "parameters"."reference_id" = 1 ORDER BY parameters.name
2015-11-06 10:25:19 [sql] [D] HostParameter Load (12.2ms) SELECT "parameters".* FROM "parameters" WHERE "parameters"."type" IN ('HostParameter') AND "parameters"."reference_id" = 5 ORDER BY parameters.name
2015-11-06 10:25:20 [sql] [D] (1.0ms) SELECT "config_groups".id FROM "config_groups" INNER JOIN "host_config_groups" ON "config_groups"."id" = "host_config_groups"."config_group_id" WHERE "host_config_groups"."host_id" = 5 AND "host_config_groups"."host_type" = 'Host::Base' ORDER BY config_groups.name
2015-11-06 10:25:20 [sql] [D] (0.2ms) SELECT puppetclass_id FROM "config_group_classes" WHERE "config_group_classes"."config_group_id" IN (NULL)
2015-11-06 10:25:20 [sql] [D] (0.3ms) SELECT puppetclass_id FROM "hostgroup_classes" WHERE "hostgroup_classes"."hostgroup_id" IS NULL
2015-11-06 10:25:20 [sql] [D] SQL (5.2ms) UPDATE "operatingsystems" SET "hosts_count" = COALESCE("hosts_count", 0) - 1 WHERE "operatingsystems"."id" IN (SELECT "operatingsystems"."id" FROM "operatingsystems" WHERE "operatingsystems"."type" IN ('Redhat') AND "operatingsystems"."id" = 1 ORDER BY title)
2015-11-06 10:25:20 [sql] [D] (0.4ms) SELECT puppetclass_id FROM "host_classes" WHERE "host_classes"."host_id" = 5
2015-11-06 10:25:20 [sql] [D] LookupValue Load (0.3ms) SELECT "lookup_values".* FROM "lookup_values" WHERE "lookup_values"."match" = 'fqdn=agent01.example.com'
2015-11-06 10:25:20 [sql] [D] (2.5ms) SELECT DISTINCT puppetclasses.id FROM "puppetclasses" INNER JOIN "environment_classes" ON "puppetclasses"."id" = "environment_classes"."puppetclass_id" WHERE "environment_classes"."environment_id" = 4 AND "puppetclasses"."id" IN (NULL)
2015-11-06 10:25:20 [app] [I] Rendered text template (0.0ms)
2015-11-06 10:25:20 [app] [I] Completed 200 OK in 4818ms (Views: 905.8ms | ActiveRecord: 598.0ms)
2015-11-06 10:25:20 [sql] [D] LookupKey Load (1.3ms) SELECT "lookup_keys".* FROM "lookup_keys" WHERE "lookup_keys"."puppetclass_id" IN (NULL) ORDER BY lookup_keys.key
2015-11-06 10:25:20 [sql] [D] CACHE (0.1ms) SELECT "config_groups".id FROM "config_groups" INNER JOIN "host_config_groups" ON "config_groups"."id" = "host_config_groups"."config_group_id" WHERE "host_config_groups"."host_id" = 5 AND "host_config_groups"."host_type" = 'Host::Base' ORDER BY config_groups.name
2015-11-06 10:25:20 [sql] [D] CACHE (0.0ms) SELECT puppetclass_id FROM "config_group_classes" WHERE "config_group_classes"."config_group_id" IN (NULL)
2015-11-06 10:25:20 [sql] [D] CACHE (0.0ms) SELECT puppetclass_id FROM "hostgroup_classes" WHERE "hostgroup_classes"."hostgroup_id" IS NULL
2015-11-06 10:25:20 [sql] [D] CACHE (0.0ms) SELECT puppetclass_id FROM "host_classes" WHERE "host_classes"."host_id" = 5
2015-11-06 10:25:20 [sql] [D] CACHE (0.0ms) SELECT DISTINCT puppetclasses.id FROM "puppetclasses" INNER JOIN "environment_classes" ON "puppetclasses"."id" = "environment_classes"."puppetclass_id" WHERE "environment_classes"."environment_id" = 4 AND "puppetclasses"."id" IN (NULL)
2015-11-06 10:25:20 [sql] [D] SQL (11.6ms) SELECT "lookup_keys"."id" AS t0_r0, "lookup_keys"."key" AS t0_r1, "lookup_keys"."created_at" AS t0_r2, "lookup_keys"."updated_at" AS t0_r3, "lookup_keys"."puppetclass_id" AS t0_r4, "lookup_keys"."default_value" AS t0_r5, "lookup_keys"."path" AS t0_r6, "lookup_keys"."description" AS t0_r7, "lookup_keys"."validator_type" AS t0_r8, "lookup_keys"."validator_rule" AS t0_r9, "lookup_keys"."is_param" AS t0_r10, "lookup_keys"."key_type" AS t0_r11, "lookup_keys"."override" AS t0_r12, "lookup_keys"."required" AS t0_r13, "lookup_keys"."lookup_values_count" AS t0_r14, "lookup_keys"."merge_overrides" AS t0_r15, "lookup_keys"."avoid_duplicates" AS t0_r16, "lookup_keys"."use_puppet_default" AS t0_r17, "environment_classes"."id" AS t1_r0, "environment_classes"."puppetclass_id" AS t1_r1, "environment_classes"."environment_id" AS t1_r2, "environment_classes"."lookup_key_id" AS t1_r3 FROM "lookup_keys" INNER JOIN "environment_classes" ON "environment_classes"."lookup_key_id" = "lookup_keys"."id" WHERE "lookup_keys"."override" = 't' AND "environment_classes"."puppetclass_id" IN (NULL) AND "environment_classes"."environment_id" = 4 ORDER BY lookup_keys.key
2015-11-06 10:25:20 [sql] [D] CACHE (0.0ms) SELECT "config_groups".id FROM "config_groups" INNER JOIN "host_config_groups" ON "config_groups"."id" = "host_config_groups"."config_group_id" WHERE "host_config_groups"."host_id" = 5 AND "host_config_groups"."host_type" = 'Host::Base' ORDER BY config_groups.name
2015-11-06 10:25:20 [sql] [D] CACHE (0.0ms) SELECT puppetclass_id FROM "config_group_classes" WHERE "config_group_classes"."config_group_id" IN (NULL)
2015-11-06 10:25:20 [sql] [D] CACHE (0.0ms) SELECT puppetclass_id FROM "hostgroup_classes" WHERE "hostgroup_classes"."hostgroup_id" IS NULL
2015-11-06 10:25:20 [sql] [D] CACHE (0.1ms) SELECT puppetclass_id FROM "host_classes" WHERE "host_classes"."host_id" = 5
2015-11-06 10:25:20 [sql] [D] Puppetclass Load (1.6ms) SELECT DISTINCT "puppetclasses".* FROM "puppetclasses" INNER JOIN "environment_classes" ON "puppetclasses"."id" = "environment_classes"."puppetclass_id" WHERE "environment_classes"."environment_id" = 4 AND "puppetclasses"."id" IN (NULL) ORDER BY puppetclasses.name
2015-11-06 10:25:20 [sql] [D] Host::Managed Load (11.4ms) SELECT "hosts".* FROM "hosts" WHERE "hosts"."type" IN ('Host::Managed') AND "hosts"."id" = 5 LIMIT 1
2015-11-06 10:25:20 [sql] [D] (14.8ms) SELECT MAX("audits"."version") AS max_id FROM "audits" WHERE "audits"."auditable_id" = 5 AND "audits"."auditable_type" = 'Host'
2015-11-06 10:25:20 [sql] [D] SQL (1.8ms) INSERT INTO "audits" ("action", "associated_id", "associated_name", "associated_type", "auditable_id", "auditable_name", "auditable_type", "audited_changes", "comment", "created_at", "remote_address", "request_uuid", "user_id", "user_type", "username", "version") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16) RETURNING "id" [["action", "destroy"], ["associated_id", nil], ["associated_name", nil], ["associated_type", nil], ["auditable_id", 5], ["auditable_name", "agent01.example.com"], ["auditable_type", "Host"], ["audited_changes", "---\nname: agent01.example.com\nroot_pass: \narchitecture_id: 1\noperatingsystem_id: 1\nenvironment_id: 4\nptable_id: \nmedium_id: \nbuild: false\ncomment: \ndisk: \ninstalled_at: \nmodel_id: 1\nhostgroup_id: \nowner_id: \nowner_type: \nenabled: true\npuppet_ca_proxy_id: 1\nmanaged: false\nuse_image: \nimage_file: \nuuid: \ncompute_resource_id: \npuppet_proxy_id: 1\ncertname: agent01.example.com\nimage_id: \norganization_id: \nlocation_id: \notp: \nrealm_id: \ncompute_profile_id: \nprovision_method: \ngrub_pass: ''\ndiscovery_rule_id: \n"], ["comment", nil], ["created_at", Fri, 06 Nov 2015 09:25:20 UTC +00:00], ["remote_address", "192.168.35.1"], ["request_uuid", nil], ["user_id", 4], ["user_type", nil], ["username", "Kamjar gerami"], ["version", 3]]
2015-11-06 10:25:20 [sql] [D] SQL (14.6ms) DELETE FROM "hosts" WHERE "hosts"."type" IN ('Host::Managed') AND "hosts"."id" = $1 [["id", 5]]
2015-11-06 10:25:20 [sql] [D] (12.7ms) COMMIT
2015-11-06 10:25:20 [app] [I] Redirected to https://theforeman.example.com/hosts
Updated by Dominic Cleal over 8 years ago
- Status changed from New to Resolved
Thanks for testing Kamjar, I'm closing the ticket. I also can't see anything in that area of code that would be linked to authorisation - it's possible that #8316 changed the behaviour.
Actions