* [bug#36191] [PATCH] gnu: postgres service: More secure default permissions.
@ 2019-06-13 13:50 Robert Vollmert
2019-06-25 15:40 ` Ludovic Courtès
0 siblings, 1 reply; 5+ messages in thread
From: Robert Vollmert @ 2019-06-13 13:50 UTC (permalink / raw)
To: 36191; +Cc: Robert Vollmert
This changes to 'peer' authentication for local socket connections,
and password-based authentication for local network connections.
* gnu/services/databases.scm (%default-postgres-hba): Change
authentication method.
---
gnu/services/databases.scm | 7 ++++---
1 file changed, 4 insertions(+), 3 deletions(-)
diff --git a/gnu/services/databases.scm b/gnu/services/databases.scm
index 7113f1f2a1..ec31489d48 100644
--- a/gnu/services/databases.scm
+++ b/gnu/services/databases.scm
@@ -5,6 +5,7 @@
;;; Copyright © 2017 Christopher Baines <mail@cbaines.net>
;;; Copyright © 2018 Clément Lassieur <clement@lassieur.org>
;;; Copyright © 2018 Julien Lepiller <julien@lepiller.eu>
+;;; Copyright © 2019 Robert Vollmert <rob@vllmrt.net>
;;;
;;; This file is part of GNU Guix.
;;;
@@ -91,9 +92,9 @@
(define %default-postgres-hba
(plain-file "pg_hba.conf"
"
-local all all trust
-host all all 127.0.0.1/32 trust
-host all all ::1/128 trust"))
+local all all peer
+host all all 127.0.0.1/32 md5
+host all all ::1/128 md5"))
(define %default-postgres-ident
(plain-file "pg_ident.conf"
--
2.20.1 (Apple Git-117)
^ permalink raw reply related [flat|nested] 5+ messages in thread
* [bug#36191] [PATCH] gnu: postgres service: More secure default permissions.
2019-06-13 13:50 [bug#36191] [PATCH] gnu: postgres service: More secure default permissions Robert Vollmert
@ 2019-06-25 15:40 ` Ludovic Courtès
2019-06-26 6:37 ` Giovanni Biscuolo
2019-06-28 22:25 ` [bug#36191] " Christopher Baines
0 siblings, 2 replies; 5+ messages in thread
From: Ludovic Courtès @ 2019-06-25 15:40 UTC (permalink / raw)
To: Robert Vollmert; +Cc: 36191
Hello,
Robert Vollmert <rob@vllmrt.net> skribis:
> This changes to 'peer' authentication for local socket connections,
> and password-based authentication for local network connections.
>
> * gnu/services/databases.scm (%default-postgres-hba): Change
> authentication method.
That sounds reasonable to me. Chris, WDYT?
Thanks,
Ludo’.
^ permalink raw reply [flat|nested] 5+ messages in thread
* [bug#36191] [PATCH] gnu: postgres service: More secure default permissions.
2019-06-25 15:40 ` Ludovic Courtès
@ 2019-06-26 6:37 ` Giovanni Biscuolo
2019-07-02 15:11 ` bug#36191: " Ludovic Courtès
2019-06-28 22:25 ` [bug#36191] " Christopher Baines
1 sibling, 1 reply; 5+ messages in thread
From: Giovanni Biscuolo @ 2019-06-26 6:37 UTC (permalink / raw)
To: Ludovic Courtès, Robert Vollmert; +Cc: 36191
[-- Attachment #1: Type: text/plain, Size: 563 bytes --]
Ludovic Courtès <ludo@gnu.org> writes:
> Robert Vollmert <rob@vllmrt.net> skribis:
>
>> This changes to 'peer' authentication for local socket connections,
>> and password-based authentication for local network connections.
>>
>> * gnu/services/databases.scm (%default-postgres-hba): Change
>> authentication method.
>
> That sounds reasonable to me. Chris, WDYT?
It's very reasonable to have such default auth methods for PostgresSQL:
we should apply this patch
Thanks Robert!
[...]
--
Giovanni Biscuolo
Xelera IT Infrastructures
[-- Attachment #2: signature.asc --]
[-- Type: application/pgp-signature, Size: 832 bytes --]
^ permalink raw reply [flat|nested] 5+ messages in thread
* [bug#36191] [PATCH] gnu: postgres service: More secure default permissions.
2019-06-25 15:40 ` Ludovic Courtès
2019-06-26 6:37 ` Giovanni Biscuolo
@ 2019-06-28 22:25 ` Christopher Baines
1 sibling, 0 replies; 5+ messages in thread
From: Christopher Baines @ 2019-06-28 22:25 UTC (permalink / raw)
To: Ludovic Courtès; +Cc: 36191, Robert Vollmert
[-- Attachment #1: Type: text/plain, Size: 487 bytes --]
Ludovic Courtès <ludo@gnu.org> writes:
> Hello,
>
> Robert Vollmert <rob@vllmrt.net> skribis:
>
>> This changes to 'peer' authentication for local socket connections,
>> and password-based authentication for local network connections.
>>
>> * gnu/services/databases.scm (%default-postgres-hba): Change
>> authentication method.
>
> That sounds reasonable to me. Chris, WDYT?
I'm definitely no authority on PostgreSQL authentication, but this
sounds sensible to me.
[-- Attachment #2: signature.asc --]
[-- Type: application/pgp-signature, Size: 962 bytes --]
^ permalink raw reply [flat|nested] 5+ messages in thread
* bug#36191: [PATCH] gnu: postgres service: More secure default permissions.
2019-06-26 6:37 ` Giovanni Biscuolo
@ 2019-07-02 15:11 ` Ludovic Courtès
0 siblings, 0 replies; 5+ messages in thread
From: Ludovic Courtès @ 2019-07-02 15:11 UTC (permalink / raw)
To: Giovanni Biscuolo; +Cc: 36191-done, Robert Vollmert
Hello,
Giovanni Biscuolo <g@xelera.eu> skribis:
> It's very reasonable to have such default auth methods for PostgresSQL:
> we should apply this patch
Christopher Baines <mail@cbaines.net> skribis:
> I'm definitely no authority on PostgreSQL authentication, but this
> sounds sensible to me.
Alright, applied, thanks for your feedback!
Ludo’.
^ permalink raw reply [flat|nested] 5+ messages in thread
end of thread, other threads:[~2019-07-02 15:12 UTC | newest]
Thread overview: 5+ messages (download: mbox.gz follow: Atom feed
-- links below jump to the message on this page --
2019-06-13 13:50 [bug#36191] [PATCH] gnu: postgres service: More secure default permissions Robert Vollmert
2019-06-25 15:40 ` Ludovic Courtès
2019-06-26 6:37 ` Giovanni Biscuolo
2019-07-02 15:11 ` bug#36191: " Ludovic Courtès
2019-06-28 22:25 ` [bug#36191] " Christopher Baines
Code repositories for project(s) associated with this external index
https://git.savannah.gnu.org/cgit/guix.git
This is an external index of several public inboxes,
see mirroring instructions on how to clone and mirror
all data and code used by this external index.