<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
Hello, again!<br>
<br>
I've been digging a litle more and:<br>
<br>
on /usr/sbin/amavisd<br>
<br>
$sql_select_white_black_list =<br>
'SELECT wb FROM wblist JOIN mailaddr ON wblist.sid=mailaddr.id'.<br>
' WHERE wblist.rid=? AND mailaddr.email IN (%k)'.<br>
' ORDER BY mailaddr.priority DESC';<br>
<br>
In only uses mailaddr.priority for sorting, so I think there
wblist.wb is not expecting a numeric value...<br>
<br>
Anyway I kind of answered my question :)<br>
I think adding a priority field on the wblists and altereing the
"sql_select_white_black_list" expression will solve my predicament
:)<br>
<br>
Thanks!<br>
<br>
<br>
On 12/16/2011 02:17 AM, Michael Scheidell wrote:
<blockquote cite="mid:4EEAAA49.3010506@secnap.com" type="cite">
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
On 12/15/11 10:36 AM, Miguel Fernandes wrote:
<blockquote cite="mid:4EEA13F0.6000204@eurotux.com" type="cite">Hello!
<br>
<br>
I need to have some sort of priority in black/white lists, but
currently this field is in the mailaddr table..., <br>
so I can't have different priorities per recipient right? <br>
<br>
I'm thinking on creating a priority field in the table wblist,
to have a priority per wblist entry, mainly to prioritize white
lists. <br>
</blockquote>
actually, the entry in the wb field doesn't need to be a 'w' or a
'b' (if I remember correctly)<br>
you can set it as a -100 for whitelist, and, say, +50 in b.<br>
<blockquote cite="mid:4EEA13F0.6000204@eurotux.com" type="cite"> <br>
Can this this be achieved by some other way? <br>
How does a domain w/b list affect that domain's recipients? How
can we know the priority order in the case we have both domain
w/b lists and recipient's w/b lists? <br>
<br>
Thanks! <br>
<br>
</blockquote>
<br>
<br>
<div class="moz-signature">-- <br>
Michael Scheidell, CTO<br>
o: 561-999-5000<br>
d: 561-948-2259<br>
<font color="#999999">></font><font color="#cc0000"> <b>| </b></font>SECNAP
Network Security Corporation
<style type="text/css">
<!--
.unnamed1 {
margin: 1em;
padding: 1px;
} -->
</style>
<ul class="unnamed1">
<li>Best Mobile Solutions Product of 2011</li>
<li>Best Intrusion Prevention Product</li>
<li>Hot Company Finalist 2011</li>
<li>Best Email Security Product</li>
<li>Certified SNORT Integrator</li>
</ul>
</div>
<br>
<div id="disclaimer.secnap.com">
<hr>This email has been scanned and certified safe by
SpammerTrap®.</div>
<div>For Information please see
<a moz-do-not-send="true" href="http://www.spammertrap.com/">http://www.spammertrap.com/</a>
<hr></div>
<br>
</blockquote>
<br>
<br>
<pre class="moz-signature" cols="72">--
Cumprimentos,
Miguel Fernandes
</pre>
</body>
</html>