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)