This article is outdated and may not work correctly for current operating systems or software.
Kanboard is a free and open source project management software program which is designed to facilitate and visualize team work-flow using the Kanban methodology.
This article will show you how to setup Kanboard on Debian 9.
A Vultr Debian 9 server instance, we will use 203.0.113.1 as an example IP address.
A sudo user.
Log into the server as a sudo user from an SSH terminal, update the Debian 9 system and install git.
sudo apt update && sudo apt upgrade -y
sudo apt install -y git
sudo reboot
After the reboot, log back in as the same sudo user and continue to the next step.
Install the Apache 2.4 web server for Kanboard.
sudo apt install apache2 -y
Start and enable the Apache service.
sudo systemctl enable --now apache2.service
By default, Kanboard uses SQLite to store its data. Alternatively, you can use MariaDB (MySQL) to enhance performance in a production environment.
Install MariaDB.
sudo apt install -y mariadb-server mariadb-client
Start and enable the MariaDB service.
sudo systemctl enable --now mariadb.service
Secure the installation.
sudo mysql_secure_installation
Reply to the questions on the screen as shown below. For security purposes, you should always setup a private and strong MariaDB root password.
Enter current password for root (enter for none): Enter
Set root password? [Y/n]: Y
New password: <your-password>
Re-enter new password: <your-password>
Remove anonymous users? [Y/n]: Y
Disallow root login remotely? [Y/n]: Y
Remove test database and access to it? [Y/n]: Y
Reload privilege tables now? [Y/n]: Y
Kanboard requires PHP 5.3.9 or greater. We will be using PHP 7.0 (and several extensions), which is the default version available in official Debian repositories.
sudo apt install -y php php-mysql php-gd php-mbstring php-common php-ldap php-opcache php-cli php-xml
Download and install the latest release of Kanboard.
cd /var/www/html
sudo git clone https://github.com/kanboard/kanboard.git
sudo chown -R www-data:www-data kanboard/data
Setup a MySQL database and a database user for Kanboard.
sudo mysql -u root -p -e "CREATE DATABASE kanboard;"
sudo mysql -u root -p kanboard < /var/www/html/kanboard/app/Schema/Sql/mysql.sql
sudo mysql -u root -p -e "CREATE USER 'kanboarduser'@'localhost' IDENTIFIED BY 'yourpassword';"
sudo mysql -u root -p -e "GRANT ALL PRIVILEGES ON kanboard.* TO 'kanboarduser'@'localhost' IDENTIFIED BY 'yourpassword' WITH GRANT OPTION;"
sudo mysql -u root -p -e "FLUSH PRIVILEGES;"
Note: When prompted, input the MariaDB root password you had setup earlier. You should also choose a strong user password other than the one shown above.
Update the Kanboard configuration file in order to switch to MySQL.
cd /var/www/html/kanboard
sudo mv config.default.php config.php
Open config.php with a text editor of your choice.
sudo vi config.php
Find the following lines.
// Database driver: sqlite, mysql or postgres (sqlite by default)
define('DB_DRIVER', 'sqlite');
// Mysql/Postgres username
define('DB_USERNAME', 'root');
// Mysql/Postgres password
define('DB_PASSWORD', '');
// Mysql/Postgres hostname
define('DB_HOSTNAME', 'localhost');
// Mysql/Postgres database name
define('DB_NAME', 'kanboard');
Modify them as follows.
// Database driver: sqlite, mysql or postgres (sqlite by default)
define('DB_DRIVER', 'mysql');
// Mysql/Postgres username
define('DB_USERNAME', 'kanboarduser');
// Mysql/Postgres password
define('DB_PASSWORD', 'yourpassword');
// Mysql/Postgres hostname
define('DB_HOSTNAME', 'localhost');
// Mysql/Postgres database name
define('DB_NAME', 'kanboard');
Restart Apache.
sudo systemctl restart apache2.service
Finally, point your web browser to http://203.0.113.1/kanboard to start using Kanboard. Use the following default credentials to log in:
Username: admin
Password: admin
Note: For security purposes, remember to modify admin's password using the users management link from the upper right-hand admin drop-down menu.
In order to achieve the best performance on your Kanboard server, you can adjust the settings of Zend OpCache which has been enabled by default.
For example, when using Kanboard on a single-node setup in production as we intended in this article, you can use the following settings as a starter to optimize Zend OpCache.
Open the Zend OpCache configuration file.
sudo vi /etc/php/7.0/apache2/conf.d/10-opcache.ini
Modify the file in accordance with the following settings.
zend_extension=opcache.so;
opcache.enable=1;
opcache.file_cache=/tmp/opcache
opcache.validate_timestamps=0
opcache.revalidate_freq=0
opcache.memory_consumption=192
opcache.interned_strings_buffer=16
opcache.max_accelerated_files=1979
opcache.fast_shutdown=1
Restart the Apache service to put your changes into effect.
sudo systemctl restart apache2.service
In order to generate accurate reports and analytics, you need to setup a daily cron job using the www-data user.
sudo crontab -u www-data -e
Populate the crontab file with the following cronjob.
0 3 * * * cd /var/www/html/kanboard && ./cli cronjob >/dev/null 2>&1
Save and quit.
With this cron job, all of the reports and analytics will be updated at 3:00 AM everyday.