Member since
02-19-2024
7
Posts
3
Kudos Received
0
Solutions
03-17-2024
09:36 PM
Sorry for my late post, Yes like you said @SAMSAL I miss the parameter from connection string : this is my previous connection string jdbc:sqlserver://#{db_cmk_colo_host};port=#{db_cmk_colo_port};database=#{db_cmk_colo_name} And this is after (its working now) jdbc:sqlserver://#{db_cmk_colo_host};port=#{db_cmk_colo_port};database=#{db_cmk_colo_name};authentication=NotSpecified;encrypt=true;trustServerCertificate=true Thank you again for your help. 😊
... View more
03-14-2024
08:55 PM
The other side team decide to give me an access into their SQL Server 2019 (Development Server) And I got another issue when trying to connect into SQL Server 2019
... View more
03-08-2024
04:59 AM
hi @SAMSAL I just query using SSMS. Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64) Apr 2 2010 15:48:46 Copyright (c) Microsoft Corporation Standard Edition (64-bit) on Windows NT 6.2 <X64> (Build 9200: ) It is RTM, so I think they need to update their SQL Server 2008 R2 Service Pack to the latest.
... View more
03-07-2024
08:36 PM
1 Kudo
Apache NiFi 1.25.0 I'm trying to connect SQL Server 2008 R2 using ConvertJSONToSQL processor but got this error : Using this driver : jar : mssql-jdbc-12.6.0.jre11.jar class : com.microsoft.sqlserver.jdbc.SQLServerDriver I have no problem connect SQL Server 2008 R2 using SSMS. Am I missing some configuration? I did using default https configuration on nifi.properties provided by Apache NiFi when installed.
... View more
Labels:
- Labels:
-
Apache NiFi
02-19-2024
10:32 PM
2 Kudos
I'm just installing Apache Nifi on linux server with version 1.25 . this is my nifi.properties : #nifi.security=none
#nifi.security.autoreload.enabled=false
#nifi.security.autoreload.interval=10 secs
#nifi.security.keystore=
#nifi.security.keystoreType=PKCS12
#nifi.security.keystorePasswd=
#nifi.security.keyPasswd=
#nifi.security.truststore=
#nifi.security.truststoreType=PKCS12
#nifi.security.truststorePasswd=
#nifi.security.user.authorizer=
nifi.security.allow.anonymous.authentication=false
nifi.security.user.login.identity.provider=file-login-provider
#nifi.security.user.jws.key.rotation.period=PT1H
#nifi.security.ocsp.responder.url=
#nifi.security.ocsp.responder.certificate= this is my users.xml : <?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<tenants>
<users>
<!-- Add more users as needed -->
<user identifier="ronald">
<identity>ronald</identity>
<!-- Replace CREDENTIAL_VALUE with the hashed password -->
<credential>wyojiYY_R6FGaU-XZKg5K9Mai1NlZXizt_-KGyWsHBs=</credential>
</user>
</users>
<groups>
<!-- Define groups if needed -->
</groups>
<policies>
<!-- Define access policies if needed -->
</policies>
</tenants> and this is my authorizers.xml : ...
<policies>
<!-- Define access policies -->
<policy identifier="ronald_policy">
<resource>/flow</resource>
<action>read</action>
<action>write</action>
<action>delete</action>
<user>ronald</user>
</policy>
</policies>
</authorizers> I still got an error when starting the app : Caused by: java.lang.Exception: The specified login identity provider 'file-login-provider' could not be found.
at org.apache.nifi.web.security.spring.LoginIdentityProviderFactoryBean.getObject(LoginIdentityProviderFactoryBean.java:131)
at org.springframework.beans.factory.support.FactoryBeanRegistrySupport.doGetObjectFromFactoryBean(FactoryBeanRegistrySupport.java:169)
... 72 common frames omitted
2024-02-20 13:18:04,241 INFO [Thread-0] org.apache.nifi.NiFi Application Server shutdown started
... View more
Labels:
- Labels:
-
Apache NiFi