How to install Pixie CMS in Ubuntu

To install Pixie

Run the following command to set the LAMP environment on your system.

root@linuxhelp:~# apt-get install mariadb-server apache2 php5 libapache2-mod-php5 php5-mcrypt php5-mysql php5-gd php5-curl -y
Reading package lists... Done
Building dependency tree
Reading state information... Done
The following extra packages will be installed:
apache2-bin apache2-data apache2-utils libaio1 libapr1 libaprutil1 libaprutil1-dbd-sqlite3 libaprutil1-ldap libdbd-mysql-perl libdbi-perl libhtml-template-perl
liblua5.1-0 libmcrypt4 libmysqlclient18 libreadline5 libterm-readkey-perl mariadb-client-10.0 mariadb-client-core-10.0 mariadb-common mariadb-server-10.0
mariadb-server-core-10.0 mysql-common php5-cli php5-common php5-json php5-readline
.
.
.
Enabling module mpm_prefork.
apache2_switch_mpm Switch to prefork
apache2_invoke: Enable module php5
Setting up php5 (5.6.11+dfsg-1ubuntu3.4) ...
Processing triggers for libc-bin (2.21-0ubuntu4) ...
Processing triggers for ureadahead (0.100.0-19) ...
Processing triggers for systemd (225-1ubuntu9) ...

Start and enable the mysql services.

root@linuxhelp:~# systemctl start mysql
root@linuxhelp:~# systemctl enable mysql
mysql.service is not a native service, redirecting to systemd-sysv-install
Executing /lib/systemd/systemd-sysv-install enable mysql

Set root password for mairadb.

root@linuxhelp:~# mysql_secure_installation

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

In order to log into MariaDB to secure it, we' ll need the current
password for the root user. If you' ve just installed MariaDB, and
you haven' t set the root password yet, the password will be blank,
so you should just press enter here.

Enter current password for root (enter for none):
OK, successfully used password, moving on...

Setting the root password ensures that nobody can log into the MariaDB
root user without the proper authorisation.

Set root password? [Y/n] y
New password:
Re-enter new password:
Password updated successfully!
Reloading privilege tables..
... Success!

By default, a MariaDB installation has an anonymous user, allowing anyone
to log into MariaDB 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. You should remove them before moving into a
production environment.

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

Normally, root should only be allowed to connect from ' localhost' . This
ensures that someone cannot guess at the root password from the network.

Disallow root login remotely? [Y/n] y
... Success!

By default, MariaDB comes with a database named ' test'  that anyone can
access. This is also intended only for testing, and should be removed
before moving into a production environment.

Remove test database and access 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!

Reloading the privilege tables will ensure that all changes made so far
will take effect immediately.

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

Cleaning up...

All done! If you' ve completed all of the above steps, your MariaDB
installation should now be secure.

Thanks for using MariaDB!

Create the database and database user for pixie cms as shown below.

root@linuxhelp:~# mysql -u root -p
Enter password:
Welcome to the MariaDB monitor. Commands end with   or g.
Your MariaDB connection id is 51
Server version: 10.0.25-MariaDB-0ubuntu0.15.10.1 (Ubuntu)

Copyright (c) 2000, 2016, Oracle, MariaDB Corporation Ab and others.

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

MariaDB [(none)]>  CREATE DATABASE pixiedb 
Query OK, 1 row affected (0.00 sec)

MariaDB [(none)]>  GRANT ALL PRIVILEGES ON pixiedb.* TO ' linuxhelp' @' localhost'  IDENTIFIED BY ' ubuntu'  
Query OK, 0 rows affected (0.01 sec)

MariaDB [(none)]>  FLUSH PRIVILEGES 
Query OK, 0 rows affected (0.00 sec)

MariaDB [(none)]>  exit
Bye

Download the source code for pixie cms from the official website by using wget command.

root@linuxhelp:~# wget http://pixie-cms.googlecode.com/files/pixie_v1.04.zip
--2016-07-23 16:07:27-- http://pixie-cms.googlecode.com/files/pixie_v1.04.zip
Resolving pixie-cms.googlecode.com (pixie-cms.googlecode.com)... 74.125.130.82, 2404:6800:4003:c01::52
Connecting to pixie-cms.googlecode.com (pixie-cms.googlecode.com)|74.125.130.82|:80... connected.
HTTP request sent, awaiting response... 200 OK
Length: 2001768 (1.9M) [application/x-zip]
Saving to: ‘ pixie_v1.04.zip’ 

pixie_v1.04.zip 100%[==========================================================================================> ] 1.91M 304KB/s in 7.7s

2016-07-23 16:07:35 (255 KB/s) - ‘ pixie_v1.04.zip’  saved [2001768/2001768]

Extract the downloaded package by using the following command.

root@linuxhelp:~# ls
Desktop Documents Downloads examples.desktop Music Pictures pixie_v1.04.zip Public Templates Videos
root@linuxhelp:~# unzip pixie_v1.04.zip
Archive: pixie_v1.04.zip
creating: pixie_v1.04/
extracting: pixie_v1.04/.htaccess
creating: pixie_v1.04/admin/
creating: pixie_v1.04/admin/admin/
inflating: pixie_v1.04/admin/admin/index.php
creating: pixie_v1.04/admin/admin/modules/
inflating: pixie_v1.04/admin/admin/modules/ajax_fileupload.php
inflating: pixie_v1.04/admin/admin/modules/ajax_message.php
.
.
.
inflating: pixie_v1.04/files/sqlbackups/index.php
creating: pixie_v1.04/files/video/
inflating: pixie_v1.04/files/video/index.php
inflating: pixie_v1.04/index.php
inflating: pixie_v1.04/license.txt
inflating: pixie_v1.04/robots.txt
inflating: pixie_v1.04/sitemap.xml.php

To configure Pixie

Change the name of the directory.

root@linuxhelp:~# ls
Desktop Documents Downloads examples.desktop Music Pictures pixie_v1.04 pixie_v1.04.zip Public Templates Videos
root@linuxhelp:~# mv pixie_v1.04 pixie
root@linuxhelp:~# ls
Desktop Documents Downloads examples.desktop Music Pictures pixie pixie_v1.04.zip Public Templates Videos

Move the pixie directory to default root location by running the following command.

root@linuxhelp:~# mv pixie /var/www/html/

Next we need to change the ownership for the pixie directory as follows.

root@linuxhelp:~# chown www-data:www-data -R /var/www/html/pixie
root@linuxhelp:~# ls -lZd /var/www/html/pixie
drwxr-xr-x 4 www-data www-data ? 4096 Mar 20 2010 /var/www/html/pixie

Create the apache virtual host configuration file.

root@linuxhelp:~# vim /etc/apache2/sites-available/pixie.conf

And add the following lines into it.

< Virtualhost *:80> 
ServerAdmin admin@linuxhelp.com
DocumentRoot /var/www/html/pixie/
ServerName linuxhelp.com
ServerAlias www.linuxhelp.com
< Directory /var/www/html/pixie/> 
Options FollowSymLinks
AllowOverride All
Order allow,deny
allow from all
< /Directory> 
ErrorLog /var/log/apache2/linuxhelp.com-error_log
CustomLog /var/log/apache2/linuxhelp.com-access_log common
< /Virtualhost> 

Create soft link for the vhost config file.

root@linuxhelp:~# ln -s /etc/apache2/sites-available/pixie.conf /etc/apache2/sites-enabled/pixie.conf

Restart the apache services.

root@linuxhelp:~# systemctl restart apache2