Dnia 28.01.2020 o godz. 18:43:48 Hamid M. pisze: > > Issuing following command works and doesn't require password: > sudo -u postfix psql -U mailserver -d mailserver -h /var/run/postgresql > > Additionally, all queries using "postmap -q" succeed with correct results. > > But none of the look ups defined in "virtual_mailbox_maps.cf" or " > virtual_alias_maps.cf" work when the postfix server tries them, and in fact > they report that connection to postgresql fails because it can't find it!: > > postfix/trivial-rewrite[8119]: warning: connect to pgsql server > /var/run/postgresql: could not connect to server: No such file or > directory??Is the server running locally and accepting??connections on Unix > domain socket "/var/run/postgresql/.s.PGSQL.5432"??
Maybe the reason is that your PostgreSQL socket isn't available from within Postfix chroot jail? Try placing it somewhere inside Postfix chroot jail. -- Regards, Jaroslaw Rafa r...@rafa.eu.org -- "In a million years, when kids go to school, they're gonna know: once there was a Hushpuppy, and she lived with her daddy in the Bathtub."
