Installation and Configuration Guide for Orangescrum Community Edition ( Ubuntu 14.04 LAMP )

Ref : https://hostpresto.com/community/tutorials/communityarticleshow-to-setup-and-install-orangescrum-on-ubuntu-14-04/

Requirements

  • A Server running Ubuntu 14.04
  • A Static IP Address for your server

Install Mysql

By default the mysql package is available in the Ubuntu 14.04 repository.

So, you can easily install mysql using the following command:

sudo apt-get install mysql-server

After this, start mysql service and enable mysql to start on boot.

sudo /etc/init.d/mysql start sudo update-rc.d mysql defaults

Install Php and Apache

After installing mysql, you will need to install PHP and Apache.

sudo apt-get install libapache2-mod-php5 php5 php5-cli php5-common php5-gd php5-mcrypt php5-mysql apache2

After this, start Apache service and enable Apache to start on boot.

sudo /etc/init.d/apache2 start sudo update-rc.d apache2 defaults

Download Orangescrum and Upload it to Apache Web root

You can download Orangescrum open source version from url https://github.com/Orangescrum/orangescrum.

sudo wget https://github.com/Orangescrum/orangescrum/archive/master.zip

After downloading Orangescrum you will need to unzip master.zip.

sudo unzip master.zip

After this, You will find the orangescrum-master directory.

Now, move this directory with name orangescrumPM to your Apache web root directory.

sudo mv orangescrum-master /var/www/html/orangescrumPM

Give proper permissions to the orangescrumPM directory.

sudo chown -R www-data:www-data /var/www/html/orangescrumPM sudo chmod -R 777 /var/www/html/orangescrumPM

Configure Mysql

In order to log into MySQL to secure it, you’ll need the current password for the root user. If you’ve just installed MySQL, and you haven’t set the root password yet, the password will be blank.

sudo mysql_secure_installation

Answer all the questions shown as below:

Enter current password for root (enter for none): **currentrootpasswd**
Set root password? [Y/n]: **Press Enter**
New password: **rootsqlpasswd**
Re-enter new password: **rootsqlpasswd**
Remove anonymous users? [Y/n]: **Press Enter**
Disallow root login remotely? [Y/n]: **Press Enter**
Remove test database and access to it? [Y/n] : **Press Enter**
Reload privilege tables now? [Y/n] : **Press Enter**

All done! If you’ve completed all of the above steps, your MySQL installation should now be secure. Now, You need login to mysql, create database and user for Orangescrum.

sudo mysql -u root -p

Create the database with the name Orangescrum:

mysql> create database orangescrum;

Create the user with the name orangescrum:

mysql> create user orangescrum;

Grant all privileges while assigning the password, chose a secure password and replace my-secret-password with your own:

mysql> grant all on orangescrum.* to 'orangescrum'@'localhost' identified by 'my-secret-password';

Exit from the mysql shell:

mysql> exit

Now, You will need to import the database from database.sql file located in /var/www/html/orangescrumPM directory.

First, change into the orangescrum directory:

sudo cd /var/www/html/orangescrumPM/

Now import the sql file:

sudo mysql -u orangescrum -porangescrum < database.sql

Next, by default STRICT mode is On in Mysql. So you need to disable it.

You can do this by editing my.cnf file:

sudo nano /etc/mysql/my.cnf

Add the following line at the end of file:

sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

Save and close the file, restart mysql to reflect changes.

sudo /etc/init.d/mysql restart

##Configure PHP

Now, You wiil need to change the ‘post_max_size’ and upload_max_filesize to 200M in php.ini.

You can do this by editing the php.ini file:

sudo nano /etc/php5/cli/php.ini

Change the post_max_size and upload_max_size as shown below:

post_max_size=200M
...
upload_max_filesize=200M

Save and close the file.

Configure Apache

The next step is to add orangescrumPM in the Apache default configuration file.

You can do this by editing apache2.conf file:

sudo nano /etc/apache2/apache2.conf

Add the following content:

``` language-bash

Options Indexes ExecCGI MultiViews FollowSymLinks AllowOverride All Order allow,deny Allow from all


When you are finished, it is recommended to check the configuration for syntax errors.

`sudo apachectl configtest`

You should see following output if Apache configuration syntax is correct:

Syntax OK


After the syntax check is done you need to enable Apache headers and rewrite module.

You can do this by running:

`sudo a2enmod rewrite` `sudo a2enmod headers`

Now, restart Apache to reflect the changes:

`sudo /etc/init.d/apache2 restart`

## Configure Orangescrum

Now you need to update the database connection details in `database.php` file.

You can do this by editing `database.php` file.

`sudo nano /var/www/html/orangescrumPM/app/Config/database.php`

Change the following lines, not forgetting to substitute in your password instead of 'my-secret-password':

    class DATABASE_CONFIG {

public $default = array( 'datasource' => 'Database/Mysql', 'persistent' => false,'host' => 'localhost', 'login' => 'orangescrum', 'password' => 'my-secret-password', 'database' => 'orangescrum', 'prefix' => '', 'encoding' => 'utf8', );}


Save and close the file when you are finished.

Next, you will need to provide an SMTP service for Orangescrum to send email from. In this example we use a Gmail account, but you can use any SMTP service such as Sendgrid or Mandrill.

Edit the Orangescrum `constants.php` file:

`sudo nano /var/www/html/orangescrumPM/app/Config/constants.php`

Change the following line:

    //Gmail SMTP
    define("SMTP_HOST", "ssl://smtp.gmail.com");
    define("SMTP_PORT", "465");
    define("SMTP_UNAME", "user@gmail.com");
    define("SMTP_PWORD", "**********");define('FROM_EMAIL_NOTIFY', 'user@gmail.com'); //(REQUIRED)
    define('SUPPORT_EMAIL', 'user@gmail.com'); //(REQUIRED) From Email
    define("DEV_EMAIL", 'user@gmail.com'); // Developer Email ID to report the application error

define('SUB_FOLDER', '/');

“`

FROM_EMAIL_NOTIFY : All the tasks created/updated notification emails will be sent from this email address.

SUPPORT_EMAIL : All other emails and support related emails will be sent from this email address.

Save and close the file, when you are finished.

##Testing Orangescrum

From a remote machine, open your Firefox browser and type url http://your-server-ip-address

You will be asked to provide your Company Name, Email address and a Password to login and start using Orangescrum.

After this, you can see the orangescrum welcome page.

Setting up Laravel with Nginx and phpmyadmin on Ubuntu 14.04

1) Install the Backend Components
1.1) sudo apt-get update
1.2) sudo apt-get upgrade
1.3) sudo apt-get install nginx php5-fpm php5-cli php5-mcrypt git
--------------------------------------------------------------------------------------------------------------------------
2) Modify the PHP Configuration
2.1) sudo nano /etc/php5/fpm/php.ini
2.2) cgi.fix_pathinfo=0 
2.3) sudo php5enmod mcrypt
2.4) sudo service php5-fpm restart
--------------------------------------------------------------------------------------------------------------------------
3) Configure Nginx and the Web Root
3.1) sudo mkdir -p /var/www/laravel
3.2) sudo nano /etc/nginx/sites-available/default


=======================================================
server {
    listen 80 default_server;
    listen [::]:80 default_server;

    #root /var/www/laravel/public;
    index index.php index.html index.htm;

    server_name server_domain_or_IP;

    location / {
        try_files $uri $uri/ /index.php?$query_string;
    }

    location ~ \.php$ {
        try_files $uri /index.php =404;
        fastcgi_split_path_info ^(.+\.php)(/.+)$;
        fastcgi_pass unix:/var/run/php5-fpm.sock;
        fastcgi_index index.php;
        fastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name;
        include fastcgi_params;
    }
}

=======================================================
3.3) sudo service nginx restart
3.4) if you want to setup virtual block
3.4.1) sudo cp /etc/nginx/sites-available/default /etc/nginx/sites-available/example.com
3.4.2) sudo ln -s /etc/nginx/sites-available/example.com /etc/nginx/sites-enabled/

sample for "/etc/nginx/site-availables/example.com
=======================================================
server {
    listen 8080 default_server;
    listen [::]:8080 default_server;

    #root /var/www/laravel_example_com/public;
    index index.php index.html index.htm;

    server_name server_domain_or_IP;

    location / {
        try_files $uri $uri/ /index.php?$query_string;
    }

    location ~ \.php$ {
        try_files $uri /index.php =404;
        fastcgi_split_path_info ^(.+\.php)(/.+)$;
        fastcgi_pass unix:/var/run/php5-fpm.sock;
        fastcgi_index index.php;
        fastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name;
        include fastcgi_params;
    }
}



======================================================== 

3.4.3) sudo nano /etc/nginx/nginx.conf 
3.4.4) server_names_hash_bucket_size 64; 
3.4.5) sudo service nginx restart 
-------------------------------------------------------------------------------------------------------------------------- 4) Create Swap File (Optional) 4.1) sudo fallocate -l 1G /swapfile 2) sudo mkswap /swapfile 3) sudo swapon /swapfile -------------------------------------------------------------------------------------------------------------------------- 5) Install Composer and Laravel 5.1) cd ~ 5.2) curl -sS https://getcomposer.org/installer | php 5.3) sudo mv composer.phar /usr/local/bin/composer 5.4) sudo composer create-project laravel/laravel /var/www/laravel 5.5) sudo composer create-project laravel/laravel /var/www/laravel 4.2 5.6) sudo chown -R :www-data /var/www/laravel 5.7) sudo chmod -R 775 /var/www/laravel/app/storage 5.8) http://server_domain_or_IP

--------------------------------------------------------------------------------------------------------------------------
4) Install phpmyadmin
4.1) sudo apt-get install phpmyadmin
4.2) che5.ck where is the site
cd /usr/share/nginx/html

4.3) sudo ln  -s /usr/share/phpmyadmin/ /usr/share/nginx/html
it will create a new link name “phpmyadmin” under /user/share/nginx/html
if you want to create custom phpmyadmin link, you can create by the following command
sudo ln  -s /usr/share/phpmyadmin_mycustom_name/ /usr/share/nginx/html
it will create a new link name “phpmyadmin_mycustom_name” under /user/share/nginx/html
And we can call it from browser by “http://ip_address/phpmyadmin; or “http://ip_address/phpmyadmin_mycustom_name;

4.3 ) sudo systemctl restart nginx

—————————————————————————————————————————————-

5) if there is “root /var/www/html” at /etc/nginx/sites-available/default, comment out it
eg ” # root /var/www/html ” and change server_name to
server_name localhost / ip_address;

—————————————————————————————————————————————

6) if “cgi.fix_pathinfo = 0” at /etc/php/7.0/fpm/php.ini, pls change back to original “cgi.fix_pathinfo = 1”
sudo systemctl restart nginx   OR sudo service nginx restart

 

7) If you used the new port for the virtual host, you have to allow that ports to access from globally ( outside )sudo ufw allow 8000/tcp

 

Cheers

 

Laravel Composer Update Issues at Ubuntu

Apache error “Could not reliably determine the server’s fully qualified domain name”

Open a terminal
Open the /etc/apache2/httpd.conf file:
sudo editor /etc/apache2/httpd.conf
By default, it would be blank. Simply add the following line:
ServerName localhost
Save the file and exit
Restart the server
sudo service apache2 restart
=====================================
mbstring is missing while composer updating

– laravel/framework v5.2.9 requires ext-mbstring * -> the requested PHP extension mbstring is missing from your system.

for general php versions
sudo apt-get install php-mbstring

for php 5.*
sudo apt-get install libapache2-mod-php5

for php 7.*
sudo apt-get install php-mbstring php7.0-mbstring php-gettext libapache2-mod-php7.0

Then, restart apache2:
sudo service apache2 restart ( Ubuntu 14.04 )
sudo systemctl restart apache2 ( Ubuntu 16.04 )

Still missing?

sudo phpenmod mcrypt
sudo phpenmod mbstring

Then, restart apache2
sudo service apache2 restart ( Ubuntu 14.04 )
sudo systemctl restart apache2 ( Ubuntu 16.04 )

===================================

If you got problem, while composer updating
“doctrine-dbal missing”

composer require Doctrine/dbal
or
apt-get install php-doctrine-dbal
=====================================

If you got problem
” phpunit/phpunit 4.8.9 requires ext-dom * -> the requested PHP extension dom is missing from your system.”

for general php versions
sudo apt-get install php-xml

if your php version is 5.*
sudo apt-get install php5.6-xml

if your php version is 7.*
sudo apt-get install php7.0-xml