The authentication type 10 is not supported

最新推荐文章于 2024-11-14 13:28:22 发布

苹榆枫

最新推荐文章于 2024-11-14 13:28:22 发布

阅读量4k

点赞数 1

CC 4.0 BY-SA版权

分类专栏：大数据文章标签： postgresql 数据库 hive

本文链接：https://blog.youkuaiyun.com/pingyufeng/article/details/125995317

大数据专栏收录该内容

13 篇文章

订阅专栏

在尝试使用Hive Metastore连接PostgreSQL时遇到了认证类型不支持的错误，错误信息为'The authentication type 10 is not supported'。解决方法包括修改pg_hba.conf配置文件，将所有连接的认证方式改为'trust'，或者将认证方式改为'scram-sha-256'。这两种方法都可以解决Hive与PostgreSQL之间的认证兼容性问题。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

hive-metastore 连接postgresql

报错The authentication type 10 is not supported

修改pg_hba.conf配置文件当中的ipv4如下

# TYPE  DATABASE        USER            ADDRESS                 METHOD

# "local" is for Unix domain socket connections only
local   all             all                                     trust
# IPv4 local connections:
#host   all             all             127.0.0.1/32            trust
host    all             all             0.0.0.0/0               trust
# IP6 local connections:
host    all             all             ::1/128                 trust
# Allow replication connections from localhost, by a user with the
# replication privilege.
local   replication     all                                     trust
host    replication     all             127.0.0.1/32            trust
host    replication     all             ::1/128                 trust

host all all all scram-sha-256

或者

解决方法将pg_hba.conf由"host all all all scram-sha-256"改"host all all all trust"
····

The authentication type 10 is not supported