[teiid-issues] [JBoss JIRA] (TEIID-4552) Missing support for connection to Facebook via OAuth 2

[Lucie Fabrikova (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-4552?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13407618#comment-13407618 ] 

Lucie Fabrikova commented on TEIID-4552:
----------------------------------------

I am sorry for late response, generated access token is not null and works correctly e.g. directly in web browser (https://graph.facebook.com/v2.7/myUserId?access_token=myGeneratedAT)

However I have difficulties with using the generated security domain for facebook resource adapter. If I deploy vdb like the one attached and execute query like:
call facebook.invokeHTTP(endpoint=>'https://graph.facebook.com/v2.7/myUserId/feed?access_token=myGeneratedAT&message=xy', action=>'POST'), attached error is thrown. 
I generated access token with teiid-oauth-util.sh in teiid-9.3.0.Beta3, urls are left default, scope user_posts.

(If I removed from resource adapter definition the SecurityType config-property and security-domain, I can execute the query correctly.)

> Missing support for connection to Facebook via OAuth 2
> ------------------------------------------------------
>
>                 Key: TEIID-4552
>                 URL: https://issues.jboss.org/browse/TEIID-4552
>             Project: Teiid
>          Issue Type: Feature Request
>          Components: Misc. Connectors
>    Affects Versions: 8.12.5
>            Reporter: Lucie Fabrikova
>            Assignee: Kylin Soong
>             Fix For: 9.3
>
>         Attachments: facebook3-vdb.xml, query, server.log, standalone.xml, teiid-oauth-util.sh-output
>
>
> I would like to connect to facebook resource adapter and configure OAuth 2 security domain for it; I used teiid-oauth-util.sh to generate the security domain (see attachment). Facebook doesn't support refresh tokens and in the generated code is refresh token's value "null".
> If I try to execute VDB with source pointing to such resource adapter I get error:
>  ERROR [org.teiid.CONNECTOR] (Worker0_QueryProcessorQueue13) Connector worker process failed for atomic-request=Gapuea1/NRcn.6.3.0: org.apache.cxf.rs.security.oauth2.provider.OAuthServiceException
>  
> (see server.log, facebook-vdb.xml, standalone.xml)



--
This message was sent by Atlassian JIRA
(v7.2.3#72005)