我正在尝试在JDBC中测试SCRAM-SHA-256。
public static void main(String[] args) throws SQLException {
String url = "jdbc:postgresql://192.168.56.101:1521/gisdb";
Properties props = new Properties();
props.setProperty("user", "pguser");
String scram = "SCRAM-SHA-256$4096:QNTBYMpbvZjbOx5RLM7rvA==$tuBD7Ek7niK8jyiuwjCGLH2EurqMNoIaclZhOXohyik=:2b0Ow951/1OPKsqzaGLWPyT+wVIXOs9dvY8TF2eTCVM=";
props.setProperty("password", scram);
// props.setProperty("password", "*******");
Connection conn = DriverManager.getConnection(url, props);
String databaseProductVersion = conn.getMetaData().getDatabaseProductVersion();
System.out.println(databaseProductVersion);
}
我的pg_hba.conf
:
hostssl all all 192.168.0.0/16 scram-sha-256
#hostssl all all 192.168.0.0/16 trust
select rolname,rolpassword from pg_authid;
这条命令会显示:
rolname | rolpassword
---------------------------+---------------------------------------------------------------------------------------------------------------------------------------
pg_monitor |
pg_read_all_settings |
pg_read_all_stats |
pg_stat_scan_tables |
pg_read_server_files |
pg_write_server_files |
pg_execute_server_program |
pg_signal_backend |
pguser | SCRAM-SHA-256$4096:PZNbiF6I5G1SVcoN9sTjJw==$xe8jrBS9iUn0ldoIV8moaAod06sYRbxsyyQaUbiuSQE=:2tpLS+eL1brme0Il0wcnsllkDBfDkaQ/II7iVJ3ecxM=
test |
postgres | SCRAM-SHA-256$4096:o1lyjT/acTglIuLsp6TF3Q==$pdWLZ8DuceZDwr9jla0WPzXXa3N3kWrjh9cPnrloP3w=:6hd8Ib7Od+ZZenItVoH4L+26oSiBxqp63WxO82PeonM=
当我在Java代码中使用
scram-sha-256
加密的密码字符串或者纯密码进行连接时,在日志文件中会显示 FATAL: password authentication failed for user "pguser"
。当我将方法更改为 trust
在pg_hba.conf
中,它可以正常工作。如何使用 scram-sha-256
方法进行密码连接?我的JDBC驱动程序版本是 postgresql-42.2.12.jar
。
postgresql-42.2.12.jar
- gooin