搭建ZSK服务

# 安装菁苗知识库操作步骤

## 安装mysql5.7
### 安装并配置Mysql密码
[Mysql运维](/project-2/doc-12/)

### 导入数据库
使用数据库连接工具，创建数据库，并执行SQL文件创建表及数据
![创建数据库](/media/202312/2023-12-07_184341_0846430.7182462673489399.png)

![导入SQL文件](/media/202312/2023-12-07_184442_7166600.8920225285190503.png)

或直接登录客户端导入sql文件
```
CREATE DATABASE `xthz` CHARACTER SET 'utf8mb4' COLLATE 'utf8mb4_general_ci';

source /path/xthz.sql;
```

![建好的数据库](/media/202312/2023-12-07_184559_1638300.741153568347066.png)

## 安装Nginx1.24.0
### 安装Nginx
```
rpm -Uvh http://nginx.org/packages/centos/7/noarch/RPMS/nginx-release-centos-7-0.el7.ngx.noarch.rpm

yum install -y nginx

systemctl enable nginx
systemctl start nginx
```
### 复制Nginx配置文件
```

user root;
worker_processes auto;

error_log /var/log/nginx/error.log notice;
pid /var/run/nginx.pid;

events {
    worker_connections 1024;
}

http {
    include /etc/nginx/mime.types;
    default_type application/octet-stream;

log_format main '$remote_addr - $remote_user [$time_local] "$request" '
    '$status $body_bytes_sent "$http_referer" '
    '"$http_user_agent" "$http_x_forwarded_for"';

access_log /var/log/nginx/access.log main;

sendfile on;
    #tcp_nopush     on;

keepalive_timeout 65;

#gzip  on;

include /etc/nginx/conf.d/*.conf;

server {
        listen 80;
        server_name localhost;

#charset koi8-r;

access_log  /var/log/nginx/host.access.log  main;
        location / {
            root /zskweb/web/project/public;
            index index.html index.htm index.php;
            if (!-e $request_filename) {
                rewrite ^(.*)$ /index.php?s=$1 last;
            }
        }

#error_page  404              /404.html;

# redirect server error pages to the static page /50x.html
        #
        error_page 500 502 503 504 /50x.html;
        location = /50x.html {
            root html;
        }

# proxy the PHP scripts to Apache listening on 127.0.0.1:80
        #
        #location ~ \.php$ {
        #    proxy_pass   http://127.0.0.1;
        #}

# pass the PHP scripts to FastCGI server listening on 127.0.0.1:9000
        #
        location ~ \.php$ {
            root /zskweb/web/project/public;
            fastcgi_pass 127.0.0.1:9000;
            fastcgi_index index.php;
            fastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name;
            include fastcgi_params;
        }

# deny access to .htaccess files, if Apache's document root
        # concurs with nginx's one
        #
        #location ~ /\.ht {
        #    deny  all;
        #}
    }
    server {
        listen 8191;
        server_name localhost;

#charset koi8-r;
        #
        #        #access_log  logs/host.access.log  main;
        #
        location / {
            root /zskweb/web/xthzAdmin/public;
            index index.html index.htm index.php;
            if (!-e $request_filename) {
                rewrite ^(.*)$ /index.php?s=$1 last;
            }
        }
        #error_page  404              /404.html;
        #
        #        # redirect server error pages to the static page /50x.html

error_page 500 502 503 504 /50x.html;
        location = /50x.html {
            root html;
        }
        # proxy the PHP scripts to Apache listening on 127.0.0.1:80
        #         #
        #                 #location ~ \.php$ {
        #                         #    proxy_pass   http://127.0.0.1;
        #                                 #}
        # pass the PHP scripts to FastCGI server listening on 127.0.0.1:9000
        #         #
        location ~ \.php$ {
            root /zskweb/web/xthzAdmin/public;
            fastcgi_pass 127.0.0.1:9000;
            fastcgi_index index.php;
            fastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name;
            include fastcgi_params;
        }

# deny access to .htaccess files, if Apache's document root
        # concurs with nginx's one
        #
        #location ~ /\.ht {
        #  deny  all;
        #}
    }

}

```

### 关闭SElinux
```
#永久关闭-重启生效
sed -i 's/SELINUX=enforcing/SELINUX=disabled/g' /etc/selinux/config

#临时关闭
setenforce 0
```

## 安装php、php-frp
### 安装
```
wget https://dl.fedoraproject.org/pub/epel/epel-release-latest-7.noarch.rpm

rpm -ivh epel-release-latest-7.noarch.rpm

wget https://mirror.webtatic.com/yum/el7/webtatic-release.rpm --no-check-certificate

rpm -ivh webtatic-release.rpm

# 需要将webtatic的所有repo文件里的https修改为http

# 有点慢 
yum install -y php72w php72w-cli  php72w-common  php72w-devel php72w-mysql php72w-fpm

php -v

systemctl enable php-fpm
systemctl start php-fpm
systemctl status php-fpm

```

## 安装neo4j数据库
### 安装jdk
```
yum install -y java-1.8.0-openjdk

java -version
```
### 上传neo4j数据库的包
（直接使用已导入数据的数据库打包文件）

### 修改配置
#### zy
```
## Bolt connector
#dbms.connector.bolt.enabled=true
##dbms.connector.bolt.tls_level=OPTIONAL
dbms.connector.bolt.listen_address=0.0.0.0:7687
#
## HTTP Connector. There can be zero or one HTTP connectors.
#dbms.connector.http.enabled=true
dbms.connector.http.listen_address=0.0.0.0:7474
#
## HTTPS Connector. There can be zero or one HTTPS connectors.
#dbms.connector.https.enabled=true
dbms.connector.https.listen_address=0.0.0.0:7473
```
#### xy
```
## Bolt connector
#dbms.connector.bolt.enabled=true
##dbms.connector.bolt.tls_level=OPTIONAL
dbms.connector.bolt.listen_address=0.0.0.0:7688
#
## HTTP Connector. There can be zero or one HTTP connectors.
#dbms.connector.http.enabled=true
dbms.connector.http.listen_address=0.0.0.0:7476
#
## HTTPS Connector. There can be zero or one HTTPS connectors.
#dbms.connector.https.enabled=true
dbms.connector.https.listen_address=0.0.0.0:7475
```

### 启动neo4j
```
$path/neo4j-community-3.5.26/bin/neo4j start
```

## 上传php代码、配置nginx
### 上传文件

### 修改js接口地址
文件列表：`app.1642123537343.js`、`app.1642123537343.js.map`、`app.1642232425236.js`、`app.1642232425236.js.map`
将其中的接口地址IP修改为当前服务器访问ip。

### 修改数据库配置地址
文件：`project/.env`、`xthzAdmin/.env`文件，修改Mysql服务器ip、账号、密码。

### 修改Neo4j配置
文件：`project/app/controller/CommonController.php`、`project/app/controller/CommonTwoController.php`2个文件，修改其中的neo4j的ip、账号信息。

## 附件
1. [【附件】yum-resource.zip](/media/attachment/2023/12/yum-resource.zip)