Troubleshooting

About this task

If you encounter the following error in PostgreSQL log while authenticating with BINDPW parameter:
ERROR: pam_authenticate failed: User not known to the underlying authentication module
perform the following workaround steps on NPS host with root user:

Procedure

  1. Run: 
    echo -n <bindpassword> |sss_obfuscate --domain=external_ldap -s
  2. Run: 
    systemctl restart sssd

    To handle mixed cases in the LDAP/AD authentication process, do not use NAMESPACE in the SET AUTHENTICATION LDAP command.

    Example:
    nzsql -c " SET AUTHENTICATION LDAP BASE 'dc=nzdevelopment,dc=com' SERVER '<LDAP/AD Server>' SSL 'off' BINDPW Ipspass26BINDDN 'cn=ad_user1,cn=Users,dc=nzdevelopment,dc=com'; "