Install MyCollab Project Management / CRM Portal on Ubuntu 16.04 | 18.04 | 18.10

MyCollab is a flexible open source project management and CRM web platform written Java.  It provides the essential features of tasks, issues, knowledge management, and other project activities management. It also integrates with other popular open source plugins to make managing your projects easy.…

If you want a project management platform that has enterprise-class features, scalable, and performs at a high level, then MyCollab is a good place to start… MyCollab is built on an open source core with support for open standards, which might be very useful in helping you run your projects…

MyCollab platform is designed for ease of use to allow enterprises and business owners to collaborate and automate engaging experiences with users across multiple devices, including mobile…

For more about MyCollab, please check their Homepage

This brief tutorial is going to show students and new users how to install MyCollab on Ubuntu 16.04 / 18.10 and 18.04 LTS…To get started with installing MyCollab, follow the steps below:

Step 1: Install OpenJDK

MyCollab is a Java based program and requires Java JDK installed. You can choose to install Oracle JDK or use the open source version, OpenJDK. The open source version works great on Ubuntu.

To install it, run the commands

sudo apt update
sudo apt-get install openjdk-8-jdk

After that, OpenJDK should be installed and ready to use.

Step 2: Install MariaDB Database Server

MyCollab also requires a database server to store its content. If you’re looking for a truly open source database server, then MariaDB is a great place to start. To install MariaDB run the commands below:

sudo apt-get install mariadb-server mariadb-client

After installing MariaDB, the commands below can be used to stop, start and enable MariaDB service to always start up when the server boots.

Run these on Ubuntu 16.04 LTS

sudo systemctl stop mysql.service
sudo systemctl start mysql.service
sudo systemctl enable mysql.service

Run these on Ubuntu 18.10 and 18.04 LTS

sudo systemctl stop mariadb.service
sudo systemctl start mariadb.service
sudo systemctl enable mariadb.service

Next, run the commands below to secure the database server with a root password if you were not prompted to do so during the installation.

sudo mysql_secure_installation

When prompted, answer the questions below by following the guide.

  • Enter current password for root (enter for none): Just press the Enter
  • Set root password? [Y/n]: Y
  • New password: Enter password
  • Re-enter new password: Repeat 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

Now that MariaDB is installed, to test whether the database server was successfully installed, run the commands below.

sudo mysql -u root -p

type the root password when prompted.

mariadb welcome

If you see a similar screen as shown above, then the server was successfully installed.

Step 3: Create MyCollab Database

Now that you’ve installed all the packages that are required for MyCollab to function, continue below to start configuring the servers. First run the commands below to create a blank MyCollab database.

To logon to MariaDB database server, run the commands below.

sudo mysql -u root -p

Then create a database called mycollab

CREATE SCHEMA mycollab DEFAULT CHARACTER SET utf8mb4;

Create a database user called mycollabuser with a new password

CREATE USER 'mycollabuser'@'localhost' IDENTIFIED BY 'new_password_here';

Then grant the user full access to the database.

GRANT ALL ON mycollab.* TO 'mycollabuser'@'localhost' IDENTIFIED BY 'user_password_here' WITH GRANT OPTION;

Finally, save your changes and exit.

FLUSH PRIVILEGES;
EXIT;

Step 4: Enable the MyCollab Site

After installing OpenJDK and MariaDB, run the commands below to download the latest version of MyCollab. as the time of this writing, the latest version is 5.3.4.

wget 
unzip MyCollab-All-5.3.4.zip

After extracting the downloaded content, move it to your home directory by running the commands below:

mv MyCollab-5.3.4/ ~/mycollab

After run the commands below to being installing.

sh ~/mycollab/bin/startup.sh

that should launch MyCollab setup page as shown below. On this page, setup your site name, URL and database connection info you created above. then click the Setup button.

MyCollab Ubuntu Install

After that, create an admin account and continue.

MyCollab Ubuntu Install

After that, MyCollab should be installed and ready to use.

MyCollab Ubuntu Install

That’s it!

Congratulation! You have successfully installed MyCollab on Ubuntu 16.04 | 18.04 and 18.10.

You may also like the post below: