[AMaViS-user] per recepient rule sql lookup requesting a list of ?

Hi amavisd-users,

im having trouble using the per recepient spam-assassin rules. i
turned on debugging mode, and the %k spaceholder is replcaed by a list
of '?'.

similar things for wblist lookups. how is %k filled, i read sth about
user+foo@example.com, but i cant see where the strings foo, example
and so on come from.

there is another question i have:
as well the emailvalue in my database might be only a email alias, must i setup a table to map emailadresses to alias? how else can amavis find the right user for a specific email?


joerg
here is a part of my mail.log file, every help is welcome:
Jun 9 19:45:14 shove-it amavis[23275]: (23275-01) SQL prepare: SELECT *,users.id FROM users,policy WHERE (users.policy_id=policy.id) AND (users.email IN (?)) ORDER BY users.priority DESC
Jun 9 19:45:14 shove-it amavis[23275]: (23275-01) SQL prepare: SELECT *,users.id FROM users,policy WHERE (users.policy_id=policy.id) AND (users.email IN (?,?)) ORDER BY users.priority DESC
Jun 9 19:45:14 shove-it amavis[23275]: (23275-01) SQL prepare: SELECT *,users.id FROM users,policy WHERE (users.policy_id=policy.id) AND (users.email IN (?,?,?)) ORDER BY users.priority DESC
Jun 9 19:45:14 shove-it amavis[23275]: (23275-01) SQL prepare: SELECT *,users.id FROM users,policy WHERE (users.policy_id=policy.id) AND (users.email IN (?,?,?,?)) ORDER BY users.priority DESC
Jun 9 19:45:14 shove-it amavis[23275]: (23275-01) SQL prepare: SELECT *,users.id FROM users,policy WHERE (users.policy_id=policy.id) AND (users.email IN (?,?,?,?,?)) ORDER BY users.priority DESC
Jun 9 19:45:14 shove-it amavis[23275]: (23275-01) SQL prepare: SELECT *,users.id FROM users,policy WHERE (users.policy_id=policy.id) AND (users.email IN (?,?,?,?,?,?)) ORDER BY users.priority DESC


-------------------------------------------------------
SF.Net email is sponsored by: Discover Easy Linux Migration Strategies
from IBM. Find simple to follow Roadmaps, straightforward articles,
informative Webcasts and more! Get everything you need to get up to
speed, fast. http://ads.osdn.com/?ad_id=7477&alloc_id=16492&op=click
_______________________________________________
AMaViS-user mailing list
AMaViS-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/...fo/amavis-user
AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3
AMaViS-HowTos:http://www.amavis.org/howto/