Shell script to go out and leech image from email?

Shell script to go out and leech image from email?

Posted by: mfarley
Posted on: 2007-02-19 11:48:00

We upload all our photos to a MySQL database hosted on Dreamhost through a web front-end.

My wife has a new camera phone that can automatically email the taken photo to a specified email address.

Here's what I want to do:

Write a shell script that will periodically (cron) run on my dreamhost account (debian/linux) to check the specified email address for new messages/photos, strip out the attached image, and send it off to the MySQL database.

I can use the same PHP script that the web front-end uses to actually load the binary into the mysql table, but I need help with the shell script.

Can anyone point me in the right direction as to command-line tools that might aid in this process? I don't want to reinvent the wheel -- I've been looking at "fetchmail"

Thanks..

Tags: shell scriptdebian linuxcommand line toolsdreamhostmysql databaseemailmysql tablefetchmailphp scriptleechright directionphotoscronperiodically