Re: SV: SV: SV: SV: Problem with ssl and psql in Postgresql 13

I wrote: > Gustavsson Mikael writes: >> So if i set gssencmode=disable on my pgsql-13 to postgres 13 server >> connection i get an SSL connection. > It looks like, if there is a credentials cache and gssencmode isn't > explicitly disabled, we try GSS first. If the server refuses that: > ... > t

Re: SV: SV: SV: SV: Problem with ssl and psql in Postgresql 13

Gustavsson Mikael writes: > I did a final test before logging out for Christmas because i found a thread > in hackers discussing some issue with GSS and SSL. > So if i set gssencmode=disable on my pgsql-13 to postgres 13 server > connection i get an SSL connection. Oooh ... that's the missing i

SV: SV: SV: SV: Problem with ssl and psql in Postgresql 13

__ Från: externaly-forwar...@smhi.se för Gustavsson Mikael Skickat: den 22 december 2020 09:07:17 Till: Tom Lane Kopia: Magnus Hagander; Kyotaro Horiguchi; pgsql-gene...@postgresql.org; Svensson Peter Ämne: SV: SV: SV: SV: Problem with ssl and psql in Postgresql 13 Hi, Yes it´

SV: SV: SV: SV: Problem with ssl and psql in Postgresql 13

Jul as we say in Sweden. KR Mikael Gustavsson, SMHI Från: Tom Lane Skickat: den 18 december 2020 21:02:50 Till: Gustavsson Mikael Kopia: Magnus Hagander; Kyotaro Horiguchi; pgsql-gene...@postgresql.org; Svensson Peter Ämne: Re: SV: SV: SV: Problem with ssl and

Re: SV: SV: SV: Problem with ssl and psql in Postgresql 13

Gustavsson Mikael writes: > pgsql-13 with require: > $ /usr/pgsql-13/bin/psql "dbname=postgres user=kalle host=server > sslmode=require" > Password for user kalle: > psql (13.1) > Type "help" for help. That is just bizarre. libpq should not ignore the sslmode=require option like that, unless it

SV: SV: SV: Problem with ssl and psql in Postgresql 13

för Gustavsson Mikael Skickat: den 17 december 2020 17:33:13 Till: Tom Lane Kopia: Magnus Hagander; Kyotaro Horiguchi; pgsql-gene...@postgresql.org; Svensson Peter Ämne: SV: SV: SV: Problem with ssl and psql in Postgresql 13 Here is the result. ldd /usr/pgsql-13/bin/psql linux-vdso.so.1 (

SV: SV: SV: Problem with ssl and psql in Postgresql 13

___ Från: Tom Lane Skickat: den 17 december 2020 17:25:31 Till: Gustavsson Mikael Kopia: Magnus Hagander; Kyotaro Horiguchi; pgsql-gene...@postgresql.org; Svensson Peter Ämne: Re: SV: SV: Problem with ssl and psql in Postgresql 13 Gustavsson Mikael writes: > $ /usr/pgsql-13/bin/ps

Re: SV: SV: Problem with ssl and psql in Postgresql 13

Gustavsson Mikael writes: > $ /usr/pgsql-13/bin/psql "dbname=postgres user=kalle host=server > sslmode=require" > psql: error: FATAL: no pg_hba.conf entry for host "nn.nnn.n.nnn", user > "kalle", database "postgres", SSL off > FATAL: no pg_hba.conf entry for host "nn.nnn.n.nnn", user "kalle",

SV: SV: Problem with ssl and psql in Postgresql 13

Sorry, my bad. But i get the same result. $ /usr/pgsql-13/bin/psql "dbname=postgres user=kalle host=server sslmode=require" psql: error: FATAL: no pg_hba.conf entry for host "nn.nnn.n.nnn", user "kalle", database "postgres", SSL off FATAL: no pg_hba.conf entry for host "nn.nnn.n.nnn", user "

SV: SV: Problem with ssl and psql in Postgresql 13

Hi Magnus, The clients 11 and 13 is on the same host. Hmm, I get the same error if I set sslmode=require. $ /usr/pgsql-13/bin/psql -d postgres --set=sslmode=require -Ukalle -hserver -W Password: psql: error: FATAL: no pg_hba.conf entry for host "nn.nnn.n.nnn", user "kalle", database "postgr

SV: SV: Problem with ssl and psql in Postgresql 13

Hi, log_connections is on. The ERR message is correct, we do not have an entry for SSL off. The question is why psql(13) is trying to connect without ssl? 2020-12-17T14:25:09.565566+00:00 server INFO [30-1] pgpid=2422778 pguser=[unknown] pghost=nnn.nn.n.nnn pgdb=[unknown] pgapp=[unknown] LOG: