View source for 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 '-'

<pre class=rvmscreen>
default
37a8eec1ce19687d132fe29051dca629d164e2c4958ba141d5f4133a33f0688f  
</pre>

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

 <clickhouse>
     <users>
         <default>
           <password_sha256_hex>37a8eec1ce19687d132fe29051dca629d164e2c4958ba141d5f4133a33f0688f</password_sha256_hex></code>
         </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 

<pre class=rvmscreen>
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'
</pre>

Spostare il commento in

 vi /etc/clickhouse-server/users.xml

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

 clickhouse-client --password

=Riferimenti=
*[https://clickhouse.com/docs/en/operations/settings/settings-users User Settings | ClickHouse Docs]