clickhouse的21.6.9.7版本安装问题记录

配置完成后连接： clickhouse-client 报

ClickHouse client version 21.6.9.7 (official build).
Connecting to localhost:9001 as user default.
Code: 210. DB::NetException: Connection refused (localhost:9001)

看错误日志：cat /var/log/clickhouse-server/clickhouse-server.err.log 

报错 DB::Exception: Cancelled merging parts, Stack trace (when copying this message, always include the lines below):

看日志： cat /var/log/clickhouse-server/clickhouse-server.log

 

可以看到错误信息：

Error loading private key from file /etc/clickhouse-server/server.key: error:02000002:system library:OPENSSL_internal:No such file or directory (version 21.6.9.7 (official build))
2022.06.16 14:06:14.025658 [ 4361 ] {} <Trace> MySQLHandlerFactory: Failed to read RSA key pair from server certificate. Error: Code: 76, e.displayText() = DB::Exception: Cannot open certificate file: /etc/clickhouse-server/server.crt. (version 21.6.9.7 (official build))

表明：/etc/clickhouse-server/server.key文件不存在

执行命令：

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

如下图显示表明生成成功 未执行前

 执行后

 表示生成成功

启动查看日志

发现还有问题：

Error opening Diffie-Hellman parameters file /etc/clickhouse-server/dhparam.pem

显示/etc/clickhouse-server/dhparam.pem文件不存在

 执行命令： openssl dhparam -out /etc/clickhouse-server/dhparam.pem 4096

表明文件已经生成完毕

看日志没有报错

连接客户端还是报连接失败

 后来发现需要带一个参数

clickhouse-client --host 127.0.0.1 --port 9001

使用命令查询节点信息：select * from system.clusters;

select * from system.clusters;

 

 

终于连接成功~~~感动~~~

clickhouse 数据存放在 /var/lib/clickhouse/data/

clickhouse 日志存放在 /var/log/clickhouse-server/