Patch available for NIFI-7563

[Juan Pablo Gardella]

Hi team,

I would like to ask for some volunteers to review NIFI-7563. It is an
optimization for PublishJMS. I also discovered two more during the
resolution of it; but I would like to patch them after merging NIFI-7563
(if it is possible) to simplify the merge.

Thanks in advance,
Juan

Re: FW: Execute SQL to MSFT SQLServer - getting error

[Juan Pablo Gardella]

According JDBC documentation driver
,
integratedSecurity is a boolean property, and to authenticate against
SQLServer you have three options for integratedSecurity=true. Kerberos,
NTLM or NativeAuthentication. NativeAuthentication only works in windows
os, so you cannot use it in linux.

Juan

On Thu, 20 Feb 2020 at 14:49, Pierre Villard 
wrote:

> Based on this thread [1], it looks like it's because the DLL are not
> loaded by Java. I'd double check what you set for java.library.path system
> property.
>
> [1]
> https://stackoverflow.com/questions/6087819/jdbc-sqlserverexception-this-driver-is-not-configured-for-integrated-authentic
>
> Le jeu. 20 févr. 2020 à 02:03, Samarendra Sahoo <
> sahoo.samaren...@gmail.com> a écrit :
>
>> Thanks a lot Peter. Attaching the controller. In addition to the
>> controller setting, adding jdbc 8 driver, we have added mssql-jdbc_auth dll
>> at below locations in the Nifi server.
>>
>>
>> /usr/lib/jvm/java-1.8.0-openjdk-1.8.0.141-3.b16.el6_9.x86_64/bin/mssql-jdbc_auth-8.2.0.x64.dll
>>
>> /usr/lib/jvm/java-1.8.0-openjdk-1.8.0.141-3.b16.el6_9.x86_64/jre/bin/mssql-jdbc_auth-8.2.0.x64.dll
>> - Forwarded message -
>>
>> From: *Pierre Villard* 
>> Date: Thu, 20 Feb, 2020, 12:54 AM
>> Subject: Re: Execute SQL to MSFT SQLServer - getting error
>> To: 
>> Cc: 
>>
>>
>>
>> Hi,
>>
>>
>>
>> Based on the error, it sounds like the driver you are using is not
>> configured for integrated authentication. Can you share more details about
>> how you configured your controller service?
>>
>>
>>
>> Thanks,
>>
>> Pierre
>>
>>
>>
>> Le mer. 19 févr. 2020 à 09:58, Samarendra Sahoo <
>> sahoo.samaren...@gmail.com> a écrit :
>>
>> Dear all,
>> We are trying to connect to SQLServer from Nifi installed on a RHEL Linux
>> VM. We are not able to find a way to connect SQLServer configured with
>> Integrated Security=*SSPI *with Windows login Authentication*  ( Note :
>> Kerberos not enabled )  *. We are trying to use *DBCPConnectionPool *with
>> JDBC database connector 
>> *jdbc:sqlserver://xx.xxx.xx.xxx:port;databaseName=DEMODB;integratedSecurity=SSPI
>> . *However its not allowed us to login to SQLServer. Does nifi provide
>> any connector/Component or to connect to SSPI Security mode ?  Or Is there
>> any other way to connect using custom code connector?
>>
>>
>>
>> Attaching error message for reference
>>
>>

NIFI-5070/NIFI-5049 patches available

[Juan Pablo Gardella]

Hi folks,

I've sent both patches some time ago, I know you are very busy but please
let me know if something else is required in both patches.

Thanks in advance,
Juan

Any chance to merge NIFI-3093?

[Juan Pablo Gardella]

Hi devs,

Could you check if there is something missing to merge NIFI-3093? Pull:  GitHub
Pull Request #2507 

I can help you if something is missing.

Thanks,
Juan