Beefy Boxes and Bandwidth Generously Provided by pair Networks
Think about Loose Coupling
 
PerlMonks  

email to database via perl?

by Elihu (Novice)
on Jun 29, 2001 at 02:33 UTC ( [id://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/sendmail.cf for details on what program you're using. If this file makes no sense, use QMail.

Log In?
Username:
Password:

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

How do I use this?Last hourOther CB clients
Other Users?
Others taking refuge in the Monastery: (3)
As of 2024-04-25 09:39 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found