Re: [AMaViS-user] SQL lookups : Which amavisd-new version to use

Hello Mark,

First of all, thank you for your reply.

Mark Martinec wrote:
<snip>
>> I'm most interested in having the possibility to store per-user
>>settings for the following amavisd-new settings in a SQL (MySQL)
>>database : spam_quarantine_to, virus_lover, spam_lover and
>>banned_files_lover. These ones "seems" (but I'm not sure yet) to be
>>supported by my current amavisd-new version (20030616p10).
>=20
>=20
> They are. Here is the relevant part of amavisd 20030616p10
> which lists the supported SQL fields for that version:
>=20
> $user_id_sql =3D $nf->('id', 'S');
> $virus_lovers_sql =3D $nf->('virus_lover', 'B0');
> $spam_lovers_sql =3D $nf->('spam_lover', 'B-');
> $banned_files_lovers_sql=3D $nf->('banned_files_lover', 'B-');
> $bad_header_lovers_sql =3D $nf->('bad_header_lover', 'B-');
> $bypass_virus_checks_sql=3D $nf->('bypass_virus_checks', 'B0');
> $bypass_spam_checks_sql =3D $nf->('bypass_spam_checks', 'B0');
> $bypass_banned_checks_sql=3D$nf->('bypass_banned_checks','B-');
> $bypass_header_checks_sql=3D$nf->('bypass_header_checks','B-');
> $spam_tag_level_sql =3D $nf->('spam_tag_level', 'N' );
> $spam_tag2_level_sql =3D $nf->('spam_tag2_level', 'N' );
> $spam_kill_level_sql =3D $nf->('spam_kill_level', 'N' );
> $spam_modifies_subj_sql =3D $nf->('spam_modifies_subj', 'B-');
> $spam_quarantine_to_sql =3D $nf->('spam_quarantine_to', 'S-');
> $local_domains_sql =3D $nf->('local', 'B1');
>=20

Hmm, ok. I did some tests and found that I was looking for the=20
solution trying a completely non-related setting. What I would like to=20
have is a possibility to define a field in a SQL database, represting a=20
local directory, to which amavisd-new should send the messages it=20
detected as spam in a Maildir or similar format.

Now I see (reading about the behavior of spam_quarantine_to) that=20
it's not really possible. I can set spam_quarantine_to as empty (or=20
undef), a string not cointaining the an '@' symbol or as a mail address=20
and have different behaviors for each one of these configurations.

What I would like to have is a config parameter which would allow me=20
to send messages considered spam to a subfolder called "Spam" (or=20
whatever) inside the user's mailbox to which the message was initially=20
sent to.

Maybe for this to work I would need something like a variable=20
$QUARANTINEDIR for each user. i.e. the possibility to set=20
$QUARANTINEDIR's value into a SQL database for each user and have=20
amavisd-new to look for it there.

Would that be really needed to do what I need ? Couldn't it be done=20
with an existent amavisd-new configuration option (even if it's an=20
amavisd-new-2.2.1-only config option) ?

Regards,

--
Andr=E9 Lu=EDs Lopes


-------------------------------------------------------
SF email is sponsored by - The IT Product Guide
Read honest & candid reviews on hundreds of IT Products from real users.
Discover which products truly live up to the hype. Start reading now.
http://ads.osdn.com/?ad_id=6595&alloc_id=14396&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/