SOPlanning is a free, open source and easy-to-use online scheduling tool specially designed to efficiently organize projects and activities. You can assign work to each member of your team, regardless of your activity. SoPlanning also offers e-mail notifications, synchronization with Google Calendar and Outlook for greater efficiency. SoPlanning is an open source tool, so you can customize your logo and colors to match your business. SoPlanning mainly used in the production plant, booking material, online booking system, IT project management, industrial production, sales team and much more.
In this tutorial, I'm going to explain how to install SOPlanning with Apache, MariaDB and PHP on the Ubuntu 18.04 LTS server.
- A server with Ubuntu 18.04 LTS.
- A non-root user with sudo privileges.
Install the LAMP server
Before starting, you need to install the Apache, MariaDB, and PHP Web server on the server. First, install Apache and MariaDB with the following command:
sudo apt-get install apache2 mariadb-server -y
Once the installation is complete, you will need to add the Ondrej PHP repository to your system. SoPlanning does not yet support PHP 7.2, so we will install PHP 7.1 from the Ondrej repository. You can add it with the following command:
sudo add-apt-repository ppa: ondrej / php
sudo apt-get install 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 have been installed, start the Apache and MariaDB service and activate them with the following command:
sudo systemctl starts apache2
sudo systemctl enables apache2
sudo systemctl start mariadb
sudo systemctl enables mariadb
Create a database user and a database for SoPlanning. Access MariaDB as the root user:
mysql -u root -p
and create a new database and database user called & # 39; soplanning & # 39; with password & # 39; soplanning-pass & # 39 ;.
CREATE THE DATABASE soplanning;
GRANT ALL PRIVILEGES ON soplanning. * TO & # 39; soplanning & # 39; @ & # 39; localhost & # 39; IDENTIFIED BY & # 39; soplanning-pass & # 39 ;;
First, download the latest version of SoPlanning from Source Forge using the following command:
cd / tmp
Then, unzip the downloaded file:
Then, copy the extracted directory to the Apache Web root directory:
sudo cp -r soplanning / var / www / html / soplanning
Next, provide the correct property 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 it with the following command:
sudo nano /etc/apache2/sites-available/soplanning.conf
Add the following lines:
ServerName example.com ServerAdmin [email protected] DocumentRoot / var / www / html / soplanning / AllowOverride All Allow the order, deny allow everyone ErrorLog /var/log/apache2/soplanning_error.log CustomLog /var/log/apache2/soplanning_custom.log joined
Save and close the file, then enable the Apache virtual host file and the Apache rewrite module with the following command:
sudo a2ensite soplanning.conf
sudo a2enmod rewrite
Finally, restart the Apache Web service to apply the changes:
sudo systemctl restart apache2
Log in to SoPlanning
Now open the web browser and type in the URL http://example.com. You will be redirected to the following page:
Here, provide the database name, the root user and the root password, and then click the Start Installation button. You should see the following page:
Now, click on the Click here button. You will be redirected to the SoPlanning login page:
Here, provide the user name and password of the administrator, and then click the Login button. You should see the SoPlanning dashboard in the following screen:
Download images of virtual machines of this tutorial
This tutorial is available as a virtual machine image ready for use in an ovf / ovo format compatible with VMWare and Virtualbox. The image of the virtual machine uses the following login details:
SSH / Shell access
This user has sudo rights.
Access to SoPlanning
The IP of the VM is 192.168.1.100, it can be modified in the file /etc/netplan/01-netcfg.yaml. Please change all the above passwords to protect the virtual machine.