MariaDB Archives - Page 12 of 14

April 7, 2019April 24, 2019

How To Install Nagios on Ubuntu 16.04

Nagios is an open source software that can be used for network and infrastructure monitoring. Nagios will monitor servers, switches, applications and services. It alerts the System Administrator when something went wrong and also alerts back when the issues has been rectified. Resources that can be monitored include CPU, memory and disk space loads, log files, temperature or hardware errors. It can monitor various parameters and problems for services like HTTP, SMTP, DNS, and with the help of plugins it can be highly extended. Nagios core was originally designed to run under Linux, although it should work under most other unices as well.

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 Nagios on a Ubuntu 16.04 (Xenial Xerus) server.

Install Nagios on Ubuntu 16.04

Step 1. First make sure that all your system packages are up-to-date by running these following apt-get commands in the terminal.

sudo apt-get update
sudo apt-get upgrade

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

A Ubuntu 16.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.0 openssl perl make php7.0-gd libgd2-xpm-dev libapache2-mod-php7.0 libperl-dev libssl-dev daemon wget apache2-utils unzip

Step 3. Create users and groups for Nagios.

Now create a new nagios user account and setup a password to this account:

useradd nagios
groupadd nagcmd
usermod -a -G nagcmd nagios
usermod -a -G nagcmd www-data

Step 4. Installing Nagios and plugins.

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

wget https://assets.nagios.com/downloads/nagioscore/releases/nagios-4.1.1.tar.gz
tar -zxvf /tmp/nagios-4.1.1.tar.gz
cd /tmp/nagios-4.1.1/

Perform below steps to compile the Nagios from the source code:

./configure --with-nagios-group=nagios --with-command-group=nagcmd --with-httpd_conf=/etc/apache2/sites-enabled/
make all
make install
make install-init
make install-config
make install-commandmode
make install-webconf

Next steps, Download latest nagios-plugins source and install using following commands:

wget http://www.nagios-plugins.org/download/nagios-plugins-2.1.1.tar.gz
tar xzf nagios-plugins-2.1.1.tar.gz
cd nagios-plugins-2.1.1
./configure --with-nagios-user=nagios --with-nagios-group=nagios
make
make install

Step 5. Configure Nagios.

Edit the /usr/local/nagios/etc/objects/contacts.cfg config file with your favorite editor and change the email address associated with the nagiosadmin contact definition to the address you’d like to use for receiving alerts.

nano /usr/local/nagios/etc/objects/contacts.cfg

Change the email address field to receive the notification:

[...]
define contact{
contact_name nagiosadmin ; Short name of userus
generic-contact ; Inherit default values from generic-contact template (defined above)
alias Nagios Admin ; Full name of useremail
[email protected] ; &amp;lt;&amp;lt;***** CHANGE THIS TO YOUR EMAIL ADDRESS ******
[...]

Step 6. Configure Apache web server for Nagios.

Now create nagios apache2 configuration file:

nano /etc/apache2/sites-enabled/nagios.conf

Edit the following lines if you want to access nagios administrative console from a particular IP series, Here, I want to allow nagios administrative access from 192.168.1.0/24 series only:

[...]
## Comment the following lines ##
# Order allow,deny
# Allow from all

## Uncomment and Change lines as shown below ##
Order deny,allow
Deny from all
Allow from 127.0.0.1 192.168.1.0/24
[...]

Enable Apache’s rewrite and cgi modules:

sudo a2enmod rewrite
sudo a2enmod cgi

Configure Apache authentication:

We need to setup the password for the user nagiosadmin. This username will be used to access the web interface so it is important to remember the password that you will input here. Set the password running the following command and enter the password twice:

# sudo htpasswd -s -c /usr/local/nagios/etc/htpasswd.users nagiosadmin
New password:
Re-type new password:
Adding password for user nagiosadmin

Restart Apache for the changes to take effect:

systemctl restart apache2

Step 7. Verify and Start Nagios service.

Next we have to make Nagios start at boot time, so first verify that the configuration file has no errors running the following command:

sudo /usr/local/nagios/bin/nagios -v /usr/local/nagios/etc/nagios.cfg

And you should get the output:

[...]
Checking objects...
Checked 8 services.
Checked 1 hosts.
Checked 1 host groups.
Checked 0 service groups.
Checked 1 contacts.
Checked 1 contact groups.
Checked 24 commands.
Checked 5 time periods.
Checked 0 host escalations.
Checked 0 service escalations.
Checking for circular paths...
Checked 1 hosts
Checked 0 service dependencies
Checked 0 host dependencies
Checked 5 timeperiods
Checking global event handlers...
Checking obsessive compulsive processor commands...
Checking misc settings...

Total Warnings: 0
Total Errors: 0

Things look okay - No serious problems were detected during the pre-flight check
[...]

Ubuntu 16.04 uses systemd for starting / stopping all the services, so, we need to create nagios.service file:

nano /etc/systemd/system/nagios.service

Add the following lines:

[Unit]
Description=Nagios
BindTo=network.target

[Install]
WantedBy=multi-user.target

[Service]
User=nagios
Group=nagios
Type=simple
ExecStart=/usr/local/nagios/bin/nagios /usr/local/nagios/etc/nagios.cfg

Enable Nagios to start automatically at system startup:

systemctl enable /etc/systemd/system/nagios.service

Now, start Nagios service:

systemctl start nagios

Step 8. Accessing Nagios.

Nagios 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. When prompted for username and password you will introduce the username “nagiosadmin” and the password that you entered in step 6.

Congratulation’s! You have successfully installed Nagios. Thanks for using this tutorial for installting Nagios monitoring tool in ubuntu 16.04 (Xenial Xerus) systems. For additional help or useful information, we recommend you to check the official Nagios web site.

April 7, 2019April 24, 2019

How To Install YetiForce CRM on Ubuntu 16.04

YetiForce is an open source innovative CRM system. YetiForce was built on a rock-solid Vtiger foundation, but has hundreds of changes that help to accomplish even the most challenging tasks in the simplest way. Every function within the system was thought through and automated to ensure that all of them work together seamlessly and form a coherent integrity.

Install YetiForce CRM on Ubuntu 16.04

Step 1. First make sure that all your system packages are up-to-date by running these following apt-get commands in the terminal.

sudo apt-get update
sudo apt-get upgrade

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

A Ubuntu 16.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.0-mysql php7.0-curl php7.0-json php7.0-cgi php7.0 libapache2-mod-php7.0 <code>php7.0-mcrypt php7.0-gd
</code>

tep 3. Installing YetiForce CRM.

First thing to do is to go to YetiForce CRM’s download page and download the latest stable version of YetiForce CRM, At the time of writing, the latest version is YetiForce version 3.1.0:

wget https://github.com/YetiForceCompany/YetiForceCRM/archive/3.1.0.zip

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

unzip 3.1.0.zip -d /var/www/html/
mv YetiForceCRM-3.1.0 yetiforce

Set the file permissions for YetiForce CRM:

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

Step 4. Configuring MariaDB for YetiForce CRM.

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 YetiForce CRM. 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 YetiForce CRM installation:

MariaDB [(none)]&gt; CREATE DATABASE yetiforce;
MariaDB [(none)]&gt; GRANT ALL PRIVILEGES ON yetiforce.* TO 'yetiforce'@'localhost' IDENTIFIED BY 'strong_password';
MariaDB [(none)]&gt; FLUSH PRIVILEGES;
MariaDB [(none)]&gt; \q

Step 5. Configuring Apache web server for YetiForce CRM.

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

sudo a2enmod rewrite
touch /etc/apache2/sites-available/yetiforce.conf
ln -s /etc/apache2/sites-available/yetiforce.conf /etc/apache2/sites-enabled/yetiforce.conf
nano /etc/apache2/sites-available/yetiforce.conf

Add the following lines:

ServerAdmin [email protected]
DocumentRoot /var/www/html/yetiforce/
ServerName your-domain.com
ServerAlias www.your-domain.com

Options FollowSymLinks
AllowOverride All
Order allow,deny
allow from all

ErrorLog /var/log/apache2/your-domain.com-error_log
CustomLog /var/log/apache2/your-domain.com-access_log common

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

systemctl restart apache2.service

Step 6. Accessing YetiForce CRM.

YetiForce CRM 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. The default username admin and password admin. If you are using a firewall, please open port 80 to enable access to the control panel.

Congratulation’s! You have successfully installed YetiForce CRM. Thanks for using this tutorial for installing YetiForce customer relationship management on your Ubuntu 16.04 system. For additional help or useful information, we recommend you to check the official YetiForce CRM web site.

[youtube https://www.youtube.com/watch?v=UhqxUabMej4]

April 7, 2019April 24, 2019

How To Install Bludit CMS on Ubuntu 16.04

Bludit is a simple web application to make your own blog or site in seconds, it’s completly free and open source. Bludit uses flat-files (text files in JSON format) to store the posts and pages, you don’t need to install or configure a database.

Install Bludit CMS on Ubuntu 16.04 LTS

Step 1. First make sure that all your system packages are up-to-date by running these following apt-get commands in the terminal.

sudo apt-get update
sudo apt-get upgrade

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

A Ubuntu 16.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.0-mysql php7.0-curl php7.0-json php7.0-cgi php7.0 libapache2-mod-php7.0 <code>php7.0-mcrypt php7.0-gd
</code>

Step 3. Installing Bludit CMS.

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

wget https://s3.amazonaws.com/bludit-s3/bludit-builds/bludit_latest.zip

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

unzip bludit_latest.zip
mv bludit /var/www/html/

Set the file permissions for Bludit CMS:

chown -R www-data:www-data /var/www/html/bludit/bl-content

Step 4. Configuring Apache web server for Bludit CMS.

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

sudo a2enmod rewrite
touch /etc/apache2/sites-available/bludit.conf
ln -s /etc/apache2/sites-available/bludit.conf /etc/apache2/sites-enabled/bludit.conf
nano /etc/apache2/sites-available/bludit.conf

Add the following lines:

ServerAdmin [email protected]
DocumentRoot /var/www/html/bludit/
ServerName your-domain.com
ServerAlias www.your-domain.com

Options FollowSymLinks
AllowOverride All
Order allow,deny
allow from all

ErrorLog /var/log/apache2/your-domain.com-error_log
CustomLog /var/log/apache2/your-domain.com-access_log common

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

systemctl restart apache2.service

Step 5. Accessing Bludit Content Management System.

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

Congratulation’s! You have successfully installed Bludit CMS. Thanks for using this tutorial for installing Bludit content management system (CMS) on your Ubuntu 16.04 system. For additional help or useful information, we recommend you to check the official Bludit CMS web site.

[youtube https://www.youtube.com/watch?v=NGCshaVotZI]

April 4, 2019April 24, 2019

How To Install OpenCart on Ubuntu 16.04

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.

Install OpenCart on Ubuntu 16.04

Step 1. First make sure that all your system packages are up-to-date by running these following apt-get commands in the terminal.

sudo apt-get update
sudo apt-get upgrade

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

A Ubuntu 16.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.0-mysql php7.0-curl php7.0-json php7.0-cgi php7.0 libapache2-mod-php7.0 <code>php7.0-mcrypt
</code>

Step 3. Installing OpenCart.

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

wget https://github.com/opencart/opencart/archive/2.3.0.2.zip
unzip 2.3.0.2.zip
mv opencart-2.3.0.2/upload/* /var/www/html/

Rename the file ‘config-dist.php’ to ‘config.php’:

mv config-dist.php config.php

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 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)]&gt; CREATE DATABASE opencart;
MariaDB [(none)]&gt; GRANT ALL PRIVILEGES ON opencart.* TO 'opencartuser'@'localhost' IDENTIFIED BY 'opencartuser_passwd';
MariaDB [(none)]&gt; FLUSH PRIVILEGES;
MariaDB [(none)]&gt; \q

Step 5. 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 16.04 systems. For additional help or useful information, we recommend you to check the official OpenCart website.

April 4, 2019April 24, 2019

How To Install Dokuwiki on Ubuntu 16.04

DokuWiki is considered to be the most versatile open source Wiki software application which is proven to meet your demanding wiki needs. Using a very familiar interface, it allows you to easily scale and optimize using many advanced features. Utilizing files instead of a database, DokuWiki is extremely flexible with the type of system it will run on (no database server required).

Install Dokuwiki on Ubuntu 16.04

Step 1. First make sure that all your system packages are up-to-date by running these following apt-get commands in the terminal.

sudo apt-get update
sudo apt-get upgrade

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

A Ubuntu 16.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.0-curl php7.0-json php7.0-cgi php7.0 libapache2-mod-php7.0 php7.0-xml <code>php7.0-mcrypt php7.0-gd
</code>

Step 3. Installing Dokuwiki.

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

wget http://download.dokuwiki.org/src/dokuwiki/dokuwiki-stable.tgz

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

tar xvf dokuwiki-stable.tgz
mv dokuwiki-*/ /var/www/dokuwiki

We will need to change some folders permissions:

chown www-data:www-data -R /var/www/dokuwiki
chmod -R 707 /var/www/dokuwiki

Step 4. Configuring Apache web server for DokuWiki.

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

sudo a2enmod rewrite
touch /etc/apache2/sites-available/dokuwiki.conf
ln -s /etc/apache2/sites-available/dokuwiki.conf /etc/apache2/sites-enabled/dokuwiki.conf
nano /etc/apache2/sites-available/dokuwiki.conf

Add the following lines:

ServerAdmin [email protected]
DocumentRoot /var/www/dokuwiki/
ServerName your-domain.com
ServerAlias www.your-domain.com

Options FollowSymLinks
AllowOverride All
Order allow,deny
allow from all

ErrorLog /var/log/apache2/your-domain.com-error_log
CustomLog /var/log/apache2/your-domain.com-access_log common

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

systemctl restart apache2.service

Step 5. Accessing DokuWiki.

DokuWiki 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.

Congratulation’s! You have successfully installed Dokuwiki. Thanks for using this tutorial for installing Dokuwiki on your Ubuntu 16.04 (Xenial Xerus) system. For additional help or useful information, we recommend you to check the official Dokuwiki web site.

April 3, 2019April 24, 2019

How To Install Icinga 2 on Ubuntu 16.04

Icinga 2 is an open source network monitoring system which checks the availability of your network resources, notifies users of outages, and generates performance data for reporting. Its Scalable and extensible, Icinga2 can monitor large, complex environments across multiple locations.

Icinga 2 Features:

Monitoring of network services (SMTP, POP3, HTTP, NNTP, ping, etc.)
Monitoring of host resources (CPU load, disk usage, etc.)
Monitoring of server components (switches, routers, temperature and humidity sensors, etc.)
Simple plug-in design that allows users to easily develop their own service checks,
Parallelized service checks.
Ability to define network host hierarchy using “parent” hosts, allowing detection of and distinction between hosts that are down and those that are unreachable.
Ability to define event handlers to be run during service or host events for proactive problem resolution.
Notification of contact persons when service or host problems occur and get resolved (via email, pager, or user-defined method).
Escalation of alerts to other users or communication channels.
Two optional user interfaces (Icinga Classic UI and Icinga Web) for visualization of host and service status, network maps, reports, logs, etc.
Icinga Reporting module based on open source Jasper Reports for both Icinga Classic and Icinga Web user interfaces
Capacity utilization reporting.
Performance graphing via add-ons such as PNP4Nagios, NagiosGrapher and InGraph.

Install Icinga 2 on Ubuntu 16.04

Step 1. First make sure that all your system packages are up-to-date by running these following apt-get commands in the terminal.

sudo apt-get update
sudo apt-get upgrade

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

A Ubuntu 16.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.0-mysql php7.0-curl php7.0-json php7.0-cgi php7.0 libapache2-mod-php7.0 &lt;code&gt;php7.0-mcrypt
&lt;/code&gt;

Step 3. Installing Icinga 2.

First, enable the add-repository feature and add the repository for Icinga with the below commands:

apt install software-properties-common
add-apt-repository ppa:formorer/icinga

Install Icinga 2 package:

apt update
apt install icinga2

Once the installation is complete. Make sure the service is up and running fine:

systemctl status icinga2.service
systemctl enable icinga2.service
systemctl start icinga2.service

By default, Icinga2 enables the following features. But we can confirm the enabled settings by running this command as below:

icinga2 feature list

Step 3. Installing Icinga2 plugin.

Icinga2 will collect the service information based on the monitoring plugins. So, we need to install nagios plugin using below command:

apt install nagios-plugins

Next, you need to install the IDO module which is crucial for the Icinga 2 web interface. It will export all configuration and status information into its database. Execute the following command:

apt install icinga2-ido-mysql

Then restart Icinga 2 for the changes to take effect:

systemctl restart icinga2.service

Once you enabled the IDO modules, Icinga 2 places the new configuration file at /etc/icinga2/features-enabled/ido-mysql.conf in which we need to update the database credentials manually:

cat /etc/icinga2/features-enabled/ido-mysql.conf

Update the above file shown like below:

root@:wpcademy.com~# nano /etc/icinga2/features-enabled/ido-mysql.conf
/**
* The db_ido_mysql library implements IDO functionality
* for MySQL.
*/
library "db_ido_mysql"
object IdoMysqlConnection "ido-mysql" {
user = "icinga2",
password = "icinga123",
host = "localhost",
database = "icinga2"
}

Step 4. Configuring MariaDB for Icinga 2.

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 Icinga 2. 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 Icinga 2 installation:

MariaDB [(none)]&amp;gt; create database icinga2;
MariaDB [(none)]&amp;gt; grant all privileges on icingaweb.* to icinga2@localhost identified by 'icinga123';
MariaDB [(none)]&amp;gt; flush privileges;
MariaDB [(none)]&amp;gt; \q

Step 5. Installing Icinga 2 Web.

After creating the database, we can install the Web interface plugin and configure it one by one:

apt-get install icingaweb2

Step 6. Accessing Icinga 2.

Icinga2 will be available on HTTP port 80 by default. Open your favorite browser and navigate to http://yourdomain.com/icingaweb2/setup or http://server-ip/icingaweb2/setup 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 Icinga 2. Thanks for using this tutorial for installing Icinga 2 network monitoring on Ubuntu 16.04 LTS systems. For additional help or useful information, we recommend you to check the official Icinga 2 web site.

April 3, 2019April 24, 2019

How To Install Open Source Social Network on Ubuntu 16.04

Opensource-Social network (OSSN) is a social networking software written in PHP. It allows you to make a social networking website and helps your members build social relationships, with people who share similar professional or personal interests.

Install Open Source Social Network on Ubuntu 16.04

Step 1. First make sure that all your system packages are up-to-date by running these following apt-get commands in the terminal.

sudo apt-get update
sudo apt-get upgrade

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

A Ubuntu 16.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.0-mysql php7.0-curl php7.0-json php7.0-cgi php7.0 libapache2-mod-php7.0 &lt;code&gt;php7.0-mcrypt
&lt;/code&gt;

Step 3. Installing Open Source Social Network.

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

cd /opt/
wget https://www.opensource-socialnetwork.org/downloads/ossn-v4.2-1468404691.zip -O ossn.zip
unzip ossn.zip -d /var/www/html/

We will need to change some folders permissions:

chown -R www-data.www-data /var/www/html/ossn/

Step 4. Configuring MariaDB for Open Source Social Network.

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

MariaDB [(none)]&amp;gt; SET GLOBAL sql_mode='';
MariaDB [(none)]&amp;gt; CREATE DATABASE ossndb;
MariaDB [(none)]&amp;gt; CREATE USER 'ossnuser'@'localhost' IDENTIFIED BY 'y0ur-pAssW0RD';
MariaDB [(none)]&amp;gt; GRANT ALL PRIVILEGES ON ossndb.* TO 'ossnuser'@'localhost';
MariaDB [(none)]&amp;gt; FLUSH PRIVILEGES;
MariaDB [(none)]&amp;gt; \q

Step 5. Configuring Apache web server for Open Source Social Network.

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

sudo a2enmod rewrite
touch /etc/apache2/sites-available/ossn.conf
ln -s /etc/apache2/sites-available/ossn.conf /etc/apache2/sites-enabled/ossn.conf
nano /etc/apache2/sites-available/ossn.conf

Add the following lines:

ServerAdmin [email protected]
DocumentRoot /var/www/html/ossn/
ServerName your-domain.com
ServerAlias www.your-domain.com

Options FollowSymLinks
AllowOverride All
Order allow,deny
allow from all

ErrorLog /var/log/apache2/your-domain.com-error_log
CustomLog /var/log/apache2/your-domain.com-access_log common

Next, You can edit the PHP configuration file:

nano /etc/php/7.0/cli/php.ini

And modify these lines:

allow_url_fopen = On
file_uploads = On
upload_max_filesize = 32M

OSSN also needs a directory for storing the uploaded files such as images. For security reasons we will create this directory outside of the document root directory:

mkdir -p /var/www/ossndatadir

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

systemctl restart apache2.service

Step 6. Accessing Open Source Social Network.

Open Source Social Network 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. Log in to the OSSN administration back-end at http://your-domain.com/administrator and configure OSSN according to your needs.

Congratulation’s! You have successfully installed Open Source Social Network. Thanks for using this tutorial for installing Open Source Social Network on Ubuntu 16.04 systems. For additional help or useful information, we recommend you to check the official Open Source Social Network web site.