search

apache / arrow-flight-sql-postgresql

Apache Arrow Flight SQL adapter for PostgreSQL
https://arrow.apache.org/flight-sql-postgresql/
Apache License 2.0
65 stars 9 forks source link

IOError: Invalid: SCRAM auth method isn't supported yet #187

Closed tumluliu closed 4 months ago

tumluliu commented 4 months ago

Hi, thank you for making this very nice library. I'm trying it by following the [official doc]() but could not even make the "How to connect" successful. It complained with:

IOError: Invalid: SCRAM auth method isn't supported yet. Detail: Unauthenticated. Detail: Unauthenticated

at this line I believe:

ARROW_ASSIGN_OR_RAISE(auto bearer_token, client->AuthenticateBasicToken(call_options, user, password));

From the postgresql server side, I saw such a log entry accordingly:

2024-05-15 15:38:25.605 UTC [263] LOG:  background worker "arrow-flight-sql: executor: 16118212404317981807" (PID 28668) exited with exit code 1

And I can confirm the provided user and password are correct. Could you please provide me some hints that where the problem could be? Thanks a lot!

tumluliu commented 4 months ago

ok, I found the reason. It's not yet implemented according to here. Will adjust my pg_hba accordingly, and close this issue

kou commented 4 months ago

Right. Challenge-response style auths aren't implemented yet.