From edcab78dd4b5fcf06e27c3d0d00c57567d68f66a Mon Sep 17 00:00:00 2001 From: HimbeerserverDE Date: Tue, 18 Jul 2023 18:43:11 +0200 Subject: fix UPSERTion of postgres users / passwords --- auth_mtpostgresql.go | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'auth_mtpostgresql.go') diff --git a/auth_mtpostgresql.go b/auth_mtpostgresql.go index ffd932c..fe4b9c7 100644 --- a/auth_mtpostgresql.go +++ b/auth_mtpostgresql.go @@ -134,7 +134,7 @@ func (a *AuthMTPostgreSQL) Passwd(name string) (salt, verifier []byte, err error func (a *AuthMTPostgreSQL) SetPasswd(name string, salt, verifier []byte) error { encodedPasswd := encodeVerifierAndSalt(salt, verifier) - _, err := a.db.Exec("REPLACE INTO auth (name, password, last_login) VALUES ($1, $2, unixepoch());", name, encodedPasswd) + _, err := a.db.Exec("INSERT INTO auth (name, password, last_login) VALUES ($1, $2, extract(epoch from now())) ON CONFLICT (name) DO UPDATE SET password = EXCLUDED.password, last_login = extract(epoch from now());", name, encodedPasswd) return err } -- cgit v1.2.3