I cannot find a link where I can download the RPM, can you please help? The installation is only to install the RPM? Is it necessary to upgrade Foreman as well? I'm running now 14.3
On Friday, June 16, 2017 at 12:03:03 PM UTC+3, Lukas Zapletal wrote: > > No ETA yet, you can use this scratchbuild it will work: > http://koji.katello.org/koji/taskinfo?taskID=6018 > > Report back if it fixes your issue. > > LZ > > On Tue, Jun 13, 2017 at 1:32 PM, Ido Kaplan <kapla...@gmail.com > <javascript:>> wrote: > > Ok, thank you for the update. > > Is there a fix for this issue? > > When it should be released? > > > > > > On Monday, June 12, 2017 at 9:16:37 AM UTC+3, Ido Kaplan wrote: > >> > >> Hi, > >> > >> Foreman version 1.14.3, Discovery plugin version 8.0.1. > >> > >> During provisioning a server with multiple interfaces, domain is not > set > >> from a host group. > >> Error - Failed to save: Domain can't be blank, Interfaces.domain can't > >> find domain with this id > >> The same issue like this bug - > http://projects.theforeman.org/issues/19445 > >> Can you please advise? > >> > >> 2017-06-11 13:41:16 f825c503 [app] [I] Started GET > >> > "/discovered_hosts/mac000000000000/edit?utf8=%E2%9C%93&host%5Bhostgroup_id%5D=1" > > > >> for 1.1.1.1 at 2017-06-11 13:41:16 +0000 > >> 2017-06-11 13:41:16 f825c503 [app] [I] Processing by > >> DiscoveredHostsController#edit as HTML > >> 2017-06-11 13:41:16 f825c503 [app] [I] Parameters: {"utf8"=>"✓", > >> "host"=>{"hostgroup_id"=>"1"}, "id"=>"mac000000000000"} > >> 2017-06-11 13:41:16 f825c503 [sql] [D] > >> ActiveRecord::SessionStore::Session Load (0.9ms) SELECT "sessions".* > FROM > >> "sessions" WHERE "sessions"."session_id" = $1 ORDER BY "sessions"."id" > ASC > >> LIMIT 1 [["session_id", "f825c5039243217a9989ad65570411fe"]] > >> 2017-06-11 13:41:16 f825c503 [sql] [D] User Load (0.8ms) SELECT > >> "users".* FROM "users" WHERE "users"."id" = $1 LIMIT 1 [["id", 3]] > >> 2017-06-11 13:41:16 f825c503 [app] [D] Setting current user > thread-local > >> variable to admin > >> 2017-06-11 13:41:16 f825c503 [sql] [D] AuthSource Load (0.7ms) > SELECT > >> "auth_sources".* FROM "auth_sources" WHERE "auth_sources"."id" = $1 > LIMIT 1 > >> [["id", 1]] > >> 2017-06-11 13:41:16 f825c503 [sql] [D] Host::Discovered Load (0.9ms) > >> SELECT "hosts".* FROM "hosts" WHERE "hosts"."type" IN > ('Host::Discovered') > >> AND "hosts"."id" = $1 ORDER BY hosts.created_at DESC LIMIT 1 [["id", > 0]] > >> 2017-06-11 13:41:16 f825c503 [sql] [D] Host::Discovered Load (1.0ms) > >> SELECT "hosts".* FROM "hosts" WHERE "hosts"."type" IN > ('Host::Discovered') > >> AND "hosts"."name" = $1 ORDER BY hosts.created_at DESC LIMIT 1 > [["name", > >> "mac000000000000"]] > >> 2017-06-11 13:41:16 f825c503 [sql] [D] Nic::Base Load (0.9ms) SELECT > >> "nics".* FROM "nics" WHERE "nics"."host_id" = $1 ORDER BY > >> "nics"."identifier" ASC [["host_id", 12]] > >> 2017-06-11 13:41:16 f825c503 [sql] [D] (0.2ms) BEGIN > >> 2017-06-11 13:41:16 f825c503 [sql] [D] Subnet Load (0.7ms) SELECT > >> "subnets".* FROM "subnets" WHERE "subnets"."id" = $1 AND > "subnets"."type" = > >> $2 ORDER BY vlanid LIMIT 1 [["id", 1], ["type", "Subnet::Ipv4"]] > >> 2017-06-11 13:41:16 f825c503 [sql] [D] Nic::Base Load (0.6ms) SELECT > >> "nics".* FROM "nics" WHERE "nics"."ip" = $1 [["ip", "2.2.2.2"]] > >> 2017-06-11 13:41:16 f825c503 [sql] [D] Nic::Base Load (0.6ms) SELECT > >> "nics".* FROM "nics" WHERE "nics"."domain_id" IS NULL AND "nics"."name" > = $1 > >> [["name", "mac000000000000"]] > >> 2017-06-11 13:41:16 f825c503 [sql] [D] Using host queue > >> 2017-06-11 13:41:16 f825c503 [sql] [D] Using host queue > >> 2017-06-11 13:41:16 f825c503 [sql] [D] Using host queue > >> 2017-06-11 13:41:16 f825c503 [sql] [D] Using host queue > >> 2017-06-11 13:41:16 f825c503 [sql] [D] Nic::Base Load (0.5ms) SELECT > >> "nics".* FROM "nics" WHERE "nics"."ip" = $1 [["ip", "192.168.0.120"]] > >> 2017-06-11 13:41:16 f825c503 [sql] [D] Using host queue > >> 2017-06-11 13:41:16 f825c503 [sql] [D] Using host queue > >> 2017-06-11 13:41:16 f825c503 [sql] [D] Using host queue > >> 2017-06-11 13:41:16 f825c503 [sql] [D] (0.4ms) COMMIT > >> 2017-06-11 13:41:16 f825c503 [sql] [D] Hostgroup Load (0.8ms) SELECT > >> "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."title" = $1 ORDER > BY > >> hostgroups.title LIMIT 1 [["title", "1"]] > >> 2017-06-11 13:41:16 f825c503 [sql] [D] Hostgroup Load (0.9ms) SELECT > >> "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" = $1 ORDER BY > >> hostgroups.title LIMIT 1 [["id", 1]] > >> 2017-06-11 13:41:16 f825c503 [sql] [D] Hostgroup Load (1.0ms) SELECT > >> "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" = $1 ORDER BY > >> hostgroups.title LIMIT 1 [["id", 1]] > >> 2017-06-11 13:41:16 f825c503 [sql] [D] Architecture Load (0.7ms) > SELECT > >> "architectures".* FROM "architectures" WHERE "architectures"."id" = $1 > LIMIT > >> 1 [["id", 1]] > >> 2017-06-11 13:41:16 f825c503 [sql] [D] Operatingsystem Load (0.8ms) > >> SELECT "operatingsystems".* FROM "operatingsystems" WHERE > >> "operatingsystems"."id" = $1 ORDER BY "operatingsystems"."title" ASC > LIMIT > >> 1 [["id", 1]] > >> 2017-06-11 13:41:16 f825c503 [sql] [D] Domain Load (0.7ms) SELECT > >> "domains".* FROM "domains" WHERE "domains"."id" = $1 ORDER BY > domains.name > >> LIMIT 1 [["id", 1]] > >> 2017-06-11 13:41:16 f825c503 [sql] [D] Subnet Load (0.7ms) SELECT > >> "subnets".* FROM "subnets" WHERE "subnets"."id" = $1 ORDER BY vlanid > LIMIT > >> 1 [["id", 1]] > >> 2017-06-11 13:41:16 f825c503 [app] [I] Rendered > hosts/_progress.html.erb > >> (0.2ms) > >> 2017-06-11 13:41:16 f825c503 [app] [D] Setting current organization > >> thread-local variable to none > >> 2017-06-11 13:41:16 f825c503 [app] [D] Setting current location > >> thread-local variable to none > >> 2017-06-11 13:41:16 f825c503 [sql] [D] SmartProxy Load (1.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 (1=1) AND "features"."name" = 'Puppet' ORDER BY > >> "smart_proxies"."name" ASC > >> 2017-06-11 13:41:16 f825c503 [sql] [D] CACHE (0.0ms) SELECT > >> "domains".* FROM "domains" WHERE "domains"."id" = $1 ORDER BY > domains.name > >> LIMIT 1 [["id", 1]] > >> 2017-06-11 13:41:16 f825c503 [sql] [D] Hostgroup Load (0.8ms) SELECT > >> "hostgroups".* FROM "hostgroups" WHERE (1=1) ORDER BY > "hostgroups"."title" > >> ASC > >> 2017-06-11 13:41:16 f825c503 [sql] [D] Environment Load (0.6ms) > SELECT > >> "environments".* FROM "environments" WHERE (1=1) ORDER BY > >> "environments"."name" ASC > >> 2017-06-11 13:41:16 f825c503 [sql] [D] CACHE (0.0ms) 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 (1=1) AND "features"."name" = 'Puppet' ORDER BY > >> "smart_proxies"."name" ASC > >> 2017-06-11 13:41:16 f825c503 [sql] [D] SmartProxy Load (1.1ms) > 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 (1=1) AND "features"."name" = 'Puppet CA' ORDER BY > >> "smart_proxies"."name" ASC > >> 2017-06-11 13:41:16 f825c503 [sql] [D] Realm Load (0.6ms) SELECT > >> "realms".* FROM "realms" WHERE (1=1) ORDER BY "realms"."name" ASC > >> 2017-06-11 13:41:16 f825c503 [sql] [D] CACHE (0.0ms) 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 (1=1) AND "features"."name" = 'Puppet' ORDER BY > >> "smart_proxies"."name" ASC > >> 2017-06-11 13:41:16 f825c503 [sql] [D] CACHE (0.0ms) SELECT "nics".* > >> FROM "nics" WHERE "nics"."host_id" = $1 ORDER BY "nics"."identifier" > ASC > >> [["host_id", 12]] > >> 2017-06-11 13:41:16 f825c503 [sql] [D] Domain Load (0.6ms) SELECT > >> "domains".* FROM "domains" WHERE (1=1) ORDER BY "domains"."name" ASC > >> 2017-06-11 13:41:16 f825c503 [sql] [D] CACHE (0.0ms) SELECT > "domains".* > >> FROM "domains" WHERE (1=1) ORDER BY "domains"."name" ASC > >> 2017-06-11 13:41:16 f825c503 [sql] [D] CACHE (0.0ms) SELECT > "domains".* > >> FROM "domains" WHERE (1=1) ORDER BY "domains"."name" ASC > >> 2017-06-11 13:41:16 f825c503 [sql] [D] Subnet::Ipv4 Load (0.8ms) > SELECT > >> "subnets".* FROM "subnets" WHERE "subnets"."type" IN ('Subnet::Ipv4') > AND > >> (1=1) ORDER BY "subnets"."name" ASC > >> 2017-06-11 13:41:16 f825c503 [sql] [D] CACHE (0.0ms) SELECT > "subnets".* > >> FROM "subnets" WHERE "subnets"."type" IN ('Subnet::Ipv4') AND (1=1) > ORDER > >> BY "subnets"."name" ASC > >> 2017-06-11 13:41:16 f825c503 [sql] [D] CACHE (0.0ms) SELECT > "subnets".* > >> FROM "subnets" WHERE "subnets"."type" IN ('Subnet::Ipv4') AND (1=1) > ORDER > >> BY "subnets"."name" ASC > >> 2017-06-11 13:41:16 f825c503 [sql] [D] Subnet::Ipv6 Load (0.7ms) > SELECT > >> "subnets".* FROM "subnets" WHERE "subnets"."type" IN ('Subnet::Ipv6') > AND > >> (1=1) ORDER BY "subnets"."name" ASC > >> 2017-06-11 13:41:16 f825c503 [sql] [D] CACHE (0.0ms) SELECT > "subnets".* > >> FROM "subnets" WHERE "subnets"."type" IN ('Subnet::Ipv6') AND (1=1) > ORDER > >> BY "subnets"."name" ASC > >> 2017-06-11 13:41:16 f825c503 [sql] [D] CACHE (0.0ms) SELECT > >> "subnets".* FROM "subnets" WHERE "subnets"."id" = $1 AND > "subnets"."type" = > >> $2 ORDER BY vlanid LIMIT 1 [["id", 1], ["type", "Subnet::Ipv4"]] > >> 2017-06-11 13:41:16 f825c503 [app] [I] Rendered > nic/_base_form.html.erb > >> (20.9ms) > >> 2017-06-11 13:41:16 f825c503 [app] [I] Rendered > >> nic/_virtual_form.html.erb (1.2ms) > >> 2017-06-11 13:41:16 f825c503 [app] [I] Rendered > >> nic/_provider_specific_form.html.erb (0.1ms) > >> 2017-06-11 13:41:16 f825c503 [app] [I] Rendered > >> nic/manageds/_managed.html.erb (23.9ms) > >> 2017-06-11 13:41:16 f825c503 [sql] [D] CACHE (0.0ms) SELECT > "domains".* > >> FROM "domains" WHERE (1=1) ORDER BY "domains"."name" ASC > >> 2017-06-11 13:41:16 f825c503 [sql] [D] CACHE (0.0ms) SELECT > "domains".* > >> FROM "domains" WHERE (1=1) ORDER BY "domains"."name" ASC > >> 2017-06-11 13:41:16 f825c503 [sql] [D] CACHE (0.0ms) SELECT > "domains".* > >> FROM "domains" WHERE (1=1) ORDER BY "domains"."name" ASC > >> 2017-06-11 13:41:16 f825c503 [sql] [D] CACHE (0.0ms) SELECT > "subnets".* > >> FROM "subnets" WHERE "subnets"."type" IN ('Subnet::Ipv4') AND (1=1) > ORDER > >> BY "subnets"."name" ASC > >> 2017-06-11 13:41:16 f825c503 [sql] [D] CACHE (0.0ms) SELECT > "subnets".* > >> FROM "subnets" WHERE "subnets"."type" IN ('Subnet::Ipv4') AND (1=1) > ORDER > >> BY "subnets"."name" ASC > >> 2017-06-11 13:41:16 f825c503 [sql] [D] CACHE (0.0ms) SELECT > "subnets".* > >> FROM "subnets" WHERE "subnets"."type" IN ('Subnet::Ipv4') AND (1=1) > ORDER > >> BY "subnets"."name" ASC > >> 2017-06-11 13:41:16 f825c503 [sql] [D] CACHE (0.0ms) SELECT > "subnets".* > >> FROM "subnets" WHERE "subnets"."type" IN ('Subnet::Ipv6') AND (1=1) > ORDER > >> BY "subnets"."name" ASC > >> 2017-06-11 13:41:16 f825c503 [sql] [D] CACHE (0.0ms) SELECT > "subnets".* > >> FROM "subnets" WHERE "subnets"."type" IN ('Subnet::Ipv6') AND (1=1) > ORDER > >> BY "subnets"."name" ASC > >> 2017-06-11 13:41:16 f825c503 [app] [I] Rendered > nic/_base_form.html.erb > >> (14.5ms) > >> 2017-06-11 13:41:16 f825c503 [app] [I] Rendered > >> nic/_virtual_form.html.erb (1.1ms) > >> 2017-06-11 13:41:16 f825c503 [app] [I] Rendered > >> nic/_provider_specific_form.html.erb (0.1ms) > >> 2017-06-11 13:41:16 f825c503 [app] [I] Rendered > >> nic/manageds/_managed.html.erb (17.1ms) > >> 2017-06-11 13:41:16 f825c503 [sql] [D] CACHE (0.0ms) SELECT > "domains".* > >> FROM "domains" WHERE (1=1) ORDER BY "domains"."name" ASC > >> 2017-06-11 13:41:16 f825c503 [sql] [D] CACHE (0.0ms) SELECT > "domains".* > >> FROM "domains" WHERE (1=1) ORDER BY "domains"."name" ASC > >> 2017-06-11 13:41:16 f825c503 [sql] [D] CACHE (0.0ms) SELECT > "domains".* > >> FROM "domains" WHERE (1=1) ORDER BY "domains"."name" ASC > >> 2017-06-11 13:41:16 f825c503 [sql] [D] CACHE (0.0ms) SELECT > "subnets".* > >> FROM "subnets" WHERE "subnets"."type" IN ('Subnet::Ipv4') AND (1=1) > ORDER > >> BY "subnets"."name" ASC > >> 2017-06-11 13:41:16 f825c503 [sql] [D] CACHE (0.0ms) SELECT > "subnets".* > >> FROM "subnets" WHERE "subnets"."type" IN ('Subnet::Ipv4') AND (1=1) > ORDER > >> BY "subnets"."name" ASC > >> 2017-06-11 13:41:16 f825c503 [sql] [D] CACHE (0.0ms) SELECT > "subnets".* > >> FROM "subnets" WHERE "subnets"."type" IN ('Subnet::Ipv4') AND (1=1) > ORDER > >> BY "subnets"."name" ASC > >> 2017-06-11 13:41:16 f825c503 [sql] [D] CACHE (0.0ms) SELECT > "subnets".* > >> FROM "subnets" WHERE "subnets"."type" IN ('Subnet::Ipv6') AND (1=1) > ORDER > >> BY "subnets"."name" ASC > >> 2017-06-11 13:41:16 f825c503 [sql] [D] CACHE (0.0ms) SELECT > "subnets".* > >> FROM "subnets" WHERE "subnets"."type" IN ('Subnet::Ipv6') AND (1=1) > ORDER > >> BY "subnets"."name" ASC > >> 2017-06-11 13:41:16 f825c503 [app] [I] Rendered > nic/_base_form.html.erb > >> (13.5ms) > >> 2017-06-11 13:41:16 f825c503 [app] [I] Rendered > >> nic/_virtual_form.html.erb (1.0ms) > >> 2017-06-11 13:41:16 f825c503 [app] [I] Rendered > >> nic/_provider_specific_form.html.erb (0.1ms) > >> 2017-06-11 13:41:16 f825c503 [app] [I] Rendered > >> nic/manageds/_managed.html.erb (16.0ms) > >> 2017-06-11 13:41:16 f825c503 [sql] [D] CACHE (0.0ms) SELECT > "domains".* > >> FROM "domains" WHERE (1=1) ORDER BY "domains"."name" ASC > >> 2017-06-11 13:41:16 f825c503 [sql] [D] CACHE (0.0ms) SELECT > "domains".* > >> FROM "domains" WHERE (1=1) ORDER BY "domains"."name" ASC > >> 2017-06-11 13:41:16 f825c503 [sql] [D] CACHE (0.0ms) SELECT > "domains".* > >> FROM "domains" WHERE (1=1) ORDER BY "domains"."name" ASC > >> 2017-06-11 13:41:16 f825c503 [sql] [D] CACHE (0.0ms) SELECT > "subnets".* > >> FROM "subnets" WHERE "subnets"."type" IN ('Subnet::Ipv4') AND (1=1) > ORDER > >> BY "subnets"."name" ASC > >> 2017-06-11 13:41:16 f825c503 [sql] [D] CACHE (0.0ms) SELECT > "subnets".* > >> FROM "subnets" WHERE "subnets"."type" IN ('Subnet::Ipv4') AND (1=1) > ORDER > >> BY "subnets"."name" ASC > >> 2017-06-11 13:41:16 f825c503 [sql] [D] CACHE (0.0ms) SELECT > "subnets".* > >> FROM "subnets" WHERE "subnets"."type" IN ('Subnet::Ipv4') AND (1=1) > ORDER > >> BY "subnets"."name" ASC > >> 2017-06-11 13:41:16 f825c503 [sql] [D] CACHE (0.0ms) SELECT > "subnets".* > >> FROM "subnets" WHERE "subnets"."type" IN ('Subnet::Ipv6') AND (1=1) > ORDER > >> BY "subnets"."name" ASC > >> 2017-06-11 13:41:16 f825c503 [sql] [D] CACHE (0.0ms) SELECT > "subnets".* > >> FROM "subnets" WHERE "subnets"."type" IN ('Subnet::Ipv6') AND (1=1) > ORDER > >> BY "subnets"."name" ASC > >> 2017-06-11 13:41:16 f825c503 [app] [I] Rendered > nic/_base_form.html.erb > >> (13.4ms) > >> 2017-06-11 13:41:16 f825c503 [app] [I] Rendered > >> nic/_virtual_form.html.erb (1.0ms) > >> 2017-06-11 13:41:16 f825c503 [app] [I] Rendered > >> nic/_provider_specific_form.html.erb (0.1ms) > >> 2017-06-11 13:41:16 f825c503 [app] [I] Rendered > >> nic/manageds/_managed.html.erb (16.0ms) > >> 2017-06-11 13:41:16 f825c503 [sql] [D] CACHE (0.0ms) SELECT > "domains".* > >> FROM "domains" WHERE (1=1) ORDER BY "domains"."name" ASC > >> 2017-06-11 13:41:16 f825c503 [sql] [D] CACHE (0.0ms) SELECT > "domains".* > >> FROM "domains" WHERE (1=1) ORDER BY "domains"."name" ASC > >> 2017-06-11 13:41:16 f825c503 [sql] [D] CACHE (0.0ms) SELECT > "domains".* > >> FROM "domains" WHERE (1=1) ORDER BY "domains"."name" ASC > >> 2017-06-11 13:41:16 f825c503 [sql] [D] CACHE (0.0ms) SELECT > "subnets".* > >> FROM "subnets" WHERE "subnets"."type" IN ('Subnet::Ipv4') AND (1=1) > ORDER > >> BY "subnets"."name" ASC > >> 2017-06-11 13:41:16 f825c503 [sql] [D] CACHE (0.0ms) SELECT > "subnets".* > >> FROM "subnets" WHERE "subnets"."type" IN ('Subnet::Ipv4') AND (1=1) > ORDER > >> BY "subnets"."name" ASC > >> 2017-06-11 13:41:16 f825c503 [sql] [D] CACHE (0.0ms) SELECT > "subnets".* > >> FROM "subnets" WHERE "subnets"."type" IN ('Subnet::Ipv4') AND (1=1) > ORDER > >> BY "subnets"."name" ASC > >> 2017-06-11 13:41:16 f825c503 [sql] [D] CACHE (0.0ms) SELECT > "subnets".* > >> FROM "subnets" WHERE "subnets"."type" IN ('Subnet::Ipv6') AND (1=1) > ORDER > >> BY "subnets"."name" ASC > >> 2017-06-11 13:41:16 f825c503 [sql] [D] CACHE (0.0ms) SELECT > "subnets".* > >> FROM "subnets" WHERE "subnets"."type" IN ('Subnet::Ipv6') AND (1=1) > ORDER > >> BY "subnets"."name" ASC > >> 2017-06-11 13:41:16 f825c503 [app] [I] Rendered > nic/_base_form.html.erb > >> (13.8ms) > >> 2017-06-11 13:41:16 f825c503 [app] [I] Rendered > >> nic/_provider_specific_form.html.erb (0.1ms) > >> 2017-06-11 13:41:16 f825c503 [app] [I] Rendered > nic/bmcs/_bmc.html.erb > >> (16.4ms) > >> 2017-06-11 13:41:16 f825c503 [sql] [D] CACHE (0.0ms) SELECT > "domains".* > >> FROM "domains" WHERE (1=1) ORDER BY "domains"."name" ASC > >> 2017-06-11 13:41:16 f825c503 [sql] [D] CACHE (0.0ms) SELECT > "domains".* > >> FROM "domains" WHERE (1=1) ORDER BY "domains"."name" ASC > >> 2017-06-11 13:41:16 f825c503 [sql] [D] CACHE (0.0ms) SELECT > "domains".* > >> FROM "domains" WHERE (1=1) ORDER BY "domains"."name" ASC > >> 2017-06-11 13:41:16 f825c503 [sql] [D] CACHE (0.0ms) SELECT > "subnets".* > >> FROM "subnets" WHERE "subnets"."type" IN ('Subnet::Ipv4') AND (1=1) > ORDER > >> BY "subnets"."name" ASC > >> 2017-06-11 13:41:16 f825c503 [sql] [D] CACHE (0.0ms) SELECT > "subnets".* > >> FROM "subnets" WHERE "subnets"."type" IN ('Subnet::Ipv4') AND (1=1) > ORDER > >> BY "subnets"."name" ASC > >> 2017-06-11 13:41:16 f825c503 [sql] [D] CACHE (0.0ms) SELECT > "subnets".* > >> FROM "subnets" WHERE "subnets"."type" IN ('Subnet::Ipv4') AND (1=1) > ORDER > >> BY "subnets"."name" ASC > >> 2017-06-11 13:41:16 f825c503 [sql] [D] CACHE (0.0ms) SELECT > "subnets".* > >> FROM "subnets" WHERE "subnets"."type" IN ('Subnet::Ipv6') AND (1=1) > ORDER > >> BY "subnets"."name" ASC > >> 2017-06-11 13:41:16 f825c503 [sql] [D] CACHE (0.0ms) SELECT > "subnets".* > >> FROM "subnets" WHERE "subnets"."type" IN ('Subnet::Ipv6') AND (1=1) > ORDER > >> BY "subnets"."name" ASC > >> 2017-06-11 13:41:16 f825c503 [app] [I] Rendered > nic/_base_form.html.erb > >> (13.8ms) > >> 2017-06-11 13:41:16 f825c503 [app] [I] Rendered > >> nic/_virtual_form.html.erb (1.0ms) > >> 2017-06-11 13:41:16 f825c503 [app] [I] Rendered > >> nic/_provider_specific_form.html.erb (0.1ms) > >> 2017-06-11 13:41:16 f825c503 [app] [I] Rendered > >> nic/manageds/_managed.html.erb (16.4ms) > >> 2017-06-11 13:41:16 f825c503 [sql] [D] CACHE (0.0ms) SELECT > "domains".* > >> FROM "domains" WHERE (1=1) ORDER BY "domains"."name" ASC > >> 2017-06-11 13:41:16 f825c503 [sql] [D] CACHE (0.0ms) SELECT > "domains".* > >> FROM "domains" WHERE (1=1) ORDER BY "domains"."name" ASC > >> 2017-06-11 13:41:16 f825c503 [sql] [D] CACHE (0.0ms) SELECT > "domains".* > >> FROM "domains" WHERE (1=1) ORDER BY "domains"."name" ASC > >> 2017-06-11 13:41:16 f825c503 [sql] [D] CACHE (0.0ms) SELECT > "subnets".* > >> FROM "subnets" WHERE "subnets"."type" IN ('Subnet::Ipv4') AND (1=1) > ORDER > >> BY "subnets"."name" ASC > >> 2017-06-11 13:41:16 f825c503 [sql] [D] CACHE (0.0ms) SELECT > "subnets".* > >> FROM "subnets" WHERE "subnets"."type" IN ('Subnet::Ipv4') AND (1=1) > ORDER > >> BY "subnets"."name" ASC > >> 2017-06-11 13:41:16 f825c503 [sql] [D] CACHE (0.0ms) SELECT > "subnets".* > >> FROM "subnets" WHERE "subnets"."type" IN ('Subnet::Ipv4') AND (1=1) > ORDER > >> BY "subnets"."name" ASC > >> 2017-06-11 13:41:16 f825c503 [sql] [D] CACHE (0.0ms) SELECT > "subnets".* > >> FROM "subnets" WHERE "subnets"."type" IN ('Subnet::Ipv6') AND (1=1) > ORDER > >> BY "subnets"."name" ASC > >> 2017-06-11 13:41:16 f825c503 [sql] [D] CACHE (0.0ms) SELECT > "subnets".* > >> FROM "subnets" WHERE "subnets"."type" IN ('Subnet::Ipv6') AND (1=1) > ORDER > >> BY "subnets"."name" ASC > >> 2017-06-11 13:41:16 f825c503 [app] [I] Rendered > nic/_base_form.html.erb > >> (13.5ms) > >> 2017-06-11 13:41:16 f825c503 [app] [I] Rendered > >> nic/_virtual_form.html.erb (1.0ms) > >> 2017-06-11 13:41:16 f825c503 [app] [I] Rendered > >> nic/_provider_specific_form.html.erb (0.1ms) > >> 2017-06-11 13:41:16 f825c503 [app] [I] Rendered > >> nic/manageds/_managed.html.erb (16.1ms) > >> 2017-06-11 13:41:16 f825c503 [sql] [D] CACHE (0.0ms) SELECT > "domains".* > >> FROM "domains" WHERE (1=1) ORDER BY "domains"."name" ASC > >> 2017-06-11 13:41:16 f825c503 [sql] [D] CACHE (0.0ms) SELECT > "domains".* > >> FROM "domains" WHERE (1=1) ORDER BY "domains"."name" ASC > >> 2017-06-11 13:41:16 f825c503 [sql] [D] CACHE (0.0ms) SELECT > "domains".* > >> FROM "domains" WHERE (1=1) ORDER BY "domains"."name" ASC > >> 2017-06-11 13:41:16 f825c503 [sql] [D] CACHE (0.0ms) SELECT > "subnets".* > >> FROM "subnets" WHERE "subnets"."type" IN ('Subnet::Ipv4') AND (1=1) > ORDER > >> BY "subnets"."name" ASC > >> 2017-06-11 13:41:16 f825c503 [sql] [D] CACHE (0.0ms) SELECT > "subnets".* > >> FROM "subnets" WHERE "subnets"."type" IN ('Subnet::Ipv4') AND (1=1) > ORDER > >> BY "subnets"."name" ASC > >> 2017-06-11 13:41:16 f825c503 [sql] [D] CACHE (0.0ms) SELECT > "subnets".* > >> FROM "subnets" WHERE "subnets"."type" IN ('Subnet::Ipv4') AND (1=1) > ORDER > >> BY "subnets"."name" ASC > >> 2017-06-11 13:41:16 f825c503 [sql] [D] CACHE (0.0ms) SELECT > "subnets".* > >> FROM "subnets" WHERE "subnets"."type" IN ('Subnet::Ipv6') AND (1=1) > ORDER > >> BY "subnets"."name" ASC > >> 2017-06-11 13:41:16 f825c503 [sql] [D] CACHE (0.0ms) SELECT > "subnets".* > >> FROM "subnets" WHERE "subnets"."type" IN ('Subnet::Ipv6') AND (1=1) > ORDER > >> BY "subnets"."name" ASC > >> 2017-06-11 13:41:16 f825c503 [app] [I] Rendered > nic/_base_form.html.erb > >> (13.6ms) > >> 2017-06-11 13:41:16 f825c503 [app] [I] Rendered > >> nic/_virtual_form.html.erb (1.0ms) > >> 2017-06-11 13:41:16 f825c503 [app] [I] Rendered > >> nic/_provider_specific_form.html.erb (0.1ms) > >> 2017-06-11 13:41:16 f825c503 [app] [I] Rendered > >> nic/manageds/_managed.html.erb (16.2ms) > >> 2017-06-11 13:41:16 f825c503 [app] [I] Rendered > >> hosts/_interfaces.html.erb (144.4ms) > >> 2017-06-11 13:41:16 f825c503 [sql] [D] Architecture Load (0.5ms) > SELECT > >> "architectures".* FROM "architectures" ORDER BY "architectures"."name" > ASC > >> 2017-06-11 13:41:16 f825c503 [sql] [D] CACHE (0.0ms) SELECT > >> "architectures".* FROM "architectures" WHERE "architectures"."id" = $1 > LIMIT > >> 1 [["id", 1]] > >> 2017-06-11 13:41:16 f825c503 [sql] [D] (0.9ms) SELECT COUNT(*) FROM > >> "operatingsystems" INNER JOIN "architectures_operatingsystems" ON > >> "operatingsystems"."id" = > >> "architectures_operatingsystems"."operatingsystem_id" WHERE > >> "architectures_operatingsystems"."architecture_id" = $1 > >> [["architecture_id", 1]] > >> 2017-06-11 13:41:16 f825c503 [sql] [D] Operatingsystem Load (0.9ms) > >> 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" ASC [["architecture_id", 1]] > >> 2017-06-11 13:41:16 f825c503 [app] [I] Rendered > >> common/os_selection/_architecture.html.erb (5.7ms) > >> 2017-06-11 13:41:16 f825c503 [sql] [D] (0.9ms) SELECT COUNT(*) FROM > >> "media" INNER JOIN "media_operatingsystems" ON "media"."id" = > >> "media_operatingsystems"."medium_id" WHERE > >> "media_operatingsystems"."operatingsystem_id" = $1 AND (1=1) > >> [["operatingsystem_id", 1]] > >> 2017-06-11 13:41:16 f825c503 [sql] [D] Medium Load (1.0ms) 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" ASC [["operatingsystem_id", 1]] > >> 2017-06-11 13:41:16 f825c503 [sql] [D] (0.9ms) SELECT COUNT(*) FROM > >> "templates" INNER JOIN "operatingsystems_ptables" ON "templates"."id" = > >> "operatingsystems_ptables"."ptable_id" WHERE "templates"."type" IN > >> ('Ptable') AND "operatingsystems_ptables"."operatingsystem_id" = $1 AND > >> (1=1) [["operatingsystem_id", 1]] > >> 2017-06-11 13:41:16 f825c503 [sql] [D] Ptable Load (0.9ms) SELECT > >> "templates".* FROM "templates" INNER JOIN "operatingsystems_ptables" ON > >> "templates"."id" = "operatingsystems_ptables"."ptable_id" WHERE > >> "templates"."type" IN ('Ptable') AND > >> "operatingsystems_ptables"."operatingsystem_id" = $1 AND (1=1) ORDER > BY > >> "templates"."name" ASC [["operatingsystem_id", 1]] > >> 2017-06-11 13:41:16 f825c503 [app] [I] Rendered > >> common/os_selection/_pxe_loader.html.erb (1.2ms) > >> 2017-06-11 13:41:16 f825c503 [app] [I] Rendered > >> common/os_selection/_operatingsystem.html.erb (14.2ms) > >> 2017-06-11 13:41:16 f825c503 [app] [I] Rendered > >> hosts/provision_method/build/_form.html.erb (15.5ms) > >> 2017-06-11 13:41:16 f825c503 [app] [I] Rendered > >> hosts/provision_method/image/_form.html.erb (0.1ms) > >> 2017-06-11 13:41:16 f825c503 [app] [I] Rendered > >> hosts/_operating_system.html.erb (26.7ms) > >> 2017-06-11 13:41:16 f825c503 [app] [I] Rendered > >> hosts/_unattended.html.erb (26.8ms) > >> 2017-06-11 13:41:16 f825c503 [sql] [D] Hostgroup Load (0.9ms) SELECT > >> "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" IN (1) ORDER > BY > >> coalesce("hostgroups"."ancestry", '') > >> 2017-06-11 13:41:16 f825c503 [sql] [D] (0.6ms) 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" = $1 AND > "host_config_groups"."host_type" = > >> $2 ORDER BY config_groups.name [["host_id", 1], ["host_type", > >> "Hostgroup"]] > >> 2017-06-11 13:41:16 f825c503 [sql] [D] (0.6ms) 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" = $1 AND > "host_config_groups"."host_type" = > >> $2 ORDER BY config_groups.name [["host_id", 12], ["host_type", > >> "Host::Base"]] > >> 2017-06-11 13:41:16 f825c503 [sql] [D] (0.4ms) SELECT > >> "config_group_classes"."puppetclass_id" FROM "config_group_classes" > WHERE > >> 1=0 > >> 2017-06-11 13:41:16 f825c503 [sql] [D] (0.4ms) SELECT > >> "hostgroup_classes"."puppetclass_id" FROM "hostgroup_classes" WHERE > >> "hostgroup_classes"."hostgroup_id" = 1 > >> 2017-06-11 13:41:16 f825c503 [sql] [D] HostClass Load (0.3ms) SELECT > >> "host_classes".* FROM "host_classes" WHERE "host_classes"."host_id" = > $1 > >> [["host_id", 12]] > >> 2017-06-11 13:41:16 f825c503 [sql] [D] (0.3ms) SELECT > puppetclasses.id > >> FROM "puppetclasses" WHERE 1=0 > >> 2017-06-11 13:41:16 f825c503 [sql] [D] (0.5ms) SELECT DISTINCT > >> "lookup_keys"."puppetclass_id" FROM "lookup_keys" WHERE > "lookup_keys"."type" > >> IN ('VariableLookupKey') AND 1=0 > >> 2017-06-11 13:41:16 f825c503 [sql] [D] (0.6ms) SELECT DISTINCT > >> environment_classes.puppetclass_id FROM "lookup_keys" INNER JOIN > >> "environment_classes" ON > "environment_classes"."puppetclass_lookup_key_id" = > >> "lookup_keys"."id" WHERE "lookup_keys"."type" IN > ('PuppetclassLookupKey') > >> AND 1=0 > >> 2017-06-11 13:41:16 f825c503 [sql] [D] Puppetclass Load (0.3ms) > SELECT > >> "puppetclasses".* FROM "puppetclasses" WHERE 1=0 AND 1=0 ORDER BY > >> puppetclasses.name > >> 2017-06-11 13:41:16 f825c503 [app] [I] Rendered > >> puppetclasses/_class_parameters.html.erb (0.0ms) > >> 2017-06-11 13:41:16 f825c503 [app] [I] Rendered > >> puppetclasses/_classes_parameters.html.erb (14.4ms) > >> 2017-06-11 13:41:16 f825c503 [sql] [D] CommonParameter Load (0.5ms) > >> SELECT "parameters".* FROM "parameters" WHERE "parameters"."type" IN > >> ('CommonParameter') ORDER BY parameters.name > >> 2017-06-11 13:41:16 f825c503 [sql] [D] DomainParameter Load (0.4ms) > >> SELECT "parameters".* FROM "parameters" WHERE "parameters"."type" IN > >> ('DomainParameter') AND "parameters"."reference_id" = $1 ORDER BY > >> parameters.name [["reference_id", 1]] > >> 2017-06-11 13:41:16 f825c503 [sql] [D] SubnetParameter Load (0.4ms) > >> SELECT "parameters".* FROM "parameters" WHERE "parameters"."type" IN > >> ('SubnetParameter') AND "parameters"."reference_id" = $1 ORDER BY > >> parameters.name [["reference_id", 1]] > >> 2017-06-11 13:41:16 f825c503 [sql] [D] CACHE (0.0ms) SELECT > >> "operatingsystems".* FROM "operatingsystems" WHERE > "operatingsystems"."id" = > >> $1 ORDER BY "operatingsystems"."title" ASC LIMIT 1 [["id", 1]] > >> 2017-06-11 13:41:16 f825c503 [sql] [D] OsParameter Load (0.5ms) > SELECT > >> "parameters".* FROM "parameters" WHERE "parameters"."type" IN > >> ('OsParameter') AND "parameters"."reference_id" = $1 ORDER BY > >> parameters.name [["reference_id", 1]] > >> 2017-06-11 13:41:16 f825c503 [sql] [D] Hostgroup Load (0.5ms) SELECT > >> "hostgroups".* FROM "hostgroups" WHERE 1=0 ORDER BY > >> coalesce("hostgroups"."ancestry", '') > >> 2017-06-11 13:41:16 f825c503 [sql] [D] GroupParameter Load (0.4ms) > >> SELECT "parameters".* FROM "parameters" WHERE "parameters"."type" IN > >> ('GroupParameter') AND "parameters"."reference_id" = $1 ORDER BY > >> parameters.name [["reference_id", 1]] > >> 2017-06-11 13:41:16 f825c503 [app] [I] Rendered > >> common_parameters/_inherited_parameters.html.erb (0.2ms) > >> 2017-06-11 13:41:16 f825c503 [sql] [D] HostParameter Load (0.3ms) > >> SELECT "parameters".* FROM "parameters" WHERE "parameters"."type" IN > >> ('HostParameter') AND "parameters"."reference_id" = $1 ORDER BY > >> parameters.name [["reference_id", 12]] > >> 2017-06-11 13:41:16 f825c503 [sql] [D] CACHE (0.0ms) SELECT > >> "parameters".* FROM "parameters" WHERE "parameters"."type" IN > >> ('HostParameter') AND "parameters"."reference_id" = $1 ORDER BY > >> parameters.name [["reference_id", 12]] > >> 2017-06-11 13:41:16 f825c503 [app] [I] Rendered > >> common_parameters/_parameter.html.erb (1.5ms) > >> 2017-06-11 13:41:16 f825c503 [app] [I] Rendered > >> common_parameters/_parameters.html.erb (5.3ms) > >> 2017-06-11 13:41:16 f825c503 [sql] [D] (0.4ms) SELECT > auth_sources.id > >> FROM "auth_sources" WHERE "auth_sources"."type" IN ('AuthSourceHidden') > >> 2017-06-11 13:41:16 f825c503 [sql] [D] User Load (0.4ms) SELECT > >> "users".* FROM "users" WHERE ("users"."auth_source_id" NOT IN (2)) > ORDER BY > >> firstname > >> 2017-06-11 13:41:16 f825c503 [sql] [D] Usergroup Load (0.3ms) SELECT > >> "usergroups".* FROM "usergroups" ORDER BY usergroups.name > >> 2017-06-11 13:41:16 f825c503 [sql] [D] Model Load (0.4ms) SELECT > >> "models".* FROM "models" ORDER BY "models"."name" ASC > >> 2017-06-11 13:41:16 f825c503 [sql] [D] Model Load (0.3ms) SELECT > >> "models".* FROM "models" WHERE "models"."id" = $1 ORDER BY models.name > >> LIMIT 1 [["id", 3]] > >> 2017-06-11 13:41:16 f825c503 [app] [D] Setting current location > >> thread-local variable to none > >> 2017-06-11 13:41:16 f825c503 [app] [D] Setting current organization > >> thread-local variable to none > >> 2017-06-11 13:41:16 f825c503 [app] [I] Rendered hosts/_form.html.erb > >> (241.9ms) > >> 2017-06-11 13:41:16 f825c503 [app] [I] Rendered hosts/edit.html.erb > >> within layouts/application (243.7ms) > >> 2017-06-11 13:41:16 f825c503 [app] [I] Rendered > >> layouts/_application_content.html.erb (0.2ms) > >> 2017-06-11 13:41:16 f825c503 [app] [I] Rendered > >> home/_user_dropdown.html.erb (1.7ms) > >> 2017-06-11 13:41:16 f825c503 [app] [I] Read fragment > >> views/tabs_and_title_records-3 (0.1ms) > >> 2017-06-11 13:41:16 f825c503 [app] [I] Rendered home/_topbar.html.erb > >> (5.8ms) > >> 2017-06-11 13:41:16 f825c503 [app] [I] Rendered layouts/base.html.erb > >> (7.2ms) > >> 2017-06-11 13:41:16 f825c503 [app] [I] Completed 200 OK in 423ms > (Views: > >> 229.1ms | ActiveRecord: 37.0ms) > >> 2017-06-11 13:41:16 f825c503 [sql] [D] (0.1ms) BEGIN > >> 2017-06-11 13:41:16 f825c503 [sql] [D] SQL (0.4ms) UPDATE "sessions" > >> SET "data" = $1, "updated_at" = $2 WHERE "sessions"."id" = $3 > [["data", > >> > "BAh7CkkiCXVzZXIGOgZFRmkISSIPZXhwaXJlc19hdAY7AEZsKweMVj1ZSSIL\nbG9jYWxlBjsARiIHZW5JIhBfY3NyZl90b2tlbgY7AEZJIjFRSGFaN2JqanVP\nOXdBUmV0anRSaFVHVEpEaUF2SFFpckZtMDBCWjBMVURrPQY7AEZJIiVyZWRp\ncmVjdF90b191cmxfZGlzY292ZXJlZF9ob3N0cwY7AFQiKmh0dHBzOi8vMTcy\nLjIwLjEwMC4yL2Rpc2NvdmVyZWRfaG9zdHM=\n"], > > > >> ["updated_at", "2017-06-11 13:41:16.864800"], ["id", 2785]] > >> 2017-06-11 13:41:16 f825c503 [sql] [D] (8.6ms) COMMIT > >> 2017-06-11 13:41:22 f825c503 [app] [I] Started PATCH > >> "/discovered_hosts/mac000000000000" for 1.1.1.1 at 2017-06-11 13:41:22 > +0000 > >> 2017-06-11 13:41:22 f825c503 [app] [I] Processing by > >> DiscoveredHostsController#update as */* > >> 2017-06-11 13:41:22 f825c503 [app] [I] Parameters: {"utf8"=>"✓", > >> > "authenticity_token"=>"kx1mdDcNjoqaWjU1Jx24eCjhmc7crAVJVcj42Tt01uLTa/+Zj+42ZepbIpipydkoTCiX7vOxDeJDpczcpn+G2w==", > > > >> "host"=>{"name"=>"mac000000000000", "hostgroup_id"=>"1", > "managed"=>"true", > >> "progress_report_id"=>"[FILTERED]", "type"=>"Host::Managed", > >> "interfaces_attributes"=>{"0"=>{"_destroy"=>"0", > "mac"=>"00:00:00:00:00:00", > >> "identifier"=>"em1", "name"=>"mac000000000000", "domain_id"=>"", > >> "subnet_id"=>"1", "ip"=>"2.2.2.2", "ip6"=>"", "managed"=>"1", > >> "primary"=>"1", "provision"=>"1", "tag"=>"", "attached_to"=>"", > "id"=>"21"}, > >> "1"=>{"_destroy"=>"0", "mac"=>"00:00:00:00:00:00", "identifier"=>"em2", > >> "name"=>"", "domain_id"=>"", "subnet_id"=>"", "ip"=>"", "ip6"=>"", > >> "managed"=>"0", "primary"=>"0", "provision"=>"0", "tag"=>"", > >> "attached_to"=>"", "id"=>"22"}, "2"=>{"_destroy"=>"0", > >> "mac"=>"00:00:00:00:00:00", "identifier"=>"em3", "name"=>"", > >> "domain_id"=>"", "subnet_id"=>"", "ip"=>"", "ip6"=>"", "managed"=>"0", > >> "primary"=>"0", "provision"=>"0", "tag"=>"", "attached_to"=>"", > "id"=>"23"}, > >> "3"=>{"_destroy"=>"0", "mac"=>"00:00:00:00:00:00", "identifier"=>"em4", > >> "name"=>"", "domain_id"=>"", "subnet_id"=>"", "ip"=>"", "ip6"=>"", > >> "managed"=>"0", "primary"=>"0", "provision"=>"0", "tag"=>"", > >> "attached_to"=>"", "id"=>"24"}, "4"=>{"_destroy"=>"0", > >> "mac"=>"00:00:00:00:00:00", "identifier"=>"ipmi", "name"=>"", > >> "domain_id"=>"", "subnet_id"=>"", "ip"=>"192.168.0.120", "ip6"=>"", > >> "managed"=>"0", "primary"=>"0", "provision"=>"0", "username"=>"", > >> "provider"=>"IPMI", "id"=>"27"}, "5"=>{"_destroy"=>"0", > >> "mac"=>"00:00:00:00:00:00", "identifier"=>"p3p1", "name"=>"", > >> "domain_id"=>"", "subnet_id"=>"", "ip"=>"", "ip6"=>"", "managed"=>"0", > >> "primary"=>"0", "provision"=>"0", "tag"=>"", "attached_to"=>"", > "id"=>"25"}, > >> "6"=>{"_destroy"=>"0", "mac"=>"00:00:00:00:00:00", > "identifier"=>"p3p2", > >> "name"=>"", "domain_id"=>"", "subnet_id"=>"", "ip"=>"", "ip6"=>"", > >> "managed"=>"0", "primary"=>"0", "provision"=>"0", "tag"=>"", > >> "attached_to"=>"", "id"=>"26"}}, "architecture_id"=>"1", > >> "operatingsystem_id"=>"1", "build"=>"1", "medium_id"=>"9", > >> "ptable_id"=>"80", "pxe_loader"=>"PXELinux BIOS", "disk"=>"", > >> "is_owned_by"=>"3-Users", "enabled"=>"1", "model_id"=>"3", > "comment"=>"", > >> "overwrite"=>"false"}, "fakepassword"=>"[FILTERED]", > >> "bare_metal_capabilities"=>"build", "id"=>"mac000000000000"} > >> 2017-06-11 13:41:22 f825c503 [sql] [D] > >> ActiveRecord::SessionStore::Session Load (0.7ms) SELECT "sessions".* > FROM > >> "sessions" WHERE "sessions"."session_id" = $1 ORDER BY "sessions"."id" > ASC > >> LIMIT 1 [["session_id", "f825c5039243217a9989ad65570411fe"]] > >> 2017-06-11 13:41:22 f825c503 [sql] [D] User Load (0.6ms) SELECT > >> "users".* FROM "users" WHERE "users"."id" = $1 LIMIT 1 [["id", 3]] > >> 2017-06-11 13:41:22 f825c503 [app] [D] Setting current user > thread-local > >> variable to admin > >> 2017-06-11 13:41:22 f825c503 [sql] [D] AuthSource Load (0.6ms) > SELECT > >> "auth_sources".* FROM "auth_sources" WHERE "auth_sources"."id" = $1 > LIMIT 1 > >> [["id", 1]] > >> 2017-06-11 13:41:22 f825c503 [sql] [D] Host::Discovered Load (0.7ms) > >> SELECT "hosts".* FROM "hosts" WHERE "hosts"."type" IN > ('Host::Discovered') > >> AND "hosts"."id" = $1 ORDER BY hosts.created_at DESC LIMIT 1 [["id", > 0]] > >> 2017-06-11 13:41:22 f825c503 [sql] [D] Host::Discovered Load (0.8ms) > >> SELECT "hosts".* FROM "hosts" WHERE "hosts"."type" IN > ('Host::Discovered') > >> AND "hosts"."name" = $1 ORDER BY hosts.created_at DESC LIMIT 1 > [["name", > >> "mac000000000000"]] > >> 2017-06-11 13:41:22 f825c503 [sql] [D] Nic::Base Load (1.1ms) SELECT > >> "nics".* FROM "nics" WHERE "nics"."host_id" = $1 ORDER BY > >> "nics"."identifier" ASC [["host_id", 12]] > >> 2017-06-11 13:41:22 f825c503 [sql] [D] (0.3ms) BEGIN > >> 2017-06-11 13:41:22 f825c503 [sql] [D] Subnet Load (1.0ms) SELECT > >> "subnets".* FROM "subnets" WHERE "subnets"."id" = $1 AND > "subnets"."type" = > >> $2 ORDER BY vlanid LIMIT 1 [["id", 1], ["type", "Subnet::Ipv4"]] > >> 2017-06-11 13:41:22 f825c503 [sql] [D] Nic::Base Load (0.7ms) SELECT > >> "nics".* FROM "nics" WHERE "nics"."ip" = $1 [["ip", "2.2.2.2"]] > >> 2017-06-11 13:41:22 f825c503 [sql] [D] Nic::Base Load (0.6ms) SELECT > >> "nics".* FROM "nics" WHERE "nics"."domain_id" IS NULL AND "nics"."name" > = $1 > >> [["name", "mac000000000000"]] > >> 2017-06-11 13:41:22 f825c503 [sql] [D] Using host queue > >> 2017-06-11 13:41:22 f825c503 [sql] [D] Using host queue > >> 2017-06-11 13:41:22 f825c503 [sql] [D] Using host queue > >> 2017-06-11 13:41:22 f825c503 [sql] [D] Using host queue > >> 2017-06-11 13:41:22 f825c503 [sql] [D] Nic::Base Load (0.6ms) SELECT > >> "nics".* FROM "nics" WHERE "nics"."ip" = $1 [["ip", "192.168.0.120"]] > >> 2017-06-11 13:41:22 f825c503 [sql] [D] Using host queue > >> 2017-06-11 13:41:22 f825c503 [sql] [D] Using host queue > >> 2017-06-11 13:41:22 f825c503 [sql] [D] Using host queue > >> 2017-06-11 13:41:22 f825c503 [sql] [D] (0.2ms) COMMIT > >> 2017-06-11 13:41:22 f825c503 [sql] [D] Hostgroup Load (0.6ms) SELECT > >> "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."title" = $1 ORDER > BY > >> hostgroups.title LIMIT 1 [["title", "1"]] > >> 2017-06-11 13:41:22 f825c503 [sql] [D] Hostgroup Load (0.6ms) SELECT > >> "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" = $1 ORDER BY > >> hostgroups.title LIMIT 1 [["id", 1]] > >> 2017-06-11 13:41:22 f825c503 [sql] [D] User Load (0.6ms) SELECT > >> "users".* FROM "users" WHERE "users"."id" = $1 ORDER BY firstname > LIMIT 1 > >> [["id", 3]] > >> 2017-06-11 13:41:22 f825c503 [sql] [D] Nic::Base Load (0.7ms) SELECT > >> "nics".* FROM "nics" WHERE "nics"."host_id" = $1 AND "nics"."id" IN > (21, 22, > >> 23, 24, 27, 25, 26) ORDER BY "nics"."identifier" ASC [["host_id", > 12]] > >> 2017-06-11 13:41:22 f825c503 [sql] [D] Hostgroup Load (0.7ms) SELECT > >> "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" = $1 ORDER BY > >> hostgroups.title LIMIT 1 [["id", 1]] > >> 2017-06-11 13:41:22 f825c503 [sql] [D] FactValue Load (1.3ms) SELECT > >> "fact_values".* FROM "fact_values" WHERE "fact_values"."host_id" = $1 > >> [["host_id", 12]] > >> 2017-06-11 13:41:22 f825c503 [sql] [D] FactName Load (2.9ms) SELECT > >> "fact_names".* FROM "fact_names" WHERE "fact_names"."id" IN (365, 370, > 3, > >> 65, 404, 77, 244, 257, 255, 258, 260, 261, 259, 59, 74, 395, 396, 397, > 398, > >> 399, 400, 401, 402, 403, 202, 197, 405, 406, 407, 408, 117, 118, 200, > 300, > >> 75, 447, 448, 449, 450, 451, 452, 453, 454, 455, 385, 456, 457, 458, > 459, > >> 460, 461, 462, 463, 464, 465, 466, 467, 468, 469, 470, 471, 472, 473, > 474, > >> 393, 394, 60, 63, 378, 306, 445, 446, 62, 64, 20, 21, 22, 8, 9, 7, 97, > 312, > >> 327, 309, 307, 310, 379, 94, 11, 12, 10, 17, 18, 16, 19, 301, 302, 303, > 304, > >> 409, 410, 411, 412, 413, 414, 415, 416, 417, 418, 419, 420, 421, 422, > 423, > >> 424, 425, 426, 427, 428, 429, 430, 431, 432, 433, 434, 435, 436, 305, > 24, > >> 26, 437, 364, 380, 66, 67, 438, 206, 381, 382, 383, 384, 439, 440, 441, > 442, > >> 443, 444) ORDER BY fact_names.name > >> 2017-06-11 13:41:22 f825c503 [sql] [D] Setting Load (0.6ms) SELECT > >> "settings".* FROM "settings" WHERE "settings"."name" = $1 ORDER BY > >> "settings"."name" ASC LIMIT 1 [["name", "discovery_clean_facts"]] > >> 2017-06-11 13:41:22 f825c503 [app] [D] Setting current organization > >> thread-local variable to none > >> 2017-06-11 13:41:22 f825c503 [app] [D] Setting current location > >> thread-local variable to none > >> 2017-06-11 13:41:22 f825c503 [sql] [D] CACHE (0.0ms) SELECT > >> "fact_values".* FROM "fact_values" WHERE "fact_values"."host_id" = $1 > >> [["host_id", 12]] > >> 2017-06-11 13:41:22 f825c503 [sql] [D] CACHE (0.0ms) SELECT > >> "fact_names".* FROM "fact_names" WHERE "fact_names"."id" IN (365, 370, > 3, > >> 65, 404, 77, 244, 257, 255, 258, 260, 261, 259, 59, 74, 395, 396, 397, > 398, > >> 399, 400, 401, 402, 403, 202, 197, 405, 406, 407, 408, 117, 118, 200, > 300, > >> 75, 447, 448, 449, 450, 451, 452, 453, 454, 455, 385, 45... -- You received this message because you are subscribed to the Google Groups "Foreman users" group. To unsubscribe from this group and stop receiving emails from it, send an email to foreman-users+unsubscr...@googlegroups.com. To post to this group, send email to foreman-users@googlegroups.com. Visit this group at https://groups.google.com/group/foreman-users. For more options, visit https://groups.google.com/d/optout.