Control: Replication Controller containers argument basic auth file should not be set
Description
This check ensures that the container in the Replication Controller does not have an argument basic auth file set.
Usage
Run the control in your terminal:
powerpipe control run kubernetes_compliance.control.replication_controller_container_no_argument_basic_auth_file
Snapshot and share results via Turbot Pipes:
powerpipe loginpowerpipe control run kubernetes_compliance.control.replication_controller_container_no_argument_basic_auth_file --share
SQL
This control uses a named query:
select coalesce(uid, concat(path, ':', start_line)) as resource, case when (c -> 'command') is null or not ((c -> 'command') @> '["kube-apiserver"]') then 'ok' when (c -> 'command') @> '["kube-apiserver"]' and (c ->> 'command' like '%--basic-auth-file%') then 'alarm' else 'ok' end as status, case when (c -> 'command') is null then c ->> 'name' || ' command not defined.' when not ((c -> 'command') @> '["kube-apiserver"]') then c ->> 'name' || ' kube-apiserver not defined.' when (c -> 'command') @> '["kube-apiserver"]' and (c ->> 'command' like '%--basic-auth-file%') then c ->> 'name' || ' basic auth file set.' else c ->> 'name' || ' basic auth file not set.' end as reason, name as replication_controller_name , coalesce(context_name, '') as context_name, namespace, source_type, coalesce(path || ':' || start_line || '-' || end_line, '') as pathfrom kubernetes_replication_controller, jsonb_array_elements(template -> 'spec' -> 'containers') as c;