Date: Fri, 29 Aug 2008 09:12:51 -0400 From: Greg Larkin <glarkin@FreeBSD.org> To: Marcel Grandemange <thavinci@thavinci.za.net> Cc: freebsd-questions@freebsd.org Subject: Re: Script To Execute command via mail Message-ID: <48B7F5D3.7070901@FreeBSD.org> In-Reply-To: <029d01c909d8$272dd1f0$758975d0$@za.net> References: <029801c909d6$67d76330$37862990$@za.net> <48B7F387.4060602@FreeBSD.org> <029d01c909d8$272dd1f0$758975d0$@za.net>
next in thread | previous in thread | raw e-mail | index | archive | help
-----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@domain.com > > > I really miss procmail! > > -----Original Message----- > From: owner-freebsd-questions@freebsd.org > [mailto:owner-freebsd-questions@freebsd.org] On Behalf Of Greg Larkin > Sent: Friday, August 29, 2008 3:03 PM > To: Marcel Grandemange > Cc: freebsd-questions@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-----
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?48B7F5D3.7070901>