On 10/4/07, Ray wrote: > > I think I understand a little more about what is going on. The system is set > up so that you create one table, that is specific to amavis-new. It then > performs it's own lookup on that table with it's own, built in, select > statement. (details in documentation) > Am I right so far?
Yes, except it's not just one table. There are a number of tables in the schema. There are actually two sets of tables. One which contains recipient settings and whitelist/blacklist data, and the other which records information about messages and provides for optional SQL quarantine. > I am running postfix and dovecot with MySQL tables that provide all > information. I would like to let amavis go look at those tables to find out > what domains are to be considered local (this is in "amavisd.conf-sample", > right) Right > and possibly in the future find custom spam cutoff levels, white/black > lists, etc. At that point you would have to reset your $sql_select_policy (probably back to the default) and @lookup_sql_dsn. > I guess that I could create the database structure that amavis expects, and > repopulate it every 1/2 hour or so from the postfix/dovecot tables, but I > would prefer not to. > Any other suggestions? > Thanks, > Ray How often are new domains added, or old domains deleted? If all you want for the time being is set set up the local domains, I would set up the amavis schema, create a policy with all the fields NULL (except for id and policy name) and then add all the domains (@example.com, @example.net etc.) to the users table and assign them that policy. I would not add the optional local field to the users table. This way, all I need to do is maintain the list of domains. The fact that they exist makes them local. In the future, you could create additional policies and add users as you see fit. -- Gary V ------------------------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ _______________________________________________ AMaViS-user mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/amavis-user AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3 AMaViS-HowTos:http://www.amavis.org/howto/
