☰
✕
✕

How to install webERP on OpenSUSE 42.3

To install webERP on OpenSUSE 42.3

In our erstwhile article, we have seen about the installation procedure of webERP on CentOS 7. In this article, we will see about the installation procedure of webERP on OpenSUSE 42.3. webERP is an open-source, web based accounting/ ERP system that uses only a web browser and a PDF reader. It contains a plethora of features that are suitable for many businesses in both large scale and small scale or retail management. It also contains Purchase orders, MRP, Multi-Currency, Standard Costing, Ghost bills, Expense claims, and PDF reports.


Pre-Requisite
- LAMP (Apache, PHP 7, MySQL)
- MySQL (create database and user and provide privileges to user)
- PHP 7 along with dependencies (php-mysql php-curl php-json php-cgi php php-mcrypt php-xmlrpc php-gd)

Installation procedure

To proceed with the installation procedure, download the latest stable version using wget command followed by the download link. 

linuxhelp:~ # wget https://excellmedia.dl.sourceforge.net/project/web-erp/webERP4.14.1.zip
--2017-10-31 11:51:35--  https://excellmedia.dl.sourceforge.net/project/web-erp/webERP4.14.1.zip
Resolving excellmedia.dl.sourceforge.net (excellmedia.dl.sourceforge.net)... 202.153.32.19
Connecting to excellmedia.dl.sourceforge.net (excellmedia.dl.sourceforge.net)|202.153.32.19|:443... connected.
HTTP request sent, awaiting response... 200 OK
Length: 30862574 (29M) [application/octet-stream]
Saving to: ‘ webERP4.14.1.zip’ 

100%[==============================================================================================================================================> ] 30,862,574   559KB/s   in 67s    

2017-10-31 11:52:42 (452 KB/s) - ‘ webERP4.14.1.zip’  saved [30862574/30862574]

Extract the downloaded package using unzip command. 

linuxhelp:~ # unzip webERP4.14.1.zip -d /srv/www/htdocs/
Archive:  webERP4.14.1.zip
   creating: /srv/www/htdocs/webERP/
  inflating: /srv/www/htdocs/webERP/AccountGroups.php  
  inflating: /srv/www/htdocs/webERP/AccountSections.php  
  inflating: /srv/www/htdocs/webERP/AddCustomerContacts.php  
  inflating: /srv/www/htdocs/webERP/AddCustomerNotes.php  
  inflating: /srv/www/htdocs/webERP/AddCustomerTypeNotes.php  
  inflating: /srv/www/htdocs/webERP/AgedControlledInventory.php  
  inflating: /srv/www/htdocs/webERP/AgedDebtors.php  
  inflating: /srv/www/htdocs/webERP/AgedSuppliers.php  
  inflating: /srv/www/htdocs/webERP/AnalysisHorizontalIncome.php  
  inflating: /srv/www/htdocs/webERP/AnalysisHorizontalPosition.php  
   creating: /srv/www/htdocs/webERP/api/
.
.
.
.
inflating: /srv/www/htdocs/webERP/Z_Upgrade_3.08-3.09.php  
  inflating: /srv/www/htdocs/webERP/Z_Upgrade_3.09-3.10.php  
  inflating: /srv/www/htdocs/webERP/Z_Upgrade_3.10-3.11.php  
  inflating: /srv/www/htdocs/webERP/Z_Upgrade_3.11-4.00.php  
  inflating: /srv/www/htdocs/webERP/Z_UploadForm.php  
  inflating: /srv/www/htdocs/webERP/Z_UploadResult.php

Move to Apache document root location by running the cd command and list the files in the directory. 

linuxhelp:~ # cd /srv/www/htdocs/
linuxhelp:/srv/www/htdocs # ll
total 32
drwxrwxrwx  2 wwwrun www   4096 Oct  9 23:15 gif
-rwxrwxrwx  1 wwwrun www   2356 Mar 18  2017 info2html.css
drwxr-xr-x 15 root   root 20480 Jun 26 12:59 webERP

Provide the appropriate owner permission and file execution permission by running the following command. 

linuxhelp:/srv/www/htdocs # chown -R wwwrun:www /srv/www/htdocs/
linuxhelp:/srv/www/htdocs # chmod -R 775 /srv/www/htdocs/

Create an Apache configuration file named web.conf and enter the following content in the file. Save and exit the file. 

linuxhelp:/srv/www/htdocs # vim /etc/apache2/conf.d/web.conf

< VirtualHost *:80> 
DocumentRoot " /srv/www/htdocs" 
ServerName www.linuxhelp1.com
< Directory " /srv/www/htdocs/" > 
DirectoryIndex index.php
Options FollowSymLinks
AllowOverride All
Require all granted
< /Directory> 
< /VirtualHost>

Restart the Apache service. 

linuxhelp:/srv/www/htdocs # systemctl restart apache

Switch over to the browser and enter the URL as http://www.linuxhelp1.com/webERP. The installation page of webERP is displayed on the screen. Select the required language and click NEXT STEP.

Fill the required database details and click NEXT STEP option.

Next fill the required company details such as company name, accounts file, timezone and company logo.

Enter the administrator account settings and click Install option.

The installation is complete and now the login page of webERP appears on the screen. Enter the required credentials and click Login option.

The Admin page of webERP is displayed as shown below.

The installation procedure of webERP on OpenSUSE 42.3 is done without any glitches.

Tag : OpenSUSE WebERP
FAQ
Q
How to import GL history and the chart details table (technical)?
A
There is foreign key checking on the chart details table such that there must always be a matching period record in the periods' table.

The balancing factor on the balance sheet is the retained earning account which is the sum of all the bfwd+actual for all profit and loss accounts as at the end of the period under review.
Q
The links on each page do not work I keep getting a page not found errors when selecting menu links?
A
Some installations appear not to be able to work out the value of the variable $rootpath using the line

$rootpath = dirname($_SERVER['PHP_SELF']
Q
What do we need to run OpenFlyers?
A
Just have a computer with internet access and a modern browser like Google Chrome, Firefox, Internet Explorer, Opera or Safari. No installation is required on the computer.
Q
What is webERP?
A
WebERP is an open source, web based accounting and business management tool for Small and Medium Enterprises. It supports almost all platforms and is very useful as an online shop or a retail management system for business.
Q
Each time I choose an option, anyone, I'm presented with the login screen again?
A
webERP uses sessions to store the access level of the user. Sessions allow information to be retained between web pages. Some installations of php do not have session support working by default.