Clean "Last execution failed" from host

Problem:

Previosly I worked with ssh user to remote execution jobs, but now i delete my ssh users and work with puppet (for security reasons).

My problem is that i cant clean my host status because i don’t have ssh users for run a success job.

can i only clean my last execution status?

Expected outcome:

Foreman and Proxy versions:

Foreman and Proxy plugin versions:

Other relevant data:
[e.g. logs from Foreman and/or the Proxy, modified templates, commands issued, etc]
(for logs, surround with three back-ticks to get proper formatting, e.g.)

logs

Not at the moment unfortunately. The only way is running some successful command. You could delete that from database if the need be. It would be good RFE to have possibility to remediate or “override” any host sub status.

thanks Marek

I changed it from the database.

the query if anyone need it:

foreman=# select * from host_status where host_id=45;
 id  |              type               | status | host_id |        reported_at
-----+---------------------------------+--------+---------+----------------------------
 273 | Katello::ErrataStatus           |      0 |      45 | 2019-03-11 19:57:08.542461
 279 | HostStatus::ConfigurationStatus |      1 |      45 | 2019-03-12 14:27:37
 280 | HostStatus::ExecutionStatus     |      1 |      45 | 2019-01-18 15:51:15.704883
 277 | Katello::PurposeAddonsStatus    |      0 |      45 | 2019-01-18 15:50:07.764444
 278 | Katello::PurposeStatus          |      0 |      45 | 2019-01-18 15:50:07.76734
 272 | Katello::SubscriptionStatus     |      0 |      45 | 2019-01-18 15:50:07.585902
 274 | Katello::PurposeSlaStatus       |      0 |      45 | 2019-01-18 15:50:07.753543
 275 | Katello::PurposeRoleStatus      |      0 |      45 | 2019-01-18 15:50:07.757329
 276 | Katello::PurposeUsageStatus     |      0 |      45 | 2019-01-18 15:50:07.76103
(9 rows)

foreman=# update host_status set status=0 where id=280;
UPDATE 1
1 Like