Started GET "/hosts" for 192.168.88.1 at 2013-06-24 20:17:39 -0700
Processing by HostsController#index as HTML
  User Load (0.5ms)  SELECT "users".* FROM "users" WHERE "users"."id" = $1 LIMIT 1  [["id", 1]]
Setting current user thread-local variable to admin
  Host::Managed Load (0.6ms)  SELECT "hosts".* FROM "hosts" WHERE "hosts"."type" IN ('Host::Managed') LIMIT 1
   (0.3ms)  SELECT COUNT(*) FROM "user_facts" WHERE "user_facts"."user_id" = 1
  Host::Managed Load (0.5ms)  SELECT "hosts".* FROM "hosts" WHERE "hosts"."type" IN ('Host::Managed') ORDER BY "hosts"."name" ASC NULLS FIRST LIMIT 20 OFFSET 0
  Operatingsystem Load (0.4ms)  SELECT "operatingsystems".* FROM "operatingsystems" WHERE "operatingsystems"."id" IN (1) ORDER BY LOWER(operatingsystems.name)
  Environment Load (0.3ms)  SELECT "environments".* FROM "environments" WHERE "environments"."id" IN (1) ORDER BY environments.name
  Model Load (0.3ms)  SELECT "models".* FROM "models" WHERE "models"."id" IN (1) ORDER BY LOWER(models.name)
   (0.3ms)  SELECT MAX("reports"."id") AS maximum_id, host_id AS host_id FROM "reports" WHERE "reports"."host_id" IN (1) GROUP BY host_id
  Rendered hosts/_list.html.erb (8.7ms)
  Rendered hosts/index.html.erb within layouts/application (11.9ms)
  Rendered home/_user_dropdown.html.erb (1.1ms)
Read fragment views/tabs_and_title_records-1 (0.1ms)
  Rendered home/_topbar.html.erb (1.2ms)
  Bookmark Load (0.5ms)  SELECT "bookmarks".* FROM "bookmarks" WHERE (((bookmarks.public = 't') OR (bookmarks.owner_id = 1 AND bookmarks.owner_type = 'User'))) AND (controller = 'hosts') ORDER BY name
  Rendered common/_searchbar.erb (4.0ms)
Completed 200 OK in 35ms (Views: 21.2ms | ActiveRecord: 3.8ms)


Started GET "/hosts/new" for 192.168.88.1 at 2013-06-24 20:17:42 -0700
Processing by HostsController#new as HTML
  User Load (0.4ms)  SELECT "users".* FROM "users" WHERE "users"."id" = $1 LIMIT 1  [["id", 1]]
Setting current user thread-local variable to admin
  Rendered hosts/_progress.erb (0.5ms)
Setting current organization thread-local variable to none
Setting current location thread-local variable to none
   (0.6ms)  SELECT COUNT(*) 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" = 'Puppet'
  ComputeResource Load (0.4ms)  SELECT "compute_resources".* FROM "compute_resources" ORDER BY type, name
   (0.6ms)  SELECT COUNT(*) FROM "hostgroups" INNER JOIN "user_hostgroups" ON "hostgroups"."id" = "user_hostgroups"."hostgroup_id" WHERE "user_hostgroups"."user_id" = 1 AND (1=1)
  Hostgroup Load (0.3ms)  SELECT "hostgroups".* FROM "hostgroups" WHERE (1=1)
  Environment Load (0.3ms)  SELECT "environments".* FROM "environments" ORDER BY environments.name
   (0.5ms)  SELECT COUNT(*) 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" = 'Puppet CA'
  SmartProxy Load (0.4ms)  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" = 'Puppet CA' ORDER BY smart_proxies.name
  CACHE (0.0ms)  SELECT COUNT(*) 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" = 'Puppet'
  SmartProxy Load (0.4ms)  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" = 'Puppet' ORDER BY smart_proxies.name
  Domain Load (0.4ms)  SELECT "domains".* FROM "domains" INNER JOIN "user_domains" ON "domains"."id" = "user_domains"."domain_id" WHERE "user_domains"."user_id" = 1 ORDER BY domains.name
  Domain Load (0.3ms)  SELECT "domains".* FROM "domains" ORDER BY domains.name
  Rendered common/_domain.html.erb (2.1ms)
  CACHE (0.0ms)  SELECT "domains".* FROM "domains" ORDER BY domains.name
  CACHE (0.0ms)  SELECT "domains".* FROM "domains" ORDER BY domains.name
  CACHE (0.0ms)  SELECT "domains".* FROM "domains" ORDER BY domains.name
  Rendered hosts/_interfaces.html.erb (8.0ms)
  Architecture Load (0.4ms)  SELECT "architectures".* FROM "architectures" 
  Rendered common/os_selection/_architecture.html.erb (2.2ms)
  Rendered common/os_selection/_operatingsystem.html.erb (2.8ms)
  Rendered hosts/_operating_system.html.erb (12.5ms)
  Rendered hosts/_unattended.html.erb (47.3ms)
   (0.5ms)  SELECT COUNT(*) AS count_all, puppetclass_id AS puppetclass_id FROM "lookup_keys" WHERE "lookup_keys"."puppetclass_id" IN (NULL) GROUP BY puppetclass_id
   (0.4ms)  SELECT COUNT(*) AS count_all, environment_classes.puppetclass_id AS environment_classes_puppetclass_id FROM "lookup_keys" INNER JOIN "environment_classes" ON "environment_classes"."lookup_key_id" = "lookup_keys"."id" WHERE "environment_classes"."puppetclass_id" IN (NULL) GROUP BY environment_classes.puppetclass_id
  Rendered puppetclasses/_class_parameters.html.erb (0.0ms)
  Rendered puppetclasses/_classes_parameters.html.erb (4.5ms)
  CommonParameter Load (0.3ms)  SELECT "parameters".* FROM "parameters" WHERE "parameters"."type" IN ('CommonParameter')
  Rendered common_parameters/_inherited_parameters.erb (0.7ms)
  Rendered common_parameters/_puppetclass_parameter.erb (2.7ms)
  Rendered common_parameters/_puppetclasses_parameters.erb (12.9ms)
  Rendered common_parameters/_parameter.erb (1.8ms)
  Rendered common_parameters/_parameters.erb (12.1ms)
  User Load (0.5ms)  SELECT "users".* FROM "users" ORDER BY firstname
  Usergroup Load (0.7ms)  SELECT "usergroups".* FROM "usergroups" ORDER BY LOWER(usergroups.name)
  Model Load (0.3ms)  SELECT "models".* FROM "models" ORDER BY LOWER(models.name)
Setting current location thread-local variable to none
Setting current organization thread-local variable to none
  Rendered hosts/_form.html.erb (201.6ms)
  Rendered hosts/new.html.erb within layouts/application (202.8ms)
  Rendered home/_user_dropdown.html.erb (1.1ms)
Read fragment views/tabs_and_title_records-1 (0.1ms)
  Rendered home/_topbar.html.erb (1.2ms)
Completed 200 OK in 213ms (Views: 195.1ms | ActiveRecord: 13.3ms)


Started POST "/hosts/compute_resource_selected" for 192.168.88.1 at 2013-06-24 20:17:54 -0700
Processing by HostsController#compute_resource_selected as */*
  Parameters: {"utf8"=>"✓", "authenticity_token"=>"DgB7Th4tkqM2dDe1JwyOFm5+y32sSS/tL/fmC0Ysbkg=", "host"=>{"name"=>"test17", "compute_resource_id"=>"1", "hostgroup_id"=>"", "environment_id"=>"", "puppet_ca_proxy_id"=>"", "puppet_proxy_id"=>"", "managed"=>"true", "progress_report_id"=>"[FILTERED]", "type"=>"Host::Managed", "mac"=>"", "domain_id"=>"", "ip"=>"", "interfaces_attributes"=>{"new_interfaces"=>{"_destroy"=>"false", "type"=>"Nic::Managed", "mac"=>"", "name"=>"", "domain_id"=>"", "ip"=>"", "provider"=>"IPMI", "updated_at"=>"2013-06-24 20:17:42 -0700"}}, "architecture_id"=>"", "provision_method"=>"build", "build"=>"1", "disk"=>"", "root_pass"=>"[FILTERED]", "is_owned_by"=>"", "enabled"=>"1", "model_id"=>"", "comment"=>"", "overwrite"=>"false"}}
  User Load (0.5ms)  SELECT "users".* FROM "users" WHERE "users"."id" = $1 LIMIT 1  [["id", 1]]
Setting current user thread-local variable to admin
  Organization Load (0.5ms)  SELECT "taxonomies".* FROM "taxonomies" WHERE "taxonomies"."type" IN ('Organization') AND "taxonomies"."id" IS NULL LIMIT 1
  Location Load (0.3ms)  SELECT "taxonomies".* FROM "taxonomies" WHERE "taxonomies"."type" IN ('Location') AND "taxonomies"."id" IS NULL LIMIT 1
Setting current organization thread-local variable to none
Setting current location thread-local variable to none
  ComputeResource Load (0.4ms)  SELECT "compute_resources".* FROM "compute_resources" WHERE "compute_resources"."id" = 1 ORDER BY compute_resources.name LIMIT 1
  ComputeResource Exists (0.6ms)  SELECT 1 AS one FROM "compute_resources" WHERE ("compute_resources"."name" = 'vmware' AND "compute_resources"."id" != 1) LIMIT 1
  Rendered compute_resources_vms/form/vmware/_network.html.erb (46.8ms)
  Rendered compute_resources_vms/form/vmware/_network.html.erb (127.8ms)
  Rendered compute_resources_vms/form/vmware/_volume.html.erb (38.2ms)
  Rendered compute_resources_vms/form/vmware/_volume.html.erb (34.5ms)
  Rendered compute_resources_vms/form/_vmware.html.erb (495.4ms)
  Rendered hosts/_compute.html.erb (575.0ms)
Setting current location thread-local variable to none
Setting current organization thread-local variable to none
Completed 200 OK in 587ms (Views: 578.1ms | ActiveRecord: 3.1ms)


Started POST "/hosts/domain_selected" for 192.168.88.1 at 2013-06-24 20:18:06 -0700
Processing by HostsController#domain_selected as */*
  Parameters: {"domain_id"=>"1"}
  User Load (0.4ms)  SELECT "users".* FROM "users" WHERE "users"."id" = $1 LIMIT 1  [["id", 1]]
Setting current user thread-local variable to admin
Setting current organization thread-local variable to none
Setting current location thread-local variable to none
  Domain Load (0.8ms)  SELECT "domains".* FROM "domains" WHERE "domains"."id" = $1 ORDER BY domains.name LIMIT 1  [["id", "1"]]
   (0.5ms)  SELECT COUNT(*) FROM "subnets" INNER JOIN "subnet_domains" ON "subnets"."id" = "subnet_domains"."subnet_id" WHERE "subnet_domains"."domain_id" = 1
  CACHE (0.0ms)  SELECT COUNT(*) FROM "subnets" INNER JOIN "subnet_domains" ON "subnets"."id" = "subnet_domains"."subnet_id" WHERE "subnet_domains"."domain_id" = 1
  Subnet Load (0.5ms)  SELECT "subnets".* FROM "subnets" INNER JOIN "subnet_domains" ON "subnets"."id" = "subnet_domains"."subnet_id" WHERE "subnet_domains"."domain_id" = 1 ORDER BY vlanid
  Rendered common/_domain.html.erb (5.8ms)
Setting current location thread-local variable to none
Setting current organization thread-local variable to none
Completed 200 OK in 96ms (Views: 5.3ms | ActiveRecord: 2.2ms)


Started POST "/hosts/current_parameters" for 192.168.88.1 at 2013-06-24 20:18:06 -0700
Processing by HostsController#current_parameters as */*
  Parameters: {"utf8"=>"✓", "authenticity_token"=>"DgB7Th4tkqM2dDe1JwyOFm5+y32sSS/tL/fmC0Ysbkg=", "host"=>{"name"=>"test17", "compute_resource_id"=>"1", "hostgroup_id"=>"", "environment_id"=>"1", "puppet_ca_proxy_id"=>"1", "puppet_proxy_id"=>"1", "managed"=>"true", "progress_report_id"=>"[FILTERED]", "type"=>"Host::Managed", "compute_attributes"=>{"cpus"=>"1", "memory_mb"=>"768", "cluster"=>"thuis", "path"=>"/Datacenters/CJIB/vm", "interfaces_attributes"=>{"new_interfaces"=>{"network"=>"VM Network", "_delete"=>""}, "0"=>{"network"=>"VM Network", "_delete"=>""}}, "volumes_attributes"=>{"new_volumes"=>{"datastore"=>"datastore1", "name"=>"Hard disk", "size_gb"=>"10", "_delete"=>""}, "0"=>{"datastore"=>"datastore1", "name"=>"Hard disk", "size_gb"=>"10", "_delete"=>""}}, "start"=>"1"}, "mac"=>"", "domain_id"=>"1", "subnet_id"=>"", "ip"=>"", "interfaces_attributes"=>{"new_interfaces"=>{"_destroy"=>"false", "type"=>"Nic::Managed", "mac"=>"", "name"=>"", "domain_id"=>"", "ip"=>"", "provider"=>"IPMI", "updated_at"=>"2013-06-24 20:17:42 -0700"}}, "architecture_id"=>"", "provision_method"=>"build", "build"=>"1", "disk"=>"", "root_pass"=>"[FILTERED]", "is_owned_by"=>"", "enabled"=>"1", "model_id"=>"", "comment"=>"", "overwrite"=>"false"}, "capabilities"=>"build", "host_id"=>"null"}
  User Load (0.4ms)  SELECT "users".* FROM "users" WHERE "users"."id" = $1 LIMIT 1  [["id", 1]]
Setting current user thread-local variable to admin
  Organization Load (0.4ms)  SELECT "taxonomies".* FROM "taxonomies" WHERE "taxonomies"."type" IN ('Organization') AND "taxonomies"."id" IS NULL LIMIT 1
  Location Load (0.3ms)  SELECT "taxonomies".* FROM "taxonomies" WHERE "taxonomies"."type" IN ('Location') AND "taxonomies"."id" IS NULL LIMIT 1
Setting current organization thread-local variable to none
Setting current location thread-local variable to none
  Host::Base Load (0.4ms)  SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = 0 LIMIT 1
  CommonParameter Load (0.4ms)  SELECT "parameters".* FROM "parameters" WHERE "parameters"."type" IN ('CommonParameter')
  Domain Load (0.3ms)  SELECT "domains".* FROM "domains" WHERE "domains"."id" = 1 ORDER BY domains.name LIMIT 1
  DomainParameter Load (0.3ms)  SELECT "parameters".* FROM "parameters" WHERE "parameters"."type" IN ('DomainParameter') AND "parameters"."reference_id" = 1
  Rendered common_parameters/_inherited_parameters.erb (0.8ms)
Setting current location thread-local variable to none
Setting current organization thread-local variable to none
Completed 200 OK in 16ms (Views: 4.2ms | ActiveRecord: 2.5ms)


Started POST "/subnets/freeip" for 192.168.88.1 at 2013-06-24 20:18:07 -0700
Processing by SubnetsController#freeip as */*
  Parameters: {"subnet_id"=>"1", "host_mac"=>""}
  User Load (0.4ms)  SELECT "users".* FROM "users" WHERE "users"."id" = $1 LIMIT 1  [["id", 1]]
Setting current user thread-local variable to admin
Setting current organization thread-local variable to none
Setting current location thread-local variable to none
  Subnet Load (0.6ms)  SELECT "subnets".* FROM "subnets" WHERE "subnets"."id" = $1 ORDER BY vlanid LIMIT 1  [["id", 1]]
  SmartProxy Load (0.3ms)  SELECT "smart_proxies".* FROM "smart_proxies" WHERE "smart_proxies"."id" = 1 ORDER BY smart_proxies.name LIMIT 1
Setting current location thread-local variable to none
Setting current organization thread-local variable to none
Completed 200 OK in 2314ms (Views: 1.0ms | ActiveRecord: 1.4ms)


Started POST "/hosts/architecture_selected" for 192.168.88.1 at 2013-06-24 20:18:13 -0700
Processing by HostsController#architecture_selected as */*
  Parameters: {"architecture_id"=>"1"}
  User Load (0.8ms)  SELECT "users".* FROM "users" WHERE "users"."id" = $1 LIMIT 1  [["id", 1]]
Setting current user thread-local variable to admin
Setting current organization thread-local variable to none
Setting current location thread-local variable to none
  Architecture Load (0.3ms)  SELECT "architectures".* FROM "architectures" WHERE "architectures"."id" = $1 LIMIT 1  [["id", "1"]]
  Operatingsystem Load (0.6ms)  SELECT "operatingsystems".* FROM "operatingsystems" INNER JOIN "architectures_operatingsystems" ON "operatingsystems"."id" = "architectures_operatingsystems"."operatingsystem_id" WHERE "architectures_operatingsystems"."architecture_id" = 1 ORDER BY LOWER(operatingsystems.name)
  Rendered common/os_selection/_architecture.html.erb (4.5ms)
Setting current location thread-local variable to none
Setting current organization thread-local variable to none
Completed 200 OK in 16ms (Views: 7.3ms | ActiveRecord: 1.6ms)


Started GET "/compute_resources/1/images?search=operatingsystem%3D1%20architecture%3D1" for 192.168.88.1 at 2013-06-24 20:18:14 -0700
Processing by ImagesController#index as JSON
  Parameters: {"search"=>"operatingsystem=1 architecture=1", "compute_resource_id"=>"1"}
  User Load (0.7ms)  SELECT "users".* FROM "users" WHERE "users"."id" = $1 LIMIT 1  [["id", 1]]
Setting current user thread-local variable to admin
  ComputeResource Load (0.6ms)  SELECT "compute_resources".* FROM "compute_resources" WHERE "compute_resources"."id" = $1 ORDER BY compute_resources.name LIMIT 1  [["id", "1"]]
  SQL (0.9ms)  SELECT "images"."id" AS t0_r0, "images"."operatingsystem_id" AS t0_r1, "images"."compute_resource_id" AS t0_r2, "images"."architecture_id" AS t0_r3, "images"."uuid" AS t0_r4, "images"."username" AS t0_r5, "images"."name" AS t0_r6, "images"."created_at" AS t0_r7, "images"."updated_at" AS t0_r8, "images"."iam_role" AS t0_r9, "operatingsystems"."id" AS t1_r0, "operatingsystems"."major" AS t1_r1, "operatingsystems"."name" AS t1_r2, "operatingsystems"."minor" AS t1_r3, "operatingsystems"."nameindicator" AS t1_r4, "operatingsystems"."created_at" AS t1_r5, "operatingsystems"."updated_at" AS t1_r6, "operatingsystems"."release_name" AS t1_r7, "operatingsystems"."type" AS t1_r8, "architectures"."id" AS t2_r0, "architectures"."name" AS t2_r1, "architectures"."created_at" AS t2_r2, "architectures"."updated_at" AS t2_r3 FROM "images" LEFT OUTER JOIN "operatingsystems" ON "operatingsystems"."id" = "images"."operatingsystem_id" LEFT OUTER JOIN "architectures" ON "architectures"."id" = "images"."architecture_id" WHERE "images"."compute_resource_id" = 1 AND ((("operatingsystems"."id" = '1') AND ("architectures"."id" = '1')))
Completed 200 OK in 18ms (Views: 3.2ms | ActiveRecord: 3.3ms)


Started POST "/hosts/os_selected" for 192.168.88.1 at 2013-06-24 20:18:14 -0700
Processing by HostsController#os_selected as */*
  Parameters: {"operatingsystem_id"=>"1"}
  User Load (0.4ms)  SELECT "users".* FROM "users" WHERE "users"."id" = $1 LIMIT 1  [["id", 1]]
Setting current user thread-local variable to admin
Setting current organization thread-local variable to none
Setting current location thread-local variable to none
  Operatingsystem Load (0.4ms)  SELECT "operatingsystems".* FROM "operatingsystems" WHERE "operatingsystems"."id" = $1 ORDER BY LOWER(operatingsystems.name) LIMIT 1  [["id", "1"]]
  Medium Load (0.6ms)  SELECT "media".* FROM "media" INNER JOIN "media_operatingsystems" ON "media"."id" = "media_operatingsystems"."medium_id" WHERE "media_operatingsystems"."operatingsystem_id" = 1 ORDER BY media.name
  Ptable Load (0.6ms)  SELECT "ptables".* FROM "ptables" INNER JOIN "operatingsystems_ptables" ON "ptables"."id" = "operatingsystems_ptables"."ptable_id" WHERE "operatingsystems_ptables"."operatingsystem_id" = 1 ORDER BY LOWER(ptables.name)
  Rendered common/os_selection/_operatingsystem.html.erb (7.8ms)
Setting current location thread-local variable to none
Setting current organization thread-local variable to none
Completed 200 OK in 18ms (Views: 10.4ms | ActiveRecord: 2.0ms)


Started POST "/hosts/current_parameters" for 192.168.88.1 at 2013-06-24 20:18:14 -0700
Processing by HostsController#current_parameters as */*
  Parameters: {"utf8"=>"✓", "authenticity_token"=>"DgB7Th4tkqM2dDe1JwyOFm5+y32sSS/tL/fmC0Ysbkg=", "host"=>{"name"=>"test17", "compute_resource_id"=>"1", "hostgroup_id"=>"", "environment_id"=>"1", "puppet_ca_proxy_id"=>"1", "puppet_proxy_id"=>"1", "managed"=>"true", "progress_report_id"=>"[FILTERED]", "type"=>"Host::Managed", "compute_attributes"=>{"cpus"=>"1", "memory_mb"=>"768", "cluster"=>"thuis", "path"=>"/Datacenters/CJIB/vm", "interfaces_attributes"=>{"new_interfaces"=>{"network"=>"VM Network", "_delete"=>""}, "0"=>{"network"=>"VM Network", "_delete"=>""}}, "volumes_attributes"=>{"new_volumes"=>{"datastore"=>"datastore1", "name"=>"Hard disk", "size_gb"=>"10", "_delete"=>""}, "0"=>{"datastore"=>"datastore1", "name"=>"Hard disk", "size_gb"=>"10", "_delete"=>""}}, "start"=>"1"}, "mac"=>"", "domain_id"=>"1", "subnet_id"=>"1", "ip"=>"192.168.88.1", "interfaces_attributes"=>{"new_interfaces"=>{"_destroy"=>"false", "type"=>"Nic::Managed", "mac"=>"", "name"=>"", "domain_id"=>"", "ip"=>"", "provider"=>"IPMI", "updated_at"=>"2013-06-24 20:17:42 -0700"}}, "architecture_id"=>"1", "operatingsystem_id"=>"1", "provision_method"=>"build", "build"=>"1", "medium_id"=>"1", "ptable_id"=>"1", "disk"=>"", "root_pass"=>"[FILTERED]", "is_owned_by"=>"", "enabled"=>"1", "model_id"=>"", "comment"=>"", "overwrite"=>"false"}, "capabilities"=>"build", "host_id"=>"null"}
  User Load (0.4ms)  SELECT "users".* FROM "users" WHERE "users"."id" = $1 LIMIT 1  [["id", 1]]
Setting current user thread-local variable to admin
  Organization Load (0.3ms)  SELECT "taxonomies".* FROM "taxonomies" WHERE "taxonomies"."type" IN ('Organization') AND "taxonomies"."id" IS NULL LIMIT 1
  Location Load (0.2ms)  SELECT "taxonomies".* FROM "taxonomies" WHERE "taxonomies"."type" IN ('Location') AND "taxonomies"."id" IS NULL LIMIT 1
Setting current organization thread-local variable to none
Setting current location thread-local variable to none
  Host::Base Load (0.4ms)  SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = 0 LIMIT 1
  CommonParameter Load (0.4ms)  SELECT "parameters".* FROM "parameters" WHERE "parameters"."type" IN ('CommonParameter')
  Domain Load (0.3ms)  SELECT "domains".* FROM "domains" WHERE "domains"."id" = 1 ORDER BY domains.name LIMIT 1
  DomainParameter Load (0.3ms)  SELECT "parameters".* FROM "parameters" WHERE "parameters"."type" IN ('DomainParameter') AND "parameters"."reference_id" = 1
  Operatingsystem Load (0.3ms)  SELECT "operatingsystems".* FROM "operatingsystems" WHERE "operatingsystems"."id" = 1 ORDER BY LOWER(operatingsystems.name) LIMIT 1
  OsParameter Load (0.3ms)  SELECT "parameters".* FROM "parameters" WHERE "parameters"."type" IN ('OsParameter') AND "parameters"."reference_id" = 1
  Rendered common_parameters/_inherited_parameters.erb (0.1ms)
Setting current location thread-local variable to none
Setting current organization thread-local variable to none
Completed 200 OK in 12ms (Views: 0.7ms | ActiveRecord: 3.0ms)
Connecting to database specified by database.yml
  Setting Load (1.0ms)  SELECT "settings".* FROM "settings" ORDER BY name LIMIT 1
   (0.3ms)  BEGIN
  Setting Load (0.7ms)  SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'administrator' ORDER BY name LIMIT 1
removing administrator from cache
  Setting Load (0.3ms)  SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'foreman_url' ORDER BY name LIMIT 1
removing foreman_url from cache
  Setting Load (0.2ms)  SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'email_reply_address' ORDER BY name LIMIT 1
removing email_reply_address from cache
  Setting Load (0.2ms)  SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'entries_per_page' ORDER BY name LIMIT 1
removing entries_per_page from cache
  Setting Load (0.2ms)  SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'authorize_login_delegation' ORDER BY name LIMIT 1
removing authorize_login_delegation from cache
  Setting Load (0.2ms)  SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'authorize_login_delegation_api' ORDER BY name LIMIT 1
removing authorize_login_delegation_api from cache
  Setting Load (0.2ms)  SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'idle_timeout' ORDER BY name LIMIT 1
removing idle_timeout from cache
  Setting Load (0.2ms)  SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'max_trend' ORDER BY name LIMIT 1
removing max_trend from cache
  Setting Load (0.2ms)  SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'use_gravatar' ORDER BY name LIMIT 1
removing use_gravatar from cache
   (0.1ms)  COMMIT
  Setting Load (0.4ms)  SELECT "settings".* FROM "settings" ORDER BY name LIMIT 1
Using puppetmaster command: /usr/bin/puppet master --config /etc/puppet/puppet.conf --vardir /var/lib/puppet


Started POST "/hosts" for 192.168.88.1 at 2013-06-24 20:18:20 -0700
Processing by HostsController#create as */*
  Parameters: {"utf8"=>"✓", "authenticity_token"=>"DgB7Th4tkqM2dDe1JwyOFm5+y32sSS/tL/fmC0Ysbkg=", "host"=>{"name"=>"test17", "compute_resource_id"=>"1", "hostgroup_id"=>"", "environment_id"=>"1", "puppet_ca_proxy_id"=>"1", "puppet_proxy_id"=>"1", "managed"=>"true", "progress_report_id"=>"[FILTERED]", "type"=>"Host::Managed", "compute_attributes"=>{"cpus"=>"1", "memory_mb"=>"768", "cluster"=>"thuis", "path"=>"/Datacenters/CJIB/vm", "interfaces_attributes"=>{"new_interfaces"=>{"network"=>"VM Network", "_delete"=>""}, "0"=>{"network"=>"VM Network", "_delete"=>""}}, "volumes_attributes"=>{"new_volumes"=>{"datastore"=>"datastore1", "name"=>"Hard disk", "size_gb"=>"10", "_delete"=>""}, "0"=>{"datastore"=>"datastore1", "name"=>"Hard disk", "size_gb"=>"10", "_delete"=>""}}, "start"=>"1"}, "mac"=>"", "domain_id"=>"1", "subnet_id"=>"1", "ip"=>"192.168.88.1", "interfaces_attributes"=>{"new_interfaces"=>{"_destroy"=>"false", "type"=>"Nic::Managed", "mac"=>"", "name"=>"", "domain_id"=>"", "ip"=>"", "provider"=>"IPMI", "updated_at"=>"2013-06-24 20:17:42 -0700"}}, "architecture_id"=>"1", "operatingsystem_id"=>"1", "provision_method"=>"build", "build"=>"1", "medium_id"=>"1", "ptable_id"=>"1", "disk"=>"", "root_pass"=>"[FILTERED]", "is_owned_by"=>"", "enabled"=>"1", "model_id"=>"", "comment"=>"", "overwrite"=>"false"}, "capabilities"=>"build"}
  User Load (0.4ms)  SELECT "users".* FROM "users" WHERE "users"."id" = $1 LIMIT 1  [["id", 1]]
Setting current user thread-local variable to admin
  Setting Load (0.4ms)  SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'authorize_login_delegation' ORDER BY name LIMIT 1
  Setting Load (0.5ms)  SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'idle_timeout' ORDER BY name LIMIT 1
   (0.3ms)  BEGIN
  Subnet Load (0.6ms)  SELECT "subnets".* FROM "subnets" WHERE "subnets"."id" = 1 ORDER BY vlanid LIMIT 1
  Domain Load (0.4ms)  SELECT "domains".* FROM "domains" WHERE "domains"."id" = 1 ORDER BY domains.name LIMIT 1
  Setting Load (0.3ms)  SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'use_uuid_for_certificates' ORDER BY name LIMIT 1
  Host::Base Exists (0.5ms)  SELECT 1 AS one FROM "hosts" WHERE "hosts"."name" = 'test17.localdomain' LIMIT 1
  SmartProxy Load (0.3ms)  SELECT "smart_proxies".* FROM "smart_proxies" WHERE "smart_proxies"."id" = 1 ORDER BY smart_proxies.name LIMIT 1
  ComputeResource Load (0.3ms)  SELECT "compute_resources".* FROM "compute_resources" WHERE "compute_resources"."id" = 1 ORDER BY compute_resources.name LIMIT 1
  Host::Managed Exists (0.3ms)  SELECT 1 AS one FROM "hosts" WHERE "hosts"."ip" = '192.168.88.1' LIMIT 1
Scheduling new DHCP reservations for test17.localdomain
  CACHE (0.0ms)  SELECT "smart_proxies".* FROM "smart_proxies" WHERE "smart_proxies"."id" = 1 ORDER BY smart_proxies.name LIMIT 1
Scheduling new DNS entries
  CACHE (0.0ms)  SELECT "smart_proxies".* FROM "smart_proxies" WHERE "smart_proxies"."id" = 1 ORDER BY smart_proxies.name LIMIT 1
  Operatingsystem Load (0.5ms)  SELECT "operatingsystems".* FROM "operatingsystems" WHERE "operatingsystems"."id" = 1 ORDER BY LOWER(operatingsystems.name) LIMIT 1
  ConfigTemplate Load (1.8ms)  SELECT "config_templates".* FROM "config_templates" INNER JOIN "config_templates_operatingsystems" ON "config_templates_operatingsystems"."config_template_id" = "config_templates"."id" INNER JOIN "operatingsystems" ON "operatingsystems"."id" = "config_templates_operatingsystems"."operatingsystem_id" INNER JOIN "template_kinds" ON "template_kinds"."id" = "config_templates"."template_kind_id" INNER JOIN "template_combinations" ON "template_combinations"."config_template_id" = "config_templates"."id" INNER JOIN "environments" ON "environments"."id" = "template_combinations"."environment_id" WHERE "operatingsystems"."id" = 1 AND "template_kinds"."name" = 'PXELinux' AND "environments"."id" = 1 ORDER BY config_templates.name LIMIT 1
  ConfigTemplate Load (1.2ms)  SELECT "config_templates".* FROM "config_templates" INNER JOIN "config_templates_operatingsystems" ON "config_templates_operatingsystems"."config_template_id" = "config_templates"."id" INNER JOIN "operatingsystems" ON "operatingsystems"."id" = "config_templates_operatingsystems"."operatingsystem_id" INNER JOIN "template_kinds" ON "template_kinds"."id" = "config_templates"."template_kind_id" INNER JOIN "os_default_templates" ON "os_default_templates"."config_template_id" = "config_templates"."id" WHERE "operatingsystems"."id" = 1 AND "template_kinds"."name" = 'PXELinux' AND "os_default_templates"."operatingsystem_id" = 1 ORDER BY config_templates.name LIMIT 1
  CACHE (0.0ms)  SELECT "smart_proxies".* FROM "smart_proxies" WHERE "smart_proxies"."id" = 1 ORDER BY smart_proxies.name LIMIT 1
  Setting Load (0.5ms)  SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'manage_puppetca' ORDER BY name LIMIT 1
  Ptable Load (0.5ms)  SELECT "ptables".* FROM "ptables" WHERE "ptables"."id" = 1 ORDER BY LOWER(ptables.name) LIMIT 1
  Ptable Exists (0.4ms)  SELECT 1 AS one FROM "ptables" INNER JOIN "operatingsystems_ptables" ON "ptables"."id" = "operatingsystems_ptables"."ptable_id" WHERE "operatingsystems_ptables"."operatingsystem_id" = 1 AND "ptables"."id" = 1 ORDER BY LOWER(ptables.name) LIMIT 1
  Medium Load (0.4ms)  SELECT "media".* FROM "media" WHERE "media"."id" = 1 ORDER BY media.name LIMIT 1
  Medium Exists (0.3ms)  SELECT 1 AS one FROM "media" INNER JOIN "media_operatingsystems" ON "media"."id" = "media_operatingsystems"."medium_id" WHERE "media_operatingsystems"."operatingsystem_id" = 1 AND "media"."id" = 1 ORDER BY media.name LIMIT 1
  Architecture Load (0.2ms)  SELECT "architectures".* FROM "architectures" WHERE "architectures"."id" = 1 LIMIT 1
  Architecture Exists (0.4ms)  SELECT 1 AS one FROM "architectures" INNER JOIN "architectures_operatingsystems" ON "architectures"."id" = "architectures_operatingsystems"."architecture_id" WHERE "architectures_operatingsystems"."operatingsystem_id" = 1 AND "architectures"."id" = 1 LIMIT 1
  Environment Load (0.3ms)  SELECT "environments".* FROM "environments" WHERE "environments"."id" = 1 ORDER BY environments.name LIMIT 1
  Puppetclass Load (0.5ms)  SELECT DISTINCT puppetclasses.id,puppetclasses.name FROM "puppetclasses" INNER JOIN "host_classes" ON "puppetclasses"."id" = "host_classes"."puppetclass_id" WHERE "host_classes"."host_id" IS NULL ORDER BY puppetclasses.name
  Setting Load (0.3ms)  SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'token_duration' ORDER BY name LIMIT 1
Adding Compute instance for test17.localdomain
  ComputeResource Exists (0.4ms)  SELECT 1 AS one FROM "compute_resources" WHERE ("compute_resources"."name" = 'vmware' AND "compute_resources"."id" != 1) LIMIT 1
   (0.2ms)  BEGIN
  Setting Load (0.4ms)  SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'puppet_interval' ORDER BY name LIMIT 1
removing puppet_interval from cache
  Setting Load (0.5ms)  SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'default_puppet_environment' ORDER BY name LIMIT 1
removing default_puppet_environment from cache
  Setting Load (0.4ms)  SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'modulepath' ORDER BY name LIMIT 1
removing modulepath from cache
  Setting Load (0.3ms)  SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'document_root' ORDER BY name LIMIT 1
removing document_root from cache
  Setting Load (0.3ms)  SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'puppetrun' ORDER BY name LIMIT 1
removing puppetrun from cache
  Setting Load (0.4ms)  SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'puppet_server' ORDER BY name LIMIT 1
removing puppet_server from cache
  Setting Load (0.3ms)  SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'failed_report_email_notification' ORDER BY name LIMIT 1
removing failed_report_email_notification from cache
  Setting Load (0.3ms)  SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'using_storeconfigs' ORDER BY name LIMIT 1
removing using_storeconfigs from cache
  Setting Load (0.5ms)  SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'Default_variables_Lookup_Path' ORDER BY name LIMIT 1
removing Default_variables_Lookup_Path from cache
  Setting Load (0.3ms)  SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'Enable_Smart_Variables_in_ENC' ORDER BY name LIMIT 1
removing Enable_Smart_Variables_in_ENC from cache
  Setting Load (0.3ms)  SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'Parametrized_Classes_in_ENC' ORDER BY name LIMIT 1
removing Parametrized_Classes_in_ENC from cache
  Setting Load (0.4ms)  SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'enc_environment' ORDER BY name LIMIT 1
removing enc_environment from cache
  Setting Load (0.4ms)  SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'use_uuid_for_certificates' ORDER BY name LIMIT 1
removing use_uuid_for_certificates from cache
  Setting Load (0.4ms)  SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'update_environment_from_facts' ORDER BY name LIMIT 1
removing update_environment_from_facts from cache
  Setting Load (0.5ms)  SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'remove_classes_not_in_environment' ORDER BY name LIMIT 1
removing remove_classes_not_in_environment from cache
  Setting Load (0.4ms)  SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'host_group_matchers_inheritance' ORDER BY name LIMIT 1
removing host_group_matchers_inheritance from cache
   (0.2ms)  COMMIT
  Setting Load (0.4ms)  SELECT "settings".* FROM "settings" ORDER BY name LIMIT 1
Using puppetmaster command: /usr/bin/puppet master --config /etc/puppet/puppet.conf --vardir /var/lib/puppet
   (0.2ms)  BEGIN
  Setting Load (0.4ms)  SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'root_pass' ORDER BY name LIMIT 1
removing root_pass from cache
  Setting Load (0.5ms)  SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'safemode_render' ORDER BY name LIMIT 1
removing safemode_render from cache
  Setting Load (0.3ms)  SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'ssl_certificate' ORDER BY name LIMIT 1
removing ssl_certificate from cache
  Setting Load (0.3ms)  SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'ssl_ca_file' ORDER BY name LIMIT 1
removing ssl_ca_file from cache
  Setting Load (0.3ms)  SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'ssl_priv_key' ORDER BY name LIMIT 1
removing ssl_priv_key from cache
  Setting Load (0.2ms)  SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'manage_puppetca' ORDER BY name LIMIT 1
removing manage_puppetca from cache
  Setting Load (0.2ms)  SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'ignore_puppet_facts_for_provisioning' ORDER BY name LIMIT 1
removing ignore_puppet_facts_for_provisioning from cache
  Setting Load (0.3ms)  SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'query_local_nameservers' ORDER BY name LIMIT 1
removing query_local_nameservers from cache
  Setting Load (0.2ms)  SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'remote_addr' ORDER BY name LIMIT 1
removing remote_addr from cache
  Setting Load (0.3ms)  SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'token_duration' ORDER BY name LIMIT 1
removing token_duration from cache
  Setting Load (0.3ms)  SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'libvirt_default_console_address' ORDER BY name LIMIT 1
removing libvirt_default_console_address from cache
   (0.1ms)  COMMIT
  Setting Load (0.3ms)  SELECT "settings".* FROM "settings" ORDER BY name LIMIT 1
   (0.1ms)  BEGIN
  Setting Load (0.3ms)  SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'oauth_active' ORDER BY name LIMIT 1
removing oauth_active from cache
  Setting Load (0.6ms)  SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'oauth_consumer_key' ORDER BY name LIMIT 1
removing oauth_consumer_key from cache
  Setting Load (0.3ms)  SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'oauth_consumer_secret' ORDER BY name LIMIT 1
removing oauth_consumer_secret from cache
  Setting Load (0.3ms)  SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'oauth_map_users' ORDER BY name LIMIT 1
removing oauth_map_users from cache
  Setting Load (0.3ms)  SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'restrict_registered_puppetmasters' ORDER BY name LIMIT 1
removing restrict_registered_puppetmasters from cache
  Setting Load (0.3ms)  SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'require_ssl_puppetmasters' ORDER BY name LIMIT 1
removing require_ssl_puppetmasters from cache
  Setting Load (0.3ms)  SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'trusted_puppetmaster_hosts' ORDER BY name LIMIT 1
removing trusted_puppetmaster_hosts from cache
  Setting Load (0.3ms)  SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'ssl_client_dn_env' ORDER BY name LIMIT 1
removing ssl_client_dn_env from cache
  Setting Load (0.3ms)  SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'ssl_client_verify_env' ORDER BY name LIMIT 1
removing ssl_client_verify_env from cache
  Setting Load (0.3ms)  SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'signo_sso' ORDER BY name LIMIT 1
removing signo_sso from cache
  Setting Load (0.3ms)  SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'signo_url' ORDER BY name LIMIT 1
removing signo_url from cache
   (0.2ms)  COMMIT
  Setting Load (0.6ms)  SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'entries_per_page' ORDER BY name LIMIT 1
   (0.5ms)  SELECT COUNT(*) FROM "roles" 
   (0.2ms)  BEGIN
   (0.4ms)  SELECT COUNT(*) FROM "roles" WHERE "roles"."name" = 'Manager'
  Role Load (0.3ms)  SELECT "roles".* FROM "roles" WHERE "roles"."name" = 'Manager'
   (0.4ms)  SELECT COUNT(*) FROM "roles" WHERE "roles"."name" = 'Edit partition tables'
  Role Load (0.2ms)  SELECT "roles".* FROM "roles" WHERE "roles"."name" = 'Edit partition tables'
   (0.3ms)  SELECT COUNT(*) FROM "roles" WHERE "roles"."name" = 'View hosts'
  Role Load (0.3ms)  SELECT "roles".* FROM "roles" WHERE "roles"."name" = 'View hosts'
   (0.3ms)  SELECT COUNT(*) FROM "roles" WHERE "roles"."name" = 'Edit hosts'
  Role Load (0.3ms)  SELECT "roles".* FROM "roles" WHERE "roles"."name" = 'Edit hosts'
   (0.3ms)  SELECT COUNT(*) FROM "roles" WHERE "roles"."name" = 'Viewer'
  Role Load (0.3ms)  SELECT "roles".* FROM "roles" WHERE "roles"."name" = 'Viewer'
   (0.2ms)  SELECT COUNT(*) FROM "roles" WHERE "roles"."name" = 'Site manager'
  Role Load (0.2ms)  SELECT "roles".* FROM "roles" WHERE "roles"."name" = 'Site manager'
  Role Load (0.4ms)  SELECT "roles".* FROM "roles" WHERE "roles"."builtin" = 1 LIMIT 1
  Role Load (0.2ms)  SELECT "roles".* FROM "roles" WHERE "roles"."builtin" = 2 LIMIT 1
   (0.1ms)  COMMIT
   (0.7ms)  SELECT id FROM "users" 
  Host::Managed Load (0.5ms)  SELECT "hosts".* FROM "hosts" WHERE "hosts"."uuid" = '503d3525-c7fc-a786-4c29-83493b637eb0' LIMIT 1
  Host::Managed Load (0.7ms)  SELECT "hosts".* FROM "hosts" WHERE "hosts"."mac" = '00:50:56:bd:1c:f6' LIMIT 1
Create DHCP reservation for test17.localdomain-00:50:56:bd:1c:f6/192.168.88.1
Add DNS PTR record for 192.168.88.1/test17.localdomain
Add the TFTP configuration for test17.localdomain
  CACHE (0.0ms)  SELECT "config_templates".* FROM "config_templates" INNER JOIN "config_templates_operatingsystems" ON "config_templates_operatingsystems"."config_template_id" = "config_templates"."id" INNER JOIN "operatingsystems" ON "operatingsystems"."id" = "config_templates_operatingsystems"."operatingsystem_id" INNER JOIN "template_kinds" ON "template_kinds"."id" = "config_templates"."template_kind_id" INNER JOIN "template_combinations" ON "template_combinations"."config_template_id" = "config_templates"."id" INNER JOIN "environments" ON "environments"."id" = "template_combinations"."environment_id" WHERE "operatingsystems"."id" = 1 AND "template_kinds"."name" = 'PXELinux' AND "environments"."id" = 1 ORDER BY config_templates.name LIMIT 1
  CACHE (0.0ms)  SELECT "config_templates".* FROM "config_templates" INNER JOIN "config_templates_operatingsystems" ON "config_templates_operatingsystems"."config_template_id" = "config_templates"."id" INNER JOIN "operatingsystems" ON "operatingsystems"."id" = "config_templates_operatingsystems"."operatingsystem_id" INNER JOIN "template_kinds" ON "template_kinds"."id" = "config_templates"."template_kind_id" INNER JOIN "os_default_templates" ON "os_default_templates"."config_template_id" = "config_templates"."id" WHERE "operatingsystems"."id" = 1 AND "template_kinds"."name" = 'PXELinux' AND "os_default_templates"."operatingsystem_id" = 1 ORDER BY config_templates.name LIMIT 1
  Setting Load (0.5ms)  SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'safemode_render' ORDER BY name LIMIT 1
  Setting Load (0.4ms)  SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'foreman_url' ORDER BY name LIMIT 1
Fetching required TFTP boot files for test17.localdomain
  CACHE (0.0ms)  SELECT 1 AS one FROM "media" INNER JOIN "media_operatingsystems" ON "media"."id" = "media_operatingsystems"."medium_id" WHERE "media_operatingsystems"."operatingsystem_id" = 1 AND "media"."id" = 1 ORDER BY media.name LIMIT 1
  CACHE (0.0ms)  SELECT 1 AS one FROM "architectures" INNER JOIN "architectures_operatingsystems" ON "architectures"."id" = "architectures_operatingsystems"."architecture_id" WHERE "architectures_operatingsystems"."operatingsystem_id" = 1 AND "architectures"."id" = 1 LIMIT 1
Powering up Compute instance for test17.localdomain
  Feature Load (0.5ms)  SELECT "features".* FROM "features" WHERE "features"."name" = 'TFTP' LIMIT 1
  Feature Load (0.3ms)  SELECT "features".* FROM "features" WHERE "features"."name" = 'BMC' LIMIT 1
  Feature Load (0.2ms)  SELECT "features".* FROM "features" WHERE "features"."name" = 'DNS' LIMIT 1
  Feature Load (0.2ms)  SELECT "features".* FROM "features" WHERE "features"."name" = 'DHCP' LIMIT 1
  Feature Load (0.3ms)  SELECT "features".* FROM "features" WHERE "features"."name" = 'Puppet CA' LIMIT 1
  Feature Load (0.2ms)  SELECT "features".* FROM "features" WHERE "features"."name" = 'Puppet' LIMIT 1
  TemplateKind Load (0.5ms)  SELECT "template_kinds".* FROM "template_kinds" WHERE (name LIKE 'pxelinux')
  TemplateKind Load (0.2ms)  SELECT "template_kinds".* FROM "template_kinds" WHERE (name LIKE 'pxegrub')
  TemplateKind Load (0.3ms)  SELECT "template_kinds".* FROM "template_kinds" WHERE (name LIKE 'gpxe')
  TemplateKind Load (0.3ms)  SELECT "template_kinds".* FROM "template_kinds" WHERE (name LIKE 'provision')
  TemplateKind Load (0.3ms)  SELECT "template_kinds".* FROM "template_kinds" WHERE (name LIKE 'finish')
  TemplateKind Load (0.3ms)  SELECT "template_kinds".* FROM "template_kinds" 
  SQL (0.9ms)  INSERT INTO "hosts" ("architecture_id", "build", "certname", "comment", "compute_resource_id", "created_at", "disk", "domain_id", "enabled", "environment", "environment_id", "hostgroup_id", "image_file", "image_id", "installed_at", "ip", "last_compile", "last_freshcheck", "last_report", "location_id", "mac", "managed", "medium_id", "model_id", "name", "operatingsystem_id", "organization_id", "owner_id", "owner_type", "ptable_id", "puppet_ca_proxy_id", "puppet_proxy_id", "puppet_status", "root_pass", "serial", "source_file_id", "subnet_id", "type", "updated_at", "use_image", "uuid") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33, $34, $35, $36, $37, $38, $39, $40, $41) RETURNING "id"  [["architecture_id", 1], ["build", true], ["certname", nil], ["comment", ""], ["compute_resource_id", 1], ["created_at", Tue, 25 Jun 2013 03:18:25 UTC +00:00], ["disk", ""], ["domain_id", 1], ["enabled", true], ["environment", nil], ["environment_id", 1], ["hostgroup_id", nil], ["image_file", nil], ["image_id", nil], ["installed_at", nil], ["ip", "192.168.88.1"], ["last_compile", nil], ["last_freshcheck", nil], ["last_report", nil], ["location_id", nil], ["mac", "00:50:56:bd:1c:f6"], ["managed", true], ["medium_id", 1], ["model_id", nil], ["name", "test17.localdomain"], ["operatingsystem_id", 1], ["organization_id", nil], ["owner_id", 1], ["owner_type", "User"], ["ptable_id", 1], ["puppet_ca_proxy_id", 1], ["puppet_proxy_id", 1], ["puppet_status", 0], ["root_pass", nil], ["serial", nil], ["source_file_id", nil], ["subnet_id", 1], ["type", "Host::Managed"], ["updated_at", Tue, 25 Jun 2013 03:18:25 UTC +00:00], ["use_image", nil], ["uuid", "503d3525-c7fc-a786-4c29-83493b637eb0"]]
  Host::Managed Load (0.6ms)  SELECT "hosts".* FROM "hosts" WHERE "hosts"."id" = 2 LIMIT 1
   (0.4ms)  SELECT MAX("audits"."version") AS max_id FROM "audits" WHERE "audits"."auditable_id" = 2 AND "audits"."auditable_type" = 'Host'
  SQL (0.6ms)  INSERT INTO "audits" ("action", "associated_id", "associated_name", "associated_type", "auditable_id", "auditable_name", "auditable_type", "audited_changes", "comment", "created_at", "remote_address", "user_id", "user_type", "username", "version") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15) RETURNING "id"  [["action", "create"], ["associated_id", nil], ["associated_name", nil], ["associated_type", nil], ["auditable_id", 2], ["auditable_name", "test17.localdomain"], ["auditable_type", "Host"], ["audited_changes", "--- \n  name: test17.localdomain\n  ip: \"192.168.88.1\"\n  environment: \n  last_freshcheck: \n  source_file_id: \n  mac: \"00:50:56:bd:1c:f6\"\n  root_pass: \n  serial: \n  domain_id: 1\n  architecture_id: 1\n  operatingsystem_id: 1\n  environment_id: 1\n  subnet_id: 1\n  ptable_id: 1\n  medium_id: 1\n  build: true\n  comment: \"\"\n  disk: \"\"\n  installed_at: \n  model_id: \n  hostgroup_id: \n  owner_id: 1\n  owner_type: User\n  enabled: true\n  puppet_ca_proxy_id: 1\n  managed: true\n  use_image: \n  image_file: \n  uuid: \"503d3525-c7fc-a786-4c29-83493b637eb0\"\n  compute_resource_id: 1\n  puppet_proxy_id: 1\n  certname: \n  image_id: \n  organization_id: \n  location_id: "], ["comment", nil], ["created_at", Tue, 25 Jun 2013 03:18:25 UTC +00:00], ["remote_address", "192.168.88.1"], ["user_id", nil], ["user_type", nil], ["username", "Admin User"], ["version", 1]]
   (0.8ms)  COMMIT
Completed 200 OK in 4661ms (Views: 0.2ms | ActiveRecord: 17.1ms)


Started GET "/tasks/76bd522f-b05f-4b95-8cff-64ee8b0407bf" for 192.168.88.1 at 2013-06-24 20:18:25 -0700
Processing by TasksController#show as */*
  Parameters: {"id"=>"76bd522f-b05f-4b95-8cff-64ee8b0407bf"}
  User Load (0.4ms)  SELECT "users".* FROM "users" WHERE "users"."id" = $1 LIMIT 1  [["id", 1]]
Setting current user thread-local variable to admin
  Rendered tasks/_list.html.erb (1.5ms)
Completed 200 OK in 10ms (Views: 4.2ms | ActiveRecord: 0.4ms)


Started GET "/hosts/test17.localdomain" for 192.168.88.1 at 2013-06-24 20:18:25 -0700
  Setting Load (0.2ms)  SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'email_reply_address' ORDER BY name LIMIT 1
Processing by HostsController#show as HTML
  Parameters: {"id"=>"test17.localdomain"}
  User Load (0.4ms)  SELECT "users".* FROM "users" WHERE "users"."id" = $1 LIMIT 1  [["id", 1]]
Setting current user thread-local variable to admin
  Host::Base Load (0.5ms)  SELECT "hosts".* FROM "hosts" WHERE "hosts"."name" = 'test17.localdomain' LIMIT 1
  Report Load (0.4ms)  SELECT status FROM "reports" WHERE "reports"."host_id" = 2 AND (reported_at > '2013-06-18 03:18:25.447219') ORDER BY reported_at
  Operatingsystem Load (0.4ms)  SELECT "operatingsystems".* FROM "operatingsystems" WHERE "operatingsystems"."id" = 1 ORDER BY LOWER(operatingsystems.name) LIMIT 1
  ComputeResource Load (0.4ms)  SELECT "compute_resources".* FROM "compute_resources" WHERE "compute_resources"."id" = 1 ORDER BY compute_resources.name LIMIT 1
  SmartProxy Load (0.5ms)  SELECT "smart_proxies".* FROM "smart_proxies" WHERE "smart_proxies"."id" = 1 ORDER BY smart_proxies.name LIMIT 1
  Setting Load (0.3ms)  SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'puppetrun' ORDER BY name LIMIT 1
   (0.3ms)  SELECT COUNT(*) FROM "reports" WHERE "reports"."host_id" = 2
  Nic::Base Load (0.6ms)  SELECT "nics".* FROM "nics" WHERE "nics"."host_id" = 2 AND "nics"."type" = 'Nic::BMC' LIMIT 1
  FactValue Load (0.7ms)  SELECT "fact_values".* FROM "fact_values" WHERE "fact_values"."host_id" = 2
   (0.4ms)  SELECT COUNT(*) 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" = 'Puppet'
  Domain Load (0.3ms)  SELECT "domains".* FROM "domains" WHERE "domains"."id" = 1 ORDER BY domains.name LIMIT 1
  Environment Load (0.2ms)  SELECT "environments".* FROM "environments" WHERE "environments"."id" = 1 ORDER BY environments.name LIMIT 1
  Architecture Load (0.3ms)  SELECT "architectures".* FROM "architectures" WHERE "architectures"."id" = 1 LIMIT 1
  User Load (0.3ms)  SELECT "users".* FROM "users" WHERE "users"."id" = 1 ORDER BY firstname LIMIT 1
  Setting Load (0.3ms)  SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'use_uuid_for_certificates' ORDER BY name LIMIT 1
  Rendered hosts/_overview.html.erb (13.7ms)
  TemplateKind Load (0.2ms)  SELECT "template_kinds".* FROM "template_kinds" 
  ConfigTemplate Load (1.3ms)  SELECT "config_templates".* FROM "config_templates" INNER JOIN "config_templates_operatingsystems" ON "config_templates_operatingsystems"."config_template_id" = "config_templates"."id" INNER JOIN "operatingsystems" ON "operatingsystems"."id" = "config_templates_operatingsystems"."operatingsystem_id" INNER JOIN "template_kinds" ON "template_kinds"."id" = "config_templates"."template_kind_id" INNER JOIN "template_combinations" ON "template_combinations"."config_template_id" = "config_templates"."id" INNER JOIN "environments" ON "environments"."id" = "template_combinations"."environment_id" WHERE "operatingsystems"."id" = 1 AND "template_kinds"."name" = 'PXELinux' AND "environments"."id" = 1 ORDER BY config_templates.name LIMIT 1
  ConfigTemplate Load (0.7ms)  SELECT "config_templates".* FROM "config_templates" INNER JOIN "config_templates_operatingsystems" ON "config_templates_operatingsystems"."config_template_id" = "config_templates"."id" INNER JOIN "operatingsystems" ON "operatingsystems"."id" = "config_templates_operatingsystems"."operatingsystem_id" INNER JOIN "template_kinds" ON "template_kinds"."id" = "config_templates"."template_kind_id" INNER JOIN "os_default_templates" ON "os_default_templates"."config_template_id" = "config_templates"."id" WHERE "operatingsystems"."id" = 1 AND "template_kinds"."name" = 'PXELinux' AND "os_default_templates"."operatingsystem_id" = 1 ORDER BY config_templates.name LIMIT 1
  ConfigTemplate Load (1.3ms)  SELECT "config_templates".* FROM "config_templates" INNER JOIN "config_templates_operatingsystems" ON "config_templates_operatingsystems"."config_template_id" = "config_templates"."id" INNER JOIN "operatingsystems" ON "operatingsystems"."id" = "config_templates_operatingsystems"."operatingsystem_id" INNER JOIN "template_kinds" ON "template_kinds"."id" = "config_templates"."template_kind_id" INNER JOIN "template_combinations" ON "template_combinations"."config_template_id" = "config_templates"."id" INNER JOIN "environments" ON "environments"."id" = "template_combinations"."environment_id" WHERE "operatingsystems"."id" = 1 AND "template_kinds"."name" = 'gPXE' AND "environments"."id" = 1 ORDER BY config_templates.name LIMIT 1
  ConfigTemplate Load (0.8ms)  SELECT "config_templates".* FROM "config_templates" INNER JOIN "config_templates_operatingsystems" ON "config_templates_operatingsystems"."config_template_id" = "config_templates"."id" INNER JOIN "operatingsystems" ON "operatingsystems"."id" = "config_templates_operatingsystems"."operatingsystem_id" INNER JOIN "template_kinds" ON "template_kinds"."id" = "config_templates"."template_kind_id" INNER JOIN "os_default_templates" ON "os_default_templates"."config_template_id" = "config_templates"."id" WHERE "operatingsystems"."id" = 1 AND "template_kinds"."name" = 'gPXE' AND "os_default_templates"."operatingsystem_id" = 1 ORDER BY config_templates.name LIMIT 1
  ConfigTemplate Load (1.2ms)  SELECT "config_templates".* FROM "config_templates" INNER JOIN "config_templates_operatingsystems" ON "config_templates_operatingsystems"."config_template_id" = "config_templates"."id" INNER JOIN "operatingsystems" ON "operatingsystems"."id" = "config_templates_operatingsystems"."operatingsystem_id" INNER JOIN "template_kinds" ON "template_kinds"."id" = "config_templates"."template_kind_id" INNER JOIN "template_combinations" ON "template_combinations"."config_template_id" = "config_templates"."id" INNER JOIN "environments" ON "environments"."id" = "template_combinations"."environment_id" WHERE "operatingsystems"."id" = 1 AND "template_kinds"."name" = 'provision' AND "environments"."id" = 1 ORDER BY config_templates.name LIMIT 1
  ConfigTemplate Load (1.2ms)  SELECT "config_templates".* FROM "config_templates" INNER JOIN "config_templates_operatingsystems" ON "config_templates_operatingsystems"."config_template_id" = "config_templates"."id" INNER JOIN "operatingsystems" ON "operatingsystems"."id" = "config_templates_operatingsystems"."operatingsystem_id" INNER JOIN "template_kinds" ON "template_kinds"."id" = "config_templates"."template_kind_id" INNER JOIN "os_default_templates" ON "os_default_templates"."config_template_id" = "config_templates"."id" WHERE "operatingsystems"."id" = 1 AND "template_kinds"."name" = 'provision' AND "os_default_templates"."operatingsystem_id" = 1 ORDER BY config_templates.name LIMIT 1
  ConfigTemplate Load (1.2ms)  SELECT "config_templates".* FROM "config_templates" INNER JOIN "config_templates_operatingsystems" ON "config_templates_operatingsystems"."config_template_id" = "config_templates"."id" INNER JOIN "operatingsystems" ON "operatingsystems"."id" = "config_templates_operatingsystems"."operatingsystem_id" INNER JOIN "template_kinds" ON "template_kinds"."id" = "config_templates"."template_kind_id" INNER JOIN "template_combinations" ON "template_combinations"."config_template_id" = "config_templates"."id" INNER JOIN "environments" ON "environments"."id" = "template_combinations"."environment_id" WHERE "operatingsystems"."id" = 1 AND "template_kinds"."name" = 'finish' AND "environments"."id" = 1 ORDER BY config_templates.name LIMIT 1
  ConfigTemplate Load (0.8ms)  SELECT "config_templates".* FROM "config_templates" INNER JOIN "config_templates_operatingsystems" ON "config_templates_operatingsystems"."config_template_id" = "config_templates"."id" INNER JOIN "operatingsystems" ON "operatingsystems"."id" = "config_templates_operatingsystems"."operatingsystem_id" INNER JOIN "template_kinds" ON "template_kinds"."id" = "config_templates"."template_kind_id" INNER JOIN "os_default_templates" ON "os_default_templates"."config_template_id" = "config_templates"."id" WHERE "operatingsystems"."id" = 1 AND "template_kinds"."name" = 'finish' AND "os_default_templates"."operatingsystem_id" = 1 ORDER BY config_templates.name LIMIT 1
  ConfigTemplate Load (1.1ms)  SELECT "config_templates".* FROM "config_templates" INNER JOIN "config_templates_operatingsystems" ON "config_templates_operatingsystems"."config_template_id" = "config_templates"."id" INNER JOIN "operatingsystems" ON "operatingsystems"."id" = "config_templates_operatingsystems"."operatingsystem_id" INNER JOIN "template_kinds" ON "template_kinds"."id" = "config_templates"."template_kind_id" INNER JOIN "template_combinations" ON "template_combinations"."config_template_id" = "config_templates"."id" INNER JOIN "environments" ON "environments"."id" = "template_combinations"."environment_id" WHERE "operatingsystems"."id" = 1 AND "template_kinds"."name" = 'script' AND "environments"."id" = 1 ORDER BY config_templates.name LIMIT 1
  ConfigTemplate Load (0.7ms)  SELECT "config_templates".* FROM "config_templates" INNER JOIN "config_templates_operatingsystems" ON "config_templates_operatingsystems"."config_template_id" = "config_templates"."id" INNER JOIN "operatingsystems" ON "operatingsystems"."id" = "config_templates_operatingsystems"."operatingsystem_id" INNER JOIN "template_kinds" ON "template_kinds"."id" = "config_templates"."template_kind_id" INNER JOIN "os_default_templates" ON "os_default_templates"."config_template_id" = "config_templates"."id" WHERE "operatingsystems"."id" = 1 AND "template_kinds"."name" = 'script' AND "os_default_templates"."operatingsystem_id" = 1 ORDER BY config_templates.name LIMIT 1
  ConfigTemplate Load (1.1ms)  SELECT "config_templates".* FROM "config_templates" INNER JOIN "config_templates_operatingsystems" ON "config_templates_operatingsystems"."config_template_id" = "config_templates"."id" INNER JOIN "operatingsystems" ON "operatingsystems"."id" = "config_templates_operatingsystems"."operatingsystem_id" INNER JOIN "template_kinds" ON "template_kinds"."id" = "config_templates"."template_kind_id" INNER JOIN "template_combinations" ON "template_combinations"."config_template_id" = "config_templates"."id" INNER JOIN "environments" ON "environments"."id" = "template_combinations"."environment_id" WHERE "operatingsystems"."id" = 1 AND "template_kinds"."name" = 'PXEGrub' AND "environments"."id" = 1 ORDER BY config_templates.name LIMIT 1
  ConfigTemplate Load (0.7ms)  SELECT "config_templates".* FROM "config_templates" INNER JOIN "config_templates_operatingsystems" ON "config_templates_operatingsystems"."config_template_id" = "config_templates"."id" INNER JOIN "operatingsystems" ON "operatingsystems"."id" = "config_templates_operatingsystems"."operatingsystem_id" INNER JOIN "template_kinds" ON "template_kinds"."id" = "config_templates"."template_kind_id" INNER JOIN "os_default_templates" ON "os_default_templates"."config_template_id" = "config_templates"."id" WHERE "operatingsystems"."id" = 1 AND "template_kinds"."name" = 'PXEGrub' AND "os_default_templates"."operatingsystem_id" = 1 ORDER BY config_templates.name LIMIT 1
  TemplateKind Load (0.2ms)  SELECT "template_kinds".* FROM "template_kinds" WHERE "template_kinds"."id" = 1 LIMIT 1
  TemplateKind Load (0.2ms)  SELECT "template_kinds".* FROM "template_kinds" WHERE "template_kinds"."id" = 3 LIMIT 1
  Rendered compute_resources_vms/show/_vmware.html.erb (19.4ms)
  CACHE (0.0ms)  SELECT "nics".* FROM "nics" WHERE "nics"."host_id" = 2 AND "nics"."type" = 'Nic::BMC' LIMIT 1
  Report Load (0.5ms)  SELECT "reports".* FROM "reports" WHERE "reports"."host_id" = 2 AND (reported_at > '2013-06-18 03:18:28.628740') ORDER BY reported_at
  Report Load (0.3ms)  SELECT "reports".* FROM "reports" WHERE "reports"."host_id" = 2 AND (reported_at > '2013-06-18 03:18:28.630910') ORDER BY reported_at
  Rendered hosts/show.html.erb within layouts/application (3180.3ms)
  Setting Load (0.4ms)  SELECT "settings".* FROM "settings" WHERE "settings"."name" = 'use_gravatar' ORDER BY name LIMIT 1
  Rendered home/_user_dropdown.html.erb (3.5ms)
Read fragment views/tabs_and_title_records-1 (0.1ms)
  Rendered home/_org_switcher.html.erb (0.0ms)
  Rendered home/_settings.html.erb (4.5ms)
Write fragment views/tabs_and_title_records-1 (0.9ms)
  Rendered home/_topbar.html.erb (9.0ms)
Completed 200 OK in 3207ms (Views: 3177.1ms | ActiveRecord: 20.5ms)