Bug #16883
closedCannot display Puppet info at SmartProxy page
Description
When I go to my smartproxies, select one and go the puppet-tab I get the following errors:
General-tab:
Oops, we're sorry but something went wrong PG::Error: ERROR: missing FROM-clause entry for table "smart_proxies" LINE 1: ..." WHERE "hosts"."type" IN ('Host::Managed') AND (("smart_pro... ^ : SELECT COUNT FROM (SELECT 1 AS count_column FROM "reports" INNER JOIN "hosts" ON "hosts"."id" = "reports"."host_id" AND "hosts"."type" IN ('Host::Managed') WHERE "reports"."type" IN ('ConfigReport') AND (status <> 0) AND "reports"."host_id" IN (SELECT "hosts"."id" FROM "hosts" WHERE "hosts"."type" IN ('Host::Managed') AND (("smart_proxies"."name" = 'BASE_FM_01'))) AND (("reports"."reported_at" >= '2016-10-06')) LIMIT 9) subquery_for_count
Environments-tab:
Failure: ERF50-5345 [Foreman::WrappedException]: Unable to connect ([ProxyAPI::ProxyException]: ERF12-2749 [ProxyAPI::ProxyException]: Unable to get environments from Puppet ([RestCli...)
I'm also not able to import the classes at the moment, this could/should be a cert issue but the query error does give a feeling that something else is not right.
PuppetCA has no issues, it shows the certs and all needed info.