0

Kliqqi is an available supply content administration system dedicated to producing an on-line community that is social. So you can create your community that is own site facebook.

Formerly called Pligg CMS, Kliqqi includes some core features like modules, templates, opinions, language help, teams and SEO.

Kliqqi utilizes Smarty template system with integrated auto-caching to help keep rule divided from design.

We additionally permitted to expand Kliqqi functionality by producing module for Kliqqi.

You can find out about Kliqqi from Kliqqi internet site.

Objective

In this guide we will discover install that is how-to on Ubuntu 14.04. We will also install and configure its prerequisites.

Prerequisites

We will install Kliqqi in fresh installation of Ubuntu Server 14.04.

We also need these application to be able to run Kliqqi:

  • Apache 2
  • MySQL >= 5.1
  • PHP >= 5.4

Update Base System

Before we install Kliqqi, let’s update the system to the update that is latest.

$ Sudo apt-get update $ sudo apt-get -y upgrade 

Install Apache 2

After applying update that is latest to our base system, let’s start installing Apache 2 and its required libraries.

$ sudo apt-get -y install apache2 apache2-bin apache2-data apache2-mpm-prefork libaio1 libapache2-mod-php5 libapr1 libaprutil1 libdbd-mysql-perl libdbi-perl libhtml-template-perl libmysqlclient18 libterm-readkey-perl libwrap0 ssl-cert tcpd 

We can check Apache 2 service status using command below:

sudo service apache2 status  * apache2 is running 

Install MySQL 5.6

We will install and use MySQL 5.6 as database for Kliqqi.

We will use MySQL Server 5.6 since MySQL 5.6 is the most up to date version of MySQL shipped with Ubuntu 14.04 Trusty Tahr.

$ sudo apt-get install that is-y 

We should setup MySQL root password. Please input password for MySQL root individual.

Verify root password.

Securing MySQL Installation

We shall secure MySQL installation by running mysql_secure_installation.

Enter root password it, we’ll need the current password for the root user that we set on installation:

$ mysql_secure_installation  NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MySQL       SERVERS IN PRODUCTION USE!  PLEASE READ EACH STEP CAREFULLY!

In order to log into MySQL to secure. If you have simply set up MySQL, along withn't set the basis password yet, the password are going to be blank, and that means you should simply press enter right here.

Enter present password for root (enter for none): okay, effectively utilized password, shifting...

Since we curently have a root password set, solution this spend the n.

Setting the basis password helps to ensure that no one can log to the MySQL root individual with no authorisation that is proper

You already have a root password set, so you can safely answer 'n'.

Change the root password? [Y/n] n ... skipping.

Remove the user that is anonymous enhance protection. This may make people that are sure application have correct username and password to login to MySQL. Answer with Y.

By default, a MySQL installation has an anonymous user, allowing anyone to log into MySQL without having to have a user account created for them.  This is intended only for testing, and to make the installation go a bit smoother.  They should be removed by you before stepping into a production environment.

Remove anonymous users? [Y/n] Y ... Success!

We would also like eliminate the root login from remote device. Response with Y:

Normally, root should simply be permitted to link from 'localhost'.  This helps to ensure that some body cannot imagine at root password from system.

Disallow root login from another location? [Y/n] Y ... Success!

Previously the test database wa produced immediately by MySQL installation, but MySQL 5.6 will not produce test database. We are able to nevertheless select Y, it’s going to toss mistake but that is fine.

By standard, MySQL includes a database called 'test' that anybody can access.  This really is additionally meant just for evaluating, and may be eliminated before stepping into a production environment.

Remove Test access and database to it? [Y/n] Y - Dropping test database... ERROR 1008 (HY000) at line 1: Can't drop database 'test'; database doesn't exist ... Failed! Not critical, keep moving... - Removing privileges on test database... ... Success!

Last step is to reload privilege that is mySQL.

Reloading the privilege tables will make certain that all modifications made to date will need impact straight away.

Reload privilege tables now? [Y/n] Y ... Success!

All done! If you have finished all the above actions, your installation that is mySQL should be secure.

Thanks for using MySQL!

Cleaning up...

Create Database for kliqqi

Now we have a secure MySQL installation, time to create database and user for kliqqi itself.

Login to MySQL using root credential.

$ Mysql root that is-u Enter password:  Welcome towards MySQL monitor.  Commands end with ; or g. Your MySQL connection id is 58 Server variation: 5.6.30-0ubuntu0.14.04.1 (Ubuntu)

Copyright (c) 2000, 2016, Oracle and/or its affiliates. All legal rights reserved.

Oracle is a trademark that is registered of Corporation and/or its affiliates. Other names may be trademarks of their respective owners.

Type 'help;' or 'h' for help. Type 'c' to clear the current input statement.

mysql>

Create new database named kliqqi using command below:

mysql> CREATE DATABASE kliqqi; Query OK, 1 row affected (0.00 sec) 

Create user for kliqqi

Database for kliqqi is ready, let’s create username and password and grant privileges to kliqqi database.

Don’t forget to change the password kliqqi123secret below with better password.

mysql> GRANT ALL PRIVILEGES ON `kliqqi`.* TO 'kliqqi'@'localhost' IDENTIFIED BY 'kliqqi123secret'; Query OK, 0 rows affected (0.00 sec) 

We need to run FLUSH PRIVILEGES command so that the privileges table will be reloaded by MySQL and we can use new credential.

mysql> FLUSH PRIVILEGES; Query OK, 0 rows affected (0.00 sec) 

Exit from MySQL console by typing q

mysql> q 

Install PHP 5

Last component before we can install kliqqi is PHP 5. We will install PHP 5 and several common PHP libraries.

$ that we have to install sudo apt-get install that is-y php5-common php5-json php5-mysql php5-readline 

Install additional php libraries:

$ sudo apt-get -y install php5-gd php5-mcrypt php5-curl 

We will disable php5 opcache module and enable mcrypt module

$ sudo php5dismod opcache $ sudo php5enmod mcrypt 

Restart Apache 2 process so the changes will be applied

$ sudo service apache2 restart 

Install kliqqi

All prerequisites is already installed. We’re ready to install kliqqi. The latest stable version of kliqqi is available Kliqqi download page.

At the time of this writing, the latest version that is stable version 3.5.2, let us down load kliqqi compressed file utilizing wget.

$ wget -c https://www.kliqqi.com/download/2268/ -O Kliqqi1112017.zip 

Extract the file that is downloaded unzip. If your system don’t have unzip yet, you can install unzip using command below:

$ sudo apt-get -y install unzip 

Extract kliqqi using unzip

$ unzip Kliqqi1112017.zip 

Move Kliqqi1112017 directory to Apache directory as kliqqi.

$ sudo mv Kliqqi1112017 /var/www/kliqqi 

Change ownership of kliqqi directory to www-data user and group.

$ sudo chown -R www-data:www-data /var/www/kliqqi 

The kliqqi files are ready, now let’s create Apache Virtual Host configuration to serve kliqqi.

Configure Apache Virtual Host for http Only

Create new apache configuration file on /etc/apache2/sites-available/kliqqi.conf with contents below.

<VirtualHost *:80>     ServerName kliqqi.exampleserver.xyz

DocumentRoot /var/www/kliqqi

<Directory /var/www/kliqqi> Options -Indexes +FollowSymLinks +MultiViews AllowOverride All Require all granted </Directory>

ErrorLog ${APACHE_LOG_DIR}/kliqqi.exampleserver.xyz-error.log CustomLog ${APACHE_LOG_DIR}/kliqqi.exampleserver.xyz-access.log combined

</VirtualHost>

Don’t forget to change kliqqi.exampleserver.xyz above with the domain name that you use for your kliqqi installation.

Enable the site using a2ensite command.

$ sudo a2ensite kliqqi 

Reload the apache2 process so it read the new virtualhost configuration:

$ sudo service apache2 reload 

Kliqqi Installation Wizard

Now point our browser to Kliqqi installation URL : http://kliqqi.exampleserver.xyz/install/install.php

First step is language select, choose English

Step one contain installation step information. Click Next step

Step 2 is configuring database for Kliqqi. Enter database name and credentials that we created for Kliqqi before. Click Check Settings

Step 3 the installer shall upgrade setup apply for database. Simply click Next step.

Step 4 will generate database database schema for people. Within action we’ll additionally produce admin qualifications for Kliqqi.

Installation is complete we’ll need to do post install task to secure our Kliqqi installation, we’ll repeat this on next part

whenever we click login to dashboard website link we’ll get login web page. We are able to login utilizing admin credential we created on action 4.

After effectively login we’ll head to Kliqqi management dashboard in which we are able to handle Kliqqi settings.

Secure Kliqqi Installation

We have actually do two post install tasks, modification file authorization for database setup and in addition eliminate install directory.

$ cd /var/www/kliqqi $ chmod 644 /libs/dbconnect.php $ rm -rf install 

Configure https just website for kliqqi

Secure connection is currently a requirement for internet application. Final action we does inside tutorial is changing the text to just utilize https.

We assume which you curently have SSL certificate and key that is private

Let’s create new apache virtual host configuration on /etc/apache2/sites-available/kliqqi-ssl.conf with contents below.

Don’t forget to change***********) that are:

(************)ServerName

  • SSLCertificateFile
  • SSLCertificateChainFile
  • SSLCertificateKeyFile
  • <VirtualHost *:80>    ServerName kliqqi.exampleserver.xyz    Redirect permanent / https://kliqqi.exampleserver.xyz/ </VirtualHost>

    <VirtualHost *:443>

    ServerName kliqqi.exampleserver.xyz

    DocumentRoot /var/www/kliqqi

    <Directory /var/www/kliqqi> choices -Indexes +FollowSymLinks +MultiViews AllowOverride All need all issued </Directory>

    ErrorLog ${APACHE_LOG_DIR}/kliqqi.exampleserver.xyz-error.log CustomLog ${APACHE_LOG_DIR}/kliqqi.exampleserver.xyz-access.log combined

    SSLEngine on SSLCertificateFile /etc/apache2/ssl/kliqqi.exampleserver.xyz.crt SSLCertificateChainFile /etc/apache2/ssl/kliqqi.exampleserver.xyz.crt SSLCertificateKeyFile /etc/apache2/ssl/kliqqi.exampleserver.xyz.key

    Header constantly set Strict-Transport-Security "max-age=15768000"

    </VirtualHost>

    # intermediate setup, tweak towards requirements SSLProtocol all -SSLv2 -SSLv3 SSLCipherSuite ECDHE-ECDSA-CHACHA20-POLY1305:ECDHE-RSA-CHACHA20-POLY1305:ECDHE-ECDSA-AES128-GCM-SHA256:ECDHE-RSA-AES128-GCM-SHA256:ECDHE-ECDSA-AES256-GCM-SHA384:ECDHE-RSA-AES256-GCM-SHA384:DHE-RSA-AES128-GCM-SHA256:DHE-RSA-AES256-GCM-SHA384:ECDHE-ECDSA-AES128-SHA256:ECDHE-RSA-AES128-SHA256:ECDHE-ECDSA-AES128-SHA:ECDHE-RSA-AES256-SHA384:ECDHE-RSA-AES128-SHA:ECDHE-ECDSA-AES256-SHA384:ECDHE-ECDSA-AES256-SHA:ECDHE-RSA-AES256-SHA:DHE-RSA-AES128-SHA256:DHE-RSA-AES128-SHA:DHE-RSA-AES256-SHA256:DHE-RSA-AES256-SHA:ECDHE-ECDSA-DES-CBC3-SHA:ECDHE-RSA-DES-CBC3-SHA:EDH-RSA-DES-CBC3-SHA:AES128-GCM-SHA256:AES256-GCM-SHA384:AES128-SHA256:AES256-SHA256:AES128-SHA:AES256-SHA:DES-CBC3-SHA:!DSS SSLHonorCipherOrder on

    We also disable kliqqi http just digital host and allow the newest digital host config.

    $ sudo a2dissite kliqqi $ sudo a2ensite kliqqi-ssl 

    The brand new host that is virtual need Apache mod_ssl and mod_headers modules. We need to enable those modules.

    $ sudo a2enmod ssl $ headers that are sudo a2enmod*****************)

    Now, restart Apache 2 solution so that it will reload its setup. We have to restart in the place of reload since we allow brand new module.

    $ sudo solution apache2 restart 

    We should also alter settings.php allow https on our website.

    Open settings.php.

    find

    $my_base_url = 'http://kliqqi.exampleserver.xyz'; 

    replace http with https.

    $my_base_url = 'https://kliqqi.exampleserver.xyz'; 

    Now our Kliqqi website is completely operate on https.

    Summary

    In this guide we discovered how-to kliqqi that is install Ubuntu 14.04.

    We installed all the prerequisites, create user and database on MySQL for Kliqqi and also configure Apache 2 virtual hosts to be able to serve kliqqi.

    We also configured https settings for kliqqi so people can site access our community firmly.

    Webinar Series: Building Containerized Applications

    Previous article

    What is the essential difference between cPanel And WHM?

    Next article

    You may also like

    Comments

    Leave a reply

    Your email address will not be published. Required fields are marked *

    More in Apache