Project

General

Profile

Actions

Bug #16883

closed

Cannot display Puppet info at SmartProxy page

Added by Yama Kasi about 8 years ago. Updated about 8 years ago.

Status:
Duplicate
Priority:
Normal
Assignee:
-
Category:
-
Target version:
-
Difficulty:
medium
Triaged:
Fixed in Releases:
Found in Releases:

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.


Related issues 1 (0 open1 closed)

Is duplicate of Foreman - Bug #16627: Puppet general tab new error on 1.12.3ClosedTomer Brisker09/20/2016Actions
Actions

Also available in: Atom PDF