1. hostname:9003 或者hostname:9000 Exception,且 telnet 端口不通
原因:服务的 IP 地址 与监听端口没有打开
解决:在临时配置文件里面添加 <listen_host>::</listen_host>
例如:
<?xml version="1.0"?>
<yandex>
<logger>
<level>trace</level>
<log>/home/clickhouse/log/clickhouse-server/clickhouse-server.log</log>
<errorlog>/home/clickhouse/log/clickhouse-server/clickhouse-server.err.log</errorlog>
</logger>
<tcp_port>9003</tcp_port>
<path>/home/clickhouse/data/clickhouse/</path>
<tmp_path>/home/clickhouse/data/clickhouse/tmp/</tmp_path>
<user_files_path>/home/clickhouse/data/clickhouse/user_files/</user_files_path>
<access_control_path>/home/clickhouse/data/clickhouse/access/</access_control_path>
<remote_servers incl="clickhouse_remote_servers" />
<zookeeper incl="zookeeper-servers" optional="true" />
<macros incl="macros" optional="true" />
<format_schema_path>/home/clickhouse/data/clickhouse/format_schemas/</format_schema_path>
<include_from>/etc/clickhouse-server/config.d/metrika.xml</include_from>
<listen_host>::</listen_host>
</yandex>
2. 修改临时 users.xml 配置文件,密码不正确或者无法登陆
原因:服务在加载配置文件
解决:稍等几分钟,重新测试数据库连接即可。