TL;dr

打印日志到控制台

    <yandex>
        <logger>
            <level>trace</level>
            <console>1</console>
            <log>/var/log/clickhouse-server/clickhouse-server.log</log>
            <errorlog>/var/log/clickhouse-server/clickhouse-server.err.log</errorlog>
            <size>1000M</size>
            <count>10</count>
        </logger>
    </yandex>

端口

   <http_port>8123</http_port>
   <tcp_port>9000</tcp_port>
   <interserver_http_port>9009</interserver_http_port>

root@demo-clickhouse-0:/# ss -tunlp
Netid         State           Recv-Q          Send-Q                     Local Address:Port                     Peer Address:Port                                                            
tcp           LISTEN          0               64                               0.0.0.0:9009                          0.0.0.0:*              users:(("clickhouse-serv",pid=1,fd=12))          
tcp           LISTEN          0               64                               0.0.0.0:8123                          0.0.0.0:*              users:(("clickhouse-serv",pid=1,fd=10))          
tcp           LISTEN          0               64                               0.0.0.0:9000                          0.0.0.0:*              users:(("clickhouse-serv",pid=1,fd=11))          
root@demo-clickhouse-0:/# 
###
###
root@demo-clickhouse-0:/# ps aux
USER       PID %CPU %MEM    VSZ   RSS TTY      STAT START   TIME COMMAND
clickho+     1  0.0  2.7 3467192 220544 ?      Ssl  May06   1:20 /usr/bin/clickhouse-server --config-file=/etc/clickhouse-server/config.xml
root        78  0.0  0.0  20312  3936 pts/0    Ss   07:21   0:00 bash
root       514  0.0  0.0  36076  3340 pts/0    R+   07:27   0:00 ps aux
root@demo-clickhouse-0:/# 
###
###
root@demo-clickhouse-0:/# pstree -a
clickhouse-serv --config-file=/etc/clickhouse-server/config.xml
  └─36*[{clickhouse-serv}]
###
###
root@demo-clickhouse-0:/# pstree -p
clickhouse-serv(1)─┬─{clickhouse-serv}(42)
                   ├─{clickhouse-serv}(43)
                   ├─{clickhouse-serv}(44)
                   ├─{clickhouse-serv}(45)
                   ├─{clickhouse-serv}(46)
                   ├─{clickhouse-serv}(47)
                   ├─{clickhouse-serv}(48)
                   ├─{clickhouse-serv}(49)
                   ├─{clickhouse-serv}(50)
                   ├─{clickhouse-serv}(51)
                   ├─{clickhouse-serv}(52)
                   ├─{clickhouse-serv}(53)
                   ├─{clickhouse-serv}(54)
                   ├─{clickhouse-serv}(55)
                   ├─{clickhouse-serv}(56)
                   ├─{clickhouse-serv}(57)
                   ├─{clickhouse-serv}(58)
                   ├─{clickhouse-serv}(59)
                   ├─{clickhouse-serv}(60)
                   ├─{clickhouse-serv}(61)
                   ├─{clickhouse-serv}(62)
                   ├─{clickhouse-serv}(63)
                   ├─{clickhouse-serv}(64)
                   ├─{clickhouse-serv}(65)
                   ├─{clickhouse-serv}(66)
                   ├─{clickhouse-serv}(67)
                   ├─{clickhouse-serv}(68)
                   ├─{clickhouse-serv}(69)
                   ├─{clickhouse-serv}(70)
                   ├─{clickhouse-serv}(71)
                   ├─{clickhouse-serv}(72)
                   ├─{clickhouse-serv}(73)
                   ├─{clickhouse-serv}(74)
                   ├─{clickhouse-serv}(75)
                   ├─{clickhouse-serv}(76)
                   └─{clickhouse-serv}(77)


配置

/etc/clickhouse-server/config.xml
/etc/clickhouse-server/users.xml
/etc/clickhouse-server/config.d
/etc/clickhouse-server/metrica.d
/etc/clickhouse-server/users.d

# https://clickhouse.tech/docs/en/operations/configuration-files/
## 设置密码
PASSWORD=$(base64 < /dev/urandom | head -c8);
echo "$PASSWORD";
echo -n "$PASSWORD" | sha256sum | tr -d '-'
2020.05.06 15:55:43.022422 [ 1 ] {} <Error> Application: DB::Exception: More than one field of 'password', 'password_sha256_hex', 'password_double_sha1_hex' is used to specify password for user default. Must be only one of them.
2020.05.06 17:00:41.494205 [ 12 ] {} <Error> HTTPHandler: Code: 193, e.displayText() = DB::Exception: Wrong password for user default, Stack trace:

0. 0x55bfc1b7b9d0 StackTrace::StackTrace() /usr/bin/clickhouse
1. 0x55bfc1b7b7a5 DB::Exception::Exception(std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const&, int) /usr/bin/clickhouse
2. 0x55bfc1927f7f ? /usr/bin/clickhouse
3. 0x55bfc1928187 ? /usr/bin/clickhouse
4. 0x55bfc4da75d8 DB::Context::setUser(std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const&, std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const&, Poco::Net::SocketAddress const&, std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const&) /usr/bin/clickhouse
5. 0x55bfc1bfd9a3 DB::HTTPHandler::processQuery(Poco::Net::HTTPServerRequest&, HTMLForm&, Poco::Net::HTTPServerResponse&, DB::HTTPHandler::Output&) /usr/bin/clickhouse
6. 0x55bfc1c00f99 DB::HTTPHandler::handleRequest(Poco::Net::HTTPServerRequest&, Poco::Net::HTTPServerResponse&) /usr/bin/clickhouse
7. 0x55bfc59d2ef9 Poco::Net::HTTPServerConnection::run() /usr/bin/clickhouse
8. 0x55bfc59cdcd0 Poco::Net::TCPServerConnection::start() /usr/bin/clickhouse
9. 0x55bfc59ce3ed Poco::Net::TCPServerDispatcher::run() /usr/bin/clickhouse
10. 0x55bfc70b1701 Poco::PooledThread::run() /usr/bin/clickhouse
11. 0x55bfc70af4ac Poco::ThreadImpl::runnableEntry(void*) /usr/bin/clickhouse
12. 0x55bfc7824d20 ? /usr/bin/clickhouse
13. 0x7f720181a6db start_thread /lib/x86_64-linux-gnu/libpthread-2.27.so
14. 0x7f720113788f clone /lib/x86_64-linux-gnu/libc-2.27.so
 (version 19.14.9.12 (official build))


2020.05.06 17:00:32.728649 [ 1 ] {} <Information> Application: It looks like the process has no CAP_NET_ADMIN capability, 'taskstats' performance statistics will be disabled. It could happen due to incorrect ClickHouse package installation. You could resolve the problem manually with 'sudo setcap cap_net_admin=+ep /usr/bin/clickhouse'. Note that it will not work on 'nosuid' mounted filesystems. It also doesn't work if you run clickhouse-server inside network namespace as it happens in some containers.
2020.05.06 17:00:32.728669 [ 1 ] {} <Information> Application: It looks like the process has no CAP_SYS_NICE capability, the setting 'os_thread_nice' will have no effect. It could happen due to incorrect ClickHouse package installation. You could resolve the problem manually with 'sudo setcap cap_sys_nice=+ep /usr/bin/clickhouse'. Note that it will not work on 'nosuid' mounted filesystems.

ref