topic Re: The authentication type 10 is not supported in Data Engineering

The authentication type 10 is not supported

LoiNguyen — Tue, 27 Jul 2021 10:32:32 GMT

I use below code to connect to postgresql.

df = spark.read \ 
    .jdbc("jdbc:postgresql://hostname:5432/dbname", "schema.table",
          properties={"user": "user", "password": "password"})\
      .load()
df.printSchema()

However, I got the following error

org.postgresql.util.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.

Can anyone help me to solve this problem? Thanks.

Re: The authentication type 10 is not supported

mlapierre — Wed, 06 Apr 2022 14:37:15 GMT

Hi, were you able to solve the issue? I just ran into the same problem and haven't found any other discussions on this.

Re: The authentication type 10 is not supported

DBXC — Wed, 26 Apr 2023 15:04:45 GMT

try the following to check connectivity between Databricks and your DB server

%sh ping servername

%sh ping IP_Of_your_server

If no connectivity, you would need to check your firewall / vNet and DNS mapping as Databricks takes fully qualify DNS instead server name with ports (assuming this is how you access your DB server "locally" in your network)

Re: The authentication type 10 is not supported

HaroldAlvarado — Wed, 16 Aug 2023 10:45:22 GMT

Hey there! I can understand that this types of issue is frustrating for any users. If you are Mac user and still struggling with the authentication problem on this site then you can check this source- https://setapp.com/how-to/how-to-flush-dns-cache that can be helpful to solve this type of problem. In this article they share complete tutorial about how to flush DNS cache on Mac. Good Luck for you.

Re: The authentication type 10 is not supported

simboss — Tue, 05 Sep 2023 06:54:50 GMT

But how are we going to do this for those who use Windows?

Re: The authentication type 10 is not supported

AntonioR — Mon, 18 Mar 2024 16:41:15 GMT

in Windows the command is

ipconfig /flushdns