Hi there AppWorks fans,
Welcome to a new installment of AppWorks tips.
This guide will help you installing AppWorks on the supported CentOS VM image. AppWorks requires an instance of CARS.
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 CentOS VM image with CARS 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 11 of Java! In this post we used: https://jdbc.postgresql.org/download/postgresql-42.2.5.jar
Once downloaded upload it to the VM with WinSCP or MobaXTerm using the already available ‘otadmin’ administrator.
In the VM we move the file to the correct TomEE location:
sudo cp /home/otadmin/postgresql-42.2.5.jar /opt/tomee/latest/lib/
And restart TomEE
systemctl restart tomee
To make it nicer and smoother we will update the otadmin bash_profile. So, edit the ~/.bash_profile of the ‘otadmin’ user:
The two OpenText folder locations in the CLASSPATH and LD_LIBRARY_PATH are there to optimize the installation in the rest of this post!
When done reload your profile via the command:
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 us first create a nice location folder and own it by the ‘postgres’ user that was created during the installation of PostgreSQL.
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
And create a tablepace 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:
And execute the magic command:
sudo CATALINA_HOME=$CATALINA_HOME CLASSPATH=$CLASSPATH ./OpenText_AppWorks_Platform_16.6.bin
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!
Accept the license and hit ‘Next’
Accept more licenses and hit ‘Next’
CARS is already installed and running so the information should be fine. Provide the CARS password. We used for the example ‘admin’. Hit ‘Next’.
Leave as default and continue by hitting ‘Next’
Also leave as is and click ‘Next’.
Now it’s time to get a hand on your new requested license file!
How to get one is described on top of this post.
Fill in the data from your license file and click ‘Next’.
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!
Leave the default folder location and click ‘Next’
If the field are not filled in already point it to the correct location and give the proper service name. Click ‘Next’
Provide a password for the sysadmin account. For example, ‘admin’ and click ‘Next’
Now make sure to fill in the correct information for the Database connection:
- Database type: PostgreSQL (The screenshot is wrong!)
- 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’
Point the tablespace to our own create 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.2.5.jar’ is available on the CLASSPATH
Also, this can happen for the table spacing. Just click ‘OK’
Give a password with the JMX admin user. For example, ‘admin’ and click ‘Next’
Almost there…The magic ‘Install’ button….Hit it like a bro!! 💪
Time for a beer…
There it is…Our well-earned ‘Done’ button!
Can take some time when the screen is gone, but it’s done…done!
To see what was done to the system check the log files:
cat /opt/opentext/AppWorksPlatform/defaultInst/install_log/AppWorks\ Platform\ installation.Log
sudo cat /opt/opentext/AppWorksPlatform/defaultInst/Logs/Monitor.xml
To see if AppWorks is running fine:
ps aux | grep cordys
tomcat 3816 2.1 2.5 3942488 234160 ? Sl 10:27 0:23 /usr/lib/jvm/java-1.8.0-openjdk-184.108.40.206.b04-0.el7_6.x86_64/jre/bin/java -Xrs -XX:+HeapDumpOnOutOfMemoryError -cp :/opt/opentext/AppWorksPlatform/defaultInst/cordyscp.jar:/opt/opentext/AppWorksPlatform/defaultInst/cordyscp.jar::/opt/tomee/latest/lib/postgresql-42.2.5.jar:/opt/opentext/AppWorksPlatform/defaultInst/cordyscp.jar:/opt/tomee/apache-tomee-plus-7.0.5/lib/postgresql-42.2.5.jar:/opt/opentext/AppWorksPlatform/defaultInst/cordyscp.jar:: -Dbus.xml.vm.maxsize=1024 -Xmx256M -Dfile.encoding=UTF-8 com.eibus.soap.Processor -name system#cap#cap@win-5skkmburvo7
To stop and start AppWorks you can use these commands:
/etc/init.d/wcpddefaultInst stop or
systemctl stop wcpddefaultInst.service
/etc/init.d/wcpddefaultInst start or
systemctl start wcpddefaultInst.service
The status call can be done with
systemctl status wcpddefaultInst.service
And this again gives us a big ‘DONE’ we can be proud off. Let me know what you think of this post in the comments. And 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.