Confluence has been updated to version 6.15.9

Overview

The Exalate Server for HP ALM/QC hosts the applications to translate the HP ALM/QC defect information to a common format and the way around.

The application requires JAVA and PostgreSQL.

Steps to install the Exalate Server for HP ALM/QC (or HPQCNODE) 


Install and configure the database server (PostgreSQL 9.6)

Please follow the steps to install PostgreSQL on the exalate server as documented here https://wiki.postgresql.org/wiki/YUM_Installation
Ensure that

  • the database server comes up when the server is booted
  • the data directories are included in the backup strategy

Enable PostgreSQL to accept login with password

http://stackoverflow.com/questions/4328679/how-to-configure-postgresql-so-it-accepts-loginpassword-a...

You will need to modify /var/lib/pgsql/9.6/data/pg_hba.conf to require md5 for local IPv4 connections, such at the end of the file it does look like 

# TYPE  DATABASE        USER            ADDRESS                 METHOD
# "local" is for Unix domain socket connections only such as postgres
local   all             all                                     trust
# IPv4 local connections:
host    all             all             127.0.0.1/32            md5


Restart the database 

 systemctl restart postgresql-9.6.service 

Installing OpenJDK 

  • Needs Exalate for HPQC version 5.0 and higher
  • For version lower than 5.0, please deploy Oracle Java version 1.8

Commands extracted from  https://www.liquidweb.com/kb/install-java-8-on-centos-7/

#refresh repos
yum -y update

#install the openjdk - latest version in the 8 family
yum install java-1.8.0-openjdk

#ensure it is being used - choose the openjdk
update-alternatives --config java


#update the java home in your .bash_profile by adding (the openjdk path depends on what was installed)
export JAVA_HOME=/usr/lib/jvm/java-1.8.0-openjdk-1.8.0.242.b08-0.el7_7.x86_64
export JAVA_JRE=$JAVA_HOME/jre
export PATH=$PATH:@JAVA_JRE/bin/



Install the Exalate server for HP ALM/QC

 You can download the Exalate server for HP ALM/QC RPM from here

Install the latest version of the Exalate app for HP ALM/QC :

# the version number will differ
yum localinstall exalate-hpqcnode-5.0.7.noarch.rpm


This will create these files:

  • /opt/hpqcnode/data → Contains configuration files
    • /opt/hpqcnode/logs → Contains log files
  • /opt/hpqcnode/install → contains all the files (binaries) which are necessary for the application to run 
  • /etc/init.d/hpqcnode → Script which will allow start, stop and restart hpqcnode application
  • /etc/sysconfig/hpqcnode → System properties

Copy dist files into prod files

cp /etc/sysconfig/hpqcnode.dist /etc/sysconfig/hpqcnode
cp /etc/init.d/hpqcnode.dist /etc/init.d/hpqcnode
cp /opt/hpqcnode/data/hpqcnode.conf.dist /opt/hpqcnode/data/hpqcnode.conf
cp /opt/hpqcnode/data/logger.xml.dist /opt/hpqcnode/data/logger.xml


Adapt configuration files

Adapt /etc/init.d/hpqcnode RUN_AS_USER variable to point to a valid user which will be running the application

...
#
#

# Script arguments (start, stop, restart or status)
COMMAND=$1

# ***********************************************
# *************  Set these variables  ***********

RUN_AS_USER=root // Set the user that would be running the application
NAME=hpqcnode
HOME_DIR=/opt/hpqcnode
DATA_DIR=$HOME_DIR/data
APP_DIR=$HOME_DIR/install
SYSCONFIG=/etc/sysconfig/hpqcnode

# ***********************************************

# stop if no configuration available
if [ ! -f "$SYSCONFIG" ]; then printf "no config present ... exiting\n"; exit 1; fi
...


Adapt /etc/sysconfig/hpqcnode parameters: 

# ---------
# Data Base specifics
DHPQCNODE_PG_USER=idalko
DHPQCNODE_PG_PWD=idalko
DHPQCNODE_PG_HOST=localhost
#DHPQCNODE_PG_HOST="localhost:5432"
DHPQCNODE_PG_DB=hpqcnode
# ---------
# OS User Name
# Name of the OS User to run the app with
DHPQCNODE_SYS_USER=root
# ---------
# Port specifics
DHPQCNODE_PORT=9000
# ---------
# SMTP specifics
DHPQCNODE_SMTP_HOST_NAME=mail.server.com
DHPQCNODE_SMTP_PORT=465
DHPQCNODE_SMTP_FROM=admin@admin.com
DHPQCNODE_SMTP_USER=admin
DHPQCNODE_SMTP_PASS=1234567
DHPQCNODE_SMTP_SSL=true
# ---------

Start the application

/etc/init.d/hpqcnode start


Troubleshooting

Problems during the installation using yum

If you have problems during installation of the Exalate server for HP ALM/QC using yum, you can find logs describing possible problem inside /tmp The name for this file is generated randomly automatically by the OS but you should be able to find the file based on the creation date.

In case of  'yum list postgresql*' error refer to the troubleshooting article.

Problems while running the Exalate server for HP ALM/QC

Logs will be generated under the directory: /opt/hpqcnode/data/logs. Refer to these logs to get more information about possible problems and communicate with our support if you need any assistance.