Install FocalBoard - Project and Task Management Platform - on Linux

#Focalboard #Linux #Kanban

Full steps can be found at https://i12bretro.github.io/tutorials/0960.html

What is FocalBoard? Focalboard is an open source, multilingual, self-hosted project management tool that's an alternative to Trello, Notion, and Asana. It helps define, organize, track and manage work across individuals and teams. - https://github.com/mattermost/focalboard   Installation    01. Log into the Linux device    02. Run the following commands in a terminal:          # update software repositories          sudo apt update          # install any available software updates          sudo apt upgrade -y          # install nginx and MySQL database          sudo apt install nginx mariadb-server mariadb-client -y          # configure the MySQL database          sudo su          mysql_secure_installation    03. Press Enter to login as root    04. Type N and press Enter to not switch to socket authentication    05. Type Y and press Enter to set a root password, type the password twice to confirm    06. Type Y and press Enter to remove anonymous users    07. Type Y and press Enter to disallow root login remotely    08. Type Y and press Enter to remove the test database    09. Type Y and press Enter to reload privilege tables    10. Run the following command to login into MySQL:          mysql -u root -p    11. Authenticate with the root password set earlier    12. Run the following commands to create the database and database user          CREATE DATABASE focalboard DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;          GRANT ALL ON focalboard.* TO 'focalboard_rw'@'localhost' IDENTIFIED BY 'Foc@lB0a4d';          FLUSH PRIVILEGES;          EXIT;          exit    13. Continue with the following commands to download and extract FocalBoard to the webroot          # fetch the latest download URL          regex='"browser_download_url": "(https://github.com/mattermost/focalboard/releases/download/[^/]/focalboard-server-linux-amd64.tar.gz)"' && response=$(curl -H "Accept: application/vnd.github.v3+json" https://api.github.com/repos/mattermost/focalboard/releases) && [[ $response =~ $regex ]] && downloadURL="${BASH_REMATCH[1]}"          # download latest focalboard version          wget -O /tmp/focalboard.tar.gz $downloadURL          # extract the downloaded archive          sudo tar -xvzf /tmp/focalboard.tar.gz -C /opt          # edit focalboard configuration          sudo nano /opt/focalboard/config.json    14. Update the dbtype and dbconfig to the following          "dbtype": "mysql",          "dbconfig": "focalboard_rw:Foc@lB0a4d@tcp(127.0.0.1:3306)/focalboard",    15. Continue with the following commands          # create nginx config file          sudo nano /etc/nginx/sites-available/focalboard    16. Paste the following configuration          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;           }          }    17. Press CTRL+O, Enter, CTRL+X to write the changes    18. Continue with the following commands          # remove default nginx site          sudo rm /etc/nginx/sites-enabled/default          # enable the focalboard site config

....Full steps can be found on GitHub [link at the top]

Connect with me and others

★ Discord: https://discord.com/invite/EzenvmSHW8 ★ Reddit: https://reddit.com/r/i12bretro ★ Twitter: https://twitter.com/i12bretro ... https://www.youtube.com/watch?v=7KhhKpCJGVo