Bug #14369: When creating new organization, host selection step won't show, if the user is n context of different organization. - Foreman

Bug #14369

When creating new organization, host selection step won't show, if the user is n context of different organization.

Added by Shimon Shtein almost 5 years ago. Updated over 2 years ago.

Status:

Closed

Priority:

Normal

Assignee:

Shimon Shtein

Category:

Organizations and Locations

Target version:

1.12.0

Difficulty:

Triaged:

Bugzilla link:

1321826

Pull request:

https://github.com/theforeman/foreman/pull/3371

Fixed in Releases:

Found in Releases:

Description

Steps to reproduce:

1. Make sure you have a host without organization.
2. Pick an organization for your context (Make sure you have organization name instead of "Any context")
3. Create a new organization

Expected: Redirection to "Step 2" - hosts selector

Actual: Redirection to Edit organization screen.

The problem is in #count_nil_hosts, it uses Host.where(taxonomy_id => nil).count to check for unassigned hosts.
By default this is scoped:

Host.where(taxonomy_id => nil).to_sql
#=> "SELECT \"hosts\".* FROM \"hosts\"  WHERE \"hosts\".\"type\" IN ('Host::Managed') AND \"hosts\".\"location_id\" IN (12) AND \"hosts\".\"location_id\" IS NULL"

This query will always return 0.

Related issues