Re: [Dbmail] spam learning....

2006-11-28 Thread Paul J Stevens
Tom Allison wrote: > I think I started on the wrong foot. > > I set up a system user for the ownership of bogofilter's wordlist.db. > Unfortunately, I can't actually run anything as that user... > > So, I can either set the /etc/passwd shell from /bin/false to > /bin/(something) > or change the

Re: [Dbmail] spam learning....

2006-11-28 Thread Tom Allison
Paul J Stevens wrote: Tom Allison wrote: Paul J Stevens wrote: If you only want to read the Public/Spam box, why do you want to read the box through SQL? Use fetchmail I'd say. I don't have pop configured and I am not sure about the next question: who do you authenticate as in order to acces

Re: [Dbmail] spam learning....

2006-11-27 Thread Tom Allison
Geir Voll Nielsen wrote: Remember that the bayes database needs to be trained with at least 200 SPAM's AND 200 HAM's before it can score new messages. To get the most out of bayes you would also like to train it with HAM's on a regulary basis. What is your approach for feeding HAM's into bayes

Re: [Dbmail] spam learning....

2006-11-27 Thread Geir Voll Nielsen
Tom Allison wrote: > Paul J Stevens wrote: >> Tom Allison wrote: >>> How do you get all the physical message blocks in order? >>> (of course, for bogofilter, this doesn't really matter.) >>> >>> >>> >>> select phymsg.id, messageblk >>> from >>> dbmail_users u, >>> dbmail_mailboxes mb, >>> dbmail_m

Re: [Dbmail] spam learning....

2006-11-26 Thread Paul J Stevens
Tom Allison wrote: > Paul J Stevens wrote: >> >> If you only want to read the Public/Spam box, why do you want to read >> the box through SQL? Use fetchmail I'd say. >> >> > > I don't have pop configured and I am not sure about the next question: > who do you authenticate as in order to access PU

Re: [Dbmail] spam learning....

2006-11-26 Thread Aaron Stone
On Sun, 2006-11-26 at 15:36 -0500, Tom Allison wrote: > I don't have pop configured It's not so hard. I'd recommend dbmail.conf settings like this: [POP] PORT=110 BINDIP=127.0.0.1 NCHILDREN=1 MAXCHILDREN=3 MINSPARECHILDREN=1 MAXSPARECHILDREN=2 This will limit dbmail-pop3d to running only 1-3 pr

Re: [Dbmail] spam learning....

2006-11-26 Thread Tom Allison
Paul J Stevens wrote: Tom Allison wrote: How do you get all the physical message blocks in order? (of course, for bogofilter, this doesn't really matter.) select phymsg.id, messageblk from dbmail_users u, dbmail_mailboxes mb, dbmail_messages msg, dbmail_physmessage phymsg, dbmail_messageblks

Re: [Dbmail] spam learning....

2006-11-26 Thread Paul J Stevens
Tom Allison wrote: > How do you get all the physical message blocks in order? > (of course, for bogofilter, this doesn't really matter.) > > > > select phymsg.id, messageblk > from > dbmail_users u, > dbmail_mailboxes mb, > dbmail_messages msg, > dbmail_physmessage phymsg, > dbmail_messageblks b

[Dbmail] spam learning....

2006-11-26 Thread Tom Allison
I'm trying to put together public folders for all the SPAM/HAM(good email) to be dumped into for bayes learning. Seems to me that it would be MUCH easier if I could pull out all the messages via SQL than IMAP. I got this far... I'm not sure how to reconstruct the entire email message into a