image: Jack Wallen
basically every company depends on accounting and enterprise management tools. if you happen to start testing the waters of that enviornment, you will discover there are as many options as there are problems. that you may go together with a hosted solution; a straight-up, ancient-faculty client-server answer, or you can installation an in-apartment net-primarily based solution like WebERP to your statistics middle. This selected take on the commercial enterprise aid Planning (ERP) tool is a mature open-source equipment that gives highest quality practise, multi-consumer business administration and accounting equipment. WebERP is completely internet based mostly, can run on any internet-server that may accommodate Hypertext Preprocessor, produces experiences in PDF format, and so a whole lot greater.
I are looking to show a way to get WebERP up and working on the Ubuntu Server sixteen.04 platform. This the way to will anticipate you already have Ubuntu Server up and running, and is reachable to your network. With that noted, let’s set up.
setting up the dependencies
the primary factor we need to do is put together our server for the setting up of WebERP. Open up a terminal window and update/upgrade with right here instructions:
sudo apt update sudo apt improve
Do observe that the above could improve your kernel (which might require a reboot). on account of this, you may are looking to agenda this when server downtime is appropriate.
as soon as the update/upgrade is complete, you should install the AMP component of the LAMP stack. if you have already got a LAMP stack working, bypass this section (and head to the database advent).
deploy the server stack with the command:
sudo apt installation apache2, php7.0 php7.0-cli php7.0-mysql php7.0-gd php7.0-mcrypt php7.0-json Hypertext Preprocessor-pear personal home page-mbstring personal home page-gd -y
as soon as that completes, birth and permit Apache with the commands:
sudo systemctl delivery apache2 sudo systemctl enable apache2
in my opinion, I decide upon working with MySQL, but when you choose MariaDB, that you could installation it with right here instructions:
sudo apt-get deploy software-residences-normal -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.web/DB/mariadb/repo/10.1/ubuntu xenial leading' sudo apt-get deploy mariadb-server mariadb-customer -y
all over the installation, you may be brought about to type and assess a root user password for the database (figure A).
Configure the database
Now we’ll create a database, a database user, after which provide that consumer the imperative privileges. benefit access to the MySQL prompt with the command:
mysql -u root -p
category the MySQL root person password after which create the database with the command:
CREATE DATABASE weberp_db;
Create a database consumer and password (to be used for WebERP) with the command:
CREATE consumer 'weberp'@'localhost' recognized by way of 'PASSWORD';
where PASSWORD is the password you’re going to use for the brand new user.
subsequent we supply the proper privileges for the new person with the command:
supply 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, circulation it, and give it the appropriate permissions. i am going to warn you, the file is hosted on Sourceforge, whose present safety certificates is invalid. To download the file with wget, you should challenge here command:
wget --no-investigate-certificates https://excellmedia.dl.sourceforge.net/undertaking/internet-erp/webERP4.14.1.zip
in case your server includes a GUI, you might all the time aspect your browser to the down load pag, and snag it via standard HTTP.
before you extract the file, you may should set up unzip. To do that, subject the command:
sudo apt set up unzip
once that installing completes, extract the file with the command:
move and rename the file with the following command:
sudo cp -r webERP /var/www/html/weberp
give the file the relevant permissions with the command:
sudo chown -R www-facts:www-facts /var/www/html/weberp
For our subsequent trick, we will configure Apache to work with WebERP. First we ought to create a new virtual host file with the command:
sudo nano /and so forth/apache2/websites-purchasable/weberp.conf
within that new file, add the following:
<VirtualHost *:80> ServerAdmin [email protected] DocumentRoot "/var/www/html/weberp/" ServerName yourdomain.com ServerAlias www.yourdomain.com <directory "/var/www/html/weberp/"> alternatives FollowSymLinks AllowOverride All Order enable,deny allow from all </directory> ErrorLog /var/log/apache2/weberp-error_log CustomLog /var/log/apache2/weberp-access_log general </VirtualHost>
word: customise the above file to meet your certain needs.
Now we need to permit the brand new website with the command:
sudo a2ensite weberp
Restart Apache (so that it’s privy to the brand new website) with the command:
sudo systemctl restart apache2
at last, point a browser to http://SERVER_IP/weberp to open the WebERP installation GUI (determine B).
select your language and click subsequent STEP. in the resulting window (figure C), you have to configure the database we created prior. Enter that suggestions and click on next STEP.
within the last window (determine D), configure the company settings. make certain to scroll down to the bottom and change the admin user’s password.
when you’ve configured your enterprise settings, click the installation button and stay up for the installing to comprehensive. When the installing finishes, which you can then login with username admin and the password you created on the ultimate reveal and begin working with WebERP.
Congratulations, your new ERP solution is ready to serve you out of your statistics middle. At this factor, you could have rather a little bit of work to do to get the device ready for each day utilization. I enormously suggest going through the WebERP online manual.