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_messages msg, >>> dbmail_physmessage phymsg, >>> dbmail_messageblks blks >>> where >>> u.user_idnr = mb.owner_idnr >>> and u.userid = '__public__' >>> and mb.name = 'SPAM' >>> and mb.mailbox_idnr = msg.mailbox_idnr >>> and msg.deleted_flag = 0 >>> and msg.physmessage_id = phymsg.id >>> and phymsg.id = blks.physmessage_id >>> order by phymsg.id >>> ; >> >> 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 PUBLIC folders? I'll > assume this depends on who has rights (ACL) to the folder. > _______________________________________________ > DBmail mailing list > [email protected] > https://mailman.fastxs.nl/mailman/listinfo/dbmail
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? I suppose you are not creating public folders for HAM...!? -- Med Hilsen/Best regards Geir Voll Nielsen
