Informix

Dear Friends. 

 We have 1 OPENLDAP Svr VM  ( slapd 2.6.6 (Jul 26 2024 00:00:00) ) for USER management and 2 Clients VMs. One client for INFORMIX DB server ( 14.10.FC11DE ) and other for INFORMIX 4gl ( 7.51.FC3
)  APP and all are having the same REDAHT OS 9. 
LDAP  Authentication from  SVR to clients are successful from the OS end. 
 
But From the INFORMIX 4GL programs end,   the LDAP user ( e.g ROCKY )  is getting the INFORMIX 1809 run time error when it connects to the DB  
 
APP VM-> 
 
Env -> 
INFORMIXDIR=/opt/4gl
PWD=/home/informix
LOGNAME=informix
HOME=/home/informix
INFORMIXSQLHOSTS=/opt/4gl/etc/sqlhosts
USER=informix
INFORMIXSERVER=ldap_test_2
XDG_DATA_DIRS=/home/informix/.local/share/flatpak/exports/share:/var/lib/flatpak/exports/share:/usr/local/share:/usr/share
PATH=/home/informix/.local/bin:/home/informix/bin:/usr/local/bin:/usr/bin:/usr/local/sbin:/usr/sbin:.:/opt/4gl/bin:/opt/4gl/lib
MAIL=/var/spool/mail/informix
OLDPWD=/home/informix
 
Sqlhosts -> 
##ldap_inf onsoctcp clientdb.hwdomainlan  1529
##ldap_test onsoctcp 192.168.102.135 1528 s=4,pam_serv=(system_auth),pamauth=(password)
ldap_test_2 onsoctcp 192.168.102.135 1530 s=4,pam_serv=(passwd),pamauth=(password)
 
ls -lrt /etc/pam.d/passwd
-rw-r--r--. 1 root root 168 Aug 10  2021 /etc/pam.d/passwd
 
DB VM 
 
Env ->
INFORMIXDIR=/opt/informix
PWD=/home/informix
LOGNAME=informix
HOME=/home/informix
INFORMIXSQLHOSTS=/opt/informix/etc/sqlhosts
USER=informix
INFORMIXSERVER=ldap_test_2
XDG_DATA_DIRS=/home/informix/.local/share/flatpak/exports/share:/var/lib/flatpak/exports/share:/usr/local/share:/usr/share
PATH=/opt/informix/bin:/home/informix/.local/bin:/home/informix/bin:/usr/local/bin:/usr/bin:/usr/local/sbin:/usr/sbin
MAIL=/var/spool/mail/Informix
 
Sqlhosts -> 
ldap_test onsoctcp 192.168.102.135 1528 s=4,pam_serv=(system_auth),pamauth=(password)
ldap_test_2 onsoctcp 192.168.102.135 1530 s=4,pam_serv=(passwd),pamauth=(password)
 
onconfig ->
DBSERVERNAME ldap_inf
DBSERVERALIASES ldap_test,ldap_test_2
 
ls -lrt /etc/pam.d/passwd
-rw-r--r--. 1 root root 168 Aug 10  2021 /etc/pam.d/passwd
 
LDAP user is  getting the INFORMIX 1809  error while he connecting to 'ldap_test_2'  via dbaccess.
We were not able to see any errors related to the issue  in   OS logs and informix.log etc. 
 
We have tried the below workaround but is too not successful and getting errors  while we are compiling the code .
e.g https://www.ibm.com/support/pages/how-use-pam-authentication-ibm-informix-4gl
 
What would be the reason of the issue ?
 

Thanks !

Best Regards,

Indika