[JBoss JIRA] (TEIID-5979) how to create web service datasource for Google cloud APIs
by Nayan Bija (Jira)
[ https://issues.redhat.com/browse/TEIID-5979?page=com.atlassian.jira.plugi... ]
Nayan Bija commented on TEIID-5979:
-----------------------------------
We are using 14.x version
> how to create web service datasource for Google cloud APIs
> ----------------------------------------------------------
>
> Key: TEIID-5979
> URL: https://issues.redhat.com/browse/TEIID-5979
> Project: Teiid
> Issue Type: Feature Request
> Components: Common
> Reporter: Nayan Bija
> Assignee: Steven Hawkins
> Priority: Major
>
> We need to create a web service data source to access google apis.
> I followed the steps mentioned in the below document
> [http://teiid.github.io/teiid-documents/master/content/admin/OAuth_Authent...]
>
> But getting below error after entering the Access Token URL.
> Could you please provide solution on it.
>
> Error logs.
> ===========
> WARNING: Default key managers cannot be initialized: Password must not be null
> java.security.UnrecoverableKeyException: Password must not be null
> at sun.security.provider.JavaKeyStore.engineGetKey(JavaKeyStore.java:124)
> at sun.security.provider.JavaKeyStore$JKS.engineGetKey(JavaKeyStore.java:55)
> at java.security.KeyStore.getKey(KeyStore.java:1011)
> at sun.security.ssl.SunX509KeyManagerImpl.<init>(SunX509KeyManagerImpl.java:133)
> at sun.security.ssl.KeyManagerFactoryImpl$SunX509.engineInit(KeyManagerFactoryImpl.java:70)
> at javax.net.ssl.KeyManagerFactory.init(KeyManagerFactory.java:256)
> at org.apache.cxf.configuration.jsse.SSLUtils.loadDefaultKeyManagers(SSLUtils.java:116)
> at org.apache.cxf.configuration.jsse.SSLUtils.getDefaultKeyStoreManagers(SSLUtils.java:89)
> at org.apache.cxf.transport.https.SSLUtils.getSSLContext(SSLUtils.java:75)
> at org.apache.cxf.transport.https.HttpsURLConnectionFactory.decorateWithTLS(HttpsURLConnectionFactory.java:144)
> at org.apache.cxf.transport.https.HttpsURLConnectionFactory.createConnection(HttpsURLConnectionFactory.java:101)
> at org.apache.cxf.transport.http.URLConnectionHTTPConduit.createConnection(URLConnectionHTTPConduit.java:121)
> at org.apache.cxf.transport.http.URLConnectionHTTPConduit.setupConnection(URLConnectionHTTPConduit.java:125)
> at org.apache.cxf.transport.http.asyncclient.AsyncHTTPConduit.setupConnection(AsyncHTTPConduit.java:190)
> at org.apache.cxf.transport.http.HTTPConduit.prepare(HTTPConduit.java:505)
> at org.apache.cxf.interceptor.MessageSenderInterceptor.handleMessage(MessageSenderInterceptor.java:47)
> at org.apache.cxf.phase.PhaseInterceptorChain.doIntercept(PhaseInterceptorChain.java:308)
> at org.apache.cxf.jaxrs.client.AbstractClient.doRunInterceptorChain(AbstractClient.java:701)
> at org.apache.cxf.jaxrs.client.WebClient.doChainedInvocation(WebClient.java:1086)
> at org.apache.cxf.jaxrs.client.WebClient.doInvoke(WebClient.java:932)
> at org.apache.cxf.jaxrs.client.WebClient.doInvoke(WebClient.java:901)
> at org.apache.cxf.jaxrs.client.WebClient.form(WebClient.java:434)
> at org.apache.cxf.rs.security.oauth2.client.OAuthClientUtils.getAccessToken(OAuthClientUtils.java:301)
> at org.apache.cxf.rs.security.oauth2.client.OAuthClientUtils.getAccessToken(OAuthClientUtils.java:225)
> at org.teiid.oauth.OAuthUtil.oauth20Flow(OAuthUtil.java:158)
> at org.teiid.oauth.OAuthUtil.main(OAuthUtil.java:76)
> at org.jboss.modules.Module.run(Module.java:352)
> at org.jboss.modules.Module.run(Module.java:320)
> at org.jboss.modules.Main.main(Main.java:593)
> Exception in thread "main" org.apache.cxf.rs.security.oauth2.provider.OAuthServiceException: server_error
> at org.apache.cxf.rs.security.oauth2.client.OAuthClientUtils.getAccessToken(OAuthClientUtils.java:323)
> at org.apache.cxf.rs.security.oauth2.client.OAuthClientUtils.getAccessToken(OAuthClientUtils.java:225)
> at org.teiid.oauth.OAuthUtil.oauth20Flow(OAuthUtil.java:158)
> at org.teiid.oauth.OAuthUtil.main(OAuthUtil.java:76)
> at org.jboss.modules.Module.run(Module.java:352)
> at org.jboss.modules.Module.run(Module.java:320)
> at org.jboss.modules.Main.main(Main.java:593)
> Press any key to continue . . .
--
This message was sent by Atlassian Jira
(v7.13.8#713008)
4 years, 6 months
[JBoss JIRA] (TEIIDSB-216) We get error with methadata in Salesforce request
by Steven Hawkins (Jira)
[ https://issues.redhat.com/browse/TEIIDSB-216?page=com.atlassian.jira.plug... ]
Steven Hawkins commented on TEIIDSB-216:
----------------------------------------
The salesforce connectivity is based upon the 45.1.0 partner jar. To be honest I'm not sure how well that would work the enterprise wsdl, which is referenced in the /c/ urls. As for the error if it happens consistently then it's likely an incompatibility in the 45.1.0 partner jar and the 44.0 wsdl. If it's happening inconsistently, such as you are mentioning under a timeout scenario, then it seems appropriate that we would throw an exception. However Teiid Spring Boot does not currently attempt redeployments.
> We get error with methadata in Salesforce request
> -------------------------------------------------
>
> Key: TEIIDSB-216
> URL: https://issues.redhat.com/browse/TEIIDSB-216
> Project: Teiid Spring Boot
> Issue Type: Bug
> Components: datasource
> Reporter: Renat Eskenin
> Priority: Major
>
> We get error from Teiid:
> {code}
> SQL state [50000]; error code [30504]; TEIID30504 salesforce: Unrecognized header: {http://soap.sforce.com/2006/04/metadata}DebuggingInfo; nested exception is org.teiid.jdbc.TeiidSQLException: TEIID30504 salesforce: Unrecognized header: {http://soap.sforce.com/2006/04/metadata}DebuggingInfo
> {code}
> As I think this error faired when we have connection timeout to Salesforce. In other time all works fine.
--
This message was sent by Atlassian Jira
(v7.13.8#713008)
4 years, 6 months
[JBoss JIRA] (TEIID-5979) how to create web service datasource for Google cloud APIs
by Steven Hawkins (Jira)
[ https://issues.redhat.com/browse/TEIID-5979?page=com.atlassian.jira.plugi... ]
Steven Hawkins commented on TEIID-5979:
---------------------------------------
What Teiid/WildFly version is this on? It probably means that you need to set system parameters for the default ssl keystore - see docs such as https://doc.nuxeo.com/nxdoc/trust-store-and-key-store-configuration/
> how to create web service datasource for Google cloud APIs
> ----------------------------------------------------------
>
> Key: TEIID-5979
> URL: https://issues.redhat.com/browse/TEIID-5979
> Project: Teiid
> Issue Type: Feature Request
> Components: Common
> Reporter: Nayan Bija
> Assignee: Steven Hawkins
> Priority: Major
>
> We need to create a web service data source to access google apis.
> I followed the steps mentioned in the below document
> [http://teiid.github.io/teiid-documents/master/content/admin/OAuth_Authent...]
>
> But getting below error after entering the Access Token URL.
> Could you please provide solution on it.
>
> Error logs.
> ===========
> WARNING: Default key managers cannot be initialized: Password must not be null
> java.security.UnrecoverableKeyException: Password must not be null
> at sun.security.provider.JavaKeyStore.engineGetKey(JavaKeyStore.java:124)
> at sun.security.provider.JavaKeyStore$JKS.engineGetKey(JavaKeyStore.java:55)
> at java.security.KeyStore.getKey(KeyStore.java:1011)
> at sun.security.ssl.SunX509KeyManagerImpl.<init>(SunX509KeyManagerImpl.java:133)
> at sun.security.ssl.KeyManagerFactoryImpl$SunX509.engineInit(KeyManagerFactoryImpl.java:70)
> at javax.net.ssl.KeyManagerFactory.init(KeyManagerFactory.java:256)
> at org.apache.cxf.configuration.jsse.SSLUtils.loadDefaultKeyManagers(SSLUtils.java:116)
> at org.apache.cxf.configuration.jsse.SSLUtils.getDefaultKeyStoreManagers(SSLUtils.java:89)
> at org.apache.cxf.transport.https.SSLUtils.getSSLContext(SSLUtils.java:75)
> at org.apache.cxf.transport.https.HttpsURLConnectionFactory.decorateWithTLS(HttpsURLConnectionFactory.java:144)
> at org.apache.cxf.transport.https.HttpsURLConnectionFactory.createConnection(HttpsURLConnectionFactory.java:101)
> at org.apache.cxf.transport.http.URLConnectionHTTPConduit.createConnection(URLConnectionHTTPConduit.java:121)
> at org.apache.cxf.transport.http.URLConnectionHTTPConduit.setupConnection(URLConnectionHTTPConduit.java:125)
> at org.apache.cxf.transport.http.asyncclient.AsyncHTTPConduit.setupConnection(AsyncHTTPConduit.java:190)
> at org.apache.cxf.transport.http.HTTPConduit.prepare(HTTPConduit.java:505)
> at org.apache.cxf.interceptor.MessageSenderInterceptor.handleMessage(MessageSenderInterceptor.java:47)
> at org.apache.cxf.phase.PhaseInterceptorChain.doIntercept(PhaseInterceptorChain.java:308)
> at org.apache.cxf.jaxrs.client.AbstractClient.doRunInterceptorChain(AbstractClient.java:701)
> at org.apache.cxf.jaxrs.client.WebClient.doChainedInvocation(WebClient.java:1086)
> at org.apache.cxf.jaxrs.client.WebClient.doInvoke(WebClient.java:932)
> at org.apache.cxf.jaxrs.client.WebClient.doInvoke(WebClient.java:901)
> at org.apache.cxf.jaxrs.client.WebClient.form(WebClient.java:434)
> at org.apache.cxf.rs.security.oauth2.client.OAuthClientUtils.getAccessToken(OAuthClientUtils.java:301)
> at org.apache.cxf.rs.security.oauth2.client.OAuthClientUtils.getAccessToken(OAuthClientUtils.java:225)
> at org.teiid.oauth.OAuthUtil.oauth20Flow(OAuthUtil.java:158)
> at org.teiid.oauth.OAuthUtil.main(OAuthUtil.java:76)
> at org.jboss.modules.Module.run(Module.java:352)
> at org.jboss.modules.Module.run(Module.java:320)
> at org.jboss.modules.Main.main(Main.java:593)
> Exception in thread "main" org.apache.cxf.rs.security.oauth2.provider.OAuthServiceException: server_error
> at org.apache.cxf.rs.security.oauth2.client.OAuthClientUtils.getAccessToken(OAuthClientUtils.java:323)
> at org.apache.cxf.rs.security.oauth2.client.OAuthClientUtils.getAccessToken(OAuthClientUtils.java:225)
> at org.teiid.oauth.OAuthUtil.oauth20Flow(OAuthUtil.java:158)
> at org.teiid.oauth.OAuthUtil.main(OAuthUtil.java:76)
> at org.jboss.modules.Module.run(Module.java:352)
> at org.jboss.modules.Module.run(Module.java:320)
> at org.jboss.modules.Main.main(Main.java:593)
> Press any key to continue . . .
--
This message was sent by Atlassian Jira
(v7.13.8#713008)
4 years, 6 months
[JBoss JIRA] (TEIIDSB-206) Create native connector to interact with HDFS as a datasource
by Steven Hawkins (Jira)
[ https://issues.redhat.com/browse/TEIIDSB-206?focusedWorklogId=12451701&pa... ]
Steven Hawkins logged work on TEIIDSB-206:
------------------------------------------
Author: Steven Hawkins
Created on: 02/Jul/20 10:12 AM
Start Date: 02/Jul/20 10:11 AM
Worklog Time Spent: 1 hour
Work Description: correcting the storagemode function and additional time coordinating work
Issue Time Tracking
-------------------
Remaining Estimate: 1 day, 6 hours (was: 1 day, 7 hours)
Time Spent: 6 hours (was: 5 hours)
Worklog Id: (was: 12451701)
> Create native connector to interact with HDFS as a datasource
> -------------------------------------------------------------
>
> Key: TEIIDSB-206
> URL: https://issues.redhat.com/browse/TEIIDSB-206
> Project: Teiid Spring Boot
> Issue Type: Feature Request
> Components: datasource
> Reporter: Van Halbert
> Assignee: Aditya Manglam Sharma
> Priority: Major
> Fix For: 1.6.0
>
> Original Estimate: 2 days, 4 hours
> Time Spent: 6 hours
> Remaining Estimate: 1 day, 6 hours
>
> Would like to have native connector
> To interact with HDFS as a datasource from a DV perspective there are at least two options:
> 1 - HttpFS
> 2 - WebHDFS
> Both options seems to be in practise very slow. I heard 2x slower.
> It would be nice if we can create a native HDFS connector.
--
This message was sent by Atlassian Jira
(v7.13.8#713008)
4 years, 6 months
[JBoss JIRA] (TEIIDSB-216) We get error with methadata in Salesforce request
by Renat Eskenin (Jira)
Renat Eskenin created TEIIDSB-216:
-------------------------------------
Summary: We get error with methadata in Salesforce request
Key: TEIIDSB-216
URL: https://issues.redhat.com/browse/TEIIDSB-216
Project: Teiid Spring Boot
Issue Type: Bug
Components: datasource
Reporter: Renat Eskenin
We get error from Teiid:
{code}
SQL state [50000]; error code [30504]; TEIID30504 salesforce: Unrecognized header: {http://soap.sforce.com/2006/04/metadata}DebuggingInfo; nested exception is org.teiid.jdbc.TeiidSQLException: TEIID30504 salesforce: Unrecognized header: {http://soap.sforce.com/2006/04/metadata}DebuggingInfo
{code}
As I think this error faired when we have connection timeout to Salesforce. In other time all works fine.
--
This message was sent by Atlassian Jira
(v7.13.8#713008)
4 years, 6 months
[JBoss JIRA] (TEIIDSB-211) create an s3 file source
by Steven Hawkins (Jira)
[ https://issues.redhat.com/browse/TEIIDSB-211?page=com.atlassian.jira.plug... ]
Steven Hawkins commented on TEIIDSB-211:
----------------------------------------
The initial implementation has been added, which I am porting to wildfly. We still need:
- the s3.mustache file
- the dependency added to the data util project
- a teiid spring boot example
- a cr example for the operator
> create an s3 file source
> -------------------------
>
> Key: TEIIDSB-211
> URL: https://issues.redhat.com/browse/TEIIDSB-211
> Project: Teiid Spring Boot
> Issue Type: Feature Request
> Components: datasource
> Reporter: Steven Hawkins
> Assignee: Aditya Manglam Sharma
> Priority: Major
> Fix For: 1.6.0
>
>
> The existing s3 support is implemented as a translator / ws source combo. We instead need this to be just a source to allow for translators to utilize it (excel, parquet, avro).
> As an alternative to our existing support we should evaluate utilizing the sdk rather than providing our own processing logic. More than likely this will be a quicker path to things like s3 select support. However ceph seems to lag in s3 support (see TEIID-5935 and no s3 select support) so we'd have to compensate, make the metadata and/or the capabilities specific to the connection type.
--
This message was sent by Atlassian Jira
(v7.13.8#713008)
4 years, 6 months