turbot/steampipe-mod-docker-compliance

Control: 3.11 Ensure that Docker server certificate file ownership is set to root:root

Description

You should verify that the Docker server certificate file (the file that is passed along with the --tlscert parameter) is individual owned and group owned by root.

The Docker server certificate file should be protected from any tampering. It is used to authenticate the Docker server based on the given server certificate. It must therefore be individually owned and group owned by root to prevent modification by less privileged users.

Remediation

The following command could be executed:

chown root:root <path to Docker server certificate file>

This sets the individual ownership and group ownership for the Docker server certificate file to root.

Default Value

By default, the ownership and group-ownership for Docker server certificate file is correctly set to root.

Usage

Run the control in your terminal:

powerpipe control run docker_compliance.control.cis_v160_3_11

Snapshot and share results via Turbot Pipes:

powerpipe login
powerpipe control run docker_compliance.control.cis_v160_3_11 --share

SQL

This control uses a named query:

with os_output as (
select
btrim(stdout_output, E' \n\r\t') as os,
_ctx ->> 'connection_name' as os_conn
from
exec_command
where
command = 'uname -s'
), hostname as (
select
btrim(stdout_output, E' \n\r\t') as host,
_ctx ->> 'connection_name' as host_conn,
_ctx
from
exec_command
where
command = 'hostname'
),
linux_output as (
with json_value_cte as (
select
-- Use the colon as a "true" command that returns an empty string
case when stdout_output = '' or (stdout_output::jsonb->>'tlscacert') is null then ':' else 'stat -c %U:%G ' || (stdout_output::jsonb->>'tlscert') || ' | grep -v root:root' end as key_value,
_ctx ->> 'connection_name' as os_conn
from
exec_command,
os_output
where
os_conn = _ctx ->> 'connection_name'
and command = 'cat /etc/docker/daemon.json'
order by
key_value
)
select
stdout_output,
_ctx ->> 'connection_name' as conn
from
json_value_cte as a
join
exec_command
on command = a.key_value
where
os_conn = _ctx ->> 'connection_name'
)
select
host as resource,
case
when os.os ilike '%Darwin%' then 'skip'
when o.stdout_output = '' then 'skip'
when btrim(o.stdout_output, E'\r\n\t') = 'root:root' then 'ok'
else 'alarm'
end as status,
case
when os.os ilike '%Darwin%' then host || ' /etc/docker/daemon.json does not exist on ' || os.os || ' OS.'
when o.stdout_output = '' then host || ' TLS CA certificate file does not exist.'
when btrim(o.stdout_output, E'\r\n\t') = 'root:root' then host || ' server certificate file ownership is set to root:root.'
else host || ' server certificate file ownership is set to ' || (btrim(o.stdout_output, E' \n\r\t')) || '.'
end as reason
, h._ctx ->> 'connection_name' as connection_name
from
hostname as h,
os_output as os,
linux_output as o
where
os.os_conn = h.host_conn
and h.host_conn = o.conn;

Tags