Beefy Boxes and Bandwidth Generously Provided by pair Networks
more useful options

email to database via perl?

by Elihu (Novice)
on Jun 29, 2001 at 02:33 UTC ( #92486=perlquestion: print w/replies, xml ) Need Help??

Elihu has asked for the wisdom of the Perl Monks concerning the following question:

I'd like to set up a specific email address that intercepts an email (maybe a procmail setup?) and send it to a perl script. The perl script would then parse the file and insert relevant fields into a database. My biggest question is the email -> procmail -> perl script part. Anyone have examples or tips on how one can set this up? Thanks.

Replies are listed 'Best First'.
Re: email to database via perl?
by tadman (Prior) on Jun 29, 2001 at 12:33 UTC
    If you use something like QMail, this is pretty easy since you can insert programs into the processing stream that could, in fact, be written in Perl. There is a wide variety of locations where you can hook in to the mail stream, and each provides different information.

    As a cheap hack, you could just make something that smells like the 'rmail' program used by your mailer, assuming you're using something like the archaic 'Sendmail'. Your rmail program could, instead of delivering the message, put it into the database. Have a look in /etc/ for details on what program you're using. If this file makes no sense, use QMail.

Log In?

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: perlquestion [id://92486]
Approved by root
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others meditating upon the Monastery: (5)
As of 2022-01-17 11:36 GMT
Find Nodes?
    Voting Booth?
    In 2022, my preferred method to securely store passwords is:

    Results (51 votes). Check out past polls.