Script To Execute command via mail

[Greg Larkin]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Marcel Grandemange wrote:
> Yes the Server I want to do this on Is a FreeBSD 7.0 box, however cannot use
> procmail as all mboxes are virtual.
> Ie not real accounts all exist only on mysql, and since I changed from a
> normall stock setup to using mysql procmail no longer will work.
> All boxes are in form of user at domain.com
> 
> 
> I really miss procmail!
> 
> -----Original Message-----
> From: owner-freebsd-questions at freebsd.org
> [mailto:owner-freebsd-questions at freebsd.org] On Behalf Of Greg Larkin
> Sent: Friday, August 29, 2008 3:03 PM
> To: Marcel Grandemange
> Cc: freebsd-questions at freebsd.org
> Subject: Re: Script To Execute command via mail
> 
> Marcel Grandemange wrote:
>> I have an interesting situation.
> 
>> I have a windows based sms server, this machine works in the following
> way.
>> It watches a shared directory for txt files that must be formatted in
>> certain way and periodically sends them off to mobile.
> 
>> What I want to do is create a SMTP to SMS gateway.
> 
>> Easy in theory!
> 
>> Rite a script to map shared drive, ensure it's connected and write the txt
>> files in dir.
> 
>> However the second part I have no idea, somehow I need to watch the mbox
>> file of say a e-mail account called "test"
> 
>> And IF a mail arrives parse it look for a security key if exists convert
> to
>> txt file and copy to shared dir.
> 
> 
> Hi Marcel,
> 
> Do you have a FreeBSD machine in the mix somewhere?  If so, this sounds
>  like a job for procmail: http://en.wikipedia.org/wiki/Procmail
> 
> Using procmail, you can create a script to process incoming emails and
> process/reformat them as you see fit.
> 
> Best regards,
> Greg

Hi Marcel,

What mail server are you using with MySQL?  I use a tool called vexim
(http://www.freshports.org/mail/vexim/) that integrates Exim with MySQL
and also supports virtual mailboxes.  However, I can use procmail with
any of the mailboxes, too.

If you post more details about your setup, someone here might be able to
figure out a solution so you can use procmail.

Best regards,
Greg
- --
Greg Larkin

http://www.FreeBSD.org/       - The Power To Serve
http://www.sourcehosting.net/ - Ready. Set. Code.
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.7 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFIt/XT0sRouByUApARAnCaAJwJMdYxFe8RHlegKkf2KTcgSdUNNwCfbqGZ
Swzyy+ALyLwdTFqDDOE4NAQ=
=qT8u
-----END PGP SIGNATURE-----