LAMP for epicollect5

Epicollect5 server runs on Ubuntu 18 LTS & PHP 7.1

• install apache 2

  sudo apt-get update
  sudo apt-get -y install apache2
  
  

• enable mod_rewrite for Apache ()

  sudo a2enmod rewrite
  

• enable headers

  sudo a2enmod headers
  

• restart server

  sudo service apache2 restart
  

• install mysql (5.7+) secure installation

  https://www.digitalocean.com/community/tutorials/how-to-install-mysql-on-ubuntu-18-04

  "On Ubuntu 18.04, only the latest version of MySQL is included in the APT package repository by default. At the time of writing, that’s MySQL 5.7"

  sudo apt install mysql-server
  sudo mysql_secure_installation
  

• set root password for mysql

  ALTER USER 'root'@'localhost' IDENTIFIED BY '{_my_pwd}';
  

• install php 7.1

  sudo apt-get -y install php7.1 libapache2-mod-php7.1
  

• IMP: if it does not work, look here https://www.key2goal.com/article/install-multiple-php-73-72-71-ubuntu-1804-ubuntu-1604

• install php 7 zip extension.

  sudo apt-get install php7.1-zip 
  

• install php ldap extension (if needed).

  sudo apt-get install php-ldap
  

• install GD Library

  sudo apt-get install php7.1-gd
  

• install Imagick Library

  sudo apt-get install imagemagick
  sudo apt-get install php-imagick
  

• install XSendFile for downloading media

  sudo apt-get install libapache2-mod-xsendfile
  

• enable the module in .htaccess and http conf

  /etc/apache2/conf-available# touch xsend.conf
  

• add:

  XSendFile  On
  # XSendFile utilizes contents in your /storage/ directory.
  XSendFilePath   /var/www/html_prod/shared/storage
  
  

• enable it:

  sudo a2enconf xsend
  

• log into mysql and add epicollect user

  CREATE USER 'epicollect_admin'@'localhost' IDENTIFIED BY 'strong_password';
  
  GRANT USAGE ON *.* TO 'epicollect_admin'@'localhost';
  

• create the epicollect5 database in mysql

  CREATE database epicollect5;
  

• grant privileges to the user on the db (see https://goo.gl/qu9SAO)

  GRANT ALL PRIVILEGES on epicollect5.* TO 'epicollect_admin'@'localhost';`
  

• Check users with

  SELECT User, Host, authentication_string FROM mysql.user;
  

• install composer (1.6.2)

  curl -O "https://getcomposer.org/download/1.6.2/composer.phar"
  chmod a+x composer.phar
  sudo mv composer.phar /usr/local/bin/composer
  

• Install missing packages for php 7.1

  sudo apt-get install php7.1-mbstring
  sudo apt-get install phpunit
  sudo apt-get install php-curl
  
  

• this is important, it will give PDO errors otherwise

  sudo apt-get install php-mysql
  

• check php -version, if not 7.1 do:

  sudo rm /etc/alternatives/php; sudo ln -s /usr/bin/php7.1 /etc/alternatives/php;
  
  

• look at Apache 000-default-config in /etc/apache2/sites-available

• set document root and directory

  ServerAdmin webmaster@localhost
  DocumentRoot /var/www/html/public/
  (this is to redirect to public)
  
  <Directory /var/www/>
    Options Indexes FollowSymLinks MultiViews
    AllowOverride All
    Order allow,deny
    allow from all
  </Directory>
  

• Set up redirection of http to https (do it later, add it to apache conf)

  RewriteEngine on
  RewriteCond %{SERVER_NAME} =five.epicollect.net
  RewriteRule ^ https://%{SERVER_NAME}%{REQUEST_URI} [END,QSA,R=permanent]
  

• restart server

  sudo service apache2 restart
  

• Imp: the robots.txt in root (/public) is to avoid Search Engines crawling the site

  User-agent: *
  Disallow: /
  

• Important: in the php.ini disable op_cache for development otherwise it will not update changes**

Laravel for epicollect5

• Install Composer globally https://do.co/2SRRiF5

• Install Deployer https://deployer.org/, version 4.2.1 otherwise some Laravel 5.4 tasks are not defined, see deployphp/deployer#1889

  curl -LO https://deployer.org/releases/v4.2.1/deployer.phar
    mv deployer.phar /usr/local/bin/dep
    chmod +x /usr/local/bin/dep
  

• increase memory_limit in Loaded Configuration File: /etc/php/7.1/cli/php.ini (php --ini) to 1024M

• add a swap file (8GB at least) https://linuxize.com/post/how-to-add-swap-space-on-ubuntu-18-04/

• copy deploy.php into /var/www/html (or any root directory of your choice)

  sudo dep install production
  

• if it fails with out of memory errors, delete all folders and start fresh, increasing composer timeout from 300 secs to 5 minutes.

• if any error, install the missing PHP packages, like:

  sudo apt-get install php7.1-zip
  apt-get install php7.1-curl
  sudo apt-get install php7.1-xml` -> this always
  
  

• restart apache

...to be continued