I've recently heard people say it works... not that it's perfect, but for anyone to take over it sure would help if getting started according to the docs was possible ;-) So that said, I await someone to show me what I missed.
I really did read it. I would think that a connection error would be accompanied by some sort of error message, but I see no good or bad here. Thanks. m/ -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, December 15, 2003 3:00 PM To: Mitch (WebCob) Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: [SAtalk] MySQL not working? No indication of error when running spamd -D -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Mitch (WebCob) writes: > Not sure if I should be posting this here or sending to jengland... I > already did that though... > > Thanks in advance for looking at this... There's definitely a lot of odd stuff in the SQL code, and we need someone who would be willing to take it over and add the new things we need (like known-good ordering of user/GLOBAL/@GLOBAL blocks, and Bayes/AWL-in-SQL integration). Unfortunately none of the core team are using it. Any volunteers? - --j. > Any idea what I'm missing? The DBI tests did show success... I've also tried > with a 127.0.0.1:3306 fir the dsn - now luck there either... > > I intentionally made an error in my config file to prove to myself it is > being read... > > Here are the additions: > > user_scores_dsn DBI:mysql:MyDB:localhost > user_scores_sql_username spamassassin > user_scores_sql_password XXX > user_scores_sql_table vUserSpamassassinOptions > > mysql -u spamassassin -pXXX MyDB > select * from vUserSpamassassinOptions; > +----+----------+----------------+--------------------+ > | ID | username | preference | value | > +----+----------+----------------+--------------------+ > | 1 | root | whitelist_from | [EMAIL PROTECTED] | > | 2 | root | score | GTUBE 100 | > +----+----------+----------------+--------------------+ > > ** not sure these statements are right, but I'm not seeing the preferences > retrieval message as indicated in the docs "retrieving prefs for <username> > from SQL server" so I'm thinking that I have still got something missing... > > On startup: > spamd -D > debug: Score set 0 chosen. > debug: Preloading modules with HOME=/tmp/spamd-56909-init > debug: ignore: test message to precompile patterns and load modules > debug: using "/usr/share/spamassassin" for default rules dir > debug: using "/etc/mail/spamassassin" for site rules dir > debug: bayes: no dbs present, cannot scan: > /tmp/spamd-56909-init/.spamassassin/bayes_toks > debug: Score set 1 chosen. > debug: Initialising learner > debug: bayes: Not available for scanning, only 0 spam(s) in Bayes DB < 200 > debug: bayes: 56909 untie-ing > debug: bayes: 56909 untie-ing db_toks > debug: is Net::DNS::Resolver available? yes > debug: trying (3) gwdg.de... > debug: looking up MX for 'gwdg.de' > debug: MX for 'gwdg.de' exists? 1 > debug: MX lookup of gwdg.de succeeded => Dns available (set dns_available to > hardcode) > debug: is DNS available? 1 > debug: all '*From' addrs: [EMAIL PROTECTED] > debug: running header regexp tests; score so far=0 > debug: running body-text per-line regexp tests; score so far=1.27 > debug: Razor2 is not available > debug: running raw-body-text per-line regexp tests; score so far=1.27 > debug: running uri tests; score so far=1.27 > debug: uri tests: Done uriRE > debug: running full-text regexp tests; score so far=1.27 > debug: Razor2 is not available > debug: DCCifd is not available: no r/w dccifd socket found. > debug: Current PATH is: > /sbin:/usr/local/sbin:/usr/sbin:/bin:/usr/local/bin:/usr/bin:/usr/X11R6/bin > debug: DCC is not available: no executable dccproc found. > debug: Pyzor is not available: pyzor not found > debug: all '*To' addrs: > debug: RBL: success for 1 of 1 queries > debug: running meta tests; score so far=1.27 > debug: is spam? score=1.27 required=5 tests=DATE_MISSING,NO_REAL_NAME > server started on port 783/tcp (running version 2.61) > server pid: 56909 > logmsg: server started on port 783/tcp (running version 2.61) > > On spamc -u sysop <sample-spam.txt > logmsg: connection from localhost [127.0.0.1] at port 3809 > logmsg: info: setuid to sysop succeeded > debug: read_scoreonly_config: cannot open > "/home/sysop/.spamassassin/user_prefs": No such file or directory > debug: user has changed > debug: bayes: 56929 untie-ing > debug: bayes: no dbs present, cannot scan: > /home/sysop/.spamassassin/bayes_toks > debug: Score set 1 chosen. > logmsg: processing message <[EMAIL PROTECTED]> for sysop:1001. > debug: bayes: Not available for scanning, only 0 spam(s) in Bayes DB < 200 > debug: bayes: 56929 untie-ing > debug: bayes: 56929 untie-ing db_toks > debug: is Net::DNS::Resolver available? yes > debug: all '*From' addrs: [EMAIL PROTECTED] > debug: running header regexp tests; score so far=0 > debug: running body-text per-line regexp tests; score so far=0 > debug: Razor2 is not available > debug: running raw-body-text per-line regexp tests; score so far=0 > debug: running uri tests; score so far=0 > debug: uri tests: Done uriRE > debug: running full-text regexp tests; score so far=0 > debug: Razor2 is not available > debug: DCCifd is not available: no r/w dccifd socket found. > debug: DCC is not available: no executable dccproc found. > debug: Pyzor is not available: pyzor not found > debug: all '*To' addrs: [EMAIL PROTECTED] > debug: DNS MX records found: 0 > debug: DNS A records found: 1 > debug: RBL: success for 1 of 1 queries > debug: running meta tests; score so far=0 > debug: auto-learn? ham=0.1, spam=12, body-hits=0, head-hits=0 > debug: auto-learn: currently using scoreset 1. no need to recompute. > debug: auto-learn? no: learner indicated spam (1000 > 1) > debug: is spam? score=1000 required=5 tests=GTUBE > logmsg: identified spam (1000.0/5.0) for sysop:1001 in 0.0 seconds, 799 > bytes. -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.2 (GNU/Linux) Comment: Exmh CVS iD8DBQE/3j0CQTcbUG5Y7woRAisLAJ48sqarWCV0Ft3ypWnfYGJTq9qMywCfdcW+ Re+/jX1UHYC0rgAWNSe6cCs= =DY4o -----END PGP SIGNATURE----- ------------------------------------------------------- This SF.net email is sponsored by: IBM Linux Tutorials. Become an expert in LINUX or just sharpen your skills. Sign up for IBM's Free Linux Tutorials. Learn everything from the bash shell to sys admin. Click now! http://ads.osdn.com/?ad_id=1278&alloc_id=3371&op=click _______________________________________________ Spamassassin-talk mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/spamassassin-talk
