环境及离线资源

系统：CentOS Linux release 7.9.2009 (Core)
JDK：17
Mysql： 8.0
OpenMetadata：1.6.7
资源下载地址：open-metadata
Elasticsearch：7.17.9

关闭防火墙

禁止防火墙

# 查看防火墙状态
systemctl status firewalld

# 关闭防火墙
systemctl stop firewalld

# 禁止开机启动
systemctl disable firewalld

关闭 SELinux

# 查看状态
getenforce 	

# 修改状态
vim /etc/selinux/config
改为如下内容：
SELINUX=permissive

# 重启机器
reboot

# 如果机器不能重启，可使用临时关闭命令
setenforce 0

创建用户

因为elasticsearch的启动不允许用root，所以建立一个elasticsearch用户
# 创建用户
useradd -U elasticsearch -d /home/elasticsearch/ -s /bin/bash

# 赋予权限
chown -R elasticsearch:elasticsearch /home/elasticsearch

# 修改密码
passwd elasticsearch

# 添加sudo权限
vim /etc/sudoers
在108行添加如下内容：
elasticsearch ALL=(ALL)      NOPASSWD: ALL

# 切换用户
su - elasticsearch

安装JDK

下载地址：JDK
也可以直接下载我的资源

# 解压
sudo tar -zxvf openjdk-17.0.0.1+2_linux-x64_bin.tar.gz -C /home/elasticsearch

# 配置环境变量
sudo vim /etc/profile

export JAVA_HOME=/home/elasticsearch/jdk-17.0.0.1
export JRE_HOME=/home/elasticsearch/jdk-17.0.0.1/jre
export CLASSPATH=.:${JAVA_HOME}/lib:${JRE_HOME}/lib
export PATH=$JAVA_HOME/bin:$PATH

# 更新
source /etc/profile

安装mysql

下载地址：Mysql
注意选择适合自己系统的安装包

# 解压
sudo tar xvf mysql-8.0.41-1.el7.x86_64.rpm-bundle.tar -C /home/elasticsearch

# 严格按照以下顺序执行命令，要不会有依赖问题
sudo rpm -ivh mysql-community-common-8.0.41-1.el7.x86_64.rpm
sudo rpm -ivh mysql-community-client-plugins-8.0.41-1.el7.x86_64.rpm
sudo rpm -ivh mysql-community-libs-8.0.41-1.el7.x86_64.rpm
sudo rpm -ivh mysql-community-client-8.0.41-1.el7.x86_64.rpm
sudo rpm -ivh mysql-community-icu-data-files-8.0.41-1.el7.x86_64.rpm
sudo rpm -ivh mysql-community-devel-8.0.41-1.el7.x86_64.rpm
sudo rpm -ivh mysql-community-server-8.0.41-1.el7.x86_64.rpm

# 查看安装版本
mysql -V

# 查看 MySQL 服务状态
sudo systemctl status mysqld

# 开启 MySQL 服务
sudo systemctl start mysqld

# 设置 MySQL 服务开机自启
sudo systemctl enable mysqld

# 查看root初始密码
cat /var/log/mysqld.log | grep 'password'

# 登录mysql
mysql -u root -p

# 修改root密码
alter user 'root'@'localhost' identified by 'yourpassword';

# 创建数据库,作为open-metadata的元数据库
CREATE DATABASE openmetadata CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

# 创建用户
CREATE USER 'openmetadata'@'%' IDENTIFIED BY 'Openmetadata_123';

# 授予权限
GRANT ALL PRIVILEGES ON openmetadata.* TO 'openmetadata'@'%';

# 刷新
FLUSH PRIVILEGES;

安装Elasticsearch

下载地址：Elasticsearch

# 解压
sudo tar -zxvf elasticsearch-7.17.9-linux-x86_64.tar.gz -C /home/elasticsearch

# 编辑配置文件
vim /home/elasticsearch/elasticsearch-7.17.9/config/elasticsearch.yml

# 修改如下内容
cluster.name: openmetadata-cluster
node.name: node-1
network.host: 0.0.0.0
http.port: 9200
path.data: /home/elasticsearch/elasticsearch-7.17.9/data  # 数据存储路径
path.logs: /home/elasticsearch/elasticsearch-7.17.9/logs  # 日志路径
discovery.type: single-node  # 添加单节点模式

# 启动测试
cd /home/elasticsearch/elasticsearch-7.17.9
./bin/elasticsearch

# 测试成功后台启动
nohup ./bin/elasticsearch &

# 打开页面，返回 JSON 格式的版本信息
http://localhost:9200

安装open-metadata

下载地址：open-metadata

# 解压
sudo tar -zxvf openmetadata-1.6.7.tar.gz -C /home/elasticsearch

# 修改配置文件
cd /home/elasticsearch/openmetadata-1.6.7
vim ./conf/openmetadata.yaml

配置如下内容：
database:
  # 之前新建的数据库在此配置
  driverClass: ${DB_DRIVER_CLASS:-com.mysql.cj.jdbc.Driver}
  user: ${DB_USER:-openmetadata}
  password: ${DB_USER_PASSWORD:-Openmetadata_123}
  url: jdbc:${DB_SCHEME:-mysql}://${DB_HOST:-localhost}:${DB_PORT:-3306}/${OM_DATABASE:-openmetadata}?${DB_PARAMS:-allowPublicKeyRetrieval=true&useSSL=false&serverTimezone=UTC}

migrationConfiguration:
  # 将路径改为绝对路径，要不容易找不到
  flywayPath: "/home/elasticsearch/openmetadata-1.6.7/bootstrap/sql/migrations/flyway"
  nativePath: "/home/elasticsearch/openmetadata-1.6.7/bootstrap/sql/migrations/native"
  extensionPath: ""

elasticsearch:
  host: "localhost"   # 若跨服务器部署，填写 Elasticsearch 实际 IP
  port: 9200
  scheme: "http"      # 离线环境无需 HTTPS
  username: ""        # 若未启用安全认证，留空
  password: ""
# 文件配置官网参考文档https://docs.open-metadata.org/latest/deployment/configuration

# 迁移数据库
cd /home/elasticsearch/openmetadata-1.6.7
./bootstrap/openmetadata-ops.sh migrate
# ./bootstrap/openmetadata-ops.sh drop-create 删除库内表再迁移命令

# 启动命令
cd /home/elasticsearch/openmetadata-1.6.7
./bin/openmetadata-server-start.sh ./conf/openmetadata.yaml

# 页面地址
http://localhost:8585/
初始账号：admin@open-metadata.org
初始密码：admin

官网地址：https://open-metadata.org/
GiHub：https://github.com/open-metadata/OpenMetadata