docker 布署基于mysql

26 June 2023

docker 布署基于Mysql 的 Focalboard

docker run command

docker run -dit \
    --name focalboard \
    --restart=unless-stopped \
    --network=mynet \
    -p 8130:8000 \
    -e VIRTUAL_HOST=localhost \
    -e VIRTUAL_PORT=8000 \
    -e VIRTUAL_PROTO=http \
    -v $PWD/data:/opt/focalboard/data \
    -v $PWD/config.json:/opt/focalboard/config.json \
    mattermost/focalboard:latest

创建数据库并授权

CREATE DATABASE focalboard CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
GRANT ALL PRIVILEGES ON focalboard.* TO 'luowei'@'%';
flush privileges; 

config.json

{
    "serverRoot": "http://localhost:8000",
    "port": 8000,
    "dbtype": "mysql",
    "dbconfig": "db-username:db-password@db_mysql/focalboard",
    "mysql_dbconfig": "dbname=boards sslmode=disable",
    "useSSL": false,
    "webpath": "./pack",
    "filespath": "./data/files",
    "telemetry": true,
    "prometheusaddress": ":9092",
    "session_expire_time": 2592000,
    "session_refresh_time": 18000,
    "localOnly": false,
    "enableLocalMode": true,
    "localModeSocketLocation": "/var/tmp/focalboard_local.socket"
}

支持websocket ，在 nginx 的 server 配置中的 location / {...}添加以下几行：

proxy_http_version 1.1;
proxy_set_header Upgrade $http_upgrade;
proxy_set_header Connection "upgrade";

live
note.wodedata.com u/p:luowei/weluo389

Preview
-w800

参考文档
Focalboard Administrator’s Guide
How to Install Focalboard on Your Synology NAS
Focalboard config.json
开源笔记、项目、资金管理类程序：Focalboard安装及使用
 Focalboard ：一款开源、本地存储、免费的类 Notion 应用
 Focalboard official docker image