DB2 - Problem description
Problem IT22621 | Status: Closed |
SECURITY MECHANISM NOT SUPPORTED EXCEPTION WHEN AUTHENTICATION=CLIENT AND PASSWORD AND USER ARE PROVIDED. | |
product: | |
DB2 FOR LUW / DB2FORLUW / B10 - DB2 | |
Problem description: | |
When there are following setting on the remote server: Database manager authentication (AUTHENTICATION) = CLIENT Alternate authentication (ALTERNATE_AUTH_ENC) = NOT_SPECIFIED Cataloging allowed without authority (CATALOG_NOAUTH) = YES Trust all clients (TRUST_ALLCLNTS) = YES Trusted client authentication (TRUST_CLNTAUTH) = SERVER Bypass federated authentication (FED_NOAUTH) = NO in that case when the user and password is provided then authentication should take place on the server side. When no credentials are provided then client authentication should take place. However instead the following exceptions are raised: com.ibm.db2.jcc.am.SqlWarning: Origination unknown: [10228][11541][4.18.60] Security exceptions occurred while loading driver. ERRORCODE=4223, SQLSTATE=null and: [jcc][t4][201][11237][4.18.60] Connection authorization failure occurred. Reason: Security mechanism not supported. ERRORCODE=-4214, SQLSTATE=28000 | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to 11.1 FP2 or later * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
not known / see Local fix | |
BUG-Tracking | |
forerunner : IT19549 follow-up : | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 02.10.2017 13.10.2017 13.10.2017 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |