Postfix - antispam and relay package

n3by

Another bug ??

I found that widget is not displaying correct status.

I have configured postfix as backup relay MX2 on Site2 - it receive external mail from WAN if primary mail server MX1 on Site1 is unreachable and it store and forward all email by VPN Site - to - Site.
I also receive all emails from Site2 - from all LANs - and forward them to primary email server on Site1 by VPN Site - to - Site.

But until it receive a email from WAN ( Update Sqlite was on 1h and now is on 10 min), widget is not display anything for that day; emails from LAN are not showed;
As you can see it is missing day 10 and day 11 was displayed only if I blocked primary mail server to receive emails from WAN and email was delivered to MX2 and then forwarded to MX1…

p.s.
I just found also this one in log probably related to Postwhite:

postfix/postscreen[34560]: error: open /usr/local/etc/postfix/postscreen_spf_whitelist.cidr: No such file or directory

Screenshot_2017-04-11_14-31-48.png_thumb

Bismarck

@ecfx:

p.s.
I just found also this one in log probably related to Postwhite:
postfix/postscreen[34560]: error: open /usr/local/etc/postfix/postscreen_spf_whitelist.cidr: No such file or directory

Because you need to run /usr/local/bin/postwhite manually first, can't find any code atm in the package, which would trigger it automatically.

Just running Postfix as a Mail Proxy and my widget stats are very accurate.

n3by

no luck:

/usr/local/bin: ./postwhite
./postwhite: Permission denied.
...
/usr/local/bin: ls -la post*
-rw-r--r--  1 root  wheel  9789 Apr  9 14:59 postwhite
/usr/local/bin: chmod 755 postwhite
/usr/local/bin: ls -la post*
-rwxr-xr-x  1 root  wheel  9789 Apr  9 14:59 postwhite
/usr/local/bin: ./postwhite
./postwhite: Command not found.

Bismarck

nano /usr/local/bin/postwhite

1 line change from


#! /bin/bash

to

#! /usr/local/bin/bash

fetch -q -o /usr/local/etc/postwhite.conf https://raw.githubusercontent.com/stevejenkins/postwhite/master/postwhite.conf

and

ln -s /usr/local/etc/postwhite.conf /etc/postwhite.conf

nano /usr/local/etc/postwhite.conf

edit paths

# FILE PATHS
spftoolspath=/usr/local/bin/spf-tools
postfixpath=/usr/local/etc/postfix
postfixbinarypath=/usr/local/sbin
whitelist=postscreen_spf_whitelist.cidr
blacklist=postscreen_spf_blacklist.cidr
yahoo_static_hosts=/usr/local/etc/postfix/yahoo_static_hosts.txt

now run

/usr/local/bin/postwhite

Good luck!

n3by

Thank you but is exactly the same as before.
I can live without postwhite and widget as before…

marcelloc

@ecfx:

Thank you but is exactly the same as before.
I can live without postwhite and widget as before…

fixed postwhite config file creation and etc path call

Bismarck

Thanks, the widget shortcuts are handy. :)

Igor Filth

Can I run "install_postfix_23.sh" script again or I must remove all installed packages first ::)

Bismarck

@Igor:

Can I run "install_postfix_23.sh" script again or I must remove all installed packages first ::)

As far as I can see, it should not be a issue, just run the script again.

marcelloc

Included postfwd functions to limit messages per user and time based on package.

To use this funcion you must run the install cpan modules script from pkg-mailscanner

https://raw.githubusercontent.com/marcelloc/Unofficial-pfSense-packages/master/pkg-mailscanner/files/install_cpan_modules_23.sh

Fist time implementation, not used to run postfwd, so feedbacks are always welcome.

postfwd.PNG_thumb

marcelloc

@marcelloc:

@Bismarck:

Yes, but it looks like the widget just counts high scored spam and not all, same when searching for spam in postfix_search.php it just finds high scored spam and the numbers of high scored spam are are always the same in the widget and MailMatch.

The point is that database gets the last status from message. 'Normal spam' on your configuration are sent to user, this way, last state is sent, instead of spam.

I've pushed a commit that updates the status only when it's not a spam message
https://github.com/marcelloc/Unofficial-pfSense-packages/commit/d6dcd6d63ae83886aa9da00f545137fa2cd6b046

marcelloc

Also, I've include 7zip, rar and PDFID patch to mailscanner package, just re-run install to get latest updates.

Thanks for Bismarck and danny at tweegy.nl 8)

Bismarck

Thanks, I'm not at the office at the moment, will check it out when back. 8)

Bigdaddy168

Hey guys, would it be possible to include a pop3 connector like fetchmail or getmail?

marcelloc

@Bigdaddy168:

Hey guys, would it be possible to include a pop3 connector like fetchmail or getmail?

There was a package for it(p3scan) but it's too old and abandoned http://p3scan.sourceforge.net

danjeman

updated but now have two 'Mailscanner' Service menu items… Looks like the check_mailscanner_service.php is looking for menu item 'mailscanner' not 'Mailscanner'...

marcelloc

@danjeman:

updated but now have two 'Mailscanner' Service menu items… Looks like the check_mailscanner_service.php is looking for menu item 'mailscanner' not 'Mailscanner'...

Thanks for the feedback. I'll fix it.

danjeman

Was not getting any sqllite db's from the logs despite all settings being correct then found an old post referencing an issue if you have other characters in the hostname (- for instance which I do). So took a look at postfix.php and updated the regex match looking for date and hostname from:
preg_match("/(\w+\s+\d+\s+[0-9,:]+) (\w+))….. to
preg_match("/(\w+\s+\d+\s+[0-9,:]+) (\w+([.-]?\w+))….... and voilla now have widget and search logs available...

Will verify stats are valid but looks good so far :)

n3by

I think I am in the same situation as I have some hosts and email addresses that contain " - " and widget is not updating.

Can you please be more specific where in the file and what to change/patch as searching for

preg_match("/(\w+\s+\d+\s+[0-9,:]+) (\w+)
```=```
preg_match("/(\\w+\\s+\\d+\\s+[0-9,:]+) (\\w+)
```find many instances of that code.

Please use "Insert Code" to preserve the format.

thank you.

marcelloc

@ecfx:

Can you please be more specific where in the file and what to change/patch.

At the beginning of every log pregmatch under /usr/local/www/postfix.php

I'll modify it to get hostname from system or xml