email to database via perl?

[Elihu]

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.

[tadman]

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.