- \n
- Minimal installation on a virtual machine or physical server of Debian 9 operating system<\/li>\n
- Root account privileges or an account with root privileges via sudo command (local access via console or remote access via SSH)<\/li>\n
- One of server NICs configured with a static IP address<\/li>\n
- A public registered domain name so you perform the installation via web interface and access the application website. In intranets, you can access the app via a local domain or via your server IP address<\/li>\n
- A mail server configured at your premises or access to a public email service, such as Gmail, Outlook, Yahoo!<\/li>\n<\/ul>\n
Pre-Requirements<\/h2>\n
First, log in to your Debian server console and make sure you update the system repositories, kernel and software packages by issuing the following\u00a0commands.<\/p>\n
apt update<\/p>\n
apt upgrade<\/p>\n
Next, configure machine hostname by executing the following command. Make sure you replace the hostname value used in this topic with your own notation.<\/p>\n
hostnamectl set-hostname www.mycrm.org<\/p>\n
Issue the commands below to check if the machine hostname has been correctly configured.<\/p>\n
hostnamectl<\/p>\n
cat \/etc\/hostname<\/p>\n
hostname \u2013s<\/p>\n
hostname \u2013f<\/p>\n
Finally, reboot Debian server in order to apply kernel updates and the hostname changes properly.<\/p>\n
systemctl reboot<\/p>\n
Next, you should install the LAMP software bundle in Debian system. On the first step, install the Apache web server and a PHP processing gateway interpreter alongside with all required PHP modules needed by the application to run properly by running the following command in your server console.<\/p>\n
apt install apache2 libapache2-mod-php7.0 php7.0 php7.0-gd php7.0-opcache php7.0-mbstring php7.0-xml php7.0-json php7.0-zip php7.0-curl php7.0-imap php7.0-soap php7.0-mcrypt php-mailparse<\/p>\n
Next, install an RDBMS database backend. In this guide, we\u2019ll configure the EspoCRM application to use the MariaDB database as backend. Issue the following command to install the MariaDB database and the PHP module needed to access the MySQL database.<\/p>\n
apt install mariadb-server php7.0-mysql mariadb-client<\/p>\n
After Apache, MySQL database and PHP has been installed, open the PHP default configuration file for editing and modify the following PHP variables as described below. Assure that initially, you make a backup of PHP configuration file.<\/p>\n
cp \/etc\/php\/7.0\/apache2\/php.ini{,.backup}<\/p>\n
nano \/etc\/php\/7.0\/apache2\/php.ini<\/p>\n
Search, edit and change the following variables in the\u00a0php.ini<\/strong> configuration file:<\/p>\n
file_uploads = On
Replace the time.zone<\/em><\/strong> variable accordingly to your physical time by consulting the list of time zones provided by PHP docs at the following link http:\/\/php.net\/manual\/en\/timezones.php<\/a><\/p>\n
In order to increase the load speed of your application pages via OPCache plugin available in PHP7, insert the following OPCache code lines at the bottom of the PHP interpreter configuration file, below the [opcache]<\/em><\/strong> statement, as detailed below:<\/p>\n
opcache.enable=1
Close the php.ini<\/em><\/strong> configuration file and check if the variables have been correctly added, something which you can do by issuing the below command.<\/p>\n
grep opcache \/etc\/php\/7.0\/apache2\/php.ini| grep -v “;”<\/p>\n
Next, add the following\u00a0UFW firewall application rule in your system, in order to allow HTTP traffic to pass through firewall, by issuing the following command.<\/p>\n
ufw allow WWW<\/p>\n
or<\/p>\n
ufw allow 80\/tcp<\/p>\n
apt-get install -y iptables-persistent<\/p>\n
iptables -I INPUT -p tcp –destination-port 80 -j ACCEPT<\/p>\n
iptables -I INPUT -p tcp –destination-port 22 -j ACCEPT<\/p>\n
netfilter-persistent save<\/p>\n
systemctl restart netfilter-persistent<\/p>\n
systemctl status netfilter-persistent<\/p>\n
systemctl enable netfilter-persistent.service<\/p>\n
Finally, open a browser and visit your Debian machine IP address or your domain name via HTTP protocol. If you don\u2019t know your machine IP address, execute ifconfig<\/strong> or ip a<\/strong> command\u00a0to get the IP address of your server. If the connection to the web server is established, you should be able to view Apache web server default web page in your browser.<\/p>\n
http:\/\/your_domain.tld<\/strong><\/em><\/p>\n
On the next step, enable Apache rewrite, and deflate SSL modules required by the EspoCRM to properly run, by issuing the below command.<\/p>\n
a2enmod rewrite deflate ssl<\/p>\n
SSL module requires that you also enable default SSL configuration file in order to visit the application via HTTPS protocol. The HTTPS protocol is used for securing the traffic between the server and clients. Execute the following command to enable the Apache SSL site configuration file.<\/p>\n
a2ensite default-ssl.conf<\/p>\n
Afterwards, open Apache default SSL site configuration file with a text editor and insert the following lines of code after DocumentRoot<\/em><\/strong> directive, as shown in the below sample, in order to activate the rules placed in the .htaccess file. The .htaccess file is usually located on top of your domain webroot.<\/p>\n
nano \/etc\/apache2\/sites-enabled\/default-ssl.conf<\/em><\/p>\n
<Directory \/var\/www\/html>
<Directory \/var\/www\/html>
Finally, restart the Apache daemon to apply all rules configured so far and visit your domain via the HTTPS protocol. Because you\u2019re using the automatically Self-Signed certificates pairs issued by Apache at installation, certificate that is untrusted by the browser, an insecure connection error warning should be displayed in the browser.\u00a0 Accept the warning in order to accept the untrusted certificate and continue to be redirected to the Apache default web page.<\/p>\n
systemctl restart apache2<\/p>\n
https:\/\/yourdomain.tld<\/strong><\/em><\/p>\n
![\"SSL](\"https:\/\/afaghhosting.net\/blog\/wp-content\/uploads\/2018\/06\/how-to-install-espocrm-open-source-crm-software-on-debian-9.png\" "\\"\\"")
<\/a><\/p>\nIf you plan to expose your EspoCRM platform for production in the internet, you should consider buying a certificate issued by a trusted Certificate Authority or get a free certificate pair from Let\u2019s Encrypt CA, so that clients can visit the application without errors displaying in their browsers.<\/p>\n
In case the UFW firewall application blocks incoming network connections to HTTPS port, you should add a new rule to allow HTTPS traffic to pass through the firewall by issuing the following command.<\/p>\n
ufw allow HTTPS<\/p>\n
or<\/p>\n
ufw allow 443\/tcp<\/p>\n
For iptables firewall, add the following rule to allow port 443 inbound traffic in the firewall so that you can browse the domain name. Save and restart the iptables service in order to apply the rules after system reboot.<\/p>\n
iptables -I INPUT -p tcp –destination-port 443 -j ACCEPT<\/p>\n
netfilter-persistent save<\/p>\n
systemctl restart netfilter-persistent<\/p>\n
systemctl status netfilter-persistent<\/p>\n
Finally, create a PHP info file in your domain webroot path by executing the following command.<\/p>\n
echo ‘<?php phpinfo(); ?>’| tee \/var\/www\/html\/info.php<\/p>\n
Check PHP settings and the time zone configuration by visiting the PHP info script file from a browser at the following URL, as illustrated in the below image. Scroll down to the\u00a0date<\/strong> setting to check the PHP timezone configuration.<\/p>\n
https:\/\/domain.tld\/info.php<\/strong><\/em><\/p>\n
On the next step, log in to the MySQL server console and secure MariaDB root account by executing the below commands. Type exit<\/em> to leave database console.<\/p>\n
mysql -h localhost<\/p>\n
Welcome to the MariaDB monitor.\u00a0 Commands end with ; or \\g.
Your MariaDB connection id is 2<\/p>
Server version: 10.1.26-MariaDB-0+deb9u1 Debian 9.1<\/p>
Copyright (c) 2000, 2017, Oracle, MariaDB Corporation Ab and others.<\/p>
Type 'help;' or '\\h' for help. Type '\\c' to clear the current input statement.<\/p><\/pre>\n
MariaDB [(none)]> use mysql;<\/p>\n
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A<\/p>
Database changed<\/p><\/pre>\n
MariaDB [mysql]> update user set plugin=” where user=’root’;<\/p>\n
Query OK, 1 row affected (0.00 sec)
Rows matched: 1\u00a0 Changed: 1\u00a0 Warnings: 0<\/p><\/pre>\n
MariaDB [mysql]> flush privileges;<\/p>\n
Query OK, 0 rows affected (0.00 sec)
MariaDB [mysql]> exit<\/p>
Bye<\/p><\/pre>\n
mysql_secure_installation<\/em><\/p>\n
NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MariaDB
\u00a0\u00a0\u00a0\u00a0\u00a0 SERVERS IN PRODUCTION USE!\u00a0 PLEASE READ EACH STEP CAREFULLY!<\/p>
In order to log into MariaDB to secure it, we'll need the current<\/p>
password for the root user.\u00a0 If you've just installed MariaDB, and<\/p>
you haven't set the root password yet, the password will be blank,<\/p>
so you should just press enter here.<\/p>
Enter current password for root (enter for none):<\/p>
OK, successfully used password, moving on...<\/p>
Setting the root password ensures that nobody can log into the MariaDB<\/p>
root user without the proper authorisation.<\/p>
You already have a root password set, so you can safely answer 'n'.<\/p>
Change the root password? [Y\/n] y<\/p>
New password:<\/p>
Re-enter new password:<\/p>
Password updated successfully!<\/p>
Reloading privilege tables..<\/p>
\u00a0... Success!<\/p>
By default, a MariaDB installation has an anonymous user, allowing anyone<\/p>
to log into MariaDB without having to have a user account created for<\/p>
them.\u00a0 This is intended only for testing, and to make the installation<\/p>
go a bit smoother.\u00a0 You should remove them before moving into a<\/p>
production environment.<\/p>
Remove anonymous users? [Y\/n] y<\/p>
\u00a0... Success!<\/p>
Normally, root should only be allowed to connect from 'localhost'.\u00a0 This<\/p>
ensures that someone cannot guess at the root password from the network.<\/p>
Disallow root login remotely? [Y\/n] y<\/p>
\u00a0... Success!<\/p>
By default, MariaDB comes with a database named 'test' that anyone can<\/p>
access.\u00a0 This is also intended only for testing, and should be removed<\/p>
before moving into a production environment.<\/p>
Remove test database and access to it? [Y\/n] y<\/p>
\u00a0- Dropping test database...<\/p>
\u00a0... Success!<\/p>
\u00a0- Removing privileges on test database...<\/p>
\u00a0... Success!<\/p>
Reloading the privilege tables will ensure that all changes made so far<\/p>
will take effect immediately.<\/p>
Reload privilege tables now? [Y\/n] y<\/p>
\u00a0... Success!<\/p>
Cleaning up...<\/p>
All done!\u00a0 If you've completed all of the above steps, your MariaDB<\/p>
installation should now be secure.<\/p>
Thanks for using MariaDB!<\/p><\/pre>\n
mysql -h localhost -u root<\/p>\n
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)<\/pre>\n
mysql -h localhost -u root -p<\/p>\n
Enter password:
Welcome to the MariaDB monitor.\u00a0 Commands end with ; or \\g.<\/p>
Your MariaDB connection id is 15<\/p>
Server version: 10.1.26-MariaDB-0+deb9u1 Debian 9.1<\/p>
Copyright (c) 2000, 2017, Oracle, MariaDB Corporation Ab and others.<\/p>
Type 'help;' or '\\h' for help. Type '\\c' to clear the current input statement.<\/p>
MariaDB [(none)]> exit<\/p>
Bye<\/p><\/pre>\n
Install EspoCRM<\/h2>\n
After the Apache HTTP server, MariaDB daemon and PHP interpreter have been properly configured for installing EspoCRM application in your Debian system. Execute the following command in order to install the command line utilities mentioned in it.<\/p>\n
apt install wget bash-completion zip unzip curl<\/p>\n
wget https:\/\/www.espocrm.com\/downloads\/EspoCRM-5.0.3.zip<\/p>\n
ls<\/p>\n
unzip EspoCRM-5.0.3.zip<\/p>\n
ls<\/p>\n
ls -al EspoCRM-5.0.3<\/p>\n
rm \/var\/www\/html\/index.html<\/p>\n
rm \/var\/www\/html\/info.php<\/p>\n
cp -rf EspoCRM-5.0.3\/* \/var\/www\/html\/<\/p>\n
cp EspoCRM-5.0.3\/.htaccess \/var\/www\/html\/<\/p>\n
Next, execute the below commands in order to grant the Apache www-data<\/em> account with full write permissions to the web root path. Use the\u00a0ls<\/strong> command to list permissions for EspoCRM installed files located in the \/var\/www\/html\/ directory.<\/p>\n
chown -R www-data:www-data \/var\/www\/html\/<\/p>\n
ls \u2013al \/var\/www\/html\/<\/p>\n
mysql \u2013u root -p<\/p>\n
Welcome to the MariaDB monitor.\u00a0 Commands end with ; or \\g.
Your MariaDB connection id is 2<\/p>
Server version: 10.1.26-MariaDB-0+deb9u1 Debian 9.1<\/p>
Copyright (c) 2000, 2017, Oracle, MariaDB Corporation Ab and others.<\/p>
Type 'help;' or '\\h' for help. Type '\\c' to clear the current input statement.<\/p><\/pre>\n
MariaDB [(none)]> create database espocrm_db;<\/p>\n
Query OK, 1 row affected (0.00 sec)<\/pre>\n
MariaDB [(none)]> grant all privileges on espocrm_db.* to ‘crm_user’@’localhost’ identified by ‘password1234’;<\/p>\n
Query OK, 0 rows affected (0.00 sec)<\/pre>\n
MariaDB [(none)]> flush privileges;<\/p>\n
Query OK, 0 rows affected (0.00 sec)
MariaDB [(none)]> exit<\/p>
Bye<\/p><\/pre>\n
https:\/\/yourdomain.tld<\/strong><\/em><\/p>\n
![\"EspoCRM](\"https:\/\/afaghhosting.net\/blog\/wp-content\/uploads\/2018\/06\/how-to-install-espocrm-open-source-crm-software-on-debian-9-1.png\" "\\"\\"")
<\/a><\/p>\nIn the next screen, read the license agreement statements and check “I accept the agreemen<\/em>t” checkbox and hit on Next button to move to the next step.<\/p>\n
![\"Accept](\"https:\/\/afaghhosting.net\/blog\/wp-content\/uploads\/2018\/06\/how-to-install-espocrm-open-source-crm-software-on-debian-9-2.png\" "\\"\\"")
<\/a><\/p>\nIn the next installation screen, setup MySQL database connection settings. Supply MySQL database host address (127.0.0.1 or localhost), the database name, username and the password configured for EspoCRM application. After completing all required database fields, hit on Next button to move to the next installation step. Use the below screenshot as a guide to complete this step.<\/p>\n
![\"Database](\"https:\/\/afaghhosting.net\/blog\/wp-content\/uploads\/2018\/06\/how-to-install-espocrm-open-source-crm-software-on-debian-9-3.png\" "\\"\\"")
<\/a><\/p>\nIn the next screen, EspoCRM installer will check your server environment configurations in order to determine if all recommended MySQL variables and PHP modules and settings are properly configured. If all configurations are passed, hit on Install button to start the EspoCRM installation process.<\/p>\n
![\"Recommended](\"https:\/\/afaghhosting.net\/blog\/wp-content\/uploads\/2018\/06\/how-to-install-espocrm-open-source-crm-software-on-debian-9-4.png\" "\\"\\"")
<\/a><\/p>\nIn the next step, add an administrator account for EspoCRM and set up a strong password for this admin account. When you finish, hit on Next button to continue further with the installation process.<\/p>\n
![\"Set](\"https:\/\/afaghhosting.net\/blog\/wp-content\/uploads\/2018\/06\/how-to-install-espocrm-open-source-crm-software-on-debian-9-5.png\" "\\"\\"")
<\/a><\/p>\nNext, setup EspoCRM system settings by selecting your appropriate Date Format and Time Format. Also, choose your application appropriate Time Zone setting by selecting your nearest Continent\/City from the provided timezone list. Setup the first day of the week, application default currency, thousand and decimal separator marks and the system language. When all the above settings are configured, hit on Next button to continue with the installation process.<\/p>\n
![\"Date](\"https:\/\/afaghhosting.net\/blog\/wp-content\/uploads\/2018\/06\/how-to-install-espocrm-open-source-crm-software-on-debian-9-6.png\" "\\"\\"")
<\/a><\/p>\nOn the next step, configure the EspoCRM outgoing mail settings. Add a name for “From Name” email header and the email contact address of the admin account. This address will be used for sending emails to outside clients. Also, make sure you add the email server address, the port number of the mail server and check Auth checkbox and supply server authentication credentials and the security level, if that\u2019s the case. When you finish completing this step, hit on next button to complete the installation process.<\/p>\n
![\"SMTP](\"https:\/\/afaghhosting.net\/blog\/wp-content\/uploads\/2018\/06\/how-to-install-espocrm-open-source-crm-software-on-debian-9-7.png\" "\\"\\"")
<\/a><\/p>\nAfter the database structure has been imported and all platform settings are written to the application configuration file, the installation process will complete. The installer will display notifying you that the installation has been successfully completed and will display a note about the EspoCRM scheduled\u00a0job you need to add into your server crontab file.<\/p>\n
![\"EspoCRM](\"https:\/\/afaghhosting.net\/blog\/wp-content\/uploads\/2018\/06\/how-to-install-espocrm-open-source-crm-software-on-debian-9-8.png\" "\\"\\"")
<\/a><\/p>\nIn order to access and manage your CRM application, open a browser and navigate to your server IP address or domain name via HTTPS. Use the credentials configured during the installation process in order to log in into EspoCRM backend panel, as shown in the below screenshot.<\/p>\n
https:\/\/yourdomain.tld<\/strong><\/em><\/p>\n
![\"Log](\"https:\/\/afaghhosting.net\/blog\/wp-content\/uploads\/2018\/06\/how-to-install-espocrm-open-source-crm-software-on-debian-9-9.png\" "\\"\\"")
<\/a><\/p>\nThe default EspoCRM dashboard should contain no data so far. A preview on EspoCRM initial dashboard is illustrated in the below screenshot.<\/p>\n
![\"EspoCRM](\"https:\/\/afaghhosting.net\/blog\/wp-content\/uploads\/2018\/06\/how-to-install-espocrm-open-source-crm-software-on-debian-9-10.png\" "\\"\\"")
<\/a><\/p>\nIn order to further configure EspoCRM platform settings, hit on top right icon with three horizontal lines and hit on Administration link from the top-down menu, as shown in the below image.<\/p>\n
![\"Administration](\"https:\/\/afaghhosting.net\/blog\/wp-content\/uploads\/2018\/06\/how-to-install-espocrm-open-source-crm-software-on-debian-9-11.png\" "\\"\\"")
<\/a><\/p>\nIn order to force visitors to securely access EspoCRM backend interface via HTTPS protocol that encrypts the traffic between the server and client browsers, return to your server terminal and edit the .htaccess<\/em> file located in your website document root path, by issuing the below command.<\/p>\n
nano \/var\/www\/html\/.htaccess<\/p>\n
In .htaccess file, search for the\u00a0<IfModule mod_rewrite.c> <\/em><\/strong>line and add the below rules after RewriteEngine On <\/em><\/strong>statement in order to automatically redirect all domain traffic to HTTPS.<\/p>\n
# Redirect to HTTPS
At the top, the file you can change the native PHP server settings, such as increased values for upload_max_filesize<\/em> and post_max_size<\/em>\u00a0 PHP variables, in order to support large file uploads into application storage. Modify these PHP settings with great caution. Make sure that these variables match your server resources and configurations.<\/p>\n
# Modify PHP settings
Next, test the scheduled job before adding it to run into crontab daemon file, by issuing the below command. The crontask job should be executed with Apache HTTP server runtime account privileges.<\/p>\n
sudo -u www-data \/usr\/bin\/php7.0 -f \/var\/www\/html\/cron.php<\/p>\n
Finally, add the following\u00a0crontab job owned by Apache www-data<\/em> account, by issuing the below command.<\/p>\n
crontab -u www-data \u2013e<\/p>\n
\u00a0Crontab file excerpt:<\/p>\n
*\u00a0\u00a0\u00a0 *\u00a0\u00a0\u00a0 *\u00a0\u00a0\u00a0 *\u00a0\u00a0\u00a0 *\u00a0\u00a0\u00a0\u00a0 \/usr\/bin\/php7.0 -f \/var\/www\/html\/cron.php > \/dev\/null 2>&1<\/pre>\n
That\u2019s all! You have successfully installed and configured EspoCRM platform in Debian 9. For other settings concerning EspoCRM platform, visit the documentation page at the following address: \u00a0https:\/\/www.espocrm.com\/documentation\/<\/a><\/p>\n
\nShare this page:<\/b><\/p>\n
\n
![\"\"](\"https:\/\/afaghhosting.net\/blog\/wp-content\/uploads\/2018\/06\/how-to-install-espocrm-open-source-crm-software-on-debian-9-12.png\" "\\"\\"")
<\/a>
\n![\"\"](\"https:\/\/afaghhosting.net\/blog\/wp-content\/uploads\/2018\/06\/how-to-install-espocrm-open-source-crm-software-on-debian-9-13.png\" "\\"\\"")
<\/a>
\n![\"\"](\"https:\/\/afaghhosting.net\/blog\/wp-content\/uploads\/2018\/06\/how-to-install-espocrm-open-source-crm-software-on-debian-9-14.png\" "\\"\\"")
<\/a>
\n![\"\"](\"https:\/\/afaghhosting.net\/blog\/wp-content\/uploads\/2018\/06\/how-to-install-espocrm-open-source-crm-software-on-debian-9-15.png\" "\\"\\"")
<\/a>\n<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"In this guide we\u2019ll show you how to install and configure the latest version of the EspoCRM software on Debian 9 on top of a LAMP stack, in order to create a free online Customer Relationship Management platform for your company. EspoCRM is a flexible and easy-to-use open source customer relationship management (CRM) platform designed […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[36],"tags":[],"class_list":["post-5124","post","type-post","status-publish","format-standard","hentry","category-36"],"_links":{"self":[{"href":"https:\/\/afaghhosting.net\/blog\/wp-json\/wp\/v2\/posts\/5124","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/afaghhosting.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/afaghhosting.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/afaghhosting.net\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/afaghhosting.net\/blog\/wp-json\/wp\/v2\/comments?post=5124"}],"version-history":[{"count":0,"href":"https:\/\/afaghhosting.net\/blog\/wp-json\/wp\/v2\/posts\/5124\/revisions"}],"wp:attachment":[{"href":"https:\/\/afaghhosting.net\/blog\/wp-json\/wp\/v2\/media?parent=5124"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/afaghhosting.net\/blog\/wp-json\/wp\/v2\/categories?post=5124"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/afaghhosting.net\/blog\/wp-json\/wp\/v2\/tags?post=5124"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}