Vtiger is free and open source customer relationship management application. It is written in PHP and uses MySQL to store its data. Vtiger is very popular and is one of the most downloaded CRM applications used by thousands of businesses around the world. Vtiger CRM provides numerous features like contacts management, opportunity management, sales forecasting, email marketing, help desk and case management, customer portal and collaborative features. Vtiger CRM also provides mobile applications for various platforms like Android and iOS. The application also provides knowledge base features.
In this tutorial, we will learn how to install Vtiger CRM on CentOS server. We will also install all the required dependencies like Apache, PHP, and MySQL/MariaDB.
Vtiger CRM's requirements increase as the users of application increases. For optimal performance, you can use a server with 2GB RAM. To follow this tutorial, you will need a server with minimal CentOS 7 installed. All the required dependencies will be installed throughout the tutorial. You will also need root access or sudo access on your server. If you are logged in as non root user, run sudo -i to switch to root user.
Installing Vtiger CRM
Before installing any package it is recommended that you update the packages and repository using the following command.
yum -y update
To install Vtiger CRM, you will need to install a web server, PHP and a database server. In this tutorial, we will be installing Apache web server with PHP 5.6 and MariaDB as the database server.
To install Apache web server run the following command.
yum -y install httpd
To start Apache web server and enable it to start at boot time, run the following command.
systemctl start httpdsystemctl enable httpd
Although Vtiger CRM can be installed on earlier versions of PHP but we will be installing it on a supported version of PHP as support for PHP versions <= 5.5 has been ended. The default YUM repository contains PHP version 5.4 only, hence we will need to use the Webtatic repository to install a version of PHP greater than 5.4. Run the following commands for installing EPEL repository as EPEL repository is required to install Webtatic repository.
yum -y install epel-releaseyum -y updateyum clean all
Now install Webtatic repository using the following commands.
Once done, save the changes and restart Apache web server using the following command.
systemctl restart httpd
Now install MariaDB database server using the following command.
yum -y install mariadb mariadb-server
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 further ask you for removing test databases and anonymous users. Most of the questions are self-explanatory and you should answer yes to all the questions.
Now you will need to create a database with a database user to store Vtiger CRM 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 Vtiger CRM installation.
CREATE DATABASE vtiger_data;
The above query will create a database named vtiger_data. For the database, you can use any name you prefer in the place of vtiger_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. Using root user is not recommended for the databases. To create a new database user, run the following query.
CREATE USER 'vtiger_user'@'localhost' IDENTIFIED BY 'StrongPassword';
The above query will create a user with username vtiger_user. You can use any preferred username instead of vtiger_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 vtiger_data.* TO 'vtiger_user'@'localhost';
Now run the following command to immediately apply the changes on the database privileges.
Exit MySQL prompt by executing exit command.
Once done, you can download the Vtiger CRM using the following command.
cd /var/www/htmlwget wget http://downloads.sourceforge.net/project/vtigercrm/vtiger%20CRM%206.5.0/Core%20Product/vtigercrm6.5.0.tar.gz -O vtigercrm.tar.gz
At the time of writing the tutorial, the latest version of Vtiger CRM is 6.5.0. You can always check for the latest version on Vtiger CRM download page.
Extract the files using the following command.
tar xzf vtigercrm.tar.gz
The above command will extract the files in vtigercrm directory. Move all the files to the web root directory of Apache web server using the following command.
mv vtigercrm/* /var/www/html
Now you will need to disable your SELinux. 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
Now you can go to your favorite browser and browse the following link.
Click the Install ** button to proceed further. Now you will be shown the license agreement. To proceed further you will need to accept the license agreement. Click **I Agree to go further. The installer will now check for the system requirements. If you have followed this tutorial, you should see that all the requirements are met.
Provide the database name which we have created earlier, provide the hostname localhost and the username and password of the database user.
In System Information, choose the currency. In administration user, choose an admin password and provide your name, email, date format, and timezone. The administrator username will be set to admin with your chosen password.
In the next interface, the installer will show you the configuration settings that will be used for installation. If you need to re-configure the setting provided, click on the Back button.
Click Next to proceed further. The installer will now write the database and will install Vtiger CRM. Once done it will ask you to select the industry of your firm. In Next interface you will be asked to choose the modules to enable. Choose the modules according to your need, you can configure the modules later also.
In this tutorial, we have learned how to install Vtiger CRM application on CentOS 7 server. You can now deploy the application to increase the productivity and improve customer relations of your organization.
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...