Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Trouble connecting to remote postgres database: "PSQLException: The authentication type 10 is not supported" #760

Closed
Tracked by #765
jonnance opened this issue Oct 7, 2023 · 2 comments
Assignees
Labels
question Further information is requested Stale

Comments

@jonnance
Copy link

jonnance commented Oct 7, 2023

When attempting to run a query on a remote postgres database, I am receiving the following error in Legend Studio:
PSQLException: The authentication type 10 is not supported. Check that you have configured the pg_hba.conf file to include the client's IP address or subnet, and that it is using an authentication scheme supported by the driver.

I conducted the following steps

  1. Set up a Database store in Studio and specified the schema in line with my database via the text editor
  2. Created a Connection with (note that the vault reference is also set to point to variables I have created under "\installers\docker-compose\engine\config\vault")

RelationalDatabaseConnection target::DBConnect
{
store: store::TestDatabase;
type: Postgres;
quoteIdentifiers: false;
specification: Static
{
name: '';
host: '';
port: 5432;
};
auth: UserNamePassword
{
userNameVaultReference: 'postgres.username';
passwordVaultReference: 'postgres.password';
};
}

  1. Created a pure class
  2. Created a data mapping between the pure class and my database
  3. Created a runtime
  4. Right clicked on my pure class and clicked query

Is there a different method that I should use to authenticate to this postgres database?

@jonnance jonnance added the question Further information is requested label Oct 7, 2023
@finos-admin
Copy link
Member

This issue is stale because it has been open for 30 days with no activity. Please remove stale label or add any comment to keep this open. Otherwise this will be closed in 5 days.

@finos-admin
Copy link
Member

This issue was closed because it has been inactive for 35 days. Please re-open if this issue is still relevant.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
question Further information is requested Stale
Projects
None yet
Development

No branches or pull requests

4 participants