Control: 3.9 Ensure that TLS CA certificate file ownership is set to root:root

Description

You should verify that the TLS CA certificate file (the file that is passed along with the --tlscacert parameter) is individually owned and group owned by root.

The TLS CA certificate file should be protected from any tampering. It is used to authenticate the Docker server based on a given CA certificate. It must be therefore be individually owned and group owned by root to ensure that it cannot be modified by less privileged users.

Remediation

The following command could be executed:

chown root:root <path to TLS CA certificate file>

This sets the individual ownership and group ownership for the TLS CA certificate file to root.

Default Value

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

Usage

Run the control in your terminal:

powerpipe control run docker_compliance.control.cis_v160_3_9

Snapshot and share results via Turbot Pipes:

powerpipe login
powerpipe control run docker_compliance.control.cis_v160_3_9 --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->>'tlscacert') || ' | grep 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 || ' TLS CA certificate file ownership is set to root:root.'
    else host || ' TLS CA 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;

Control: 3.9 Ensure that TLS CA certificate file ownership is set to root:root

Description

Remediation

Default Value

Usage

SQL

Tags