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:
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:
We exit the database by executing the line:
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:
We proceed to extract the downloaded content by executing the following:
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:
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.