CentOS7安装开源笔记Focalboard

主要参考官方文档

https://www.focalboard.com/download/personal-edition/ubuntu/

说明：官方文档为Ubuntu下安装，本文为CentOS7下安装，安装步骤、安装过程略有差异但大致相同

进入安装位置
cd /usr/local/focalboard (这是我的安装位置)

下载安装包
wget https://github.com/mattermost/focalboard/releases/download/v0.15.0/focalboard-server-linux-amd64.tar.gz

解压得到focalboard
tar -xvzf focalboard-server-linux-amd64.tar.gz

在Nginx中新建目录（假设你已安装Nginx）

cd 你的Nginx安装位置
mkdir sites-available
mkdir sites-enabled

如果没有安装Nginx，可以参考以下链接进行安装

https://www.cnblogs.com/pxstar/p/14808244.html

https://www.cnblogs.com/jepson6669/p/9131217.html

添加focalboard配置

cd sites-available
vim focalboard

输入（参考官方文档配置）

upstream focalboard {
   server localhost:8000;
   keepalive 32;
}

server {
   listen 80 default_server;

   server_name focalboard.example.com;

   location ~ /ws/* {
       proxy_set_header Upgrade $http_upgrade;
       proxy_set_header Connection "upgrade";
       client_max_body_size 50M;
       proxy_set_header Host $http_host;
       proxy_set_header X-Real-IP $remote_addr;
       proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for;
       proxy_set_header X-Forwarded-Proto $scheme;
       proxy_set_header X-Frame-Options SAMEORIGIN;
       proxy_buffers 256 16k;
       proxy_buffer_size 16k;
       client_body_timeout 60;
       send_timeout 300;
       lingering_timeout 5;
       proxy_connect_timeout 1d;
       proxy_send_timeout 1d;
       proxy_read_timeout 1d;
       proxy_pass http://focalboard;
   }

   location / {
       client_max_body_size 50M;
       proxy_set_header Connection "";
       proxy_set_header Host $http_host;
       proxy_set_header X-Real-IP $remote_addr;
       proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for;
       proxy_set_header X-Forwarded-Proto $scheme;
       proxy_set_header X-Frame-Options SAMEORIGIN;
       proxy_buffers 256 16k;
       proxy_buffer_size 16k;
       proxy_read_timeout 600s;
       proxy_cache_revalidate on;
       proxy_cache_min_uses 2;
       proxy_cache_use_stale timeout;
       proxy_cache_lock on;
       proxy_http_version 1.1;
       proxy_pass http://focalboard;
   }
}

建立软连接

ln -s /usr/local/nginx/sites-available/focalboard /usr/local/nginx/sites-enabled/

重启Nginx

/usr/local/nginx/sbin/nginx -t

开启8000端口

firewall-cmd --zone=public --add-port=8000/tcp --permanent 
systemctl restart firewalld.service         //重启防火墙

--相关命令
firewall-cmd --list-all          //查看已开放端口
rewall-cmd --zone=public --add-port=80/tcp --permanent   // 添加
firewall-cmd --zone=public --add-port=111-222/tcp --permanent   // 范围添加  
firewall-cmd --zone=public --remove-port=80/tcp --permanent      // 删除
systemctl status firewalld      //防火墙状态

安装postgresql

参考

https://blog.csdn.net/qq_36213352/article/details/117856659

yum install -y https://download.postgresql.org/pub/repos/yum/reporpms/EL-7-x86_64/pgdg-redhat-repo-latest.noarch.rpm

yum install -y postgresql13-server postgresql13

打开postgresql并添加用户

su postgres

psql

CREATE DATABASE boards;

CREATE USER boardsuser WITH PASSWORD 'boardsuser';

退出：\q 或 exit;

修改focalboard

cd /usr/local/focalboard (我的focalboard安装位置)

vim config.json

#-- 将
    "dbtype": "sqlite3",
    "dbconfig": "./focalboard.db",
#--修改为
    "dbtype": "postgres",
    "dbconfig": "postgres://boardsuser:boardsuser@localhost/boards?sslmode=disable&connect_timeout=10",

设置自启动

vim /lib/systemd/system/focalboard.service

添加以下代码

[Unit]
Description=focalboard service
After=network.target

[Service]
Type=forking
ExecStart=你的安装位置/bin/focalboard-server
WorkingDirectory=你的安装位置

[Install]
WantedBy=multi-user.target

systemctl enable focalboard.service         --加入自启动计划
systemctl start focalboard.service          --启动
-- 相关命令
systemctl restart focalboard.service      --重新启动
systemctl status focalboard.service         --查看运行状态

测试

启动后通过ip：8000访问