Cache read: https://eg-foreman.nd.cmgame.com/discovered_hosts?


Started GET "/discovered_hosts" for 192.168.58.12 at 2014-09-29 15:10:23 +0800
Processing by DiscoveredHostsController#index as HTML
  User Load (0.6ms)  SELECT `users`.* FROM `users` WHERE `users`.`id` = 4 LIMIT 1
Setting current user thread-local variable to qianmengshu
Cache read: authorize_login_delegation
Cache read: authorize_login_delegation
Cache read: idle_timeout
  AuthSource Load (0.6ms)  SELECT `auth_sources`.* FROM `auth_sources` WHERE `auth_sources`.`id` = 1 LIMIT 1
Cache read: entries_per_page
  Host::Discovered Load (0.9ms)  SELECT `hosts`.* FROM `hosts` WHERE `hosts`.`type` IN ('Host::Discovered') ORDER BY `hosts`.`name` ASC LIMIT 20 OFFSET 0
  Model Load (0.5ms)  SELECT `models`.* FROM `models` WHERE `models`.`id` = 1 ORDER BY models.name LIMIT 1
  Subnet Load (0.5ms)  SELECT `subnets`.* FROM `subnets` WHERE `subnets`.`id` = 4 ORDER BY vlanid LIMIT 1
  Rendered /opt/rh/ruby193/root/usr/share/gems/gems/foreman_discovery-1.4.0.rc3/app/views/discovered_hosts/_discovered_hosts_list.html.erb (16.3ms)
  Rendered /opt/rh/ruby193/root/usr/share/gems/gems/foreman_discovery-1.4.0.rc3/app/views/discovered_hosts/index.html.erb within layouts/application (17.7ms)
  Bookmark Load (1.1ms)  SELECT `bookmarks`.* FROM `bookmarks` WHERE (((bookmarks.public = 1) OR (bookmarks.owner_id = 4 AND bookmarks.owner_type = 'User'))) AND (controller = 'discovered_hosts') ORDER BY name
  Rendered common/_searchbar.html.erb (116.4ms)
Cache read: use_gravatar
  Rendered home/_user_dropdown.html.erb (1.8ms)
Cache read: views/tabs_and_title_records-4
Read fragment views/tabs_and_title_records-4 (0.3ms)
  Rendered home/_topbar.html.erb (2.9ms)
  Rendered layouts/base.html.erb (4.3ms)
Completed 200 OK in 149ms (Views: 137.0ms | ActiveRecord: 4.2ms)
Cache read: https://eg-foreman.nd.cmgame.com/discovered_hosts/mac005056ad1d3a?


Started GET "/discovered_hosts/mac005056ad1d3a" for 192.168.58.12 at 2014-09-29 15:10:40 +0800
Processing by DiscoveredHostsController#show as HTML
  Parameters: {"id"=>"mac005056ad1d3a"}
  User Load (0.4ms)  SELECT `users`.* FROM `users` WHERE `users`.`id` = 4 LIMIT 1
Setting current user thread-local variable to qianmengshu
Cache read: authorize_login_delegation
Cache read: authorize_login_delegation
Cache read: idle_timeout
  AuthSource Load (0.4ms)  SELECT `auth_sources`.* FROM `auth_sources` WHERE `auth_sources`.`id` = 1 LIMIT 1
  Host::Discovered Load (0.7ms)  SELECT `hosts`.* FROM `hosts` WHERE `hosts`.`type` IN ('Host::Discovered') AND `hosts`.`id` = 0 LIMIT 1
  Host::Discovered Load (0.7ms)  SELECT `hosts`.* FROM `hosts` WHERE `hosts`.`type` IN ('Host::Discovered') AND `hosts`.`name` = 'mac005056ad1d3a' LIMIT 1
  FactValue Load (1.1ms)  SELECT `fact_values`.* FROM `fact_values` WHERE `fact_values`.`host_id` = 100
  FactName Load (1.5ms)  SELECT `fact_names`.* FROM `fact_names` WHERE `fact_names`.`id` IN (171, 83, 124, 52, 86, 161, 75, 56, 42, 53, 143, 77, 158, 60, 39, 97, 159, 144, 73, 160, 149, 89, 62, 71, 36, 155, 25, 153, 145, 163, 65, 162, 122, 15, 28, 167, 19, 140, 100, 142, 24, 58, 18, 164, 138, 166, 66, 20, 38, 151, 69, 93, 94, 152, 27, 41, 165, 49, 170, 95, 147, 64, 44, 74, 23, 169, 148, 157, 48, 168, 154, 150, 99, 146, 156, 54, 139, 172, 46, 85, 141, 173, 33, 2) ORDER BY fact_names.name
  Rendered /opt/rh/ruby193/root/usr/share/gems/gems/foreman_discovery-1.4.0.rc3/app/views/discovered_hosts/show.html.erb within layouts/application (22.1ms)
Cache read: use_gravatar
  Rendered home/_user_dropdown.html.erb (1.8ms)
Cache read: views/tabs_and_title_records-4
Read fragment views/tabs_and_title_records-4 (0.4ms)
  Rendered home/_topbar.html.erb (3.0ms)
  Rendered layouts/base.html.erb (4.6ms)
Completed 200 OK in 36ms (Views: 25.4ms | ActiveRecord: 4.8ms)
Cache read: https://eg-foreman.nd.cmgame.com/discovered_hosts/mac005056ad1d3a/edit?


Started GET "/discovered_hosts/mac005056ad1d3a/edit" for 192.168.58.12 at 2014-09-29 15:10:42 +0800
Processing by DiscoveredHostsController#edit as HTML
  Parameters: {"id"=>"mac005056ad1d3a"}
  User Load (0.5ms)  SELECT `users`.* FROM `users` WHERE `users`.`id` = 4 LIMIT 1
Setting current user thread-local variable to qianmengshu
Cache read: authorize_login_delegation
Cache read: authorize_login_delegation
Cache read: idle_timeout
  AuthSource Load (0.4ms)  SELECT `auth_sources`.* FROM `auth_sources` WHERE `auth_sources`.`id` = 1 LIMIT 1
  Host::Discovered Load (0.4ms)  SELECT `hosts`.* FROM `hosts` WHERE `hosts`.`type` IN ('Host::Discovered') AND `hosts`.`id` = 0 LIMIT 1
  Host::Discovered Load (0.4ms)  SELECT `hosts`.* FROM `hosts` WHERE `hosts`.`type` IN ('Host::Discovered') AND `hosts`.`name` = 'mac005056ad1d3a' LIMIT 1
  Rendered hosts/_progress.html.erb (0.2ms)
Setting current organization thread-local variable to none
Setting current location thread-local variable to none
   (0.7ms)  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` IN ('Puppet')
  Hostgroup Load (0.5ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE (1=1)
  Environment Load (0.5ms)  SELECT `environments`.* FROM `environments` WHERE (1=1)
   (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` IN ('Puppet CA') AND (1=1)
  SmartProxy Load (0.6ms)  SELECT `smart_proxies`.* FROM `smart_proxies` INNER JOIN `features_smart_proxies` ON `features_smart_proxies`.`smart_proxy_id` = `smart_proxies`.`id` INNER JOIN `features` ON `features`.`id` = `features_smart_proxies`.`feature_id` WHERE `features`.`name` IN ('Puppet CA') AND (1=1)
   (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` IN ('Puppet') AND (1=1)
  SmartProxy Load (0.6ms)  SELECT `smart_proxies`.* FROM `smart_proxies` INNER JOIN `features_smart_proxies` ON `features_smart_proxies`.`smart_proxy_id` = `smart_proxies`.`id` INNER JOIN `features` ON `features`.`id` = `features_smart_proxies`.`feature_id` WHERE `features`.`name` IN ('Puppet') AND (1=1)
  Domain Load (0.4ms)  SELECT `domains`.* FROM `domains` WHERE (1=1)
  Realm Load (0.4ms)  SELECT `realms`.* FROM `realms` WHERE (1=1)
  Rendered common/_domain.html.erb (1.5ms)
  Nic::Base Load (0.5ms)  SELECT `nics`.* FROM `nics` WHERE `nics`.`host_id` = 100
   (0.4ms)  SELECT COUNT(*) FROM `domains` WHERE (1=1)
  CACHE (0.0ms)  SELECT COUNT(*) FROM `domains` WHERE (1=1)
  CACHE (0.0ms)  SELECT `domains`.* FROM `domains` WHERE (1=1)
  Rendered hosts/_interfaces.html.erb (7.7ms)
  Architecture Load (0.4ms)  SELECT `architectures`.* FROM `architectures` 
  Rendered common/os_selection/_architecture.html.erb (1.6ms)
  Rendered common/os_selection/_operatingsystem.html.erb (2.3ms)
  Rendered hosts/_operating_system.html.erb (9.6ms)
  Rendered hosts/_unattended.html.erb (28.0ms)
   (0.5ms)  SELECT `config_groups`.id FROM `config_groups` INNER JOIN `host_config_groups` ON `config_groups`.`id` = `host_config_groups`.`config_group_id` WHERE `host_config_groups`.`host_id` = 100 AND `host_config_groups`.`host_type` = 'Host::Base' ORDER BY config_groups.name
   (0.4ms)  SELECT puppetclass_id FROM `config_group_classes` WHERE `config_group_classes`.`config_group_id` IN (NULL)
   (0.4ms)  SELECT puppetclass_id FROM `hostgroup_classes` WHERE `hostgroup_classes`.`hostgroup_id` IS NULL
   (0.6ms)  SELECT puppetclass_id FROM `host_classes` WHERE `host_classes`.`host_id` = 100
  Puppetclass Load (0.5ms)  SELECT `puppetclasses`.* FROM `puppetclasses` WHERE `puppetclasses`.`id` IN (NULL) ORDER BY puppetclasses.name
   (0.4ms)  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 (9.3ms)
  CommonParameter Load (0.5ms)  SELECT `parameters`.* FROM `parameters` WHERE `parameters`.`type` IN ('CommonParameter') ORDER BY parameters.name
  Rendered common_parameters/_inherited_parameters.html.erb (0.3ms)
  LookupValue Load (0.5ms)  SELECT `lookup_values`.* FROM `lookup_values` WHERE `lookup_values`.`match` = 'fqdn=mac005056ad1d3a'
  Rendered common_parameters/_puppetclass_parameter.html.erb (2.2ms)
  Rendered common_parameters/_puppetclasses_parameters.html.erb (4.4ms)
  HostParameter Load (0.5ms)  SELECT `parameters`.* FROM `parameters` WHERE `parameters`.`type` IN ('HostParameter') AND `parameters`.`reference_id` = 100 ORDER BY parameters.name
  Rendered common_parameters/_parameter.html.erb (1.5ms)
  Rendered common_parameters/_parameters.html.erb (4.7ms)
  AuthSourceHidden Load (0.5ms)  SELECT `auth_sources`.* FROM `auth_sources` WHERE `auth_sources`.`type` IN ('AuthSourceHidden')
  User Load (0.7ms)  SELECT `users`.* FROM `users` WHERE (users.auth_source_id <> 3) ORDER BY firstname
  Usergroup Load (0.4ms)  SELECT `usergroups`.* FROM `usergroups` ORDER BY usergroups.name
  Model Load (0.5ms)  SELECT `models`.* FROM `models` ORDER BY models.name
Setting current location thread-local variable to none
Setting current organization thread-local variable to none
  Rendered hosts/_form.html.erb (80.8ms)
  Rendered hosts/edit.html.erb within layouts/application (82.7ms)
Cache read: use_gravatar
  Rendered home/_user_dropdown.html.erb (4.0ms)
Cache read: views/tabs_and_title_records-4
Read fragment views/tabs_and_title_records-4 (0.4ms)
  Rendered home/_topbar.html.erb (5.1ms)
  Rendered layouts/base.html.erb (6.4ms)
Completed 200 OK in 99ms (Views: 77.1ms | ActiveRecord: 14.8ms)
Cache read: https://eg-foreman.nd.cmgame.com/hosts/hostgroup_or_environment_selected?


Started POST "/hosts/hostgroup_or_environment_selected" for 192.168.58.12 at 2014-09-29 15:10:49 +0800
Processing by HostsController#hostgroup_or_environment_selected as */*
  Parameters: {"utf8"=>"✓", "authenticity_token"=>"SSQzy6Hk0CB+28KYDjJJ77ZqUQYuka6MlXwpUW+RBJs=", "host"=>{"name"=>"egtest-66-205", "hostgroup_id"=>"", "environment_id"=>"1", "puppet_ca_proxy_id"=>"", "puppet_proxy_id"=>"", "managed"=>"true", "progress_report_id"=>"[FILTERED]", "type"=>"Host::Managed", "domain_id"=>"", "realm_id"=>"", "mac"=>"00:50:56:ad:1d:3a", "ip"=>"192.168.66.243", "interfaces_attributes"=>{"new_interfaces"=>{"_destroy"=>"false", "type"=>"Nic::Managed", "mac"=>"", "name"=>"", "domain_id"=>"", "ip"=>"", "provider"=>"IPMI"}}, "architecture_id"=>"", "build"=>"1", "disk"=>"", "root_pass"=>"[FILTERED]", "is_owned_by"=>"4-Users", "enabled"=>"1", "model_id"=>"1", "comment"=>"", "overwrite"=>"false"}, "host_id"=>"100"}
  User Load (0.5ms)  SELECT `users`.* FROM `users` WHERE `users`.`id` = 4 LIMIT 1
Setting current user thread-local variable to qianmengshu
Cache read: authorize_login_delegation
Cache read: authorize_login_delegation
Cache read: idle_timeout
  AuthSource Load (0.4ms)  SELECT `auth_sources`.* FROM `auth_sources` WHERE `auth_sources`.`id` = 1 LIMIT 1
  Organization Load (0.5ms)  SELECT `taxonomies`.* FROM `taxonomies` WHERE `taxonomies`.`type` IN ('Organization') AND `taxonomies`.`id` IS NULL ORDER BY title LIMIT 1
  Location Load (0.4ms)  SELECT `taxonomies`.* FROM `taxonomies` WHERE `taxonomies`.`type` IN ('Location') AND `taxonomies`.`id` IS NULL ORDER BY title LIMIT 1
Setting current organization thread-local variable to none
Setting current location thread-local variable to none
  Host::Base Load (0.7ms)  SELECT `hosts`.* FROM `hosts` WHERE `hosts`.`id` = 100 LIMIT 1
  User Load (0.6ms)  SELECT `users`.* FROM `users` WHERE `users`.`id` = 4 ORDER BY firstname LIMIT 1
   (0.5ms)  SELECT COUNT(*) FROM `config_groups` 
   (0.4ms)  SELECT `config_groups`.id FROM `config_groups` INNER JOIN `host_config_groups` ON `config_groups`.`id` = `host_config_groups`.`config_group_id` WHERE `host_config_groups`.`host_id` = 100 AND `host_config_groups`.`host_type` = 'Host::Base' ORDER BY config_groups.name
   (0.3ms)  SELECT puppetclass_id FROM `config_group_classes` WHERE `config_group_classes`.`config_group_id` IN (NULL)
  Environment Load (0.5ms)  SELECT `environments`.* FROM `environments` WHERE `environments`.`id` = 1 ORDER BY environments.name LIMIT 1
  Puppetclass Load (0.5ms)  SELECT DISTINCT `puppetclasses`.* FROM `puppetclasses` INNER JOIN `environment_classes` ON `puppetclasses`.`id` = `environment_classes`.`puppetclass_id` WHERE `environment_classes`.`environment_id` = 1 AND `puppetclasses`.`id` IN (NULL) ORDER BY puppetclasses.name
  Puppetclass Load (0.6ms)  SELECT `puppetclasses`.* FROM `puppetclasses` INNER JOIN `host_classes` ON `puppetclasses`.`id` = `host_classes`.`puppetclass_id` WHERE `host_classes`.`host_id` = 100 ORDER BY puppetclasses.name
  Rendered puppetclasses/_selectedClasses.html.erb (0.0ms)
  CACHE (0.0ms)  SELECT `config_groups`.id FROM `config_groups` INNER JOIN `host_config_groups` ON `config_groups`.`id` = `host_config_groups`.`config_group_id` WHERE `host_config_groups`.`host_id` = 100 AND `host_config_groups`.`host_type` = 'Host::Base' ORDER BY config_groups.name
  CACHE (0.0ms)  SELECT puppetclass_id FROM `config_group_classes` WHERE `config_group_classes`.`config_group_id` IN (NULL)
  CACHE (0.0ms)  SELECT DISTINCT `puppetclasses`.* FROM `puppetclasses` INNER JOIN `environment_classes` ON `puppetclasses`.`id` = `environment_classes`.`puppetclass_id` WHERE `environment_classes`.`environment_id` = 1 AND `puppetclasses`.`id` IN (NULL) ORDER BY puppetclasses.name
  Rendered puppetclasses/_classes_in_groups.html.erb (0.0ms)
  Puppetclass Load (0.7ms)  SELECT DISTINCT `puppetclasses`.* FROM `puppetclasses` INNER JOIN `environment_classes` ON `puppetclasses`.`id` = `environment_classes`.`puppetclass_id` WHERE `environment_classes`.`environment_id` = 1 ORDER BY puppetclasses.name
  CACHE (0.0ms)  SELECT `config_groups`.id FROM `config_groups` INNER JOIN `host_config_groups` ON `config_groups`.`id` = `host_config_groups`.`config_group_id` WHERE `host_config_groups`.`host_id` = 100 AND `host_config_groups`.`host_type` = 'Host::Base' ORDER BY config_groups.name
  CACHE (0.0ms)  SELECT puppetclass_id FROM `config_group_classes` WHERE `config_group_classes`.`config_group_id` IN (NULL)
   (0.3ms)  SELECT puppetclass_id FROM `hostgroup_classes` WHERE `hostgroup_classes`.`hostgroup_id` IS NULL
   (0.3ms)  SELECT puppetclass_id FROM `host_classes` WHERE `host_classes`.`host_id` = 100
  CACHE (0.0ms)  SELECT DISTINCT `puppetclasses`.* FROM `puppetclasses` INNER JOIN `environment_classes` ON `puppetclasses`.`id` = `environment_classes`.`puppetclass_id` WHERE `environment_classes`.`environment_id` = 1 AND `puppetclasses`.`id` IN (NULL) ORDER BY puppetclasses.name
  Rendered puppetclasses/_classes.html.erb (5.3ms)
  Rendered puppetclasses/_class_selection.html.erb (159.9ms)
Setting current location thread-local variable to none
Setting current organization thread-local variable to none
Completed 200 OK in 181ms (Views: 158.5ms | ActiveRecord: 9.5ms)
Cache read: https://eg-foreman.nd.cmgame.com/hosts/puppetclass_parameters?


Started POST "/hosts/puppetclass_parameters" for 192.168.58.12 at 2014-09-29 15:10:49 +0800
Processing by HostsController#puppetclass_parameters as */*
  Parameters: {"utf8"=>"✓", "authenticity_token"=>"SSQzy6Hk0CB+28KYDjJJ77ZqUQYuka6MlXwpUW+RBJs=", "host"=>{"name"=>"egtest-66-205", "hostgroup_id"=>"", "environment_id"=>"1", "puppet_ca_proxy_id"=>"", "puppet_proxy_id"=>"", "puppetclass_ids"=>[""], "managed"=>"true", "progress_report_id"=>"[FILTERED]", "type"=>"Host::Managed", "domain_id"=>"", "realm_id"=>"", "mac"=>"00:50:56:ad:1d:3a", "ip"=>"192.168.66.243", "interfaces_attributes"=>{"new_interfaces"=>{"_destroy"=>"false", "type"=>"Nic::Managed", "mac"=>"", "name"=>"", "domain_id"=>"", "ip"=>"", "provider"=>"IPMI"}}, "architecture_id"=>"", "build"=>"1", "disk"=>"", "root_pass"=>"[FILTERED]", "is_owned_by"=>"4-Users", "enabled"=>"1", "model_id"=>"1", "comment"=>"", "overwrite"=>"false"}, "host_id"=>"100"}
  User Load (0.4ms)  SELECT `users`.* FROM `users` WHERE `users`.`id` = 4 LIMIT 1
Setting current user thread-local variable to qianmengshu
Cache read: authorize_login_delegation
Cache read: authorize_login_delegation
Cache read: idle_timeout
  AuthSource Load (0.4ms)  SELECT `auth_sources`.* FROM `auth_sources` WHERE `auth_sources`.`id` = 1 LIMIT 1
  Organization Load (0.4ms)  SELECT `taxonomies`.* FROM `taxonomies` WHERE `taxonomies`.`type` IN ('Organization') AND `taxonomies`.`id` IS NULL ORDER BY title LIMIT 1
  Location Load (0.4ms)  SELECT `taxonomies`.* FROM `taxonomies` WHERE `taxonomies`.`type` IN ('Location') AND `taxonomies`.`id` IS NULL ORDER BY title 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` = 100 LIMIT 1
  Puppetclass Load (0.4ms)  SELECT `puppetclasses`.* FROM `puppetclasses` INNER JOIN `host_classes` ON `puppetclasses`.`id` = `host_classes`.`puppetclass_id` WHERE `host_classes`.`host_id` = 100 ORDER BY puppetclasses.name
   (0.3ms)  BEGIN
   (0.3ms)  COMMIT
  User Load (0.4ms)  SELECT `users`.* FROM `users` WHERE `users`.`id` = 4 ORDER BY firstname LIMIT 1
  Environment Load (0.4ms)  SELECT `environments`.* FROM `environments` WHERE `environments`.`id` = 1 ORDER BY environments.name LIMIT 1
   (0.3ms)  SELECT `config_groups`.id FROM `config_groups` INNER JOIN `host_config_groups` ON `config_groups`.`id` = `host_config_groups`.`config_group_id` WHERE `host_config_groups`.`host_id` = 100 AND `host_config_groups`.`host_type` = 'Host::Base' ORDER BY config_groups.name
   (0.3ms)  SELECT puppetclass_id FROM `config_group_classes` WHERE `config_group_classes`.`config_group_id` IN (NULL)
   (0.3ms)  SELECT puppetclass_id FROM `hostgroup_classes` WHERE `hostgroup_classes`.`hostgroup_id` IS NULL
   (0.3ms)  SELECT puppetclass_id FROM `host_classes` WHERE `host_classes`.`host_id` = 100
  Puppetclass Load (0.4ms)  SELECT DISTINCT `puppetclasses`.* FROM `puppetclasses` INNER JOIN `environment_classes` ON `puppetclasses`.`id` = `environment_classes`.`puppetclass_id` WHERE `environment_classes`.`environment_id` = 1 AND `puppetclasses`.`id` IN (NULL) ORDER BY puppetclasses.name
   (0.3ms)  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.3ms)  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 (12.8ms)
Setting current location thread-local variable to none
Setting current organization thread-local variable to none
Completed 200 OK in 31ms (Views: 12.4ms | ActiveRecord: 6.1ms)
Cache read: https://eg-foreman.nd.cmgame.com/hosts/domain_selected?


Started POST "/hosts/domain_selected" for 192.168.58.12 at 2014-09-29 15:10:54 +0800
Processing by HostsController#domain_selected as */*
  Parameters: {"domain_id"=>"1"}
  User Load (0.4ms)  SELECT `users`.* FROM `users` WHERE `users`.`id` = 4 LIMIT 1
Setting current user thread-local variable to qianmengshu
Cache read: authorize_login_delegation
Cache read: authorize_login_delegation
Cache read: idle_timeout
  AuthSource Load (0.4ms)  SELECT `auth_sources`.* FROM `auth_sources` WHERE `auth_sources`.`id` = 1 LIMIT 1
Setting current organization thread-local variable to none
Setting current location thread-local variable to none
  Domain Load (0.5ms)  SELECT `domains`.* FROM `domains` WHERE `domains`.`id` = 1 ORDER BY domains.name LIMIT 1
   (0.4ms)  SELECT COUNT(*) FROM `subnets` WHERE (1=1)
  CACHE (0.0ms)  SELECT COUNT(*) FROM `subnets` WHERE (1=1)
  Subnet Load (0.5ms)  SELECT `subnets`.* FROM `subnets` WHERE (1=1)
  CACHE (0.0ms)  SELECT `subnets`.* FROM `subnets` WHERE (1=1)
  Rendered common/_domain.html.erb (11.0ms)
Setting current location thread-local variable to none
Setting current organization thread-local variable to none
Completed 200 OK in 21ms (Views: 10.6ms | ActiveRecord: 2.2ms)
Cache read: https://eg-foreman.nd.cmgame.com/hosts/current_parameters?


Started POST "/hosts/current_parameters" for 192.168.58.12 at 2014-09-29 15:10:54 +0800
Processing by HostsController#current_parameters as */*
  Parameters: {"utf8"=>"✓", "authenticity_token"=>"SSQzy6Hk0CB+28KYDjJJ77ZqUQYuka6MlXwpUW+RBJs=", "host"=>{"name"=>"egtest-66-205", "hostgroup_id"=>"", "environment_id"=>"1", "puppet_ca_proxy_id"=>"6", "puppet_proxy_id"=>"4", "puppetclass_ids"=>[""], "managed"=>"true", "progress_report_id"=>"[FILTERED]", "type"=>"Host::Managed", "domain_id"=>"1", "realm_id"=>"", "mac"=>"00:50:56:ad:1d:3a", "subnet_id"=>"", "ip"=>"192.168.66.243", "interfaces_attributes"=>{"new_interfaces"=>{"_destroy"=>"false", "type"=>"Nic::Managed", "mac"=>"", "name"=>"", "domain_id"=>"", "ip"=>"", "provider"=>"IPMI"}}, "architecture_id"=>"", "build"=>"1", "disk"=>"", "root_pass"=>"[FILTERED]", "is_owned_by"=>"4-Users", "enabled"=>"1", "model_id"=>"1", "comment"=>"", "overwrite"=>"false"}, "host_id"=>"100"}
  User Load (0.4ms)  SELECT `users`.* FROM `users` WHERE `users`.`id` = 4 LIMIT 1
Setting current user thread-local variable to qianmengshu
Cache read: authorize_login_delegation
Cache read: authorize_login_delegation
Cache read: idle_timeout
  AuthSource Load (0.4ms)  SELECT `auth_sources`.* FROM `auth_sources` WHERE `auth_sources`.`id` = 1 LIMIT 1
  Organization Load (0.3ms)  SELECT `taxonomies`.* FROM `taxonomies` WHERE `taxonomies`.`type` IN ('Organization') AND `taxonomies`.`id` IS NULL ORDER BY title LIMIT 1
  Location Load (0.4ms)  SELECT `taxonomies`.* FROM `taxonomies` WHERE `taxonomies`.`type` IN ('Location') AND `taxonomies`.`id` IS NULL ORDER BY title LIMIT 1
Setting current organization thread-local variable to none
Setting current location thread-local variable to none
  Host::Base Load (0.5ms)  SELECT `hosts`.* FROM `hosts` WHERE `hosts`.`id` = 100 LIMIT 1
  Puppetclass Load (0.4ms)  SELECT `puppetclasses`.* FROM `puppetclasses` INNER JOIN `host_classes` ON `puppetclasses`.`id` = `host_classes`.`puppetclass_id` WHERE `host_classes`.`host_id` = 100 ORDER BY puppetclasses.name
   (0.3ms)  BEGIN
   (0.3ms)  COMMIT
  User Load (0.4ms)  SELECT `users`.* FROM `users` WHERE `users`.`id` = 4 ORDER BY firstname LIMIT 1
  CommonParameter Load (0.3ms)  SELECT `parameters`.* FROM `parameters` WHERE `parameters`.`type` IN ('CommonParameter') ORDER BY parameters.name
  Domain Load (0.3ms)  SELECT `domains`.* FROM `domains` WHERE `domains`.`id` = 1 ORDER BY domains.name LIMIT 1
  DomainParameter Load (0.6ms)  SELECT `parameters`.* FROM `parameters` WHERE `parameters`.`type` IN ('DomainParameter') AND `parameters`.`reference_id` = 1 ORDER BY parameters.name
  Rendered common_parameters/_inherited_parameters.html.erb (1.1ms)
Setting current location thread-local variable to none
Setting current organization thread-local variable to none
Completed 200 OK in 28ms (Views: 3.6ms | ActiveRecord: 4.7ms)
Cache read: https://eg-foreman.nd.cmgame.com/architecture_selected_discovered_hosts?


Started POST "/architecture_selected_discovered_hosts" for 192.168.58.12 at 2014-09-29 15:11:04 +0800
Processing by HostsController#architecture_selected as */*
  Parameters: {"architecture_id"=>"1"}
  User Load (0.4ms)  SELECT `users`.* FROM `users` WHERE `users`.`id` = 4 LIMIT 1
Setting current user thread-local variable to qianmengshu
Cache read: authorize_login_delegation
Cache read: authorize_login_delegation
Cache read: idle_timeout
  AuthSource Load (0.4ms)  SELECT `auth_sources`.* FROM `auth_sources` WHERE `auth_sources`.`id` = 1 LIMIT 1
Setting current organization thread-local variable to none
Setting current location thread-local variable to none
  Architecture Load (0.5ms)  SELECT `architectures`.* FROM `architectures` WHERE `architectures`.`id` = 1 LIMIT 1
  Operatingsystem Load (0.7ms)  SELECT `operatingsystems`.* FROM `operatingsystems` INNER JOIN `architectures_operatingsystems` ON `operatingsystems`.`id` = `architectures_operatingsystems`.`operatingsystem_id` WHERE `architectures_operatingsystems`.`architecture_id` = 1 ORDER BY operatingsystems.name
  Rendered common/os_selection/_architecture.html.erb (151.1ms)
Setting current location thread-local variable to none
Setting current organization thread-local variable to none
Completed 200 OK in 163ms (Views: 149.1ms | ActiveRecord: 5.8ms)
Cache read: https://eg-foreman.nd.cmgame.com/hosts/os_selected?


Started POST "/hosts/os_selected" for 192.168.58.12 at 2014-09-29 15:11:06 +0800
Processing by HostsController#os_selected as */*
  Parameters: {"operatingsystem_id"=>"1"}
  User Load (0.5ms)  SELECT `users`.* FROM `users` WHERE `users`.`id` = 4 LIMIT 1
Setting current user thread-local variable to qianmengshu
Cache read: authorize_login_delegation
Cache read: authorize_login_delegation
Cache read: idle_timeout
  AuthSource Load (0.4ms)  SELECT `auth_sources`.* FROM `auth_sources` WHERE `auth_sources`.`id` = 1 LIMIT 1
Setting current organization thread-local variable to none
Setting current location thread-local variable to none
  Operatingsystem Load (0.5ms)  SELECT `operatingsystems`.* FROM `operatingsystems` WHERE `operatingsystems`.`id` = 1 ORDER BY operatingsystems.name LIMIT 1
   (0.6ms)  SELECT COUNT(*) FROM `media` INNER JOIN `media_operatingsystems` ON `media`.`id` = `media_operatingsystems`.`medium_id` WHERE `media_operatingsystems`.`operatingsystem_id` = 1 AND (1=1)
  Medium Load (0.7ms)  SELECT `media`.* FROM `media` INNER JOIN `media_operatingsystems` ON `media`.`id` = `media_operatingsystems`.`medium_id` WHERE `media_operatingsystems`.`operatingsystem_id` = 1 AND (1=1) ORDER BY media.name
  Ptable Load (0.7ms)  SELECT `ptables`.* FROM `ptables` INNER JOIN `operatingsystems_ptables` ON `ptables`.`id` = `operatingsystems_ptables`.`ptable_id` WHERE `operatingsystems_ptables`.`operatingsystem_id` = 1 ORDER BY ptables.name
  Rendered common/os_selection/_operatingsystem.html.erb (41.1ms)
Setting current location thread-local variable to none
Setting current organization thread-local variable to none
Completed 200 OK in 53ms (Views: 34.9ms | ActiveRecord: 10.0ms)
Cache read: https://eg-foreman.nd.cmgame.com/hosts/current_parameters?


Started POST "/hosts/current_parameters" for 192.168.58.12 at 2014-09-29 15:11:06 +0800
Processing by HostsController#current_parameters as */*
  Parameters: {"utf8"=>"✓", "authenticity_token"=>"SSQzy6Hk0CB+28KYDjJJ77ZqUQYuka6MlXwpUW+RBJs=", "host"=>{"name"=>"egtest-66-205", "hostgroup_id"=>"", "environment_id"=>"1", "puppet_ca_proxy_id"=>"6", "puppet_proxy_id"=>"4", "puppetclass_ids"=>[""], "managed"=>"true", "progress_report_id"=>"[FILTERED]", "type"=>"Host::Managed", "domain_id"=>"1", "realm_id"=>"", "mac"=>"00:50:56:ad:1d:3a", "subnet_id"=>"4", "ip"=>"192.168.66.205", "interfaces_attributes"=>{"new_interfaces"=>{"_destroy"=>"false", "type"=>"Nic::Managed", "mac"=>"", "name"=>"", "domain_id"=>"", "ip"=>"", "provider"=>"IPMI"}}, "architecture_id"=>"1", "operatingsystem_id"=>"1", "build"=>"1", "medium_id"=>"", "ptable_id"=>"", "disk"=>"", "root_pass"=>"[FILTERED]", "is_owned_by"=>"4-Users", "enabled"=>"1", "model_id"=>"1", "comment"=>"", "overwrite"=>"false"}, "host_id"=>"100"}
  User Load (0.5ms)  SELECT `users`.* FROM `users` WHERE `users`.`id` = 4 LIMIT 1
Setting current user thread-local variable to qianmengshu
Cache read: authorize_login_delegation
Cache read: authorize_login_delegation
Cache read: idle_timeout
  AuthSource Load (0.4ms)  SELECT `auth_sources`.* FROM `auth_sources` WHERE `auth_sources`.`id` = 1 LIMIT 1
  Organization Load (0.3ms)  SELECT `taxonomies`.* FROM `taxonomies` WHERE `taxonomies`.`type` IN ('Organization') AND `taxonomies`.`id` IS NULL ORDER BY title LIMIT 1
  Location Load (0.3ms)  SELECT `taxonomies`.* FROM `taxonomies` WHERE `taxonomies`.`type` IN ('Location') AND `taxonomies`.`id` IS NULL ORDER BY title 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` = 100 LIMIT 1
  Puppetclass Load (0.3ms)  SELECT `puppetclasses`.* FROM `puppetclasses` INNER JOIN `host_classes` ON `puppetclasses`.`id` = `host_classes`.`puppetclass_id` WHERE `host_classes`.`host_id` = 100 ORDER BY puppetclasses.name
   (0.3ms)  BEGIN
   (0.3ms)  COMMIT
  User Load (0.4ms)  SELECT `users`.* FROM `users` WHERE `users`.`id` = 4 ORDER BY firstname LIMIT 1
  CommonParameter Load (0.3ms)  SELECT `parameters`.* FROM `parameters` WHERE `parameters`.`type` IN ('CommonParameter') ORDER BY parameters.name
  Domain Load (0.4ms)  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 ORDER BY parameters.name
  Operatingsystem Load (0.3ms)  SELECT `operatingsystems`.* FROM `operatingsystems` WHERE `operatingsystems`.`id` = 1 ORDER BY operatingsystems.name LIMIT 1
  OsParameter Load (0.6ms)  SELECT `parameters`.* FROM `parameters` WHERE `parameters`.`type` IN ('OsParameter') AND `parameters`.`reference_id` = 1 ORDER BY parameters.name
  Rendered common_parameters/_inherited_parameters.html.erb (0.4ms)
Setting current location thread-local variable to none
Setting current organization thread-local variable to none
Completed 200 OK in 26ms (Views: 0.9ms | ActiveRecord: 5.1ms)
Cache read: https://eg-foreman.nd.cmgame.com/hosts/medium_selected?


Started POST "/hosts/medium_selected" for 192.168.58.12 at 2014-09-29 15:11:08 +0800
Processing by HostsController#medium_selected as */*
  Parameters: {"host"=>{"medium_id"=>"8", "operatingsystem_id"=>"1", "architecture_id"=>"1", "use_image"=>"false"}}
  User Load (0.4ms)  SELECT `users`.* FROM `users` WHERE `users`.`id` = 4 LIMIT 1
Setting current user thread-local variable to qianmengshu
Cache read: authorize_login_delegation
Cache read: authorize_login_delegation
Cache read: idle_timeout
  AuthSource Load (0.4ms)  SELECT `auth_sources`.* FROM `auth_sources` WHERE `auth_sources`.`id` = 1 LIMIT 1
  Rendered common/os_selection/_image_details.html.erb (3.3ms)
Completed 200 OK in 13ms (Views: 5.5ms | ActiveRecord: 0.8ms)
Cache read: https://eg-foreman.nd.cmgame.com/hosts/template_used?provisioning=build


Started POST "/hosts/template_used?provisioning=build" for 192.168.58.12 at 2014-09-29 15:11:13 +0800
Processing by HostsController#template_used as */*
  Parameters: {"utf8"=>"✓", "authenticity_token"=>"SSQzy6Hk0CB+28KYDjJJ77ZqUQYuka6MlXwpUW+RBJs=", "host"=>{"name"=>"egtest-66-205", "hostgroup_id"=>"", "environment_id"=>"1", "puppet_ca_proxy_id"=>"6", "puppet_proxy_id"=>"4", "puppetclass_ids"=>[""], "managed"=>"true", "progress_report_id"=>"[FILTERED]", "type"=>"Host::Managed", "domain_id"=>"1", "realm_id"=>"", "mac"=>"00:50:56:ad:1d:3a", "subnet_id"=>"4", "ip"=>"192.168.66.205", "interfaces_attributes"=>{"new_interfaces"=>{"_destroy"=>"false", "type"=>"Nic::Managed", "mac"=>"", "name"=>"", "domain_id"=>"", "ip"=>"", "provider"=>"IPMI"}}, "architecture_id"=>"1", "operatingsystem_id"=>"1", "build"=>"1", "medium_id"=>"8", "ptable_id"=>"13", "disk"=>"", "root_pass"=>"[FILTERED]", "is_owned_by"=>"4-Users", "enabled"=>"1", "model_id"=>"1", "comment"=>"", "overwrite"=>"false"}, "provisioning"=>"build"}
  User Load (0.4ms)  SELECT `users`.* FROM `users` WHERE `users`.`id` = 4 LIMIT 1
Setting current user thread-local variable to qianmengshu
Cache read: authorize_login_delegation
Cache read: authorize_login_delegation
Cache read: idle_timeout
  AuthSource Load (0.4ms)  SELECT `auth_sources`.* FROM `auth_sources` WHERE `auth_sources`.`id` = 1 LIMIT 1
  TemplateKind Load (0.5ms)  SELECT `template_kinds`.* FROM `template_kinds` 
  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` WHERE `operatingsystems`.`id` = 1 AND `template_kinds`.`name` = 'PXELinux' AND `template_combinations`.`hostgroup_id` = 0 AND `template_combinations`.`environment_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` WHERE `operatingsystems`.`id` = 1 AND `template_kinds`.`name` = 'PXELinux' AND `template_combinations`.`hostgroup_id` = 0 AND `template_combinations`.`environment_id` IS NULL 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` WHERE `operatingsystems`.`id` = 1 AND `template_kinds`.`name` = 'PXELinux' AND `template_combinations`.`hostgroup_id` IS NULL AND `template_combinations`.`environment_id` = 1 ORDER BY config_templates.name LIMIT 1
  ConfigTemplate Load (1.4ms)  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.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` WHERE `operatingsystems`.`id` = 1 AND `template_kinds`.`name` = 'PXEGrub' AND `template_combinations`.`hostgroup_id` = 0 AND `template_combinations`.`environment_id` = 1 ORDER BY config_templates.name LIMIT 1
  ConfigTemplate Load (1.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` WHERE `operatingsystems`.`id` = 1 AND `template_kinds`.`name` = 'PXEGrub' AND `template_combinations`.`hostgroup_id` = 0 AND `template_combinations`.`environment_id` IS NULL ORDER BY config_templates.name LIMIT 1
  ConfigTemplate Load (1.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` WHERE `operatingsystems`.`id` = 1 AND `template_kinds`.`name` = 'PXEGrub' AND `template_combinations`.`hostgroup_id` IS NULL AND `template_combinations`.`environment_id` = 1 ORDER BY config_templates.name LIMIT 1
  ConfigTemplate Load (1.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` = 'PXEGrub' AND `os_default_templates`.`operatingsystem_id` = 1 ORDER BY config_templates.name LIMIT 1
  ConfigTemplate Load (1.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` WHERE `operatingsystems`.`id` = 1 AND `template_kinds`.`name` = 'iPXE' AND `template_combinations`.`hostgroup_id` = 0 AND `template_combinations`.`environment_id` = 1 ORDER BY config_templates.name LIMIT 1
  ConfigTemplate Load (1.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` WHERE `operatingsystems`.`id` = 1 AND `template_kinds`.`name` = 'iPXE' AND `template_combinations`.`hostgroup_id` = 0 AND `template_combinations`.`environment_id` IS NULL ORDER BY config_templates.name LIMIT 1
  ConfigTemplate Load (1.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` WHERE `operatingsystems`.`id` = 1 AND `template_kinds`.`name` = 'iPXE' AND `template_combinations`.`hostgroup_id` IS NULL AND `template_combinations`.`environment_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 `os_default_templates` ON `os_default_templates`.`config_template_id` = `config_templates`.`id` WHERE `operatingsystems`.`id` = 1 AND `template_kinds`.`name` = 'iPXE' AND `os_default_templates`.`operatingsystem_id` = 1 ORDER BY config_templates.name LIMIT 1
  ConfigTemplate Load (1.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` WHERE `operatingsystems`.`id` = 1 AND `template_kinds`.`name` = 'provision' AND `template_combinations`.`hostgroup_id` = 0 AND `template_combinations`.`environment_id` = 1 ORDER BY config_templates.name LIMIT 1
  ConfigTemplate Load (1.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` WHERE `operatingsystems`.`id` = 1 AND `template_kinds`.`name` = 'provision' AND `template_combinations`.`hostgroup_id` = 0 AND `template_combinations`.`environment_id` IS NULL ORDER BY config_templates.name LIMIT 1
  ConfigTemplate Load (1.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` WHERE `operatingsystems`.`id` = 1 AND `template_kinds`.`name` = 'provision' AND `template_combinations`.`hostgroup_id` IS NULL AND `template_combinations`.`environment_id` = 1 ORDER BY config_templates.name LIMIT 1
  ConfigTemplate Load (1.5ms)  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.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` WHERE `operatingsystems`.`id` = 1 AND `template_kinds`.`name` = 'finish' AND `template_combinations`.`hostgroup_id` = 0 AND `template_combinations`.`environment_id` = 1 ORDER BY config_templates.name LIMIT 1
  ConfigTemplate Load (1.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` WHERE `operatingsystems`.`id` = 1 AND `template_kinds`.`name` = 'finish' AND `template_combinations`.`hostgroup_id` = 0 AND `template_combinations`.`environment_id` IS NULL ORDER BY config_templates.name LIMIT 1
  ConfigTemplate Load (1.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` WHERE `operatingsystems`.`id` = 1 AND `template_kinds`.`name` = 'finish' AND `template_combinations`.`hostgroup_id` IS NULL AND `template_combinations`.`environment_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 `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.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` WHERE `operatingsystems`.`id` = 1 AND `template_kinds`.`name` = 'script' AND `template_combinations`.`hostgroup_id` = 0 AND `template_combinations`.`environment_id` = 1 ORDER BY config_templates.name LIMIT 1
  ConfigTemplate Load (1.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` WHERE `operatingsystems`.`id` = 1 AND `template_kinds`.`name` = 'script' AND `template_combinations`.`hostgroup_id` = 0 AND `template_combinations`.`environment_id` IS NULL ORDER BY config_templates.name LIMIT 1
  ConfigTemplate Load (1.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` WHERE `operatingsystems`.`id` = 1 AND `template_kinds`.`name` = 'script' AND `template_combinations`.`hostgroup_id` IS NULL AND `template_combinations`.`environment_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` = 'script' AND `os_default_templates`.`operatingsystem_id` = 1 ORDER BY config_templates.name LIMIT 1
  ConfigTemplate Load (1.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` WHERE `operatingsystems`.`id` = 1 AND `template_kinds`.`name` = 'user_data' AND `template_combinations`.`hostgroup_id` = 0 AND `template_combinations`.`environment_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` WHERE `operatingsystems`.`id` = 1 AND `template_kinds`.`name` = 'user_data' AND `template_combinations`.`hostgroup_id` = 0 AND `template_combinations`.`environment_id` IS NULL ORDER BY config_templates.name LIMIT 1
  ConfigTemplate Load (1.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` WHERE `operatingsystems`.`id` = 1 AND `template_kinds`.`name` = 'user_data' AND `template_combinations`.`hostgroup_id` IS NULL AND `template_combinations`.`environment_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 `os_default_templates` ON `os_default_templates`.`config_template_id` = `config_templates`.`id` WHERE `operatingsystems`.`id` = 1 AND `template_kinds`.`name` = 'user_data' AND `os_default_templates`.`operatingsystem_id` = 1 ORDER BY config_templates.name LIMIT 1
  ConfigTemplate Load (1.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` WHERE `operatingsystems`.`id` = 1 AND `template_kinds`.`name` = 'ZTP' AND `template_combinations`.`hostgroup_id` = 0 AND `template_combinations`.`environment_id` = 1 ORDER BY config_templates.name LIMIT 1
  ConfigTemplate Load (1.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` WHERE `operatingsystems`.`id` = 1 AND `template_kinds`.`name` = 'ZTP' AND `template_combinations`.`hostgroup_id` = 0 AND `template_combinations`.`environment_id` IS NULL ORDER BY config_templates.name LIMIT 1
  ConfigTemplate Load (1.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` WHERE `operatingsystems`.`id` = 1 AND `template_kinds`.`name` = 'ZTP' AND `template_combinations`.`hostgroup_id` IS NULL AND `template_combinations`.`environment_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 `os_default_templates` ON `os_default_templates`.`config_template_id` = `config_templates`.`id` WHERE `operatingsystems`.`id` = 1 AND `template_kinds`.`name` = 'ZTP' 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` WHERE `operatingsystems`.`id` = 1 AND `template_kinds`.`name` = 'Bootdisk' AND `template_combinations`.`hostgroup_id` = 0 AND `template_combinations`.`environment_id` = 1 ORDER BY config_templates.name LIMIT 1
  ConfigTemplate Load (1.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` WHERE `operatingsystems`.`id` = 1 AND `template_kinds`.`name` = 'Bootdisk' AND `template_combinations`.`hostgroup_id` = 0 AND `template_combinations`.`environment_id` IS NULL ORDER BY config_templates.name LIMIT 1
  ConfigTemplate Load (1.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` WHERE `operatingsystems`.`id` = 1 AND `template_kinds`.`name` = 'Bootdisk' AND `template_combinations`.`hostgroup_id` IS NULL AND `template_combinations`.`environment_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 `os_default_templates` ON `os_default_templates`.`config_template_id` = `config_templates`.`id` WHERE `operatingsystems`.`id` = 1 AND `template_kinds`.`name` = 'Bootdisk' AND `os_default_templates`.`operatingsystem_id` = 1 ORDER BY config_templates.name LIMIT 1
  TemplateKind Load (0.5ms)  SELECT `template_kinds`.* FROM `template_kinds` WHERE `template_kinds`.`id` = 1 LIMIT 1
  TemplateKind Load (0.5ms)  SELECT `template_kinds`.* FROM `template_kinds` WHERE `template_kinds`.`id` = 4 LIMIT 1
  TemplateKind Load (0.4ms)  SELECT `template_kinds`.* FROM `template_kinds` WHERE `template_kinds`.`id` = 5 LIMIT 1
  Rendered hosts/_provisioning.html.erb (7.2ms)
Completed 200 OK in 222ms (Views: 8.1ms | ActiveRecord: 49.1ms)
Cache read: https://eg-foreman.nd.cmgame.com/discovered_hosts/mac005056ad1d3a?


Started PUT "/discovered_hosts/mac005056ad1d3a" for 192.168.58.12 at 2014-09-29 15:11:16 +0800
Processing by DiscoveredHostsController#update as */*
  Parameters: {"utf8"=>"✓", "authenticity_token"=>"SSQzy6Hk0CB+28KYDjJJ77ZqUQYuka6MlXwpUW+RBJs=", "host"=>{"name"=>"egtest-66-205", "hostgroup_id"=>"", "environment_id"=>"1", "puppet_ca_proxy_id"=>"6", "puppet_proxy_id"=>"4", "puppetclass_ids"=>[""], "managed"=>"true", "progress_report_id"=>"[FILTERED]", "type"=>"Host::Managed", "domain_id"=>"1", "realm_id"=>"", "mac"=>"00:50:56:ad:1d:3a", "subnet_id"=>"4", "ip"=>"192.168.66.205", "interfaces_attributes"=>{"new_interfaces"=>{"_destroy"=>"false", "type"=>"Nic::Managed", "mac"=>"", "name"=>"", "domain_id"=>"", "ip"=>"", "provider"=>"IPMI"}}, "architecture_id"=>"1", "operatingsystem_id"=>"1", "build"=>"1", "medium_id"=>"8", "ptable_id"=>"13", "disk"=>"", "root_pass"=>"[FILTERED]", "is_owned_by"=>"4-Users", "enabled"=>"1", "model_id"=>"1", "comment"=>"", "overwrite"=>"false"}, "id"=>"mac005056ad1d3a"}
  User Load (0.5ms)  SELECT `users`.* FROM `users` WHERE `users`.`id` = 4 LIMIT 1
Setting current user thread-local variable to qianmengshu
Cache read: authorize_login_delegation
Cache read: authorize_login_delegation
Cache read: idle_timeout
  AuthSource Load (0.4ms)  SELECT `auth_sources`.* FROM `auth_sources` WHERE `auth_sources`.`id` = 1 LIMIT 1
  Host::Discovered Load (0.5ms)  SELECT `hosts`.* FROM `hosts` WHERE `hosts`.`type` IN ('Host::Discovered') AND `hosts`.`id` = 0 LIMIT 1
  Host::Discovered Load (0.5ms)  SELECT `hosts`.* FROM `hosts` WHERE `hosts`.`type` IN ('Host::Discovered') AND `hosts`.`name` = 'mac005056ad1d3a' LIMIT 1
Setting current organization thread-local variable to none
Setting current location thread-local variable to none
   (0.3ms)  BEGIN
  Puppetclass Load (0.6ms)  SELECT `puppetclasses`.* FROM `puppetclasses` INNER JOIN `host_classes` ON `puppetclasses`.`id` = `host_classes`.`puppetclass_id` WHERE `host_classes`.`host_id` = 100 ORDER BY puppetclasses.name
  User Load (0.6ms)  SELECT `users`.* FROM `users` WHERE `users`.`id` = 4 ORDER BY firstname LIMIT 1
  Environment Load (0.5ms)  SELECT `environments`.* FROM `environments` WHERE `environments`.`id` = 1 ORDER BY environments.name LIMIT 1
  Environment Load (0.4ms)  SELECT `environments`.* FROM `environments` WHERE `environments`.`id` = 1 ORDER BY environments.name LIMIT 1
  SmartProxy Load (0.5ms)  SELECT `smart_proxies`.* FROM `smart_proxies` WHERE `smart_proxies`.`id` = 6 ORDER BY smart_proxies.name LIMIT 1
  SmartProxy Load (0.4ms)  SELECT `smart_proxies`.* FROM `smart_proxies` WHERE `smart_proxies`.`id` = 6 ORDER BY smart_proxies.name LIMIT 1
  SmartProxy Load (0.5ms)  SELECT `smart_proxies`.* FROM `smart_proxies` WHERE `smart_proxies`.`id` = 4 ORDER BY smart_proxies.name LIMIT 1
  SmartProxy Load (0.4ms)  SELECT `smart_proxies`.* FROM `smart_proxies` WHERE `smart_proxies`.`id` = 4 ORDER BY smart_proxies.name LIMIT 1
  Domain Load (0.5ms)  SELECT `domains`.* FROM `domains` WHERE `domains`.`id` = 1 ORDER BY domains.name LIMIT 1
  Domain Load (0.4ms)  SELECT `domains`.* FROM `domains` WHERE `domains`.`id` = 1 ORDER BY domains.name LIMIT 1
  Architecture Load (0.5ms)  SELECT `architectures`.* FROM `architectures` WHERE `architectures`.`id` = 1 LIMIT 1
  Architecture Load (0.4ms)  SELECT `architectures`.* FROM `architectures` WHERE `architectures`.`id` = 1 LIMIT 1
  Operatingsystem Load (0.5ms)  SELECT `operatingsystems`.* FROM `operatingsystems` WHERE `operatingsystems`.`id` = 1 ORDER BY operatingsystems.name LIMIT 1
  Operatingsystem Load (0.4ms)  SELECT `operatingsystems`.* FROM `operatingsystems` WHERE `operatingsystems`.`id` = 1 ORDER BY operatingsystems.name LIMIT 1
  Medium Load (0.4ms)  SELECT `media`.* FROM `media` WHERE `media`.`id` = 8 ORDER BY media.name LIMIT 1
  Medium Load (0.3ms)  SELECT `media`.* FROM `media` WHERE `media`.`id` = 8 ORDER BY media.name LIMIT 1
  Ptable Load (0.5ms)  SELECT `ptables`.* FROM `ptables` WHERE `ptables`.`id` = 13 ORDER BY ptables.name LIMIT 1
  Ptable Load (0.3ms)  SELECT `ptables`.* FROM `ptables` WHERE `ptables`.`id` = 13 ORDER BY ptables.name LIMIT 1
Cache read: root_pass
Cache read: root_pass
  Subnet Load (0.5ms)  SELECT `subnets`.* FROM `subnets` WHERE `subnets`.`id` = 4 ORDER BY vlanid LIMIT 1
  LookupValue Load (0.5ms)  SELECT `lookup_values`.* FROM `lookup_values` WHERE `lookup_values`.`match` = 'fqdn=egtest-66-205.nd.cmgame.com'
Cache read: use_uuid_for_certificates
  Setting Load (0.5ms)  SELECT `settings`.* FROM `settings` WHERE `settings`.`name` = 'use_uuid_for_certificates' ORDER BY name LIMIT 1
Cache write: use_uuid_for_certificates
Cache read: root_pass
  Host::Base Exists (0.5ms)  SELECT 1 AS one FROM `hosts` WHERE (`hosts`.`name` = BINARY 'egtest-66-205.nd.cmgame.com' AND `hosts`.`id` != 100) LIMIT 1
  SmartProxy Load (0.5ms)  SELECT `smart_proxies`.* FROM `smart_proxies` WHERE `smart_proxies`.`id` = 10 ORDER BY smart_proxies.name LIMIT 1
Cache read: token_duration
  Setting Load (0.5ms)  SELECT `settings`.* FROM `settings` WHERE `settings`.`name` = 'token_duration' ORDER BY name LIMIT 1
Cache write: token_duration
  Host::Managed Exists (0.6ms)  SELECT 1 AS one FROM `hosts` WHERE (`hosts`.`ip` = BINARY '192.168.66.205' AND `hosts`.`id` != 100) LIMIT 1
  Host::Managed Exists (0.5ms)  SELECT 1 AS one FROM `hosts` WHERE (`hosts`.`mac` = BINARY '00:50:56:ad:1d:3a' AND `hosts`.`id` != 100) LIMIT 1
Cache read: root_pass
Cache read: root_pass
Cache read: token_duration
Cache read: ssl_certificate
  Setting Load (0.5ms)  SELECT `settings`.* FROM `settings` WHERE `settings`.`name` = 'ssl_certificate' ORDER BY name LIMIT 1
Cache write: ssl_certificate
Cache read: ssl_ca_file
  Setting Load (0.5ms)  SELECT `settings`.* FROM `settings` WHERE `settings`.`name` = 'ssl_ca_file' ORDER BY name LIMIT 1
Cache write: ssl_ca_file
Cache read: ssl_priv_key
  Setting Load (0.5ms)  SELECT `settings`.* FROM `settings` WHERE `settings`.`name` = 'ssl_priv_key' ORDER BY name LIMIT 1
Cache write: ssl_priv_key
  CACHE (0.0ms)  SELECT `smart_proxies`.* FROM `smart_proxies` WHERE `smart_proxies`.`id` = 10 ORDER BY smart_proxies.name LIMIT 1
Cache read: ssl_certificate
Cache read: ssl_ca_file
Cache read: ssl_priv_key
DHCP records -00:50:56:ad:1d:3a/192.168.66.243 already exists
Cache read: token_duration
  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` WHERE `operatingsystems`.`id` = 1 AND `template_kinds`.`name` = 'PXELinux' AND `template_combinations`.`hostgroup_id` IS NULL AND `template_combinations`.`environment_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 read: manage_puppetca
  Setting Load (0.5ms)  SELECT `settings`.* FROM `settings` WHERE `settings`.`name` = 'manage_puppetca' ORDER BY name LIMIT 1
Cache write: manage_puppetca
Cache read: ssl_certificate
Cache read: ssl_ca_file
Cache read: ssl_priv_key
Queueing Realm
  Ptable Exists (0.7ms)  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` = 13 ORDER BY ptables.name LIMIT 1
  Medium Exists (0.6ms)  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` = 8 ORDER BY media.name LIMIT 1
  Architecture Exists (0.6ms)  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
  Puppetclass Load (0.6ms)  SELECT DISTINCT puppetclasses.id,puppetclasses.name FROM `puppetclasses` INNER JOIN `host_classes` ON `puppetclasses`.`id` = `host_classes`.`puppetclass_id` WHERE `host_classes`.`host_id` = 100 ORDER BY puppetclasses.name
  Host::Base Load (0.7ms)  SELECT `hosts`.* FROM `hosts` WHERE `hosts`.`id` = 100 LIMIT 1
Cache read: token_duration
Cache read: token_duration
  SQL (0.5ms)  INSERT INTO `tokens` (`expires`, `host_id`, `value`) VALUES ('2014-09-29 08:11:17', 100, '6849b2d2-d07c-4057-8f32-42b7aa3d1394')
  Token Load (0.4ms)  SELECT `tokens`.* FROM `tokens` WHERE `tokens`.`host_id` = 100 LIMIT 1
   (0.5ms)  ROLLBACK
Failed to save: Conflict DHCP records -00:50:56:ad:1d:3a/192.168.66.243 already exists
  Rendered hosts/_conflicts.html.erb (1.5ms)
  Rendered hosts/_progress.html.erb (0.2ms)
Setting current organization thread-local variable to none
Setting current location thread-local variable to none
   (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` IN ('Puppet')
  Hostgroup Load (0.5ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE (1=1)
  Environment Load (0.4ms)  SELECT `environments`.* FROM `environments` WHERE (1=1)
   (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` IN ('Puppet CA') AND (1=1)
  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` IN ('Puppet CA') AND (1=1)
   (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` IN ('Puppet') AND (1=1)
  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` IN ('Puppet') AND (1=1)
   (0.3ms)  SELECT COUNT(*) FROM `config_groups` 
   (0.3ms)  SELECT `config_groups`.id FROM `config_groups` INNER JOIN `host_config_groups` ON `config_groups`.`id` = `host_config_groups`.`config_group_id` WHERE `host_config_groups`.`host_id` = 100 AND `host_config_groups`.`host_type` = 'Host::Base' ORDER BY config_groups.name
   (0.3ms)  SELECT puppetclass_id FROM `config_group_classes` WHERE `config_group_classes`.`config_group_id` IN (NULL)
  Puppetclass Load (0.3ms)  SELECT DISTINCT `puppetclasses`.* FROM `puppetclasses` INNER JOIN `environment_classes` ON `puppetclasses`.`id` = `environment_classes`.`puppetclass_id` WHERE `environment_classes`.`environment_id` = 1 AND `puppetclasses`.`id` IN (NULL) ORDER BY puppetclasses.name
  Rendered puppetclasses/_selectedClasses.html.erb (0.0ms)
  CACHE (0.0ms)  SELECT `config_groups`.id FROM `config_groups` INNER JOIN `host_config_groups` ON `config_groups`.`id` = `host_config_groups`.`config_group_id` WHERE `host_config_groups`.`host_id` = 100 AND `host_config_groups`.`host_type` = 'Host::Base' ORDER BY config_groups.name
  CACHE (0.0ms)  SELECT puppetclass_id FROM `config_group_classes` WHERE `config_group_classes`.`config_group_id` IN (NULL)
  CACHE (0.0ms)  SELECT DISTINCT `puppetclasses`.* FROM `puppetclasses` INNER JOIN `environment_classes` ON `puppetclasses`.`id` = `environment_classes`.`puppetclass_id` WHERE `environment_classes`.`environment_id` = 1 AND `puppetclasses`.`id` IN (NULL) ORDER BY puppetclasses.name
  Rendered puppetclasses/_classes_in_groups.html.erb (0.0ms)
  Puppetclass Load (0.4ms)  SELECT DISTINCT `puppetclasses`.* FROM `puppetclasses` INNER JOIN `environment_classes` ON `puppetclasses`.`id` = `environment_classes`.`puppetclass_id` WHERE `environment_classes`.`environment_id` = 1 ORDER BY puppetclasses.name
  CACHE (0.0ms)  SELECT `config_groups`.id FROM `config_groups` INNER JOIN `host_config_groups` ON `config_groups`.`id` = `host_config_groups`.`config_group_id` WHERE `host_config_groups`.`host_id` = 100 AND `host_config_groups`.`host_type` = 'Host::Base' ORDER BY config_groups.name
  CACHE (0.0ms)  SELECT puppetclass_id FROM `config_group_classes` WHERE `config_group_classes`.`config_group_id` IN (NULL)
   (0.3ms)  SELECT puppetclass_id FROM `hostgroup_classes` WHERE `hostgroup_classes`.`hostgroup_id` IS NULL
   (0.3ms)  SELECT puppetclass_id FROM `host_classes` WHERE `host_classes`.`host_id` = 100
  CACHE (0.0ms)  SELECT DISTINCT `puppetclasses`.* FROM `puppetclasses` INNER JOIN `environment_classes` ON `puppetclasses`.`id` = `environment_classes`.`puppetclass_id` WHERE `environment_classes`.`environment_id` = 1 AND `puppetclasses`.`id` IN (NULL) ORDER BY puppetclasses.name
  Rendered puppetclasses/_classes.html.erb (4.3ms)
  Rendered puppetclasses/_class_selection.html.erb (23.2ms)
  Domain Load (0.4ms)  SELECT `domains`.* FROM `domains` WHERE (1=1)
  Realm Load (0.4ms)  SELECT `realms`.* FROM `realms` WHERE (1=1)
   (0.3ms)  SELECT COUNT(*) FROM `subnets` WHERE (1=1)
  CACHE (0.0ms)  SELECT COUNT(*) FROM `subnets` WHERE (1=1)
  Subnet Load (0.4ms)  SELECT `subnets`.* FROM `subnets` WHERE (1=1)
  CACHE (0.0ms)  SELECT `subnets`.* FROM `subnets` WHERE (1=1)
  Rendered common/_domain.html.erb (7.9ms)
  Nic::Base Load (0.4ms)  SELECT `nics`.* FROM `nics` WHERE `nics`.`host_id` = 100
   (0.3ms)  SELECT COUNT(*) FROM `domains` WHERE (1=1)
  CACHE (0.0ms)  SELECT COUNT(*) FROM `domains` WHERE (1=1)
  CACHE (0.0ms)  SELECT `domains`.* FROM `domains` WHERE (1=1)
  Rendered hosts/_interfaces.html.erb (7.8ms)
  Architecture Load (0.3ms)  SELECT `architectures`.* FROM `architectures` 
  Operatingsystem Load (0.4ms)  SELECT `operatingsystems`.* FROM `operatingsystems` INNER JOIN `architectures_operatingsystems` ON `operatingsystems`.`id` = `architectures_operatingsystems`.`operatingsystem_id` WHERE `architectures_operatingsystems`.`architecture_id` = 1 ORDER BY operatingsystems.name
  Rendered common/os_selection/_architecture.html.erb (3.6ms)
   (0.4ms)  SELECT COUNT(*) FROM `media` INNER JOIN `media_operatingsystems` ON `media`.`id` = `media_operatingsystems`.`medium_id` WHERE `media_operatingsystems`.`operatingsystem_id` = 1 AND (1=1)
  Medium Load (0.3ms)  SELECT `media`.* FROM `media` INNER JOIN `media_operatingsystems` ON `media`.`id` = `media_operatingsystems`.`medium_id` WHERE `media_operatingsystems`.`operatingsystem_id` = 1 AND (1=1) ORDER BY media.name
  Ptable Load (0.4ms)  SELECT `ptables`.* FROM `ptables` INNER JOIN `operatingsystems_ptables` ON `ptables`.`id` = `operatingsystems_ptables`.`ptable_id` WHERE `operatingsystems_ptables`.`operatingsystem_id` = 1 ORDER BY ptables.name
  Rendered common/os_selection/_operatingsystem.html.erb (8.6ms)
  Rendered hosts/_operating_system.html.erb (18.0ms)
  Rendered hosts/_unattended.html.erb (43.3ms)
  CACHE (0.0ms)  SELECT `config_groups`.id FROM `config_groups` INNER JOIN `host_config_groups` ON `config_groups`.`id` = `host_config_groups`.`config_group_id` WHERE `host_config_groups`.`host_id` = 100 AND `host_config_groups`.`host_type` = 'Host::Base' ORDER BY config_groups.name
  CACHE (0.0ms)  SELECT puppetclass_id FROM `config_group_classes` WHERE `config_group_classes`.`config_group_id` IN (NULL)
  CACHE (0.0ms)  SELECT puppetclass_id FROM `hostgroup_classes` WHERE `hostgroup_classes`.`hostgroup_id` IS NULL
  CACHE (0.0ms)  SELECT puppetclass_id FROM `host_classes` WHERE `host_classes`.`host_id` = 100
  CACHE (0.0ms)  SELECT DISTINCT `puppetclasses`.* FROM `puppetclasses` INNER JOIN `environment_classes` ON `puppetclasses`.`id` = `environment_classes`.`puppetclass_id` WHERE `environment_classes`.`environment_id` = 1 AND `puppetclasses`.`id` IN (NULL) ORDER BY puppetclasses.name
   (0.4ms)  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.3ms)  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 (6.6ms)
  CommonParameter Load (0.4ms)  SELECT `parameters`.* FROM `parameters` WHERE `parameters`.`type` IN ('CommonParameter') ORDER BY parameters.name
  DomainParameter Load (0.4ms)  SELECT `parameters`.* FROM `parameters` WHERE `parameters`.`type` IN ('DomainParameter') AND `parameters`.`reference_id` = 1 ORDER BY parameters.name
  OsParameter Load (0.4ms)  SELECT `parameters`.* FROM `parameters` WHERE `parameters`.`type` IN ('OsParameter') AND `parameters`.`reference_id` = 1 ORDER BY parameters.name
  Rendered common_parameters/_inherited_parameters.html.erb (0.3ms)
  Rendered common_parameters/_puppetclass_parameter.html.erb (2.2ms)
  Rendered common_parameters/_puppetclasses_parameters.html.erb (3.4ms)
  HostParameter Load (0.3ms)  SELECT `parameters`.* FROM `parameters` WHERE `parameters`.`type` IN ('HostParameter') AND `parameters`.`reference_id` = 100 ORDER BY parameters.name
  Rendered common_parameters/_parameter.html.erb (1.5ms)
  Rendered common_parameters/_parameters.html.erb (4.5ms)
  AuthSourceHidden Load (0.4ms)  SELECT `auth_sources`.* FROM `auth_sources` WHERE `auth_sources`.`type` IN ('AuthSourceHidden')
  User Load (0.4ms)  SELECT `users`.* FROM `users` WHERE (users.auth_source_id <> 3) ORDER BY firstname
  Usergroup Load (0.4ms)  SELECT `usergroups`.* FROM `usergroups` ORDER BY usergroups.name
  Model Load (0.3ms)  SELECT `models`.* FROM `models` ORDER BY models.name
Setting current location thread-local variable to none
Setting current organization thread-local variable to none
  Rendered hosts/_form.html.erb (119.0ms)
  Rendered hosts/edit.html.erb within layouts/application (122.1ms)
Cache read: use_gravatar
  Rendered home/_user_dropdown.html.erb (1.8ms)
Cache read: views/tabs_and_title_records-4
Read fragment views/tabs_and_title_records-4 (0.4ms)
  Rendered home/_topbar.html.erb (2.9ms)
  Rendered layouts/base.html.erb (4.2ms)
Setting current location thread-local variable to none
Setting current organization thread-local variable to none
Completed 200 OK in 1575ms (Views: 117.0ms | ActiveRecord: 37.6ms)
Cache read: https://eg-foreman.nd.cmgame.com/tasks/bcd492de-473f-4992-9ca7-200e1213916b?


Started GET "/tasks/bcd492de-473f-4992-9ca7-200e1213916b" for 192.168.58.12 at 2014-09-29 15:11:18 +0800
Processing by TasksController#show as */*
  Parameters: {"id"=>"bcd492de-473f-4992-9ca7-200e1213916b"}
  User Load (0.5ms)  SELECT `users`.* FROM `users` WHERE `users`.`id` = 4 LIMIT 1
Setting current user thread-local variable to qianmengshu
  AuthSource Load (0.4ms)  SELECT `auth_sources`.* FROM `auth_sources` WHERE `auth_sources`.`id` = 1 LIMIT 1
Cache read: bcd492de-473f-4992-9ca7-200e1213916b
  Rendered tasks/_list.html.erb (0.4ms)
Completed 200 OK in 8ms (Views: 2.9ms | ActiveRecord: 0.9ms)
Cache read: https://eg-foreman.nd.cmgame.com/discovered_hosts/mac005056ad1d3a?


Started PUT "/discovered_hosts/mac005056ad1d3a" for 192.168.58.12 at 2014-09-29 15:11:21 +0800
Processing by DiscoveredHostsController#update as */*
  Parameters: {"utf8"=>"✓", "authenticity_token"=>"SSQzy6Hk0CB+28KYDjJJ77ZqUQYuka6MlXwpUW+RBJs=", "host"=>{"name"=>"egtest-66-205", "hostgroup_id"=>"", "environment_id"=>"1", "puppet_ca_proxy_id"=>"6", "puppet_proxy_id"=>"4", "managed"=>"true", "progress_report_id"=>"[FILTERED]", "type"=>"Host::Managed", "domain_id"=>"1", "realm_id"=>"", "mac"=>"00:50:56:ad:1d:3a", "subnet_id"=>"4", "ip"=>"192.168.66.205", "interfaces_attributes"=>{"new_interfaces"=>{"_destroy"=>"false", "type"=>"Nic::Managed", "mac"=>"", "name"=>"", "domain_id"=>"", "ip"=>"", "provider"=>"IPMI"}}, "architecture_id"=>"1", "build"=>"1", "disk"=>"", "root_pass"=>"[FILTERED]", "is_owned_by"=>"4-Users", "enabled"=>"1", "model_id"=>"1", "comment"=>"", "overwrite"=>"true"}, "discovered_host"=>{"puppetclass_ids"=>[""], "operatingsystem_id"=>"1", "medium_id"=>"8", "ptable_id"=>"13"}, "id"=>"mac005056ad1d3a"}
  User Load (0.4ms)  SELECT `users`.* FROM `users` WHERE `users`.`id` = 4 LIMIT 1
Setting current user thread-local variable to qianmengshu
Cache read: authorize_login_delegation
Cache read: authorize_login_delegation
Cache read: idle_timeout
  AuthSource Load (0.4ms)  SELECT `auth_sources`.* FROM `auth_sources` WHERE `auth_sources`.`id` = 1 LIMIT 1
  Host::Discovered Load (0.4ms)  SELECT `hosts`.* FROM `hosts` WHERE `hosts`.`type` IN ('Host::Discovered') AND `hosts`.`id` = 0 LIMIT 1
  Host::Discovered Load (0.4ms)  SELECT `hosts`.* FROM `hosts` WHERE `hosts`.`type` IN ('Host::Discovered') AND `hosts`.`name` = 'mac005056ad1d3a' LIMIT 1
Setting current organization thread-local variable to none
Setting current location thread-local variable to none
   (0.3ms)  BEGIN
  User Load (0.4ms)  SELECT `users`.* FROM `users` WHERE `users`.`id` = 4 ORDER BY firstname LIMIT 1
  Environment Load (0.4ms)  SELECT `environments`.* FROM `environments` WHERE `environments`.`id` = 1 ORDER BY environments.name LIMIT 1
  Environment Load (0.4ms)  SELECT `environments`.* FROM `environments` WHERE `environments`.`id` = 1 ORDER BY environments.name LIMIT 1
  SmartProxy Load (0.3ms)  SELECT `smart_proxies`.* FROM `smart_proxies` WHERE `smart_proxies`.`id` = 6 ORDER BY smart_proxies.name LIMIT 1
  SmartProxy Load (0.4ms)  SELECT `smart_proxies`.* FROM `smart_proxies` WHERE `smart_proxies`.`id` = 6 ORDER BY smart_proxies.name LIMIT 1
  SmartProxy Load (0.4ms)  SELECT `smart_proxies`.* FROM `smart_proxies` WHERE `smart_proxies`.`id` = 4 ORDER BY smart_proxies.name LIMIT 1
  SmartProxy Load (0.4ms)  SELECT `smart_proxies`.* FROM `smart_proxies` WHERE `smart_proxies`.`id` = 4 ORDER BY smart_proxies.name LIMIT 1
  Domain Load (0.4ms)  SELECT `domains`.* FROM `domains` WHERE `domains`.`id` = 1 ORDER BY domains.name LIMIT 1
  Domain Load (0.4ms)  SELECT `domains`.* FROM `domains` WHERE `domains`.`id` = 1 ORDER BY domains.name LIMIT 1
  Architecture Load (0.3ms)  SELECT `architectures`.* FROM `architectures` WHERE `architectures`.`id` = 1 LIMIT 1
  Architecture Load (0.4ms)  SELECT `architectures`.* FROM `architectures` WHERE `architectures`.`id` = 1 LIMIT 1
Cache read: root_pass
Cache read: root_pass
  Subnet Load (0.4ms)  SELECT `subnets`.* FROM `subnets` WHERE `subnets`.`id` = 4 ORDER BY vlanid LIMIT 1
  LookupValue Load (0.3ms)  SELECT `lookup_values`.* FROM `lookup_values` WHERE `lookup_values`.`match` = 'fqdn=egtest-66-205.nd.cmgame.com'
Cache read: use_uuid_for_certificates
Cache read: root_pass
  Host::Base Exists (0.4ms)  SELECT 1 AS one FROM `hosts` WHERE (`hosts`.`name` = BINARY 'egtest-66-205.nd.cmgame.com' AND `hosts`.`id` != 100) LIMIT 1
  SmartProxy Load (0.4ms)  SELECT `smart_proxies`.* FROM `smart_proxies` WHERE `smart_proxies`.`id` = 10 ORDER BY smart_proxies.name LIMIT 1
Cache read: token_duration
  Host::Managed Exists (0.3ms)  SELECT 1 AS one FROM `hosts` WHERE (`hosts`.`ip` = BINARY '192.168.66.205' AND `hosts`.`id` != 100) LIMIT 1
  Host::Managed Exists (0.3ms)  SELECT 1 AS one FROM `hosts` WHERE (`hosts`.`mac` = BINARY '00:50:56:ad:1d:3a' AND `hosts`.`id` != 100) LIMIT 1
Cache read: root_pass
Cache read: root_pass
Cache read: token_duration
   (0.3ms)  ROLLBACK
Setting current location thread-local variable to none
Setting current organization thread-local variable to none
Operation FAILED: undefined method `boot_filename' for nil:NilClass
/usr/share/foreman/app/models/concerns/orchestration/dhcp.rb:60:in `dhcp_attrs'
/usr/share/foreman/app/models/concerns/orchestration/dhcp.rb:16:in `dhcp_record'
/usr/share/foreman/app/models/concerns/orchestration/dhcp.rb:140:in `dhcp_conflict_detected?'
/opt/rh/ruby193/root/usr/share/gems/gems/activesupport-3.2.8/lib/active_support/callbacks.rb:504:in `_run__4446722488266563208__validation__3119315023785256509__callbacks'
/opt/rh/ruby193/root/usr/share/gems/gems/activesupport-3.2.8/lib/active_support/callbacks.rb:405:in `__run_callback'
/opt/rh/ruby193/root/usr/share/gems/gems/activesupport-3.2.8/lib/active_support/callbacks.rb:385:in `_run_validation_callbacks'
/opt/rh/ruby193/root/usr/share/gems/gems/activesupport-3.2.8/lib/active_support/callbacks.rb:81:in `run_callbacks'
/opt/rh/ruby193/root/usr/share/gems/gems/activemodel-3.2.8/lib/active_model/validations/callbacks.rb:53:in `run_validations!'
/opt/rh/ruby193/root/usr/share/gems/gems/activemodel-3.2.8/lib/active_model/validations.rb:194:in `valid?'
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/validations.rb:69:in `valid?'
/usr/share/foreman/app/models/concerns/orchestration.rb:47:in `valid?'
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/validations.rb:77:in `perform_validations'
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/validations.rb:50:in `save'
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/attribute_methods/dirty.rb:22:in `save'
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/transactions.rb:241:in `block (2 levels) in save'
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/transactions.rb:295:in `block in with_transaction_returning_status'
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/connection_adapters/abstract/database_statements.rb:192:in `transaction'
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/transactions.rb:208:in `transaction'
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/transactions.rb:293:in `with_transaction_returning_status'
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/transactions.rb:241:in `block in save'
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/transactions.rb:252:in `rollback_active_record_state!'
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/transactions.rb:240:in `save'
/usr/share/foreman/app/models/concerns/foreman/sti.rb:29:in `save_with_type'
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/persistence.rb:216:in `block in update_attributes'
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/transactions.rb:295:in `block in with_transaction_returning_status'
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/connection_adapters/abstract/database_statements.rb:192:in `transaction'
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/transactions.rb:208:in `transaction'
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/transactions.rb:293:in `with_transaction_returning_status'
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/persistence.rb:214:in `update_attributes'
/opt/rh/ruby193/root/usr/share/gems/gems/foreman_discovery-1.4.0.rc3/app/controllers/discovered_hosts_controller.rb:74:in `block in update'
/usr/share/foreman/app/models/taxonomy.rb:44:in `block in no_taxonomy_scope'
/usr/share/foreman/app/models/taxonomy.rb:51:in `block (2 levels) in as_taxonomy'
/usr/share/foreman/app/models/concerns/foreman/thread_session.rb:148:in `as_location'
/usr/share/foreman/app/models/taxonomy.rb:50:in `block in as_taxonomy'
/usr/share/foreman/app/models/concerns/foreman/thread_session.rb:113:in `as_org'
/usr/share/foreman/app/models/taxonomy.rb:49:in `as_taxonomy'
/usr/share/foreman/app/models/taxonomy.rb:43:in `no_taxonomy_scope'
/opt/rh/ruby193/root/usr/share/gems/gems/foreman_discovery-1.4.0.rc3/app/controllers/discovered_hosts_controller.rb:73:in `update'
/opt/rh/ruby193/root/usr/share/gems/gems/actionpack-3.2.8/lib/action_controller/metal/implicit_render.rb:4:in `send_action'
/opt/rh/ruby193/root/usr/share/gems/gems/actionpack-3.2.8/lib/abstract_controller/base.rb:167:in `process_action'
/opt/rh/ruby193/root/usr/share/gems/gems/actionpack-3.2.8/lib/action_controller/metal/rendering.rb:10:in `process_action'
/opt/rh/ruby193/root/usr/share/gems/gems/actionpack-3.2.8/lib/abstract_controller/callbacks.rb:18:in `block in process_action'
/opt/rh/ruby193/root/usr/share/gems/gems/activesupport-3.2.8/lib/active_support/callbacks.rb:549:in `block (3 levels) in _run__3856820073561562779__process_action__186551469298903594__callbacks'
/opt/rh/ruby193/root/usr/share/gems/gems/activesupport-3.2.8/lib/active_support/callbacks.rb:215:in `block in _conditional_callback_around_6994'
/opt/rh/ruby193/root/usr/share/gems/gems/activesupport-3.2.8/lib/active_support/callbacks.rb:326:in `around'
/opt/rh/ruby193/root/usr/share/gems/gems/activesupport-3.2.8/lib/active_support/callbacks.rb:310:in `_callback_around_1823'
/opt/rh/ruby193/root/usr/share/gems/gems/activesupport-3.2.8/lib/active_support/callbacks.rb:214:in `_conditional_callback_around_6994'
/opt/rh/ruby193/root/usr/share/gems/gems/activesupport-3.2.8/lib/active_support/callbacks.rb:537:in `block (2 levels) in _run__3856820073561562779__process_action__186551469298903594__callbacks'
/opt/rh/ruby193/root/usr/share/gems/gems/activesupport-3.2.8/lib/active_support/callbacks.rb:215:in `block in _conditional_callback_around_6993'
/usr/share/foreman/app/models/concerns/foreman/thread_session.rb:33:in `clear_thread'
/opt/rh/ruby193/root/usr/share/gems/gems/activesupport-3.2.8/lib/active_support/callbacks.rb:214:in `_conditional_callback_around_6993'
/opt/rh/ruby193/root/usr/share/gems/gems/activesupport-3.2.8/lib/active_support/callbacks.rb:426:in `block in _run__3856820073561562779__process_action__186551469298903594__callbacks'
/opt/rh/ruby193/root/usr/share/gems/gems/activesupport-3.2.8/lib/active_support/callbacks.rb:215:in `block in _conditional_callback_around_6992'
/opt/rh/ruby193/root/usr/share/gems/gems/activesupport-3.2.8/lib/active_support/callbacks.rb:326:in `around'
/opt/rh/ruby193/root/usr/share/gems/gems/activesupport-3.2.8/lib/active_support/callbacks.rb:310:in `_callback_around_13'
/opt/rh/ruby193/root/usr/share/gems/gems/activesupport-3.2.8/lib/active_support/callbacks.rb:214:in `_conditional_callback_around_6992'
/opt/rh/ruby193/root/usr/share/gems/gems/activesupport-3.2.8/lib/active_support/callbacks.rb:414:in `_run__3856820073561562779__process_action__186551469298903594__callbacks'
/opt/rh/ruby193/root/usr/share/gems/gems/activesupport-3.2.8/lib/active_support/callbacks.rb:405:in `__run_callback'
/opt/rh/ruby193/root/usr/share/gems/gems/activesupport-3.2.8/lib/active_support/callbacks.rb:385:in `_run_process_action_callbacks'
/opt/rh/ruby193/root/usr/share/gems/gems/activesupport-3.2.8/lib/active_support/callbacks.rb:81:in `run_callbacks'
/opt/rh/ruby193/root/usr/share/gems/gems/actionpack-3.2.8/lib/abstract_controller/callbacks.rb:17:in `process_action'
/opt/rh/ruby193/root/usr/share/gems/gems/actionpack-3.2.8/lib/action_controller/metal/rescue.rb:29:in `process_action'
/opt/rh/ruby193/root/usr/share/gems/gems/actionpack-3.2.8/lib/action_controller/metal/instrumentation.rb:30:in `block in process_action'
/opt/rh/ruby193/root/usr/share/gems/gems/activesupport-3.2.8/lib/active_support/notifications.rb:123:in `block in instrument'
/opt/rh/ruby193/root/usr/share/gems/gems/activesupport-3.2.8/lib/active_support/notifications/instrumenter.rb:20:in `instrument'
/opt/rh/ruby193/root/usr/share/gems/gems/activesupport-3.2.8/lib/active_support/notifications.rb:123:in `instrument'
/opt/rh/ruby193/root/usr/share/gems/gems/actionpack-3.2.8/lib/action_controller/metal/instrumentation.rb:29:in `process_action'
/opt/rh/ruby193/root/usr/share/gems/gems/actionpack-3.2.8/lib/action_controller/metal/params_wrapper.rb:207:in `process_action'
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/railties/controller_runtime.rb:18:in `process_action'
/opt/rh/ruby193/root/usr/share/gems/gems/actionpack-3.2.8/lib/abstract_controller/base.rb:121:in `process'
/opt/rh/ruby193/root/usr/share/gems/gems/actionpack-3.2.8/lib/abstract_controller/rendering.rb:45:in `process'
/opt/rh/ruby193/root/usr/share/gems/gems/actionpack-3.2.8/lib/action_controller/metal.rb:203:in `dispatch'
/opt/rh/ruby193/root/usr/share/gems/gems/actionpack-3.2.8/lib/action_controller/metal/rack_delegation.rb:14:in `dispatch'
/opt/rh/ruby193/root/usr/share/gems/gems/actionpack-3.2.8/lib/action_controller/metal.rb:246:in `block in action'
/opt/rh/ruby193/root/usr/share/gems/gems/actionpack-3.2.8/lib/action_dispatch/routing/route_set.rb:73:in `call'
/opt/rh/ruby193/root/usr/share/gems/gems/actionpack-3.2.8/lib/action_dispatch/routing/route_set.rb:73:in `dispatch'
/opt/rh/ruby193/root/usr/share/gems/gems/actionpack-3.2.8/lib/action_dispatch/routing/route_set.rb:36:in `call'
/opt/rh/ruby193/root/usr/share/gems/gems/journey-1.0.4/lib/journey/router.rb:68:in `block in call'
/opt/rh/ruby193/root/usr/share/gems/gems/journey-1.0.4/lib/journey/router.rb:56:in `each'
/opt/rh/ruby193/root/usr/share/gems/gems/journey-1.0.4/lib/journey/router.rb:56:in `call'
/opt/rh/ruby193/root/usr/share/gems/gems/actionpack-3.2.8/lib/action_dispatch/routing/route_set.rb:600:in `call'
/opt/rh/ruby193/root/usr/share/gems/gems/apipie-rails-0.2.5/lib/apipie/extractor/recorder.rb:97:in `call'
/opt/rh/ruby193/root/usr/share/gems/gems/apipie-rails-0.2.5/lib/apipie/middleware/checksum_in_headers.rb:27:in `call'
/opt/rh/ruby193/root/usr/share/gems/gems/actionpack-3.2.8/lib/action_dispatch/middleware/best_standards_support.rb:17:in `call'
/opt/rh/ruby193/root/usr/share/gems/gems/rack-1.4.1/lib/rack/etag.rb:23:in `call'
/opt/rh/ruby193/root/usr/share/gems/gems/rack-1.4.1/lib/rack/conditionalget.rb:35:in `call'
/opt/rh/ruby193/root/usr/share/gems/gems/actionpack-3.2.8/lib/action_dispatch/middleware/head.rb:14:in `call'
/opt/rh/ruby193/root/usr/share/gems/gems/actionpack-3.2.8/lib/action_dispatch/middleware/params_parser.rb:21:in `call'
/usr/share/foreman/lib/middleware/catch_json_parse_errors.rb:9:in `call'
/opt/rh/ruby193/root/usr/share/gems/gems/actionpack-3.2.8/lib/action_dispatch/middleware/flash.rb:242:in `call'
/opt/rh/ruby193/root/usr/share/gems/gems/rack-1.4.1/lib/rack/session/abstract/id.rb:205:in `context'
/opt/rh/ruby193/root/usr/share/gems/gems/rack-1.4.1/lib/rack/session/abstract/id.rb:200:in `call'
/opt/rh/ruby193/root/usr/share/gems/gems/actionpack-3.2.8/lib/action_dispatch/middleware/cookies.rb:339:in `call'
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/query_cache.rb:64:in `call'
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/connection_adapters/abstract/connection_pool.rb:473:in `call'
/opt/rh/ruby193/root/usr/share/gems/gems/actionpack-3.2.8/lib/action_dispatch/middleware/callbacks.rb:28:in `block in call'
/opt/rh/ruby193/root/usr/share/gems/gems/activesupport-3.2.8/lib/active_support/callbacks.rb:405:in `_run__81727238673657433__call__3119315023785256509__callbacks'
/opt/rh/ruby193/root/usr/share/gems/gems/activesupport-3.2.8/lib/active_support/callbacks.rb:405:in `__run_callback'
/opt/rh/ruby193/root/usr/share/gems/gems/activesupport-3.2.8/lib/active_support/callbacks.rb:385:in `_run_call_callbacks'
/opt/rh/ruby193/root/usr/share/gems/gems/activesupport-3.2.8/lib/active_support/callbacks.rb:81:in `run_callbacks'
/opt/rh/ruby193/root/usr/share/gems/gems/actionpack-3.2.8/lib/action_dispatch/middleware/callbacks.rb:27:in `call'
/opt/rh/ruby193/root/usr/share/gems/gems/actionpack-3.2.8/lib/action_dispatch/middleware/remote_ip.rb:31:in `call'
/opt/rh/ruby193/root/usr/share/gems/gems/actionpack-3.2.8/lib/action_dispatch/middleware/debug_exceptions.rb:16:in `call'
/opt/rh/ruby193/root/usr/share/gems/gems/actionpack-3.2.8/lib/action_dispatch/middleware/show_exceptions.rb:56:in `call'
/opt/rh/ruby193/root/usr/share/gems/gems/railties-3.2.8/lib/rails/rack/logger.rb:26:in `call_app'
/opt/rh/ruby193/root/usr/share/gems/gems/railties-3.2.8/lib/rails/rack/logger.rb:16:in `call'
/opt/rh/ruby193/root/usr/share/gems/gems/actionpack-3.2.8/lib/action_dispatch/middleware/request_id.rb:22:in `call'
/opt/rh/ruby193/root/usr/share/gems/gems/rack-1.4.1/lib/rack/methodoverride.rb:21:in `call'
/opt/rh/ruby193/root/usr/share/gems/gems/rack-1.4.1/lib/rack/runtime.rb:17:in `call'
/opt/rh/ruby193/root/usr/share/gems/gems/activesupport-3.2.8/lib/active_support/cache/strategy/local_cache.rb:72:in `call'
/opt/rh/ruby193/root/usr/share/gems/gems/rack-1.4.1/lib/rack/lock.rb:15:in `call'
/opt/rh/ruby193/root/usr/share/gems/gems/actionpack-3.2.8/lib/action_dispatch/middleware/static.rb:62:in `call'
/opt/rh/ruby193/root/usr/share/gems/gems/rack-cache-1.2/lib/rack/cache/context.rb:136:in `forward'
/opt/rh/ruby193/root/usr/share/gems/gems/rack-cache-1.2/lib/rack/cache/context.rb:143:in `pass'
/opt/rh/ruby193/root/usr/share/gems/gems/rack-cache-1.2/lib/rack/cache/context.rb:155:in `invalidate'
/opt/rh/ruby193/root/usr/share/gems/gems/rack-cache-1.2/lib/rack/cache/context.rb:71:in `call!'
/opt/rh/ruby193/root/usr/share/gems/gems/rack-cache-1.2/lib/rack/cache/context.rb:51:in `call'
/opt/rh/ruby193/root/usr/share/gems/gems/railties-3.2.8/lib/rails/engine.rb:479:in `call'
/opt/rh/ruby193/root/usr/share/gems/gems/railties-3.2.8/lib/rails/application.rb:223:in `call'
/opt/rh/ruby193/root/usr/share/gems/gems/railties-3.2.8/lib/rails/railtie/configurable.rb:30:in `method_missing'
/opt/rh/ruby193/root/usr/share/gems/gems/rack-1.4.1/lib/rack/builder.rb:134:in `call'
/opt/rh/ruby193/root/usr/share/gems/gems/rack-1.4.1/lib/rack/urlmap.rb:64:in `block in call'
/opt/rh/ruby193/root/usr/share/gems/gems/rack-1.4.1/lib/rack/urlmap.rb:49:in `each'
/opt/rh/ruby193/root/usr/share/gems/gems/rack-1.4.1/lib/rack/urlmap.rb:49:in `call'
/usr/lib/ruby/gems/1.8/gems/passenger-4.0.42/lib/phusion_passenger/rack/thread_handler_extension.rb:74:in `process_request'
/usr/lib/ruby/gems/1.8/gems/passenger-4.0.42/lib/phusion_passenger/request_handler/thread_handler.rb:141:in `accept_and_process_next_request'
/usr/lib/ruby/gems/1.8/gems/passenger-4.0.42/lib/phusion_passenger/request_handler/thread_handler.rb:109:in `main_loop'
/usr/lib/ruby/gems/1.8/gems/passenger-4.0.42/lib/phusion_passenger/request_handler.rb:448:in `block (3 levels) in start_threads'
  Rendered common/500.html.erb (117.9ms)
Completed 500 Internal Server Error in 164ms (Views: 120.0ms | ActiveRecord: 8.3ms)
Cache read: https://eg-foreman.nd.cmgame.com/discovered_hosts/mac005056ad1d3a/edit?


Started GET "/discovered_hosts/mac005056ad1d3a/edit" for 192.168.58.12 at 2014-09-29 15:11:23 +0800
Processing by DiscoveredHostsController#edit as */*
  Parameters: {"id"=>"mac005056ad1d3a"}
  User Load (0.5ms)  SELECT `users`.* FROM `users` WHERE `users`.`id` = 4 LIMIT 1
Setting current user thread-local variable to qianmengshu
Cache read: authorize_login_delegation
Cache read: authorize_login_delegation
Cache read: idle_timeout
  AuthSource Load (0.4ms)  SELECT `auth_sources`.* FROM `auth_sources` WHERE `auth_sources`.`id` = 1 LIMIT 1
  Host::Discovered Load (0.5ms)  SELECT `hosts`.* FROM `hosts` WHERE `hosts`.`type` IN ('Host::Discovered') AND `hosts`.`id` = 0 LIMIT 1
  Host::Discovered Load (0.5ms)  SELECT `hosts`.* FROM `hosts` WHERE `hosts`.`type` IN ('Host::Discovered') AND `hosts`.`name` = 'mac005056ad1d3a' LIMIT 1
  Rendered hosts/_progress.html.erb (0.1ms)
Setting current organization thread-local variable to none
Setting current location thread-local variable to none
   (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` IN ('Puppet')
  Hostgroup Load (0.4ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE (1=1)
  Environment Load (0.4ms)  SELECT `environments`.* FROM `environments` WHERE (1=1)
   (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` IN ('Puppet CA') AND (1=1)
  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` IN ('Puppet CA') AND (1=1)
   (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` IN ('Puppet') AND (1=1)
  SmartProxy Load (0.3ms)  SELECT `smart_proxies`.* FROM `smart_proxies` INNER JOIN `features_smart_proxies` ON `features_smart_proxies`.`smart_proxy_id` = `smart_proxies`.`id` INNER JOIN `features` ON `features`.`id` = `features_smart_proxies`.`feature_id` WHERE `features`.`name` IN ('Puppet') AND (1=1)
  Domain Load (0.3ms)  SELECT `domains`.* FROM `domains` WHERE (1=1)
  Realm Load (0.4ms)  SELECT `realms`.* FROM `realms` WHERE (1=1)
  Rendered common/_domain.html.erb (1.6ms)
  Nic::Base Load (0.4ms)  SELECT `nics`.* FROM `nics` WHERE `nics`.`host_id` = 100
   (0.4ms)  SELECT COUNT(*) FROM `domains` WHERE (1=1)
  CACHE (0.0ms)  SELECT COUNT(*) FROM `domains` WHERE (1=1)
  CACHE (0.0ms)  SELECT `domains`.* FROM `domains` WHERE (1=1)
  Rendered hosts/_interfaces.html.erb (7.7ms)
  Architecture Load (0.3ms)  SELECT `architectures`.* FROM `architectures` 
  Rendered common/os_selection/_architecture.html.erb (1.7ms)
  Rendered common/os_selection/_operatingsystem.html.erb (2.5ms)
  Rendered hosts/_operating_system.html.erb (9.6ms)
  Rendered hosts/_unattended.html.erb (27.9ms)
   (0.3ms)  SELECT `config_groups`.id FROM `config_groups` INNER JOIN `host_config_groups` ON `config_groups`.`id` = `host_config_groups`.`config_group_id` WHERE `host_config_groups`.`host_id` = 100 AND `host_config_groups`.`host_type` = 'Host::Base' ORDER BY config_groups.name
   (0.3ms)  SELECT puppetclass_id FROM `config_group_classes` WHERE `config_group_classes`.`config_group_id` IN (NULL)
   (0.3ms)  SELECT puppetclass_id FROM `hostgroup_classes` WHERE `hostgroup_classes`.`hostgroup_id` IS NULL
   (0.3ms)  SELECT puppetclass_id FROM `host_classes` WHERE `host_classes`.`host_id` = 100
  Puppetclass Load (0.4ms)  SELECT `puppetclasses`.* FROM `puppetclasses` WHERE `puppetclasses`.`id` IN (NULL) ORDER BY puppetclasses.name
   (0.4ms)  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 (8.5ms)
  CommonParameter Load (0.3ms)  SELECT `parameters`.* FROM `parameters` WHERE `parameters`.`type` IN ('CommonParameter') ORDER BY parameters.name
  Rendered common_parameters/_inherited_parameters.html.erb (0.3ms)
  LookupValue Load (0.3ms)  SELECT `lookup_values`.* FROM `lookup_values` WHERE `lookup_values`.`match` = 'fqdn=mac005056ad1d3a'
  Rendered common_parameters/_puppetclass_parameter.html.erb (2.4ms)
  Rendered common_parameters/_puppetclasses_parameters.html.erb (4.4ms)
  HostParameter Load (0.4ms)  SELECT `parameters`.* FROM `parameters` WHERE `parameters`.`type` IN ('HostParameter') AND `parameters`.`reference_id` = 100 ORDER BY parameters.name
  Rendered common_parameters/_parameter.html.erb (1.5ms)
  Rendered common_parameters/_parameters.html.erb (4.7ms)
  AuthSourceHidden Load (0.4ms)  SELECT `auth_sources`.* FROM `auth_sources` WHERE `auth_sources`.`type` IN ('AuthSourceHidden')
  User Load (0.4ms)  SELECT `users`.* FROM `users` WHERE (users.auth_source_id <> 3) ORDER BY firstname
  Usergroup Load (0.4ms)  SELECT `usergroups`.* FROM `usergroups` ORDER BY usergroups.name
  Model Load (0.4ms)  SELECT `models`.* FROM `models` ORDER BY models.name
Setting current location thread-local variable to none
Setting current organization thread-local variable to none
  Rendered hosts/_form.html.erb (78.9ms)
  Rendered hosts/edit.html.erb within layouts/application (80.9ms)
Cache read: use_gravatar
  Rendered home/_user_dropdown.html.erb (1.8ms)
Cache read: views/tabs_and_title_records-4
Read fragment views/tabs_and_title_records-4 (0.4ms)
  Rendered home/_topbar.html.erb (3.0ms)
  Rendered layouts/base.html.erb (4.4ms)
Completed 200 OK in 96ms (Views: 77.0ms | ActiveRecord: 11.2ms)
Cache read: https://eg-foreman.nd.cmgame.com/discovered_hosts?


Started GET "/discovered_hosts" for 192.168.58.12 at 2014-09-29 15:11:44 +0800
Processing by DiscoveredHostsController#index as HTML
  User Load (0.5ms)  SELECT `users`.* FROM `users` WHERE `users`.`id` = 4 LIMIT 1
Setting current user thread-local variable to qianmengshu
Cache read: authorize_login_delegation
Cache read: authorize_login_delegation
Cache read: idle_timeout
  AuthSource Load (0.4ms)  SELECT `auth_sources`.* FROM `auth_sources` WHERE `auth_sources`.`id` = 1 LIMIT 1
Cache read: entries_per_page
  Host::Discovered Load (0.5ms)  SELECT `hosts`.* FROM `hosts` WHERE `hosts`.`type` IN ('Host::Discovered') ORDER BY `hosts`.`name` ASC LIMIT 20 OFFSET 0
  Model Load (0.4ms)  SELECT `models`.* FROM `models` WHERE `models`.`id` = 1 ORDER BY models.name LIMIT 1
  Subnet Load (0.4ms)  SELECT `subnets`.* FROM `subnets` WHERE `subnets`.`id` = 4 ORDER BY vlanid LIMIT 1
  Rendered /opt/rh/ruby193/root/usr/share/gems/gems/foreman_discovery-1.4.0.rc3/app/views/discovered_hosts/_discovered_hosts_list.html.erb (14.2ms)
  Rendered /opt/rh/ruby193/root/usr/share/gems/gems/foreman_discovery-1.4.0.rc3/app/views/discovered_hosts/index.html.erb within layouts/application (15.3ms)
  Bookmark Load (0.4ms)  SELECT `bookmarks`.* FROM `bookmarks` WHERE (((bookmarks.public = 1) OR (bookmarks.owner_id = 4 AND bookmarks.owner_type = 'User'))) AND (controller = 'discovered_hosts') ORDER BY name
  Rendered common/_searchbar.html.erb (2.8ms)
Cache read: use_gravatar
  Rendered home/_user_dropdown.html.erb (1.7ms)
Cache read: views/tabs_and_title_records-4
Read fragment views/tabs_and_title_records-4 (0.3ms)
  Rendered home/_topbar.html.erb (2.7ms)
  Rendered layouts/base.html.erb (4.0ms)
Completed 200 OK in 30ms (Views: 21.8ms | ActiveRecord: 2.6ms)