spamprobe

[Scott van Looy]

Hi,

I recently recovered my home partition from some corruption. Most of everything is working OK but my spamprobe database appears not to be

I use spam probe in a procmail recipe, from their examples in the man page:

:0
    SCORE=| /bin/spamprobe train
    :0 wf
    | formail -I "X-SpamProbe: $SCORE"
    :0 a:
    *^X-SpamProbe: SPAM
    spam

And procmail is hanging on “spamprobe,train”, timing out and failing to deliver the message.

I moved my existing spamprobe database away and created a new one and it all works as expected, but without any of my previous data from the old DB.

So, two questions:

What format does spamprobe use for the db and is it repairable somehow?

Alternatively - I set this up about 750,000 years ago, I can see spamprobe hasn’t been updated in years, is there a better solution to set up spam filtering on fedora? I run my own mail server and I currently use RBLs and spamassassin

Regards,

Scott

[Samuel Sieb]

On 4/30/19 11:30 PM, Scott van Looy via users wrote:
> What format does spamprobe use for the db and is it repairable somehow?

Try running the "file" command on the database file and see what it 
says.  What is the filename?
> Alternatively - I set this up about 750,000 years ago, I can see spamprobe hasn’t been updated in years, is there a better solution to set up spam filtering on fedora? I run my own mail server and I currently use RBLs and spamassassin

I use spamassassin, sqlgrey, and RBLs.

[Scott van Looy]

> On 1. May 2019, at 09:22, Samuel Sieb  wrote:
>
> On 4/30/19 11:30 PM, Scott van Looy via users wrote:
> > What format does spamprobe use for the db and is it repairable somehow?
>
> Try running the "file" command on the database file and see what it says.  What is the filename?

sp_words: Berkeley DB (Btree, version 9, native byte-order)
> > Alternatively - I set this up about 750,000 years ago, I can see spamprobe hasn’t been updated in years, is there a better solution to set up spam filtering on fedora? I run my own mail server and I currently use RBLs and spamassassin
>
> I use spamassassin, sqlgrey, and RBLs.

Cool thanks.
> users mailing list -- [e-mail]
> To unsubscribe send an email to [e-mail]
> Fedora Code of Conduct: https://getfedora.org/code-of-conduct.html
> List Guidelines: https://fedoraproject.org/wiki/Mailing_list_guidelines
> List Archives: https://lists.fedoraproject.org/archives/list/[e-mail]

[Samuel Sieb]

On 5/1/19 1:22 AM, Scott van Looy via users wrote:
> > On 1. May 2019, at 09:22, Samuel Sieb  wrote:
> >
> > On 4/30/19 11:30 PM, Scott van Looy via users wrote:
> > > What format does spamprobe use for the db and is it repairable somehow?
> >
> > Try running the "file" command on the database file and see what it says.  What is the filename?
>
> sp_words: Berkeley DB (Btree, version 9, native byte-order)

Make a copy of the directory and you can try the db_* utilities like 
db_verify and db_recover.

[Scott van Looy]

db_verify sp_words

Lots of lines like:
db_verify: BDB1087 Page 5308: Btree level incorrect: got 0, expected 1
db_verify: BDB0501 Page 5309: btree or recno page is of inappropriate type 0
db_verify: BDB0502 Page 5309: totally zeroed page

Then

db_verify: sp_words: BDB0090 DB_VERIFY_BAD: Database verification failed
BDB5105 Verification of sp_words failed.

db_recover seems to run very quick and at the end I end up with an additional 10mb file called log.0000000001 and I don’t know what to do with it. The original db file remains the same

Running with -v gives me

BDB2526 Finding last valid log LSN: file: 1 offset 28

But I’m pretty confused about how this is meant to work!

Scott

On 1. May 2019, at 20:48, Samuel Sieb  wrote:
> On 5/1/19 1:22 AM, Scott van Looy via users wrote:
> > > On 1. May 2019, at 09:22, Samuel Sieb  wrote:
> > >
> > > On 4/30/19 11:30 PM, Scott van Looy via users wrote:
> > > > What format does spamprobe use for the db and is it repairable somehow?
> > >
> > > Try running the "file" command on the database file and see what it says.  What is the filename?
> >
> > sp_words: Berkeley DB (Btree, version 9, native byte-order)
>
> Make a copy of the directory and you can try the db_* utilities like db_verify and db_recover.
> _______________________________________________
> users mailing list -- [e-mail]
> To unsubscribe send an email to [e-mail]
> Fedora Code of Conduct: https://getfedora.org/code-of-conduct.html
> List Guidelines: https://fedoraproject.org/wiki/Mailing_list_guidelines
> List Archives: https://lists.fedoraproject.org/archives/list/[e-mail]

[Samuel Sieb]

On 5/1/19 9:57 PM, Scott van Looy via users wrote:
> db_verify sp_words
>
> Lots of lines like:
> db_verify: BDB1087 Page 5308: Btree level incorrect: got 0, expected 1
> db_verify: BDB0501 Page 5309: btree or recno page is of inappropriate type 0
> db_verify: BDB0502 Page 5309: totally zeroed page
>
> Then
>
> db_verify: sp_words: BDB0090 DB_VERIFY_BAD: Database verification failed
> BDB5105 Verification of sp_words failed.
>
> db_recover seems to run very quick and at the end I end up with an additional 10mb file called log.0000000001 and I don’t know what to do with it. The original db file remains the same
>
> Running with -v gives me
>
> BDB2526 Finding last valid log LSN: file: 1 offset 28
>
> But I’m pretty confused about how this is meant to work!

It's quite possible that it's not recoverable.  I don't know what else 
to suggest.  I've had lots of trouble with the db in freeipa which is 
the same type.