EchoHost

Well-Known Member
Jul 27, 2003
52
0
156
Is there a way to store all outgoing and incoming e-mails into a mysql database?
 

EchoHost

Well-Known Member
Jul 27, 2003
52
0
156
ramprage said:
Yes, this can be done however I'm not sure why you'd want to do this. It would put a lot of high load on the server
It's only for my own personal website. I want to keep track of what e-mails the automatic newsletter and subscription notices send to. how many are yahoo, etc..

It would only be maybe 1,000 e-mails a day max so it shouldnt put that big of a server load on considering the server already puts up with 400 queries per second.

Would you happen to know the link to how to do this? I tried search multiple times but no luck.
 

richy

Well-Known Member
Jun 30, 2003
276
1
168
Are you looking at storing the full emails (including the body of the message) or just the To/From/Header details? If it's the latter, you may want to look at MailScanner from http://www.configserver.com - the way Chirpy et al set it it, is MailScanner logs all emails to MailWatch which runs of a MySQL database. Data stored includes the to address, from address, time/date and the headers of the message. It doesn't store the body of the email though.