You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@nifi.apache.org by "Emilio Setiadarma (Jira)" <ji...@apache.org> on 2023/06/29 19:23:00 UTC
[jira] [Assigned] (NIFI-11519) Sensitive Dynamic Properties do not work with Sensitive Parameter Values in DBCP
[ https://issues.apache.org/jira/browse/NIFI-11519?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Emilio Setiadarma reassigned NIFI-11519:
----------------------------------------
Assignee: Emilio Setiadarma
> Sensitive Dynamic Properties do not work with Sensitive Parameter Values in DBCP
> --------------------------------------------------------------------------------
>
> Key: NIFI-11519
> URL: https://issues.apache.org/jira/browse/NIFI-11519
> Project: Apache NiFi
> Issue Type: Bug
> Components: Core Framework
> Affects Versions: 1.21.0
> Reporter: Andrew M. Lim
> Assignee: Emilio Setiadarma
> Priority: Major
>
> When configuring a DBCPConnectionPool controller service, I created a dynamic property {{PWD}} and selected "Sensitive". The value from this dynamic property should be used in the PWD connection property in the Database Connection URL, but it causes an error in the processor that uses the controller service (see below).
> WORKAROUND: If I create a dynamic property {{SENSITIVE.PWD}} (doesn't matter if I select "Sensitive" setting), then the error does not occur.
> Error (from ExecuteSQL processor using the DBCP Connection Pool):
> 16:04:12 UTCERRORef0a84d5-26f6-377a-af2c-bd9ddb098ea0
> All NodesExecuteSQL[id=ef0a84d5-26f6-377a-af2c-bd9ddb098ea0] Unable to execute SQL select query [CREATE EXTERNAL TABLE orders25 LIKE PARQUET 's3a://XXXXX/destination/parquet/XXXXX.parquet'
> STORED AS PARQUET
> LOCATION 's3a://XXXXX/destination/parquet/';] for FlowFile[filename=XXXXX.parquet] routing to failure: org.apache.nifi.processor.exception.ProcessException: Privileged action failed due to: Cannot create PoolableConnectionFactory ( [JDBC](10100) Connection Refused: [JDBC](11640) Required Connection Key(s): PWD; [JDBC](11480) Optional Connection Key(s): AllowSelfSignedCerts, AsyncExecPollInterval, AutomaticColumnRename, CAIssuedCertNamesMismatch, CatalogSchemaSwitch, DefaultStringColumnLength, DelegationToken, DelegationUID, DnsResolver, DnsResolverArg, FastConnection, krbJAASFile, LowerCaseResultSetColumnName, NonSSPs, OptimizedInsert, PreparedMetaLimitZero, RowsFetchedPerBlock, ServerVersion, ServiceDiscoveryMode, SocketFactory, SocketFactoryArg, SocketTimeOut, SSLKeyStore, SSLKeyStorePwd, SSLTrustStore, SSLTrustStorePwd, StripCatalogName, SupportTimeOnlyTimestamp, UseCustomTypeCoercionMap, UseNativeQuery, UseSasl)
> - Caused by: java.sql.SQLException: Cannot create PoolableConnectionFactory ( [JDBC](10100) Connection Refused: [JDBC](11640) Required Connection Key(s): PWD; [JDBC](11480) Optional Connection Key(s): AllowSelfSignedCerts, AsyncExecPollInterval, AutomaticColumnRename, CAIssuedCertNamesMismatch, CatalogSchemaSwitch, DefaultStringColumnLength, DelegationToken, DelegationUID, DnsResolver, DnsResolverArg, FastConnection, krbJAASFile, LowerCaseResultSetColumnName, NonSSPs, OptimizedInsert, PreparedMetaLimitZero, RowsFetchedPerBlock, ServerVersion, ServiceDiscoveryMode, SocketFactory, SocketFactoryArg, SocketTimeOut, SSLKeyStore, SSLKeyStorePwd, SSLTrustStore, SSLTrustStorePwd, StripCatalogName, SupportTimeOnlyTimestamp, UseCustomTypeCoercionMap, UseNativeQuery, UseSasl)
> - Caused by: java.sql.SQLNonTransientConnectionException: [JDBC](10100) Connection Refused: [JDBC](11640) Required Connection Key(s): PWD; [JDBC](11480) Optional Connection Key(s): AllowSelfSignedCerts, AsyncExecPollInterval, AutomaticColumnRename, CAIssuedCertNamesMismatch, CatalogSchemaSwitch, DefaultStringColumnLength, DelegationToken, DelegationUID, DnsResolver, DnsResolverArg, FastConnection, krbJAASFile, LowerCaseResultSetColumnName, NonSSPs, OptimizedInsert, PreparedMetaLimitZero, RowsFetchedPerBlock, ServerVersion, ServiceDiscoveryMode, SocketFactory, SocketFactoryArg, SocketTimeOut, SSLKeyStore, SSLKeyStorePwd, SSLTrustStore, SSLTrustStorePwd, StripCatalogName, SupportTimeOnlyTimestamp, UseCustomTypeCoercionMap, UseNativeQuery, UseSasl
--
This message was sent by Atlassian Jira
(v8.20.10#820010)