On 5/13/20 4:29 PM, Viktor Dukhovni wrote:
On Wed, May 13, 2020 at 03:42:47PM -0500, Thomas Strike wrote:
Postfix is trying to access the aliases table in the postfix db with a
wrong file name and directory. I thought I had this fixed yesterday but
it is showing up again today.
I changed the property, alias_maps = /etc/postfix/mysql-aliases.cf
Yes, that needs a table type prefix.
to: mysql:/etc/postfix/sql/mysql_virtual_alias_maps.cf,
Oops, my bad again. Yes, I left out "mysql:" in my statement when I last
posted. It is actually declared the way you suggested right now.
This fails the sniff test, the lookup keys in virtual alias tables are
fully-qualified (user@domain) and the RHS values support only lists
of addresses, while "alias_maps" has bare keys (user) and supports
a different RHS syntax with ":include:/path", "|command", ...
So I would not expect virtual alias tables to be appropriate as alias
tables. What problem are you actually trying to solve?
I'm hosting multiple domains and I'm using virtual host tables. I am not
sure that I have a problem since I can send SMTP mail with TLS and
receive all the spam as fast as I can delete it. I am just a little
concerned about that path/filename that popped up in the mail log since
it's declaration doesn't exist in ether config file or show up in the
postconf -n, -m, or -d lists. What evil lurks deep in the bowels of my
server that would be attempting to use a file that isn't specified and
doesn't exist.
*May 12 07:50:57 sleepyvalley postfix/smtps/smtpd[9495]: error: open
/etc/postfix/mysql-aliases.cf: No such file or directory *
Look in the output of "postconf -n" and "postconf -M".
