Learn How To Install WebERP 4.15.1 On A CentOS 8 Server In Minutes.
WEBERP is an absolutely free enterprise resource planning software that allows you to run your warehouse, distribution service or wholesale with ease. It is a open source system that can be downloaded and used for a lifetime and comes with no annual licensing fees. WebERP can also be intergrated with a third party point of sale system and can be used as a central hub in a dispersed multi branch business. WEBERP is built with many great features and functions which include, SALES & ORDERS, TAXES, ACCOUNTS RECEIVABLES, INVENTORY MANAGEMENT, PURCHASING, ACCOUNTS PAYABLE, BANKING AND GENERAL LEDGERS, MANUFACTURING, CONTRACT COSTING, MANAGEMENT OF FIXED ASSETS and so much more! WEBERP is an entirely web bases system and can run on any web server that can host PHP. If you are conserned about software support, WEB ERP has many software support options which include FREE support from volunteers, mailing lists, web forums, the WEBERP official software manual as well as commercial paid support. Continue reading this tutorial to learn how to install WEBERP 4.15.1 on a CENTOS 8 Server in MINUTES!
In order to complete this tutorial successfully, below is a detailed list of items that you may need. Please ensure to have these items available before taking implementation action on this tutorial:
1) A desktop or laptop with atleast a dual core processor, 4GB RAM and 100GB of free disk space
2) The CENTOS 8 disk image file (ISO file)
3) The WEBERP installation files.
4) The LAMP web server or any other web server that can host PHP files.
5) A web browser ( Google Chrome, Firefox, Microsoft Edge or Safari) and a PDF Reader.
6) A terminal emulation software such as PUTTY or TERRATERM (if using a Windows device)
1) Connect to the CENTOS Server, install CENTOS 8 updates and install the LAMP server.
2) Set a static IP address and configure MariaDB
3) Create a database for WEBERP then download WEBERP installation files using wget
4) Install WebERP and configure Apache
5) Point your domain to the WEBERP server and install a free letsencrypt SSL certificate.
6) Open the WEBERP web based interface and configure the MYSQL database settings.
Step 1: Connect To The CentOS 8 Server Install CENTOS 8 Updates And Install The LAMP Stack.
1) If you are using a Windows device for install WEBERP on a remote server or virtual machine, download the PUTTY terminal emulation software HERE.
Open PUTTY and on the HOSTNAME (OR IP ADDRESS) field enter the IP ADDRESS of the CENTOS 8 server. Ensure that the PORT is set to 22 then click on the OPEN button.
2) If you are using a MAC open the terminal application and run the command for connect to a terminal interface via SSH. The command should be in the format shown below.
3) run the following command to install system and package updates for your CENTOS 8 server:
yum update && yum upgrade
Install The LAMP Server.
3) The first step is to install a web server such as APACHE, a database management system such as MYSQL and a hyper-text preprocessor such as PHP. Run the following command to to install these three items:
dnf install httpd mariadb-server php php-mysqli php-curl php-json php-cgi php-xmlrpc php-gd php-mbstring unzip -y
Start the APACHE and MARIADB services and set them to start at system boot by running the following commands:
systemctl start httpd mariadb
systemctl enable httpd mariadb
4) Add the following firewall rules to permit network connections to be made to the server on http port 80 and https port 443:
sudo firewall-cmd –permanent –add-service=http
sudo firewall-cmd –permanent –add-service=https
then reload the firewall service by running the following command:
sudo firewall-cmd –reload
Step 2: Set A Static IP Address And Configure Maria-DB
5) To set a static IP address on CENTOS 8 you need to edit the network configuration file for the network interface. Run the following command to go to the directory for network configuration files:
Then the the following command to list the contents of this directory:
ls – l
6) Run the following command to edit the network interface configuration file using the nano text editor:
The name of this file may vary from the one thats on your CENTOS 8 server.
Add the following configuration in to this file, specifying parameters for your network then Press CNTRL + O then CNTRL + X to apply changes:
7) The next step is to configure the MARIA-DB database engine. In this configuration you are going to set a MariaDB root password and to secure the MariaDB installation. Run the following command to perform the configuration:
8) There are some questions that the script will ask you and below are the responses that we recommend you to enter:
Enter current password for root (enter for none):
Set root password? [Y/n] Y
Re-enter new password:
Remove anonymous users? [Y/n] Y
Disallow root login remotely? [Y/n] Y
Remove test database and access to it? [Y/n] Y
Reload privilege tables now? [Y/n] Y
All done! If you’ve completed all of the above steps, your MariaDB
installation should now be secure.
Thanks for using MariaDB!
Step 3: Create A Database For WebERP And Download Installation Files Using Wget.
9) The next step is to create a MYSQL database for WEBERP that will be using to store and retrieve all application data. Start by running the following command to login to the MARIADB shell:
mysql -u root -p
Once you have logged in run the following commands to create a WEBERP database as well as a database user:
MariaDB [(none)]> create database WEBERP;
MariaDB [(none)]> create user weberp@localhost identified by ‘weberppassword’;
10) Next, grant all database privileges to the weberp database user by running the following command:
MariaDB [(none)]> grant all privileges on WEBERP.* to weberp@localhost identified by ‘weberppassword’;
Then flush the privileges and exit out of the MARIADB shell by running the following commands:
MariaDB [(none)]> flush privileges;
MariaDB [(none)]> exit;
11) The next step is to download WEBERP from the internet on your CENTOS 8 server using wget. To do this run the following command:
If this download link is not working for you, click HERE to go to the WEBERP download page. Click on the download button, copy the download link and use wget to download the file.
NB: If you do not have the wget package run the following command to install it:
yum install wget
Step 4: Install WebERP And Configure Apache.
12) Unzip the WEBERP archive file to the /var/www/html directory by running the following command:
unzip webERP_4.15.1.zip -d /var/www/html
13) Next, set the owner of the WEBERP folder in the /var/www/html directory to the apache user and set file permissions to 755 by running the following commands:
chown -R apache:apache /var/www/html/webERP
chmod -R 755 /var/www/html/webERP
Step 5: Configure Apache For WEBERP.
14) Create an apache virtual host configuration file with information on how the apache web server should respond to WEBERP web requests. To create this file run the following command as root user:
15) Add the following configuration to the weberp.conf file. When you are done editing this file, press CTRL + O then CTRL + X on your keyboard
<VirtualHost *:80> ServerAdmin email@example.com DocumentRoot /var/www/html/webERP ServerName weberp.example.com <Directory /var/www/html/webERP/> Options FollowSymLinks AllowOverride All Order allow,deny allow from all </Directory> ErrorLog /var/log/httpd/weberp.org-error_log CustomLog /var/log/httpd/weberp.org-access_log common </VirtualHost>
16) Next restart the apache web server service and check the status of the apache web server service by running the following commands:
1) systemctl restart httpd
2) systemctl status httpd
The second command should return results that are shown in the image on the right.
Step 6: Point Your Domain To The WebERP Server And Install A Free Letsencrypt SSL Certificate.
17) Letsencrypt is a free and open SSL certificate authority run by the Internet Security Research Group (ISRG) that allows almost anyone to install an SSL certificate on almost any website or server on demand. Letsencrypt SSL certificate are only valid for 90 days and need to be renewed after that 90 day period. The certbot SSL client is also needed to install a letsencrypt SSL certificate. Run the following commands to install CERTBOT on the WEBERP server:
1)sudo dnf install epel-release.
2)dnf install letsencrypt python3-certbot-apache.
Then run the following command to obtain and install an SSL certificate:
certbot –apache -d weberp.yourdomainname.com
Step 7: Open the WEBERP Web interface And Configure The MYSQL Database Settings.
18) Open a web browser, enter the IP address of the WEBERP server in the address bar and press ENTER.
Select your desired language on the LANGUAGE drop down menu and click on NEXT STEP.
20) On the DATABASE SETTINGS page, enter your hostname, dattabase name database username and database password on the spaces provided then click on NEXT STEP
21) On the COMPANY SETTINGS page, enter the name of your organization of the COMPANY NAME field, choose default.sql on the CHART OF ACCOUNTS drop down, set a COMPANY LOGO and click on NEXT STEP
22) On the INSTALLATION OPTION page, enter the username, password and email address for the WEBERP system administrator account and click on INSTALL
22) Once the installation process is complete a weberp login page will be displayed. Select the name of your company on the COMPANY dropdown, enter your weberp administrator username and password and click on LOGIN
22) The weberp dashboard will be displayed and you can now start using the system to manage your business.