Script To Execute command via mail

[Chris St Denis]

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
>
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> 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
> - --
> 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/OH0sRouByUApARAntMAJ43+cuEDrdEIZle4TTxa3orO+u05QCdHsOq
> c1yjtkE0i7CN4dM04WgcfrM=
> =0pjX
> -----END PGP SIGNATURE-----
>
> _______________________________________________
> freebsd-questions at freebsd.org mailing list
> http://lists.freebsd.org/mailman/listinfo/freebsd-questions
> To unsubscribe, send any mail to "freebsd-questions-unsubscribe at freebsd.org"
>
> __________ NOD32 3396 (20080828) Information __________
>
> This message was checked by NOD32 antivirus system.
> http://www.eset.com
>
>
> _______________________________________________
> freebsd-questions at freebsd.org mailing list
> http://lists.freebsd.org/mailman/listinfo/freebsd-questions
> To unsubscribe, send any mail to "freebsd-questions-unsubscribe at freebsd.org"
>   
Courier maildrop should do what you need. it's in ports/mail/maildrop. 
It can have a mysql backend if you compile it WITH_AUTHLIB=yes

-- 
Chris St Denis
Programmer
SmarttNet (www.smartt.com)
Ph: 604-473-9700 Ext. 200
-------------------------------------------
"Smart Internet Solutions For Businesses"