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

[Nayan Bija (Jira)]

    [ https://issues.redhat.com/browse/TEIID-6017?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14392983#comment-14392983 ] 

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/teiid/wildfly/teiid-wildfly/15.0.0/teiid-wildfly-15.0.0-server.zip]

 

 

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://storage.googleapis.com/]</config-property>
>  <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)