Cambiare la password di default di clickhouse per ntop

Tipologie di password

Password in SHA256

Generare la password:

PASSWORD=default; echo "$PASSWORD"; echo -n "$PASSWORD" | sha256sum | tr -d '-'

default
37a8eec1ce19687d132fe29051dca629d164e2c4958ba141d5f4133a33f0688f  

vi /etc/clickhouse-server/users.d/default-password.xml

<clickhouse>
    <users>
        <default>
          <password_sha256_hex>37a8eec1ce19687d132fe29051dca629d164e2c4958ba141d5f4133a33f0688f</password_sha256_hex>
        </default>
    </users>
</clickhouse>

Password in cleartext

vi /etc/clickhouse-server/users.d/default-password.xml

<clickhouse>
    <users>
        <default>
            <password>default</password>
        </default>
    </users>
</clickhouse>

Riavvio e test

systemctl restart clickhouse.service

journalctl -u clickhouse.service -xe

less /var/log/clickhouse-server/clickhouse-server.err.log

• Se non va, perchè dice

More than one field of 'password', 'password_sha256_hex', 'password_double_sha1_hex', 'no_password', 'ldap', 'kerberos', 'ssl_certificates', 'ssh_keys', 'http_authentication' are used to specify authentication info for user default. Must be only one of them.: while parsing user 'default' in users configuration file: while loading configuration file '/etc/clickhouse-server/users.xml'

Spostare il commento in

vi /etc/clickhouse-server/users.xml

           <password></password>
           -->
systemctl restart clickhouse.service

clickhouse-client --password

Riferimenti

• User Settings | ClickHouse Docs