Use cliclhouse server and client

 使用

command : clickhouse server

1. Use current user to run : clickhouse server, it will use config.xml under current path

2. Use clickhouse user : sudo -u clickhouse clickhouse server -C /etc/clickhouse_server/config.xml

Now, it will use /etc/clickhouse_server/config.xml

In the file , check the line

<users_xml> : define the default user path

<path>/var/lib/clickhouse/</path>

Set up TLS

1. create https certificate under /etc/clickhouse_server

openssl req -subj "/CN=localhost" -new -newkey rsa:2048 -days 365 -nodes -x509 -keyout /etc/clickhouse-server/server.key -out /etc/clickhouse-server/server.crt

2. config https and secure grpc port

<https_port>8443</https_port>

<tcp_port_secure>9440</tcp_port_secure>

3. set cert

    <grpc>

        <enable_ssl>false</enable_ssl>

        <!-- The following two files are used only if enable_ssl=1 -->

        <ssl_cert_file>/etc/clickhouse-server/certs/marsnet_ca.crt</ssl_cert_file>

        <ssl_key_file>/etc/clickhouse-server/certs/marsnet_ca.key</ssl_key_file>

...

Clickhouse client

1. clickhouse client

2. input password

3. show databases

4.