Laravel GitScrum is a free and open source application developed in PHP Laravel. It is built to help the developer team to use Git and Scrum on the same interface for day to day task management. It comes with many features such as it can be easily integrated with GitHub or GitLab. Further, it has Product Backlog feature which contains the Product Owner's assessment of business value. It also has features like User Story, Sprint Backlog, and Issues managements. The application is responsive and can be used in different devices.
In this tutorial, we will be installing GitScrum on CentOS 7. We will also install all the required dependencies which include Apache, PHP 5.6, Node.js, and MariaDB.
GitScrum can be installed on systems with least of RAM, but the requirement of RAM increase as the number of users increases. You will also need a minimal installation of CentOS 7 with root access on it. If you are logged in as a non-root user, you can run sudo -i to switch to root user.
Before installing any package it is recommended that you update the packages and repository using the following command.
yum -y update
Once you have your system updated, run the following command to install few packages on your server.
yum -y install httpd mariadb-server mariadb git
The above command will install Apache web server with MariaDB database server and Git. Now you will need to install PHP. GitScrum supports both PHP 5.6 and 7.0. In this tutorial, we will learn to install both PHP 5.6 and 7.0. You must install only one version of PHP. The YUM repository contains PHP version 5.4 only, hence we will need to use the Webtatic repository to install a version of PHP 5.6 or 7.0. Run the following commands for installing EPEL repository as EPEL repository is required before we install Webtatic repository.
yum -y install epel-releaseyum -y update
Now install Webtatic repository using the following commands.
rpm -Uvh https://mirror.webtatic.com/yum/el7/webtatic-release.rpmyum -y updateyum clean all
To install PHP 5.6 and all the required PHP modules, run the following command.
To start Apache web server and enable it to start at boot time, run the following command.
systemctl start httpdsystemctl enable httpd
Start MariaDB and enable it to start at boot time using the following commands.
systemctl start mariadbsystemctl enable mariadb
Now run the following command to secure your MariaDB installation.
It will run a small script which asks you to provide the root password for MariaDB. As we have just installed MariaDB, the root password is not set, just press enter to proceed further. It will ask you if you want to set a root password for your MariaDB installation, choose y and set a strong password for the installation. It will also ask you for removing test databases and anonymous users. Most of the questions are self-explanatory and you should answer yes or y to all the questions.
Now you will need to create a database with database user to store GitScrum data. To create a database we will need to login to MySQL command line first. Run the following command for same.
mysql -u root -p
This will prompt you for the root password, provide the root password of MySQL which you have set earlier. Now run the following query to create a new database for your GitScrum installation.
CREATE DATABASE gitscrum_data;
The above query will create a database named gitscrum_data. For the database, you can use any name you prefer in the place of gitscrum_data. Make sure that you use semicolon at the end of each query as the query always ends with a semicolon. Once the database is created you can create a new user and grant all the permissions to the user for the database. To create a new database user, run the following query.
CREATE USER 'gitscrum_user'@'localhost' IDENTIFIED BY 'StrongPassword';
The above query will create a user with username gitscrum_user. You can use any preferred username instead of gitscrum_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 command:
GRANT ALL PRIVILEGES ON gitscrum_data.* TO 'gitscrum_user'@'localhost';
Now run the following command to immediately apply the changes on the database privileges.
Exit MySQL prompt by executing exit command.
Now install GitScrum, by cloning the repository on your system.
cd /var/www/htmlgit clone https://github.com/renatomarinho/laravel-gitscrum.git .
Change the APP_URL to the domain name of your application. You must also choose the protocol, http or https. Change APP_TITLE to any title you want to use for your application.
Also, you will need to create an application either on Github or Gitlab. If you are using Github, go to the Github OAuth application page and fill out the form with the following details.
Application name: <Same as your APP_TITLE>
Homepage URL: <Same as APP_URL at .env>
Application description: <A description for your app>
Authorization callback URL: http://<URL is the SAME APP_URL>/auth/provider/github/callback
You will get the GITHUB_CLIENT_ID= and GITHUB_CLIENT_SECRET, which you will need to provide in the following lines in .env file. It should look similar to this.
Next, Provide mysql in DB_CONNECTION= as we are using MariaDB which is a fork of MySQL. Provide 127.0.0.1 in DB_HOST=. Leave the database port to 3306. Further provide the database name, username, and database password, which we have created earlier. Finally, it should look like shown below.
Once .env file has been populated, run the following command to initialize GitScrum database.
php artisan GitScrum:init
Now you will need to disable your SELinux because MyBB does not work with SELinux policies. To temporary disable SELinux, run the following command.
To completely disable the SELinux you will need to edit /etc/selinux/config file.
If you don't have nano installed, you can install it using yum -y install nano Find the following line:
Change it to:
Now you will need to reboot your server so that the new configuration can take effect. Once the server is rebooted, you will need to provide the ownership of the application to web server user using the following command.
chown -R apache:apache /var/www/html
Furthermore, you will need to create a virtual host file so that the application is accessible from URL provided. Create a new virtual host file using the following command.
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...