[PostgreSQL 14.1] Why is the connection wrong and the encryption method is scram-sha-256?

leafo / pgmoon

A pure Lua Postgres driver for use in OpenResty & more

MIT License

390 stars 93 forks source link

[PostgreSQL 14.1] Why is the connection wrong and the encryption method is scram-sha-256? #121

Closed mpv945 closed 1 month ago

mpv945 commented 2 years ago

select version(); PostgreSQL 14.1 (Debian 14.1-1.pgdg110+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 10.2.1-6) 10.2.1 20210110, 64-bit

select rolname,rolpassword from pg_authid where rolname = 'postgres'; SCRAM-SHA-256$4096:Oyg9TWU4+8qPPFwyy4VjUQ==$cwANuKpk/GBP+G5uUH6qDZKc9R+yry82RRU6GsV1I=:5mR7hX16C1T9MtRWUDdsFf/y6MlkDJSw1vxLCKKMGAM=

leafo commented 2 years ago

I'm not sure what you're asking. What do yo expect to see and how did you try connecting?

mpv945 commented 2 years ago

我不确定你在问什么。您希望看到什么？您是如何尝试连接的？

I'm not sure what you're asking. What do yo expect to see and how did you try connecting?

The connection of database version 14 is not successful. It is normal to return to version 13. But pgmoon-v1 14.0 has not solved the encryption processing of [PostgreSQL 14.1] scram-sha-256?