Hi, i am trying to build a system that can catch-up all mail and archive them into a sql database for let me search easily and powerly in future (web interface, app, direct SQL query). I am evaluating if the system shoud also strip attachment (for example all or just *ffice,pdf,ps,*img,*compressed) and save them to a separate space. I think that this should keep the database to a reasonability size (only pure-text) and let me search better, but the db should then contain a "pointer" (link, path, other?) to the new file location. It this possible with dbmail? Is some modification necessary?
For this moment I am testing this with a stable Debian Woody and qmail with qmailqueue patch that cath all mail traffic and using dbmail-smtp as injector into the db of the mails but the attachment isn't stripped... i could strip the attach before the inject but: 1. this is independent from dbmail 2. the pointer of the stripped attach isn't place in db (maybe in mail body) any suggestion welcome! giorgio70165 --------------------------------------------------------- Stanco dello spam nella tua email? Prova GRATIS il nuovo servizio ANTISPAM di superEva: http://webmail.supereva.it/spam.html ---------------------------------------------------------
