Oninit cdi / Archive
Talk to an expert →

DB/4GL error 1809 from OPENLDAP

Posted in 2024

Topics: Connectivity: ESQL/C, 4GL & Embedded SQL, Server Administration, Security, Permissions & Auditing, Networking & sqlhosts Configuration

Indika Jinadasa — source: IBM Community (ConnectedCommunity.org) Informix forum

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/4glPWD=/home/informix LOGNAME=informix HOME=/home/informix INFORMIXSQLHOSTS=/opt/4gl/etc/sqlhostsUSER=informix INFORMIXSERVER=ldap_test_2XDG_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/libMAIL=/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/passwdDB VM Env -> INFORMIXDIR=/opt/informixPWD=/home/informix LOGNAME=informix HOME=/home/informix INFORMIXSQLHOSTS=/opt/informix/etc/sqlhostsUSER=informix INFORMIXSERVER=ldap_test_2XDG_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/sbinMAIL=/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/passwdLDAP 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 ------------------------------ Indika Jinadasa ------------------------------

Glossary