The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Store e-mails in database

Discussion in 'E-mail Discussions' started by EchoHost, Jun 12, 2006.

  1. EchoHost

    EchoHost Well-Known Member

    Joined:
    Jul 27, 2003
    Messages:
    52
    Likes Received:
    0
    Trophy Points:
    6
    Is there a way to store all outgoing and incoming e-mails into a mysql database?
     
  2. ramprage

    ramprage Well-Known Member

    Joined:
    Jul 21, 2002
    Messages:
    667
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Canada
    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
     
  3. EchoHost

    EchoHost Well-Known Member

    Joined:
    Jul 27, 2003
    Messages:
    52
    Likes Received:
    0
    Trophy Points:
    6
    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.
     
  4. richy

    richy Well-Known Member

    Joined:
    Jun 30, 2003
    Messages:
    276
    Likes Received:
    1
    Trophy Points:
    16
    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.
     
Loading...

Share This Page