How To Install Shopware on CentOS 7 – Step by Step

Install Shopware on CentOS 7

Shopware is a free and open source e-commerce application written in PHP. It uses MySQL as the database server to store the data. Shopware is very easy to use and require no coding knowledge to work. It is secure and responsive. The application provides the interface for elements to drag and drop, it also supports design grids. It contains story telling, slide shows, and quick views. In this tutorial we will learn how to Install Shopware on CentOS 7.

This article assumes you have at least basic knowledge of Linux, know how to use the shell, and most importantly, you host your site on your own VPS. The installation is quite simple and assumes you are running in the root accge of Linount, if not you may need to add ‘sudo’ to the commands to get root privileges. I will show you through the step by step installation Shopware on a CentOS 7 server.

Install Shopware on CentOS 7

Step 1. First let’s start by ensuring your system is up-to-date.

yum clean all
yum -y update

Step 2. Install LAMP server.

A CentOS 7 LAMP stack server is required. If you do not have LAMP installed, you can follow our guide here. Also install required PHP modules:

yum -y install php-gd php-imap php-ldap php-odbc php-pear php-xml php-xmlrpc php-mbstring php-mcrypt php-mssql php-snmp php-soap php-tidy curl curl-devel

Step 3. Installing Shopware on CentOS.

Go to the root directory of your system and download the latest stable version of Shopware:

wget https://codeload.github.com/shopware/shopware/zip/5.5
unzip v5.5.zip -d /var/www/html
cd /var/www/html/shopware-5.5 cp -a * ..

We will need to change some folders permissions:

chown -R www-data:www-data /var/www/html/

Step 4. Configuring MariaDB for Shopware.

By default, MariaDB is not hardened. You can secure MariaDB using the mysql_secure_installation script. You should read and below each steps carefully which will set root password, remove anonymous users, disallow remote root login, and remove the test database and access to secure MariaDB.

mysql_secure_installation

Configure it like this:

- Set root password? [Y/n] y
- 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

Next we will need to log in to the MariaDB console and create a database for the Shopware. Run the following command:

mysql -u root -p

This will prompt you for a password, so enter your MariaDB root password and hit Enter. Once you are logged in to your database server you need to create a database for Shopware installation:

CREATE DATABASE shopware;
GRANT ALL PRIVILEGES ON shopware.* TO 'shopware'@'localhost' IDENTIFIED BY 'strong_password';
FLUSH PRIVILEGES;
\q

Step 5. Configuring Apache for Shopware.

We will create Apache virtual host for your Shopware website. First create ‘/etc/httpd/conf.d/vhosts.conf’ file with using a text editor of your choice:

nano /etc/httpd/conf.d/vhosts.conf
IncludeOptional vhosts.d/*.conf

Next, create the virtual host:

mkdir /etc/httpd/vhosts.d/
nano /etc/httpd/vhosts.d/yourdomain.com.conf

Add the following lines:

<VirtualHost YOUR_SERVER_IP:80>
ServerAdmin [email protected]
DocumentRoot /var/www/html
ServerName yourdomain.com
ServerAlias www.yourdomain.com
ErrorLog "/var/log/httpd/yourdomain.com-error_log"
CustomLog "/var/log/httpd/yourdomain.com-access_log" combined

<Directory "/var/www/html/">
DirectoryIndex index.html index.php
Options FollowSymLinks
AllowOverride All
Require all granted
</Directory>
</VirtualHost>

Save and close the file. Restart the Apache service for the changes to take effects:

systemctl restart httpd.service

Step 6. Accessing Shopware e-commerce.

Shopware will be available on HTTP port 80 by default. Open your favorite browser and navigate to http://yourdomain.com or http://server-ip and complete the required the steps to finish the installation. If you are using a firewall, please open port 80 to enable access to the control panel.

Congratulation’s! You have successfully installed Shopware. Thanks for using this tutorial for installing Shopware community edition on CentOS 7 systems. For additional help or useful information, we recommend you to check the official Shopware website.

How To Install OpenCart v3.0.3.2 on Ubuntu 18.04 LTS

Install OpenCart on Ubuntu 18

OpenCart is a free open source ecommerce platform for online merchants. OpenCart provides a professional and reliable foundation from which to build a successful online store. In this tutorial we will learn you how to install OpenCart on Ubuntu 18.04 LTS.

This article assumes you have at least basic knowledge of Linux, know how to use the shell, and most importantly, you host your site on your own VPS. The installation is quite simple and assumes you are running in the root account, if not you may need to add ‘sudo’ to the commands to get root privileges. I will show you through the step by step installation OpenCart on a Ubuntu 18.04 (Bionic Beaver) server.

Install OpenCart on Ubuntu 18.04 LTS

Step 1. First make sure that all your system packages are up-to-date

sudo apt update
sudo apt upgrade

Step 2. Install LAMP (Linux, Apache, MariaDB and PHP) server.

A Ubuntu 18.04 LAMP server is required. If you do not have LAMP installed, you can follow our guide here. Also install all required PHP modules:

apt-get install php7.1-cli php7.1-mbstring php7.1-gd php7.1-opcache php7.1-mysql php7.1-json php7.1-mcrypt php7.1-xml php7.1-curl

Step 3. Download OpenCart

First thing to do is to go to OpenCart’s download page and download the latest stable version of OpenCart:

sudo mkdir -p /var/www/html/example.com
cd /tmp
wget https://github.com/opencart/opencart/releases/download/3.0.3.1/opencart-3.0.3.1.zip
unzip opencart-*.zip
sudo mv /tmp/upload/* /var/www/html/example.com/

Next, copy the configurations files:

sudo cp /var/www/html/example.com/{config-dist.php,config.php}
sudo cp /var/www/html/example.com/admin/{config-dist.php,config.php}

We will need to change some folders permissions:

sudo chown -R www-data: /var/www/html

Step 4. Configuring MariaDB for OpenCart.

By default, MariaDB is not hardened. You can secure MariaDB using the mysql_secure_installation script. You should read and below each steps carefully which will set root password, remove anonymous users, disallow remote root login, and remove the test database and access to secure MariaDB.

mysql_secure_installation

Configure it like this:

- Set root password? [Y/n] y
- 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

Next we will need to log in to the MariaDB console and create a database for the OpenCart. Run the following command:

mysql -u root -p

This will prompt you for a password, so enter your MariaDB root password and hit Enter. Once you are logged in to your database server you need to create a database for OpenCart installation:

MariaDB [(none)]> CREATE DATABASE opencart;
MariaDB [(none)]> GRANT ALL PRIVILEGES ON opencart.* TO 'opencartuser'@'localhost' IDENTIFIED BY 'opencartuser_passwd';
MariaDB [(none)]> FLUSH PRIVILEGES;
MariaDB [(none)]> \q

Step 5. Configuring Apache web server for OpenCart.

Create a new virtual host directive in Apache. For example, create a new Apache configuration file named ‘opencart.conf’ on your virtual server:
[/php]
touch /etc/apache2/sites-available/opencart.conf
ln -s /etc/apache2/sites-available/opencart.conf /etc/apache2/sites-enabled/opencart.conf
nano /etc/apache2/sites-available/opencart.conf
[/php]

Add the following lines:

<VirtualHost *:80>
ServerAdmin [email protected]
DocumentRoot /var/www/html/example.com
ServerName your-domain.com
ServerAlias www.your-domain.com
<Directory /var/www/html/example.com/>
Options FollowSymLinks
AllowOverride All
</Directory>
ErrorLog /var/log/apache2/your-domain.com-error_log
CustomLog /var/log/apache2/your-domain.com-access_log common

Save and close the file. Restart the apache service for the changes to take effects:

sudo a2ensite magento.conf
sudo a2enmod rewrite
sudo systemctl restart apache2

Step 6. Accessing OpenCart.

OpenCart will be available on HTTP port 80 by default. Open your favorite browser and navigate to http://your-domain.com/ or http://server-ip and complete the required the steps to finish the installation. If you are using a firewall, please open port 80 to enable access to the control panel.

Congratulation’s! You have successfully installed OpenCart. Thanks for using this tutorial for installing OpenCart e-commerce on Ubuntu 18.04 systems. For additional help or useful information, we recommend you to check the official OpenCart website.

How To Install TYPO3 9 LTS(Version: 9.5.5)on Ubuntu 18.04 LTS

Install TYPO3 on Ubuntu 18

TYPO3 is an enterprise open source content management system based on PHP. It’s intended for ease of use to allow owners and enterprises to create powerful and dynamic content websites. If you’re looking for a functional, higher performance content management system to manage your websites or blogs and 100% free, then you’ll find TYPO3 to be helpful.

This article assumes you have at least basic knowledge of Linux, know how to use the shell, and most importantly, you host your site on your own VPS. The installation is quite simple and assumes you are running in the root account, if not you may need to add ‘sudo’ to the commands to get root privileges. I will show you through the step by step installation LimeSurvey on an Ubuntu 18.04 (Bionic Beaver) server.

Install TYPO3 on Ubuntu 18.04 LTS

Step 1. First, make sure that all your system packages are up-to-date

sudo apt update
sudo apt upgrade

Step 2. Install LAMP (Linux, Apache, MariaDB and PHP) server.

An Ubuntu 18.04 LAMP server is required. If you do not have a LAMP installed, you can follow our guide here. Also install all required PHP modules:

sudo apt-get install software-properties-common
sudo add-apt-repository ppa:ondrej/php

Next, run the commands below to install PHP 7.2 and related modules:

sudo apt install php7.2 libapache2-mod-php7.2 php7.2-common php7.2-gmp php7.2-curl php7.2-intl php7.2-mbstring php7.2-xmlrpc php7.2-mysql php7.2-gd php7.2-xml php7.2-cli php7.2-zip

Step 3. Download TYPO3 latest version

Download TYPO3 latest release you may want to use Github repository:

Install Composer, Curl and other dependencies:

sudo apt install curl git
curl -sS https://getcomposer.org/installer | sudo php -- --install-dir=/usr/local/bin --filename=composer

Next, Download TYPO3 latest release you may want to use Github repository:

cd /var/www/html
sudo composer create-project typo3/cms-base-distribution typo3 ^9
sudo touch /var/www/html/typo3/public/FIRST_INSTALL

We will need to change some folders permissions:

sudo chown -R www-data:www-data /var/www/html/typo3/
sudo chmod -R 755 /var/www/html/typo3/

Step 4. Configuring MariaDB for TYPO3.

By default, MariaDB is not hardened. You can secure MariaDB using the mysql_secure_installation script. you should read and below each step carefully which will set the root password, remove anonymous users, disallow remote root login, and remove the test database and access to secure MariaDB:

mysql_secure_installation

Configure it like this:

- Set root password? [Y/n] y
- 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

Next we will need to log in to the MariaDB console and create a database for the TYPO3. Run the following command:

mysql -u root -p

This will prompt you for a password, so enter your MariaDB root password and hit Enter. Once you are logged in to your database server, you need to create a database for TYPO3 installation:

CREATE DATABASE typo3;
CREATE USER 'typo3user'@'localhost' IDENTIFIED BY 'new_password_here';
GRANT ALL ON typo3.* TO 'typo3user'@'localhost' IDENTIFIED BY 'user_password_here' WITH GRANT OPTION;
FLUSH PRIVILEGES;
EXIT;

Step 5. Configuring Apache for TYPO3.

Create a new virtual host directive in Apache. For example, create a new Apache configuration file named ‘typo.conf’ on your virtual server:

touch /etc/apache2/sites-available/typo.conf
ln -s /etc/apache2/sites-available/typo.conf /etc/apache2/sites-enabled/typo.conf
nano /etc/apache2/sites-available/typo.conf

Add the following lines:

<VirtualHost *:80>
ServerAdmin [email protected]
DocumentRoot /var/www/html/typo3/public
ServerName your-domain.com
ServerAlias www.your-domain.com
<Directory /var/www/html/typo3/public/>
Options FollowSymLinks
AllowOverride All
Order allow,deny
allow from all
</Directory>
ErrorLog /var/log/apache2/your-domain.com-error_log
CustomLog /var/log/apache2/your-domain.com-access_log common
</VirtualHost>

Now, we can restart Apache web server so that the changes take place:

sudo a2ensite typo3.conf
sudo a2enmod rewrite
systemctl restart apache2.service

Next, we have to make some PHP settings. For this we go into the php.ini and adjust a few settings:

nano /etc/php/7.2/apache2/php.ini

Then make the change the following lines below in the file and save:

file_uploads = On
allow_url_fopen = On
short_open_tag = On
memory_limit = 256M
upload_max_filesize = 100M
max_execution_time = 360
max_input_vars = 1500
date.timezone = America/Chicago

Step 6. Accessing TYPO3 CMS.

TYPO3 will be available on HTTP port 80 by default. Open your favorite browser and navigate to http://yourdomain.com/ or http://server-ip/ and complete the required the steps to finish the installation. If you are using a firewall, please open port 80 to enable access to the control panel.

Congratulation’s! You have successfully installed TYPO3. Thanks for using this tutorial for installing TYPO3 on Ubuntu 18.04 LTS (Bionic Beaver) system. For additional help or useful information, we recommend you to check the official TYPO3 web site.

How To Install Elgg3.0.2 on Ubuntu 18.04 LTS

Install Elgg on Ubuntu 18

In this tutorial we will show you how to install Elgg on Ubuntu 18.04 LTS. For those of you who didn’t know, Elgg is an open source social networking engine that allows the creation of social environments such as campus social networks and internal collaborative platforms for organizations. Elgg offers a number of social networking features including microblogging, messaging, file-sharing and groups.

This article assumes you have at least basic knowledge of Linux, know how to use the shell, and most importantly, you host your site on your own VPS. The installation is quite simple and assumes you are running in the root account, if not you may need to add ‘sudo’ to the commands to get root privileges. I will show you through the step by step installation Elgg Social Networking Platform on an Ubuntu 18.04 Bionic Beaver server.

Install Elgg on Ubuntu 18.04 LTS

Step 1. First, make sure that all your system packages are up-to-date

sudo apt update
sudo apt upgrade

Step 2. Install LAMP (Linux, Apache, MariaDB and PHP) server.

A Ubuntu 18.04 LAMP server is required. If you do not have LAMP installed, you can follow our guide here. Also install all required PHP modules:

apt-get install php7.1-cli php7.1-mbstring php7.1-gd php7.1-opcache php7.1-mysql php7.1-json php7.1-mcrypt php7.1-xml php7.1-curl

Step 3. Download latest stable Elgg version

First thing to do is to go to Elgg’s download page and download the latest stable version of Elgg, At the moment of writing this article it is version 2.3.10:

wget https://elgg.org/about/getelgg?forward=elgg-2.3.10.zip

Unpack the Elgg archive to the document root directory on your server:

unzip elgg-2.3.10.zip
mv /elgg-2.3.10/ /var/www/html/elgg/

We will need to change some folders permissions:

chown -R www-data:www-data /var/www/html/elgg/
chmod -R 755 /var/www/html/elgg/

Step 4. Configuring MariaDB for Elgg.

By default, MariaDB is not hardened. You can secure MariaDB using the mysql_secure_installation script. you should read and below each steps carefully which will set root password, remove anonymous users, disallow remote root login, and remove the test database and access to secure MariaDB:

mysql_secure_installation

Configure it like this:

- Set root password? [Y/n] y
- 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

Next we will need to log in to the MariaDB console and create a database for the Elgg. Run the following command:

mysql -u root -p

This will prompt you for a password, so enter your MariaDB root password and hit Enter. Once you are logged in to your database server you need to create a database for Elgg installation:

create database elggdb;
GRANT ALL PRIVILEGES ON elggdb.* TO 'elgguser'@'localhost' IDENTIFIED BY 'Y0UR-PASSW0RD';
flush privileges;
quit

Step 5. Configuring Apache web server for Elgg.

Create a new virtual host directive in Apache. For example, create a new Apache configuration file named ‘elgg.conf’ on your virtual server:

touch /etc/apache2/sites-available/elgg.conf
ln -s /etc/apache2/sites-available/elgg.conf /etc/apache2/sites-enabled/elgg.conf
nano /etc/apache2/sites-available/elgg.conf

Add the following lines:

<VirtualHost *:80>
ServerAdmin [email protected]
DocumentRoot /var/www/html/elgg/
ServerName your-domain.com
ServerAlias www.your-domain.com
<Directory /var/www/html/elgg/>
Options FollowSymLinks
AllowOverride All
</Directory>
ErrorLog /var/log/apache2/your-domain.com-error_log
CustomLog /var/log/apache2/your-domain.com-access_log common

Save and close the file. Restart the apache service for the changes to take effects:

sudo a2ensite elgg.conf
sudo a2enmod rewrite
sudo systemctl restart apache2

Step 6. Accessing Elgg.

Elgg Social Networking Platform will be available on HTTP port 80 by default. Open your favorite browser and navigate to http://yourdomain.com/install.php or http://server-ip/install.php and complete the required the steps to finish the installation. If you are using a firewall, please open port 80 to enable access to the control panel.
how-to-isntall-elgg

Congratulation’s! You have successfully installed Elgg. Thanks for using this tutorial for installing Elgg Social Networking Platform in Ubuntu 18.04 LTS system. For additional help or useful information, we recommend you to check the official Elgg web site.

How To Install LimeSurveyCE(V3.17.1) on Ubuntu 18.04 LTS

Install LimeSurvey on Ubuntu 18

LimeSurvey (formerly PHPSurveyor) is an open source online survey application. It has been widely used by many big industries to create the survey tasks. It has many powerful features like creating dynamic fields for survey. Supports multilingual, defines userroles, user groups and the more it has been integrated into various CMS. The limesurvey team provides the commercial for those who are seeking. As well as community support for its users.

This article assumes you have at least basic knowledge of Linux, know how to use the shell, and most importantly, you host your site on your own VPS. The installation is quite simple and assumes you are running in the root account, if not you may need to add ‘sudo’ to the commands to get root privileges. I will show you through the step by step installation LimeSurvey on an Ubuntu 18.04 (Bionic Beaver) server.

Install LimeSurvey on Ubuntu 18.04 LTS

Step 1. First, make sure that all your system packages are up-to-date

sudo apt update
sudo apt upgrade

Step 2. Install LAMP (Linux, Apache, MariaDB and PHP) server.

A Ubuntu 18.04 LAMP server is required. If you do not have LAMP installed, you can follow our guide here. Also install all required PHP modules:

apt-get install php7.1-cli php7.1-mbstring php7.1-gd php7.1-opcache php7.1-mysql php7.1-json php7.1-mcrypt php7.1-xml php7.1-curl

Step 3. Download the latest LimeSurvey version

Download the latest stable version of LimeSurvey, At the moment of writing this article it is version 3.15.6:

wget https://www.limesurvey.org/stable-release?download=2519:limesurvey3156%20190108zip
unzip "stable-release?download=2519:limesurvey3156 20190108zip"
mv limesurvey/ /var/www/html/limesurvey/

We will need to change some folders permissions:

chown www-data:www-data -R /var/www/html/limesurvey
chmod -R 755 /var/www/html/limesurvey/

Step 4. Configuring MariaDB.

By default, MariaDB is not hardened. You can secure MariaDB using the mysql_secure_installation script. You should read and below each steps carefully which will set root password, remove anonymous users, disallow remote root login, and remove the test database and access to secure MariaDB.

mysql_secure_installation

Configure it like this:

- Set root password? [Y/n] y
- 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

Next we will need to log in to the MariaDB console and create a database for the LimeSurvey. Run the following command:

mysql -u root -p

This will prompt you for a password, so enter your MariaDB root password and hit Enter. Once you are logged in to your database server you need to create a database for LimeSurvey installation:

CREATE DATABASE limesurvey;
GRANT ALL PRIVILEGES ON limesurvey.* TO 'limeuser'@'localhost' IDENTIFIED BY 'your-password';
FLUSH PRIVILEGES;
\q

Step 5. Configuring Apache web server for LimeSurvey.

Create a new virtual host directive in Apache. For example, create a new Apache configuration file named ‘limesurvey.conf’ on your virtual server:

touch /etc/apache2/sites-available/limesurvey.conf
ln -s /etc/apache2/sites-available/limesurvey.conf /etc/apache2/sites-enabled/limesurvey.conf
nano /etc/apache2/sites-available/limesurvey.conf

Add the following lines:

<VirtualHost *:80>
ServerAdmin [email protected]
DocumentRoot /var/www/html/limesurvey/
ServerName your-domain.com
ServerAlias www.your-domain.com
<Directory /var/www/html/limesurvey/>
Options FollowSymLinks
AllowOverride All
</Directory>
ErrorLog /var/log/apache2/your-domain.com-error_log
CustomLog /var/log/apache2/your-domain.com-access_log common
</VirtualHost>

Now, we can restart Apache web server so that the changes take place:

sudo a2ensite limesurvey.conf
sudo a2enmod rewrite
sudo systemctl restart apache2.service

LimeSurvey will be available on HTTP port 80 by default. Open your favorite browser and navigate to http://yourdomain.com/admin or http://server-ip/admin and complete the required the steps to finish the installation. If you are using a firewall, please open port 80 to enable access to the control panel.

Congratulation’s! You have successfully installed LimeSurvey. Thanks for using this tutorial for installing LimeSurvey online survey platform based PHP on Ubuntu 18.04 LTS (Bionic Beaver) system. For additional help or useful information, we recommend you to check the official LimeSurvey web site.

How To Install OroCRM 3.1 on Ubuntu 18.04 LTS

Install OroCRM on Ubuntu 18

OroCRM is an open-source and simple to utilize CRM with worked in advertising devices for eCommerce business. This product is completely focused on the internet business. OroCRM offers the best functionalities being adaptable and additionally intense. OroCRM can also be easily integrated with popular e-commerce platforms like Magento, MailChimp or Zendesk.

This article assumes you have at least basic knowledge of Linux, know how to use the shell, and most importantly, you host your site on your own VPS. The installation is quite simple and assumes you are running in the root account, if not you may need to add ‘sudo’ to the commands to get root privileges. I will show you through the step by step installation OroCRM open-source and simple to utilize CRM on an Ubuntu 18.04 Bionic Beaver server.

Install OroCRM on Ubuntu 18.04 LTS

Step 1. First make sure that all your system packages are up-to-date

sudo apt-get update
sudo apt-get upgrade

Step 2. Install LAMP (Linux, Apache, MariaDB and PHP) server.

A Ubuntu 18.04 LAMP server is required. If you do not have LAMP installed, you can follow our guide here. Also install all required PHP modules:

apt-get install php7.1-cli php7.1-mbstring php7.1-gd php7.1-opcache php7.1-mysql php7.1-json php7.1-mcrypt php7.1-xml php7.1-curl

Step 3. Installing Node.js and Composer.

OroCRM requires Node.js and Composer to be installed on the system. To install these packages, run the commands below:

curl -sS https://getcomposer.org/installer | sudo php -- --install-dir=/usr/local/bin --filename=composer

Next, run the commands below to install Node.js:

sudo curl --silent --location https://deb.nodesource.com/setup_8.x | sudo bash -
sudo apt install nodejs

Step 3. Download the stable version

First thing to do is to go to OroCRM’s download page and download the latest stable version of OroCRM:

cd /var/www/html/
sudo git clone -b 2.4 https://github.com/oroinc/crm-application.git orocrm
cd orocrm
sudo composer install --prefer-dist --no-dev

Next, run the commands below to complete the installation:


sudo php app/console oro:install --env=prod

We will need to change some folders permissions:

sudo chown -R www-data:www-data /var/www/html/orocrm/
sudo chmod -R 755 /var/www/html/orocrm/

Step 4. Configuring MariaDB for OroCRM.

By default, MariaDB is not hardened. You can secure MariaDB using the mysql_secure_installation script. You should read and below each steps carefully which will set root password, remove anonymous users, disallow remote root login, and remove the test database and access to secure MariaDB.

mysql_secure_installation

Configure it like this:

- Set root password? [Y/n] y
- 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

Next we will need to log in to the MariaDB console and create a database for the OroCRM. Run the following command:

mysql -u root -p

This will prompt you for a password, so enter your MariaDB root password and hit Enter. Once you are logged in to your database server you need to create a database for OroCRM installation:

MariaDB [(none)]> CREATE DATABASE orocrm;
MariaDB [(none)]> CREATE USER 'orocrmuser'@'localhost' IDENTIFIED BY 'new_password_here';
MariaDB [(none)]> GRANT ALL ON orocrm.* TO 'orocrmuser'@'localhost' IDENTIFIED BY 'user_password_here' WITH GRANT OPTION;
MariaDB [(none)]> FLUSH PRIVILEGES;
MariaDB [(none)]> \q

Step 5. Configuring Apache web server for OroCRM.

Create a new virtual host directive in Apache. For example, create a new Apache configuration file named ‘orocrm.conf’ on your virtual server:

touch /etc/apache2/sites-available/orocrm.conf
ln -s /etc/apache2/sites-available/orocrm.conf /etc/apache2/sites-enabled/orocrm.conf
nano /etc/apache2/sites-available/orocrm.conf

Add the following lines:

<VirtualHost *:80>
ServerAdmin [email protected]
DocumentRoot "/var/www/html/orocrm/web"
ServerName your-domain.com
ServerAlias www.your-domain.com
<Directory "/var/www/html/orocrm/web">
Options FollowSymLinks
AllowOverride All
Order allow,deny
allow from all
</Directory>
ErrorLog /var/log/apache2/your-domain.com-error_log
CustomLog /var/log/apache2/your-domain.com-access_log common
</VirtualHost>

Now, we can restart Apache web server so that the changes take place:

sudo a2enmod rewrite
a2ensite orocrm.conf
systemctl restart apache2.service

Step 6. Accessing OroCRM.

OroCRM will be available on HTTP port 80 by default. Open your favorite browser and navigate to http://yourdomain.com or http://server-ip and complete the required the steps to finish the installation. If you are using a firewall, please open port 80 to enable access to the control panel.

orocrm-install

Congratulation’s! You have successfully installed OroCRM. Thanks for using this tutorial for installing OroCRM open-source and simple to utilize CRM on your Ubuntu 18.04 LTS (Bionic Beaver) system. For additional help or useful information, we recommend you to check the official OroCRM web site.

How To Install Matomo 3.9.1 on Ubuntu 18.04 LTS

Install Matomo on Ubuntu 18

Matomo or formerly known as Piwik, is an open source web analytics application. It rivals Google Analytics and includes even more features and allows you to brand your brand and send out custom daily, weekly, and monthly reports to your clients.

This article assumes you have at least basic knowledge of Linux, know how to use the shell, and most importantly, you host your site on your own VPS. The installation is quite simple and assumes you are running in the root account, if not you may need to add ‘sudo’ to the commands to get root privileges. I will show you through the step by step installation Matomo open source web analytics on an Ubuntu 18.04 Bionic Beaver server.

Install Matomo on Ubuntu 18.04 LTS

Step 1. First make sure that all your system packages are up-to-date

sudo apt-get update
sudo apt-get upgrade

Step 2. Install LAMP (Linux, Apache, MariaDB and PHP) server.

A Ubuntu 18.04 LAMP server is required. If you do not have LAMP installed, you can follow our guide here. Also install all required PHP modules:

apt-get install php7.1-cli php7.1-mbstring php7.1-gd php7.1-opcache php7.1-mysql php7.1-json php7.1-mcrypt php7.1-xml php7.1-curl

Step 3. Download the latest version

First thing to do is to go to Matomo’s download page and download the latest stable version of Matomo:

cd /var/www/html/
wget https://builds.matomo.org/piwik.zip

Unzip the Matomo archive to the document root directory on your server:

unzip piwik.zip

We will need to change some folders permissions:

chown -R www-data:www-data /var/www/html/piwik
chmod -R 0755 /var/www/html/piwik/tmp

Step 4. Configuring MariaDB for Matomo.

By default, MariaDB is not hardened. You can secure MariaDB using the mysql_secure_installation script. you should read and below each steps carefully which will set root password, remove anonymous users, disallow remote root login, and remove the test database and access to secure MariaDB:

mysql_secure_installation

Configure it like this:

- Set root password? [Y/n] y
- 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

Next we will need to log in to the MariaDB console and create a database for the Matomo. Run the following command:

mysql -u root -p

This will prompt you for a password, so enter your MariaDB root password and hit Enter. Once you are logged in to your database server you need to create a database for Matomo installation:

CREATE DATABASE db_name;
GRANT ALL ON db_name.* TO 'username' IDENTIFIED BY 'password';
FLUSH PRIVILEGES;
quit

Step 5. Accessing Matomo web analytics application.

Matomo will be available on HTTP port 80 by default. Open your favorite browser and navigate to http://yourdomain.com/piwik or http://server-ip/piwik and complete the required the steps to finish the installation. If you are using a firewall, please open port 80 to enable access to the control panel.

install-matomo

Congratulation’s! You have successfully installed Matomo. Thanks for using this tutorial for installing Matomo open source web analytics on your Ubuntu 18.04 LTS Bionic Beaver. For additional help or useful information, we recommend you to check the official Matomo web site.