Mailwatchy kind of question but not really OT

[Eduardo Casarero]

2010/6/23 Alex Neuman <alex at rtpty.com>

> Thanks! How could one modify the "select" so that only one record is sent,
> as a test?
>

you can try this sentence:

select id,hostname from maillog_table WHERE quarantined='1' limit 1;
+----------------+----------+
| id             | hostname |
+----------------+----------+
| o4A1jN4L015623 | server-1  |
+----------------+----------+

this will bring you the first quarantined email in the table.

some tips:

locate the file "release_msg.php" in your system and first try this:
(server-1 must be findable in /etc/hosts) this command will send to "
youremail at yourdomain.com" the quarantined email also if the original
destination wasnt that address.

"php /path_to/release_msg.php server-1 80 o4A1jN4L015623
youremail at yourdomain.com"

 after you get this release part working you can edit it in the script and
try it with the sql (with limit 1).

the script also adds a random delay bewteen releases so you dont kill your
server.



> --
>
> Alex Neuman
> BBM 20EA17C5
> +507 6781-9505
> Skype:alex at rtpty.com <Skype%3Aalex at rtpty.com>
>
> -----Original Message-----
> From: Eduardo Casarero <ecasarero at gmail.com>
> Sender: mailscanner-bounces at lists.mailscanner.info
> Date: Wed, 23 Jun 2010 14:09:38
> To: MailScanner discussion<mailscanner at lists.mailscanner.info>
> Reply-To: MailScanner discussion <mailscanner at lists.mailscanner.info>
> Subject: Re: Mailwatchy kind of question but not really OT
>
> --
> MailScanner mailing list
> mailscanner at lists.mailscanner.info
> http://lists.mailscanner.info/mailman/listinfo/mailscanner
>
> Before posting, read http://wiki.mailscanner.info/posting
>
> Support MailScanner development - buy the book off the website!
>
>
> --
> MailScanner mailing list
> mailscanner at lists.mailscanner.info
> http://lists.mailscanner.info/mailman/listinfo/mailscanner
>
> Before posting, read http://wiki.mailscanner.info/posting
>
> Support MailScanner development - buy the book off the website!
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.mailscanner.info/pipermail/mailscanner/attachments/20100623/61ad1396/attachment.html