search

GlareDB / glaredb

GlareDB: An analytics DBMS for distributed data
https://glaredb.com
GNU Affero General Public License v3.0
678 stars 39 forks source link

What kind of client authentication when connecting to a local instance? #2040

Open Seddryck opened 1 year ago

Seddryck commented 1 year ago

I'm a bit struggling to connect to a local instance of GlareDB. I'm successful with psql but not with the Npgsql data provider in .NET. Could you confirm if the client authentication is Trust Authentication?

64J0 commented 2 months ago

I'm also having trouble using npgsql!

It does not work with dbeaver too.

But it works with psql.

talagluck commented 2 months ago

Thanks for opening this issue @Seddryck and thanks for adding, @64J0!

We don't recommend the local server use-case for anything aside from testing, really, and we haven't tested it much with other tools.

@64J0, are your issues with npgsql and dbeaver for the local server, or for GlareDB Cloud? What errors are you getting?

64J0 commented 2 months ago

@64J0, are your issues with npgsql and dbeaver for the local server, or for GlareDB Cloud? What errors are you getting?

For the local server. It's related to the protocol these tools use. I did open an issue at the npgsql repo as well -> https://github.com/npgsql/npgsql/issues/5809.

talagluck commented 2 months ago

Thanks for the update, @64J0!

We're currently working on the connection to dbeaver. The error I'm hitting:

SQL Error [XX000]: ERROR: Error during planning: Invalid function 'format_type'.
Did you mean 'flatten'?

has to do with a Postgres function which hasn't yet been implemented in GlareDB, and so we're working on implementing that now. This is connecting to GlareDB Cloud, rather than the local postgres server.

Could you please share the error you're getting as well as how you're specifying your config?

I'd also love to know more about how you're using the local server - it's not something we really document, and it would be great to understand what need it's meeting.

Seddryck commented 2 months ago

Regarding the use case for the local server instance, I'm trying to use it for some integration tests in our CI/CD pipelines. We don't want these pipelines to rely on remote (especially web) resources.

talagluck commented 2 months ago

Thanks for the follow up, @Seddryck! Has this been blocking your usage of GlareDB?

talagluck commented 2 months ago

I wanted to follow up with our progress here. We have a PR open to implement the function which unblocks the first bug we were hitting (the unimplemented format_type function). The issue is that we're still hitting a second error here due to the connection query generated by DBeaver, and the way that DataFusion handles columns in joins with the same name; it won't be possible for us to resolve this directly.

However, we're in the process of building a new execution engine, which we're planning on merging into this repo in the next month or two. Once we have that, we should be able to bypass this issue entirely.

Thanks for your patience, and please let me know if there's anything else we can do to help!