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 properYou 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.xyzDocumentRoot /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.
Comments