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
So, it’s time to start work
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.
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
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
Now we can continue
Now we are ready to download the latest stable version of WebERP using the
To do this it is best to go to the
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, 184.108.40.206 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>
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
sudo a2ensite weberp sudo a2enmod rewrite sudo systemctl restart apache2
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
Now open your favorite web browser and go to
https://your-domain where you will see the welcome screen.
Choose the language and continue.
Now add the database parameters we created earlier.
The next step is to customize the installation by adding our company name and other things.
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.
And you will see the WebERP dashboard.
So, enjoy it.
WEbERP is a very efficient application to manage your company. The installation is easy to install and use and it’s free.