flight-sql-server-example: Some bug with "Detail: Unauthenticated Invalid bearer token provided. Detail: Unauthenticated"

Dbeaver log:

cfjd.org.apache.arrow.flight.FlightRuntimeException: UNAUTHENTICATED: Invalid bearer token provided. Detail: Unauthenticated cfjd.org.apache.arrow.flight.FlightRuntimeException: UNAUTHENTICATED: Invalid bearer token provided. Detail: Unauthenticated Invalid bearer token provided. Detail: Unauthenticated

Tableau log:

Unable to complete action Bad Connection: Tableau could not connect to the data source. Error Code: FAB9A2C5 cfjd.org.apache.arrow.flight.FlightRuntimeException: UNAUTHENTICATED: Invalid bearer token provided. Detail: Unauthenticated Generic JDBC connection error cfjd.org.apache.arrow.flight.FlightRuntimeException: UNAUTHENTICATED: Invalid bearer token provided. Detail: Unauthenticated

Context: After docker run I can properly get access to dbever. but when I just try to connect with tableau it show UNAUTHENTICATION issue . After I go back to dbever and it shows same UNAUTHENTICATION issue till I restart docker.

This is terminal docker log.

2023-11-06 22:06:30 Client running SQL command:     
2023-11-06 22:06:30 SELECT * FROM "customer";  # Dbeaver select 
2023-11-06 22:06:30 
2023-11-06 22:06:35 Client running SQL command: 
2023-11-06 22:06:35 SELECT VERSION();  # dbeaver version select 
2023-11-06 22:06:35 
2023-11-06 22:07:17 Bearer Token verification failed with exception: failed to verify signature: VerifyFinal failed   #Tableau try to access 
2023-11-06 22:07:17 Client running SQL command: 
2023-11-06 22:07:17 SELECT 1;
2023-11-06 22:07:17

It happens when I try to connect from Tableau with “Mysql” dialect and Postgres dialect. It shows nothing with SQL92. Снимок экрана 2023-11-06 в 22 10 09

About this issue

Original URL
State: closed
Created 8 months ago
Comments: 26

Commits related to this issue

Fixes #11 — committed to prmoore77/flight-sql-server-example by prmoore77 7 months ago

Most upvoted comments

By the way - that kamu tool looks very cool! Thanks for sharing.

prmoore77 on Dec 5, 2023

@prmoore77 Finally I run flight sql, but with kamu-cli project … to be sure that tableau is working.

tables showed properly and with sql92 dialect. (ok, 98% properly 😃, some sql errors still exist

based on this example https://github.com/kamu-data/kamu-cli/tree/master/examples/trading and run this

cd trading
kamu init
kamu add . --recursive
kamu pull --all
kamu sql server --flight-sql

Connect using URL: jdbc:arrow-flight-sql://127.0.0.1:10000?useEncryption=false Use ‘kamu’ as login and password

YuriyGavrilov on Dec 5, 2023

Oh - also, I think you can now remove the &token=null from the JDBC url (since we updated the code)…

prmoore77 on Dec 5, 2023

@prmoore77 plan to test it today evening… will come back to you after.

YuriyGavrilov on Dec 4, 2023

@prmoore77 I’ve also made some changes in arrow. May be you should know it to make some adoption. https://github.com/apache/arrow/issues/38253 (https://github.com/apache/arrow/issues/38737 - this PR) or may be need to add different issue it but anyway I put it here may be nothing needs to do)

YuriyGavrilov on Dec 4, 2023

Yep, I’m sure it’s true. Will fix my environment and retest. Many thx 🙏 for your help @prmoore77

YuriyGavrilov on Dec 1, 2023

@YuriyGavrilov - I believe I’ve fixed the issue. Could you validate?

prmoore77 on Dec 1, 2023