version: '3.1'

services:
  mysql:
    image: mysql:8.0.26
    container_name: flarum-db
    ports:
      - "5308:3306"
    environment:
      MYSQL_DATABASE: flarum
      MYSQL_ROOT_PASSWORD: dbpassword
    command: --character-set-server=utf8mb4 --collation-server=utf8mb4_general_ci
    privileged: true

  app:
    image: mondedie/flarum:latest
    container_name: flarum
    ports:
      - "5334:8888"
    environment:
      FORUM_URL: 'http://172.192.168.2.5:5334'
      DB_HOST: 'mysql'
      DB_USER: 'root'
      DB_PASS: 'thisispassword'
      FLARUM_ADMIN_USER: 'admin'
      FLARUM_ADMIN_PASS: 'fsd7fsd5f44'
      FLARUM_ADMIN_MAIL: 'asd1464@qq.com'
      FLARUM_TITLE: '问答小助手'
    links:
      - mysql

sudo yum -y install epel-release
sudo yum -y install https://mirrors.aliyun.com/remi/enterprise/remi-release-7.rpm
sudo yum -y install yum-utils

sudo yum-config-manager --enable remi-php80

sudo yum install  php-cli php-fpm php-mysqlnd php-zip php-devel php-gd php-mbstring php-curl php-xml php-pear php-bcmath php-json php-redis  --skip-broken

cp /usr/bin/php /usr/local/bin/php

 systemctl start php-fpm

php -r "copy('https://getcomposer.org/installer', 'composer-setup.php');"
php -r "if (hash_file('sha384', 'composer-setup.php') === '906a84df04cea2aa72f40b5f787e49f22d4c2f19492ac310e8cba5b96ac8b64115ac402c8cd292b8a03482574915d1a8') { echo 'Installer verified'; } else { echo 'Installer corrupt'; unlink('composer-setup.php'); } echo PHP_EOL;"

php composer-setup.php

php -r "unlink('composer-setup.php');"

sudo mv composer.phar /usr/local/bin/composer

mysql -uroot -p

create database db_flarum;

create user 'flarum'@'localhost' identified by '7c6fwgLskw+';

grant all on db_flarum.* to 'flarum'@'localhost';

flush privileges;

mkdir -p /www/flarum

cd /www/flarum

composer create-project flarum/flarum .

chmod -R 777 /www/flarum

chown -R www:www /www/flarum

# 问答平台
server {
  listen 80; 
  server_name  hikki.site; # 你的域名
  return       301 https://$server_name$request_uri;  
  
}
server {
  listen 443 ssl;
  server_name hikki.site; # 你的域名
  # 资源
  include  /www/flarum/.nginx.conf;
  root     /www/flarum/public; # flarum下的public
  index index.html index.php;
 
  # SSL证书
  ssl_certificate      cert/guangruan.life/cert.pem;  
  ssl_certificate_key  cert/guangruan.life/key.pem; 
  # 最大文件 
  client_max_body_size 1024M;
  # 日志
  access_log /usr/local/nginx/logs/access.log;
  error_log /usr/local/nginx/logs/error.log;


  # php-fpm
  location  ~* \.php$ {
    fastcgi_pass   127.0.0.1:9000;
    fastcgi_index  index.php;
    fastcgi_split_path_info  ^((?U).+\.php)(/?.+)$;
    fastcgi_param  SCRIPT_FILENAME  $document_root$fastcgi_script_name;
    fastcgi_param  PATH_INFO  $fastcgi_path_info;
    fastcgi_param  PATH_TRANSLATED  $document_root$fastcgi_path_info;
    include        fastcgi_params;
  }
}

cd /www/flarum

docker exec -it flarum sh

cd flarum/app/

composer config -g repo.packagist composer https://mirrors.aliyun.com/composer/

composer require flarum-lang/chinese-simplified:*

docker exec -it flarum-db /bin/bash

mysql -uflarum -phBf4sdf14

use db_flarum -- 进入db_flarum

ALTER TABLE tb_posts DROP INDEX content;

CREATE FULLTEXT INDEX tb_content ON `tb_posts` (`content`) WITH PARSER ngram;

ALTER TABLE tb_discussions DROP INDEX title;

CREATE FULLTEXT INDEX title ON `tb_discussions` (`title`) WITH PARSER ngram;

cd /www/flarum

docker exec -it flarum sh

cd flarum/app/

# 简体中文支持
composer require flarum-lang/chinese-simplified:*

# 最佳回复插件安装 -- 需要开启后点击保存才有效果 -- 帖子内部的回复置顶功能，非常好用
composer require fof/best-answer:*

# 安装文件上传扩展插件,开启上传插件，支持 copy images -- 可以直接复制图片拷贝到帖子内部
composer require fof/upload:*

# 使用邀请码注册
composer require fof/doorman:*

# 微信登录（需要微信开发者资质才可以使用）
composer require nomiscz/flarum-ext-auth-wechat

# 投票插件 -- 需要设置参与投票的人可以有哪些
composer require fof/polls:*

# 精华帖 - 推送到首页
composer require fof/frontpage:*


# 头像徽章插件 
composer require fof/ignore-users:*

# 开启私密主题 -- 效果不是很理想
composer require fof/byobu:*

# 自定义头像 -- 比如可以选择危化镖局的卡通头像（需要提前上传）
composer require clarkwinkelmann/flarum-ext-predefined-avatars:*

# 自定义邮件模板
composer require fof/pretty-mail:"*"

# 欢迎用户小部件，携带个人统计信息
composer require justoverclock/flarum-ext-welcomebox:*

# 传统板块插件
composer require askvortsov/flarum-categories:*

# 表情插件 -- 需要禁用掉自带的表情，不然会很怪异
composer require clarkwinkelmann/flarum-ext-emojionearea:*

# 同意条款
composer require fof/terms

# 帖子内容摘要
composer require ianm/synopsis

# 个人、群发邮件
composer require clarkwinkelmann/flarum-ext-mailing

# 预定义用户头像，允许用户从预定义头像库中选中一张作为自己的论坛头像
composer require clarkwinkelmann/flarum-ext-predefined-avatars:*

# 昵称功能，默认自带
# 需要到 常规功能模块里打开 User Display Name ，才能修改昵称

# 在首页生成用户管理 -- 如果是内部使用，可以关闭掉注册口邮件回复和激活功能，通过这里激活用户
composer require fof/user-directory:*

# 允许修改作者 -- 调整发布帖子的人
composer require clarkwinkelmann/flarum-ext-author-change:*

# 版主警告
composer require askvortsov/flarum-moderator-warnings

# 社交分享
composer require fof/share-social

# 对很久的帖子发出警告
composer require fof/prevent-necrobumping

# 自动审批
composer require askvortsov/flarum-auto-moderator:*

# 超级置顶
composer require the-turk/flarum-stickiest:^2.0.1

# 预定义标签发表模板
composer require askvortsov/flarum-discussion-templates

# 帖子书签
composer require clarkwinkelmann/flarum-ext-bookmarks

# 根据前置批准的数量，后续自动审批
composer require clarkwinkelmann/flarum-ext-first-post-approval

# 首页右侧热门帖子
composer require justoverclock/hot-discussions:"*"

# 短时间防止重复帖子
composer require the-turk/flarum-nodp

# 代码风格
composer require ffans/clipboardjs

# 自定义导航链接
composer require fof/links

# 用户自定义签名
composer require fof/user-bio:"*"

# 图片幻灯片
composer require darkle/fancybox

# 个人主页留言板
composer require fof/moderator-notes:"*"

# 广告
composer require afrux/news-widget:"*"

# 在线人数
composer require afrux/online-users-widget:"*"

# 过去一个月热门用户
composer require afrux/top-posters-widget:"*"

# 帖子增加首图卡片展示功能 -- 开启后会报错，要稍微等会，就能安装正常
composer require dem13n/discussion-cards:*

# 信任等级，可以提供一个等级设置，根据什么样的条件达成什么样的权限设置
composer require askvortsov/flarum-trust-levels:*

# 达成什么成就，就会在回复或发布的主题底下形成一排的成就图标!!! 点击启动时会报错，也是需要安装等待会才能正常
composer require malago/flarum-achievements:*

# 论坛统计功能 -- 还可以设置允许看到的人的权限
composer require fof/forum-statistics-widget:*

# markdown 表格功能扩展
composer require kvothe/pipetables

# 图片放大 缩小 -- 只有这个库支持 fof 图片放大缩小扩展！！！ -- 点击图片可放大查阅(已失效)
composer require phenomlab/fancybox-wrapper:*

php flarum cache:clear

composer update fof/best-answer

composer remove fof/best-answer

mysql -uflarum -p

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| db_flarum          |
+--------------------+
2 rows in set (0.00 sec)

mkdir -p /opt/dbs/

mysqldump -uroot -p db_flarum > /opt/dbs/db_flarum.sql

mysqldump -uroot -p mysql > /opt/dbs/mysql.sql

mkdir -p /home/docker/mysql/{mydir,db,conf,init} && cd /home/docker/mysql

[mysqld]
user=mysql
default-storage-engine=INNODB
character-set-server=utf8
character-set-client-handshake=FALSE
collation-server=utf8_unicode_ci
init_connect='SET NAMES utf8'
[client]
default-character-set=utf8
[mysql]
default-character-set=utf8

cp /opt/dbs/* ./init/

version: '3'
services:
  mysql5.6:
    restart: always
    image: mysql:5.7.18
    container_name: mysql-5.7.18
    volumes:
      - ./mydir:/mydir
      - ./db:/var/lib/mysql
      - ./conf/my.cnf:/etc/my.cnf
      - ./init:/docker-entrypoint-initdb.d  # 数据库还原目录 可将需要还原的sql文件放在这里
    environment:
      MYSQL_ROOT_PASSWORD: fv1sa5 # root用户密码，和之前数据库的密码一样
      MYSQL_USER: flarum # 新建一个flarum用户，和之前数据库的用户名一样
      MYSQL_PASSWORD: 7c1fhaiw # flarum用户密码，和之前数据库的密码一样
      MYSQL_DATABASE: db_flarum # 新建一个db_flarum数据库
      TZ: Asia/Shanghai
    ports:
      - 3506:3306 # 宿主机：容器

[root@ECS-4 flarum]# ip addr show docker0
6: docker0: <NO-CARRIER,BROADCAST,MULTICAST,UP> mtu 1500 qdisc noqueue state DOWN group default
    link/ether 02:42:33:cd:b9:61 brd ff:ff:ff:ff:ff:ff
    inet 172.17.0.1/16 brd 172.17.255.255 scope global docker0
       valid_lft forever preferred_lft forever
    inet6 fe80::42:33ff:fecd:b961/64 scope link
       valid_lft forever preferred_lft forever

<?php return array (
  'debug' => false,
  'database' =>
  array (
    'driver' => 'mysql',
    'host' => '172.17.0.1',
    'port' => 3506,
    'database' => 'db_flarum',
    'username' => 'flarum',
    'password' => '7c1fhaiw',
    'charset' => 'utf8mb4',
    'collation' => 'utf8mb4_unicode_ci',
    'prefix' => 'tb_',
    'strict' => false,
    'engine' => 'InnoDB',
    'prefix_indexes' => true,
  ),
  'url' => 'https://XXXX',
  'paths' =>
  array (
    'api' => 'api',
    'admin' => 'admin',
  ),
  'headers' =>
  array (
    'poweredByHeader' => true,
    'referrerPolicy' => 'same-origin',
  ),
);