战姬物语项目部署战姬物语项目部署-LNMT 战姬物语项目部署-LNMT 战姬物语项目部署-LNMT 战姬物语项目部署-L

一、部署Java环境

1、上传jdk压缩包
rz
2、解压缩

[root@qqfarm ~]# tar -xf jdk-8u211-linux-x64.tar.gz
[root@qqfarm ~]# mv jdk1.8.0_211/ /usr/local/jdk

3、配置环境变量

[root@qqfarm ~]# vim /etc/profile.d/java.sh
       export JAVA_HOME=/usr/local/jdk
       export PATH=$JAVA_HOME/bin:$PATH

[root@qqfarm ~]# source /etc/profile.d/java.sh
[root@qqfarm ~]# 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)

二、发布项目

准备数据库


1、修改数据库配置文件
[root@qqfarm ~]# vim /etc/my.cnf
#在最后一行加上
validate-password=OFF
2、重启数据库
[root@qqfarm ~]# systemctl restart mysqld
3、修改密码
[root@qqfarm ~]# mysqlamdin -p旧密码 password "jgirlstest"
4、建库
[root@qqfarm ~]# mysql -p"jgirlstest"
mysql>create database jgirls_test default charset 'utf8';
5、导入SQL文件
mysql>use jgirls_test;
mysql>source /root/jgirls_test.sql;
6、执行SQL语句
mysql>UPDATE `jgirls_test`.`system` SET `id`='1', `data`='{\"version\":\"1.0.0.0\",\"resVersion\":\"1.0.0.0.0.0.0.0\",\"areas\":[{\"id\":100001,\"name\":\"云计算1\",\"host\":\"192.168.11.130\",\"port\":10090,\"status\":2},{\"id\":100002,\"name\":\"www.QFetu.com\",\"host\":\"192.168.11.130\",\"port\":10100,\"status\":1}],\"globalStatus\":1,\"versionStr\":\"\",\"whiteListWhenMaintenance\":\",\",\"declaration\":[{\"declarationTitle\":\"云计算\",\"declarationCotent\":\"www.QF.com\"},{\"declarationTitle\":\"公告标题2\",\"declarationCotent\":\"公告内容2\"},{\"declarationTitle\":\"公告标题3\",\"declarationCotent\":\"公告内容3\"}]}' WHERE (`id`='1');
mysql>\q

上传前后端项目

1.上传项目代码 
  rz
2.解压缩
[root@qqfarm ~] tar -xf zjwy.tar.gz -C /

修改后端项目配置

[root@qqfarm ~]# vim /opt/server/100001/Application.properties
        managerWhiteList=127.0.0.1,192.168.11.130
[root@qqfarm ~]# vim /opt/server/apache-tomcat-8080/conf/context.xml
<Resource name="jdbc/mysql" auth="Container" type="javax.sql.DataSource"
         maxActive="500" maxIdle="30" maxWaitMillis="10000"
         username="root" password="jgirlstest                     driverClassName="com.mysql.jdbc.Driver"
         url="jdbc:mysql://localhost:3306/jgirls_test?characterEncoding=utf-8&amp;useSSL=false"
         factory = "org.apache.tomcat.jdbc.pool.DataSourceFactory"
         removeAbandonedOnBorrow="true"
         removeAbandonedOnMaintenance="true"
         logAbandoned="true"
         testOnBorrow="true"
    />

启动后端项目

[root@qqfarm ~]# cd /opt/server/mongodb-linux-x86_64-rhel70-3.2.9/ && ./start.sh
[root@qqfarm ~]# cd /opt/server/AdminNew/ && ./restart.sh
[root@qqfarm ~]# cd /opt/server/apache-tomcat-8080/bin/ && ./startup.sh
[root@qqfarm ~]# cd /opt/server/chatserver/ && ./start.sh
[root@qqfarm ~]# cd /opt/server/100001/ && ./start.sh start

部署前端项目

[root@qqfarm ~]# rm -rf /usr/share/nginx/html/*
[root@qqfarm ~]# mv /www/wwwroot/yixiaw/* /usr/share/nginx/html/
# 修改配置
[root@qqfarm ~]# vim /usr/share/nginx/html/index.html
      :%s/218.93.207.238/192.168.11.130/g

访问项目

http://192.168.11.130
http://192.168.11.130:8002 (后台管理)

笔记:

show databases; 查看数据库  
use xxx; 切换数据库  
select * from system;