Jeremy T. Bouse:
> With the /etc/postfix/pgsql/*.cf files all following the format:
>
> user = DB_USER
> password = DB_PASSWD
> hosts = psqldb.undergrid.net
> dbname = postfixadmin
> query = <SQL QUERY>
>
> Everything is working fine... So with the PGPASSFILE set in
> import_environment and I've confirmed through procfs that it is in the
> environ file for the postfix processes I comment out the 'user' and
> 'password' lines in each of the .cf files and restart postfix. I then
> tried to run 'sendmail -bv jbo...@undergrid.net' and I get the following:
>
> Jan 28 22:25:53 mail02 postfix/pickup[20576]: 99FFD5FB82: uid=0 from=<root>
> Jan 28 22:25:53 mail02 postfix/cleanup[20633]: 99FFD5FB82:
> message-id=<20170128222553.99ffd5f...@smtp.undergrid.net>
> Jan 28 22:25:53 mail02 postfix/qmgr[20577]: 99FFD5FB82:
> from=<r...@smtp.undergrid.net>, size=291, nrcpt=1 (queue active)
> Jan 28 22:25:53 mail02 postfix/proxymap[20634]: warning: connect to
> pgsql server psqldb.undergrid.net: fe_sendauth: no password supplied?
Perhaps the mysql client library can't open PGPASSFILE. That may
be logged somewhere (that is up to the mysql client library).
Check the permissions. The proxymap daemon runs with UID and
GID of the $mail_owner account.
And don't forget the permissions for the parent directories; if
those directory permissions don't allow access, then the file
permissions don't matter.
Another possibility is that SeLinux/AppArmor/etc. are sabotaging
things. That should be visible in some system log.
Wietse
