On 04/23/2014 12:53 PM, Reindl Harald wrote: > Am 23.04.2014 18:34, schrieb furface: >> This seems like a rather harsh suggestion. I've been using Dovecot Maildirs >> for years and frequently examine the >> contents of Maildirs, and in rare instances manipulate the contents. One of >> the reason's I'm trying DBMail is >> because sql provides a more robust data interface than file systems. It >> would be disappointing to find out that it >> is more problematic than using Maildirs. > it's possible but unsupported and will take a lot of work > > manipulate the contents? > don't do that - never - in no setup you break signed messages > > don't do that in case of dbmail because if three people have the > same textfile attachment each in 5 messages you manipulate at the > same time that mime-part for all of them > > frankly forgot the idea to re-constrcut dbmail-messages with > selfmade scripts - i (as user) have spent a lot of hours to > debug message-reconstruction for complex messages with a lot > of mime-parts and nested attachments with the lead developer > and i can tell you for sure re-invent the wheel and do that > outside of dbmail leads straight to hell > > sure, it is do-able but it is pretty dumb > use imap-libraries and fetch the recostructed message with them > that is a standarized protocol, the low-level storage of a > de-duplicating mailserver is usually not your businesss > >> In fact standard mail delivery infrastructure is designed to have multiple >> apps query and manipulate data stores. >> For instance IMAP and LMTP. >> >>>> using Mysql querries, can an administrator search, query and manipulate >>>> the records? >>> don't do that - the db-scheme may change and low-level tables >>> are no public interface, you can in theory but you have two >>> problems: >>> >>> * complexity / error-prone / safety (if you make mistakes you leak infos) >>> * not a stable interface >>> >>> in dbmail 2.x there was no de-duplication, all tools like my admin-backends >>> only working with the high-level tables are working unchanged, anything >>> touching message-bodies directly would needed to be rewritten > > > _______________________________________________ > DBmail mailing list > [email protected] > http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
Point well taken and understandable. What about this: since all the messages inbound will 1) be from a unique user and, 2) be a unique message (no possibility of duplication whatsoever) can I duplicate the messages into a separate table/db for manipulation thereby leaving the original intact? If dbmail isn't a candidate for this, are there any systems that would 1) allow me to extract email, subject, body into separate database/table/fields for analysis and manipulation? I'm somewhat familiar with Exim although I find the references to routers, etc. very confusing and scary, quiet frankly.
_______________________________________________ DBmail mailing list [email protected] http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
