MyCollab is a free and open-source project management application for team collaboration .It is mostly used for project management and documentation purposes in industry. This guide will help you install and configure MyCollab on your CentOS server for project management purposes.
For installing Mycollab on your CentOS server you should have at least 1 GB of RAM but we recommend 2 GB of RAM and root privileges on the server. You can switch between root user and sudo user using sudo -i command.
Before installing the MyCollab community edition on your server it is recommended to update the system use following command to do so.
yum -y update
Now once the system is updated you'll need to install Java Runtime Environment.
MyCollab requires Java to be installed on your server so first install java using following command.
You can check the status of MySQL using the following command.
systemctl status mysqld
You should see following result on your screen:
[root@ip-172-31-21-42 ~]# systemctl status mysqld
● mysqld.service - MySQL Server
Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)
Active: active (running) since Wed 2017-01-11 13:20:58 UTC; 1min 21s ago
Main PID: 10715 (mysqld)
└─10715 /usr/sbin/mysqld --daemonize --pid-file=/var/run/mysqld/mysqld.pid
Jan 11 13:20:52 ip-172-31-21-42 systemd: Starting MySQL Server...
Jan 11 13:20:58 ip-172-31-21-42 systemd: Started MySQL Server.
During installation of MySQL, the installer automatically uses a random password for the MySQL root user, you can obtain the password using the following command.
grep 'temporary password' /var/log/mysqld.log
You will see the following output containing the current root password.
[root@ip-172-31-21-42 ~]# grep 'temporary password' /var/log/mysqld.log
2017-01-11T13:20:55.542896Z 1 [Note] A temporary password is generated for root@localhost: ,Zxrn2eusuSn
Now you can run the following command to harden the security of your MySQL server.
You will be asked about your current root password, enter the password obtained through the command above. Now it will prompt to change your root password, and provide y for all the questions asked.
We have successfully installed MySQL on our server now let's create a database for MyCollab and to do so follow below given instructions.
Login to your MySQL shell using the following command and providing the required password when prompted.
mysql -u root -p
Now execute the following query to create a new database.
CREATE SCHEMA mycollab DEFAULT CHARACTER SET utf8mb4;
The above query will create a database named mycollab. For the database you can use any name you prefer in the place of mycollab. Make sure that you use semicolon at the end of each query as a MySQL query always ends with a semicolon. Once the database is created you can create a new user and grant the required permissions to the user for the database.
CREATE USER 'mycollab_user'@'localhost' IDENTIFIED BY 'StrongPassword';
The above query will create a user with username mycollab_user. You can use any preferred username instead of mycollab_user. Replace StrongPassword with a strong password.
Now provide the appropriate privileges to your database user over the database you have created. Run the following query to do so.
GRANT ALL PRIVILEGES ON mycollab.* TO 'mycollab_user'@'localhost'; Now run the following query to immediately apply the changes on the database privileges.FLUSH PRIVILEGES;
Now you can exit from MySQL prompt using following command.
Now download latest stable release of mycollab community edition from Github and in order to download it use following commands as shown below.
First install wget command on your system if you do not already have installed on your system using yum install wget.
Please provide all the details asked for setting up the installation wizard like:
Site name: < Your Site Name>
Server address: 18.104.22.168 or example.com
Database name: mycollab
User name: mycollab_user
Password: your strong password
Database server address: localhost
Finally click on Setup button to finish the installation wizard and by clicking the setup button your browser will be automatically redirected to application homepage(It will take some time so you should wait).
Secure MyCollab instances
By default, MyCollab has not provided built-in SSL support because there are many our customers already setup using reverse proxy in front of their servers, as well as their cloud service which uses such a solution as well.
We recommend you use the reverse proxy; there are two free solutions which are Apache and Nginx. Setup SSL on these servers and forward requests to the internal MyCollab instance. The reverse proxy can play the role of caching content, application firewall or the TLS Termination proxy for your all web applications.
In this tutorial you learned how to install and configure the MyCollab community edition on your CentOS 7 server and now we hope you have enough knowledge to work with MyCollab. You can now deploy and manage your projects using MyCollab.
Truth be told, it’s difficult for a web application that doesn’t have some kind of identification, even if you don’t see it as a security measure in and of itself. The Internet is a kind of lawless land, and even on free services like Google’s, authentication ensures that abuses will...
Although data persistence is almost always a fundamental element of applications, Node.js has no native integration with databases. Everything is delegated to third-party libraries to be included manually, in addition to the standard APIs. Although MongoDB and other non-relational databases are the most common choice with Node because if you...