DataSphere Studio AppConn 部署

一、Exchangis AppConn  部署

参考文档:

https://github.com/WeBankFinTech/Exchangis/blob/master/docs/zh_CN/ch1/exchangis_appconn_deploy_cn.md

https://github.com/WeBankFinTech/Exchangis/blob/dev-1.0.0/docs/zh_CN/ch1/exchangis_deploy_cn.md

1.安装zookeeper(单机版)

复制代码
tar xf zookeeper-3.5.7.tar.gz -C /mnt/datasphere/
cd /mnt/datasphere/
ln -sv zookeeper-3.5.7/ zookeeper
cd zookeeper/conf
mv zoo_sample.cfg zoo.cfg 

vim /etc/profile.d/zookeeper.sh
export ZOOKEEPER_HOME=/mnt/datasphere/zookeeper
export ZOOCFGDIR=/mnt/datasphere/zookeeper/conf
export PATH=$PATH:${ZOOKEEPER_HOME}/bin

.  /etc/profile.d/zookeeper.sh
zkServer.sh start
zkServer.sh status
netstat -tnlp|grep 2181
复制代码

2.安装sqoop

复制代码
tar xf sqoop-1.4.6.bin__hadoop-2.0.4-alpha.tar.gz -C /mnt/datasphere/
mv mysql-connector-java-5.1.27-bin.jar /mnt/datasphere/sqoop/lib/
cd /mnt/datasphere/
ln -sv sqoop-1.4.6.bin__hadoop-2.0.4-alpha/ sqoop

vim /etc/profile.d/sqoop.sh
export PATH=${PATH}:/mnt/datasphere/sqoop/bin/
export SQOOP_HOME=/mnt/datasphere/sqoop

. /etc/profile.d/sqoop.sh

sqoop list-databases --connect jdbc:mysql://192.168.1.134:3306/ --username root  -P  #测试配置是否正常
Enter password:     #mysql root密码,根据登录的用户名称
information_schema
dss
hive
mysql
performance_schema
sys
复制代码

3.Exchangis server 安装部署

下载二进制包 具体根据官方页面提供链接下载

wget https://osp-1257653870.cos.ap-guangzhou.myqcloud.com/WeDatasphere/Exchangis/exchangis1.0.0/wedatasphere-exchangis-1.0.0.tar.gz
wget https://osp-1257653870.cos.ap-guangzhou.myqcloud.com/WeDatasphere/Exchangis/exchangis1.0.0/exchangis-appconn.zip
wget https://osp-1257653870.cos.ap-guangzhou.myqcloud.com/WeDatasphere/Exchangis/exchangis1.0.0/dist.zip

为exchangis加数据源认证的token(dss数据库)

INSERT INTO `linkis_mg_gateway_auth_token`(`token_name`,`legal_users`,`legal_hosts`,`business_owner`,`create_time`,`update_time`,`elapse_day`,`update_by`) VALUES ('EXCHANGIS-AUTH','*','*','BDP',curdate(),curdate(),-1,'LINKIS');

为exchangis加hive数据源的认证,注意替换 192.168.1.134:3306,该值为 hive数据库IP和端口

INSERT INTO `linkis_ps_dm_datasource_env` (`env_name`, `env_desc`, `datasource_type_id`, `parameter`, `create_time`, `create_user`, `modify_time`, `modify_user`) VALUES ('开发环境SIT', '开发环境SIT', 4, '{"uris":"thrift://192.168.1.134:3306", "hadoopConf":{"hive.metastore.execute.setugi":"true"}}',  now(), NULL,  now(), NULL);
INSERT INTO `linkis_ps_dm_datasource_env` (`env_name`, `env_desc`, `datasource_type_id`, `parameter`, `create_time`, `create_user`, `modify_time`, `modify_user`) VALUES ('开发环境UAT', '开发环境UAT', 4, '{"uris":"thrift://192.168.1.134:3306", "hadoopConf":{"hive.metastore.execute.setugi":"true"}}',  now(), NULL,  now(), NULL);

解压并配置

复制代码
#解压并配置参数
mkdir  /mnt/datasphere/exchangis-server/
mv wedatasphere-exchangis-1.0.0.tar.gz  /mnt/datasphere/exchangis-server/
cd  /mnt/datasphere/exchangis-server/
tar xf wedatasphere-exchangis-1.0.0.tar.gz 
vim config
/config.sh #LINKIS_GATEWAY服务地址IP,用于查找linkis-mg-gateway服务 LINKIS_GATEWAY_HOST=192.168.1.134 #LINKIS_GATEWAY服务地址端口,用于查找linkis-mg-gateway服务 LINKIS_GATEWAY_PORT=9001 #Exchangis服务端口 EXCHANGIS_PORT=9080 #Eureka服务URL EUREKA_URL=http://192.168.1.134:9600/eureka/ vim config/db.sh MYSQL_HOST=192.168.1.134 MYSQL_PORT=3306 MYSQL_USERNAME=root MYSQL_PASSWORD=Qwer@123 DATABASE=exchangis #不需要提前创建 sbin/install.sh Do you want to initalize database with sql? (Y/N)y #初始化数据库
复制代码

启动服务

sbin/daemon.sh start server

确认服务启动并注册成功

4.Exchangis 前端安装部署

复制代码
#配置Nginx
vim /etc/nginx/conf.d/exchangeis.conf server { listen 10001; server_name localhost; location / { root /appcom/Install/exchangis; # Exchangis 前端部署目录 autoindex on; } location /api { proxy_pass http://192.168.1.134:9001; # 后端linkis-mg-gateway的地址,需要修改 proxy_set_header Host $host; proxy_set_header X-Real-IP $remote_addr; proxy_set_header x_real_ipP $remote_addr; proxy_set_header remote_addr $remote_addr; proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for; proxy_http_version 1.1; proxy_connect_timeout 4s; proxy_read_timeout 600s; proxy_send_timeout 12s; proxy_set_header Upgrade $http_upgrade; proxy_set_header Connection upgrade; } error_page 500 502 503 504 /50x.html; location = /50x.html { root /usr/share/nginx/html; } }

nginx -t
nginx -s reload

mkdir /appcom/Install/exchangis
unzip dist.zip
mv dist/* /appcom/Install/exchangis


访问 http://192.168.1.134:10001/#/projectManage

 
复制代码

5.安装exchangis AppConn

复制代码
mv exchangis-appconn.zip /mnt/datasphere/dss_linkis_one-click_install_20221201/dss/dss-appconns/
cd /mnt/datasphere/dss_linkis_one-click_install_20221201/dss/dss-appconns/
unzip exchangis-appconn.zip
cd ../bin
./appconn-install.sh   #输入字符串 exchangis 以及exchangis服务的ip和端口,即可以完成安装,这里的exchangis端口是指前端端口,在nginx进行配置即10001

cd ../sbin 
sh ./dss-stop-all.sh
sh ./dss-start-all.sh
复制代码

6.验证

新建项目test2

 exchangis前端刷新页面查看是否同步

二、Visualis  AppConn 安装

参考文档:

https://github.com/WeBankFinTech/Visualis/blob/master/visualis_docs/zh_CN/Visualis_deploy_doc_cn.md

https://github.com/WeBankFinTech/Visualis/blob/master/visualis_docs/zh_CN/Visualis_appconn_install_cn.md

1.安装maven

复制代码
1.安装maven,具体版本根据文档要求,下载其他版本地址 https://archive.apache.org/dist/maven/
tar xf apache-maven-3.6.3-bin.tar.gz -C /mnt/datasphere
cd /mnt/datasphere
ln -sv apache-maven-3.6.3 maven
sudo vim /etc/profile.d/maven.sh
export MAVEN_HOME=/mnt/datasphere/maven
export PATH=$PATH:$MAVEN_HOME/bin
. /etc/profile.d/maven.sh
mvn -v
复制代码

2.安装npm

复制代码
# https://nodejs.org/dist/ 可用版本
wget --no-check-certificate https://npm.taobao.org/mirrors/node/v16.13.0/node-v16.13.0-linux-x64.tar.gz
tar xf node-v16.13.0-linux-x64.tar.gz -C /mnt/datasphere/
rm -f /usr/local/bin/node  #删除旧node,按需
rm -f /usr/local/bin/npm  #删旧npm,按需
ln -sv /mnt/datasphere/node-v16.13.0-linux-x64/bin/node /usr/local/bin/node
ln -sv /mnt/datasphere/node-v16.13.0-linux-x64/bin/npm /usr/local/bin/npm
node -v
npm -v
复制代码

3.编译后端

git clone  https://github.com/WeBankFinTech/Visualis.git
cd Visualis
git check out 1.0.0
mvn clean package -DskipTests=ture mv assembly/target/visualis-server.zip /mnt/datasphere/

4.编译前端

复制代码
cd webapp 
vim package-lock.json-bak 
g/"resolved".*/d  #删除resolved所在行

npm i --registry https://registry.npm.taobao.org
npm run build --registry https://registry.npm.taobao.org
# 卡主后如果没报错,直接ctrl+C中断,build目录就是前端代码
mkdir  /appcom/Install/visualis/dss/visualis
mv build/* /appcom/Install/visualis/dss/visualis
复制代码

5.编译visualis组件

cd visualis-appconn
mvn clean package -DskipTests=ture
mv visualis-appconn/target/visualis.zip /mnt/datasphere/dss_linkis_one-click_install_20221201/dss/dss-appconns/

6.初始化数据库

mysql -uroot -h 192.168.1.134 -p
mysql> create database visualis default character set utf8mb4 COLLATE utf8mb4_general_ci;
mysql> use visualis;
mysql> source /home/hadoop/Visualis/db/davinci.sql; #源代码db目录下
mysql> source /home/hadoop/Visualis/db/ddl.sql;

7.字体库安装

sudo yum -y install fontconfig-devel
sudo mkdir -p  /usr/share/fonts/visualis
sudo mv /home/hadoop/Visualis/ext/pf.ttf /usr/share/fonts/visualis

8.配置前端

复制代码
vim /etc/nginx/conf.d/dss.conf 
    location /dss/visualis {
    root   /appcom/Install/visualis; # 修改静态文件目录
    autoindex on;
    }
nginx -t
nginx -s reload
复制代码

9.配置后端

复制代码
cd /mnt/datasphere/
unzip visualis-server.zip
cd visualis-server/conf

vim application.yml     #根据升级情况替换
# ##################################
# 1. Visualis Service configuration   配置visualis的前端地址和端口
# ##################################
server:
  protocol: http
  address: 192.168.1.134 # server ip address
  port:  9018 # server port
  url: http://192.168.1.134:8085/dss/visualis # frontend index page full path
  access:
    address: 192.168.1.134 # frontend address
    port: 8085 # frontend port


# ##################################
# 2. eureka configuration   #配置eureka地址
# ##################################
eureka:
      defaultZone: http://192.168.1.134:9600/eureka/ # Configuration required
  instance:
    metadata-map:
      test: wedatasphere


# ##################################
# 3. Spring configuration   #数据库配置
# ##################################
spring:
  main:
    allow-bean-definition-overriding: true
  application:
    name: visualis-dev
  datasource: # visualis需要和dss部署在同一个数据库
    url: jdbc:mysql://192.168.1.134:3306/visualis?characterEncoding=UTF-8&allowMultiQueries=true # Configuration required
    username: root
    password: Qwer@123


vim linkis.properties
wds.linkis.gateway.url=http://192.168.1.134:9001

cd ../bin/
sh start-visualis-server.sh
less logs/linkis.out  #查看日志
复制代码

eureka 查看注册状态

10.安装AppConn

复制代码
cd /mnt/datasphere/dss_linkis_one-click_install_20221201/dss/dss-appconns/
unzip visualis.zip 
cd ../bin/
>> sh appconn-install.sh

# 输入Visualis名称
>> visualis

# 输入Visualis前端IP地址
>> 192.168.1.134

# 输入Visualis服务的前端端口后
>> 8085

#重启dss 服务 sh dss
-stop-all.sh sh dss-start-all.sh
复制代码

11.注意事项

在Visualis未进行部署前创建的项目里面拖拽节点,会报project is not found错误,如果需要使用需要在部署Visualis后创建

三、Streamis AppConn 安装

相关依赖参考:Linkis后端编译:https://linkis.apache.org/zh-CN/docs/1.1.1/development/linkis-compile-and-package/

1.安装scala

复制代码
wget https://downloads.lightbend.com/scala/2.11.2/scala-2.11.2.tgz
tar xf scala-2.11.2.tgz -C /mnt/datasphere/
ln -sv scala-2.11.12  scala

vim /etc/profile.d/scala.sh
export SCALA_HOME=${BASE_DIR}/scala
export PATH=$PATH:${SCALA_HOME}/bin
. etc/profile.d/scala.sh
复制代码

2.安装flink

复制代码
# 其他版本下载地址 https://archive.apache.org/dist/flink/
wget https://archive.apache.org/dist/flink/flink-1.12.2/flink-1.12.2-bin-scala_2.12.tgz
tar xf flink-1.12.2-bin-scala_2.12.tgz -C /mnt/datasphere/  #注意scala版本
cd /mnt/datasphere/
ln -sv flink-1.12.2/ flink


sudo vim /etc/profile.d/flink.sh 
# 确保HADOOP_CONF_DIR HADOOP_CLASSPATH 环境变量已经存在
export FLINK_HOME=/mnt/datasphere/flink
export FLINK_CONF_DIR=${FLINK_HOME}/conf/
export FLINK_LIB_DIR=${FLINK_HOME}/lib
export PATH=${FLINK_HOME}/bin:${FLINK_HOME}

.  /etc/profile.d/flink.sh
复制代码

3.编译Flink引擎

Flink引擎使用:https://linkis.apache.org/zh-CN/docs/1.1.1/engine-usage/flink/

Linkis引擎安装:https://linkis.apache.org/zh-CN/docs/1.1.1/deployment/engine-conn-plugin-installation/

复制代码
git clone https://github.com/apache/linkis.git
cd linkis
git checkout release-1.1.1
vim pom.xml
<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
    <version>${mysql.connector.version}</version>
    <!--<scope>test</scope>-->  #注释scope
</dependency>


mvn -N  install
mvn clean install -DskipTests
cd linkis-engineconn-plugins/engineconn-plugins/flink  #flink是对应引擎的名称
mvn clean install  # target/out/flink  目录就是引擎包
cp -r target/out/flink /mnt/datasphere/dss_linkis_one-click_install_20221201/linkis/lib/linkis-engineconn-plugins
chown -R hadoop:hadoop /mnt/datasphere
复制代码

4.添加flink引擎标签

复制代码
mysql -uroot -D dss -p   
SET @FLINK_LABEL="flink-1.12.2";
SET @FLINK_ALL=CONCAT('*-*,',@FLINK_LABEL);
SET @FLINK_IDE=CONCAT('*-IDE,',@FLINK_LABEL);

insert into `linkis_cg_manager_label` (`label_key`, `label_value`, `label_feature`, `label_value_size`, `update_time`, `create_time`) VALUES ('combined_userCreator_engineType',@FLINK_ALL, 'OPTIONAL', 2, now(), now());
insert into `linkis_cg_manager_label` (`label_key`, `label_value`, `label_feature`, `label_value_size`, `update_time`, `create_time`) VALUES ('combined_userCreator_engineType',@FLNK_IDE, 'OPTIONAL', 2, now(), now());

select @label_id := id from linkis_cg_manager_label where `label_value` = @FLINK_IDE;
insert into linkis_ps_configuration_category (`label_id`, `level`) VALUES (@label_id, 2);


INSERT INTO `linkis_ps_configuration_config_key` (`key`, `description`, `name`, `default_value`, `validate_type`, `validate_range`, `engine_conn_type`, `is_hidden`, `is_advanced`, `level`, `treeName`) VALUES ('linkis.flink.url', '例如:http://127.0.0.1:8080', '连接地址', 'http://127.0.0.1:8080', 'Regex', '^\\s*http://([^:]+)(:\\d+)(/[^\\?]+)?(\\?\\S*)?$', 'flink', 0, 0, 1, '数据源配置');
INSERT INTO `linkis_ps_configuration_config_key` (`key`, `description`, `name`, `default_value`, `validate_type`, `validate_range`, `engine_conn_type`, `is_hidden`, `is_advanced`, `level`, `treeName`) VALUES ('linkis.flink.catalog', 'catalog', 'catalog', 'system', 'None', '', 'flink', 0, 0, 1, '数据源配置');
INSERT INTO `linkis_ps_configuration_config_key` (`key`, `description`, `name`, `default_value`, `validate_type`, `validate_range`, `engine_conn_type`, `is_hidden`, `is_advanced`, `level`, `treeName`) VALUES ('linkis.flink.source', 'source', 'source', 'global', 'None', '', 'flink', 0, 0, 1, '数据源配置');



insert into `linkis_ps_configuration_key_engine_relation` (`config_key_id`, `engine_type_label_id`)
(select config.id as `config_key_id`, label.id AS `engine_type_label_id` FROM linkis_ps_configuration_config_key config
INNER JOIN linkis_cg_manager_label label ON config.engine_conn_type = 'flink' and label_value = @FLINK_ALL);

insert into `linkis_ps_configuration_config_value` (`config_key_id`, `config_value`, `config_label_id`)
(select `relation`.`config_key_id` AS `config_key_id`, '' AS `config_value`, `relation`.`engine_type_label_id` AS `config_label_id` FROM linkis_ps_configuration_key_engine_relation relation
INNER JOIN linkis_cg_manager_label label ON relation.engine_type_label_id = label.id AND label.label_value = @FLINK_ALL);

exit
复制代码

5.刷新引擎目录

su - hadoop
cd /mnt/datasphere/dss_linkis_one-click_install_20221201/linkis/sbin/
sh linkis-daemon.sh restart cg-engineplugin  #强制刷新引擎目录

mysql -uroot -D dss -p  
select * from linkis_cg_engine_conn_plugin_bml_resources #查看是否有flink数据,及创建时间

6.Streamis 后端安装部署

复制代码
mysql -uroot  -p
create database streamis default character set utf8mb4 COLLATE utf8mb4_general_ci;
wget https://osp-1257653870.cos.ap-guangzhou.myqcloud.com/WeDatasphere/Streamis/0.2.0/wedatasphere-streamis-0.2.0-dist.tar.gz
mkdir /mnt/datasphere/streamis
mv wedatasphere-streamis-0.2.0-dist.tar.gz /mnt/datasphere/streamis/
cd /mnt/datasphere/streamis/
tar xf wedatasphere-streamis-0.2.0-dist.tar.gz 
vim conf/db.sh 
MYSQL_HOST=192.168.1.134
MYSQL_PORT=3306
MYSQL_DB=streamis
MYSQL_USER=root
MYSQL_PASSWORD=Qwer@123


vim conf/config.sh  #根据实际情况替换
deployUser=hadoop
STREAMIS_PORT=9400
STREAMIS_INSTALL_HOME=/mnt/datasphere/streamis
EUREKA_INSTALL_IP=192.168.1.134
EUREKA_PORT=9600
GATEWAY_INSTALL_IP=192.168.1.134
GATEWAY_PORT=9001
STREAMIS_SERVER_INSTALL_IP=192.168.1.134
STREAMIS_SERVER_INSTALL_PORT=9400


sh bin/install.sh  #会询问是否初始化数据库,第一次安装必须选是
sh bin/start.sh
netstat -tnlp|grep 9400 #查看eurekas是否注册成功
复制代码

7.Streamis 前端安装部署

复制代码
wget https://osp-1257653870.cos.ap-guangzhou.myqcloud.com/WeDatasphere/Streamis/0.2.0/streamis-0.2.0-dist.zip
unzip -q streamis-0.2.0-dist.zip 
mkdir /appcom/Install/streamis
mv dist/* /appcom/Install/streamis

server {
    listen       10002;
    server_name  localhost;
    location / {
        root   /appcom/Install/streamis; 
        index  index.html index.html;
    }
    location /api {
    proxy_pass http://192.168.1.134:9001; 
    proxy_set_header Host $host;
    proxy_set_header X-Real-IP $remote_addr;
    proxy_set_header x_real_ipP $remote_addr;
    proxy_set_header remote_addr $remote_addr;
    proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for;
    proxy_http_version 1.1;
    proxy_connect_timeout 4s;
    proxy_read_timeout 600s;
    proxy_send_timeout 12s;
    proxy_set_header Upgrade $http_upgrade;
    proxy_set_header Connection upgrade;
    }

    error_page   500 502 503 504  /50x.html;
    location = /50x.html {
    root   /usr/share/nginx/html;
    }
}

nginx -t 
nginx -s reload
复制代码

8.修改MySQL sql_mode

vim  /etc/my.cnf
sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
systemctl restart mysqld

9.部署 Streamis AppConn 插件

复制代码
wget https://github.com/WeBankFinTech/Streamis/archive/refs/tags/0.2.0.tar.gz
tar xf 0.2.0.tar.gz
cd Streamis-0.2.0
cd streamis-appconn
mvn clean install
cp target/streamis.zip /mnt/datasphere/dss_linkis_one-click_install_20221201/dss/dss-appconns/
cd /mnt/datasphere/dss_linkis_one-click_install_20221201/dss/dss-appconns
unzip streamis.zip

cd ../bin
sh ./appconn-install.sh  输入字符串streamis以及streamis服务的ip和端口,streamis端口是指前端端口,在nginx进行配置。而不是后端的服务端口即10002

cd ../sbin/
sh ./dss-stop-all.sh
sh ./dss-start-all.sh
复制代码

10.验证

1.控制台创建项目
2.数据库查看是否同步创建项目,SQL为
SELECT * FROM linkis_stream_project WHERE name = '项目名称';

四、DolphinScheduler AppConn 安装

参考文档:

https://dolphinscheduler.apache.org/zh-cn/docs/1.3.9/standalone-deployment

https://github.com/WeBankFinTech/DataSphereStudio-Doc/blob/main/zh_CN/%E5%AE%89%E8%A3%85%E9%83%A8%E7%BD%B2/DolphinScheduler%E6%8F%92%E4%BB%B6%E5%AE%89%E8%A3%85%E6%96%87%E6%A1%A3.md

1.安装依赖

依赖参考:https://dolphinscheduler.apache.org/zh-cn/docs/1.3.9/standalone-deployment

yum install psmisc -y  #其他我都已经满足了

2.创建数据库

mysql -uroot -p
CREATE DATABASE dolphinscheduler DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_general_ci;  #这里使用root用户,如果使用其他用户,记得对该用户授权

3.下载JDBCmysql-connector-java

https://repo1.maven.org/maven2/mysql/mysql-connector-java/ 选择对应的版本即可,当前版本要求不低于5.1.47

或者

https://mvnrepository.com/artifact/mysql/mysql-connector-java

4.下载dolphinsche

wget https://archive.apache.org/dist/dolphinscheduler/1.3.9/apache-dolphinscheduler-1.3.9-bin.tar.gz  #具体版本请根据实际links版本选择,参考文档
tar xf apache-dolphinscheduler-1.3.9-bin.tar.gz 
mv mysql-connector-java-5.1.47.jar apache-dolphinscheduler-1.3.9-bin/lib/
cd apache-dolphinscheduler-1.3.9-bin

5.配置dolphinsche

这里安装使用的是Standalone,部署用户直接用Hadoop

复制代码
vi conf/datasource.properties #根据实际情况配置数据库信息,此处注释postgresql配置,启用MySQL
spring.datasource.driver-class-name=com.mysql.jdbc.Driver
spring.datasource.url=jdbc:mysql://192.168.1.134:3306/dolphinscheduler?useUnicode=true&characterEncoding=UTF-8
spring.datasource.username=root
spring.datasource.password=Qwer@123

sh script/create-dolphinscheduler.sh #创建表及导入基础数据脚本

vim conf/env/dolphinscheduler_env.sh   #JAVA_HOME 和 PATH 是必须配置,其他没有用到的可以忽略或者注释掉
BASE_DIR=/mnt/datasphere
export HADOOP_HOME=${BASE_DIR}/hadoop
export HADOOP_CONF_DIR=${HADOOP_HOME}/etc/hadoop/
export SPARK_HOME=${BASE_DIR}/spark
export HIVE_HOME=${BASE_DIR}/hive
export SPARK_HOME=${BASE_DIR}/spark
export FLINK_HOME=${BASE_DIR}/flink
export JAVA_HOME=/usr/local/java
export PYTHON_HOME=/appcom/Install/anaconda2
export PATH=$HADOOP_HOME/bin:$SPARK_HOME1/bin:$PYTHON_HOME/bin:$JAVA_HOME/bin:$HIVE_HOME/bin:$FLINK_HOME/bin:$PATH

sudo ln -sv /usr/local/java/bin/java /usr/bin/java



vim conf/config/install_config.conf  #配置项具体含义参考文档
dbtype="mysql"
dbhost="192.168.1.134:3306"
username="root"
dbname="dolphinscheduler"
password="Qwer@123"
zkQuorum="192.168.1.134:2181"
installPath="/mnt/datasphere/dolphinscheduler"   #注意此处指的是安装后的目录,当前配置的路径为部署目录
deployUser="hadoop"
mailServerHost="smtp.exmail.qq.com"
mailServerPort="25"
mailSender="xxxxxxxxxx"
mailUser="xxxxxxxxxx"
mailPassword="xxxxxxxxxx"
starttlsEnable="true"
sslEnable="false"
sslTrust="smtp.exmail.qq.com"
dataBasedirPath="/tmp/dolphinscheduler"
resourceStorageType="HDFS"
resourceUploadPath="/data/dolphinscheduler"
defaultFS="file:///data/dolphinscheduler"
resourceManagerHttpAddressPort="8088"
singleYarnIp="192.168.1.134"
hdfsRootUser="hadoop"
kerberosStartUp="false"
krb5ConfPath="$installPath/conf/krb5.conf"
keytabUserName="hdfs-mycluster@ESZ.COM"
keytabPath="$installPath/conf/hdfs.headless.keytab"
kerberosExpireTime="2"
apiServerPort="12345"
ips="localhost"
sshPort="22"
masters="localhost"
workers="localhost::default"
alertServer="localhost"
apiServers="localhost"



sudo mkdir -p /data/dolphinscheduler
sudo chown -R hadoop:hadoop /data/dolphinscheduler
复制代码

6.启动dolphinsche服务

复制代码
sh install.sh  #应用解压目录下
jps |egrep  'MasterServer|WorkerServer|LoggerServer|ApiApplicationServer|AlertServer'  #查看相关服务是否正常启动
18566 ApiApplicationServer
18129 MasterServer
18457 AlertServer
18348 LoggerServer
18238 WorkerServer
ll /mnt/datasphere/dolphinscheduler/logs/  #如果出现问题日志路径
复制代码

访问地址:http://192.168.1.134:12345/dolphinscheduler/ui/view/login/index.html

默认账号密码: admin/dolphinscheduler123

7.安装DolphinScheduler AppConn

复制代码
wget https://osp-1257653870.cos.ap-guangzhou.myqcloud.com/WeDatasphere/DolphinScheduler/DSS1.1.1_dolphinscheduler/dolphinscheduler-appconn.zip  
mv dolphinscheduler-appconn.zip /mnt/datasphere/dss_linkis_one-click_install_20221201/dss/dss-appconns/
cd /mnt/datasphere/dss_linkis_one-click_install_20221201/dss/dss-appconns/
unzip dolphinscheduler-appconn.zip  

vim dolphinscheduler/appconn.properties
wds.dss.appconn.ds.admin.user=admin 
wds.dss.appconn.ds.admin.token=b245a4931ccbf58850f67ed202fc6eb7  #dolphinscheduler服务页面--安全中心-令牌管理中创建
wds.dss.appconn.ds.version=1.3.9
wds.dss.appconn.ds.client.home=/mnt/datasphere/dolphinscheduler-client  #dss-dolphinscheduler-client安装目录,后面步骤会安装,注意目录保持一致
cd ../bin/
sh install-appconn.sh # 安装appconn,输入字符串 dolphinscheduler 以及 dolphinscheduler 服务的 ip 和端口,端口为Nginx dss端口 即8085
复制代码

8.修改jar包

复制代码
wget https://osp-1257653870.cos.ap-guangzhou.myqcloud.com/WeDatasphere/DolphinScheduler/DSS1.1.1_dolphinscheduler/dss-dolphinscheduler-token-1.1.1.jar  # 用于免密请求 DolphinScheduler 的接口
mv  dss-dolphinscheduler-token-1.1.1.jar   /mnt/datasphere/dss_linkis_one-click_install_20221201/dss/lib/dss-framework/dss-framework-project-server/
sh sbin/dss-daemon.sh restart project-server

wget https://osp-1257653870.cos.ap-guangzhou.myqcloud.com/WeDatasphere/DolphinScheduler/DSS1.1.1_dolphinscheduler/dolphinscheduler-prod-metrics-1.1.1-jar-with-dependencies.jar
mv dolphinscheduler-prod-metrics-1.1.1-jar-with-dependencies.jar  /mnt/datasphere/dolphinscheduler/lib/ #拷贝到 DolphinScheduler 部署的 lib 目录
cd /mnt/datasphere/dolphinscheduler/
sh bin/stop-all.sh
sh bin/start-all.sh
复制代码

9.配置前端转发

复制代码
vim /etc/nginx/conf.d/dss.conf  #增加以下内容
location /dolphinscheduler {
    proxy_pass http://192.168.1.134:12345;#后端dolphinscheduler服务的地址
    proxy_http_version 1.1;
    proxy_set_header Upgrade $http_upgrade;
    proxy_set_header Connection upgrade;
}

nginx -t
nginx -s reload
复制代码

10.配置调度中心 url

vim /mnt/datasphere/dss_linkis_one-
click_install_20221201/dss/conf/dss-workflow-server.properties 
wds.dss.workflow.schedulerCenter.url=http://192.168.1.134:8085/dolphinscheduler #添加该字段
sh sbin/dss-daemon.sh restart workflow-server

11.部署 dss-dolphinscheduler-client

复制代码
wget https://osp-1257653870.cos.ap-guangzhou.myqcloud.com/WeDatasphere/DolphinScheduler/DSS1.1.1_dolphinscheduler/dss-dolphinscheduler-client.zip
unzip  dss-dolphinscheduler-client.zip

mv dss-dolphinscheduler-client /mnt/datasphere/dolphinscheduler-client   #该目录和dolphinscheduler服务中指定的一致

cd  /mnt/datasphere/dolphinscheduler-client
vim conf/linkis.properties
wds.linkis.gateway.url=192.168.1.134:9001  #gateway地址
复制代码

12.验证

创建新工作空间(旧空间看不到)

确认可以免密登录(dolphinscheduler需要已经登录,可以尝试在dolphinscheduler中创建hadoop用户,然后不登录试试dss是否可以免密登录)

五、Qualitis  AppConn 安装 

1.编译Qualitis  

 

复制代码
cd /mnt/datasphere/
wget https://services.gradle.org/distributions/gradle-4.6-bin.zip
unzip -q gradle-4.6-bin.zip
ln -sv gradle-4.6 gradle
vim ~/.bashrc
export PATH="/mnt/datasphere/gradle/bin/:$PATH"
. ~/.bashrc
gradle -v
wget https:
//github.com/WeBankFinTech/Qualitis/archive/refs/tags/release-0.9.2.zip wget https://github.com/WeBankFinTech/Qualitis/releases/download/release-0.9.1/forgerock.zip unzip -q forgerock.zip mv forgerock ~/.m2/repository/org/ unzip -q release-0.9.2.zip cd Qualitis-release-0.9.2 gradle clean distZip #编译文件build/distributions/ 目录下
复制代码

 

2.初始化数据库

复制代码
cd build/distributions
unzip -q qualitis-0.9.2.zip
cd qualitis-0.9.2

mysql -uroot -h 192.168.1.134 -p --default-character-set=utf8
mysql> create database qualitis default character set utf8mb4 COLLATE utf8mb4_general_ci;
mysql> use qualitis;
mysql> source conf/database/init.sql
mysql> exit;
复制代码

3.配置Qualitis

复制代码
vim conf/application-dev.yml  #新增或修改以下配置,其他默认即可
server:
  port: 8100
spring:
  datasource:
    username: root
    password: Qwer@123
    url: jdbc:mysql://192.168.1.134:3306/qualitis?createDatabaseIfNotExist=true&useUnicode=true&characterEncoding=utf-8


task:
  persistent:
    type: jdbc
    username: root
    password: Qwer@123
    address: jdbc:mysql://192.168.1.134:3306/qualitis?createDatabaseIfNotExist=true&useUnicode=true&characterEncoding=utf-8

zk:
  address: 192.168.1.134:2181

front_end:
  home_page: http://192.168.1.134:8100/#/dashboard
  domain_name: http://192.168.1.134:8100

cp mysql-connector-java-5.1.27-bin.jar /mnt/datasphere/spark/jars/
复制代码

4.启动Qualitis服务

dos2unix bin/*
sh bin/start.sh

访问web页面:http://192.168.1.134:8100/#/home  用户名: admin  密码: admin

5.系统配置填写

6.安装Qualitis AppConn 

复制代码
git clone https://github.com/WeBankFinTech/Qualitis.git
cd Qualitis/appconn
mvn clean install
mv  target/out/qualitis /mnt/datasphere/dss_linkis_one-click_install_20221201/dss/dss-appconns/
cd /mnt/datasphere/dss_linkis_one-click_install_20221201/dss/dss-appconns/
chmod -R 777 qualitis/
cd ../bin/
sh appconn-install.sh   #qualitis 192.168.1.134 8100
cd ../sbin/
sh dss-stop-all.sh 
sh dss-start-all.sh 
复制代码

7.验证

新建工作空间

测试自动跳转并免密登录

 

 

posted @   百衲本  阅读(663)  评论(2编辑  收藏  举报
cnblogs_post_body { color: black; font: 0.875em/1.5em "微软雅黑" , "PTSans" , "Arial" ,sans-serif; font-size: 15px; } cnblogs_post_body h1 { text-align:center; background: #333366; border-radius: 6px 6px 6px 6px; box-shadow: 0 0 0 1px #5F5A4B, 1px 1px 6px 1px rgba(10, 10, 0, 0.5); color: #FFFFFF; font-family: "微软雅黑" , "宋体" , "黑体" ,Arial; font-size: 23px; font-weight: bold; height: 25px; line-height: 25px; margin: 18px 0 !important; padding: 8px 0 5px 5px; text-shadow: 2px 2px 3px #222222; } cnblogs_post_body h2 { text-align:center; background: #006699; border-radius: 6px 6px 6px 6px; box-shadow: 0 0 0 1px #5F5A4B, 1px 1px 6px 1px rgba(10, 10, 0, 0.5); color: #FFFFFF; font-family: "微软雅黑" , "宋体" , "黑体" ,Arial; font-size: 20px; font-weight: bold; height: 25px; line-height: 25px; margin: 18px 0 !important; padding: 8px 0 5px 5px; text-shadow: 2px 2px 3px #222222; } cnblogs_post_body h3 { background: #2B6695; border-radius: 6px 6px 6px 6px; box-shadow: 0 0 0 1px #5F5A4B, 1px 1px 6px 1px rgba(10, 10, 0, 0.5); color: #FFFFFF; font-family: "微软雅黑" , "宋体" , "黑体" ,Arial; font-size: 18px; font-weight: bold; height: 25px; line-height: 25px; margin: 18px 0 !important; padding: 8px 0 5px 5px; text-shadow: 2px 2px 3px #222222; } 回到顶部 博客侧边栏 回到顶部 页首代码 回到顶部 页脚代码
点击右上角即可分享
微信分享提示