Search found 1135 matches

by pdwalker
02 Nov 2018 06:47
Forum: 3.x How-to
Topic: Admin user pw reset does not work
Replies: 5
Views: 281

Re: Admin user pw reset does not work

try this:

mysql
use mailscanner;
select username from users;

What do you get?
by pdwalker
02 Nov 2018 06:42
Forum: 3.x Bugs
Topic: Database issue not assigning token.
Replies: 25
Views: 1245

Re: Database issue not assigning token.

ooooh! that's useful. I didn't know that one.
by pdwalker
31 Oct 2018 11:19
Forum: 3.x How-to
Topic: Forwarding rule to external address and change of sender address
Replies: 3
Views: 136

Re: Forwarding rule to external address and change of sender address

Actually, that should be possible. I'll investigate. There may be a few ways this may be done: 1/ you can allow the exchange user Y to "send as X", thus the email from user Y will have an address of X - manual process though. 2/ possibly the transport rules in exchange server may allow rewriting? Ne...
by pdwalker
30 Oct 2018 06:11
Forum: 3.x Bugs
Topic: Database issue not assigning token.
Replies: 25
Views: 1245

Re: Database issue not assigning token.

I previously had performance issues running the vmware image under esxi server - and somehow I resolved the problem. I think I had a problem with my disk controller configuration on my esxi server so disk io performance was terribly slow. Are you running your vm image under esxi server? If so, what ...
by pdwalker
30 Oct 2018 06:09
Forum: 3.x How-to
Topic: Forwarding rule to external address and change of sender address
Replies: 3
Views: 136

Re: Forwarding rule to external address and change of sender address

This feature is not a feature of EFA, but rather your mail server.

What mail server do you use?
by pdwalker
29 Oct 2018 04:17
Forum: 3.x How-to
Topic: How to allow a NON US sender
Replies: 2
Views: 181

Re: How to allow a NON US sender

Which log file on which machine did you pull that message from?
by pdwalker
29 Oct 2018 04:13
Forum: 3.x Bugs
Topic: Database issue not assigning token.
Replies: 25
Views: 1245

Re: Database issue not assigning token.

So, there is something funny going on with your mysql. What, I'm not sure. One good thing is your IO Wait is low (0.2%wa) which would normally indicate a problem with writing to the disks if it were high. And your memory allocation seems reasonable, so that shouldn't be it. And your system has enoug...
by pdwalker
26 Oct 2018 03:39
Forum: 3.x How-to
Topic: Greylistning and connection statistics
Replies: 4
Views: 117

Re: Greylistning and connection statistics

Maybe. If I look at the logs in more detail, I should be able to see if that is the pattern or not.

Or, I could look at the sqlgrey source code and find the definitive answer...
by pdwalker
25 Oct 2018 08:52
Forum: 3.x How-to
Topic: Making sure an email has never reached EFA
Replies: 3
Views: 122

Re: Making sure an email has never reached EFA

To better answer your question: is it possible for EFA to block a message and not record it? Yes, but that will be in the /var/log/maillog files. If it is not, then it never reached EFA at all.
by pdwalker
25 Oct 2018 08:51
Forum: 3.x How-to
Topic: Making sure an email has never reached EFA
Replies: 3
Views: 122

Re: Making sure an email has never reached EFA

First, you have to know what your mail flow is. Then, you need to check the logs of every system under your control to see if the mail actually arrived. For example, my system is Internet -> Messagelabs -> EFA -> Exchange. Since Messagelabs is the first point of contact, I check their logs for the m...
by pdwalker
25 Oct 2018 03:18
Forum: 3.x How-to
Topic: Block Office documents with Macro's and notify recipient, rulebased
Replies: 8
Views: 1317

Re: Block Office documents with Macro's and notify recipient, rulebased

The problem is macro detection is very very weird. When I was looking into the problem earlier, I discovered that there is no "one way" to absolutely guarantee that you can detect a macro inside an office document file because of the multitude of office document formats from over the years and diffe...
by pdwalker
25 Oct 2018 03:10
Forum: 3.x Bugs
Topic: Database issue not assigning token.
Replies: 25
Views: 1245

Re: Database issue not assigning token.

Apologies, been sick, so I forgot to follow up. I suspect your sql instance isn't configured to use enough memory. Can you give me a "top" screenshot showing your mysqld. For a reference, here is my top (sorted by % memory) top - 11:10:13 up 50 days, 1 min, 1 user, load average: 0.23, 0.17, 0.13 Tas...
by pdwalker
25 Oct 2018 03:08
Forum: 3.x How-to
Topic: Greylistning and connection statistics
Replies: 4
Views: 117

Re: Greylistning and connection statistics

I suggest you search the maillog and look for the string " sqlgrey: ". This string will be the message lines that tell you what sqlgrey is doing. In my logs, I see the following: whitelist: -> emails senders that have been whitelisted already by sqlgrey spam: -> huh? how does sql grey know if a mess...
by pdwalker
25 Oct 2018 02:56
Forum: 3.x How-to
Topic: Disable spam check outgoing email
Replies: 17
Views: 1953

Re: Disable spam check outgoing email

^^^ spam. Could someone delete that garbage please?
by pdwalker
24 Oct 2018 09:51
Forum: Discussion
Topic: AWL Spam
Replies: 5
Views: 231

Re: AWL Spam

Have you tried training the system with the spam that was misclassified?
by pdwalker
23 Oct 2018 08:40
Forum: Discussion
Topic: AWL Spam
Replies: 5
Views: 231

Re: AWL Spam

I've checked the spam report, and the difference is that the later emails have a negative AWL score which then allows it through. For example: -1.32 AWL Adjusted score from AWL reputation of From: address I'd be curious know what the AWL score is from the 6 messages you listed. Was the AWL score go...
by pdwalker
23 Oct 2018 08:37
Forum: Discussion
Topic: AWL Spam
Replies: 5
Views: 231

Re: AWL Spam

Can someone run a "SpamAssassun Rule Hits" report under "Search and Reports" for me and tell me if you have any entries for AWL or TXREP and what your results are? It's supposed to be enabled by default, but it doesn't seem to be doing anything on my system, so I'd like to make a comparison. My repo...
by pdwalker
23 Oct 2018 05:55
Forum: Discussion
Topic: AWL Spam
Replies: 5
Views: 231

Re: AWL Spam

That score is being generated by the spamassassin autowhitelist plugin.

Some reasons it might be going wrong.

Now that I am looking, it seems this plugin is not giving me any results on my system, so I cannot test and verify what it is doing until I resolve that issue.
by pdwalker
19 Oct 2018 09:13
Forum: 3.x How-to
Topic: See content of greylisted message
Replies: 2
Views: 218

Re: See content of greylisted message

No, for the reason @Rhopkins13 described.

You can only see the message after it has been resent and accepted
by pdwalker
16 Oct 2018 03:04
Forum: 3.x Bugs
Topic: Database issue not assigning token.
Replies: 25
Views: 1245

Re: Database issue not assigning token.

ok, so what i can see is there is a delete query running on the mtalog table that's taking a long time to complete. And because that query locks the table, everything else stalls. So, why is there a delete query, and why is it taking so long? I'll need to check the mailwatch code to see if I can fig...
by pdwalker
13 Oct 2018 04:16
Forum: 3.x How-to
Topic: Update Postfix
Replies: 2
Views: 229

Re: Update Postfix

Most people here just want an appliance that "just works". When you start messing with the system and installing your own custom software, then you run the risk of creating conflicts that make it very difficult to upgrade the system. If you're comfortable with these kinds of things, then go for it. ...
by pdwalker
12 Oct 2018 10:53
Forum: 3.x Bugs
Topic: Blacklist/Whitelist not working
Replies: 13
Views: 482

Re: Blacklist/Whitelist not working

Looks like I am getting things mixed up. Anyway, according to my previous test, the whitelisting/blacklisting worked just fine. Can you add a valid external email address to your blacklist and test it yourself like I did? Then repeat it for the whitelist in the manner similar to what I did? Accordin...
by pdwalker
12 Oct 2018 10:25
Forum: 3.x Bugs
Topic: Blacklist/Whitelist not working
Replies: 13
Views: 482

Re: Blacklist/Whitelist not working

How do you know it's not using them? Try this: cd /var/spool/MailScanner grep -r X-Greylist: *|less I get a lot of entries like this: quarantine/20180914/nonspam/A2B9B182AA3.A9CDD:X-Greylist: whitelisted by SQLgrey-1.8.0 quarantine/20180914/nonspam/17388182A9B.ADAAB:X-Greylist: whitelisted by SQLgre...
by pdwalker
12 Oct 2018 09:33
Forum: 3.x Bugs
Topic: Blacklist/Whitelist not working
Replies: 13
Views: 482

Re: Blacklist/Whitelist not working

I'd look in your mail log to see if you can see anything interesting. For example, the following command shows me that mailwatch frequently updates the black and white list entries: grep " MailWatch: Read " /var/log/maillog| tail -100 | vim - I assume it's pulling from the database. Maybe you can se...
by pdwalker
12 Oct 2018 09:24
Forum: Discussion
Topic: SQLGrey and Senders with Multiple IPs
Replies: 7
Views: 636

Re: SQLGrey and Senders with Multiple IPs

Yeah, so here is how it looks on my system [root@efa MailScanner]# grep -r "X-Greylist: whitelisted" * | wc -l 36543 [root@efa MailScanner]# grep -r "X-Greylist: delayed" * | wc -l 35 That's roughly a little less than 0.1% of all mail received in the last 60 days got greylisted, delayed and then del...