<br><br><div class="gmail_quote">2010/6/23 Alex Neuman <span dir="ltr"><<a href="mailto:alex@rtpty.com">alex@rtpty.com</a>></span><br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
Thanks! How could one modify the "select" so that only one record is sent, as a test?<br></blockquote><div><br></div><div>you can try this sentence:</div><div><br></div><div><div>select id,hostname from maillog_table WHERE quarantined='1' limit 1;</div>
<div>+----------------+----------+</div><div>| id | hostname |</div><div>+----------------+----------+</div><div>| o4A1jN4L015623 | server-1 | </div><div>+----------------+----------+</div></div><div><br></div>
<div>this will bring you the first quarantined email in the table.</div><div><br></div><div>some tips:</div><div><br></div><div>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 "<a href="mailto:youremail@yourdomain.com">youremail@yourdomain.com</a>" the quarantined email also if the original destination wasnt that address.</div>
<div><br></div><div>"php /path_to/release_msg.php server-1 80 o4A1jN4L015623 <a href="mailto:youremail@yourdomain.com">youremail@yourdomain.com</a>"</div><div><br></div><div><span class="Apple-style-span" style="font-family: arial, sans-serif; font-size: 13px; border-collapse: collapse; "> after you get this release part working you can edit it in the script and try it with the sql (with limit 1).</span></div>
<div><span class="Apple-style-span" style="font-family: arial, sans-serif; font-size: 13px; border-collapse: collapse; "><br></span></div><div><span class="Apple-style-span" style="font-family: arial, sans-serif; font-size: 13px; border-collapse: collapse; ">the script also adds a random delay bewteen releases so you dont kill your server.</span></div>
<div><br></div><div> </div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
<font color="#888888">--<br>
</font><div class="im"><br>
Alex Neuman<br>
BBM 20EA17C5<br>
+507 6781-9505<br>
<a href="mailto:Skype%3Aalex@rtpty.com">Skype:alex@rtpty.com</a><br>
<br>
</div><div class="im">-----Original Message-----<br>
From: Eduardo Casarero <<a href="mailto:ecasarero@gmail.com">ecasarero@gmail.com</a>><br>
Sender: <a href="mailto:mailscanner-bounces@lists.mailscanner.info">mailscanner-bounces@lists.mailscanner.info</a><br>
Date: Wed, 23 Jun 2010 14:09:38<br>
To: MailScanner discussion<<a href="mailto:mailscanner@lists.mailscanner.info">mailscanner@lists.mailscanner.info</a>><br>
Reply-To: MailScanner discussion <<a href="mailto:mailscanner@lists.mailscanner.info">mailscanner@lists.mailscanner.info</a>><br>
Subject: Re: Mailwatchy kind of question but not really OT<br>
<br>
--<br>
MailScanner mailing list<br>
<a href="mailto:mailscanner@lists.mailscanner.info">mailscanner@lists.mailscanner.info</a><br>
<a href="http://lists.mailscanner.info/mailman/listinfo/mailscanner" target="_blank">http://lists.mailscanner.info/mailman/listinfo/mailscanner</a><br>
<br>
Before posting, read <a href="http://wiki.mailscanner.info/posting" target="_blank">http://wiki.mailscanner.info/posting</a><br>
<br>
Support MailScanner development - buy the book off the website!<br>
<br>
<br>
</div>--<br>
<div><div></div><div class="h5">MailScanner mailing list<br>
<a href="mailto:mailscanner@lists.mailscanner.info">mailscanner@lists.mailscanner.info</a><br>
<a href="http://lists.mailscanner.info/mailman/listinfo/mailscanner" target="_blank">http://lists.mailscanner.info/mailman/listinfo/mailscanner</a><br>
<br>
Before posting, read <a href="http://wiki.mailscanner.info/posting" target="_blank">http://wiki.mailscanner.info/posting</a><br>
<br>
Support MailScanner development - buy the book off the website!<br>
</div></div></blockquote></div><br>