施坤的博客
0%

centos7搭建jforum

发表于 更新于 分类于 阅读次数： Valine：

说明

作为性能测试的压测目标网站，本次教程主要是在centos7上搭建iforum论坛的步骤

按照mysql

1
wget hhttps://repo.mysql.com//mysql80-community-release-el7-3.noarch.rpm
  • 安装MySql源
1
2
3
4
5
6
[root@racknerd-4dbd89 local]# rpm -ivh mysql80-community-release-el7-3.noarch.rpm
warning: mysql80-community-release-el7-3.noarch.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
Preparing...                          ################################# [100%]
Updating / installing...
   1:mysql80-community-release-el7-3  ################################# [100%]

  • 安装MySQL服务器
    yum install mysql-community-server

  • 开启mysql服务

1
service mysqld start
  • mysql安装成功后创建的超级用户‘root‘@’localhost’的密码会被存储在/var/log/mysqld.log，可以使用如下命令查看密码
1
grep 'temporary password' /var/log/mysqld.log

  • 输入 mysql -u root -p,输入得到的密码，然后修改密码：

    1
    ALTER USER 'root'@'localhost' IDENTIFIED BY 'new password';

  • 添加远程登录用户

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
use mysql;
mysql> select host, user from user;
+-----------+------------------+
| host      | user             |
+-----------+------------------+
| localhost | mysql.infoschema |
| localhost | mysql.session    |
| localhost | mysql.sys        |
| localhost | root             |
+-----------+------------------+
4 rows in set (0.01 sec)
# 查看表格中 root 用户的 host，默认应该显示的 localhost，只支持本地访问，不允许远程访问。

update user set host='%' where user ='root';
# 说明： % 代表任意的客户端,可替换成具体IP地址。
flush privileges;
  • 防火墙中开放mysql的访问端口
1
2
3
4
5
6
7
firewall-cmd --zone=public --add-port=3306/tcp --permanent
firewall-cmd --reload   # 配置立即生效
firewall-cmd --zone=public --list-port # 查看防火墙所有开放的端口
firewall-cmd --state # 查看防火墙状态
netstat -lnpt # 查看监听的端口
netstat -lnpt |grep 3306 # 查看监听的具体端口

  • 用HeidiSQL远程连接mysql成功

    image-20211020114616786

  • 新建数据库，名字为：iforum

    image-20211020163450656

安装java

  • 我的服务器上已经按照好了java

    1
    2
    3
    4
    [root@racknerd-4dbd89 ~]# java -version
    java version "1.8.0_291"
    Java(TM) SE Runtime Environment (build 1.8.0_291-b10)
    Java HotSpot(TM) 64-Bit Server VM (build 25.291-b10, mixed mode)

安装tomcat

1
2
3
4
5
6
7
8
9
10
11
12
13
14
wget https://dlcdn.apache.org/tomcat/tomcat-8/v8.5.72/bin/apache-tomcat-8.5.72.tar.gz
tar  zxvf apache-tomcat-8.5.72.tar.gz

# 启动tomcat
[root@racknerd-4dbd89 bin]# sh startup.sh
Using CATALINA_BASE:   /usr/local/apache-tomcat-8.5.72
Using CATALINA_HOME:   /usr/local/apache-tomcat-8.5.72
Using CATALINA_TMPDIR: /usr/local/apache-tomcat-8.5.72/temp
Using JRE_HOME:        /usr/jdk1.8.0_291/jre
Using CLASSPATH:       /usr/local/apache-tomcat-8.5.72/bin/bootstrap.jar:/usr/local/apache-tomcat-8.5.72/bin/tomcat-juli.jar
Using CATALINA_OPTS:
Tomcat started.


配置tomcat

  • 防火墙开发8080端口给tomcat
1
2
firewall-cmd --zone=public --add-port=8080/tcp --permanent
firewall-cmd --reload

  • 已经可以访问

    image-20211020162109704

安装jforum

  • 打开地址并下载

  • 将 jforum-2.6.2.war放到tomcat目录的webapps下；

  • 重启tomcat，sh shutdown.sh sh startup.sh

  • 输入 host:8080/jforum-2.6.2 进入安装流程

    image-20211020165041066

    image-20211020165234244

image-20211020165311313

image-20211020171443069

新增批量用户

  • 新增存储过程，批量新增用户，密码都是123456

    1
    2
    3
    4
    5
    6
    7
    8
    9
    10
    11
    12
    13
    14
    15
    16
    BEGIN
    DECLARE userName VARCHAR (20) ;
    DECLARE userMail VARCHAR (20) ;
    DECLARE i INT DEFAULT 9;#原来是1，要看jforum_users表最新一个用户的id是多少，要比最新那个用户id大就行
    WHILE i<= 400 DO
    set userName = CONCAT ('test1', LPAD ( i, 3, '0' )) ;
    set userMail = CONCAT (userName, '@test.com' ) ;
    #密码123456
    INSERT INTO jforum_users VALUES (i, '1', userName,   'e10adc3949ba59abbe56e057f20f883e', '0', '0',
      null, '2015-05-06 09:33:18', NULL,    '0', '', NULL, '',   '%d/%M/%Y %H:%i', '0',    '0', null, NULL,    '0', '1',
    '0',    '1', '1', '1',    '1', '1', '0',    '0', '1', '1',   '0', NULL,   '0',userMail, null, null, null,
    null, null, null, null, null, null, null, null, null, null, null, NULL);
    INSERT INTO jforum_user_groups VALUES (2,i) ;
    SET i = i+1;
    END WHILE;
    END

image-20211111112111795