Purview access postgresql Error: (3912) Connector Exception

Eduardo Evangelista 1

I try to scan a Azure Postgresql database in Azure purview but receive this message:

"Error: (3912) Connector Exception: Unable to access the with the given credentials."

The Purview account have the get and list in secret permission.

The same credention and secret works fine in Data Factory connection.

Is there something I'm doing wrong?

GeethaThatipatri-MSFT 29,282 Reputation points Microsoft Employee

2022-09-30T15:20:56.32+00:00

Hi, @Eduardo Evangelista Welcome to the Microsoft Q&A platform, thanks for posting the question and for using Azure Services.
Can you please share the steps you followed? also the screenshot of the error message.
let me reproduce it in my environment and provide you with more details.

Regards
Geetha

2 answers

GeethaThatipatri-MSFT 29,282 Reputation points Microsoft Employee

2022-09-30T19:37:20.127+00:00

Hi, @Eduardo Evangelista I tried to reproduce the issue from my end and it was a successful connection.
I hope you are trying to connect to Postgres single server and using SQL authentication

Please follow this document and prerequisites also do share the error screenshot and the steps you followed.

Make sure you add the IP address under the connection settings firewall rule.

Regards
Geetha
Please sign in to rate this answer.

0 comments No comments
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.
Eduardo Evangelista 1 Reputation point

2022-09-30T19:50:39.017+00:00

The credentials has connected successfully but, gave me the same error in purview scan.

These are the steps below:
Please sign in to rate this answer.
GeethaThatipatri-MSFT 29,282 Reputation points Microsoft Employee

2022-10-03T20:01:39.807+00:00

@Eduardo Evangelista Can you please share the Run ID.

Regards
Geetha

Eduardo Evangelista 1 Reputation point

2022-10-04T20:19:23.533+00:00

Eduardo Evangelista 1 Reputation point

2022-10-04T20:20:09.797+00:00

This the run id in string:
7eecfd3d-2011-4a98-ad46-1c3969b01ac7

GeethaThatipatri-MSFT 29,282 Reputation points Microsoft Employee

2022-10-05T23:28:19.413+00:00

Thanks, @Eduardo Evangelista we will look into it and provide you with more details.

Regards
Geetha

GeethaThatipatri-MSFT 29,282 Reputation points Microsoft Employee

2022-10-10T13:48:02.093+00:00

@Eduardo Evangelista wants to double confirm here if you have tested in ir? was the connect succeed?

GeethaThatipatri-MSFT 29,282 Reputation points Microsoft Employee

2022-10-11T20:41:12.027+00:00

@Eduardo Evangelista Did you get a chance to check the connection?

Regards
Geetha

Eduardo Evangelista 1 Reputation point

2022-10-13T17:05:08.71+00:00

I can't test because I need a SSL connection choice in this integration runtime test.
But, with the same credential, but using in Data Factory, the connection works fine.

The error and print are below:
Failed to connect to the database. Error message: ERROR [08S01] [Microsoft][ODBC PostgreSQL Wire Protocol driver]Socket closed.
ERROR [08S01] [Microsoft][ODBC PostgreSQL Wire Protocol driver]Socket closed.
ERROR [28000] [Microsoft][ODBC PostgreSQL Wire Protocol driver][PostgreSQL]FATAL: SSL connection is required. Please specify SSL options and retry.(File auth.c; Line 481; Routine ClientAuthentication; )
ERROR [08S01] [Microsoft][ODBC PostgreSQL Wire Protocol driver]Socket closed.
ERROR [08S01] [Microsoft][ODBC PostgreSQL Wire Protocol driver]Socket closed.
ERROR [28000] [Microsoft][ODBC PostgreSQL Wire Protocol driver][PostgreSQL]FATAL: SSL connection is required. Please specify SSL options and retry.(File auth.c; Line 481; Routine ClientAuthentication; )

GeethaThatipatri-MSFT 29,282 Reputation points Microsoft Employee

2022-10-13T19:47:25.373+00:00

@Eduardo Evangelista Do you mean you want to know how to fix the socket error?
Azure PostgreSQL socket close issue, which may be related to ssl configuration. The successful scan requires pass test connection in IR. Please pass the test connection.

Regards
Geetha
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.