Hum, this trigger idea seems better and less time of coding!
From: [email protected] [mailto:[email protected]] On Behalf Of Jake Anderson Sent: sexta-feira, 19 de Junho de 2009 14:07 To: DBMAIL Developers Mailinglist Subject: Re: [Dbmail-dev] New idea 2, log received messages by lmtpd Jorge Bastos wrote: 1-So for now I'm going to see a way to get this info from postfix, whether grep the logs or something else. 2-the views are important, 'cause if the message was received by postfix and not by dbmail, something eat it! After wake up this morning I was thinking, the view's won't work, 'cause if I want to see an email from one month ago, and the user uses POP3, that email won't exist anymore on the database. Apart from the postfix log, for my case, email will only be eat by clamd is it has virus. That's why I think the best way is to make dbmail-lmtpd log this. What do you say? _______________________________________________ Dbmail-dev mailing list [email protected] http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail-dev Rather than the view, perhaps create another table in the same format then use a trigger that fires when a new mail is inserted to SELECT foo INTO that table for posterity. I can see benefit to that and its an optional extra that people can turn on at will and with some tweaking can be made specific down to the individual user level. If all the info is in the database then a "stats" application is going to be easy to hack up and if you were really keen you could have a "top" style application grouping by domains etc showing bandwidth per minute etc.
_______________________________________________ Dbmail-dev mailing list [email protected] http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail-dev
