Re: [Exim] email content storing in database

Top Page
Delete this message
Reply to this message
Author: Steve Haslam
Date:  
To: S. Ancelot
CC: exim-users
Subject: Re: [Exim] email content storing in database
On Fri, Sep 06, 2002 at 03:08:11PM +0200, S. Ancelot wrote:
> Hi,
> I have got an email account that receives informations from a web site
> thanks to post web form .
>
> incoming data are formatted in the email : name address ..., I would
> like to store all these informations into
> a database when exim get messages, how to do that ?
> Bye
> Stephane ANCELOT


what you can do is get Exim to send the content of the email to a Perl
script or sth, which can then write the data into the database.

It's hard to tell how much of this you've already done. But here's some help
on the Exim bit.

Assuming you have a dedicated email address for all these things (e.g. all
the email goes to "feedback" on your machine), you can add a line to
/etc/aliases like this:

feedback: | /usr/local/bin/write_feedback_to_database

to run the write_feedback_to_database script on the incoming email. You may
have to adjust your "address_pipe" transport to set a user for this comment
to run as. In the default config file there's a "user = list" line that is
commented out (with a note about "Uncomment if you are using smartlist").
Uncomment thist line, making sure that the user is set to a user that does
really exist (e.g. create a user called "list", or set "user = nobody").

HTH

SRH
--
Steve Haslam      Reading, UK                           araqnid@???
Debian GNU/Linux Maintainer                               araqnid@???
                               maybe the human race deserves to be wiped out