I am trying to get spamassassin pulling per user prefs from a mysql db and
it does not seem to be even trying. I am following the debugging steps in
the bottom of the sql readme by running spamd -d from the command line, and
injecting a spam message using spamc (cat sample-spam.txt | spamc). I never
see an attempt by spamassassin to connect to the mysql db, nor do I see a
connect attempt from the mysql side. Spamassassin was installed through
cpan. It is version: 2.55
Here is /etc/mail/spamassassin/local.cf:
auto_whitelist_path /var/spool/spamassassin/auto-whitelist
auto_whitelist_file_mode 0666
user_scores_dsn DBI:mysql:maildb:127.0.0.1
user_scores_sql_username username
user_scores_sql_password password
user_scores_sql_table sauserprefs
Here is the spamd -D output:
logmsg: connection from localhost [127.0.0.1] at port 1155
logmsg: info: setuid to root succeeded
debug: read_scoreonly_config: cannot open "/root/.spamassassin/user_prefs":
No such file or directory
debug: user has changed
debug: bayes: 5185 untie-ing
debug: bayes: no dbs present, cannot scan: /root/.spamassassin/bayes_toks
debug: Score set 1 chosen.
logmsg: Still running as root: user not specified with -u, not found, or set
to root. Fall back to nobody.
logmsg: processing message <N1msdrbJXNPfV4wg9> for root:65534.
debug: debug: Only 0 spam(s) in Bayes DB < 200
debug: bayes: 5185 untie-ing
debug: bayes: 5185 untie-ing db_toks
debug: is Net::DNS::Resolver available? yes
debug: running header regexp tests; score so far=0
debug: running body-text per-line regexp tests; score so far=2.6
debug: running raw-body-text per-line regexp tests; score so far=6.3
debug: running uri tests; score so far=6.3
debug: uri tests: Done uriRE
debug: running full-text regexp tests; score so far=6.3
debug: DCC is not available: dccproc not found
debug: Razor2 is available
debug: Razor2 is available
debug: entering helper-app run mode
Razor-Log: Computed razorhome from env: /root/.razor
Razor-Log: No razorhome found, using all defaults
Razor-Log: No razor-agent.conf found, using defaults.
Jul 28 01:55:17.806645 check[5185]: [ 1] [bootup] Logging initiated
LogDebugLevel=9 to stdout
Jul 28 01:55:17.811945 check[5185]: [ 5] computed razorhome=, conf=,
ident=identity
Jul 28 01:55:17.814769 check[5185]: [ 8] Client supported_engines: 1 2 3 4
Jul 28 01:55:17.822046 check[5185]: [ 8] prep_mail done: mail 1
headers=1552, mime0=3139
Jul 28 01:55:17.824923 check[5185]: [ 7] Can't read file
servers.discovery.lst, looking relatve to
Jul 28 01:55:17.826200 check[5185]: [ 5] Can't read file
/servers.discovery.lst: No such file or directory
Jul 28 01:55:17.827467 check[5185]: [ 7] Can't read file
servers.nomination.lst, looking relatve to
Jul 28 01:55:17.828627 check[5185]: [ 5] Can't read file
/servers.nomination.lst: No such file or directory
Jul 28 01:55:17.829910 check[5185]: [ 7] Can't read file
servers.catalogue.lst, looking relatve to
Jul 28 01:55:17.831066 check[5185]: [ 5] Can't read file
/servers.catalogue.lst: No such file or directory
Jul 28 01:55:17.833900 check[5185]: [ 5] no listfile: servers.catalogue.lst
Jul 28 01:55:17.835210 check[5185]: [ 6] no discovery listfile:
servers.discovery.lst
Jul 28 01:55:17.836324 check[5185]: [ 5] Finding Discovery Servers via DNS
in the razor2.cloudmark.com zone
Jul 28 01:55:17.972951 check[5185]: [ 6] Found 1 Discovery Servers via DNS
in the razor2.cloudmark.com zone
Jul 28 01:55:17.974905 check[5185]: [ 8] Checking with Razor Discovery
Server 216.52.3.2
Jul 28 01:55:17.976821 check[5185]: [ 6] No port specified, using 2703
Jul 28 01:55:17.977881 check[5185]: [ 5] Connecting to 216.52.3.2 ...
Jul 28 01:55:18.121723 check[5185]: [ 8] Connection established
Jul 28 01:55:18.123087 check[5185]: [ 4] 216.52.3.2 >> 35 server greeting:
sn=D&srl=124&ep4=7542-10&a=l&a=cg
Jul 28 01:55:18.125576 check[5185]: [ 4] 216.52.3.2 << 12
Jul 28 01:55:18.126657 check[5185]: [ 6] a=g&pm=csl
Jul 28 01:55:18.197505 check[5185]: [ 4] 216.52.3.2 >> 54
Jul 28 01:55:18.198490 check[5185]: [ 6] response to sent.1
-csl=?
stress.cloudmark.com
truth.cloudmark.com
.
Jul 28 01:55:18.203146 check[5185]: [ 8] Discovery Server 216.52.3.2
replying with csl=stress.cloudmark.com
Jul 28 01:55:18.204191 check[5185]: [ 8] Discovery Server 216.52.3.2
replying with csl=truth.cloudmark.com
Jul 28 01:55:18.205971 check[5185]: [ 4] 216.52.3.2 << 12
Jul 28 01:55:18.206913 check[5185]: [ 6] a=g&pm=nsl
Jul 28 01:55:18.277104 check[5185]: [ 4] 216.52.3.2 >> 51
Jul 28 01:55:18.278144 check[5185]: [ 6] response to sent.2
-nsl=?
folly.cloudmark.com
joy.cloudmark.com
.
Jul 28 01:55:18.281359 check[5185]: [ 8] Discovery Server 216.52.3.2
replying with nsl=folly.cloudmark.com
Jul 28 01:55:18.282349 check[5185]: [ 8] Discovery Server 216.52.3.2
replying with nsl=joy.cloudmark.com
Jul 28 01:55:18.284555 check[5185]: [ 5] no razorhome, not caching server
info to disk
Jul 28 01:55:18.286025 check[5185]: [ 6] losing old server connection,
216.52.3.2, for new server, stress.cloudmark.com
Jul 28 01:55:18.287385 check[5185]: [ 5] disconnecting from server
216.52.3.2
Jul 28 01:55:18.288941 check[5185]: [ 4] 216.52.3.2 << 5
Jul 28 01:55:18.290040 check[5185]: [ 6] a=q
Jul 28 01:55:18.291557 check[5185]: [ 5] Connecting to stress.cloudmark.com
...
Jul 28 01:55:18.463667 check[5185]: [ 8] Connection established
Jul 28 01:55:18.465273 check[5185]: [ 4] stress.cloudmark.com >> 29 server
greeting: sn=C&srl=67&ep4=7542-10&a=l
Jul 28 01:55:18.468452 check[5185]: [ 4] stress.cloudmark.com << 14
Jul 28 01:55:18.469438 check[5185]: [ 6] a=g&pm=state
Jul 28 01:55:18.540743 check[5185]: [ 4] stress.cloudmark.com >> 97
Jul 28 01:55:18.541712 check[5185]: [ 6] response to sent.4
-sv=3.29
sn=C
zone=razor2.cloudmark.com
ac=6
srl=67
lm=4
bql=50
bqs=129
dre=4
se=48
.
Jul 28 01:55:18.550102 check[5185]: [ 5] Updated to new server state srl 67
for server stress.cloudmark.com
Jul 28 01:55:18.551848 check[5185]: [ 6] stress.cloudmark.com is a Catalogue
Server srl 67; computed min_cf=6, Server se: 48
Jul 28 01:55:18.553761 check[5185]: [ 8] Computed supported_engines: 4
Jul 28 01:55:18.554978 check[5185]: [ 5] no razorhome, not caching server
info to disk
Jul 28 01:55:18.556291 check[5185]: [ 5] srl was updated, forcing discovery
...
Jul 28 01:55:18.557651 check[5185]: [ 5] no listfile: servers.catalogue.lst
Jul 28 01:55:18.558817 check[5185]: [ 8] already have 1 discovery servers
Jul 28 01:55:18.560141 check[5185]: [ 8] Checking with Razor Discovery
Server 216.52.3.2
Jul 28 01:55:18.561215 check[5185]: [ 6] losing old server connection,
stress.cloudmark.com, for new server, 216.52.3.2
Jul 28 01:55:18.562300 check[5185]: [ 5] disconnecting from server
stress.cloudmark.com
Jul 28 01:55:18.563858 check[5185]: [ 4] stress.cloudmark.com << 5
Jul 28 01:55:18.564915 check[5185]: [ 6] a=q
Jul 28 01:55:18.566230 check[5185]: [ 5] Connecting to 216.52.3.2 ...
Jul 28 01:55:18.707213 check[5185]: [ 8] Connection established
Jul 28 01:55:18.708513 check[5185]: [ 4] 216.52.3.2 >> 35 server greeting:
sn=D&srl=124&ep4=7542-10&a=l&a=cg
Jul 28 01:55:18.713115 check[5185]: [ 4] 216.52.3.2 << 12
Jul 28 01:55:18.714158 check[5185]: [ 6] a=g&pm=csl
Jul 28 01:55:18.808633 check[5185]: [ 4] 216.52.3.2 >> 54
Jul 28 01:55:18.809613 check[5185]: [ 6] response to sent.6
-csl=?
truth.cloudmark.com
stress.cloudmark.com
.
Jul 28 01:55:18.812841 check[5185]: [ 8] Discovery Server 216.52.3.2
replying with csl=truth.cloudmark.com
Jul 28 01:55:18.813837 check[5185]: [ 8] Discovery Server 216.52.3.2
replying with csl=stress.cloudmark.com
Jul 28 01:55:18.815604 check[5185]: [ 4] 216.52.3.2 << 12
Jul 28 01:55:18.816537 check[5185]: [ 6] a=g&pm=nsl
Jul 28 01:55:18.888126 check[5185]: [ 4] 216.52.3.2 >> 51
Jul 28 01:55:18.889076 check[5185]: [ 6] response to sent.7
-nsl=?
joy.cloudmark.com
folly.cloudmark.com
.
Jul 28 01:55:18.892202 check[5185]: [ 8] Discovery Server 216.52.3.2
replying with nsl=joy.cloudmark.com
Jul 28 01:55:18.893188 check[5185]: [ 8] Discovery Server 216.52.3.2
replying with nsl=folly.cloudmark.com
Jul 28 01:55:18.895005 check[5185]: [ 5] no razorhome, not caching server
info to disk
Jul 28 01:55:18.896392 check[5185]: [ 5] no razorhome, not caching server
info to disk
Jul 28 01:55:18.897690 check[5185]: [ 8] Using next closest server
stress.cloudmark.com:2703, cached info srl 67
Jul 28 01:55:18.899655 check[5185]: [ 8] mail 1 Subject: Home Based Business
for Grownups
Jul 28 01:55:18.911536 check[5185]: [ 6] preproc: mail 1.0 went from 3139
bytes to 3100
Jul 28 01:55:18.913305 check[5185]: [ 6] computing sigs for mail 1.0, len
3100
Jul 28 01:55:18.924257 check[5185]: [ 6] skipping whitelist file (empty?):
razor-whitelist
Jul 28 01:55:18.925699 check[5185]: [ 6] losing old server connection,
216.52.3.2, for new server, stress.cloudmark.com
Jul 28 01:55:18.926661 check[5185]: [ 5] disconnecting from server
216.52.3.2
Jul 28 01:55:18.928370 check[5185]: [ 4] 216.52.3.2 << 5
Jul 28 01:55:18.929291 check[5185]: [ 6] a=q
Jul 28 01:55:18.930754 check[5185]: [ 5] Connecting to stress.cloudmark.com
...
Jul 28 01:55:19.140331 check[5185]: [ 8] Connection established
Jul 28 01:55:19.141884 check[5185]: [ 4] stress.cloudmark.com >> 29 server
greeting: sn=C&srl=67&ep4=7542-10&a=l
Jul 28 01:55:19.144103 check[5185]: [ 6] stress.cloudmark.com is a Catalogue
Server srl 67; computed min_cf=6, Server se: 48
Jul 28 01:55:19.145631 check[5185]: [ 8] Computed supported_engines: 4
Jul 28 01:55:19.147546 check[5185]: [ 8] mail 1.0 e4 sig:
04rRJ9uwTYgQJ5mkkDDpFS6NpiEA
Jul 28 01:55:19.150027 check[5185]: [ 8] preparing 1 queries
Jul 28 01:55:19.152484 check[5185]: [ 8] sending 1 batches
Jul 28 01:55:19.154062 check[5185]: [ 4] stress.cloudmark.com << 52
Jul 28 01:55:19.155140 check[5185]: [ 6]
a=c&e=4&ep4=7542-10&s=04rRJ9uwTYgQJ5mkkDDpFS6NpiEA
Jul 28 01:55:19.253845 check[5185]: [ 4] stress.cloudmark.com >> 11
Jul 28 01:55:19.254885 check[5185]: [ 6] response to sent.9
p=1&cf=96
Jul 28 01:55:19.258720 check[5185]: [ 6] mail 1.0 e=4
sig=04rRJ9uwTYgQJ5mkkDDpFS6NpiEA: Is spam: cf 96 >= min_cf 6
Jul 28 01:55:19.260141 check[5185]: [ 7] method 4: mail 1.0: no-contention
part, spam=1
Jul 28 01:55:19.261310 check[5185]: [ 7] method 4: mail 1: a non-contention
part was spam, mail spam
Jul 28 01:55:19.262258 check[5185]: [ 3] mail 1 is known spam.
Jul 28 01:55:19.263376 check[5185]: [ 5] disconnecting from server
stress.cloudmark.com
Jul 28 01:55:19.265215 check[5185]: [ 4] stress.cloudmark.com << 5
Jul 28 01:55:19.266284 check[5185]: [ 6] a=q
debug: Using results from Razor v2.34
debug: Found Razor2 part: part=0 engine=4 ct=0 cf=96
debug: leaving helper-app run mode
debug: Razor2 results: spam? 1 highest cf score: 96
debug: Pyzor is not available: pyzor not found
debug: looking up PTR record for '63.10.249.142'
debug: PTR for '63.10.249.142': ''
debug: round-the-world: mail relayed through ns.fundch.cl by 63.10.249.142
(HELO y068k3017, rev DNS says )
debug: round-the-world: probably not
debug: all '*From' addrs: [EMAIL PROTECTED]
[EMAIL PROTECTED]
debug: all '*To' addrs: [EMAIL PROTECTED]
[EMAIL PROTECTED]
debug: forged_rcvd_trail: entry 0: by=netnoteinc.com from=slashnull.org
mismatches=0
debug: forged_rcvd_trail: entry 1: by=slashnull.org from=(undef)
mismatches=0
debug: forged_rcvd_trail: entry 2: by=slashnull.org from=uci.edu
mismatches=0
debug: forged_rcvd_trail: entry 3: by=uci.edu from=mydomain.com mismatches=0
debug: forged_rcvd_trail: entry 4: by=mydomain.com from=fundch.cl
mismatches=0
debug: Ran run_rbl_eval_test rule RCVD_IN_NJABL ======> got hit
debug: Ran run_rbl_eval_test rule RCVD_IN_OSIRUSOFT_COM ======> got hit
debug: Ran run_rbl_eval_test rule X_NJABL_OPEN_PROXY ======> got hit
debug: running meta tests; score so far=10.5
debug: auto-learn? safety=4, ham=-2, spam=15, body-hits=7.8, head-hits=6.8
debug: auto-learn: currently using scoreset 1. no need to recompute.
debug: auto-learn? no: inside auto-learn thresholds or safety zone around
required_hits
debug: is spam? score=11 required=5
tests=DATE_IN_PAST_12_24,DRASTIC_REDUCED,HOME_EMPLOYMENT,INVALID_DATE,INVALI
D_MSGID,NO_REAL_NAME,ONCE_IN_LIFETIME,RAZOR2_CHECK,RCVD_IN_NJABL,RCVD_IN_OSI
RUSOFT_COM,REMOVE_SUBJ,UNDISC_RECIPS,X_NJABL_OPEN_PROXY
logmsg: identified spam (11.0/5.0) for root:65534 in 12.7 seconds, 4656
bytes.
debug: bayes: 5185 untie-ing
Thanks,
Rob
-------------------------------------------------------
This SF.Net email sponsored by: Free pre-built ASP.NET sites including
Data Reports, E-commerce, Portals, and Forums are available now.
Download today and enter to win an XBOX or Visual Studio .NET.
http://aspnet.click-url.com/go/psa00100003ave/direct;at.aspnet_072303_01/01
_______________________________________________
Spamassassin-talk mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/spamassassin-talk
