ActiveRecord not finding a record

lzap · April 24, 2020, 1:32pm

Hello,

does anybody know why this would happen:

$ sudo -i foreman-rake console
Loading production environment (Rails 5.2.1)
irb(main):001:0> Host.find_by_certname( "display2.whanganui.tasman.lan")
=> nil
irb(main):002:0> Host.find_by_name("display2.whanganui.tasman.lan").certname
=> "display2.whanganui.tasman.lan"

https://projects.theforeman.org/issues/29407

x9c4 · April 24, 2020, 3:38pm

Shouldn’t this be
Host.find_by certname: "display......"
?
And i guess it can only work if certname is an actual database field?

tbrisker · April 26, 2020, 9:28am

certname is a database field, but host has an accessor that falls back to name if certname is missing:

github.com

theforeman/foreman/blob/develop/app/models/host/managed.rb#L633


    return false
  end
  ProxyAPI::Puppet.new({:url => puppet_proxy.url}).run fqdn
rescue => e
  errors.add(:base, _("failed to execute puppetrun: %s") % e)
  Foreman::Logging.exception("Unable to execute puppet run", e)
  false
end


# if certname does not exist, use hostname instead
def certname
  self[:certname] || name
end


def capabilities
  compute_resource ? compute_resource.capabilities : bare_metal_capabilities
end


def bare_metal_capabilities
  [:build]
end

If you want to verify if the field is set in the db you can run:

Host.find_by_name("display2.whanganui.tasman.lan")[:certname]