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]"


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]"


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:
> 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 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]"


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]"