Mark Irvine wrote:
Hi,
Could anyone give me some ideas on how I might send my mail to a mysql (or
any sql) database. I get mail from a few mailing lists, and I never read
it untill I run into problems. But I can't search the body of these
messages, so I'd like to store them in a good database.
Ideally I'd like to extract some headers to store in table colums, and
store the body seperatly. I'm not asking for someone to write the reciepes
for me, I've read the procmail and procmailex man pages, but I'm quite new
to procmail/unix so any Ideas appreciated.
i am doing something similar to this, i handle web server logs with a
runlevel script
in perl that listens on a fifo and updates an sql server with those log
entries.
what you need for this is to create a fifo ( man fifo ) and then write a
perl script
or anything that suits you and can handle fifos and is your connector to
the mysql database.
you simply redirect your mail into that fifo and let the perl script do
the sql stuff.
greetings
Christoph
---------------------------------------
Christoph Schaper
email :christoph(_at_)schaper(_dot_)org
homepage http://schaper.org/christoph
http://schaper-edv.de
---------------------------------------
_______________________________________________
procmail mailing list
procmail(_at_)lists(_dot_)RWTH-Aachen(_dot_)DE
http://MailMan.RWTH-Aachen.DE/mailman/listinfo/procmail