You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@nifi.apache.org by Ravisankar Mani <rr...@gmail.com> on 2016/05/24 11:05:34 UTC
problem in windows authentication
Hi All,
I have trying to move data to sql server using "PutSQL" processor, In this
case i have created a specific DBCP connection pool. I have tried some
following steps for this operation
1. I moved to the "sqljdbc" jar file to nifi lib location and then restart
server.
2. I can able to moved the data to SQL Server using server authentication.
3. After i tried to move the data using sql server using windows
authentication, so i have changed my connection string like
jdbc:sqlserver://localhost;database=MyData;integratedSecurity=true;
In this case i have found some exceptions like
" the driver is not configured for integrated authentication"
and also i have tried to put "sqljdbc_auth.dll" to nifi lib location.
still the problem not yet solved. Can ypu please share the information for
resolving this issue.
Regards,
Ravi
Re: problem in windows authentication
Posted by Alexander Alten-Lorenz <wg...@gmail.com>.
Looks like an issue with your driver, according to:
https://blogs.msdn.microsoft.com/jdbcteam/2007/06/18/com-microsoft-sqlserver-jdbc-sqlserverexception-this-driver-is-not-configured-for-integrated-authentication/ <https://blogs.msdn.microsoft.com/jdbcteam/2007/06/18/com-microsoft-sqlserver-jdbc-sqlserverexception-this-driver-is-not-configured-for-integrated-authentication/>
cheers,
--alex
> On May 24, 2016, at 1:35 PM, Ravisankar Mani <rr...@gmail.com> wrote:
>
> Hi Pierre,
>
> Thank you for the update,
>
> Please find the below logs.
>
>
> 2016-05-24 02:25:50,530 ERROR [Timer-Driven Process Thread-2] o.apache.nifi.processors.standard.PutSQL
> org.apache.nifi.processor.exception.ProcessException: org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (This driver is not configured for integrated authentication.)
> at org.apache.nifi.dbcp.DBCPConnectionPool.getConnection(DBCPConnectionPool.java:225) ~[na:na]
> at sun.reflect.GeneratedMethodAccessor338.invoke(Unknown Source) ~[na:na]
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.7.0_51]
> at java.lang.reflect.Method.invoke(Method.java:606) ~[na:1.7.0_51]
> at org.apache.nifi.controller.service.StandardControllerServiceProvider$1.invoke(StandardControllerServiceProvider.java:164) ~[nifi-framework-core-0.6.0.jar:0.6.0]
> at com.sun.proxy.$Proxy89.getConnection(Unknown Source) ~[na:na]
> at org.apache.nifi.processors.standard.PutSQL.onTrigger(PutSQL.java:205) ~[na:na]
> at org.apache.nifi.processor.AbstractProcessor.onTrigger(AbstractProcessor.java:27) ~[nifi-api-0.6.0.jar:0.6.0]
> at org.apache.nifi.controller.StandardProcessorNode.onTrigger(StandardProcessorNode.java:1057) [nifi-framework-core-0.6.0.jar:0.6.0]
> at org.apache.nifi.controller.tasks.ContinuallyRunProcessorTask.call(ContinuallyRunProcessorTask.java:136) [nifi-framework-core-0.6.0.jar:0.6.0]
> at org.apache.nifi.controller.tasks.ContinuallyRunProcessorTask.call(ContinuallyRunProcessorTask.java:47) [nifi-framework-core-0.6.0.jar:0.6.0]
> at org.apache.nifi.controller.scheduling.TimerDrivenSchedulingAgent$1.run(TimerDrivenSchedulingAgent.java:123) [nifi-framework-core-0.6.0.jar:0.6.0]
> at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471) [na:1.7.0_51]
> at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:304) [na:1.7.0_51]
> at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:178) [na:1.7.0_51]
> at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293) [na:1.7.0_51]
> at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [na:1.7.0_51]
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [na:1.7.0_51]
> at java.lang.Thread.run(Thread.java:744) [na:1.7.0_51]
> Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (This driver is not configured for integrated authentication.)
> at org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1549) ~[na:na]
> at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1388) ~[na:na]
> at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044) ~[na:na]
> at org.apache.nifi.dbcp.DBCPConnectionPool.getConnection(DBCPConnectionPool.java:222) ~[na:na]
> ... 18 common frames omitted
> Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: This driver is not configured for integrated authentication.
> at com.microsoft.sqlserver.jdbc.SQLServerConnection.terminate(SQLServerConnection.java:1352) ~[sqljdbc4-3.0.jar:na]
> at com.microsoft.sqlserver.jdbc.SQLServerConnection.sendLogon(SQLServerConnection.java:2329) ~[sqljdbc4-3.0.jar:na]
> at com.microsoft.sqlserver.jdbc.SQLServerConnection.logon(SQLServerConnection.java:1905) ~[sqljdbc4-3.0.jar:na]
> at com.microsoft.sqlserver.jdbc.SQLServerConnection.access$000(SQLServerConnection.java:41) ~[sqljdbc4-3.0.jar:na]
> at com.microsoft.sqlserver.jdbc.SQLServerConnection$LogonCommand.doExecute(SQLServerConnection.java:1893) ~[sqljdbc4-3.0.jar:na]
> at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4874) ~[sqljdbc4-3.0.jar:na]
> at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1400) ~[sqljdbc4-3.0.jar:na]
> at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:1045) ~[sqljdbc4-3.0.jar:na]
> at com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:817) ~[sqljdbc4-3.0.jar:na]
> at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:700) ~[sqljdbc4-3.0.jar:na]
> at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:842) ~[sqljdbc4-3.0.jar:na]
> at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38) ~[na:na]
> at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582) ~[na:na]
> at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1556) ~[na:na]
> at org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1545) ~[na:na]
> ... 21 common frames omitted
> Caused by: java.lang.UnsatisfiedLinkError: no sqljdbc_auth in java.library.path
> at java.lang.ClassLoader.loadLibrary(ClassLoader.java:1886) ~[na:1.7.0_51]
> at java.lang.Runtime.loadLibrary0(Runtime.java:849) ~[na:1.7.0_51]
> at java.lang.System.loadLibrary(System.java:1088) ~[na:1.7.0_51]
> at com.microsoft.sqlserver.jdbc.AuthenticationJNI.<clinit>(AuthenticationJNI.java:32) ~[sqljdbc4-3.0.jar:na]
> at com.microsoft.sqlserver.jdbc.SQLServerConnection.logon(SQLServerConnection.java:1902) ~[sqljdbc4-3.0.jar:na]
> ... 33 common frames omitted
>
>
> Regards,
> Ravi
>
> On Tue, May 24, 2016 at 7:09 AM, Pierre Villard <pierre.villard.fr@gmail.com <ma...@gmail.com>> wrote:
> Hi Ravisankar,
>
> Could you provide full exception stack trace from the log files in NiFi?
>
> Thanks,
> Pierre
>
> 2016-05-24 13:05 GMT+02:00 Ravisankar Mani <rravimr@gmail.com <ma...@gmail.com>>:
> Hi All,
>
> I have trying to move data to sql server using "PutSQL" processor, In this case i have created a specific DBCP connection pool. I have tried some following steps for this operation
>
> 1. I moved to the "sqljdbc" jar file to nifi lib location and then restart server.
> 2. I can able to moved the data to SQL Server using server authentication.
> 3. After i tried to move the data using sql server using windows authentication, so i have changed my connection string like jdbc:sqlserver://localhost;database=MyData;integratedSecurity=true;
>
> In this case i have found some exceptions like
> " the driver is not configured for integrated authentication"
>
> and also i have tried to put "sqljdbc_auth.dll" to nifi lib location. still the problem not yet solved. Can ypu please share the information for resolving this issue.
>
>
> Regards,
> Ravi
>
>
>
>
>
>
Re: problem in windows authentication
Posted by Ravisankar Mani <rr...@gmail.com>.
Hi Pierre,
Thank you for the update,
Please find the below logs.
2016-05-24 02:25:50,530 ERROR [Timer-Driven Process Thread-2]
o.apache.nifi.processors.standard.PutSQL
org.apache.nifi.processor.exception.ProcessException:
org.apache.commons.dbcp.SQLNestedException: Cannot create
PoolableConnectionFactory (This driver is not configured for integrated
authentication.)
at
org.apache.nifi.dbcp.DBCPConnectionPool.getConnection(DBCPConnectionPool.java:225)
~[na:na]
at sun.reflect.GeneratedMethodAccessor338.invoke(Unknown Source)
~[na:na]
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
~[na:1.7.0_51]
at java.lang.reflect.Method.invoke(Method.java:606) ~[na:1.7.0_51]
at
org.apache.nifi.controller.service.StandardControllerServiceProvider$1.invoke(StandardControllerServiceProvider.java:164)
~[nifi-framework-core-0.6.0.jar:0.6.0]
at com.sun.proxy.$Proxy89.getConnection(Unknown Source) ~[na:na]
at
org.apache.nifi.processors.standard.PutSQL.onTrigger(PutSQL.java:205)
~[na:na]
at
org.apache.nifi.processor.AbstractProcessor.onTrigger(AbstractProcessor.java:27)
~[nifi-api-0.6.0.jar:0.6.0]
at
org.apache.nifi.controller.StandardProcessorNode.onTrigger(StandardProcessorNode.java:1057)
[nifi-framework-core-0.6.0.jar:0.6.0]
at
org.apache.nifi.controller.tasks.ContinuallyRunProcessorTask.call(ContinuallyRunProcessorTask.java:136)
[nifi-framework-core-0.6.0.jar:0.6.0]
at
org.apache.nifi.controller.tasks.ContinuallyRunProcessorTask.call(ContinuallyRunProcessorTask.java:47)
[nifi-framework-core-0.6.0.jar:0.6.0]
at
org.apache.nifi.controller.scheduling.TimerDrivenSchedulingAgent$1.run(TimerDrivenSchedulingAgent.java:123)
[nifi-framework-core-0.6.0.jar:0.6.0]
at
java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
[na:1.7.0_51]
at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:304)
[na:1.7.0_51]
at
java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:178)
[na:1.7.0_51]
at
java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293)
[na:1.7.0_51]
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
[na:1.7.0_51]
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
[na:1.7.0_51]
at java.lang.Thread.run(Thread.java:744) [na:1.7.0_51]
Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot create
PoolableConnectionFactory (This driver is not configured for integrated
authentication.)
at
org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1549)
~[na:na]
at
org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1388)
~[na:na]
at
org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)
~[na:na]
at
org.apache.nifi.dbcp.DBCPConnectionPool.getConnection(DBCPConnectionPool.java:222)
~[na:na]
... 18 common frames omitted
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: This driver is
not configured for integrated authentication.
at
com.microsoft.sqlserver.jdbc.SQLServerConnection.terminate(SQLServerConnection.java:1352)
~[sqljdbc4-3.0.jar:na]
at
com.microsoft.sqlserver.jdbc.SQLServerConnection.sendLogon(SQLServerConnection.java:2329)
~[sqljdbc4-3.0.jar:na]
at
com.microsoft.sqlserver.jdbc.SQLServerConnection.logon(SQLServerConnection.java:1905)
~[sqljdbc4-3.0.jar:na]
at
com.microsoft.sqlserver.jdbc.SQLServerConnection.access$000(SQLServerConnection.java:41)
~[sqljdbc4-3.0.jar:na]
at
com.microsoft.sqlserver.jdbc.SQLServerConnection$LogonCommand.doExecute(SQLServerConnection.java:1893)
~[sqljdbc4-3.0.jar:na]
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4874)
~[sqljdbc4-3.0.jar:na]
at
com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1400)
~[sqljdbc4-3.0.jar:na]
at
com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:1045)
~[sqljdbc4-3.0.jar:na]
at
com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:817)
~[sqljdbc4-3.0.jar:na]
at
com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:700)
~[sqljdbc4-3.0.jar:na]
at
com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:842)
~[sqljdbc4-3.0.jar:na]
at
org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)
~[na:na]
at
org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582)
~[na:na]
at
org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1556)
~[na:na]
at
org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1545)
~[na:na]
... 21 common frames omitted
Caused by: java.lang.UnsatisfiedLinkError: no sqljdbc_auth in
java.library.path
at java.lang.ClassLoader.loadLibrary(ClassLoader.java:1886)
~[na:1.7.0_51]
at java.lang.Runtime.loadLibrary0(Runtime.java:849) ~[na:1.7.0_51]
at java.lang.System.loadLibrary(System.java:1088) ~[na:1.7.0_51]
at
com.microsoft.sqlserver.jdbc.AuthenticationJNI.<clinit>(AuthenticationJNI.java:32)
~[sqljdbc4-3.0.jar:na]
at
com.microsoft.sqlserver.jdbc.SQLServerConnection.logon(SQLServerConnection.java:1902)
~[sqljdbc4-3.0.jar:na]
... 33 common frames omitted
Regards,
Ravi
On Tue, May 24, 2016 at 7:09 AM, Pierre Villard <pierre.villard.fr@gmail.com
> wrote:
> Hi Ravisankar,
>
> Could you provide full exception stack trace from the log files in NiFi?
>
> Thanks,
> Pierre
>
> 2016-05-24 13:05 GMT+02:00 Ravisankar Mani <rr...@gmail.com>:
>
>> Hi All,
>>
>> I have trying to move data to sql server using "PutSQL" processor, In
>> this case i have created a specific DBCP connection pool. I have tried some
>> following steps for this operation
>>
>> 1. I moved to the "sqljdbc" jar file to nifi lib location and then
>> restart server.
>> 2. I can able to moved the data to SQL Server using server authentication.
>> 3. After i tried to move the data using sql server using windows
>> authentication, so i have changed my connection string like
>> jdbc:sqlserver://localhost;database=MyData;integratedSecurity=true;
>>
>> In this case i have found some exceptions like
>> " the driver is not configured for integrated authentication"
>>
>> and also i have tried to put "sqljdbc_auth.dll" to nifi lib location.
>> still the problem not yet solved. Can ypu please share the information for
>> resolving this issue.
>>
>>
>> Regards,
>> Ravi
>>
>>
>>
>>
>>
>
Re: problem in windows authentication
Posted by Pierre Villard <pi...@gmail.com>.
Hi Ravisankar,
Could you provide full exception stack trace from the log files in NiFi?
Thanks,
Pierre
2016-05-24 13:05 GMT+02:00 Ravisankar Mani <rr...@gmail.com>:
> Hi All,
>
> I have trying to move data to sql server using "PutSQL" processor, In this
> case i have created a specific DBCP connection pool. I have tried some
> following steps for this operation
>
> 1. I moved to the "sqljdbc" jar file to nifi lib location and then restart
> server.
> 2. I can able to moved the data to SQL Server using server authentication.
> 3. After i tried to move the data using sql server using windows
> authentication, so i have changed my connection string like
> jdbc:sqlserver://localhost;database=MyData;integratedSecurity=true;
>
> In this case i have found some exceptions like
> " the driver is not configured for integrated authentication"
>
> and also i have tried to put "sqljdbc_auth.dll" to nifi lib location.
> still the problem not yet solved. Can ypu please share the information for
> resolving this issue.
>
>
> Regards,
> Ravi
>
>
>
>
>