On Thu, February 8, 2024 14:20, Jens Berthold wrote:
> Hi James,
>
> it seems that the psql command connects to the server via UNIX domain socket
> /var/run/postgresql per default (so the first line in pg_hba.conf allow the
> access).
>
> OpenXPKI tries a TCP connection. So you need to modify the entry with 
> 127.0.0.1
> in pg_hba.conf to your special localhost IP and it should allow access.
>

I missed that.  As openxpki is running in a jail the localhost address was
changed to 127.0.89.1. Changing the local IPv4 address in pg_hba.conf to:
> # IPv4 local connections:
> host    all             all             127.0.89.1/32            trust

Fixed the issue.

Thanks,


-- 
***          e-Mail is NOT a SECURE channel          ***
        Do NOT transmit sensitive data via e-Mail
   Unencrypted messages have no legal claim to privacy
 Do NOT open attachments nor follow links sent by e-Mail

James B. Byrne                mailto:[email protected]
Harte & Lyne Limited          http://www.harte-lyne.ca
9 Brockley Drive              vox: +1 905 561 1241
Hamilton, Ontario             fax: +1 905 561 0757
Canada  L8E 3C3



_______________________________________________
OpenXPKI-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openxpki-users

Reply via email to