Linux上部署学之思系统

环境：集成部署

nodeJs（16 ）：Index of /download/release/latest-v16.x/

Jdk（1.8 ）：Java Downloads | Oracle

Mysql（8.0/5.7 ）：MySQL :: MySQL Community Downloads

数据库脚本下载地址：https://www.mindskip.net:999，创建表初始化数据，数据库名称为xzs

代码下载 mysql版本，配合相应的数据库使用

安装mysql ，导入xzs-mysql.sql脚本

学生端默认账号：student / 123456

管理端默认账号：admin / 123456

安装打包工具

安装jdk，并配置环境

[root@web-nginx ~]# tar xzvf jdk-8u221-linux-x64.tar.gz -C /usr/local/
[root@web-nginx ~]# mv /usr/local/jdk1.8.0_221/ /usr/local/java
[root@web-nginx ~]# vim /etc/profile
JAVA_HOME=/usr/local/java
PATH=$JAVA_HOME/bin:$PATH
export JAVA_HOME PATH
[root@web-nginx ~]# source /etc/profile
[root@web-nginx ~]# java -version
java version "1.8.0_211"
Java(TM) SE Runtime Environment (build 1.8.0_211-b12)
Java HotSpot(TM) 64-Bit Server VM (build 25.211-b12, mixed mode)

安装maven，设置环境变量

[root@web-nginx ~]# wget https://mirrors.tuna.tsinghua.edu.cn/apache/maven/maven-3/3.8.8/binaries/apache-maven-3.8.8-bin.tar.gz
[root@web-nginx ~]# tar xzvf apache-maven-3.8.8-bin.tar.gz -C /usr/local/
[root@web-nginx ~]# mv /usr/local/apache-maven-3.8.8/ /usr/local/maven
[root@web-nginx ~]# vim /etc/profile
MAVEN_HOME=/usr/local/maven
PATH=$PATH:$MAVEN_HOME/bin
export MAVEN_HOME PATH
[root@web-nginx ~]# source /etc/profile
[root@web-nginx ~]#  mvn -version    #检测maven是否安装成功
Apache Maven 3.8.8 (4c87b05d9aedce574290d1acc98575ed5eb6cd39)
Maven home: /usr/local/maven
Java version: 1.8.0_211, vendor: Oracle Corporation, runtime: /usr/local/java/jre
Default locale: en_US, platform encoding: UTF-8
OS name: "linux", version: "3.10.0-1160.el7.x86_64", arch: "amd64", family: "unix"

安装node.js前端打包工具命令npm

[root@web-nginx ~]# wget https://nodejs.org/download/release/latest-v16.x/node-v16.20.2-linux-x64.tar.xz
[root@web-nginx ~]# tar xf node-v16.20.2-linux-x64.tar.xz -C /usr/local/
[root@web-nginx ~]# cd /usr/local/
[root@web-nginx local]# mv node-v16.20.2-linux-x64/ node
[root@web-nginx ~]# vim /etc/profile
NODE_HOME=/usr/local/node
PATH=$NODE_HOME/bin:$PATH
export NODE_HOME PATH
[root@web-nginx ~]# source /etc/profile
[root@web-nginx ~]# node --version
v16.20.2

安装Git命令获取源代码

[root@web-nginx ~]# yum install -y git

[root@web-nginx ~]# git clone https://gitee.com/hyunze/xzs-mysql.git   #获取clone代码

安装mysql5.7

[root@web-nginx ~]# wget https://dev.mysql.com/get/mysql80-community-release-el7-3.noarch.rpm
[root@web-nginx ~]# rpm -ivh mysql80-community-release-el7-3.noarch.rpm 
[root@web-nginx ~]# vim /etc/yum.repos.d/mysql-community.repo 
#将mysql8.0关闭将mysql5.7开启
enabled=1
gpgcheck=0
[root@web-nginx ~]# yum install -y mysql-community-server
[root@web-nginx ~]# systemctl start mysqld
[root@web-nginx ~]# grep pass /var/log/mysqld.log 
[root@web-nginx ~]# mysqladmin -uroot -p'HdV>.f>Ir8;h' password 'Mhong@123!'
[root@web-nginx ~]# mysql -uroot -p'Mhong@123!'
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 3
Server version: 5.7.31 MySQL Community Server (GPL)
...

创建数据库xzs，设置root允许远程登录

mysql> create database xzs character set utf8 collate  utf8_general_ci;
Query OK, 1 row affected (0.00 sec)

mysql> update mysql.user set host = '%' where user = 'root';   #设置root允许远程登录
Query OK, 1 row affected (0.10 sec)
Rows matched: 1  Changed: 1  Warnings: 0

mysql> flush privileges;

mysql> \q
Bye

配置mysql环境

#修改mysql
[root@web-nginx ~]# vim xzs-mysql/source/xzs/src/main/resources/application-prod.yml
logging:
  path: /usr/log/xzs/

spring:
  datasource:
    url: jdbc:mysql://10.36.192.66:3306/xzs?useSSL=false&useUnicode=true&serverTimezone=Asia/Shanghai&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&allowPublicKeyRetrieval=true&allowMultiQueries=true
    username: root
    password: Mhong@123!
    driver-class-name: com.mysql.cj.jdbc.Driver

#导入初始化sql
[root@web-nginx ~]# mysql -uroot -p'Mhong@123!' xzs < xzs-mysql/sql/xzs-mysql.sql 

前端打包

#学生端
[root@web-nginx ~]# cd /root/xzs-mysql/source/vue/xzs-student/
[root@web-nginx xzs-student]# npm config set sass_binary_site https://npm.taobao.org/mirrors/node-sass/
[root@web-nginx xzs-student]# npm install --registry https://registry.npm.taobao.org  
[root@web-nginx xzs-student]# npm run build
[root@web-nginx xzs-student]# \cp -r student /root/xzs-mysql/source/xzs/src/main/resources/static


#管理端
[root@web-nginx ~]# cd /root/xzs-mysql/source/vue/xzs-admin/
[root@web-nginx xzs-admin]# npm config set sass_binary_site https://npm.taobao.org/mirrors/node-sass/
[root@web-nginx xzs-admin]# npm install --registry https://registry.npm.taobao.org  
[root@web-nginx xzs-admin]# npm run build
[root@web-nginx xzs-admin]# \cp -r admin /root/xzs-mysql/source/xzs/src/main/resources/static

将java程序打包成jar包

[root@web-nginx ~]# cd xzs-mysql/source/xzs
[root@web-nginx xzs]# mvn package

#服务上线
[root@web-nginx ~]# mkdir -p /application/java-server
[root@web-nginx ~]# cp xzs-mysql/source/xzs/target/xzs-3.9.0.jar /application/java-server
[root@web-nginx ~]# cd /application/java-server
[root@web-nginx java-server]# nohup java -Duser.timezone=Asia/Shanghai -jar -Dspring.profiles.active=prod  xzs-3.9.0.jar  > start1.log  2>&1 &

学生端访问地址为：http://ip:8000/student

管理员端访问地址为：http://ip:8000/admin

学生端默认账号：student / 123456

管理端默认账号：admin / 123456

错误总结：将java程序打包成jar包时发生一下错误时👇

解决方法：进入maven 的配置文件中159行，即原有<mirror>...</mirror>的上方加入阿里云的maven镜像源

 vim  /usr/local/maven/conf/settings.xml 

所添加内容 

<mirror>
    <id>aliyunmaven</id>
    <mirrorOf>*</mirrorOf>
    <name>阿里云公共仓库</name>
    <url>https://maven.aliyun.com/repository/public</url>
</mirror>

 添加阿里云镜像源之后

   <url>http://my.repository.com/repo/path</url>
    </mirror>
     -->
<mirror>
    <id>aliyunmaven</id>
    <mirrorOf>*</mirrorOf>
    <name>阿里云公共仓库</name>
    <url>https://maven.aliyun.com/repository/public</url>
</mirror>
<mirror>
      <id>maven-default-http-blocker</id>
      <mirrorOf>external:http:*</mirrorOf>
      <name>Pseudo repository to mirror external repositories initially using HTTP.</name>
      <url>http://0.0.0.0/</url>
      <blocked>true</blocked>
    </mirror>
  </mirrors>

  <!-- profiles