Page 1 of 1

Relay Information missing from message details

Posted: 14 Apr 2022 00:29
by forhire
After updating eFa I am no longer seeing the Relay Information in the message details.

I have confirmed it went missing right when the update was done. Transport is working properly, it's just not capturing the delivery on the details page. Did it possibly get disabled? Any ideas?

I have rebooted the server and glanced through the config and logs but nothing jumps out.
relay.png
relay.png (23.84 KiB) Viewed 164226 times

Re: Relay Information missing from message details

Posted: 16 Apr 2022 18:25
by forhire
I think I found the issue. Not sure why postfix_relay isn't starting. I did managed to get it restart once last night but it promptly died. milter_relay is running. Rebooting the server made no change. Any ideas?

Code: Select all

[user@smtp ~]$ sudo systemctl status postfix_relay
● postfix_relay.service - Postfix relay service for MailWatch
   Loaded: loaded (/usr/bin/mailwatch/tools/Postfix_relay; enabled; vendor preset: disabled)
   Active: failed (Result: start-limit) since Sat 2022-04-16 10:59:21 PDT; 12min ago
  Process: 3911 ExecStart=/usr/bin/php -q /usr/bin/mailwatch/tools/Postfix_relay/mailwatch_postfix_relay.php (code=exited, status=255)
 Main PID: 3911 (code=exited, status=255)

Apr 16 10:59:21 smtp.domain.com systemd[1]: Unit postfix_relay.service entered failed state.
Apr 16 10:59:21 smtp.domain.com systemd[1]: postfix_relay.service failed.
Apr 16 10:59:21 smtp.domain.com systemd[1]: postfix_relay.service holdoff time over, scheduling restart.
Apr 16 10:59:21 smtp.domain.com systemd[1]: Stopped Postfix relay service for MailWatch.
Apr 16 10:59:21 smtp.domain.com systemd[1]: start request repeated too quickly for postfix_relay.service
Apr 16 10:59:21 smtp.domain.com systemd[1]: Failed to start Postfix relay service for MailWatch.
Apr 16 10:59:21 smtp.domain.com systemd[1]: Unit postfix_relay.service entered failed state.
Apr 16 10:59:21 smtp.domain.com systemd[1]: postfix_relay.service failed.

Re: Relay Information missing from message details

Posted: 16 Apr 2022 18:32
by forhire
It looks like either I have a missing/broken column in the database or an issue with the field list. Still digging.

Code: Select all

[user@smtp ~]$ sudo /usr/bin/php -q /usr/bin/mailwatch/tools/Postfix_relay/mailwatch_postfix_relay.php

Fatal error: Uncaught mysqli_sql_exception: Unknown column 'to_address' in 'field list' in /var/www/html/mailscanner/functions.php:1054
Stack trace:
#0 /var/www/html/mailscanner/functions.php(1054): mysqli->query()
#1 /var/www/html/mailscanner/mtalogprocessor.inc.php(135): dbquery()
#2 /var/www/html/mailscanner/mtalogprocessor.inc.php(179): MtaLogProcessor->processLine()
#3 /usr/bin/mailwatch/tools/Postfix_relay/mailwatch_postfix_relay.php(97): MtaLogProcessor->doit()
#4 {main}
  thrown in /var/www/html/mailscanner/functions.php on line 1054
cat: write error: Broken pipe


Re: Relay Information missing from message details

Posted: 16 Apr 2022 22:33
by forhire
I ran upgrade.php and postfix_relay is now running.

sudo /usr/bin/php -e /usr/bin/mailwatch/tools/upgrade.php

I'm still not seeing the Relay Information. Now I'm at a real loss. Any ideas?

Re: Relay Information missing from message details

Posted: 17 Apr 2022 05:16
by forhire
The database table mtalog_id is NOT updating. I selected a message from the logs. Grabbed the smtpd_id and the smtp_id and manually inserted them into the mtalog_id table. The Relay Information now appears in the message details for that message. Watching the count on mta_log_id table confirms it is NOT updating. The mtalog table is populating properly. Now I just need to figure out what code/daemon should be updating the table.

I pulled a random message-id from the logs:
Apr 16 21:13:51 smtp postfix/cleanup[20077]: 4KgxWz0KjMzB48GB: message-id=<c1dd2922-be04@foo.com>
Apr 16 21:13:56 smtp postfix/cleanup[20077]: 4KgxX45MBhzB48GB: message-id=<c1dd2922-be04@foo.com>

I then inserted the smtpd_id and smtp_id into the mtalog_id table:
MariaDB [mailscanner]> INSERT INTO mtalog_ids (smtpd_id,smtp_id) VALUES ("4KgxWz0KjMzB48GB", "4KgxX45MBhzB48GB");
Query OK, 1 row affected (0.04 sec)

Re: Relay Information missing from message details

Posted: 17 Apr 2022 08:02
by freyuh
I have the same problem, Blut it`s more weired.
I have 2 eFas and the second is an exakt clone of the first one.
But I see the relay info on the second eFa. On the first one it is missing.
I have to take a deeper look on it next week.

Re: Relay Information missing from message details

Posted: 17 Apr 2022 13:05
by shawniverson
The milter_relay daemon is responsible for inserting into the table mtalog_ids. So if you aren't getting this information, this is where we need to focus.

Restarting the milter_relay daemon causes it to rescan the maillog before following it live. So if it doesn't capture anything after restarting, we definitely have something to look at here.

Re: Relay Information missing from message details

Posted: 17 Apr 2022 15:34
by shawniverson
I hate my own code sometimes... :oops:

Please download this copy and test and/or debug (DEBUG_MILTER can be set to true and restarted to get detailed logging to the maillog)...

Code: Select all

curl -sSL https://raw.githubusercontent.com/shawniverson/MailWatch/041722milter_relay/tools/Postfix_relay/mailwatch_milter_relay.php | sudo tee /usr/bin/mailwatch/tools/Postfix_relay/mailwatch_milter_relay.php
sudo systemctl daemon-reload
sudo systemctl restart milter_relay

Re: Relay Information missing from message details

Posted: 17 Apr 2022 18:22
by forhire
shawniverson, I installed the patched version this morning as it is working great. Thank you!!

Re: Relay Information missing from message details

Posted: 19 Apr 2022 12:06
by freyuh
No problems so far ...

Re: Relay Information missing from message details

Posted: 27 May 2022 11:59
by mendark
Hello,
I have exact situation, but this problem aper when i modify chown on postfix folder to be root, on all folder.
Can be from change the owener of postfix folder?

Thank you

Re: Relay Information missing from message details

Posted: 10 Jun 2022 19:05
by mendark
Hello,
So i have some little update, i decide to convert Rocky Linux 8 to Alma Linux and relay information work again, but from today relay information disappear again. Can you help me with this situation?

Thank you