vTiger CRM on Ubuntu 18.04 LTS

vtiger.sh

apache2 -v
mysql --version
php --version
	
  sudo mysql -u root -p

	CREATE DATABASE vtigerdb;
	
	CREATE USER 'vtiger'@'localhost' IDENTIFIED BY 'password';

	GRANT ALL PRIVILEGES ON vtigerdb.* TO 'vtiger'@'localhost' IDENTIFIED BY 'mypassword' WITH GRANT OPTION;
	
	ALTER DATABASE vtigerdb CHARACTER SET utf8 COLLATE utf8_general_ci;

	FLUSH PRIVILEGES;
	exit
  cd Downloads/
  wget https://excellmedia.dl.sourceforge.net/project/vtigercrm/vtiger%20CRM%207.1.0/Core%20Product/vtigercrm7.1.0.tar.gz
  tar -xvzf vtigercrm7.1.0.tar.gz
  cp -r vtigercrm /var/www/html/
  sudo cp -r vtigercrm /var/www/html/
  sudo chown -R www-data:www-data /var/www/html/vtigercrm
  sudo chmod -R 755 /var/www/html/vtigercrm
  sudo nano /etc/apache2/sites-available/vtigercrm.conf

Add the following lines:

<VirtualHost *:80>
     ServerAdmin [email protected]
     ServerName example.com
     DocumentRoot /var/www/html/vtigercrm/

     <Directory /var/www/html/vtigercrm/>
        Options FollowSymlinks
        AllowOverride All
        Require all granted
     </Directory>

     ErrorLog /var/log/apache2/vtigercrm_error.log
     CustomLog /var/log/apache2/vtigercrm_access.log combined
</VirtualHost>

  a2ensite vtigercrm
  sudo a2ensite vtigercrm
  sudo a2dissite 000-default
  sudo a2enmod rewrite
  sudo systemctl restart apache2
  sudo systemctl status apache2
  sudo nano /etc/mysql/my.cnf
  
Add the following part to the bottom:

[mysqld]

sql_mode=ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

sudo service mysql restart


#Video Tutorial:
https://www.youtube.com/watch?v=n2yArYLs-Iw&feature=youtu.be