Control: Pod containers should have etcd peer certfile and peer keyfile configured appropriately
Description
This check ensures that the container in the Pod has etcd peer certfile and peer keyfile configured appropriately.
Usage
Run the control in your terminal:
powerpipe control run kubernetes_compliance.control.pod_container_argument_etcd_peer_certfile_and_peer_keyfile_configured
Snapshot and share results via Turbot Pipes:
powerpipe loginpowerpipe control run kubernetes_compliance.control.pod_container_argument_etcd_peer_certfile_and_peer_keyfile_configured --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') @> '["etcd"]') then 'ok' when (c -> 'command') @> '["etcd"]' and ( not (c ->> 'command' like '%--peer-cert-file%') or not (c ->> 'command' like '%--peer-key-file%') ) then 'alarm' else 'ok' end as status, case when (c -> 'command') is null then c ->> 'name' || ' command not defined.' when not ((c -> 'command') @> '["etcd"]') then c ->> 'name' || ' etcd not defined.' when (c -> 'command') @> '["etcd"]' and( not (c ->> 'command' like '%--peer-cert-file%') or not (c ->> 'command' like '%--peer-key-file%') ) then c ->> 'name' || ' etcd peer certfile and peer keyfile not set.' else c ->> 'name' || ' etcd peer certfile and peer keyfile set.' end as reason, name as pod_name , coalesce(context_name, '') as context_name, namespace, source_type, coalesce(path || ':' || start_line || '-' || end_line, '') as pathfrom kubernetes_pod, jsonb_array_elements(containers) as c;