Re: could use some spamdb output

2019-01-10 Thread Boudewijn Dijkstra
Op Fri, 21 Dec 2018 17:10:46 +0100 schreef Gilles Chehade  
:



spamdb | grep -E '^(GREY|WHITE)\|' | cut -d\| -f1,2



--
Gemaakt met Opera's e-mailprogramma: http://www.opera.com/mail/



could use some spamdb output

2018-12-21 Thread Gilles Chehade
hello misc@,

If you are comfortable with sharing your spamdb output with me, it would
be very helpful in confirming or not some theories I have.

I do not need the sender/recipient parts, only the first two fields that
disclose if the connection is in GREY or WHITE list and IP address of MX
that initated the connection:

$ spamdb | grep -E '^(GREY|WHITE)\|' | cut -d\| -f1,2


Do not spam misc@ with that output, send it directly to me.

Thanks !

-- 
Gilles Chehade @poolpOrg

https://www.poolp.org tip me: https://paypal.me/poolpOrg



Re: spamdb output

2007-11-21 Thread RW
On Mon, 19 Nov 2007 14:47:37 -0700, Bob Beck wrote:

 RW [EMAIL PROTECTED] [2007-11-11 22:39]:

 It seems that the migrated database works but new entries go on the end
 - no SORT of order, and SPAMTRAP entries (that I entered using a
 script) ended up showing in two bunches in the midst of other unordered
 entries.
 
 My question is: Is this normal with spamd a la 4.2 or is it because I
 migrated a database?

   This is normal in 4.2 - the change happened post 4.0 when
spamdb stopped using DB_BTREE

Thanks Bob. I'm already using a script to sort the list to emulate the
previous behaviour but at least I know I'll have to keep a copy for any
future wipe and re-install upgrade.

Looking at today's output showed me another puzzle which you will
probably shoot down, but here goes.

Here is one line fro
spamdb:
GREY|69.28.223.134|mta5br.cmpgnr.com|gotb1103621_1102728_683443_1138134
[EMAIL PROTECTED]
|[EMAIL PROTECTED]|1195673789|1195675648|1195688189|2|0
but here is a line from my spamlog:
Nov 22 07:08:14 mail spamd[28826]: whitelisting 69.28.223.134 in
/var/db/spamd

Why does the spamdb output show GREY instead of WHITE three hours
later? It does show the 2 knocks which date -r will show were more than
a half hour apart and so the whitelisting should have happened.

Colour me puzzled.

BTW the envelope recipient address shown is a spamtrap and is my only
edit of the output.

Thanks again for spamd. I absolutely love it. I have never known of it
causing loss of genuine mail and also grepping the mail log daily for
reject has only shown two emails in the last six months being blocked
by zen.spamhaus having passed spamd. Both were really spammers anyway
so apmd has an extremely good batting average.

Two domains hosted on that box and zero customer complaints = mail
admin happiness.

In the beginning was The Word
and The Word was Content-type: text/plain
The Word of Rod.



Re: spamdb output

2007-11-19 Thread Bob Beck
* RW [EMAIL PROTECTED] [2007-11-11 22:39]:

 It seems that the migrated database works but new entries go on the end
 - no SORT of order, and SPAMTRAP entries (that I entered using a
 script) ended up showing in two bunches in the midst of other unordered
 entries.
 
 My question is: Is this normal with spamd a la 4.2 or is it because I
 migrated a database?

This is normal in 4.2 - the change happened post 4.0 when
spamdb stopped using DB_BTREE

-Bob



spamdb output

2007-11-11 Thread RW
I just got through updating a mailserver that had been running 4.0 to
4.2 using a new HDD, fresh install of OS and required packages. All old
scripts settings etc preserved on original HDD now sitting in an
accessible older box so I can grab anything forgotten.

The one thing that hit me was the output of spamdb.

Back on 4.0 all the entries came out (sort of) sorted.
All the SPAMTRAP entries last but sorted on the trap address field.
All the GREY, WHITE or TRAPPED entries first sorted on the IP field
(but sorted 
alphabetically i.e. 101.x.y.z precedes 99.x.y.z)

All that was fine because I could easily see if there were two entries
for the one IP which happened when a script that runs every few minutes
evaluates a GREY entry and enters it as TRAPPED.

It seems that the migrated database works but new entries go on the end
- no SORT of order, and SPAMTRAP entries (that I entered using a
script) ended up showing in two bunches in the midst of other unordered
entries.

My question is: Is this normal with spamd a la 4.2 or is it because I
migrated a database?

I can always use:  spamdb |sort -n -t | -k 2 |less  to get a fully
sorted list if I have to, but curiosity makes me ask about expected
behaviour.

Of course (to cut off pedants) I could have used:  spamdb |sort -t |
-k 2 -n|less to get the output looking like that from 4.0.
Thanx,

Rod/
/earth: write failed, file system is full
cp: /earth/creatures: No space left on device



Spamdb Output Format Mismatch

2007-03-28 Thread Jason Haag
From man spamdb:

=
For GREY or WHITE entries, the format is:

  type|source IP|helo|from|to|first|pass|expire|block|pass
=

When I at the spamdb output on my box I get (2 representative entries):

=
GREY|194.242.40.177|tlnordic.moduleweb.net||[EMAIL PROTECTED]
apture.com|1175098496|1175112896|1175112896|1|0
=
Yep, looks like it should.

=
WHITE|91.89.52.244|||1175062170|1175064001|1178174455|3|0
=
Hm, there is a field missing. It should display  instead of |||.

Can anyone confirm this? Or is my box messed up in the head?

Thanks,
-Jason



Re: Spamdb Output Format Mismatch

2007-03-28 Thread Stuart Henderson
On 2007/03/28 16:28, Jason Haag wrote:
 For GREY or WHITE entries, the format is:
   type|source IP|helo|from|to|first|pass|expire|block|pass
 
 When I at the spamdb output on my box I get (2 representative entries):
 WHITE|91.89.52.244|||1175062170|1175064001|1178174455|3|0

 Can anyone confirm this? Or is my box messed up in the head?

Mine does the same. I don't know whether it's a doc-bug or sw-bug.

Of course this gets especially confusing when somebody sends a helo
with | in it...