/ Installation  

The AppWorks installation survival guide

Hi there AppWorks fans,

Welcome to a new installment of AppWorks tips.

This guide will help you to install AppWorks on the supported RHEL VM image. AppWorks requires an instance of CARS/OpenLDAP.

This post is part of the series for ‘AppWorks installation in 10 great steps’.

This is the list of ingredients we are going to use:

  • The license information requested at OpenText support!
  • The already installed ‘Oracle Virtual Box’ software from the previous post
  • Our supported RHEL VM image with CARS/OpenLDAP installed from the previous posts
  • OpenText Appworks Platform (will be downloaded from OpenText support)
    • Includes the OpenText documentation
  • JDBC driver for TomEE. Downloaded from: postgresql.org
  • MobaXterm (X server and SSH client). Downloaded from: mobatek.net

Let get right into it…Get your license file ready!

Make the JDBC driver available for TomEE and AppWorks installation

Go to postgresql download site and download the latest version for our version 17 of Java! In this post we used: https://jdbc.postgresql.org/download/postgresql-42.6.0.jar

After download, upload it to the VM with WinSCP or MobaXTerm using the already available ‘sysadmin’ administrator.

In the VM we move the file to the correct TomEE location: sudo cp /home/sysadmin/postgresql-42.6.0.jar /opt/tomee/latest/lib/

Give the ‘tomcat’ user ownership: sudo chown tomcat:tomcat /opt/tomee/latest/lib/postgresql-42.6.0.jar

Restart TomEE: systemctl restart tomee

To make it nicer and smoother we will update the ‘sysadmin’ bash_profile. So, edit the ~/.bash_profile of the ‘sysadmin’ user: vi ~/.bash_profile

1
2
3
4
5
6
7
8
9
10
11
12
13
14
# .bash_profile

# Get the aliases and functions
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi

# User specific environment and startup programs
export CLASSPATH=$CLASSPATH:/opt/tomee/apache-tomee-plus-9.1.0/lib/postgresql-42.6.0.jar
export JAVA_HOME=/usr/lib/jvm/java-17-openjdk-17.0.8.0.7-2.el8.x86_64
LIB_PATH=$JAVA_HOME/lib/server
export PATH=$PATH:$HOME/.local/bin:$HOME/bin
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$LIB_PATH
export CATALINA_HOME=/opt/tomee/apache-tomee-plus-9.1.0

When done reload your profile via the command: source ~/.bash_profile

Check if it’s all OK via: env | grep PATH


Before we continue our ‘AppWorks installation journey’ we first create a table space for our PostgreSQL database instance that we can use for our installation.

Let’s first create a nice location folder and own it by the ‘postgres’ user that was created during the installation of PostgreSQL.

1
2
3
sudo mkdir /usr/data
sudo mkdir /usr/data/appworks_ts
sudo chown postgres /usr/data/appworks_ts/

Now enter the psql CLI: sudo -u postgres psql

Create a tablespace with this SQL statement: CREATE TABLESPACE appworks_ts LOCATION '/usr/data/appworks_ts';

To see the result, execute this query: select * from pg_tablespace;

\q to quit psql


Now the major step of this blog post series. The installation of AppWorks.

Go to your uploaded installation files: cd ~/opentext-appworks-suite-23.4-linux/OpenTextAppWorksPlatform/

Execute the magic command: sudo CATALINA_HOME=$CATALINA_HOME CLASSPATH=$CLASSPATH ./OpenText_AppWorks_Platform_23.4.bin

Get the message: Graphical installers are not supported by the VM. The console mode will be used instead…You need to make sure your DISPLAY variable is correct! export DISPLAY=IP:0.0

The “secret” silent installation call is: sudo CATALINA_HOME=$CATALINA_HOME CLASSPATH=$CLASSPATH ./OpenText_AppWorks_Platform_23.4.bin -i silent -f ./cordys.installer.properties
This a copy of my cordys.installer.properties which is based on the steps below.

install_appworks_001

Hit ‘Next’

install_appworks_002

Accept the license and hit ‘Next’

install_appworks_003

Accept more licenses and hit ‘Next’

install_appworks_004

We have already CARS installed and running, so the information should be fine. Provide the CARS password. We used for the example ‘admin’. Hit ‘Next’.

install_appworks_005

Leave as default and continue by hitting ‘Next’

install_appworks_006

Also, leave as is and click ‘Next’.

Now it’s time to get a hand on your new requested license file! It’s described on top of this post how to get one.

install_appworks_007

Fill in the data from your license file and click ‘Next’.

install_appworks_008

Unmark the ‘Fetch’ option and type in the license key from your local license file. Click ‘Next’.

If you get error on the next screen make sure your hostname is proper FQDN and that it matches the HOST in the license file!

install_appworks_009

Leave the (default) folder location and click ‘Next’

install_appworks_010

If the fields are empty, point it to the correct location and give the proper service name. Click ‘Next’.

install_appworks_011

Provide a password for the sysadmin account. For example, ‘admin’ and click ‘Next’.

Now you also see that the account ‘sysadmin’ on the server matches this account on the platform. Trust me…You want to have this match when you start to use server tools that make connection to the platform.

install_appworks_012

Now make sure to fill in the correct information for the Database connection:

  • Database type: PostgreSQL
  • Server name: your FQDN
  • Default Port: 5432
  • Username: postgres
  • Password: admin (as we changed during the PostgreSQL installation post in this site)
  • Database name: appworks_db
  • Mark the ‘Create Database’ option
  • DBA username: postgres
  • DBA password: admin

Now click ‘Next’

install_appworks_013

Click ‘Next’

install_appworks_014

Point the tablespace to our own created tablespace as described before the installation started. Click ‘Next’.

If you get connection errors to the database make sure the information is correct, and the JDBC driver postgresql-42.6.0.jar is available on the CLASSPATH

install_appworks_015

Also, this can happen for the table spacing. Just click ‘OK’.

install_appworks_016

install_appworks_017

Give a password with the JMX admin user. For example, ‘admin’ and click ‘Next’.

install_appworks_018

Almost there…The magic ‘Install’ button….Hit it like a bro!! 💪

Time for a beer…

install_appworks_019

install_appworks_020

There it is…Our well-earned ‘Done’ button!

Copy that URL as we will not be provided with that browser window! We need to do something like this from our local laptop: http://192.168.56.107:8080/cordys/wcp/cap/install?nodeName=appworks, but that is the next post…

Can take some time before the screen is gone, but it’s done…done!

To see what was done to the system check the log files:

cat /tmp/cordys_custom_log.log

cat /opt/opentext/AppWorksPlatform/defaultInst/install_log/AppWorks\ Platform\ installation.Log

cat /opt/opentext/AppWorksPlatform/defaultInst/install_log/configureapplicationserver.log

sudo cat /opt/opentext/AppWorksPlatform/defaultInst/Logs/Application_Server.xml

To see if AppWorks is running fine: ps aux | grep defaultInst

To stop and start AppWorks you can just restart the TomEE instance!

Deprecated commands:

/etc/init.d/wcpddefaultInst stop or systemctl stop wcpddefaultInst.service

/etc/init.d/wcpddefaultInst start or systemctl start wcpddefaultInst.service


This again gives us a big ‘DONE’ we can be proud off. Let me know what you think of this post in the comments. As always ‘have a good one for today’ and see you on the next installment of ‘Appworks Tips’. The final step in our series ‘AppWorks installation in 10 great steps’ is the deployment of the ‘ready packages’ from the installation.