clickhouse安装日记

原创已于 2022-03-27 01:22:18 修改 · 2.9k 阅读

1 ·

CC 4.0 BY-SA版权

文章标签：

#数据库

于 2022-03-26 23:26:40 首次发布

clickhouse 专栏收录该内容

1 篇文章

订阅专栏

本文介绍了在CentOS8系统中安装ClickHouse的过程，包括解决依赖问题及GPG检查失败的方法。

# 下载安装包

下载地址：Index of /repos/clickhouse

# 安装

rpm -ivh *.rpm
错误：依赖检测失败：
        libcrypto.so.10()(64bit) 被 clickhouse-compressor-1.1.54236-4.el7.x86_64 需要
        libicudata.so.50()(64bit) 被 clickhouse-compressor-1.1.54236-4.el7.x86_64 需要
        libicui18n.so.50()(64bit) 被 clickhouse-compressor-1.1.54236-4.el7.x86_64 需要
        libicuuc.so.50()(64bit) 被 clickhouse-compressor-1.1.54236-4.el7.x86_64 需要
        libodbc.so.2()(64bit) 被 clickhouse-compressor-1.1.54236-4.el7.x86_64 需要
        libssl.so.10()(64bit) 被 clickhouse-compressor-1.1.54236-4.el7.x86_64 需要
        libcrypto.so.10()(64bit) 被 clickhouse-server-1.1.54236-4.el7.x86_64 需要
        libcrypto.so.10(libcrypto.so.10)(64bit) 被 clickhouse-server-1.1.54236-4.el7.x86_64 需要
        libicudata.so.50()(64bit) 被 clickhouse-server-1.1.54236-4.el7.x86_64 需要
        libicui18n.so.50()(64bit) 被 clickhouse-server-1.1.54236-4.el7.x86_64 需要
        libicuuc.so.50()(64bit) 被 clickhouse-server-1.1.54236-4.el7.x86_64 需要
        libodbc.so.2()(64bit) 被 clickhouse-server-1.1.54236-4.el7.x86_64 需要
        libreadline.so.6()(64bit) 被 clickhouse-server-1.1.54236-4.el7.x86_64 需要
        libssl.so.10()(64bit) 被 clickhouse-server-1.1.54236-4.el7.x86_64 需要
        libssl.so.10(libssl.so.10)(64bit) 被 clickhouse-server-1.1.54236-4.el7.x86_64 需要
        libtinfo.so.5()(64bit) 被 clickhouse-server-1.1.54236-4.el7.x86_64 需要

# 解决依赖

# 安装工具

yum install yum-utils

# 检查依赖包

repoquery --requires --resolve  *.rpm
CentOS-8 - AppStream                                                                                                                                                                                      44 kB/s | 4.4 kB     00:00    
CentOS-8 - Base                                                                                                                                                                                           50 kB/s | 3.9 kB     00:00    
CentOS-8 - Extras                                                                                                                                                                                         46 kB/s | 3.0 kB     00:00    
bash-0:4.4.20-3.el8.x86_64
clickhouse-server-0:1.1.54236-4.el7.x86_64
clickhouse-server-common-0:1.1.54236-4.el7.x86_64
compat-openssl10-1:1.0.2o-3.el8.x86_64
glibc-0:2.28-196.el8.i686
glibc-0:2.28-196.el8.x86_64
libgcc-0:8.5.0-10.el8.x86_64
libstdc++-0:8.5.0-10.el8.x86_64
libtool-ltdl-0:2.4.6-25.el8.x86_64
ncurses-compat-libs-0:6.1-9.20180224.el8.x86_64
unixODBC-0:2.3.7-1.el8.x86_64
zlib-0:1.2.11-17.el8.x86_64

# 安装依赖

yum install -y bash-0:4.4.20-3.el8.x86_64 compat-openssl10-1:1.0.2o-3.el8.x86_64 glibc-0:2.28-196.el8.i686 glibc-0:2.28-196.el8.x86_64 libgcc-0:8.5.0-10.el8.x86_64 libstdc++-0:8.5.0-10.el8.x86_64 libtool-ltdl-0:2.4.6-25.el8.x86_64 ncurses-compat-libs-0:6.1-9.20180224.el8.x86_64 unixODBC-0:2.3.7-1.el8.x86_64 zlib-0:1.2.11-17.el8.x86_64

# 再来安装

rpm -ivh *.rpm
错误：依赖检测失败：
        libicudata.so.50()(64bit) 被 clickhouse-compressor-1.1.54236-4.el7.x86_64 需要
        libicui18n.so.50()(64bit) 被 clickhouse-compressor-1.1.54236-4.el7.x86_64 需要
        libicuuc.so.50()(64bit) 被 clickhouse-compressor-1.1.54236-4.el7.x86_64 需要
        libicudata.so.50()(64bit) 被 clickhouse-server-1.1.54236-4.el7.x86_64 需要
        libicui18n.so.50()(64bit) 被 clickhouse-server-1.1.54236-4.el7.x86_64 需要
        libicuuc.so.50()(64bit) 被 clickhouse-server-1.1.54236-4.el7.x86_64 需要
        libreadline.so.6()(64bit) 被 clickhouse-server-1.1.54236-4.el7.x86_64 需要

# 确认一下是否安装成功：

find /usr -name libicu*
/usr/lib64/libicutu.so.60.3
/usr/lib64/libicudata.so.60
/usr/lib64/libicudata.so.60.3
/usr/lib64/libicuuc.so.60
/usr/lib64/libicui18n.so.60
/usr/lib64/libicuuc.so.60.3
/usr/lib64/libicui18n.so.60.3
/usr/lib64/libicuio.so.60
/usr/lib64/libicuio.so.60.3
/usr/lib64/libicutest.so.60
/usr/lib64/libicutest.so.60.3
/usr/lib64/libicutu.so.60
/usr/lib64/libicudata.so
/usr/lib64/libicui18n.so
/usr/lib64/libicuio.so
/usr/lib64/libicutest.so
/usr/lib64/libicutu.so
/usr/lib64/libicuuc.so
/usr/share/licenses/libicu
/usr/share/licenses/libicu-devel
/usr/share/doc/libicu-devel

不对了，这个是 CentOS 7 的安装包，尴尬了，我的系统是 CentOS 8。但是，方法应该是通用的。

CentOS 8 可以使用的源：

# 添加源
yum-config-manager --add-repo https://repo.yandex.ru/clickhouse/rpm/stable/x86_64/

# 安装
yum install clickhouse-server clickhouse-client 
结果会报错：  错误：GPG 检查失败

# 如何解决：
yum install clickhouse-server clickhouse-client  --nogpgcheck

# 另外，后来我又查到还有这种方式不知道是否可行（我没有验证过）：


If you are using “dnf config-manager –add-repo” to add a repository, the command does not add the GPG key file location configuration for that repository. A package installation would fail, as by default, dnf enables gpgcheck. It equires the GPG key to be set or imported.

1. Manually set and import the GPG key file location:
rpm --import "file:///etc/pki/rpm-gpg/RPM-GPG-KEY-oracle"

or

2. Add or set the GPG key for all of the individual repository entries under /etc/yum.repos.d:

gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-oracle


这样想必可以去掉


亦或者，参照这个链接来处理：
https://joelitechlife.ca/2021/12/08/yum-gpg-check-failed-or-package-no-digest/

CentOS 8 安装成功