Tag: LAMP

Posted on

How To Install Akaunting on CentOS 7 Step by Step

Install Akaunting on CentOS 7

Akaunting is a free and online accounting software designed for small businesses to manage their finances and stay on top of their cash flow. Invoicing, accepting online payments and keeping track of expenses couldn’t be simpler. Akaunting is built with modern technologies such as Laravel, Bootstrap, jQuery, Swift Mailer, API etc. In this tutorial we will learn how to Install Akaunting on CentOS 7 step by step.

Prerequisites

This tutorial 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 Akaunting online accounting software on a CentOS 7 server.

Install Akaunting 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 Akaunting on CentOS 7.

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

cd /var/www/akaunting
curl -O -J -L https://akaunting.com/download.php?version=latest
unzip Akaunting_1.1.15-Stable.zip

We will need to change some folders permissions:

chown -R chown apache:apache -R /var/www/akaunting

Step 4. Configuring MariaDB for Akaunting.

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 Akaunting. 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 Akaunting installation:

MariaDB [(none)]> CREATE DATABASE dbname;
MariaDB [(none)]> GRANT ALL ON dbname.* TO 'username' IDENTIFIED BY 'password';
MariaDB [(none)]> FLUSH PRIVILEGES;
MariaDB [(none)]> EXIT;

Step 5. Configure Apache web server for Akaunting.

We will create Apache virtual host for your Akaunting 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:

ServerAdmin [email protected]
DocumentRoot "/var/www/akaunting"
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/akaunting/">
DirectoryIndex index.html index.php
Options FollowSymLinks
AllowOverride All
Require all granted

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

systemctl restart httpd.service

Step 6. Accessing Akaunting.

Akaunting 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 Akaunting. Thanks for using this tutorial for installing Akaunting online accounting software on CentOS 7 systems. For additional help or useful information, we recommend you to check the official Akaunting web site.

Posted on

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.

Posted on

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.

Posted on

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.

Posted on

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.

Posted on

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.

Posted on

How To Install Magento 2.3 on Ubuntu 18.04 LTS

Install Magento on Ubuntu 18

Magento is one of the worlds most widely used applications for managing E-Commerce sites. Magento is fully customizable to meet the users requirements and allowing them to create and launch a fully functional online store in minutes. Magento employs the MySQL relational database management system, the PHP programming language, and elements of the Zend Framework.

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 Magento on an Ubuntu 18.04 Bionic Beaver server.

Magento Features:

  • Analytics and Reporting – the script is integrated with Google Analytics and offers many different reports.
  • Product Browsing – multiple images for products, options for extensive reviews, wishlists and much more.
  • Catalog Browsing – easy navigation, advanced product filtering system, product comparison.
  • Catalog Management – inventory management, batch import and export of products, different tax rates per location, additional product attributes.
  • Customer Accounts – order status and history, e-mail and RSS feeds for products in the wishlist, newsletter subscription, default billing and shipping address.
  • Customer Service – enhanced features for customers’ accounts, Contact Us form, comprehensive order tracking and history, customizable order e-mails.
  • Order Management – create orders through admin area, create multiple invoices shipments and credit memos, call center order creation option.
  • Payment – different payment methods: credit cards, PayPal, Authorize.net,
  • Google Checkout, checks, money orders, support of external payment modules like Cybersource, ePay, eWAY and many more.
  • Shipping – shipping to multiple addresses, flat rating shipping, supports UPS,
  • UPS XML (account rates), FedEx (account rates), USPS and DHL.
  • Checkout – one page checkout, SSL support, checkout without having an account.
  • Search Engine Optimization – 100% Search Engine Friendly, Google SiteMap support.
  • International Support – multiple languages and currencies, list of allowed countries for registration, purchasing and shipping, localization.
  • Marketing Promotions and Tools – coupons, discounts and different promotion options.
  • Site Management – control of multiple web sites, multiple languages, tax rate with support for US and International markets, customizable outlook through templates.

Install Magento 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. Installing Magento on Ubuntu 18.04.
First thing to do is to go to Magento’s download page and download the latest stable version of Magento, At the moment of writing this article it is version 2.3.0.

Next, unpack the Magento archive to the document root directory on your server:

unzip magento*.zip
cp -rf magento/* /var/www/html/

We will need to change some folders permissions:

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

Step 4. Configuring MariaDB for Magento.

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 Magento. 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 Magento installation:

CREATE DATABASE magentodb;
GRANT ALL PRIVILEGES ON magentodb . * TO magento@'localhost' IDENTIFIED BY 'PASSWORD' WITH GRANT OPTION;
flush privileges;
exit

Step 5. Configuring Apache web server for Magento.

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

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

Add the following lines:

<VirtualHost *:80>
ServerAdmin [email protected]
DocumentRoot /var/www/html/
ServerName your-domain.com
ServerAlias www.your-domain.com
<Directory /var/www/html/>
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. Configure PHP for Magento.

Now here we should allow Magento to use enough PHP memory (it is recommended that PHP should be allowed 512 MB of RAM). To do that, run the commands below to open the configuration file:

sudo nano /etc/php/7.1/apache2/php.ini

Search for the line ‘memory_limit‘ in the file:

memory_limit = 128M
### And change the value to 512 ###
memory_limit = 512M

Restart Apache for the changes to take effect using the following command:

systemctl restart apache2

Step 7. Accessing Magento.

Magento 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 Magento. Thanks for using this tutorial for installing Magento eCommerce in Ubuntu 18.04 LTS system. For additional help or useful information, we recommend you to check the official Magento web site.