Warning message while starting postgres 10.7 base

Document ID : KB000122451
Last Modified Date : 05/12/2018
Show Technical Document Details
Issue:
This customer upgrades from APM 10.5.2 to 10.7 which upgrade the Postgres to 9.6

When they start the postrgres database on the server they would see the following warnings:

WARNING --> PERL_INSTALL_PATH is not set in /ca/wilyadm/database/etc/sysconfig/plLanguages.config file
WARNING --> PYTHON_INSTALL_PATH is not set in /ca/wilyadm/database/etc/sysconfig/plLanguages.config file
WARNING --> TCL_INSTALL_PATH is not set in /ca/wilyadm/database/etc/sysconfig/plLanguages.config file
Environment:
APM 10.7 
Postgres 9.6.2
Cause:
These message can be ignored and done cause harm to Postgres or APM
Resolution:
Here are the things the customer did to remove the messages:

The warning messages are coming from "/ca/wilyadm/database/etc/sysconfig/loadplLanguages.sh". "/etc/init.d/postgres-9.6" calls "/ca/wilyadm/database/etc/sysconfig/loadplLanguages.sh" which gets the parameters configured in the "/ca/wilyadm/database/etc/sysconfig/plLanguages.config". 

To make the "/etc/init.d/postgres-6.2 start" script execute without the warnings I had to make few changes in our environment: 
1. Installed Pearl5.1, Python 3.3 and Tcl on the host 
2. I updated the "/ca/wilyadm/database/etc/sysconfig/plLanguages.config" file with the correct paths to those libraries 
3. I had to do few modifications to the /ca/wilyadm/database/etc/sysconfig/loadplLanguages.sh file to match the install locations for pearl, python and tcl (including changing some of the commands in the script (see tcl function) 

INFO --) Required Perl version 5.20 found at /opt/rh/rh-perl520/root/usr ... 
INFO --) Required Python version 3.3 found at /opt/rh/python33/root/usr ... 
INFO --) Required Tcl version 8.5 found at /usr ...