Focalboard是一款由Mattermost开发的开源项目管理工具,旨在为个人和团队提供类似Trello、Notion和Asana的替代方案。它支持看板、列表、画廊和日历等多种视图,方便用户灵活组织和查看任务。Focalboard提供个人桌面版和个人服务器版,允许用户在本地或自托管环境中使用,确保数据隐私和安全。此外,它还能与Mattermost平台集成,增强团队协作能力。然而,需要注意的是,独立版本目前已停止维护,建议用户考虑与Mattermost集成的版本以获得持续支持。
一、升级CentOS
yum update
二、安装mysql57
2.1 在线安装-选择MySQL官方软件仓库
# MySQL5.7的软件仓库,下载文件的大小大概25K左右
wget -i -c http://dev.mysql.com/get/mysql57-community-release-el7-10.noarch.rpm
2.2 安装MySQL软件仓库
yum -y install mysql57-community-release-el7-10.noarch.rpm
2.3 开始安装MySQL
yum -y install mysql-community-server
Tips:若出现GPG Keys问题执行下面命令
rpm --import https://repo.mysql.com/RPM-GPG-KEY-mysql-2022
2.4 启动MySQL
[root@work ~]# service mysqld start
Redirecting to /bin/systemctl start mysqld.service
[root@work ~]# service mysqld status
2.5 配置MySQL的密码等属性
# %)5N/ncF=I,h 就是此次安装的MySQL的初始密码
[root@localhost ~]# grep "password" /var/log/mysqld.log
2020-08-05T02:55:25.487331Z 1 [Note] A temporary password is generated for root@localhost: .e-kj-?%S4da
[root@work ~]# grep "password" /var/log/mysqld.log
2024-06-23T14:06:29.704797Z 1 [Note] A temporary password is generated for root@localhost: %)5N/ncF=I,h
[root@work ~]# mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.7.44
Copyright (c) 2000, 2023, Oracle and/or its affiliates.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> CREATE DATABASE focalboard;
Query OK, 1 row affected (0.00 sec)
mysql> GRANT ALL on focalboard.* to 'root'@'localhost' identified by 'Focalboard@2024#';
Query OK, 0 rows affected, 1 warning (0.00 sec)
mysql> set password for root@localhost = password('Focalboard@2024#');
Query OK, 0 rows affected, 1 warning (0.00 sec)
mysql> set global validate_password_policy=0;
Query OK, 0 rows affected (0.00 sec)
mysql> set global validate_password_length=1;
Query OK, 0 rows affected (0.01 sec)
mysql> use mysql;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> update user set user.Host='%' where user.User='root';
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
[root@work ~]# firewall-cmd --permanent --add-port=3306/tcp
success
[root@work ~]# firewall-cmd --permanent --add-port=3306/udp
success
[root@work ~]# firewall-cmd --permanent --add-port=8080/udp
success
[root@work ~]# firewall-cmd --permanent --add-port=8080/tcp
success
[root@work ~]#
firewall-cmd --permanent --add-port=8000/tcp
success
[root@work ~]#
firewall-cmd --reload
success
三、安装FocalBoard
3.1 下载FocalBoard安装包
wget https://github.com/mattermost/focalboard/releases/download/v7.9.2/focalboard-server-linux-amd64.tar.gz
# 访问Github Release进行下载最新的版本
#解压
tar -zxvf focalboard-server-linux-amd64.tar.gz
sudo mv focalboard /var/www
#移到你的文件夹
3.2 配置MySQL数据库至config.json
vim /var/www/focalboard/config.json
"dbtype": "mysql",
"dbconfig": "root:focalboard:Focalboard@2024#@tcp(127.0.0.1:3306)/focalboard",
3.3 以服务运行
vim /lib/systemd/system/focalboard.service
[Unit]
Description=Focalboard server
[Service]
Type=simple
Restart=always
RestartSec=5s
ExecStart=/var/www/focalboard/bin/focalboard-server
WorkingDirectory=/var/www/focalboard
[Install]
WantedBy=multi-user.target
sudo systemctl daemon-reload
sudo systemctl start focalboard.service
sudo systemctl enable focalboard.service