[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:all-tabpanel ]

Nayan Bija updated TEIID-6017:
------------------------------
    Description: 
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?

 

 

 

 

  was:
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?

 

 

 

 



> 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)