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