Install Restyaboard, an Open Source Kanban board. I am using it daily to manage this blog.
Update package index.
$ sudo apt-get update
Upgrade installed packages.
$ sudo apt-get upgrade
Install basic utilities.
$ sudo apt-get install unzip wget git
Install the PostgreSQL server.
$ sudo apt-get install postgresql
Create the user and password for the Restyaboard application.
$ sudo -u postgres psql -c "CREATE ROLE restyaboard WITH LOGIN PASSWORD 'restyaboard'"
Create database.
$ sudo -u postgres createdb -O restyaboard -E UTF8 restyaboard
Configure database authentication for the created user.
$ cat << EOF | sudo tee -a /etc/postgresql/9.6/main/pg_hba.conf # restyaboard host restyaboard restyaboard 127.0.0.1/32 md5 EOF
Reload PostgreSQL server configuration.
$ sudo -u postgres psql -c "SELECT pg_reload_conf()"
Install nginx web server.
$ sudo apt-get install nginx-full
Install PHP Fast Process Manager with additional modules.
$ sudo apt-get install php-fpm php-pgsql php-curl php-imagick php-mbstring php-xml
Specify the default PHP timezone.
$ sudo sed -i -e "s/^;date.timezone =/date.timezone = Europe\/Warsaw/" /etc/php/7.0/fpm/php.ini
Reload PHP Fast Process Manager.
$ sudo systemctl reload php7.0-fpm
Create a directory to store the SSL certificate.
$ sudo mkdir /etc/nginx/ssl
Create a single-domain SSL certificate.
$ sudo openssl req -subj "/commonName=board.example.org/" -x509 -nodes -days 730 -newkey rsa:2048 -keyout /etc/nginx/ssl/nginx.key -out /etc/nginx/ssl/nginx.crt
Create Nginx site configuration. It is the default configuration located in a project repository.
$ sudo cat << EOF | sudo tee /etc/nginx/sites-available/restyaboard
server {
#listen 80 default_server;
listen 443 ssl;
ssl_certificate ssl/nginx.crt;
ssl_certificate_key ssl/nginx.key;
server_name _;
root /var/www/html;
index index.html index.php;
gzip on;
gzip_disable "msie6";
gzip_comp_level 6;
# gzip_comp_level 9;
gzip_min_length 1100;
gzip_buffers 16 8k;
gzip_proxied any;
# gzip_http_version 1.1;
gzip_types text/plain application/xml text/css text/js text/xml application/x-javascript text/javascript application/json application/xml+rss;
client_max_body_size 300M;
rewrite ^/oauth/authorize$ /server/php/authorize.php last;
rewrite ^/oauth_callback/([a-zA-Z0-9_\.]*)/([a-zA-Z0-9_\.]*)\$ /server/php/oauth_callback.php?plugin=\$1&code=\$2 last;
rewrite ^/download/([0-9]*)/([a-zA-Z0-9_\.]*)\$ /server/php/download.php?id=\$1&hash=\$2 last;
rewrite ^/ical/([0-9]*)/([0-9]*)/([a-z0-9]*).ics\$ /server/php/ical.php?board_id=\$1&user_id=\$2&hash=\$3 last;
rewrite ^/api/(.*)$ /server/php/R/r.php?_url=\$1&\$args last;
rewrite ^/api_explorer/api-docs/$ /client/api_explorer/api-docs/index.php last;
location / {
root /var/www/html/client;
}
location ~ \.php\$ {
try_files \$uri =404;
include fastcgi_params;
fastcgi_pass unix:/run/php/php7.0-fpm.sock;
fastcgi_index index.php;
fastcgi_param SCRIPT_FILENAME \$document_root\$fastcgi_script_name;
fastcgi_param PHP_VALUE "upload_max_filesize=80M \n post_max_size=120M \n max_execution_time=200 \n max_input_time=200 \n memory_limit=256M";
}
location ~* \.(css|js|less|html|ttf|woff|jpg|jpeg|gif|png|bmp|ico) {
root /var/www/html/client;
if (-f \$request_filename) {
break;
}
rewrite ^/img/([a-zA-Z_]*)/([a-zA-Z_]*)/([a-zA-Z0-9_\.]*)\$ /server/php/image.php?size=\$1&model=\$2&filename=\$3 last;
add_header Cache-Control public;
add_header Cache-Control must-revalidate;
expires 7d;
}
}
EOFDisable default Nginx site.
$ sudo unlink /etc/nginx/sites-enabled/default
Enable configured site.
$ sudo ln -s /etc/nginx/sites-available/restyaboard /etc/nginx/sites-enabled/
Reload Nginx configuration.
$ sudo systemctl reload nginx
Remove the default index file.
$ sudo rm /var/www/html/index.nginx-debian.html
Download recent Restyaboard release.
$ wget https://github.com/RestyaPlatform/board/releases/download/v0.6.1/board-v0.6.1.zip
Extract application to the /var/www/html/ directory.
$ sudo unzip -d /var/www/html/ board-v0.6.1.zip
Change user and group to www-data:www-data.
$ sudo chown -R www-data:www-data /var/www/html
Configure database access.
$ sudo sed -i -e "/^define('R_DB_HOST'/c\define('R_DB_HOST', 'localhost');" /var/www/html/server/php/config.inc.php
$ sudo sed -i -e "/^define('R_DB_USER'/c\define('R_DB_USER', 'restyaboard');" /var/www/html/server/php/config.inc.php
$ sudo sed -i -e "/^define('R_DB_PASSWORD'/c\define('R_DB_PASSWORD', 'restyaboard');" /var/www/html/server/php/config.inc.php
$ sudo sed -i -e "/^define('R_DB_NAME'/c\define('R_DB_NAME', 'restyaboard');" /var/www/html/server/php/config.inc.php
$ sudo sed -i -e "/^define('R_DB_PORT'/c\define('R_DB_PORT', 5432);" /var/www/html/server/php/config.inc.php
Load database schema.
$ sudo cat restyaboard/var/www/html/sql/restyaboard_with_empty_data.sql | psql restyaboard --username=restyaboard --password --host=localhost
Get basic board applications.
$ sudo git clone https://github.com/RestyaPlatform/board-apps.git /var/www/html/client/apps
Remove .git directory. Alternatively, you can deny access to this directory using Nginx.
$ sudo rm -rf /var/www/html/client/apps/.git
Fix permissions for additional applications.
$ sudo chown -R www-data:www-data /var/www/html/client/apps
The Restyaboard installation process does not require any particular actions. The official installer performs too many operations, so I decided to describe it using the simplest possible way. Just remember to change passwords.