SNI workaround not working for PopSQL
I'm trying to set up PopSQL with my database. On neon docs it says that SNI workaround D is required, however, when I set the password field with the schema
endpoint=<endpoint_id>;<password> or endpoint=<endpoint_id>$<password> both result in the error Uh oh :( password authentication failed for user <username>8 Replies
sunny-green•2y ago
cc @Conrad Ludgate
fair-rose•2y ago
Can you double-check that your connection fields are defined as in this example:
Given a connection string that looks like this (yours will differ):
postgres://alex:AbC123dEf@ep-cool-darkness-123456.us-east-2.aws.neon.tech/dbname
These would be your values:
hostname: ep-cool-darkness-123456.us-east-2.aws.neon.tech
port: 5432
database name: dbname
Role: alex
Password: endpoint=ep-cool-darkness-123456;AbC123dEf
rival-blackOP•2y ago
thanks I've confirmed all of the above, but still no luck
One difference is that popsql is that it says
Username instead of Rolerare-sapphire•2y ago
Can you DM me your endpoint ID, I can try and take a look in our logs for you
From the looks of it, you don't need the SNI workaround. In fact, I think that's why you're getting an error. I see logs for your endpoint with
Ok, debugged with @diay some more in DMs. This is a really annoying situation. popsql in the editor uses their own sql client setup ("application_name": "popsql"Connection with sni
application_name=popsql, supports SNI). But popsql dashboards run as a job in sidekiq (application_name=sidekiq 6.4.0 worker-md [1 of 6 busy], does not support SNI).
I don't think we have a workaround that works in these conditions right now.
I am at least able to reproduce the issuerival-blackOP•2y ago
Thanks for investigating
Ok, will look to use other solutions for the time being
fair-rose•2y ago
I sent an email to PopSQL informing them of the issue. We'll drop PopSQL from our list of supported clients for now.
optimistic-gold•2y ago
I have encountered the same issue with PopSQL, is there a workaround?
fair-rose•2y ago
Hi, this was the response from PopSQL.
