企业官网建设流程全解析

你只需要按照流程来，肯定不会出错，我经历的坑全部都在里面
centos7安装---superset

#wget拉取miniconda3安装包（自带python12环境）superset官网安装环境需要python12 wget https://repo.anaconda.com/miniconda/Miniconda3-py312_24.1.2-0-Linux-x86_64.sh; #执行bash [root@hjx-centos7 ~]# bash Miniconda3-py312_24.1.2-0-Linux-x86_64.sh #加载环境变量 source ~/.bashrc #配置镜像 [atguigu@hadoop102 ~]$ conda config --add channels https://mirrors.tuna.tsinghua.edu.cn/anaconda/pkgs/free [atguigu@hadoop102 ~]$ conda config --add channels https://mirrors.tuna.tsinghua.edu.cn/anaconda/pkgs/main [atguigu@hadoop102 ~]$ conda config --set show_channel_urls yes #关闭默认conda环境 [atguigu@hadoop102 lib]$ conda config --set auto_activate_base false #安装superset环境python [root@hjx-centos7 ~]# conda create --name superset python=3.12 #进入环境 [root@hjx-centos7 ~]# conda activate superset (superset) [superset@hjx-el7-superset ~]$ conda install psycopg2 #退出环境 (superset) [root@hjx-centos7 ~]# conda deactivate #安装superset依赖 (superset) [root@hjx-centos7 ~]# sudo yum install gcc gcc-c++ libffi-devel python-devel python-pip python-wheel openssl-devel cyrus-sasl-devel openldap-devel python3-devel #更新setuptools和pip (superset) [root@hjx-centos7 ~]# pip install --upgrade setuptools pip -i https://pypi.tuna.tsinghua.edu.cn/simple/ --trusted-host pypi.tuna.tsinghua.edu.cn #安装依赖（由于安装superset编译一直卡住，导致需要直接安装包然后在进行安装superset） (superset) [superset@centos4 ~]$ pip install apsw>=3.43.2.0 -i https://mirrors.aliyun.com/pypi/simple/ --only-binary=:all: --trusted-host mirrors.aliyun.com #安装Superset (superset) [root@hjx-centos7 ~]# pip install apache-superset -i https://mirrors.aliyun.com/pypi/simple/ --trusted-host mirrors.aliyun.com

设置生产元数据数据库（superset只支持Mysql、postgresql具体版本请查看superset官网）

(superset) [root@hjx-centos7 bin]# conda install mysqlclient (superset) [superset@hjx-el7-superset ~]$ conda install pymysql (superset) [superset@hjx-el7-superset bin]$ conda install -c conda-forge mysql-client (superset) [root@hjx-rocky8-Superset superset]# vim /root/miniconda3/envs/superset/lib/python3.12/site-packages/superset/config.py #添加一下内容 SQLALCHEMY_DATABASE_URI = 'mysql+pymysql://superset:superset@10.197.165.171:3306/superset?charset=utf8mb4' #Mysql数据库需要操作 create database superset; SET GLOBAL validate_password.check_user_name = OFF; -- 设置最低策略级别 SET GLOBAL validate_password.policy = 0; -- 设置最短密码长度 SET GLOBAL validate_password.length = 4; -- 取消大小写混合要求 SET GLOBAL validate_password.mixed_case_count = 0; -- 取消数字要求 SET GLOBAL validate_password.number_count = 0; -- 取消特殊字符要求 SET GLOBAL validate_password.special_char_count = 0; create user 'superset'@'%' IDENTIFIED WITH mysql_native_password BY 'superset'; grant all on *.* to 'superset'@'%';

初始化Superset数据库

(superset) [superset@hjx-el7-superset ~]$ mkdir -p ./superset/logs (superset) [superset@centos4 ~]$ openssl rand -base64 42 6eZBllyXhwb5GKDk9K1CGNwymJY54ViNQgNU6X0n2KfxjCoTBfLnsUi2 cd superset; #增加如下内容 vi ./superset_config.py SECRET_KEY = "66eZBllyXhwb5GKDk9K1CGNwymJY54ViNQgNU6X0n2KfxjCoTBfLnsUi2" vi ~/.bashrc export SUPERSET_CONFIG_PATH="/home/superset/superset/superset_config.py" (superset) [atguigu@hadoop102 ~]$ superset db upgrade #如果SECRET_KEY报错，执行以下操作 export SUPERSET_SECRET_KEY="oh-so-secret"; #创建管理员用户 (superset) [atguigu@hadoop102 ~]$ export FLASK_APP=superset (superset) [atguigu@hadoop102 ~]$ superset fab create-admin ​ #Superset初始化 (superset) [atguigu@hadoop102 ~]$ superset init #安装gunicorn (superset) [root@hjx-centos7 ~]# pip install gunicorn -i https://mirrors.aliyun.com/pypi/simple/ --trusted-host mirrors.aliyun.com #启动Superset (superset) [root@hjx-centos7 ~]# gunicorn --workers 5 --timeout 120 --bind 10.197.165.117:8100 --daemon --access-logfile /root/superset/logs/access.log --error-logfile /root/superset/logs/error.log "superset.app:create_app()" #关闭superset (superset) [root@hjx-centos7 superset]# ps -ef | awk '/superset/ && !/awk/{print $2}' | xargs kill -9 #配置汉化包 (superset) [root@hjx-centos7 superset]# vim superset_config.py (superset) [root@hjx-centos7 superset]# cat superset_config.py SECRET_KEY = "rqqmcnic5/GsCEgvA982tLwe1s0Yx/JTLoSfVkRR5tr5u9BhBpPHWt/c" LANGUAGES = { "zh": {"flag": "cn", "name": "简体中文"}, "en": {"flag": "us", "name": "English"}, } #生效环境变量,重启superset (superset) [root@hjx-centos7 superset]# source ~/.bashrc

配置superset启停脚本

cat >> ./superset.sh << 'EOF' #!/bin/bash ​ superset_status(){ result=`ps -ef | awk '/gunicorn/ && !/awk/{print $2}' | wc -l` if [[ $result -eq 0 ]]; then return 0 else return 1 fi } superset_start(){ source ~/.bashrc superset_status >/dev/null 2>&1 if [[ $? -eq 0 ]]; then conda activate superset ; gunicorn --workers 5 --timeout 120 --bind 10.197.165.117:8100 --daemon --access-logfile /home/superset/superset/logs/access.log --error-logfile /home/superset/superset/logs/error.log "superset.app:create_app()" else echo "superset正在运行" fi ​ } ​ superset_stop(){ superset_status >/dev/null 2>&1 if [[ $? -eq 0 ]]; then echo "superset未在运行" else ps -ef | awk '/gunicorn/ && !/awk/{print $2}' | xargs kill -9 fi } ​ ​ case $1 in start ) echo "启动Superset" superset_start ;; stop ) echo "停止Superset" superset_stop ;; restart ) echo "重启Superset" superset_stop superset_start ;; status ) superset_status >/dev/null 2>&1 if [[ $? -eq 0 ]]; then echo "superset未在运行" else echo "superset正在运行" fi esac EOF

superset连接oracle数据库

#安装依赖 (superset) [root@hjx-centos7 ~]# conda install oracledb (superset) [root@hjx-centos7 superset]# conda install cx_Oracle #安装oracle install Clinet (superset) [root@hjx-centos7 superset]# yum install perl-DBD-Pg perl perl-devel perl-DBI perl-CPAN bzip2 perl-ExtUtils-CBuilder perl-ExtUtils-MakeMaker wget https://download.oracle.com/otn_software/linux/instantclient/219000/oracle-instantclient-basic-21.9.0.0.0-1.x86_64.rpm wget https://download.oracle.com/otn_software/linux/instantclient/219000/oracle-instantclient-devel-21.9.0.0.0-1.x86_64.rpm wget https://download.oracle.com/otn_software/linux/instantclient/219000/oracle-instantclient-sqlplus-21.9.0.0.0-1.x86_64.rpm sudo rpm -ivh oracle-instantclient-*.rpm cat >>/etc/profile <<'EOF' export ORACLE_HOME=/usr/lib/oracle/21/client64/lib export LD_LIBRARY_PATH=$ORACLE_HOME export PATH=$PATH:$ORACLE_HOME EOF . /etc/profile #连接信息如下 oracle+cx_oracle://sys:oracle@10.197.165.184:1521/ORCL?mode=sysdba