29.8 C
Texas
angeloma
Senior Writer and partner

How to install WebERP on Ubuntu 20.04?

Hello, friends. In this post, we will talk about WebERP which is a useful application for running a company. So, today you will learn how to install WebERP on Ubuntu 20.04 and you will do it using LAMP as a base.

According to the project website:

webERP is a complete web-based accounting and business management system that requires only a web browser and pdf reader to use. It has a wide range of features suitable for many businesses particularly distributed businesses in wholesale, distribution, and manufacturing.

There are 33 different language translations available all included in the archive with users all over the world.

Some of the main goals that the project planned and achieved are:

  • Fast, web-based, integrated “best practice” business administration software.
  • “Low footprint” efficient and fast, with absolutely minimal network traffic
  • Platform Independence with no reliance on any propriety technologies
  • Scripts are easily readable and modifiable by a business
- Advertisement -

So, it’s time to start work

Install WebERP on Ubuntu 20.04

For this post, you will need a server or computer with Ubuntu 20.04. Any modern processor with 1Gb of RAM should be enough although the more resources the better the performance.

Install LAMP on Ubuntu 20.04

WebERP is an ERP created with PHP and requires a database manager like MariaDB to store the data. So you can use a typical installation of LAMP on Ubuntu 20.04 Check our post, so you can do it without problems.

Also, be sure to install these additional packages to compile the post.

php php-mysql php-curl php-curl php-curl php-json php-cgi php-xmlrpc php-gd php-mbstring unzip

Creating a new database and user for WebERP

Now it is necessary to create a new database for WebERP to store all the necessary information. Also, it is advisable to create a user and assign sufficient permissions to it.

So, open the MariaDB shell:

sudo mysql -u root -p

And create the database:

CREATE DATABASE weberpdb;

Now the user and the permissions on the database:

GRANT ALL PRIVILEGES ON weberpdb.* TO 'weberpuser'@'localhost' IDENTIFIED BY 'password';
FLUSH PRIVILEGES;

Finally, exit the shell

exit;

Now we can continue

Download and install WebERP on Ubuntu 20.04

Now we are ready to download the latest stable version of WebERP using the wget command.

To do this it is best to go to the /tmp folder.

cd /tmp/
wget https://sourceforge.net/projects/web-erp/files/webERP_4.15.zip
HTTP request sent, awaiting response... 302 Found
Location: https://kumisystems.dl.sourceforge.net/project/web-erp/webERP_4.15.zip [following]
--2021-07-27 17:49:26--  https://kumisystems.dl.sourceforge.net/project/web-erp/webERP_4.15.zip
Resolving kumisystems.dl.sourceforge.net (kumisystems.dl.sourceforge.net)... 2a01:4f8:210:1057::2, 148.251.120.111
Connecting to kumisystems.dl.sourceforge.net (kumisystems.dl.sourceforge.net)|2a01:4f8:210:1057::2|:443... connected.
HTTP request sent, awaiting response... 200 OK
Length: 32397871 (31M) [application/octet-stream]
Saving to: ‘webERP_4.15.zip’

webERP_4.15.zip                           100%[=====================================================================================>]  30.90M  39.0MB/s    in 0.8s

2021-07-27 17:49:27 (39.0 MB/s) - ‘webERP_4.15.zip’ saved [32397871/32397871]

Once the download is complete, decompress it to the Apache root directory.

sudo unzip webERP_4.15.zip -d /var/www/html

Now make apache the owner of the folder and make it have proper permissions.

sudo chown www-data:www-data -R /var/www/html/webERP
sudo chmod 755 -R /var/www/html/webERP

For Apache to better handle WebERP it is convenient to create a new Virtualhost. So, do it.

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

And add the following

<VirtualHost *:80>
    ServerAdmin [email protected]
    DocumentRoot /var/www/html/webERP/
    ServerName erp.osradar.test

    <Directory /var/www/html/webERP/>
        Options FollowSymLinks
        AllowOverride All
        Order allow,deny
        allow from all
    </Directory>

    ErrorLog /var/log/apache2/erp.osradar.test-error_log
    CustomLog /var/log/apache2/erp.osradar.test-access_log common
</VirtualHost>
1.- Creating a new Virtualhost for Weberp
1.- Creating a new Virtualhost for Weberp

Remember to change the values of ServerName to your domain and ServerAdmin to the correct information.

Save the changes and close the text editor.

Now enable the new Virtualhost and the Apache rewrite module.

sudo a2ensite weberp
sudo a2enmod rewrite
sudo systemctl restart apache2

Optional: Secure WebERP with Let’s Encrypt

If you are going to use WebERP on the Internet then you should install Let’s Encrypt certificates and enable HTTPS on the whole connection.

So, install certbot and its Apache plugin.

sudo apt install certbot python3-certbot-apache

Now you just need to generate the certificate for your website as follows

sudo certbot --apache --d [your-domain]

You will have to enter your domain and email address and accept the license terms.

In the end, you can restart Apache to complete the process.

sudo systemctl restart apache2

Complete the WebERP installation on Ubuntu 20.04

Now open your favorite web browser and go to https://your-domain where you will see the welcome screen.

2.- Select the installation language
2.- Select the installation language

Choose the language and continue.

Now add the database parameters we created earlier.

3.- Configuring the database
3.- Configuring the database

The next step is to customize the installation by adding our company name and other things.

4.- Installing WebERP on Ubuntu 20.04
4.- Installing WebERP on Ubuntu 20.04

On this screen, you can also create the admin account and its password.

Then the installation will start and at the end, you will have to log in.

5.- WebERP login screen
5.- WebERP login screen

And you will see the WebERP dashboard.

6.- WebERP dashboard on Ubuntu 20.04
6.- WebERP dashboard on Ubuntu 20.04

So, enjoy it.

Conclusion

WEbERP is a very efficient application to manage your company. The installation is easy to install and use and it’s free.

LEAVE A REPLY

Please enter your comment!
Please enter your name here

Latest article