How to install SOPlanning on Ubuntu 18.04 LTS

SOPlanning is a free, open source and easy to use Online Planning tool specially designed to efficiently organize projects and tasks. You can assign work to each member of your team, regardless of your activity. SoPlanning also offers email notification, synchronization with Google Calendar and Outlook for greater efficiency. SoPlanning is an open source tool, so you can customize the logo and the colors correspond to your company. SoPlanning mostly used in the production plant, material reservation, online booking system, IT project management, Industrial production, Sales team and much more.

In this tutorial, I am going to explain how to install SOPlanning with Apache, MariaDB and PHP on Ubuntu 18.04 LTS server.

Requirements

  • A server running Ubuntu 18.04 LTS.
  • A non-root user with sudo privileges.

Install LAMP Server

Before starting, you will need to install Apache web server, MariaDB and PHP to your system. First, install Apache and MariaDB with the following command:

sudo apt-get install apache2 mariadb-server -y

Once the installation has been completed, you will need to add Ondrej PHP repository to your system. SoPlanning does not support PHP 7.2 yet, so we will install PHP 7.1 from Ondrej repository. You can add it with the following command:

sudo add-apt-repository ppa:ondrej/php

Press <ENTER>, when the PPA installer asks for confirmation. Next, install PHP with all the required dependencies by running the following command:

sudo apt-get install php7.1 php7.1-mysql php7.1-curl php7.1-json php7.1-cgi php7.1-recode php7.1-sq php7.1-intl libapache2-mod-php7.1 php7.1-mcrypt php7.1-xmlrpc php7.1-gd php7.1-mbstring php7.1 php7.1-common php7.1-xmlrpc php7.1-soap php7.1-xml php7.1-intl php7.1-cli php7.1-ldap php7.1-zip php7.1-readline php7.1-imap php7.1-tidy -y

Once all the packages are installed, start Apache and MariaDB service and enable them to start on boot time with the following command:

sudo systemctl start apache2
sudo systemctl enable apache2
sudo systemctl start mariadb
sudo systemctl enable mariadb

Create a database user and database for SoPlanning. Log in to MariaDB as root user:

mysql -u root -p

and create a new database and database user named 'soplanning' with password 'soplanning-pass'.

CREATE DATABASE soplanning;
GRANT ALL PRIVILEGES ON soplanning.* TO 'soplanning'@'localhost' IDENTIFIED BY 'soplanning-pass';
FLUSH PRIVILEGES;
quit

Install SoPlanning

First, download the latest version of SoPlanning from Source Forge using the following command:

cd /tmp
wget https://excellmedia.dl.sourceforge.net/project/soplanning/soplanning/v1.42/soplanning-1-42.zip

Next, unzip the downloaded file:

unzip soplanning-1-42.zip

Next, copy extracted directory to the Apache web root directory:

sudo cp -r soplanning /var/www/html/soplanning

Next, give proper ownership and permission with the following command:

sudo chown -R www-data.www-data /var/www/html/soplanning
sudo chmod -R 775 /var/www/html/soplanning

Configure Apache for SoPlanning

Next, you will need to create an Apache virtual host for SoPlanning. You can do this with the following command:

sudo nano /etc/apache2/sites-available/soplanning.conf

Add the following lines:

<VirtualHost *:80>
ServerName example.com
ServerAdmin [email protected]
DocumentRoot /var/www/html/soplanning/

<Directory /var/www/html/soplanning/>
AllowOverride All
Order allow,deny
allow from all
</Directory>

ErrorLog /var/log/apache2/soplanning_error.log
CustomLog /var/log/apache2/soplanning_custom.log combined

</VirtualHost>

Save and close the file, then enable Apache virtual host file and Apache rewrite module with the following command:

sudo a2ensite soplanning.conf
sudo a2enmod rewrite

Finally, restart Apache web service to apply the changes:

sudo systemctl restart apache2

Access SoPlanning

Now, open your web browser and type the URL http://example.com. You will be redirected to the following page:

Set database details

Here, provide the database name, your root user and root password, then click on the Launch install button. You should see the following page:

Installation finished

Now, click on the Click here button. You will be redirected to the SoPlanning login page:

Login to SoPlanning

Here, provide your admin username and password, then click on the Login button. You should see the SoPlanning dashboard in the following screen:

SoPlanning Dashboard

Virtual machine image download of this tutorial

This tutorial is available as ready to use virtual machine image in ovf/ova format that is compatible with VMWare and Virtualbox. The virtual machine image uses the following login details:

SSH / Shell Login

Username: administrator
Password: howtoforge

This user has sudo rights.

SoPlanning Login

Username: admin
Password: admin

MySQL Login

Username: root
Password: howtoforge

The IP of the VM is 192.168.1.100, it can be changed in the file /etc/netplan/01-netcfg.yaml. Please change all the above passwords to secure the virtual machine.

Share this page:

0 Comment(s)