Postfix is trying to access the aliases table in my db with a wrong file name and directory. t.s.

classic Classic list List threaded Threaded
15 messages Options
Reply | Threaded
Open this post in threaded view
|

Postfix is trying to access the aliases table in my db with a wrong file name and directory. t.s.

Thomas Strike
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 to
mysql:/etc/postfix/sql/mysql_virtual_alias_maps.cf, the actual access
file to my aliases table. I searched the main.cf and master.cf files and
that file and directory is no longer there. What could be possibly
trying to use the wrong file?

May 12 07:50:57 sleepyvalley postfix/smtps/smtpd[9495]: error: open
/etc/postfix/mysql-aliases.cf: No such file or directory

Tom S.

Reply | Threaded
Open this post in threaded view
|

Re: Postfix is trying to access the aliases table in my db with a wrong file name and directory. t.s.

Wietse Venema
Thomas Strike:
> 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 to
> mysql:/etc/postfix/sql/mysql_virtual_alias_maps.cf, the actual access
> file to my aliases table. I searched the main.cf and master.cf files and
> that file and directory is no longer there. What could be possibly
> trying to use the wrong file?

Perhaps because something changed the file? Look at the file
last status change time. Perhaps that will provide a clue.

    ls -lc main.cf

For the sake of sanity, Postfix does not spontaneously change its
config files. There is only program, postconf, and that program
makes changes only on request.

        Wietse
Reply | Threaded
Open this post in threaded view
|

Re: Postfix is trying to access the aliases table in my db with a wrong file name and directory. t.s.

Viktor Dukhovni
In reply to this post by Thomas Strike
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,

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?

> 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".

--
    VIktor.
Reply | Threaded
Open this post in threaded view
|

Re: Postfix is trying to access the aliases table in my db with a wrong file name and directory. t.s.

Thomas Strike
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".

Reply | Threaded
Open this post in threaded view
|

Re: Postfix is trying to access the aliases table in my db with a wrong file name and directory. t.s.

Viktor Dukhovni
On Thu, May 14, 2020 at 02:01:31AM -0500, Thomas Strike wrote:

> > 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.

Have you looked in master.cf?  Are you looking at the right main.cf
file?

> > > *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".

Did you do that?  I am quite sure that "mysql-aliases.cf" is not
hard-coded into Postfix, so if it is reported as expected, then it is
part of your configuration in some manner, either via main.cf or
via master.cf settings for the "smtps" service.

--
    Viktor.
Reply | Threaded
Open this post in threaded view
|

Re: Postfix is trying to access the aliases table in my db with a wrong file name and directory. t.s.

Thomas Strike
On 5/14/20 2:18 AM, Viktor Dukhovni wrote:
> Have you looked in master.cf?  Are you looking at the right main.cf
> file?
>
> Look in the output of "postconf -n" and "postconf -M".

Yes. and postconf doesn't list this path/file in any -n, -m, -M, -p, or
-d.  I have only one main.cf and one master.cf file. Both of these
files, I copied and renamed *.cf.orig. to make working config files.

Thought: I am assuming that Postfix is only reading from the main.cf and
master.cf files. Could it be possible that Postfix is trying to use
main.cf* and master.cf*?

This error is still showing up in the log but it doesn't appear to be
causing any problems that I have detected.

"May 12 14:21:44 sleepyvalley postfix/smtpd[16326]: error: open
/etc/postfix/mysql-aliases.cf: No such file or directory"
"May 12 13:07:28 sleepyvalley postfix/smtps/smtpd[15107]: error: open
/etc/postfix/mysql-aliases.cf: No such file or directory"
"May 12 13:14:26 sleepyvalley postfix/submission/smtpd[15196]: error:
open /etc/postfix/mysql-aliases.cf: No such file or directory"

I have mynetworks = 127.0.0.0/8 in my main.cf file.

I looked in  postconf -d | grep 'mynetworks ' and the following came up.
Could this error be caused by any of this stuff? Does Postfix really use
all of this or is it superfluous and widening the SMTPd server for attach?

mynetworks = 127.0.0.0/8 54.39.19.0/24 [::1]/128
[2607:5300:203:2a80::]/57 [fe80::]/64
proxy_read_maps = $local_recipient_maps $mydestination
$virtual_alias_maps $virtual_alias_domains $virtual_mailbox_maps
$virtual_mailbox_domains $relay_recipient_maps $relay_domains
$canonical_maps $sender_canonical_maps $recipient_canonical_maps
$relocated_maps $transport_maps $mynetworks $smtpd_sender_login_maps
$sender_bcc_maps $recipient_bcc_maps $smtp_generic_maps
$lmtp_generic_maps $alias_maps $smtpd_client_restrictions
$smtpd_helo_restrictions $smtpd_sender_restrictions
$smtpd_relay_restrictions $smtpd_recipient_restrictions
$address_verify_sender_dependent_default_transport_maps
$address_verify_sender_dependent_relayhost_maps
$address_verify_transport_maps $fallback_transport_maps
$lmtp_discard_lhlo_keyword_address_maps $lmtp_pix_workaround_maps
$lmtp_sasl_password_maps $lmtp_tls_policy_maps $mailbox_command_maps
$mailbox_transport_maps $postscreen_discard_ehlo_keyword_address_maps
$rbl_reply_maps $sender_dependent_default_transport_maps
$sender_dependent_relayhost_maps $smtp_discard_ehlo_keyword_address_maps
$smtp_pix_workaround_maps $smtp_sasl_password_maps $smtp_tls_policy_maps
$smtpd_discard_ehlo_keyword_address_maps $smtpd_milter_maps
$virtual_gid_maps $virtual_uid_maps

Tom

> Did you do that?  I am quite sure that "mysql-aliases.cf" is not
> hard-coded into Postfix, so if it is reported as expected, then it is
> part of your configuration in some manner, either via main.cf or
> via master.cf settings for the "smtps" service.
>
Reply | Threaded
Open this post in threaded view
|

Re: Postfix is trying to access the aliases table in my db with a wrong file name and directory. t.s.

Wietse Venema
Thomas Strike:
> Thought: I am assuming that Postfix is only reading from the main.cf and
> master.cf files. Could it be possible that Postfix is trying to use
> main.cf* and master.cf*?

Type "postfix reload" and report the main.cf filename in the logs.

        Wietse
Reply | Threaded
Open this post in threaded view
|

Re: Postfix is trying to access the aliases table in my db with a wrong file name and directory. t.s.

Bill Cole-3
In reply to this post by Thomas Strike
On 14 May 2020, at 13:06, Thomas Strike wrote:

> I looked in  postconf -d | grep 'mynetworks ' and the following came
> up. Could this error be caused by any of this stuff? Does Postfix
> really use all of this or is it superfluous and widening the SMTPd
> server for attach?

'postconf -d' shows you Postfix's *default values* for every setting.  
If you want to see what Postfix is actually using that diverges from the
defaults, use '-n' instead.

--
Bill Cole
[hidden email] or [hidden email]
(AKA @grumpybozo and many *@billmail.scconsult.com addresses)
Not For Hire (currently)
Reply | Threaded
Open this post in threaded view
|

Re: Postfix is trying to access the aliases table in my db with a wrong file name and directory. t.s.

Viktor Dukhovni
In reply to this post by Thomas Strike
On Thu, May 14, 2020 at 12:06:34PM -0500, Thomas Strike wrote:

> This error is still showing up in the log but it doesn't appear to be
> causing any problems that I have detected.
>
> "May 12 14:21:44 sleepyvalley postfix/smtpd[16326]: error: open
> /etc/postfix/mysql-aliases.cf: No such file or directory"
> "May 12 13:07:28 sleepyvalley postfix/smtps/smtpd[15107]: error: open
> /etc/postfix/mysql-aliases.cf: No such file or directory"
> "May 12 13:14:26 sleepyvalley postfix/submission/smtpd[15196]: error:
> open /etc/postfix/mysql-aliases.cf: No such file or directory"

That was two days ago now, is it still happening today?

Post the outputs each of:

    1. egrep -r 'mysql-aliases\.cf' /etc/postfix

    2. postconf -x | egrep 'mysql-aliases.cf'

    3. postconf -M | egrep 'mysql-aliases.cf'

And any similar log messages *today*.

> I looked in  postconf -d | grep 'mynetworks ' and the following came up.
> Could this error be caused by any of this stuff? Does Postfix really use
> all of this or is it superfluous and widening the SMTPd server for attach?

You're letting your imaging run wild.

--
    Viktor.
Reply | Threaded
Open this post in threaded view
|

Re: Postfix is trying to access the aliases table in my db with a wrong file name and directory. t.s.

Thomas Strike

I am a novice to Postfix and only have to deal with setting up a new mail server every couple of years or so. This is only my 3rd time setting Postfix up in the past 10 years. Over time things change and every time I do this I have to learn it all over again. With all the extensive configurations and interactions with other associated service add-ons such as Dovecot and PostfixAdmin, and the mysql database (mariadb), I think that I am doing pretty good since I am alone and don't have any help accept for you guys. So, when I add a comment like "I looked in  postconf -d ..." It is not imagination, it's just not knowing what this is all about and concern that I am not putting an open SMTP relay on line like I did the first time trying to set up a mail server.

1. egrep -r 'mysql-aliases\.cf' /etc/postfix
	nothing found.
2. postconf -x | egrep 'mysql-aliases.cf'
	nothing found.
3. postconf -M | egrep 'mysql-aliases.cf'
	nothing found.

By the way, I do appreciate all the help I can get.

Thanks, Tom 

On 5/14/20 12:37 PM, Viktor Dukhovni wrote:
On Thu, May 14, 2020 at 12:06:34PM -0500, Thomas Strike wrote:

This error is still showing up in the log but it doesn't appear to be 
causing any problems that I have detected.

"May 12 14:21:44 sleepyvalley postfix/smtpd[16326]: error: open 
/etc/postfix/mysql-aliases.cf: No such file or directory"
"May 12 13:07:28 sleepyvalley postfix/smtps/smtpd[15107]: error: open 
/etc/postfix/mysql-aliases.cf: No such file or directory"
"May 12 13:14:26 sleepyvalley postfix/submission/smtpd[15196]: error: 
open /etc/postfix/mysql-aliases.cf: No such file or directory"
That was two days ago now, is it still happening today?

Post the outputs each of:

    1. egrep -r 'mysql-aliases\.cf' /etc/postfix

    2. postconf -x | egrep 'mysql-aliases.cf'

    3. postconf -M | egrep 'mysql-aliases.cf'

And any similar log messages *today*.

I looked in  postconf -d | grep 'mynetworks ' and the following came up. 
Could this error be caused by any of this stuff? Does Postfix really use 
all of this or is it superfluous and widening the SMTPd server for attach?
You're letting your imaging run wild.

Reply | Threaded
Open this post in threaded view
|

Re: Postfix is trying to access the aliases table in my db with a wrong file name and directory. t.s.

Thomas Strike
In reply to this post by Wietse Venema
Which logs are you talking about. After setting up Postfix and Dovcot,
everything reports to var/log/maillog. Postfix doesn't report it's conf
files that it loaded from there, only that it reloaded. Is there other
logs hidden somewhere?

On 5/14/20 12:28 PM, Wietse Venema wrote:
> Thomas Strike:
>> Thought: I am assuming that Postfix is only reading from the main.cf and
>> master.cf files. Could it be possible that Postfix is trying to use
>> main.cf* and master.cf*?
> Type "postfix reload" and report the main.cf filename in the logs.
>
> Wietse
> .
Reply | Threaded
Open this post in threaded view
|

Re: Postfix is trying to access the aliases table in my db with a wrong file name and directory. t.s.

Wietse Venema
Thomas Strike:
> Thought: I am assuming that Postfix is only reading from the main.cf and
> master.cf files. Could it be possible that Postfix is trying to use
> main.cf* and master.cf*?

On 5/14/20 12:28 PM, Wietse Venema wrote:
> Type "postfix reload" and report the main.cf filename in the logs.

Thomas Strike:
> Which logs are you talking about. After setting up Postfix and Dovcot,
> everything reports to var/log/maillog. Postfix doesn't report it's conf
> files that it loaded from there, only that it reloaded. Is there other
> logs hidden somewhere?

http://www.postfix.org/DEBUG_README.html#logging

Look for obvious signs of trouble Postfix logs all failed and
successful deliveries to a logfile.

  * When Postfix uses syslog logging (the default), the file is
    usually called /var/log/maillog, /var/log/mail, or something
    similar; the exact pathname is configured in a file called
    /etc/syslog.conf, /etc/rsyslog.conf, or something similar.

  * When Postfix uses its own logging system (see MAILLOG_README),
    the location of the logfile is configured with the Postfix
    maillog_file parameter.

When Postfix does not receive or deliver mail, the first order of
business is to look for errors that prevent Postfix from working
properly:

    % egrep '(warning|error|fatal|panic):' /some/log/file | more

Note: the most important message is near the BEGINNING of the output.
Error messages that come later are less useful.

The nature of each problem is indicated as follows:

  * "panic" indicates a problem in the software itself that only a
    programmer can fix. Postfix cannot proceed until this is fixed.

  * "fatal" is the result of missing files, incorrect permissions,
    incorrect configuration file settings that you can fix. Postfix
    cannot proceed until this is fixed.

  * "error" reports an error condition. For safety reasons, a Postfix
    process will terminate when more than 13 of these happen.

  * "warning" indicates a non-fatal error. These are problems that
    you may not be able to fix (such as a broken DNS server elsewhere
    on the network) but may also indicate local configuration errors
    that could become a problem later.
Reply | Threaded
Open this post in threaded view
|

Re: Postfix is trying to access the aliases table in my db with a wrong file name and directory. t.s.

Wietse Venema
Wietse Venema:

> Thomas Strike:
> > Thought: I am assuming that Postfix is only reading from the main.cf and
> > master.cf files. Could it be possible that Postfix is trying to use
> > main.cf* and master.cf*?
>
> On 5/14/20 12:28 PM, Wietse Venema wrote:
> > Type "postfix reload" and report the main.cf filename in the logs.
>
> Thomas Strike:
> > Which logs are you talking about. After setting up Postfix and Dovcot,
> > everything reports to var/log/maillog. Postfix doesn't report it's conf
> > files that it loaded from there, only that it reloaded. Is there other

It reports the main.cf file in that line.

May 14 16:07:50 spike postfix/master[1225]: reload -- version 3.6-20200316, configuration /etc/postfix

Reply | Threaded
Open this post in threaded view
|

Re: Postfix is trying to access the aliases table in my db with a wrong file name and directory. t.s.

Thomas Strike
On 5/14/20 3:08 PM, Wietse Venema wrote:

> Wietse Venema:
>> Thomas Strike:
>>> Thought: I am assuming that Postfix is only reading from the main.cf and
>>> master.cf files. Could it be possible that Postfix is trying to use
>>> main.cf* and master.cf*?
>> On 5/14/20 12:28 PM, Wietse Venema wrote:
>>> Type "postfix reload" and report the main.cf filename in the logs.
>> Thomas Strike:
>>> Which logs are you talking about. After setting up Postfix and Dovcot,
>>> everything reports to var/log/maillog. Postfix doesn't report it's conf
>>> files that it loaded from there, only that it reloaded. Is there other
> It reports the main.cf file in that line.
>
> May 14 16:07:50 spike postfix/master[1225]: reload -- version 3.6-20200316, configuration /etc/postfix

May 15 09:46:46 sleepyvalley postfix/master[20463]: reload -- version
3.3.1, configuration /etc/postfix

This is the version that still exists in the CentOS 8 repositories.

I was looking for the c0nfig file name(s). That just shows the c0nfig
file path.
Reply | Threaded
Open this post in threaded view
|

Re: Postfix is trying to access the aliases table in my db with a wrong file name and directory. t.s.

Wietse Venema
Thomas Strike:

> On 5/14/20 3:08 PM, Wietse Venema wrote:
> > Wietse Venema:
> >> Thomas Strike:
> >>> Thought: I am assuming that Postfix is only reading from the main.cf and
> >>> master.cf files. Could it be possible that Postfix is trying to use
> >>> main.cf* and master.cf*?
> >> On 5/14/20 12:28 PM, Wietse Venema wrote:
> >>> Type "postfix reload" and report the main.cf filename in the logs.
> >> Thomas Strike:
> >>> Which logs are you talking about. After setting up Postfix and Dovcot,
> >>> everything reports to var/log/maillog. Postfix doesn't report it's conf
> >>> files that it loaded from there, only that it reloaded. Is there other
> > It reports the main.cf file in that line.
> >
> > May 14 16:07:50 spike postfix/master[1225]: reload -- version 3.6-20200316, configuration /etc/postfix
>
> May 15 09:46:46 sleepyvalley postfix/master[20463]: reload -- version
> 3.3.1, configuration /etc/postfix

Postfix uses

- /etc/postfix/main.cf with parameter settings, documented in
  postconf(5), also at http://www.postfix.org/postconf.5.html .

- /etc/postfix/master.cf with service definitions and per-service
  parameter overrides, documented in master(5), also at
  http://www.postfix.org/master.5.html .

To find all my alias_maps settings:

In main.cf:
$ postconf alias_maps
alias_maps = hash:/etc/aliases

In master.cf:
$ postconf -P '*/*/alias_maps'
postconf: warning: unmatched request: "*/*/alias_maps"

So I don't have alias_maps settings in master.cf.

        Wietse