Control: PodTemplate containers argument basic auth file should not be set
Description
This check ensures that the PodTemplate container does not have an argument basic auth file set.
Usage
Run the control in your terminal:
powerpipe control run kubernetes_compliance.control.pod_template_container_no_argument_basic_auth_file
Snapshot and share results via Turbot Pipes:
powerpipe loginpowerpipe control run kubernetes_compliance.control.pod_template_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 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 (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 pod_template_name , coalesce(context_name, '') as context_name, namespace, source_type, coalesce(path || ':' || start_line || '-' || end_line, '') as pathfrom kubernetes_pod_template, jsonb_array_elements(template -> 'spec' -> 'containers') as c;