How to Install Redaxscript 3.2 CMS on a FreeBSD 11 FAMP VPS

• Prerequisites
• Step 1: Add a Sudo User
• Step 2: Update FreeBSD 11 System
• Step 3: Install Apache Web Server
• Step 4: Install PHP 7.1
• Step 5: Install MariaDB (MySQL) Server
• Step 6: Create Database for Redaxscript CMS
• Step 7: Install Redaxscript CMS Files
• Step 8: Complete Redaxscript CMS Installation

Redaxscript 3.2 CMS is a modern and ultra lightweight, free and open source Content Management System (CMS) with rocket-fast performance. The Redaxscript 3.2 CMS object relational mapper and fluent query builder provide a preconceived and standardised abstraction layer for SQLite, MSSQL, MySQL and PostgreSQL databases. Developers can execute a useful collection of powerful commands from the terminal or browser, allowing automation of installations, backups, imports and many other useful tasks, resulting in a flexible, efficient, and extensible system architecture that helps developers achieve maximum productivity and application performance.

In this tutorial we are going to install Redaxscript 3.2 CMS on a FreeBSD 11 FAMP VPS using Apache web server, PHP 7.1, and a MariaDB database.

Prerequisites

• A clean Vultr FreeBSD 11 server instance with SSH access

Step 1: Add a Sudo User

First, log into your server as root:

ssh root@YOUR_VULTR_IP_ADDRESS

The sudo command isn't installed by default in the Vultr FreeBSD 11 server instance, so we will first install sudo:

pkg install sudo

Now add a new user called user1 (or your preferred username):

adduser user1

The adduser command will prompt you for lots of details for the user account, so simply select the defaults for most of them when it makes sense to do so. When you are asked whether to Invite user1 into any other groups?, you should enter wheel to add user1 to the wheel group.

Now check the /etc/sudoers file to make sure that the sudoers group is enabled:

visudo

Look for a section like this:

# %wheel        ALL=(ALL)       ALL

This line tells us that users who are members of the wheel group can use the sudo command to gain root privileges. It will be commented out by default so you will need to uncomment it and then save and exit the file.

We can verify the user1 group membership with the groups command:

groups user1

If user1 is not a member of the wheel group, you can use this command to update the user1 group membership:

pw group mod wheel -m user1 

Now use the su command to switch to the new sudo user user1 account:

su - user1

The command prompt will update to indicate that you are now logged into the user1 account. You can verify this with the whoami command:

whoami

Now restart the sshd service so that you can login via ssh with the new non-root sudo user account you have just created:

sudo /etc/rc.d/sshd restart

Exit the user1 account:

exit

Exit the root account (which will disconnect your ssh session):

exit

You can now ssh into the server instance from your local host using the new non-root sudo user user1 account:

ssh user1@YOUR_VULTR_IP_ADDRESS

If you want to execute sudo without having to type a password every time, then open the /etc/sudoers file again, using visudo:

sudo visudo

Edit the section for the wheel group so that it looks like this:

%wheel        ALL=(ALL)       NOPASSWD: ALL

Please note: Disabling the password requirement for the sudo user is not a recommended practice, but it is included here as it can make server configuration much more convenient and less frustrating, especially during longer systems administration sessions. If you are concerned about the security implications, you can always revert the configuration change to the original after you finish your administration tasks.

Whenever you want to log into the root user account from within the sudo user account, you can use one of the following commands:

sudo -i
sudo su -

You can exit the root account and return back to your sudo user account any time by simply typing the following:

exit

Step 2: Update FreeBSD 11 System

Before installing any packages on the FreeBSD server instance, we will first update the system.

Make sure you are logged in to the server using a non-root sudo user and run the following commands:

sudo freebsd-update fetch
sudo freebsd-update install
sudo pkg update
sudo pkg upgrade

Step 3: Install Apache Web Server

Install the Apache web server:

sudo pkg install apache24

Enter y when prompted.

Now use the sysrc command to enable the Apache service to execute automatically at boot time:

sudo sysrc apache24_enable=yes

The sysrc command updates the /etc/rc.conf configuration file, so if you want to verify the configuration update manually you can simply open the /etc/rc.conf file with your favourite terminal editor:

vi /etc/rc.conf

Now start the Apache service:

sudo service apache24 start

You can quickly check that apache is running by visiting the IP address or domain of the server instance in your browser:

http://YOUR_VULTR_IP_ADDRESS/

You will see the default FreeBSD Apache page displaying the text:

It works!

Check your Apache default configuration file to ensure that the DocumentRoot directive points to the correct directory:

sudo vi /usr/local/etc/apache24/httpd.conf

The DocumentRoot configuration option will look like this:

DocumentRoot "/usr/local/www/apache24/data"

We now need to enable the mod_rewrite Apache module. We can do this by searching the default Apache configuration file for the term mod_rewrite.

By default, the mod_rewrite Apache module will be commented out (which means it is disabled). The configuration line on a clean Vultr FreeBSD 11 instance will look like this:

#LoadModule rewrite_module libexec/apache24/mod_rewrite.so

Simply remove the hash symbol to uncomment the line and load the module:

LoadModule rewrite_module libexec/apache24/mod_rewrite.so

We also need to enable the mod_deflate and mod_headers modules, so make sure they are both uncommented too:

LoadModule deflate_module libexec/apache24/mod_deflate.so
LoadModule headers_module libexec/apache24/mod_headers.so

Now we need to edit The Directory Apache directive in the same configuration file so that mod_rewrite will work correctly with Redaxscript CMS.

Find the section of the configuration file that starts with <Directory "/usr/local/www/apache24/data"> and change AllowOverride none to AllowOverride All. The end result (with all comments removed) will look something like this:

<Directory "/var/www/html">
    Options Indexes FollowSymLinks
    AllowOverride All
    Require all granted
</Directory>

Now save and exit the Apache configuration file.

We will restart Apache at the end of this tutorial, but restarting Apache regularly during installation and configuration is certainly a good habit, so let's do it now:

sudo service apache24 restart

Step 4: Install PHP 7.1

We can now install PHP 7.1 along with all of the necessary PHP modules required by Redaxscript CMS:

sudo pkg install php71 mod_php71 php71-gd php71-mbstring php71-mysqli php71-xml php71-curl php71-ctype php71-tokenizer php71-simplexml php71-dom php71-session php71-iconv php71-hash php71-json php71-fileinfo php71-pdo php71-pdo_mysql php71-zlib php71-openssl php71-zip php71-phar 

FreeBSD 11 gives us the option to use a development php.ini or a production php.ini. Since we are going to install Redaxscript on a public web server, we'll use the production version. First, back up php.ini-production:

sudo cp /usr/local/etc/php.ini-production /usr/local/etc/php.ini-production.backup

Then soft-link php.ini-production to php.ini:

sudo ln -s /usr/local/etc/php.ini-production /usr/local/etc/php.inii

We need to configure Apache to actually use PHP, so let's create a new file called php.conf in the Apache Includes directory:

sudo vi /usr/local/etc/apache24/Includes/php.conf

Enter the following text into the newly created file:

<IfModule dir_module>
    DirectoryIndex index.php index.html
    <FilesMatch "\.php$">
        SetHandler application/x-httpd-php
    </FilesMatch>
    <FilesMatch "\.phps$">
        SetHandler application/x-httpd-php-source
    </FilesMatch>
</IfModule>

Save and exit the file.

Now let's restart Apache so that it can reload the configuration changes:

sudo service apache24 restart

Step 5: Install MariaDB (MySQL) Server

FreeBSD 11 defaults to using MariaDB database server, which is an enhanced, fully open source, community developed, drop-in replacement for MySQL server.

Install the latest version of MariaDB database server:

sudo pkg install mariadb102-server mariadb102-client

Start and enable MariaDB server to execute automatically at boot time.

sudo sysrc mysql_enable="yes"
sudo service mysql-server start

Secure your MariaDB server installation:

sudo mysql_secure_installation

When prompted to create a MariaDB/MySQL root user, select "Y" (for yes) and then enter a secure root password. Simply answer "Y" to all of the other yes/no questions as the default suggestions are the most secure options.

Step 6: Create Database for Redaxscript CMS

Log into the MariaDB shell as the MariaDB root user by running the following command:

sudo mysql -u root -p

To access the MariaDB command prompt, simply enter the MariaDB root password when prompted.

Run the following queries to create a MariaDB database and database user for Redaxscript CMS:

CREATE DATABASE redax_db CHARACTER SET utf8 COLLATE utf8_general_ci;
CREATE USER 'redax_user'@'localhost' IDENTIFIED BY 'UltraSecurePassword';
GRANT ALL PRIVILEGES ON redax_db.* TO 'redax_user'@'localhost';
FLUSH PRIVILEGES;
EXIT;

You can replace the database name redax_db and username redax_user with something more to your liking, if you prefer. Also, make sure that you replace "UltraSecurePassword" with an actually secure password.

Step 7: Install Redaxscript CMS Files

Change your current working directory to the default web directory:

cd /usr/local/www/apache24/data

Your current working directory will now be: /usr/local/www/apache24/data. You can check this with the pwd (print working directory) command:

pwd

Now use wget to download the Redaxscript CMS installation package:

sudo wget https://redaxscript.com/files/releases/redaxscript-3.2.3-production-full.zip

Please note: You should definitely check for the most recent version by visiting the Redaxscript CMS download page.

List the current directory to check that you have successfully downloaded the file:

ls -la

Remove index.html:

sudo rm index.html

Now uncompress the zip archive:

sudo unzip redaxscript-3.2.3-production-full.zip

Change ownership of the web files to avoid any permissions problems:

sudo chown -R www:www * ./

Restart Apache again:

sudo service apache24 restart

Now we're ready to move on to the final step.

Step 8: Complete Redaxscript CMS Installation

It's time to visit the IP address of your server instance in your browser, or if you've already configured your Vultr DNS settings (and given it enough time to propagate) you can simply visit your domain instead.

To access the Redaxscript CMS installation page, enter your Vultr instance IP address into your browser address bar, followed by /install.php:

http://YOUR_VULTR_IP_ADDRESS/install.php

Most of the installation options are self explanatory, but here are a few pointers to help you along:

1. Enter the following database values in the Setup your database section of the Installation page:

   Type:               MySQL
   Host:               localhost
   Name:               redax_db                
   User:               redax_user      
   Password:           UltraSecurePassword         
   Table Prefix:       rs_         
   

2. Next, click on the Create your account section of the Installation page and enter appropriate Admin login details:

   Name:               <admin name>            
   User:               <admin username>
   Password:           <admin password>
   Email:              <admin email>
   

3. When you have checked that all of the installation details are correct, simply click on Install to finalize the installation.

NOTE: On FreeBSD 11, you may see a warning message that says "Unsupported Operating System". This is because some of the more advanced features may not work on FreeBSD, as they have not been tested on non-Linux operating systems. The installation will still work and you can still use Redaxscript CMS to publish sites on FreeBSD, but just be aware that you may run into a few problems down the line if you want to use some of the more advanced features.

Once the installation script has finished you will be redirected to a default sample web page. To access the admin section, simply scroll down to the bottom of the sample web page and click on the Login link at the bottom right hand corner of the page.

Alternatively, you can access the Login page by typing the address into your browser manually:

http://YOUR_VULTR_IP_ADDRESS/login

For security reasons, make sure you delete the install.php file and templates/install directory from the webroot directory immediately:

sudo rm -rf ./templates/install ./install.php

Also, make sure the config.php file is not writable:

sudo chmod 444 ./config.php

Lastly, visit console.php in your browser:

http://YOUR_VULTR_IP_ADDRESS/console.php

Enter the console lock command to revoke public access to the console.php page:

console lock

You are now ready to start adding your content and configuring the look and feel of your site. Make sure you check out the excellent Redaxscript CMS documentation for more information about how to build and configure your site.