On Dienstag, 19. Juni 2007 Paul J Stevens wrote: > > BTW, Is it OK to have more physmessages than messages? > > No. It's a known bug there are some checks missing from the > maintenance code.
OK, should I select * from dbmail_physmessage p left join dbmail_messages m on (p.id=m.physmessage_id) where m.message_idnr IS NULL; to find out phymessages that have no message id? Then I could delete them using delete from dbmail_physmessage p left join dbmail_messages m on (p.id=m.physmessage_id) where m.message_idnr IS NULL; Is this correct? > > And a > > select length(headervalue) from dbmail_headervalue order by > > length(headervalue) desc; shows there are a lot of longer entries: > > > > length > > -------- > > 14890 > > [snip] > > That's totally absurd. I seriously doubt headervalues that long are > valid. They may even indicate problems with the mime-parser. That one has the content of a lot of CC:, which is obviously SPAM, but could be legit, as CC: is not limited. Seems like the spammer configured something wrong, as the text looks like: [EMAIL PROTECTED], [EMAIL PROTECTED], [EMAIL PROTECTED], [EMAIL PROTECTED] So the whole text is word-by-word extended with @domain... *g* mfg zmi -- // Michael Monnerie, Ing.BSc ----- http://it-management.at // Tel: 0676/846 914 666 .network.your.ideas. // PGP Key: "curl -s http://zmi.at/zmi.asc | gpg --import" // Fingerprint: EA39 8918 EDFF 0A68 ACFB 11B7 BA2D 060F 1C6F E6B0 // Keyserver: www.keyserver.net Key-ID: 1C6FE6B0
signature.asc
Description: This is a digitally signed message part.
_______________________________________________ DBmail mailing list [email protected] https://mailman.fastxs.nl/mailman/listinfo/dbmail
