clickhouse

## 安装

根据官方文档安装即可

https://clickhouse.com/docs/zh/getting-started/install

使用其中 RPM

## 配置

```
vim /etc/clickhouse-server/config.xml
```

修改 http[s] 端口 => 18123

```
# http端口
<http_port>8123</http_port>
```

```
# tcp 端口
修改端口 9000 => 19000
```

## 开放外网访问

```
vim /etc/clickhouse-server/config.xml

## 取消注释 
<listen_host>0.0.0.0</listen_host>
```

防火墙
firewall-cmd --add-port=19000/tcp --permanent
firewall-cmd --add-port=18123/tcp --permanent
# 重新加载防火墙配置
firewall-cmd --reload

## 修改 default 密码

生成密码密文
```
PASSWORD=$(base64 < /dev/urandom | head -c8); echo "$PASSWORD";
echo -n "$PASSWORD" | sha256sum | tr -d '-'
```
第一行是密码明文，第二行是密码密文

```
touch /etc/clickhouse-server/users.xml
```

从 https://github.com/ClickHouse/ClickHouse/blob/master/programs/server/users.xml 复制粘贴，不用重启，实时生效

```
<clickhouse>

<profiles>
        
        <default>
        </default>

<readonly>
            <readonly>1</readonly>
        </readonly>
    </profiles>

<users>
        
        <default>
            <password>Dev123456</password>
            <networks>
                <ip>::/0</ip>
            </networks>

<profile>default</profile>

<quota>default</quota>

</default>
    </users>

<quotas>
        
        <default>
            
            <interval>
                
                <duration>3600</duration>

<queries>0</queries>
                <errors>0</errors>
                <result_rows>0</result_rows>
                <read_rows>0</read_rows>
                <execution_time>0</execution_time>
            </interval>
        </default>
    </quotas>
</clickhouse>
```

## 修改存储目录

```
ln -s /data/clickhouse /var/lib/clickhouse
chown -R /data/clickhouse
chown -R /var/lib/clickhouse
```

如果之前已有存储目录，需要将存储先迁出至指定目录

## 启停

```
/etc/init.d/clickhouse-server start
/etc/init.d/clickhouse-server stop
```

## 授权

参考 https://www.jianshu.com/p/70723b1d6703

```
vim /etc/clickhouse-server/users.xml
取消注释 access_management 这一行
```

## 手动启动来判断哪里出了问题

```
sudo --preserve-env -u 'clickhouse' /usr/bin/clickhouse-server --config-file /etc/clickhouse-server/config.xml --pid-file /var/run/clickhouse-server/clickhouse-server.pid
```

## 附录

### 修改 data 目录时遇到的问题

参考 https://www.osyunwei.com/archives/13496.html

然后一直报错说 无法 Permission denied "preprocessed_configs"

后来强行把目录全都改成 root:root 了
初步怀疑是不能放在某个 用户的目录下，需要找个干净的数据目录

然后验证了下，果然如此，以下是可以行得通的步骤

```
vim /etc/clickhouse-server/config.xml
把路径为 /var/lib/clickhouse 都改成指定的数据存储路径 /home/data/clickhouse/
```

```
chown -R clickhouse:clickhouse /var/lib/clickhouse

chown -R clickhouse:clickhouse /var/log/clickhouse-server

chown -R clickhouse:clickhouse /etc/clickhouse-server

chown -R clickhouse:clickhouse /etc/clickhouse-client

chmod 755 /var/lib/clickhouse -R

chmod 755 /var/log/clickhouse-server -R

chmod 755 /etc/clickhouse-server -R

chmod 755 /etc/clickhouse-client -R
```

```
chown -R clickhouse:clickhouse /home/data/clickhouse/
chmod -R 755 /home/data/clickhouse/
```

```
sudo --preserve-env -u 'clickhouse' /usr/bin/clickhouse-server --config-file /etc/clickhouse-server/config.xml --pid-file /var/run/clickhouse-server/clickhouse-server.pid
```

最后最后，直接用软链其实就可以解决，记得修改软链和源存储地址的 own 为 clickhouse:clickhouse 即可

```
mv /var/lib/clickhouse ~/infra/clickhouse/clickhouse-data
chmod a+rwx ~/infra/clickhouse/clickhouse-data
ln -s ~/infra/clickhouse/clickhouse-data /var/lib/clickhouse
```
```

## 参考

权限设置
https://www.cnblogs.com/MrYang-11-GetKnow/p/15895715.html

逆风起笔