SQL installation problem

[boka <bo...@piekna.pl>]

Hello,

i'm trying to configure sql whitelisting/... etc.

I've made all steps from:

http://wiki.apache.org/spamassassin/UsingSQL

and it is not working.

>From my /var/log/maillog

...
Jun 20 16:15:58 rilej amavis[19547]: Module DBD::mysql          3.0006
Jun 20 16:15:58 rilej amavis[19547]: Module DBI                 1.51
...
Jun 20 16:15:58 rilej amavis[19547]: SQL base code        NOT loaded
Jun 20 16:15:58 rilej amavis[19547]: SQL::Log code        NOT loaded
Jun 20 16:15:58 rilej amavis[19547]: SQL::Quarantine      NOT loaded
Jun 20 16:15:58 rilej amavis[19547]: Lookup::SQL code     NOT loaded
...

My conf is:
postfix-2.2.10
amavisd-new-2.4.0
spamassassin-3.1.3

best regrads
boka

Re: SQL installation problem

[Benny Pedersen <me...@junc.org>]

> Using SQL from SA is mainly useful for Bayes and AWL,
> but not for per-user settings and per-user w/b listing, as SA when called by amavisd always sees the same
> user: vscan

hope this will change so sql in sa can be used pr recipient more effitive, as i understand its not currently
posible since there is no support for this in spamassassin perl api ?

if it worked, users could change scores for every test sa do and custommize it better for there needs

i still hope it will come one day, if not tomorrow :(

what if postfix sends only one recipient at a time to amavisd ?

Re: SQL installation problem

[boka <bo...@piekna.pl>]

Benny Pedersen wrote:

>i do that i extract there entrys from sql in to local_sql.cf so
>spamassassin see it
>
>horrelble interface :(

with amavid-debugsa i can see that sa is loading sql.cf

-- 
best regrads
boka

Re: SQL installation problem

[Benny Pedersen <me...@junc.org>]

> with amavid debug-sa i can see that sql.cf is loaded.
>
> i have added smth. like this to database:
>
> INSERT INTO userpref (username,preference,value) VALUES
> ('$GLOBAL','whitelist_from','boka@piekna.pl');

this is sa not amavisd

i do that i extract there entrys from sql in to local_sql.cf so spamassassin see it

horrelble interface :(

> and i can not see in logs that this user is in whitelist.

you have to whitelist in amavisd to make it work, or drop sa whitelist to local_sql.cf

> ps. thx for your respone

thanks for your question :-)

Re: SQL installation problem

[boka <bo...@piekna.pl>]

Mark Martinec wrote:

> These log entries refer to SQL use by amavisd-new directly,
> i.e. for logging to SQL, pen pals soft-whitelisting and
> per-recipient settings including whitelisting and blacklisting
> (which is independent from w/b-listing in SA).

ok

> SA accesses SQL through its own methods and settings,
> usually set in local.cf. To see SA log messages
> run amavisd as:  amavisd debug-sa
>
> Using SQL from SA is mainly useful for Bayes and AWL,
> but not for per-user settings and per-user w/b listing,
> as SA when called by amavisd always sees the same user: vscan

with amavid debug-sa i can see that sql.cf is loaded.

i have added smth. like this to database:

INSERT INTO userpref (username,preference,value) VALUES
('$GLOBAL','whitelist_from','boka@piekna.pl');

and i can not see in logs that this user is in whitelist.

ps. thx for your respone

-- 
best regrads
boka

Re: SQL installation problem

[Mark Martinec <Ma...@ijs.si>]

boka,

> i'm trying to configure sql whitelisting/... etc.
> I've made all steps from:
> http://wiki.apache.org/spamassassin/UsingSQL

> Jun 20 16:15:58 rilej amavis[19547]: Module DBD::mysql          3.0006
> Jun 20 16:15:58 rilej amavis[19547]: Module DBI                 1.51
> ...
> Jun 20 16:15:58 rilej amavis[19547]: SQL base code        NOT loaded
> Jun 20 16:15:58 rilej amavis[19547]: SQL::Log code        NOT loaded
> Jun 20 16:15:58 rilej amavis[19547]: SQL::Quarantine      NOT loaded
> Jun 20 16:15:58 rilej amavis[19547]: Lookup::SQL code     NOT loaded

These log entries refer to SQL use by amavisd-new directly,
i.e. for logging to SQL, pen pals soft-whitelisting and
per-recipient settings including whitelisting and blacklisting
(which is independent from w/b-listing in SA).

SA accesses SQL through its own methods and settings,
usually set in local.cf. To see SA log messages
run amavisd as:  amavisd debug-sa

Using SQL from SA is mainly useful for Bayes and AWL,
but not for per-user settings and per-user w/b listing,
as SA when called by amavisd always sees the same user: vscan

  Mark