Customer Relations Management is a vital component to any business with customer support, marketing and sales. In our today’s article we will setup the World’s largest open source CRM software that is sugarCRM. It is a web based customer management tool that facilitates all the business roles by bringing them together under a unified software system that allows customer relations representatives to quickly and efficiently deal with a wide range of demands. One of the best thing about SugarCRM is that its source code of the application is available to any user, developer or customer of the product. It is often used to track customer orders, billing history and to catalog any complaints you have. So, this leads to a faster turnaround for the customer service issues, and it can also result in more accurate resolution of your customer’s issues by centralizing all customer relation services under the one unified system.
- 1) System Update
- 2) LAMP Setup
- 3) Allow Firewall Access
- Installing SugarCRM
- 1) Download sugarCRM
- 2) Extract the package
- SugarCRM Web Installation Setup
- Installation Options
- Database Type
- Database Configurations
- SugarCRM Site Configuration
- Confirm Settings
- Performing Setup
- Login to SugarCRM
- Welcome to SurgarCRM
We are going to setup SugarCRM on Linux CentOS 7.1 operating system with minimal installation package, so first of all we have to complete its basic requirements that include the Basic LAMP stack to be installed on the system where you are going to setup sugarCRM. Let’s follow the next few steps to complete the requirements before starting sugarCRM installation.
1) System Update
Login to your server with super user credentials to upgrade your OS with latest release and update its installed packages and repositories using below command.
[root@localhost ~]# yum update [root@localhost ~]# yum upgrade
2) LAMP Setup
Basic LAMP setup is the major requirement for the installation of sugarCRM where we will use Apache as its web server, MySQL-MariaDB as its database server and PHP modules. Before doing the LAMP installation setup your servers hostname and configure your hosts file with proper FQDN.
[root@localhost ~]# hostnamectl set-hostname sugarcrm [root@localhost ~]# vim /etc/hosts 10.2.3.4 sugarcrm sugarcrm.test.com :wq!
Write the changes and quit file to update your hosts entry. Now we will install the LAMP packages and its other dependent utilities with yum command as shown below.
[root@sugarcrm ~]# yum install php httpd mariadb mariadb-server php-mysqlnd php-opcache php-mbstring php-gd
Once all the above mentioned packages are installed including their dependencies, start the Apache web server and MariaDB services then enable it at boot up auto start.
[root@sugarcrm ~]# service httpd start [root@sugarcrm ~]# service mariadb start [root@sugarcrm ~]# systemctl enable httpd [root@sugarcrm ~]# systemctl enable mariadb
Now set the root password of MariaDB after a connection to it with command below.
[root@sugarcrm ~]#mysql MariaDB [(none)]> SET PASSWORD FOR 'root'@'localhost' = PASSWORD('root123'); Query OK, 0 rows affected (0.00 sec)
Once you have set the root password to the root user of MariaDB, now we will create a new database with its separate user and password that we will use later on during the installation process of sugarCRM. Let’s use the following commands to create the database and assign the privileges to the new user.
MariaDB [(none)]> CREATE DATABASE sugarcrm; Query OK, 1 row affected (0.00 sec) MariaDB [(none)]> CREATE USER 'crm_user'@'localhost' IDENTIFIED BY 'crm123'; Query OK, 0 rows affected (0.00 sec) MariaDB [(none)]> GRANT ALL PRIVILEGES ON sugarcrm.* TO 'crm_user'@'localhost'; Query OK, 0 rows affected (0.00 sec) MariaDB [(none)]> FLUSH PRIVILEGES; Query OK, 0 rows affected (0.00 sec) MariaDB [(none)]> quit; Bye
Now tune the PHP settings to allow files of atleast 6MB to be uploaded in the PHP configuration file. To do that open file /etc/php.ini and adjust the settings by searching the following parameter and update accordingly.
[root@sugarcrm ~]# vim /etc/php.ini upload_max_filesize = 25M date.timezone = Europe/London
After you update configuration, you have to restart httpd services to implement the saved changes.
[root@sugarcrm ~]#systemctl restart httpd
3) Allow Firewall Access
We have to allow HTTP on port 80 for public zone and make sure that SELinux is turned off or set it to Permissive mode. So let’s do the firewall and selinux changes by updating its conf file.
[root@sugarcrm ~]# vim /etc/selinux/config Change from enforcing to permissive as below. #SELINUX=enforcing SELINUX=permissive
Run the below command to update selinux state from enforcing to permissive mode.
[root@sugarcrm ~]# setenforce 0 [root@sugarcrm ~]# sestatus SELinux status: enabled SELinuxfs mount: /sys/fs/selinux SELinux root directory: /etc/selinux Loaded policy name: targeted Current mode: permissive Mode from config file: permissive Policy MLS status: enabled Policy deny_unknown status: allowed Max kernel policy version: 28
To allow access for http service in firewall you can use the below command to permit permanent access.
[root@sugarcrm ~]# firewall-cmd --zone=public --add-service=http --permanent Success [root@sugarcrm ~]# service firewalld restart Redirecting to /bin/systemctl restart firewalld.service [root@sugarcrm ~]# service firewalld status
We are ready to setup sugarCRM as had completed its all prerequisites in previous steps. Now let’s follow the next few step to install SugarCRM on CentOS 7.1 as described in below steps.
1) Download sugarCRM
You can download the latest community edition of sugarCRM from their official website that is http://www.sugarcrm.com/download and the upload it on the server.
If you have wget installed on your system then simply copy the link and get it on your server as.
[root@sugarcrm ~]# wget http://downloads.sourceforge.net/project/sugarcrm/1%20-%20SugarCRM%206.5.X/SugarCommunityEdition-6.5.X/SugarCE-6.5.22.zip
2) Extract the package
Now we will extract the downloaded package into the document root directory of our web server using the below unzip command.
[root@sugarcrm ~]# ls SugarCE-6.5.22.zip [root@sugarcrm ~]# unzip SugarCE-6.5.22.zip -d /var/www/html/
We will rename the extracted directory to something simpler and and this directory needs to be owned by the Apache user.
[root@sugarcrm ~]# cd /var/www/html/ [root@sugarcrm html]# mv SugarCE-Full-6.5.22 SugarCRM [root@sugarcrm html]# chown -R apache:apache SugarCRM/
SugarCRM Web Installation Setup
In this section we are going to start the installation process of SugarCRM using our web server. Open the below URL that indicates the SugarCRM package placed in web server’s document root directory with you localhost IP address.
Welcome to the SugarCRM Community Setup Wizard.
Now we are ready for to install it on our Linux host, proceeding to next step make sure that you have read all the instructions mentioned in this section about the basic system requirements configurations.
Read and Accept the License agreement then Click to NEXT button.
There are two available options one with Typical Installation and the second with Custom Installation. If you are a new to CRM then simply choose the First option and click to Next button.
If you multiple database extensions installed on your system, then will be displayed here and you have to choose the one where you want to install the sugarCRM instance.
In this section we have to choose the How to Install and Setup SugarCRM Community on CentOS 7.1 database configurations that contains the database user name and hostname that we created during LAMP setup.
Once you are done with database configurations then in the Next step you have to verify the Database credentials and click to Next.
SugarCRM Site Configuration
Here we need to set the administrator username and password that will be used login to the instance after the installation of SugarCRM.
Here is the complete summary of your configuration settings that you configured in previous steps.
Once you have confirmed all settings then click to the INSTALL button at the bottom of this page else reconfigure the missing parameters if found in the configuration settings.
The installation process will perform the tasks to create the configuration file, applications data and users setup as shown in the Picture.
Login to SugarCRM
Put your admin user credentials to login to your SugraCRM community edition and start using your best customer relations management portal.
Welcome to SurgarCRM
SugarCRM is ready to Localize, so let’s pecify your time zone and how you would like dates, currencies and names to appear in Sugar with addition to information about yourself. The information you provide about yourself will be visible to other Sugar users. After all settings have been done click on the FINISH button as shown in the below image.
Here is the dashboard of sugarCRM we had recently setup on Linux CentOS 7.1 and is ready to use for managing more customers, with more sale and more lead.
SugarCRM CE web interface is very intuitive with many features out-of-the-box. With an integrated customer relations management software suite, a company can simplify the customer relations management tasks their employees must engage in. This leads to more efficient uses of company resources, which lowers overhead.
Tags: centos 7, Community, install, Setup, SugarCRM