Data Centers

How to install WebERP on Ubuntu 16.04

If you're looking for an ERP solution that won't break the bank, Jack Wallen shows you how to install WebERP on the Ubuntu Server platform.

weberphero.jpg
Image: Jack Wallen

Nearly every business relies on accounting and business management tools. When you start testing the waters of that arena, you'll find there are as many solutions as there are problems. You can go with a hosted solution; a straight-up, old-school client-server solution, or you can install an in-house web-based solution like WebERP in your data center. This particular take on the Enterprise Resource Planning (ERP) tool is a mature open-source system that provides best practise, multi-user business administration and accounting tools. WebERP is entirely web based, can run on any web-server that can accommodate PHP, produces reports in PDF format, and so much more.

I want to demonstrate how to get WebERP up and running on the Ubuntu Server 16.04 platform. This how to will assume you already have Ubuntu Server up and running, and is reachable on your network. With that said, let's install.

Installing the dependencies

The first thing we must do is prepare our server for the installation of WebERP. Open up a terminal window and update/upgrade with the following commands:

sudo apt update
​sudo apt upgrade

Do note that the above might upgrade your kernel (which would require a reboot). Because of this, you might want to schedule this when server downtime is acceptable.

Once the update/upgrade is complete, you need to install the AMP portion of the LAMP stack. If you already have a LAMP stack running, skip this section (and head to the database creation).

Install the server stack with the command:

sudo apt install apache2, php7.0 php7.0-cli php7.0-mysql php7.0-gd php7.0-mcrypt php7.0-json php-pear php-mbstring php-gd -y

Once that completes, start and enable Apache with the commands:

sudo systemctl start apache2
​sudo systemctl enable apache2

Personally, I prefer working with MySQL, but if you prefer MariaDB, you can install it with the following commands:

sudo apt-get 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'
sudo apt-get install mariadb-server mariadb-client -y

During the installation, you will be prompted to type and verify a root user password for the database (Figure A).

Figure A

Figure A

Setting a password for the database server.

Configure the database

Now we're going to create a database, a database user, and then give that user the necessary privileges. Gain access to the MySQL prompt with the command:

mysql -u root -p

Type the MySQL root user password and then create the database with the command:

CREATE DATABASE weberp_db;

Create a database user and password (to be used for WebERP) with the command:

CREATE USER 'weberp'@'localhost' IDENTIFIED BY 'PASSWORD';

Where PASSWORD is the password you will use for the new user.

Next we grant the proper privileges for the new user with the command:

GRANT ALL PRIVILEGES ON weberp_db.* TO 'weberp'@'localhost';

Flush the database privileges and exit the database with the commands:

flush privileges;
​exit;

Download and prep WebERP

Now we're going to download the WebERP file, extract it, move it, and give it the proper permissions. I'm going to warn you, the file is hosted on Sourceforge, whose current security certificate is invalid. To download the file with wget, you need to issue the following command:

wget --no-check-certificate https://excellmedia.dl.sourceforge.net/project/web-erp/webERP4.14.1.zip


If your server includes a GUI, you could always point your browser to the download pag, and snag it via standard HTTP.

Before you extract the file, you might need to install unzip. To do this, issue the command:

sudo apt install unzip

Once that installation completes, extract the file with the command:

unzip webERP4.14.1.zip

Move and rename the file with the following command:

sudo cp -r webERP /var/www/html/weberp

Give the file the proper permissions with the command:

sudo chown -R www-data:www-data /var/www/html/weberp

Configure Apache

For our next trick, we'll configure Apache to work with WebERP. First we must create a new virtual host file with the command:

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

Within that new file, add the following:

<VirtualHost *:80>
ServerAdmin admin@yourdomain.com
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>

Note: Customize the above file to meet your particular needs.

Now we must enable the new site with the command:

sudo a2ensite weberp

Restart Apache (so that it is aware of the new site) with the command:

sudo systemctl restart apache2

Install WebERP

Finally, point a browser to http://SERVER_IP/weberp to open the WebERP Install GUI (Figure B).

Figure B

Figure B

The WebERP installation GUI.

Select your language and click NEXT STEP. In the resulting window (Figure C), you must configure the database we created earlier. Enter that information and click NEXT STEP.

Figure C

Figure C

Configuring our database for WebERP.

In the final window (Figure D), configure the company settings. Make sure to scroll down to the bottom and change the admin user's password.

Figure D

Figure D

The WebERP Company Settings page.

Once you've configured your company settings, click the INSTALL button and wait for the installation to complete. When the installation finishes, you can then login with username admin and the password you created on the last screen and start working with WebERP.

Congratulations, your new ERP solution is ready to serve you from your data center. At this point, you will have quite a bit of work to do to get the system ready for daily usage. I highly recommend going through the WebERP online manual.

Also see

About Jack Wallen

Jack Wallen is an award-winning writer for TechRepublic and Linux.com. He’s an avid promoter of open source and the voice of The Android Expert. For more news about Jack Wallen, visit his website jackwallen.com.

Editor's Picks

Free Newsletters, In your Inbox