06.部署jpress

安装mariadb数据

yum -y install mariadb-server
#启动并设置开启自启动
systemctl start mariadb.service  
systemctl enable  mariadb.service

数据库准备

[root@web01 ~]# mysql 
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 3
Server version: 5.5.68-MariaDB MariaDB Server

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> create database jpress charset utf8mb4;
Query OK, 1 row affected (0.00 sec)

MariaDB [(none)]> show create database jpress;
+----------+--------------------------------------------------------------------+
| Database | Create Database                                                    |
+----------+--------------------------------------------------------------------+
| jpress   | CREATE DATABASE `jpress` /*!40100 DEFAULT CHARACTER SET utf8mb4 */ |
+----------+--------------------------------------------------------------------+
1 row in set (0.00 sec)

MariaDB [(none)]> grant all on jpress.* to 'jpress'@'localhost' identified by '123456';
Query OK, 0 rows affected (0.00 sec)

MariaDB [(none)]> select user,host from mysql.user;
+--------+-----------+
| user   | host      |
+--------+-----------+
| root   | 127.0.0.1 |
| root   | ::1       |
|        | localhost |
| jpress | localhost |
| root   | localhost |
|        | web01     |
| root   | web01     |
+--------+-----------+
7 rows in set (0.00 sec)

MariaDB [(none)]> grant all on jpress.* to 'jpress'@'172.16.1.%' identified by '123456';
Query OK, 0 rows affected (0.00 sec)

MariaDB [(none)]> drop user ''@'localhost';
Query OK, 0 rows affected (0.00 sec)

MariaDB [(none)]> 
MariaDB [(none)]> drop user ''@'web01';
Query OK, 0 rows affected (0.00 sec)

MariaDB [(none)]> 
MariaDB [(none)]> select user,host from mysql.user;
+--------+------------+
| user   | host       |
+--------+------------+
| root   | 127.0.0.1  |
| jpress | 172.16.1.% |
| root   | ::1        |
| jpress | localhost  |
| root   | localhost  |
| root   | web01      |
+--------+------------+
6 rows in set (0.00 sec)

MariaDB [(none)]> 
MariaDB [(none)]> flush privileges;
Query OK, 0 rows affected (0.00 sec)
[root@web01 ~]# mysql -ujpress -p123456
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 7
Server version: 5.5.68-MariaDB MariaDB Server
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB [(none)]>

准备代码jpress
上传jpress.war包，直接移动到webapps路径下

[root@web01 ~]# ls
anaconda-ks.cfg  initial-setup-ks.cfg  jpress.war
[root@web01 ~]# mv jpress.war /application/tomcat/webapps/
[root@web01 ~]# ll /application/tomcat/webapps/
总用量 20320
drwxr-xr-x 14 root root     4096 8月   6 13:06 docs
drwxr-xr-x  6 root root       83 8月   6 13:06 examples
drwxr-xr-x  5 root root       87 8月   6 13:06 host-manager
drwxr-xr-x  7 root root      102 8月   6 16:01 jpress
-rw-r--r--  1 root root 20797013 3月   3 2017 jpress.war
drwxr-xr-x  5 root root      103 8月   6 13:06 manager
drwxr-xr-x  3 root root     4096 8月   6 13:06 ROOT

安装向导
访问http://192.168.111.12:8080/jpress/

下图对应的数据信息存放的文件

#tomcat数据库配置文件 db.properties
[root@web01 /application/tomcat/webapps/jpress/WEB-INF/classes]# cat db.properties 
#Auto create by JPress
#Sat Aug 06 19:35:01 CST 2022
db_name=jpress
db_host_port=3306
db_tablePrefix=jpress_
db_host=localhost
db_password=123456
db_user=jpress

如图所示对应的信息内容
在这里插入图片描述

http://192.168.111.12:8080/jpress/admin/

编辑文章，添加内容文字和图片进行发布
在这里插入图片描述

发布成功
在这里插入图片描述

上传的图片存放位置
attachment 该路径为用上传目录
在这里插入图片描述

数据库中存放文章的的内容
在这里插入图片描述

[root@web01 ~]# cat /application/tomcat/webapps/ROOT/mem.jsp 
<%
Runtime rtm = Runtime.getRuntime();
long mm = rtm.maxMemory()/1024/1024;
long tm = rtm.totalMemory()/1024/1024;
long fm = rtm.freeMemory()/1024/1024;
out.println("JVM memory detail info :<br>");
out.println("Max memory:"+mm+"MB"+"<br>");
out.println("Total memory:"+tm+"MB"+"<br>");
out.println("Free memory:"+fm+"MB"+"<br>");
out.println("Available memory can be used is :"+(mm+fm-tm)+"MB"+"<br>");
%>