AWL: Plugin doesn't register glue with MySQL

[Magnus Anderson <ma...@sonic2000.org>]

I have just migrated over from file R/W of AWL to using our MySQL server.

But it seems like it misses registering to use it for uses. It still
wrties a file for everyone.

When I run 'spamassassin -D -t < sample-spam.txt' it works and registers
a record for user root in the awl database in mysql, so it should work.

During startup it prints this:
-----------
[19660] dbg: plugin: registering glue method for
check_from_in_auto_whitelist
(Mail::SpamAssassin::Plugin::AWL=HASH(0xaa0d6b4))
[19660] dbg: auto-whitelist: sql-based connected to
DBI:mysql:spamassassin:localhost
[19660] dbg: auto-whitelist: sql-based using username: root
[19660] dbg: auto-whitelist: sql-based get_addr_entry: no entry found
for ignore@compiling.spamassassin.taint.org|ip=none
[19660] dbg: auto-whitelist: sql-based
ignore@compiling.spamassassin.taint.org|ip=none scores 0/0
[19660] dbg: auto-whitelist: AWL active, pre-score: 2.216, autolearn
score: 2.216, mean: undef, IP: undef
[19660] dbg: auto-whitelist: sql-based finish: disconnected from
DBI:mysql:spamassassin:localhost
[19660] dbg: auto-whitelist: post auto-whitelist score: 2.216
[19660] dbg: rules: running body-text per-line regexp tests; score so
far=2.216

That seems like it's doing what it should.
But when checking the logs (I'm using CGPSA and looking in its log for
this) it gives me something completly different when it checkes the
mails it gets.

[19702] dbg: locker: safe_lock: created
/var/CommuniGate/Domains/sonic2000.org/magnus.macnt/account.web/.spamassassin/auto-whitelist.lock.lynx.us-se.com.19702
[19702] dbg: locker: safe_lock: trying to get lock on
/var/CommuniGate/Domains/sonic2000.org/magnus.macnt/account.web/.spamassassin/auto-whitelist
with 0 retries
[19702] dbg: locker: safe_lock: link to
/var/CommuniGate/Domains/sonic2000.org/magnus.macnt/account.web/.spamassassin/auto-whitelist.lock:
link ok
[19702] dbg: auto-whitelist: tie-ing to DB file of type DB_File R/W in
/var/CommuniGate/Domains/sonic2000.org/magnus.macnt/account.web/.spamassassin/auto-whitelist
[19702] dbg: auto-whitelist: db-based xxx@xxx.net|ip=213.67 scores 0/0
[19702] dbg: auto-whitelist: db-based xxx@xxx.net|ip=none scores 0/0
[19702] dbg: auto-whitelist: AWL active, pre-score: -1.44, autolearn
score: -1.44, mean: undef, IP: 213.67.205.235
[19702] dbg: auto-whitelist: add_score: new count: 1, new totscore: -1.44
[19702] dbg: auto-whitelist: DB addr list: untie-ing and unlocking
[19702] dbg: auto-whitelist: DB addr list: file locked, breaking lock
[19702] dbg: locker: safe_unlock: unlink
/var/CommuniGate/Domains/sonic2000.org/magnus.macnt/account.web/.spamassassin/auto-whitelist.lock
[19702] dbg: auto-whitelist: post auto-whitelist score: -1.44

My question now is, why is it still using a DB File and not MySQL when
it has been registering it at the beginning of the startup process?

For now I just have to live with  it using DB files, but migrating the
whole thing to MySQL would be alot better.

Thanks in advance,
 Magnus

Re: AWL: Plugin doesn't register glue with MySQL

[Magnus Anderson <ma...@sonic2000.org>]

My setup are this in local.cf:

auto_whitelist_factory          Mail::SpamAssassin::SQLBasedAddrList
user_awl_dsn                    DBI:mysql:spamassassin:localhost
user_awl_sql_username           spamassassin
user_awl_sql_password           xxxxxxx
user_awl_sql_table              awl