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.
