I believe this is close to what I am needing. Thank you for your time and detail.
My thank you to everyone else for their comments. Thanks, Jeff On Thu, 2003-02-27 at 12:13, Vikash K Agarwal wrote: > We have used procmail and PHP combination to achieve this for our > department mail management and associated workflow. > > Sendmail invokes procmail which delivers the mail to the normal inbox > and invokes a PHP script thru LYNX > > The PHP script opens an IMAP connection to the inbox, reads the mail and > puts in a text data col in the database. > > This is working successfully for all our 5 departments and over 500-1000 > mails a day. Except for big attachments where we have respective > limitations (to some extent configurable - maxpacketsize options etc) > in PHP as well as MYSQL. > > vikash > > > -----Original Message----- > From: William R. Mussatto [mailto:[EMAIL PROTECTED] > Sent: Thursday, February 27, 2003 12:47 AM > To: [EMAIL PROTECTED] > Cc: [EMAIL PROTECTED] > Subject: Re: Using MySQL to store email > > First, which MYSQL, the program or the company. > Assuming you mean a mysql database I think you will need to run it > through > a program which will parse it and load it into the database tables. > > > Does anyone know where I can read more on how to redirect incoming > email > > (via Sendmail) into MySQL for a given email address? > > I understand that I can use "<[EMAIL PROTECTED]> | /path/mysql ..." in the > > /etc/aliases file to do this, but I would like to see if anyone has > had > > success with this. I also would like to know if this is not as simple > > as I may think. > > > > Thanks for any thoughts on this, > > Jeff > > > > > > > > > > > > > > William R. Mussatto, Senior Systems Engineer > Ph. 909-920-9154 ext. 27 > FAX. 909-608-7061 > > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php