How To Install WebERP on Ubuntu

In this tutorial, we explain all the steps you must follow to know how to download, install and configure webERP on Ubuntu 17

What is WebERP?

WebERP is a complete system based on a web accounting and business management environment which only requires a web browser and a pdf reader for immediate use, which makes it a simple and functional alternative.

Next, we will see how to install and use WebERP in Ubuntu 17.04.

Update Ubuntu & Install LAMP Server

The first step is to update the packages installed in the system and for this we will execute the following lines:

sudo apt update
sudo apt upgrade

The WebERP application runs on Apache, is written in PHP and uses MySQL to store the database, therefore we must install Apache, PHP and MariaDB in the operating system for the optimal functioning of WebERP.

We will run the following line to install Apache, PHP and the required PHP libraries:

sudo apt install apache2 php7.0 php7.0-cli php7.0-mysql php7.0-gd php7.0-mcrypt php7.0-json php-pear -y.0 php7.0-cli php7.0-mysql php7.0-gd php7.0-mcrypt php7.0-json php-pear -y

Once the installation is complete we proceed to start the Apache service and enable it from the system start by executing the following:

sudo systemctl start apache2
sudo systemctl enable apache2

Install MariaDB in Ubuntu

By default, the latest version of MariaDB is not available in Ubuntu 17.04, for this reason, it will be necessary to add the MariaDB repository to your system by executing the following lines:

sudo apt install software-properties-common -y
sudo apt-key adv --recv-keys --keyserver hkp://keyserver.ubuntu.com:80 0xF1656F24C74CD1D8
sudo add-apt-repository 'deb [arch=amd64,i386,ppc64el] http://www.ftp.saix.net/DB/mariadb/repo/10.1/ubuntu xenial main'

We update the repository packages by executing:

sudo apt update -y

We install the MariaDB server by executing the following:

sudo apt install mariadb-server mariadb-client -y

During the installation process, the following message will be displayed where we will define the password of the MariaDB root user:

Enter the password, press Enter and we must confirm it again. Press Enter and continue the installation process of MariaDB

We start the MySQL service and enable it to start the system by executing the following lines:

sudo systemctl start mysql
sudo systemctl enable mysql

Configure MariaDB in Ubuntu

The next step is to ensure the installation of MariaDB and for this we will execute the following script:

sudo mysql_secure_installation

The previous script will set the root password, remove anonymous users, prohibit remote root logon, and delete the test database.

Once the MariaDB server is protected, we must enter the MySQL console and create a database for WebERP by executing the following:

mysql -u root -p

We will enter the root password and create a database according to the need with the following line:

CREATE DATABASE weberp_db;

Now, we will create a username and password for WebERP with the following command:

CREATE USER 'weberp'@'localhost' IDENTIFIED BY 'password';

Now we will grant privileges to the weberp database by executing the following:

GRANT ALL PRIVILEGES ON weberp_db.* TO 'weberp'@'localhost';

We will load the privileges by executing:

flush privileges;

We exit the database by executing the line:

exit;

Download WebERP in Ubuntu

The next step is to download the latest version of WebERP from its official website with the wget command, executing the following:

wget https://excellmedia.dl.sourceforge.net/project/web-erp/webERP4.14.1.zip
Note: The current version is 4.14.1, before executing the command we can visit the website to check if there is one more recent.

We proceed to extract the downloaded content by executing the following:

unzip webERP4.14.1.zip

Once the content is extracted, we will copy the extracted directory in the Apache web root directory:

sudo cp -r webERP /var/www/html/weberp

Now we will change the property of the weberp directory:

sudo chown -R www-data:www-data /var/www/html/weberp

Apache Config for WebERP

At this point we are going to create an apache virtual host file for WebERP by executing the following:

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

In the new file we will paste the following lines:

<VirtualHost *:80>
ServerAdmin [email protected]
DocumentRoot "/var/www/html/weberp/"
ServerName yourdomain.com
ServerAlias ​​www.yourdomain.com
<< Directory "/var/www/html/weberp/">
Options FollowSymLinks
AllowOverride All
Order allow, deny
allow from all
</ Directory>
ErrorLog /var/log/apache2/weberp-error_log
CustomLog /var/log/apache2/weberp-access_log common
</ VirtualHost>

Save the changes using the Ctrl + O keys and exit the editor using the Ctrl + X keys.

Now we must activate the new virtual host with the following command:

sudo a2ensite weberp

Restart Apache by executing the following:

sudo systemctl restart apache2

Ubuntu Firewall Config & Access to WebERP

WebERP runs on port 80, so it will be necessary to configure the firewall to allow port 80 through it.

For this we will execute the following lines:

sudo ufw enable
sudo ufw allow 80/tcp
sudo ufw status

Once configured this we go to a browser and enter the following:

http://ip_address/weberp

There the following windows will be displayed.

First, we select the installation language

Then we enter the database that we have created before:

Then we define the time zone, company data and others:

When clicking on Install, WebERP will be installed in the system and then we can access by entering the respective credentials.

When we access the panel we will see the following:

From there we can configure the parameters as necessary.

In this way, WebERP is an ally for proper business management.

Similar Posts

Leave a Reply

Your email address will not be published. Required fields are marked *