Re: Script To Execute command via mail

2008-09-02 Thread 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 [EMAIL PROTECTED]


I really miss procmail!

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] 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

-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@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to [EMAIL PROTECTED]

__ NOD32 3396 (20080828) Information __

This message was checked by NOD32 antivirus system.
http://www.eset.com


___
freebsd-questions@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to [EMAIL PROTECTED]
  
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 


___
freebsd-questions@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to [EMAIL PROTECTED]


Script To Execute command via mail

2008-08-29 Thread Marcel Grandemange
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.

 

SMS sent..

 

 

Any suggestions?

___
freebsd-questions@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to [EMAIL PROTECTED]


Re: Script To Execute command via mail

2008-08-29 Thread Matthias Apitz
El día Friday, August 29, 2008 a las 02:54:42PM +0200, Marcel Grandemange 
escribió:

 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.

procmail (which is in the ports) will let you do that very easy;

matthias
-- 
Matthias Apitz
Manager Technical Support - OCLC GmbH
Gruenwalder Weg 28g - 82041 Oberhaching - Germany
t +49-89-61308 351 - f +49-89-61308 399 - m +49-170-4527211
e [EMAIL PROTECTED] - w http://www.oclc.org/ http://www.UnixArea.de/
b http://gurucubano.blogspot.com/
We should all learn from the peoples of The Netherlands, France and Ireland.
Aprendamos todos de los pueblos de Holanda, Francia e Irlanda.
___
freebsd-questions@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to [EMAIL PROTECTED]


Re: Script To Execute command via mail

2008-08-29 Thread Greg Larkin
-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@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to [EMAIL PROTECTED]


RE: Script To Execute command via mail

2008-08-29 Thread Marcel Grandemange
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 [EMAIL PROTECTED]


I really miss procmail!

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] 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

-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@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to [EMAIL PROTECTED]

__ NOD32 3396 (20080828) Information __

This message was checked by NOD32 antivirus system.
http://www.eset.com


___
freebsd-questions@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to [EMAIL PROTECTED]


Re: Script To Execute command via mail

2008-08-29 Thread 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 [EMAIL PROTECTED]
 
 
 I really miss procmail!
 
 -Original Message-
 From: [EMAIL PROTECTED]
 [mailto:[EMAIL PROTECTED] 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-

___
freebsd-questions@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to [EMAIL PROTECTED]