pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedHow to create a postgres user that auth by AUTH_REQ_MD5
2+ messages / 2 participants
[nested] [flat]
* How to create a postgres user that auth by AUTH_REQ_MD5
@ 2019-05-09 07:48 Hoa Phan <s50600822@gmail.com>
0 siblings, 1 reply; 2+ messages in thread
From: Hoa Phan @ 2019-05-09 07:48 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
How do I create user that required AUTH_REQ_MD5 or config database so that
it require AUTH_REQ_MD5 ?
I need to reproduce the following issue where postgres failed to login and
I can confirm that the raw username/pass is perfectly fine and JDBC is
happy to connect if only it's not AUTH_REQ_MD5. I dont know how on that env
it ends up being the case.
org.postgresql.util.PSQLException: FATAL: password authentication failed
for user "hoaphan
"
at
org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:516)
at
org.postgresql.core.v3.ConnectionFactoryImpl.tryConnect(ConnectionFactoryImpl.java:141)
at
org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:192)
at
org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:49)
at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:195)
at org.postgresql.Driver.makeConnection(Driver.java:454)
at org.postgresql.Driver.connect(Driver.java:256)
at
com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:136)
at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:369)
at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:198)
at
com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:467)
at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:541)
at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:115)
at
com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:112)
at
org.flywaydb.core.internal.jdbc.JdbcUtils.openConnection(JdbcUtils.java:56)
at
org.flywaydb.core.internal.database.DatabaseFactory.createDatabase(DatabaseFact
Regards,
Hoa Phan.
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: How to create a postgres user that auth by AUTH_REQ_MD5
@ 2019-05-09 14:03 Tom Lane <tgl@sss.pgh.pa.us>
parent: Hoa Phan <s50600822@gmail.com>
0 siblings, 0 replies; 2+ messages in thread
From: Tom Lane @ 2019-05-09 14:03 UTC (permalink / raw)
To: Hoa Phan <s50600822@gmail.com>; +Cc: pgsql-admin@lists.postgresql.org
Hoa Phan <s50600822@gmail.com> writes:
> How do I create user that required AUTH_REQ_MD5 or config database so that
> it require AUTH_REQ_MD5 ?
That's determined by your pg_hba.conf rules. If you really want to
have just one user acting that way, you can use a rule that keys on
user name; but it's an unusual thing to do I think.
https://www.postgresql.org/docs/current/auth-pg-hba-conf.html
regards, tom lane
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2019-05-09 14:03 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2019-05-09 07:48 How to create a postgres user that auth by AUTH_REQ_MD5 Hoa Phan <s50600822@gmail.com>
2019-05-09 14:03 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox