Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1wbz9y-002zy2-1P for pgsql-general@arkaria.postgresql.org; Tue, 23 Jun 2026 11:19:18 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wbz9x-00BGTO-0Y for pgsql-general@arkaria.postgresql.org; Tue, 23 Jun 2026 11:19:17 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1wbz9w-00BGTG-1t for pgsql-general@lists.postgresql.org; Tue, 23 Jun 2026 11:19:16 +0000 Received: from mail-dl1-x1236.google.com ([2607:f8b0:4864:20::1236]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1wbz9u-00000001jcL-04Oc for pgsql-general@lists.postgresql.org; Tue, 23 Jun 2026 11:19:15 +0000 Received: by mail-dl1-x1236.google.com with SMTP id a92af1059eb24-1384ebe7a10so5393133c88.1 for ; Tue, 23 Jun 2026 04:19:13 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1782213552; cv=none; d=google.com; s=arc-20240605; b=Rv8mOhyr77VJwWowdN6D4t0V6PQP50DPehN2eM78xqmgc0eFVkPRxHIFhpp6WQnG2N mvJdhOrQXeSgBuZQvDiVLIyVUFlbd6sn1GgAbGH2AJGUZ8Yctr5zuCtR5EpXGbWu/8E2 Uyc7x5iND70+LMEevPNhd4w9jy4qHYs+DohqVC6sk4wm1Afk0kNU4s3ZJO4+sTUwzq8J ZivrxvD+cK1AJLW2z7AlElHiDThy2/0ZH9dVi5euPL+026h8ENObeUBWMAnaNjY08Mmn Ai91ceMAQhkcvb3Ai1O39CG8SiRz6a2D0cgpRX0zVRTL6C1+PR8B9VWTKp3sIUjxva8F r5hQ== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:dkim-signature; bh=TAjTehnEMWOnfbp2EtdhxN1J1mJS/qY2jEqdl9gVq98=; fh=9fYW1w+C8R+Uz+xc39rcVIRjBn15pnXRkmIjxsCA9IU=; b=j51VsNd2KU+POE7jPSG3wShztEm5KP4Pi8AMQihpusO5c5kpQe7fOOP45oG3qHBD+B MHGyp2fKJoHhcHh13f/aQe/hIttGtyJtWSSEG1OoGezd+J1/tILfnF9tUfrd1IrgFt0p 09R//fAYsu4BlbWpjIWmteMyZqhelvJAktTMqprCC55Sczh7q/Week86oxipvkVri2zL 6LQs47iWFF0d+mO8QH9OAt0T652VpmWR3dNDsqTj7B80sBB6JPX7D4JVLVB58NZyQ3vs B6o2B+pTre2HMNfoDPkOM9nBXkuWe/cv9sBToa3brcLEvSA021YsnY+9KaaRtuhKLabI pJ+Q==; darn=lists.postgresql.org ARC-Authentication-Results: i=1; mx.google.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20251104; t=1782213552; x=1782818352; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=TAjTehnEMWOnfbp2EtdhxN1J1mJS/qY2jEqdl9gVq98=; b=jUhB49HenDtv8XS3QuqL/0tfcKlwJapvWm4+NNMjC1Pz+kVMzdNAZ4Y5ATz0I3cjpL S92mXOdQBUsdiFLEMMTUHi5htVoUcnsN7VrEZ8S3kZDtYZLe+xh6dWSpXKAKd93WjIZs ieo/SeKS5j6ohkpsFVbYOVYOEn9TXYbxpGHwJIKm9Y4WsaQvfFH/xbr9jURrA+8AEf3N u9uA2oi4GBvOJSKp04nUurOchvHFRYchavzCSLrAlX3FtMyMkfqrbKy+naulVZ8W3RRD LV78AREYSBV7wvQKFw6sLbZrtCp6whD/U4LfvQoIdbYyZXrkn1UnDyJr6TyhbVLOVe5I K3MA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1782213552; x=1782818352; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-gg:x-gm-message-state:from:to:cc:subject:date :message-id:reply-to; bh=TAjTehnEMWOnfbp2EtdhxN1J1mJS/qY2jEqdl9gVq98=; b=WIF6O1McHTZjY8HTVgNpsPtUjGR6JFILn1uwt7M/O+kWEBOcUSgEfYEp70QC6OQjPn wU+aHOu4tF6eLhbgjEtaGiMdTrmUMRBnOAuEsh6yd9d1RabE34uQuKQtgz3ESJxdFoMR kP+hQ+nIeWtSlHbcMpnP76QDmVVUPKY8tsEY9L6/G+YQcwXFzgVbHi1uVY73e3x+fqE0 IQzchH4Zg4eXsn/THhfp/9r7y0OmJnCLCwfC3ESjFqAKt9uTIlWozn/1gyZ//+RXJARd Sp5Q5gWgKfec7AdXwTu+oC1SplQVLbVUWqvqKVJ/7EttrPbvlUXMBmECKuQhiyDI5pTv i5BQ== X-Gm-Message-State: AOJu0YxzrenBCUh3QkQnlfHn0wt49NSfUmg53y0fNBj4dYxkrOwLIHEk +HdmZCkspwA1++3pm+btzvMZ/r/E1QrI2uutlOlES9lS0yjWBgrbNFsHQMglYUtlE8TsdcyTVc3 DJCbUuJGtilOOmiSR/mtqU9QU9/DvPLg= X-Gm-Gg: AfdE7cmN48Y47wf87fvUhcXwPz6lLHZe6vmy5dcSzWRZ6MYsFYtDWfsTlqsZ9/6NElt o7nNqzW/PlqWdjyaN1pUOE3xCd+yKeCzLpfFG3+0yT3Kr5QbzlQfRyu3liYVrDgRHFwGLv6Rf+h DtbSl/6yOxR9OYt6g3JghewlVoTV39kjxukgF5jCYP1Y3Qrj36yeDyMB4Wa4isHgvXca/qH51l7 k5ucF8wxr1tYJ6wh9Ha0w1k8hrlqIvAuDuSFA2mvVBT5MlHzOjo3eQng4JUFeOyGRSlYXP/lRab 0bTnDteABrCG7i2FqkZPt5+9e+aB47Ew+jeQPR3thZJhWdcPFRw5TJ1gJgNDZ+o9g60= X-Received: by 2002:a05:7022:419c:b0:12d:b7e5:a691 with SMTP id a92af1059eb24-139c5cdacaamr1584766c88.7.1782213552069; Tue, 23 Jun 2026 04:19:12 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Joan Frey Date: Tue, 23 Jun 2026 13:19:00 +0200 X-Gm-Features: AVVi8Ce6mIk4s29Q6HMvxxXO06sYiH2BfxK_7FwmDY5KHf-U1oW2rwr1JukZQKA Message-ID: Subject: Re: PostgreSQL server with SSL To: Matthias Apitz Cc: pgsql-general@lists.postgresql.org Content-Type: multipart/alternative; boundary="000000000000af624c0654e9ede5" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000af624c0654e9ede5 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Hi Matthias, *How could I enable more logging about the SSL session problem?* You can edit the following parameters in postgresql.conf: log_connections =3D on log_min_messages =3D [debug5, debug4, debug3, debug2, debug1, info, notice= , warning, error, log, fatal, panic] Reload postgres and then check the postgresql logs You can also force sslmode when you connect using psql "host=3D... port=3D5432 user=3Dsisis dbname=3Dsisis sslmode=3Drequire= " Cheers, Joan Le mar. 23 juin 2026 =C3=A0 12:31, Matthias Apitz a =C3= =A9crit : > I have generated new SSL keys exactly as documented in > https://www.postgresql.org/docs/15/ssl-tcp.html > > # su - postgres > $ mkdir canew > $ cd canew > $ export PATH=3D/usr/local/sisis-pap/bin:$PATH > $ export LD_LIBRARY_PATH=3D/usr/local/sisis-pap/lib > $ openssl -v > OpenSSL 3.5.7 9 Jun 2026 (Library: OpenSSL 3.5.7 9 Jun 2026) > > $ openssl req -new -x509 -days 365 -nodes -text -out server.crt -keyout > server.key -subj "/CN=3Dsrap48dxr1.dev.xxxx.org" > $ chmod og-rwx server.key > > $ openssl req -new -nodes -text -out root.csr -keyout root.key -subj > "/CN=3Droot.dev.xxxx.org" > $ chmod og-rwx root.key > > $ openssl x509 -req -in root.csr -text -days 3650 -extfile > /usr/local/sisis-pap/openssl.cnf -extensions v3_ca -signkey root.key -out > root.crt > $ openssl req -new -nodes -text -out server.csr -keyout server.key -sub= j > "/CN=3Dsrap48dxr1.dev.xxxx.org" > $ chmod og-rwx server.key > $ openssl x509 -req -in server.csr -text -days 365 -CA root.crt -CAkey > root.key -CAcreateserial -out server.crt > > $ ls -l > insgesamt 36 > -rw-r--r-- 1 postgres postgres 4168 23. Jun 11:27 root.crt > -rw-r--r-- 1 postgres postgres 3377 23. Jun 11:24 root.csr > -rw------- 1 postgres postgres 1704 23. Jun 11:24 root.key > -rw-r--r-- 1 postgres postgres 41 23. Jun 11:28 root.srl > -rw-r--r-- 1 postgres postgres 4087 23. Jun 11:28 server.crt > -rw-r--r-- 1 postgres postgres 3391 23. Jun 11:28 server.csr > -rw------- 1 postgres postgres 1704 23. Jun 11:28 server.key > > In postgresql.conf the SSL section is now: > > # - SSL - > # > ssl =3D on > ssl_cert_file =3D '/home/postgres/canew/server.crt' > ssl_key_file =3D '/home/postgres/canew/server.key' > > and in pg_hba.conf the matching entry for the IP addr of my Mac is: > > hostssl all all 10.49.210.27/32 > password > host all all 10.49.210.27/32 > password > > With the line for 'host' the connect with the psql falls back to non-SSL. > > $ psql -Usisis > Password for user sisis: > psql (14.15 (Homebrew), server 15.1) > Type "help" for help. > > sisis=3D# > > When I have only the 'hostssl' line for the IP addr 10.49.210.27 it says > > psql -Usisis > psql: error: connection to server at "srap48dxr1.dev.xxxx.org" > (10.23.33.57), port 2345 failed: SSL SYSCALL error: EOF detected > connection to server at "srap48dxr1.dev.xxxx.org" (10.23.33.57), port > 2345 failed: FATAL: no pg_hba.conf entry for host "10.49.210.27", user > "sisis", database "sisis", no encryption > > How could I enable more logging about the SSL session problem? > Thanks > > matthias > > > El d=C3=ADa lunes, junio 22, 2026 a las 07:56:39 +0200, Matthias Apitz es= cribi=C3=B3: > > > > > > > Hello, > > > > > > I've enabled SSL in the connection to the PostgreSQL server (16.5). > > All details see below. The SSL connection works fine from a remote > > host, for example from my MacBook, but does not work on the host > > itself via interface 'lo' where it gives the error message: > > > > FATAL: no PostgreSQL user name specified in startup packet > > connection to server at "srap48dxr1.dev.xxxx.org" (10.23.33.57), > port 5432 failed: FATAL: no PostgreSQL user name specified in startup > packet > > > > and psql crashes. Interesting observation with tcpdump is, stat the > > above error message is sent in clear over the network. > > > > The same picture is with all C- or Java-written software using an ESQL/= C > > or JDBC interface. > > > > Any idea on this? > > > > Here are the details > > > > > > # su - postgres > > $ mkdir ca > > $ cd ca > > $ export LD_LIBRARY_PATH=3D/usr/local/sisis-pap/lib > > $ export OPENSSL=3D/usr/local/sisis-pap/bin/openssl > > $ $OPENSSL version # just for testing > > export OPENSSL_CONFIG=3D'-config /usr/local/sisis-pap/openssl.cnf' > > $ /usr/local/sisis-pap/misc/CA.pl -newca > > ... > > $ /usr/local/sisis-pap/misc/CA.pl -newreq > > ... > > $ ls -l newreq.pem newkey.pem > > -rw------- 1 postgres postgres 1886 16. Jun 12:40 newkey.pem > > -rw-r--r-- 1 postgres postgres 1090 16. Jun 12:42 newreq.pem > > $ /usr/local/sisis-pap/misc/CA.pl -sign > > ... > > > > $ mv newcert.pem pg-server.crt > > $ mv newkey.pem pg-server.key > > > > we must remove the passphrase from the key for PostgreSQL to be able to > read > > and start the PostgreSQL server without user interaction: > > > > $ $OPENSSL rsa -in pg-server.key -out pg-passless-server.key > > Enter pass phrase for pg-server.key: > > writing RSA key > > > > Enabling SSL in postgresql.conf: > > > > $ vim /data/postgresql165/data/postgresql.conf > > > > # - SSL - > > > > ssl =3D on > > ssl_cert_file =3D '/home/postgres/ca/pg-server.crt' > > ssl_key_file =3D '/home/postgres/ca/pg-passless-server.key' > > ssl_ca_file =3D '/home/postgres/ca/demoCA/cacert.pem' > > > > $ vim /data/postgresql165/data/pg_hba.conf > > changed 'host' to 'hostssl' for the relevant lines > > > > Start of the server: > > > > # /etc/init.d/postgres165 start > > > > Connect from my MacBook to the remote host srap48dxr1.dev.xxxx.org: > > > > $ export PGHOST=3Dsrap48dxr1.dev.xxxx.org > > $ export PGPORT=3D5432 > > > > $ psql -Usisis sisis > > Password for user sisis: > > psql (14.15 (Homebrew), server 16.5) > > SSL connection (protocol: TLSv1.3, cipher: TLS_AES_256_GCM_SHA384, bits= : > 256, compression: off) > > Type "help" for help. > > > > sisis=3D> > > > > > > Connect on the host itself: > > > > $ export PGHOST=3Dsrap48dxr1.dev.xxxx.org > > $ export PGPORT=3D5432 > > > > $ /usr/local/sisis-pap/pgsql-16.5/bin/psql -Usisis > > psql: Fehler: connection to server at "srap48dxr1.dev.xxxx.org" > (10.23.33.57), port 5432 failed: FATAL: no PostgreSQL user name specifie= d > in startup packet > > connection to server at "srap48dxr1.dev.xxxx.org" (10.23.33.57), port > 5432 failed: FATAL: no PostgreSQL user name specified in startup packet > > free(): invalid pointer > > Abgebrochen (Speicherabzug geschrieben) > > > > $ ldd /usr/local/sisis-pap/pgsql-16.5/bin/psql | egrep 'libssl|crypto' > > libssl.so.3 =3D> /usr/local/sisis-pap/lib/libssl.so.3 > (0x00007f9ea38cb000) > > libcrypto.so.3 =3D> /usr/local/sisis-pap/lib/libcrypto.so.3 > (0x00007f9ea3000000) > > > > -- > > Matthias Apitz, =E2=9C=89 guru@unixarea.de, http://www.unixarea.de/ > +49-176-38902045 > > Public GnuPG key: http://www.unixarea.de/key.pub > > > > > > -- > Matthias Apitz, =E2=9C=89 guru@unixarea.de, http://www.unixarea.de/ > +49-176-38902045 > Public GnuPG key: http://www.unixarea.de/key.pub > > > --000000000000af624c0654e9ede5 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi Matthias,

How could I enable more logging about the SSL session = problem?

You can edit the following parameters i= n postgresql.conf:log_connections =3D on
log_min_messages =3D=C2=A0 [debug5, debu= g4, debug3, debug2, debug1, info, notice, warning, error, log, fatal, panic= ]

Reload postgres and then check the postgresql l= ogs

You can also force sslmode when you connect using
psql= "host=3D... port=3D5432=C2=A0 user=3Dsisis dbname=3Dsisis sslmode=3Dr= equire"

Cheers,
Joan

Le=C2=A0mar. 23 juin 2026 =C3=A0=C2=A012:31, Matthias Ap= itz <guru@unixarea.de> a =C3= =A9crit=C2=A0:
I= have generated new SSL keys exactly as documented in
https://www.postgresql.org/docs/15/ssl-tcp.html
# su - postgres
$ mkdir canew
$ cd canew
$ export PATH=3D/usr/local/sisis-pap/bin:$PATH
$ export LD_LIBRARY_PATH=3D/usr/local/sisis-pap/lib
$ openssl -v
OpenSSL 3.5.7 9 Jun 2026 (Library: OpenSSL 3.5.7 9 Jun 2026)

$ openssl req -new -x509 -days 365 -nodes -text -out server.crt=C2=A0 =C2= =A0-keyout server.key -subj "/CN=3Dsrap48dxr1.dev.xxxx.org&qu= ot;
$ chmod og-rwx server.key

$ openssl req -new -nodes -text -out root.csr=C2=A0 =C2=A0-keyout root.key = -subj "/CN=3Droot.dev.xxxx.org"
$ chmod og-rwx root.key

$ openssl x509 -req -in root.csr -text -days 3650 -extfile /usr/local/sisis= -pap/openssl.cnf -extensions v3_ca -signkey root.key -out root.crt
$ openssl req -new -nodes -text -out server.csr=C2=A0 =C2=A0-keyout server.= key -subj "/CN=3Dsrap48dxr1.dev.xxxx.org"
$ chmod og-rwx server.key
$ openssl x509 -req -in server.csr -text -days 365=C2=A0 =C2=A0-CA root.crt= -CAkey root.key -CAcreateserial=C2=A0 =C2=A0-out server.crt

$ ls -l
insgesamt 36
-rw-r--r-- 1 postgres postgres 4168 23. Jun 11:27 root.crt
-rw-r--r-- 1 postgres postgres 3377 23. Jun 11:24 root.csr
-rw------- 1 postgres postgres 1704 23. Jun 11:24 root.key
-rw-r--r-- 1 postgres postgres=C2=A0 =C2=A041 23. Jun 11:28 root.srl
-rw-r--r-- 1 postgres postgres 4087 23. Jun 11:28 server.crt
-rw-r--r-- 1 postgres postgres 3391 23. Jun 11:28 server.csr
-rw------- 1 postgres postgres 1704 23. Jun 11:28 server.key

In postgresql.conf the SSL section is now:

# - SSL -
#
ssl =3D on
ssl_cert_file =3D '/home/postgres/canew/server.crt'
ssl_key_file =3D '/home/postgres/canew/server.key'

and in pg_hba.conf the matching entry for the IP addr of my Mac is:

hostssl=C2=A0 =C2=A0 all=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0all= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A010.49.210.27/32=C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0password
host=C2=A0 =C2=A0 =C2=A0 =C2=A0all=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0all=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A010.49.210.27/32= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0password

With the line for 'host' the connect with the psql falls back to no= n-SSL.

$ psql -Usisis
Password for user sisis:
psql (14.15 (Homebrew), server 15.1)
Type "help" for help.

sisis=3D#

When I have only the 'hostssl' line for the IP addr 10.49.210.27 it= says

psql -Usisis
psql: error: connection to server at "srap48dxr1.dev.xxxx.org= " (10.23.33.57), port 2345 failed: SSL SYSCALL error: EOF detected
connection to server at "srap48dxr1.dev.xxxx.org" (10.23= .33.57), port 2345 failed: FATAL:=C2=A0 no pg_hba.conf entry for host "= ;10.49.210.27", user "sisis", database "sisis", no= encryption

How could I enable more logging about the SSL session problem?
Thanks

=C2=A0 =C2=A0 =C2=A0 =C2=A0 matthias


El d=C3=ADa lunes, junio 22, 2026 a las 07:56:39 +0200, Matthias Apitz escr= ibi=C3=B3:

>
>
> Hello,
>
>
> I've enabled SSL in the connection to the PostgreSQL server (16.5)= .
> All details see below. The SSL connection works fine from a remote
> host, for example from my MacBook, but does not work on the host
> itself via interface 'lo' where it gives the error message: >
>=C2=A0 =C2=A0 =C2=A0FATAL:=C2=A0 no PostgreSQL user name specified in s= tartup packet
>=C2=A0 =C2=A0 =C2=A0connection to server at "srap48dxr1.dev.x= xxx.org" (10.23.33.57), port 5432 failed: FATAL:=C2=A0 no PostgreS= QL user name specified in startup packet
>
> and psql crashes. Interesting observation with tcpdump is, stat the > above error message is sent in clear over the network.
>
> The same picture is with all C- or Java-written software using an ESQL= /C
> or JDBC interface.
>
> Any idea on this?
>
> Here are the details
>
>
> # su - postgres
> $ mkdir ca
> $ cd ca
> $ export LD_LIBRARY_PATH=3D/usr/local/sisis-pap/lib
> $ export OPENSSL=3D/usr/local/sisis-pap/bin/openssl
> $ $OPENSSL version=C2=A0 # just for testing
> export OPENSSL_CONFIG=3D'-config /usr/local/sisis-pap/openssl.cnf&= #39;
> $ /usr/local/sisis-pap/misc/CA.pl -newca
> ...
> $ /usr/local/sisis-pap/misc/CA.pl -newreq
> ...
> $ ls -l newreq.pem newkey.pem
> -rw------- 1 postgres postgres 1886 16. Jun 12:40 newkey.pem
> -rw-r--r-- 1 postgres postgres 1090 16. Jun 12:42 newreq.pem
> $ /usr/local/sisis-pap/misc/CA.pl -sign
> ...
>
> $ mv newcert.pem pg-server.crt
> $ mv newkey.pem pg-server.key
>
> we must remove the passphrase from the key for PostgreSQL to be able t= o read
> and start the PostgreSQL server without user interaction:
>
> $ $OPENSSL rsa -in pg-server.key -out pg-passless-server.key
> Enter pass phrase for pg-server.key:
> writing RSA key
>
> Enabling SSL in postgresql.conf:
>
> $ vim /data/postgresql165/data/postgresql.conf
>
> # - SSL -
>
> ssl =3D on
> ssl_cert_file =3D '/home/postgres/ca/pg-server.crt'
> ssl_key_file =3D '/home/postgres/ca/pg-passless-server.key' > ssl_ca_file =3D '/home/postgres/ca/demoCA/cacert.pem'
>
> $ vim /data/postgresql165/data/pg_hba.conf
> changed 'host' to 'hostssl' for the relevant lines
>
> Start of the server:
>
> # /etc/init.d/postgres165 start
>
> Connect from my MacBook to the remote host srap48dxr1.dev.xxxx.or= g:
>
> $ export PGHOST=3Dsrap48dxr1.dev.xxxx.org
> $ export PGPORT=3D5432
>
> $ psql -Usisis sisis
> Password for user sisis:
> psql (14.15 (Homebrew), server 16.5)
> SSL connection (protocol: TLSv1.3, cipher: TLS_AES_256_GCM_SHA384, bit= s: 256, compression: off)
> Type "help" for help.
>
> sisis=3D>
>
>
> Connect on the host itself:
>
> $ export PGHOST=3Dsrap48dxr1.dev.xxxx.org
> $ export PGPORT=3D5432
>
> $ /usr/local/sisis-pap/pgsql-16.5/bin/psql -Usisis
> psql: Fehler: connection to server at "srap48dxr1.dev.xxxx.o= rg" (10.23.33.57), port 5432 failed: FATAL:=C2=A0 no PostgreSQL us= er name specified in startup packet
> connection to server at "srap48dxr1.dev.xxxx.org" (= 10.23.33.57), port 5432 failed: FATAL:=C2=A0 no PostgreSQL user name specif= ied in startup packet
> free(): invalid pointer
> Abgebrochen (Speicherabzug geschrieben)
>
> $ ldd /usr/local/sisis-pap/pgsql-16.5/bin/psql | egrep 'libssl|cry= pto'
>=C2=A0 =C2=A0 =C2=A0 =C2=A0libssl.so.3 =3D> /usr/local/sisis-pap/lib= /libssl.so.3 (0x00007f9ea38cb000)
>=C2=A0 =C2=A0 =C2=A0 =C2=A0libcrypto.so.3 =3D> /usr/local/sisis-pap/= lib/libcrypto.so.3 (0x00007f9ea3000000)
>
> --
> Matthias Apitz, =E2=9C=89 guru@unixarea.de, http://www.unixarea.de/ +49-176-38902= 045
> Public GnuPG key: http://www.unixarea.de/key.pub
>
>

--
Matthias Apitz, =E2=9C=89 guru@unixarea.de, http://www.unixarea.de/ +49-176-38902045
Public GnuPG key: http://www.unixarea.de/key.pub


--000000000000af624c0654e9ede5--