[JBoss JIRA] (TEIID-6017) Not able to connect GCP bucket using S3 translator

Thursday, 13 August 2020

    [
https://issues.redhat.com/browse/TEIID-6017?page=com.atlassian.jira.plugi...
] 

Nayan Bija commented on TEIID-6017:
-----------------------------------

Hi,

Thanks for your suggestion,

We are using Teiid 15.0.0 version and downloaded it from below link.

[https://oss.sonatype.org/service/local/repositories/releases/content/org/...]

And I am also making changes step by step.

First I have configured the adapter by using Google Bucket secret key.

then I have created a above dummy VDB just to check the connectivity with the Google
Storage.

But connection is not estabilishing. hence I am not getting what exactly missing here.

Whether there is a problem in adapter or I am following wrong approch.

I have done below things till now.
 #  Download Teiid 15.0.0
 #  Created bucket on Google Storage.
 #  Created a access key and secret key 
 #  Created a adapter by adding google access key and secret key
 #  Created  a dummy VDB to test connection.
 #  Trying to make connction.

Could you please convey me if I am missing anything?

...
 Not able to connect GCP bucket using S3 translator
 --------------------------------------------------

                 Key: TEIID-6017
                 URL: https://issues.redhat.com/browse/TEIID-6017
             Project: Teiid
          Issue Type: Feature Request
            Reporter: Nayan Bija
            Assignee: Steven Hawkins
            Priority: Major

 As suggested in the ticket TEIID-6015
 We have tried to connect the GCP bucket using the S3 translator(not amazon-s3).
 As mentioned, S3  doesn't support google authentication,
 so we have created access key and secret key of Google bucket by logging into the GCP
accoudnt.
 We have followed below steps to create access key and secret key.
 _*Storage->Setting->INTEROPERABILITY-> Service account HMAC->Create a key for
service account"*_

 We have also created below adapter file and VDB but still, we are not able to connect to
GCP.

 <resource-adapter id="amazon-s3-custom">
  <module slot="main"
id="org.jboss.teiid.resource-adapter.s3"/>
  <transaction-support>NoTransaction</transaction-support>
  <connection-definitions>
  <connection-definition
class-name="org.teiid.resource.adapter.s3.S3ManagedConnectionFactory"
jndi-name="java:/s3DS" enabled="true"
use-java-context="true" pool-name="teiid-s3-ds">
  <config-property name="bucket">abc</config-property>
  <config-property
name="endpoint">[https://storage.googleapis.com|https://stor...
  <config-property name="secretKey">xxx</config-property>
  <config-property name="accessKey">xxx</config-property>
  </connection-definition>
  </connection-definitions>
  </resource-adapter>

 VDB
 ----

 <?xml version="1.0"?>
  <vdb name="gcp" version="1">
  <connection-type>BY_VERSION</connection-type>
  <model name="s3">
  <source name="web-connector" translator-name="amazon-s3-custom"
connection-jndi-name="java:/s3DS"/>
  </model>
 <translator name="amazon-s3-custom" type="amazon-s3">
  <property name="accesskey" value="xxx"/>
  <property name="secretkey" value="xxx"/>
  <property name="bucket" value="abc"/>
  </translator>
  </vdb

 as we tried to connect we are getting below error.

 *_"_*_org.teiid.jdbc.TeiidSQLException: TEIID20018 Unable to find a component used
authenticate on to Teiid_*_"_*

 In the above configuration, where should we mention the File name?
 As I have read the properties in the documentation, I could see bucket property, where we
can add a bucket name. but where should we add the file name which is present in the
bucket?

 Could you please help us with it?

--
This message was sent by Atlassian Jira
(v7.13.8#713008)

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009