Level up your Box knowledge with brand new learning paths on Box University. Visit training.box.com to get started

Box Status

CDATA ODBC issue Error: redirect_uri_mismatch

Follow
New post
Krzysztof Wypijewski

Dear Support Community

I am trying  integrate Tibco SPotfire with BOX.com using CDATA  JDBC and ODBC driver.

Unfortynetly I cannot connect even via ODBC

How I did it :

1) Created aplication on dev BOX :

- Custom APP with "Client credntials grant"

-  Authorization has been approve by enterprise admins

- get the ID adn client secret

2)  installed ODBC driver

- put the Client ID and the Client secret  into ODBC configuration

- calback URL set to  :https://localhost:33333

I cannot connect in any know me way

The errros is :

Error: redirect_uri_mismatch

 
Show Error Details
  • response_type=code
  • redirect_uri=http://localhost:33333
  • client_id=xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

 

Could you please take a look and let me know what i did wrong

 

Thanks in advance

Chris

 

 

-

 

0

Comments

3 comments

Date Votes
  • Kourtney
    • Edited

    Hello, 

    This error indicates that the redirect URL passed in the authorization URL does not match exactly to what is configured in the developer console. From the details above it looks like one is HTTPS and one is HTTP. 

    Best,

    Kourtney, Box Developer Advocate

    0
    Comment actions Permalink
  • Krzysztof Wypijewski

    Hello Kourtney

    Thanks for the answer
    Please see where we are now 
    ODBC  works fine 
    JDBC we can connect to source 
    we can create info links (spotfire elements)
    we can see whole content from BOX
     
    Unfortunately we cannot get any data :
     
    Error message: Could not open information link.
    ImportException at Spotfire.Dxp.Data:
    Failed to create DataTable (HRESULT: 80131500)
    InformationModelException at Spotfire.Dxp.Data:
    An Internal Error has occurred. com.spotfire.ws.dat.OperatorException: unexpected exception (HRESULT: 80131500)
     
     
    1) we created OAuthVerifier 
    2) put OAuthVerifier  into the driver and set InitiateOAuth: Set this to REFRESH. 
    3) we received the file with encrypted:PASSWORD
    4 put the file to Spotfire linux server where the driver is installed 
    5) We cannot Test the connection to authenticate in the browser. as this is linux 
    5   from the end client we used URL from the client jdbc:box:InitiateOAuth="GETANDREFRESH";OAuthAccessToken="";OAuthClientId="";OAuthClientSecret="";OAuthSettingsLocation=/opt/spotfire/tibco/OAuthSettings.txt;OAuthVerifier="Pxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx";
     
    Cheers
    Chris

     

    0
    Comment actions Permalink
  • Kourtney

    Hey Chris, 

    Im not sure this error is coming from the Box end of things. I'd be happy to take a quick look at our backend logs to see if anything jumps out if you can provide me the client ID. I do want to note that this driver was built by and is maintained by CDATA so their support team would be the best starting point for ensuring everything is set up correctly/troubleshooting. 

    Best,

    Kourtney, Box Developer Advocate

    0
    Comment actions Permalink

Please sign in to leave a comment.