Netezza Performance Server

Netezza Performance Server

Connect with Db2, Informix, Netezza, open source, and other data experts to gain value from your data, share insights, and solve problems.

 View Only

Unable to Enforce SHA256 Auth – SHOW CONNECTION Still Shows MD5/Trust

  • 1.  Unable to Enforce SHA256 Auth – SHOW CONNECTION Still Shows MD5/Trust

    Posted 10 days ago

    Hi ,We are trying to enforce sha256 authentication on Netezza 11.2 emulator. Even after updating /nz/simdata/pg_hba.conf and using nzauth to set all connections (local and host) to sha256, the SHOW CONNECTION command still shows trust, password, and md5. From the local machine, connections succeed even with a wrong password. How can we ensure sha256 is enforced and reflected correctly in the system?



    ------------------------------
    Yash Shah
    ------------------------------