clickhouse 安装启动报<Error> Application: DB::Exception: There is no profile ‘default’ in configuration file. 以及常见的错误的总结

1、启动时报错

csharp;gutter:true; 2021.08.07 15:05:30.719723 [ 1 ] {} : Starting ClickHouse 19.4.5.35 with revision 54416 2021.08.07 15:05:30.723015 [ 1 ] {} Application: starting up 2021.08.07 15:05:30.725499 [ 1 ] {} Application: Will mlockall to prevent executable memory from being paged out. It may take a few seconds.</p> <p>2021.08.07 15:05:30.765438 [ 1 ] {} Application: The memory map of clickhouse executable has been mlock'ed 2021.08.07 15:05:30.765680 [ 1 ] {} Application: rlimit on number of file descriptors is 128000 2021.08.07 15:05:30.765701 [ 1 ] {} Application: Initializing DateLUT.</p> <p>2021.08.07 15:05:30.765718 [ 1 ] {} Application: Initialized DateLUT with time zone ‘.

2021.08.07 15:05:30.769868 [ 1 ] {} ConfigReloader: Loading config /etc/clickhouse-server/config.xml' 2021.08.07 15:05:30.773574 [ 1 ] {} Application: Shutting down storages.</p> <p>2021.08.07 15:05:30.773606 [ 1 ] {} Application: Shutted down storages.</p> <p>2021.08.07 15:05:30.774008 [ 1 ] {} Application: Destroyed global context.</p> <p>2021.08.07 15:05:30.774584 [ 1 ] {} Application: DB::Exception: There is no profile 'default' in configuration file.</p> <p>2021.08.07 15:05:30.774617 [ 1 ] {} Application: shutting down 2021.08.07 15:05:30.774630 [ 1 ] {} Application: Uninitializing subsystem: Logging Subsystem 2021.08.07 15:05:30.774735 [ 2 ] {} BaseDaemon: Stop SignalListener thread</p> <pre><code> 这是因为在config.xml中设置了 但是并没有在 config.xml中指定 这个标签元素，导致 default_profile无法和users.xml 中的default profile 关联起来。 config.xml 配置参考： ;gutter:true;
error
/data/clickhouse/logs/clickhouse.log
/data/clickhouse/logs/error.log
500M
5

8123
9000
9009
本机IP

0.0.0.0
4096
800
800
300
1000
8589934592
5368709120
/data/clickhouse/
/data/clickhouse/tmp/
users.xml
default
1
default

3600
3600
300
0

300
600
2

0
0

/clickhouse/task_queue/ddl

/etc/clickhouse-server/metrika.xml

user.xml配置参考：

html;gutter:true; 10000000000 0 random</p> <pre><code>10000000000 0 random 1 0 0 0 0 0 65b84b497ef843f7c9629251a64e307caecbf7327975af4d18f83261239e1460 ::/0 default default 65b84b497ef843f7c9629251a64e307caecbf7327975af4d18f83261239e1460 ::/0 readonly default </code></pre> <pre><code> metrika.xml 集群信息配置文件参考： ;gutter:true;
true

192.68.1.1
9000
default
password

192.68.1.2
9000
default
password

true

192.68.1.3
9000
default
password

192.68.1.4
9000
default
password

192.68.1.5
2181

192.68.1.6
2181

192.68.1.7
2181

01
01
192.68.1.1

::/0

10000000000
0.01
lz4

2、ubuntu上安装时，可以从如下国内网站下载相关的lib：https://mirrors.tuna.tsinghua.edu.cn/clickhouse/deb/stable/main/

3、如何修改时区 config.xml

4、对外开放连接：取消 注释（config.xml ）

5、报错： <span class="tag"><error><span class="pln"> Application: DB::Exception: Effective user of the process (root) does not match the owner of the data (clickhouse). Run under 'sudo -u clickhouse'.</span></error></span>

更改目录/etc/clickhouse-server： chown -R clickhouse:clickhouse /etc/clickhouse-server

更改目录/var/log/clickhouse-server：chown -R clickhouse:clickhouse /var/log/clickhouse-server

<span class="pln">&#xA0;&#x4F7F;&#x7528;</span> <span class="pln">sudo <span class="pun">-<span class="pln">u clickhouse clickhouse<span class="pun">-<span class="pln">server <span class="pun">--<span class="pln">config<span class="pun">-<span class="pln">file<span class="pun">=<span class="str">/etc/<span class="pln">clickhouse<span class="pun">-<span class="pln">server<span class="pun">/<span class="pln">config<span class="pun">.<span class="pln">xml <span class="pun">&&#xA0; &#x8FDB;&#x884C;&#x542F;&#x52A8;&#x3002;</span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span>

6、centos7 安装clickhouse

1）、纯rpm安装：

wget --content-disposition https://packagecloud.io/Altinity/clickhouse/packages/el/7/clickhouse-server-common-20.3.12.112-1.el7.x86_64.rpm/download.rpm

wget --content-disposition https://packagecloud.io/Altinity/clickhouse/packages/el/7/clickhouse-server-20.3.12.112-1.el7.x86_64.rpm/download.rpm

wget --content-disposition https://packagecloud.io/Altinity/clickhouse/packages/el/7/clickhouse-common-static-20.3.12.112-1.el7.x86_64.rpm/download.rpm

wget --content-disposition https://packagecloud.io/Altinity/clickhouse/packages/el/7/clickhouse-client-20.3.12.112-1.el7.x86_64.rpm/download.rpm

rpm -ivh ./*.rpm

2）、yum 安装

• 下载仓库

curl -s
https://packagecloud.io/install/repositories/altinity/clickhouse/script.rpm.sh
| sudo os=centos dist=7 bash

• 查看安装包

sudo yum list 'clickhouse*'

• 安装服务

sudo yum install -y clickhouse-server clickhouse-client

• 查看安装列表

sudo yum list installed 'clickhouse*'

• 控制台输出

Installed Packages
clickhouse-client.noarch
clickhouse-common-static.x86_64
clickhouse-server.noarch

7、centos8 安装clickhouse

第一步：安装 clickhouse-server 和 clickhouse-client

yum install yum-utils
rpm –import https://repo.clickhouse.tech/CLICKHOUSE-KEY.GPG
yum-config-manager –add-repo https://repo.clickhouse.tech/rpm/clickhouse.repo
yum install clickhouse-server clickhouse-client -y

第二步：启动服务
systemctl status clickhouse-server.service

[TencentCloudSDKException] code:FailedOperation.ServiceIsolate message:service is stopped due to arrears, please recharge your account in Tencent Cloud requestId:5d37aa3e-e41f-426e-9e76-d08b2fe64ce9

设置用户名密码
PASSWORD=$(base64 < /dev/urandom | head -c8); echo “$PASSWORD”; echo -n “$PASSWORD” | sha1sum | tr -d ‘-‘ | xxd -r -p | sha1sum | tr -d ‘-‘
[TencentCloudSDKException] code:FailedOperation.ServiceIsolate message:service is stopped due to arrears, please recharge your account in Tencent Cloud requestId:70937417-8cb6-49ea-a5eb-f85f1d0b8d27

BOWrM6eD
dc1f916aa271ba4147cfc9eb7116195d6d7c2b69920a7fd2b356f09f201cd924

修改配置文件
vim /etc/clickhouse-server/users.xml
找到 users –> default –> 标签下的password修改成password_sha256_hex，并把密文填进去

[TencentCloudSDKException] code:FailedOperation.ServiceIsolate message:service is stopped due to arrears, please recharge your account in Tencent Cloud requestId:12eb6380-d17a-4cad-89a1-b0a587daf921

clickhouse-client -h 127.0.0.1 -d default -m -u default –password BOWrM6eD

第五步：开放外网访问
vim /etc/clickhouse-server/config.xml
找到 listen_host 标签，修改为以下

重启一下clickhouse服务
systemctl restart clickhouse-server

8、参考资料：

如何搭建ClickHouse 分布式高可用集群搭建：https://www.bbsmax.com/A/ke5j0nNozr/

clickhouse配置文件说明：https://www.cnblogs.com/gentlescholar/p/15043234.html

Original: https://www.cnblogs.com/laoqing/p/15112701.html
Author: 张永清
Title: clickhouse 安装启动报<Error> Application: DB::Exception: There is no profile ‘default’ in configuration file. 以及常见的错误的总结