<div dir="ltr"><div><div><div><div>Already fixed this problem.<br></div>I'm my CSF firewall configuration, I restricted access to the SYSLOG too much, so MailScanner didn't had proper access to it.<br></div>That's why it didn't log it's actions properly in postfix maillog and my SQL didn't get filled with the mailscanner_relay.php script.<br><br></div>Thanks anyway for today's topic!<br><br><br></div>Greetings Z3us.<br><div><div><div><div><div><div class="gmail_extra"><br><div class="gmail_quote">2017-01-13 13:00 GMT+01:00 <span dir="ltr"><<a href="mailto:mailscanner-request@lists.mailscanner.info" target="_blank">mailscanner-request@lists.mailscanner.info</a>></span>:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Send MailScanner mailing list submissions to<br>
<a href="mailto:mailscanner@lists.mailscanner.info">mailscanner@lists.mailscanner.<wbr>info</a><br>
<br>
To subscribe or unsubscribe via the World Wide Web, visit<br>
<a href="http://lists.mailscanner.info/mailman/listinfo/mailscanner" rel="noreferrer" target="_blank">http://lists.mailscanner.info/<wbr>mailman/listinfo/mailscanner</a><br>
or, via email, send a message with subject or body 'help' to<br>
<a href="mailto:mailscanner-request@lists.mailscanner.info">mailscanner-request@lists.<wbr>mailscanner.info</a><br>
<br>
You can reach the person managing the list at<br>
<a href="mailto:mailscanner-owner@lists.mailscanner.info">mailscanner-owner@lists.<wbr>mailscanner.info</a><br>
<br>
When replying, please edit your Subject line so it is more specific<br>
than "Re: Contents of MailScanner digest..."<br>
<br>
<br>
Today's Topics:<br>
<br>
1. Problem auto-filling SQL mtalog_ids from maillog (Z3us Linux)<br>
<br>
<br>
------------------------------<wbr>------------------------------<wbr>----------<br>
<br>
Message: 1<br>
Date: Thu, 12 Jan 2017 08:03:20 +0100<br>
From: Z3us Linux <<a href="mailto:z3us.linux@gmail.com">z3us.linux@gmail.com</a>><br>
To: <a href="mailto:mailscanner@lists.mailscanner.info">mailscanner@lists.mailscanner.<wbr>info</a><br>
Subject: Problem auto-filling SQL mtalog_ids from maillog<br>
Message-ID:<br>
<<a href="mailto:CADcP%2BmUzoQKtuZ0nXgrtoxN%2BgexuPB0CTgaSfY9Ovpv9BxUb%2Bw@mail.gmail.com">CADcP+mUzoQKtuZ0nXgrtoxN+<wbr>gexuPB0CTgaSfY9Ovpv9BxUb+w@<wbr>mail.gmail.com</a>><br>
Content-Type: text/plain; charset="utf-8"<br>
<br>
Hi guys,<br>
<br>
I'm running the latest version of Mailscanner and Mailwatch with postfix on<br>
CentOS 6.8.<br>
Somehow the relay information for mails isn't showing anymore (on<br>
mailscanner/detail.php).<br>
I saw that in detail.php there is a SQL query matching tables mtalog and<br>
mtalog_ids so relay information is being display on the webpage.<br>
I also discovered that the SQL table mtalog_ids in DB mailscanner isn't<br>
being filled anymore.<br>
In my troubleshooting sessions I found out<br>
that /var/www/html/mailscanner/<wbr>mailscanner_relay.php is looking into the<br>
postfix maillog for entries to fill in de DB in SQL:<br>
if (preg_match('/^.*MailScanner.*<wbr>: Requeue: (\S+\.\S+) to (\S+)\s$/',<br>
$line, $explode))<br>
<br>
When I'm looking into the postfix maillog, I can't find any lines with<br>
"Requeue" in it....<br>
This stopped a few weeks a go.<br>
What is causing this issue?<br>
Why isn't MailScanner writing those lines in the maillog anymore?<br>
I tried looking into all configuration files from the date it stopped<br>
logging those lines, but I can't find anything useful.<br>
<br>
Thanks in advance!<br>
z3us.<br>
-------------- next part --------------<br>
An HTML attachment was scrubbed...<br>
URL: <<a href="http://lists.mailscanner.info/pipermail/mailscanner/attachments/20170112/13d193e3/attachment-0001.html" rel="noreferrer" target="_blank">http://lists.mailscanner.<wbr>info/pipermail/mailscanner/<wbr>attachments/20170112/13d193e3/<wbr>attachment-0001.html</a>><br>
<br>
------------------------------<br>
<br>
Subject: Digest Footer<br>
<span class="HOEnZb"><font color="#888888"><br>
<br>
<br>
--<br>
MailScanner mailing list<br>
<a href="mailto:mailscanner@lists.mailscanner.info">mailscanner@lists.mailscanner.<wbr>info</a><br>
<a href="http://lists.mailscanner.info/mailman/listinfo/mailscanner" rel="noreferrer" target="_blank">http://lists.mailscanner.info/<wbr>mailman/listinfo/mailscanner</a><br>
<br>
<br>
------------------------------<br>
<br>
End of MailScanner Digest, Vol 133, Issue 14<br>
******************************<wbr>**************<br>
</font></span></blockquote></div><br></div></div></div></div></div></div></div>