Today, it is difficult for a business to achieve sustained growth without an application to help with management and planning. So today we will help you to install WebERP on Ubuntu 20.04
WebERP is an accounting and business management system designed for small and medium-sized enterprises (SMEs)2 with appropriate features for each of them. It is built with web technology and only requires a database manager and a functional web server.
Installation is simple, so let’s go for it.
Install LAMP on Ubuntu 20.04
Since this is a web application, we have to install the LAMP stack. This is easy because we just need to run the following command.
sudo apt install php php-mysql php-curl php-json php-cgi php-xmlrpc php-gd php-mbstring php-mbstring unzip mariadb-server apache2 libapache2-mod-php
Thanks to the previous command, we will not only install Apache and MariaDB, but we will also install PHP and the necessary modules so that WebERP can run smoothly on the server.
When everything is installed, we have to open ports 80 and 443 in the firewall.
sudo ufw allow 80/tcp
sudo ufw allow 443/tcp
After this, we need to secure the MariaDB installation. To achieve this, run.
sudo mysql_secure_installation
After logging in by pressing Enter because there is no password defined, you will be able to define the help without any problems. You will then be asked several questions regarding the server.
Remove anonymous users? [Y/n] Disallow root login remotely? [Y/n] Remove test database and access to it? [Y/n] Reload privilege tables now? [Y/n]
Answer all Y and we are done.
Create the new database and the user
With LAMP fully functional, we can then create the database and user for WebERP.
Access the console
sudo mysql -u root -p
Then, create the database, the user, the password. Then refresh the necessary permissions and exit the console.
CREATE DATABASE weberp;
GRANT ALL PRIVILEGES ON weberp.* TO 'user'@'localhost' IDENTIFIED BY 'userpss';
FLUSH PRIVILEGES;
exit;
You can replace the database name, username, and password with whatever you want.
Download WebERP on Ubuntu 20.04
To download WebERP we have to use the wget command, and it is recommended to do it from the /tmp/ directory.
cd /tmp/
wget https://sourceforge.net/projects/web-erp/files/webERP_4.15.2.zip
At the time of writing this post, the latest stable version of WebERP is 4.15.2. Please go to this site and check which is the latest and modify the command.
Decompress the downloaded file
sudo unzip webERP_4.15.2.zip -d /var/www/html
Set Apache to be the owner of the folder with the necessary permissions.
sudo chown www-data:www-data -R /var/www/html/webERP
sudo chmod 755 -R /var/www/html/webERP
Then create a new virtualhost for WebERP
sudo nano /etc/apache2/sites-available/weberp.conf
And add the following
<VirtualHost *:80>
DocumentRoot /var/www/html/webERP/
ServerName your-domain
<Directory /var/www/html/webERP/>
Options FollowSymLinks
AllowOverride All
Order allow,deny
allow from all
</Directory>
ErrorLog /var/log/apache2/erp-error_log
CustomLog /var/log/apache2/erp-access_log common
</VirtualHost>Save the changes.
Enable the new VirtualHost and the Apache and PHP rewrite module.
sudo a2ensite weberp
sudo a2enmod rewrite
Finally, restart Apache.
sudo systemctl restart apache2
Accessing WebERP
The next step is to open a web browser and visit http://your-domain to see the installation wizard.
First set the installation language.
Next, configure the database options with the parameters you created earlier.
Thereafter, it is time to set the company name, your logo, and the TimeZone. On the same screen, below you can create the admin user and to start the installation, click on Install.
You will then see the login screen
When you log in, you will see the control panel.
Conclusion
In this post, we have explained how to install WebERP on Ubuntu 20.04. This software can be of great help to many companies in their daily tasks. I hope it has helped you, and you can take advantage of it.
Share our post and help us to grow. It would be a great help to us.