Hi, Thank u in advance I am trying to set policy bank setting for recipients. But not able to retrive values from table policy.
changes made in amavisd.conf $inet_socket_bind = '127.0.0.1'; $sa_tag2_level_deflt = 3.0; $policy_bank{'AM.PDP-INET'} = { protocol => 'AM.PDP', # Amavis policy delegation protocol inet_acl => [qw( 127.0.0.1 [::1])] # restrict to these IP addresses }; $interface_policy{'9998'} = 'AM.PDP-INET'; $sql_select_policy = 'SELECT *,users.id FROM users,policy'. ' WHERE (users.policyid=policy.id) AND (users.email IN (%k))'; As i am just checking this for $sa_tag2_level_deflt for one user m...@example.com entries lin policy looks like this. *Table policy* +------+-----------------------+------------------------------- | id | spam_tag2_level | spam_quarantine_to | +------+------------------------+------------------------------+ | 1 | 9 | spam_quarantine | +------+------------------------+-------------------------------+ *Table users * +----+----------+------------------------------ | id | policyid | email | +----+----------+------------------------------+ | 8 | 1 | m...@example.com | +----+----------+----------------------------+ Whenever mail is sent to m...@example.com subject must be tagged with *******spam******** only if spam score is above 9. But that is not happening. Its taking default value($sa_tag2_level_deflt = 3.0;) only. How to solve this problem. Waiting........ -with regards Manthra ------------------------------------------------------------------------------ Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july _______________________________________________ AMaViS-user mailing list AMaViS-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/amavis-user AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3 AMaViS-HowTos:http://www.amavis.org/howto/