开源项目管理 focalboard

今天先想找个项目管理的项目，本来想用 makeplane/plane ，但是没汉化，部署也稍微麻烦。于是就用了 focalboard 简洁点。

下面介绍下部署流程：

参考官方部署手册 https://www.focalboard.com/download/personal-edition/ubuntu/

下载安装包：

去 https://github.com/makeplane/plane/releases 找最新版本

1
2
3
wget https://github.com/mattermost/focalboard/releases/download/v0.15.0/focalboard-server-linux-amd64.tar.gz
tar -xvzf focalboard-server-linux-amd64.tar.gz
sudo mv focalboard /opt

修改配置

支持Mysql 、 和PG 数据库,默认用 sqlite3。

如果用数据库 修改配置 /opt/focalboard/config.json 下的 dbtype、dbconfig

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
{
  "serverRoot": "http://localhost:8000",
  "port": 8000,
  "dbtype": "sqlite3",
  "dbconfig": "./data/focalboard.db",
  "postgres_dbconfig": "dbname=focalboard sslmode=disable",
  "useSSL": false,
  "webpath": "./pack",
  "filespath": "./data/files",
  "telemetry": true,
  "session_expire_time": 2592000,
  "session_refresh_time": 18000,
  "localOnly": false,
  "enableLocalMode": true,
  "localModeSocketLocation": "/var/tmp/focalboard_local.socket"
}

PG：

1
2
"dbtype": "postgres",
"dbconfig": "postgres://boardsuser:boardsuser-password@localhost/boards?sslmode=disable&connect_timeout=10",

Mysql：

1
2
"dbtype": "mysql",
"dbconfig": "boardsuser:boardsuser-password@tcp(127.0.0.1:3306)/boards",

将 Focalboard 配置为作为服务运行

这将使服务器在重新启动后保持运行。首先，创建一个新的服务配置文件：

1
sudo vim /lib/systemd/system/focalboard.service

粘贴以下内容：

1
2
3
4
5
6
7
8
9
10
11
12
[Unit]
Description=Focalboard server

[Service]
Type=simple
Restart=always
RestartSec=5s
ExecStart=/opt/focalboard/bin/focalboard-server
WorkingDirectory=/opt/focalboard

[Install]
WantedBy=multi-user.target

让 systemd 重新加载新单元，并在机器重新启动时启动它：

1
2
3
sudo systemctl daemon-reload
sudo systemctl start focalboard.service
sudo systemctl enable focalboard.service

测试服务器

此时，Focalboard 服务器应该正在运行。

使用以下命令测试它是否在本地运行：

1
curl localhost:8000

效果如下：
img.png

项目升级：

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
# Download the new version (e.g. 0.9.2 here, check the release for the latest one)
wget https://github.com/mattermost/focalboard/releases/download/v7.10.6/focalboard-server-linux-amd64.tar.gz
tar -xvzf focalboard-server-linux-amd64.tar.gz

# Stop the server
sudo systemctl stop focalboard.service

# Back up the old version
sudo mv /opt/focalboard /opt/focalboard-old
sudo mv focalboard /opt

# Copy config and move uploaded files over
sudo mv /opt/focalboard-old/files /opt/focalboard
sudo cp /opt/focalboard-old/config.json /opt/focalboard

# Start the server
sudo systemctl start focalboard.service

# (Optional) delete the backup after verifying
sudo rm -rf /opt/focalboard-old