WebFOCUS - Tips & Tricks - configure and debug PostgreSQL Adapter in WebFOCUS 9
This tutorial explains how to configure PostgreSQL driver in general and how to fix an issue with newer versions of PostgreSQL.
Trying to connect to PostgreSQL 14 or any other recent version you might run into following problem:
(FOC1400) SQLCODE IS -1 (HEX: FFFFFFFF) XOPEN: 08004
(FOC1500) : (0) [08004] The authentication type 10 is not supported. Check that
(FOC1500) : you have configured the pg_hba.conf file to include the client's IP
(FOC1500) : address or subnet, and that it is using an authentication scheme
(FOC1500) : supported by the driver.getConnection failed: org.postgresql.util.
(FOC1500) : PSQLException: The authentication type 10 is not supported. Check that
(FOC1500) : you have configured the pg_hba.conf file to include the client's IP
(FOC1500) : address or subnet, and that it is using an authentication scheme
(FOC1500) : supported by the driver.
(FOC1500) : (-1) [00000] JDBFOC makeConnection(): ibi.ntj2c.ntjprerr: 0001
(FOC1500) : 008004 485The authentication type 10 is not supported. Check that you
(FOC1406) SQL OPEN CURSOR ERROR.
(FOC1500) ** 2 messages suppressed **
PostgreSQL Adapter Connectivity Test (SUFFIX=SQLPSTGR Postgresql14): Status - Failed
Failure Codes: ... LINES= 0 RETCODE= -1 FOCERRNUM=1406
Correct cited failure before attempting test again.
This is related to the JDBC Driver active by default in WebFOCUS that does not support scram-sha-256 password encryption - please follow the description how to fix this