OpenMAINT is an application created to hep you with the management of industrial facilities, real estate assets, furniture, infrastructures and related maintenance activities. With this tool you are able to know, organize and keep property related updates and support managing authority’s decision and operative activities. In this article we cover the installation and configuration of OpenMAINT on Debian 10 (Buster).

OpenMAINT tool can be adopted by companies on manufacturing, Financial institutions, Health sector, Government institutions to organize inventory and complete supply chain as well as management of issues and problems along the path. OpenMAINT is a web-based application with powerful web management dashboard.

Before you begin this installation confirm that you have an access to Debian Server via SSH or direct console to the operating system. An internet access is also required since the packages are pulled from online repositories. Login to the server as user with sudo privileges and begin installation.

Step 1: Update and Upgrade OS

Start by upgrading OS packages:

sudo apt update
sudo apt upgrade -y

Once the upgrade is complete you can reboot the machine:

sudo reboot

Step 2: Install Java / Tomcat and PostgreSQL database

Java and PostgreSQL database are the most critical dependencies that should be installed on the server.

Install Java dependencies:

sudo apt update
sudo apt install default-jdk -y

Confirm Java installation by checking the version:

$ java -version
openjdk version "11.0.11" 2021-04-20
OpenJDK Runtime Environment (build 11.0.11+9-post-Debian-1deb10u1)
OpenJDK 64-Bit Server VM (build 11.0.11+9-post-Debian-1deb10u1, mixed mode, sharing)

Next we install PostgreSQL 10 database server:

sudo apt update
sudo apt -y install gnupg2
wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add -
echo "deb http://apt.postgresql.org/pub/repos/apt/ `lsb_release -cs`-pgdg main" |sudo tee  /etc/apt/sources.list.d/pgdg.list
sudo apt update
sudo apt install postgresql-13 postgresql-client-10 postgresql-10-postgis-3 libpostgis-java

Proceed with the installation:

The following NEW packages will be installed:
  gdal-data libaec0 libarmadillo9 libarpack2 libblas3 libboost-atomic1.67.0 libboost-chrono1.67.0 libboost-date-time1.67.0 libboost-filesystem1.67.0
  libboost-program-options1.67.0 libboost-serialization1.67.0 libboost-test1.67.0 libboost-thread1.67.0 libboost-timer1.67.0 libcgal13 libcharls2
  libcommon-sense-perl libcurl3-gnutls libdap25 libdapclient6v5 libdapserver7v5 libepsilon1 libfreexl1 libfyba0 libgdal20 libgdbm-compat4 libgdbm6 libgeos-3.7.1
  libgeos-c1v5 libgeotiff2 libgfortran5 libgmpxx4ldbl libhdf4-0-alt libhdf5-103 libjson-perl libjson-xs-perl libkmlbase1 libkmlconvenience1 libkmldom1
  libkmlengine1 libkmlregionator1 libkmlxsd1 liblapack3 libltdl7 libmariadb3 libminizip1 libmpfr6 libnetcdf13 libnghttp2-14 libodbc1 libogdi3.2 libopenjp2-7
  libperl5.28 libpoppler82 libpostgis-java libpostgresql-jdbc-java libpq5 libproj13 libprotobuf-c1 libqhull7 libquadmath0 librtmp1 libsfcgal1 libspatialite7
  libssh2-1 libsuperlu5 libsz2 libtypes-serialiser-perl liburiparser1 libxerces-c3.2 mariadb-common mysql-common odbcinst odbcinst1debian2 perl
  perl-modules-5.28 pgdg-keyring poppler-data postgresql-10 postgresql-10-postgis-3 postgresql-10-postgis-3-scripts postgresql-13 postgresql-client-10
  postgresql-client-13 postgresql-client-common postgresql-common proj-bin proj-data ssl-cert sysstat xz-utils
0 upgraded, 91 newly installed, 0 to remove and 12 not upgraded.
Need to get 69.4 MB of archives.
After this operation, 311 MB of additional disk space will be used.
Do you want to continue? [Y/n] y

Step 3: Install OpenMAINT on Debian 10 (Buster)

After the installation of PostgreSQL and Java proceed to download OpenMAINT to your local system.

Install wget and unzip tools:

sudo apt install wget unzip -y

Then check for the latest release of OpenMAINT.

wget https://sourceforge.net/projects/openmaint/files/2.1/Core%20updates/openmaint-2.1-3.3.2/openmaint-2.1-3.3.2.war

Then openMAINT file we downloaded includes:

  • the data model suggested in the variants:
    • with demo data
    • no data (with / without predisposition GIS)
  • workflows for managing maintenance
  • reports for monitoring data

Set the password for postgres database admin user:

$ sudo passwd postgres
New password: StrongPassword
Retype new password: StrongPassword
passwd: password updated successfully

Alter role thereafter:

$ sudo su - postgres
[email protected]:~$ psql -d template1 -c "ALTER USER postgres WITH PASSWORD 'StrongPassword';"
ALTER ROLE
[email protected]:~$ exit
logout

Run the script downloaded:

$ java -jar ./openmaint-2.1-3.3.2.war install

Tomcat installation configutation:

loading jars .................................................................................................................. done

CMDBuild interactive install wizard - welcome!

this wizard will guide you in the process of installing and configuring a new instance of CMDBuild!


tomcat install location </root/cmdbuild_30> :

tomcat http port <8080>:
tomcat shutdown port (offset already applied) <8005>:
tomcat debug port (offset already applied) <8000>:

Configure PostgreSQL database connection:

postrgres db <localhost:5432> :
postrgres admin account <postgres/postgres> : postgres/StrongPassword
WARNING: server version 11.0.12 is not supported, you may encounter problems
cmdbuild posrgres database name <cmdbuild_ddd8> :
database dump to load <demo> :

If all is okay press ENTER to proceed with the installation:

we're ready to begin, this is your configuration:

	 tomcat: /root/cmdbuild_30
	 http port: 8080
	 shutdown port: 8005
	 debug port: 8000
	 postgres database: localhost:5432/cmdbuild_ddd8
	 database dump: demo.dump.xz

if everything is ok, press ENTER to begin installation
<press enter to begin>

Installation begins immediately:

BEGIN installation
install tomcat...
OK
create database...
create database cmdbuild_3487 demo.dump.xz
apply patches
adjust configs
done
OK

cmdbuild successfully installed! you can find startup/shutdown scripts in dir /root/cmdbuild_30/bin

Step 4: Start Tomcat Server and openMAINT

The startup script and shutdown scripts are located in $HOME/cmdbuild_30/bin directory:

$ ls $HOME/cmdbuild_30/bin

Let’s start the tomcat server:

$ $HOME/cmdbuild_30/bin/startup.sh
Using CATALINA_BASE:   /root/cmdbuild_30
Using CATALINA_HOME:   /root/cmdbuild_30
Using CATALINA_TMPDIR: /root/cmdbuild_30/temp
Using JRE_HOME:        /usr
Using CLASSPATH:       /root/cmdbuild_30/bin/bootstrap.jar:/root/cmdbuild_30/bin/tomcat-juli.jar
Using CATALINA_PID:    /root/cmdbuild_30/bin/catalina.pid
Tomcat started.

Once Tomcat server has been started access openMAINT Dashboard on:

http://serverip_or_hostname:8080/cmdbuild/

You’re presented with the login screen.

Use default credentials:

# Admin
Username: admin
Password: admin

# Demo account
Username: demouser
Password: demouser

Enjoy using OpenMAINT on Debian 10 (Buster) Linux system.

More articles available in our website:

Manage PostgreSQL Database Server Using DBeaver

Install Concrete5 CMS with Apache on Ubuntu

How To Provision and Run Vagrant VMs on Hyper-V

LEAVE A REPLY

Please enter your comment!
Please enter your name here