Andrea Cappelli wrote on 18.09.09:
> Il giorno mar, 15/09/2009 alle 00.30 +0200, Daniel Luttermann ha
> scritto:
>> Yes,if no other values are found in the database amavisd falls back to
>> the settings which are defined in amavisd.conf.
>> Have you include these lines in 50-user for example:
>>
>> @lookup_sql_dsn =
>> ( ['DBI:mysql:database=amavis;host=localhost', 'sql-user', 'sql-pass'] );
>> @storage_sql_dsn = @lookup_sql_dsn;
> Yes, I have these lines
>> With the above settings you enable sql lookups. Have you created the
>> mysql database and tables which amavisd should use?
> Ok, this is the real question, can i specify the query to amavis (as i
> do with dovecot and postfix) or i have to use the schema proposed in the
> file README.sql-mysql.txt?
you can use your existing user db for amavis,postfix and dovecot but
you must add the other tables (policy,wblist...) for amavis too to use
all features like white- and blacklisting, pen pals...
If you're using other tables you can modify the sql select clause so
that amavisd can fetch the correct user settings. Normally amavisd
uses such a query:
$sql_select_policy = 'SELECT *,users.id FROM users,policy'.
' WHERE (users.policy_id=policy.id) AND (users.email IN (%k))'.
' ORDER BY users.priority DESC';
This query,and the query for white-/blacklisting can be changed in
amavisd.conf.
> Because I would like to extend the current schema (maybe with a policy
> table) which is used by mail cluster
I think this should be possible.
>> You can use the spamassassin autolearn feature within amavisd or you
>> can train the bayes db manually.
>> Note: amavisd calls spamassassin so the bayes database is owned and
>> used by the amavisd user. You can store your bayes db on the local
>> filesystem or in a mysql database.
> Ok
> Thank you for the quick reply
Daniel
------------------------------------------------------------------------------
Come build with us! The BlackBerry® Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9-12, 2009. Register now!
http://p.sf.net/sfu/devconf
_______________________________________________
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/
