Re: Postfix is trying to access the aliases table in my db with a wrong file name and directory. t.s.
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.
Re: I am having an email I'm trying to post here bounce for no apparent reason.
On 5/14/20 2:51 PM, Wietse Venema wrote: Thomas Strike: The following cryptic line is given as the reason; . . . . BOUNCE postfix-users@postfix.org: Admin request of type /^\s*config\b/i at line 3 How do I correct this? Look at line 3 of the rejected email message. Wietse Thanks. I finally got it. Line 3 was throwing me. My original message was all one line because Thunderbird double lines any line breaks as a new paragraph. I found the word c0nfig on that 1st line.
Re: Postfix is trying to access the aliases table in my db with a wrong file name and directory. t.s.
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 .
Re: I am having an email I'm trying to post here bounce for no apparent reason.
On 5/14/20 2:33 PM, Ralph Seichter wrote: * Thomas Strike: The following cryptic line is given as the reason Not quite cryptic, just a regular expression. ;-) Make sure your subject line does not match this expression (the first case-insensitive word of the subject, after 0-n optional consecutive spaces, must not be "config"). -Ralph Thanks for your response. Regex is cryptic to me. I depend on others to create regular expressions. I am 74 years old now and regex is more complicated to me than any of the programming languages that I've learned. With every year passing, it is getting harder to learn something like regular expressions. So, when someone throws a regExp at me, I might as well be looking at Russian. So, If the problem was on the subject line, it's the same subject line that other emails have that went through. Tom
I am having an email I'm trying to post here bounce for no apparent reason.
The following cryptic line is given as the reason; . . . . BOUNCE postfix-users@postfix.org: Admin request of type /^\s*config\b/i at line 3 How do I correct this?
Re: Postfix is trying to access the aliases table in my db with a wrong file name and directory. t.s.
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.
Re: Postfix is trying to access the aliases table in my db with a wrong file name and directory. t.s.
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.
Re: Postfix is trying to access the aliases table in my db with a wrong file name and directory. t.s.
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".
Postfix is trying to access the aliases table in my db with a wrong file name and directory. t.s.
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.
Re: BCC on local delivery agent?
Me to. There is something about writing out your problem in detail that provides a moment of clarity. On 5/9/20 1:40 AM, @lbutlr wrote: On 08 May 2020, at 02:54, Admin Beckspaced wrote: ups ... I think I can answer my own question? Why is it that the answer mostly comes once the email has been sent ;) Because if it came before, you wouldn’t sent the message! (90% of the email questions I write are never sent, hard to believe, but true).
mysql postfix table "alias_domain" was created PostfixAdmin but it is empty. t.s.
I installed PostfixAdmin with postfix and mariadb. After PostfixAdmin set up the database, I populated it with adding domains and users through the PostfixAdmin web interface. It seemed to write all the data required to all the tables except the alias_domain table which is empty. Does Postfix use this table? Is it Postfix that populates this table or did PostfixAdmin not do this when it should have? The alias table looks like it is used for all the user name and domain name mapping. T.S.
Re: mail from external servers connecting but timing out after tls established. t.s.
>On postfix itself you can use regular blocklists to prevent such obvious IPs. For the other services like imap etc. it helps to use fail2ban. I have all filtering that I know of off right now. I am just trying to establish incoming communication with other SMTP clients right now. Once I get SMTPD services running and delivering incoming messages to the virtual mailboxes, I will work on fetching the mail through dovecot. Then at last I'll address blacklisting and spam after I get my server basically working.
Re: mail from external servers connecting but timing out after tls established. t.s.
Matus: your right. I misused the word server. I thought that this was the test message being sent with gmail because every time I sent a new test, this IP came up in the maillog. This turns out to be a Russian IP. Geez, Louise! I have Russia trying to hack me.
mail from external servers connecting but timing out after tls established. t.s.
External smtp servers time out after tls v1.2 is established. the following is from the maillog; May 8 17:40:48 sleepyvalley postfix/smtps/smtpd[17534]: connect from unknown[185.50.149.12] May 8 17:40:50 sleepyvalley postfix/smtps/smtpd[17534]: Anonymous TLS connection established from unknown[185.50.149.12]: TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits) May 8 17:40:56 sleepyvalley postfix/smtps/smtpd[17534]: lost connection after EHLO from unknown[185.50.149.12] May 8 17:40:56 sleepyvalley postfix/smtps/smtpd[17534]: disconnect from unknown[185.50.149.12] ehlo=1 commands=1 I set up certificates with letsincrypt. If these crets are wrong, would that cause this type of behavior? Thanks, Tom
Is it necessary to declare "alias_maps" in the main.cf? t.s.
With all the problems that I'm having with my Postfix setup, I am taking a deeper dive into the meaning of each parameter declaration. Is it necessary to declare "alias_maps" in the main.cf or does it have a default file path that it looks to or does it just not look at alias_maps if not declared? Thanks, T.S.
Is it necessary to declare "alias_maps" in the main.cf? t.s.
With all the problems that I'm having with my Postfix setup, I am taking a deeper dive into the meaning of each parameter declaration. Is it necessary to declare "alias_maps" in the main.cf or does it have a default file path that it looks to or does it just not look at alias_maps if not declared? Thanks, T.S.
