vTiger CRM on Ubuntu

#https://www.howtoforge.com/how-to-install-vtiger-crm-on-ubuntu-1804/#install-vtiger-crm
#https://www.youtube.com/watch?v=5J5-WkqAo9g
#Features
#Supports role-based access control.
#Provides Outlook, Thunderbird, Firefox, and Gmail plugins.
#Automated support using a customer portal and support tickets.
#Workflows, tasks, and project management.
#Allow us to import and export data via CSV files.
#provides customizable user dashboards.
#In this tutorial, we will learn how to install vTiger CRM on Ubuntu 18.04 server.

#Requirements
A server running Ubuntu 18.04.
A static IP address 192.168.0.103 is setup to your server.
A root password is setup to your server.
#Getting Started
#Before starting, you will need to update your system with the latest version. You can do this by running the following command:

app-get update -y
app-get upgrade -y
#Once your server is updated, restart your server to apply the changes.

Install LAMP Server
#VTiger CRM runs on the web server, written in PHP and uses MariaDB to store their data. So, you will need to install Apache, MariaDB, PHP and other PHP modules to your server. You can install all of them by just running the following command:


 
apt-get install apache2 mariadb-server libapache2-mod-php7.2 php7.2 php7.2-cli php7.2-mysql php7.2-common php7.2-zip php7.2-mbstring php7.2-xmlrpc php7.2-curl php7.2-soap php7.2-gd php7.2-xml php7.2-intl php7.2-ldap php7.2-imap unzip wget -y
#Once all the packages are installed, open php.ini file and make some changes:

nano /etc/php/7.2/apache2/php.ini
#Make the following changes:

file_uploads = On
allow_url_fopen = On
memory_limit = 256M
upload_max_filesize = 30M
post_max_size = 40M
max_execution_time = 60
max_input_vars = 1500
#Save and close the file. Then, start Apache and MariaDB service and enable them to start on boot time with the following command:

systemctl start apache2
systemctl start mariadb
systemctl enable apache2
systemctl enable mariadb
#Configure Database
#By default, MariaDB is not secured. So, you will need to secure it. You can do this by running the mysql_secure_installation script:


mysql_secure_installation
#This script will change your current root password, remove anonymous users, disallow root login remotely as shown below:

    Enter current password for root (enter for none):
    Set root password? [Y/n]: N
    Remove anonymous users? [Y/n]: Y
    Disallow root login remotely? [Y/n]: Y
    Remove test database and access to it? [Y/n]:  Y
    Reload privilege tables now? [Y/n]:  Y
#Once the MariaDB is secured, log in to MariaDB shell with the following command:

mysql -u root -p
#Enter your root password when prompt. Then, create a database and user for vTiger using the following command:

MariaDB [(none)]> CREATE DATABASE vtigerdb;
MariaDB [(none)]> CREATE USER 'vtiger'@'localhost' IDENTIFIED BY 'password';
Next, grant all the privileges to vTiger database with the following command:

MariaDB [(none)]> GRANT ALL PRIVILEGES ON vtigerdb.* TO 'vtiger'@'localhost' IDENTIFIED BY 'mypassword' WITH GRANT OPTION;
#Replace the word mypqssword with your own secure password. Next, alter the database with the following command:


MariaDB [(none)]> ALTER DATABASE vtigerdb CHARACTER SET utf8 COLLATE utf8_general_ci;
#Next, flush the privileges and exit from the MariaDB shell with the following command:

MariaDB [(none)]> FLUSH PRIVILEGES;
MariaDB [(none)]> exit
Install vTiger CRM
#First, you will need to download the latest version of vTiger CRM from their official website. You can download it with the following command:

wget https://excellmedia.dl.sourceforge.net/project/vtigercrm/vtiger%20CRM%207.1.0/Core%20Product/vtigercrm7.1.0.tar.gz
#Once the download has been completed, extract the downloaded file with the following command:

tar -xvzf vtiger7.1.0.tar.gz
#Next, copy the extracted directory to the Apache web root and give proper permissions:

cp -r vtiger /var/www/html/
chown -R www-data:www-data /var/www/html/vtigercrm
chmod -R 755 /var/www/html/vtigercrm
#Once you have done, you can proceed to the next step.

#Configure Apache for vTiger CRM
#Next, you will need to create an apache virtual host file for vTiger CRM. You can create it with the following command:

nano /etc/apache2/sites-available/vtiger.conf
#Add the following lines:

<VirtualHost *:80>
     ServerAdmin admin@example.com
     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/vtiger_error.log
     CustomLog /var/log/apache2/vtigercrm_access.log combined
</VirtualHost>
#Replace the domain name exampl.com with your own domain name. Save and close the file. Then, disable the Apache default virtual host file and enable vTiger virtual host file with the following command:

a2ensite vtiger
a2dissite 000-default
#Next, enable Apache rewrite module and restart Apache service with the following command:

a2enmod rewrite
systemctl restart apache2
#Next, check the status of Apache service with the following command:



systemctl status apache2
#You should see the following output:

? apache2.service - The Apache HTTP Server
   Loaded: loaded (/lib/systemd/system/apache2.service; enabled; vendor preset: enabled)
  Drop-In: /lib/systemd/system/apache2.service.d
           ??apache2-systemd.conf
   Active: active (running) since Wed 2019-02-06 16:23:20 UTC; 20min ago
  Process: 2929 ExecStop=/usr/sbin/apachectl stop (code=exited, status=0/SUCCESS)
  Process: 2938 ExecStart=/usr/sbin/apachectl start (code=exited, status=0/SUCCESS)
 Main PID: 2952 (apache2)
    Tasks: 11 (limit: 1113)
   CGroup: /system.slice/apache2.service
           ??2952 /usr/sbin/apache2 -k start
           ??2973 /usr/sbin/apache2 -k start
           ??2975 /usr/sbin/apache2 -k start
           ??2977 /usr/sbin/apache2 -k start
           ??2979 /usr/sbin/apache2 -k start
           ??2982 /usr/sbin/apache2 -k start
           ??2985 /usr/sbin/apache2 -k start
           ??2986 /usr/sbin/apache2 -k start
           ??2987 /usr/sbin/apache2 -k start
           ??3156 /usr/sbin/apache2 -k start
           ??3158 /usr/sbin/apache2 -k start

Feb 06 16:23:19 ubuntu1804 systemd[1]: Starting The Apache HTTP Server...
Feb 06 16:23:20 ubuntu1804 apachectl[2938]: AH00558: apache2: Could not reliably determine the server's fully qualified domain name, using 192.
Feb 06 16:23:20 ubuntu1804 systemd[1]: Started The Apache HTTP Server.

sudo mysql -u root -p
CREATE DATABASE masum DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
GRANT ALL ON masum.* TO 'umasum'@'localhost' IDENTIFIED BY 'Da@y=001';
FLUSH PRIVILEGES;
EXIT;