efa-project.org

Code: Select all

Nov 15 07:11:16 mx1 php: PHP Notice:  Trying to access array offset on value of type null in /usr/bin/mailwatch/tools/Postfix_relay/mailwatch_milter_relay.php on line 120
Nov 15 07:11:16 mx1 php: Notice: Trying to access array offset on value of type null in /usr/bin/mailwatch/tools/Postfix_relay/mailwatch_milter_relay.php on line 120
Nov 15 07:11:17 mx1 php: PHP Notice:  Trying to access array offset on value of type null in /usr/bin/mailwatch/tools/Postfix_relay/mailwatch_milter_relay.php on line 120
Nov 15 07:11:17 mx1 php: Notice: Trying to access array offset on value of type null in /usr/bin/mailwatch/tools/Postfix_relay/mailwatch_milter_relay.php on line 120
Nov 15 07:11:18 mx1 php: PHP Notice:  Trying to access array offset on value of type null in /usr/bin/mailwatch/tools/Postfix_relay/mailwatch_milter_relay.php on line 120
Nov 15 07:11:18 mx1 php: Notice: Trying to access array offset on value of type null in /usr/bin/mailwatch/tools/Postfix_relay/mailwatch_milter_relay.php on line 120
Nov 15 07:11:19 mx1 php: PHP Notice:  Trying to access array offset on value of type null in /usr/bin/mailwatch/tools/Postfix_relay/mailwatch_milter_relay.php on line 120
Nov 15 07:11:19 mx1 php: Notice: Trying to access array offset on value of type null in /usr/bin/mailwatch/tools/Postfix_relay/mailwatch_milter_relay.php on line 120
Nov 15 07:11:20 mx1 php: PHP Notice:  Trying to access array offset on value of type null in /usr/bin/mailwatch/tools/Postfix_relay/mailwatch_milter_relay.php on line 120
Nov 15 07:11:20 mx1 php: Notice: Trying to access array offset on value of type null in /usr/bin/mailwatch/tools/Postfix_relay/mailwatch_milter_relay.php on line 120
Nov 15 07:11:21 mx1 php: PHP Notice:  Trying to access array offset on value of type null in /usr/bin/mailwatch/tools/Postfix_relay/mailwatch_milter_relay.php on line 120
Nov 15 07:11:21 mx1 php: Notice: Trying to access array offset on value of type null in /usr/bin/mailwatch/tools/Postfix_relay/mailwatch_milter_relay.php on line 120

Code: Select all

                            $result = dbquery("SELECT id from `maillog` where messageid='" . $message_id . "' LIMIT 1;");
                            $smtpd_id = $result->fetch_row()[0];

Code: Select all

MariaDB [mailscanner]> select count(*) from maillog where messageid = '';
+----------+
| count(*) |
+----------+
|    99240 |
+----------+

MariaDB [mailscanner]> select count(*) from maillog where messageid = '';
+----------+
| count(*) |
+----------+
|    99242 |
+----------+

Code: Select all

MariaDB [mailscanner]> select count(*) from maillog where messageid <> '';
+----------+
| count(*) |
+----------+
|  1141873 |
+----------+

Code: Select all

                            $result = dbquery("SELECT id from `maillog` where messageid='" . $message_id . "' LIMIT 1;");
                            $smtpd_id = $result->fetch_row()[0]; <-- THIS trigger the notice because if there is no results the returned object is not an array (i guess)
                            if ($smtpd_id === null) { 
                                // Add a small delay to prevent race condition between mailwatch logger db and maillog
                                sleep(1);
                            } else {
                                break;
                            }

Code: Select all

@$smtpd_id = $result->fetch_row()[0];

Code: Select all

if ( $_ =~ /^message-id: (\S+)$/i ) {
   $messageid = $1;

Code: Select all

Message-ID: 
 <GVAP278MB0310DE2FC290B07EFC17D9BF9F989@GVAP278MB0310.CHEP278.PROD.OUTLOOK.COM>
References: 
 <0107017d233b1df7-ece4d4e1-fb2a-4ca4-9e69-c40aa4de4510-000000@eu-central-1.amazonses.com>
 <ZRAP278MB0173D46E2C469520B41312DC96989@ZRAP278MB0173.CHEP278.PROD.OUTLOOK.COM>

Code: Select all

By default, Postfix probe messages have a sender address "double-bounce@$myorigin" (with Postfix versions before 2.5, the default is "postmaster@$myorigin"). This is SAFE because the Postfix SMTP server does not reject mail for this address.

Code: Select all

Nov 15 18:38:30 mx1 postfix/cleanup[93273]: 4HtGd26nP3zRtpQb: message-id=<4HtGd26nP3zRtpQb@mx1.xxxcom>
Nov 15 18:38:30 mx1 postfix/qmgr[92202]: 4HtGd26nP3zRtpQb: from=<double-bounce@mx1.xxx.com>, size=277, nrcpt=1 (queue active)
Nov 15 18:38:30 mx1 postfix/smtp[99679]: 4HtGd26nP3zRtpQb: to=<hello@xyz.com>, relay=mail01.xxx.com[94.xxx.xxx.xxx]:20025, delay=0.04, delays=0/0/0.03/0.01, dsn=2.0.0, status=deliverable (250 OK <hello@xyz.com> Recipient ok)
Nov 15 18:38:30 mx1 postfix/qmgr[92202]: 4HtGd26nP3zRtpQb: removed

Code: Select all

sudo yum clean all
sudo yum update

Code: Select all

[root@mx1 sriccio]# diff /usr/bin/mailwatch/tools/Postfix_relay/mailwatch_milter_relay.php mailwatch_milter_relay.php 
44c44,46
< define('QUERYTIMEOUT', '60');
---
> define('QUERYTIMEOUT', '10');
> 
> define('MYORIGIN', 'mx1.swisscenter.com');
56a59,62
>             if (preg_match('/@' . MYORIGIN . '/', $message_id)) {
>               echo "DEBUG: (doit) Skipping " . $message_id . "\n";
>               continue;
>             }
58c64
<             $smtpd_id = $result->fetch_row()[0];
---
>             @$smtpd_id = $result->fetch_row()[0];
86a93,97
>                 $message_id = safe_value($explode[2]);
>                 if (preg_match('/@' . MYORIGIN . '/', $message_id)) {
>                     echo "DEBUG: (follow) Skipping " . $message_id . "\n";
>                     continue;
>                 }
118a130
>                             echo "DEBUG: message_id " . $message_id . " Loop count: " . $j . "\n";
120c132
<                             $smtpd_id = $result->fetch_row()[0];
---
>                             @$smtpd_id = $result->fetch_row()[0];
128a141
>                             echo "DEBUG: message_id " . $message_id . " Found match!\n";

Code: Select all

MariaDB [mailscanner]> select messageid from maillog where id = '4HtXLp6B7jzVj4M6';
+-----------+
| messageid |
+-----------+
|           |
+-----------+

Code: Select all

sudo yum clean all
sudo yum update