SA bayes with mySQL

Use this forum for discussions about SpamAssassin and anti-spam in general.
Post Reply
User avatar
katip
Senior user
Senior user
Posts: 685
Joined: 2006-12-22 07:58
Location: Istanbul

SA bayes with mySQL

Post by katip » 2017-04-30 23:17

Hi SA gurus,

has anyone tried to store and read/check bayes in mySQL?
i created db and tables, imported current flat db, .cf entries are all ok, even sa-learn works, service startup is clean w/o error. however SA doesn't check bayes as if use_bayes is 0 :P

IMO there must be something with bayes_sql_override_username but don't have any idea what username this should be. SYSTEM, unknown, .spamassasin, systemprofile, <name of the service>... tried all but no avail. IOW, who is spamd in system?
or JAM version doesn't support this?? thanks for any clue.
Katip
--
HMS 5.7.0-B2428-LTS-64-bit, MySQL 5.7.24, SA 3.4.2, ClamAV 0.101.2 + SaneS

User avatar
SorenR
Senior user
Senior user
Posts: 3191
Joined: 2006-08-21 15:38
Location: Denmark

Re: SA bayes with mySQL

Post by SorenR » 2017-05-01 00:28

katip wrote:Hi SA gurus,

has anyone tried to store and read/check bayes in mySQL?
i created db and tables, imported current flat db, .cf entries are all ok, even sa-learn works, service startup is clean w/o error. however SA doesn't check bayes as if use_bayes is 0 :P

IMO there must be something with bayes_sql_override_username but don't have any idea what username this should be. SYSTEM, unknown, .spamassasin, systemprofile, <name of the service>... tried all but no avail. IOW, who is spamd in system?
or JAM version doesn't support this?? thanks for any clue.
Frankly, there is no real incentive in having Bayes data in a DB, sure you can do stuff from Roundcube webmail but at the end of the day, hMailServer do not support differentiated user profiles - it all goes into the same user "unknown" :mrgreen:

But just for the challenge... Hmm... Tomorrow :mrgreen:
SørenR.

“With age comes wisdom, but sometimes age comes alone.”
- Oscar Wilde

User avatar
katip
Senior user
Senior user
Posts: 685
Joined: 2006-12-22 07:58
Location: Istanbul

Re: SA bayes with mySQL

Post by katip » 2017-05-01 16:21

katip wrote:however SA doesn't check bayes as if use_bayes is 0 :P
weirdest things accompany my SA beginner endeavors. i started spamd service with -D hoping to find something useful. suddenly i saw that bayes has started to check :lol:
restarted without -D and it keeps checking!!

BTW, yes, sql user which spamd refers to is "unknown"!

i'm thinking to post a HOW-TO about SA-bayes /w mySQL. keeping bayes in SQL may sound useless as HMS SA implementation is global. but i anticipate some speed, particularly with sa-learn. besides IMHO it's always a good idea to maintain a DB instead of a flat file when something is looked up in ten (even hundred) thousands of items. we'll see..
Katip
--
HMS 5.7.0-B2428-LTS-64-bit, MySQL 5.7.24, SA 3.4.2, ClamAV 0.101.2 + SaneS

User avatar
SorenR
Senior user
Senior user
Posts: 3191
Joined: 2006-08-21 15:38
Location: Denmark

Re: SA bayes with mySQL

Post by SorenR » 2017-05-01 16:52

It was pretty easy to get going... Even managed to import my "old" Bayes DB...

Code: Select all

https://www.beris.nl/blog/2011/06/23/migrating-spamassassin-from-db-files-to-mysql/

## START ## Stuff that goes into local.cf
use_bayes          1 (Default: 1)
bayes_auto_learn   0 (Default: 1) ==> 0 since I use SA-LEARN exclusively
bayes_auto_expire  1 (Default: 1)

bayes_store_module Mail::SpamAssassin::BayesStore::MySQL

# MySQL driver, databasename = sa_bayes, Host = 127.0.0.1, Port = 3306
bayes_sql_dsn      DBI:mysql:sa_bayes:127.0.0.1:3306

# YES, I have used this username and password ;-)
bayes_sql_username sa_user
bayes_sql_password sa_user_password

# Not sure what to think of this but hey, it's better than "unknown" ;-)
bayes_sql_override_username vscan

## END ##

# Get from CPAN...
.\lib\Mail\SpamAssassin\BayesStore\MySQL.pm
.\lib\Mail\SpamAssassin\BayesStore\SQL.pm
.\lib\Mail\SpamAssassin\Plugin\Bayes.pm

#Create MySQL tables (SA version 3.4.0).
CREATE TABLE bayes_expire (
  id int(11) NOT NULL default '0',
  runtime int(11) NOT NULL default '0',
  KEY bayes_expire_idx1 (id)
) ENGINE=InnoDB;

CREATE TABLE bayes_global_vars (
  variable varchar(30) NOT NULL default '',
  value varchar(200) NOT NULL default '',
  PRIMARY KEY  (variable)
) ENGINE=InnoDB;

INSERT INTO bayes_global_vars VALUES ('VERSION','3');

CREATE TABLE bayes_seen (
  id int(11) NOT NULL default '0',
  msgid varchar(200) binary NOT NULL default '',
  flag char(1) NOT NULL default '',
  PRIMARY KEY  (id,msgid)
) ENGINE=InnoDB;

CREATE TABLE bayes_token (
  id int(11) NOT NULL default '0',
  token binary(5) NOT NULL default '',
  spam_count int(11) NOT NULL default '0',
  ham_count int(11) NOT NULL default '0',
  atime int(11) NOT NULL default '0',
  PRIMARY KEY  (id, token),
  INDEX bayes_token_idx1 (id, atime)
) ENGINE=InnoDB;

CREATE TABLE bayes_vars (
  id int(11) NOT NULL AUTO_INCREMENT,
  username varchar(200) NOT NULL default '',
  spam_count int(11) NOT NULL default '0',
  ham_count int(11) NOT NULL default '0',
  token_count int(11) NOT NULL default '0',
  last_expire int(11) NOT NULL default '0',
  last_atime_delta int(11) NOT NULL default '0',
  last_expire_reduce int(11) NOT NULL default '0',
  oldest_token_age int(11) NOT NULL default '2147483647',
  newest_token_age int(11) NOT NULL default '0',
  PRIMARY KEY  (id),
  UNIQUE bayes_vars_idx1 (username)
) ENGINE=InnoDB;
SørenR.

“With age comes wisdom, but sometimes age comes alone.”
- Oscar Wilde

User avatar
SorenR
Senior user
Senior user
Posts: 3191
Joined: 2006-08-21 15:38
Location: Denmark

Re: SA bayes with mySQL

Post by SorenR » 2017-05-01 17:18

Did the suggested test...

Code: Select all

C:\SpamAssassin>wget http://spamassassin.apache.org/gtube/gtube.txt
--2017-05-01 17:08:46--  http://spamassassin.apache.org/gtube/gtube.txt
Resolving spamassassin.apache.org... 140.211.11.105, 88.198.26.2
Connecting to spamassassin.apache.org|140.211.11.105|:80... connected.
HTTP request sent, awaiting response... 200 OK
Length: 799 [text/plain]
Saving to: `gtube.txt'

100%[======================================>] 799         --.-K/s   in 0s

2017-05-01 17:08:46 (61.7 MB/s) - `gtube.txt' saved [799/799]


C:\SpamAssassin>sa-learn.exe -D --spam gtube.txt
maj  1 17:09:22.317 [3432] dbg: logger: adding facilities: all
maj  1 17:09:22.318 [3432] dbg: logger: logging level is DBG
maj  1 17:09:22.318 [3432] dbg: generic: SpamAssassin version 3.4.0
maj  1 17:09:22.318 [3432] dbg: generic: Perl 5.008009, PREFIX=., DEF_RULES_DIR=.\share\spamassassin, LOCAL_RULES_DIR=.\etc\spamassassin, LOCAL_STATE_DIR=C:\Perl\site/var/spamassassin
maj  1 17:09:22.318 [3432] dbg: config: timing enabled
maj  1 17:09:22.321 [3432] dbg: config: score set 0 chosen.
maj  1 17:09:22.327 [3432] dbg: util: running in taint mode? no
maj  1 17:09:22.327 [3432] dbg: util: defining getpwuid() wrapper using 'unknown' as username
maj  1 17:09:22.331 [3432] dbg: config: using ".\etc\spamassassin" for site rules pre files
maj  1 17:09:22.332 [3432] dbg: config: read file .\etc\spamassassin/init.pre
maj  1 17:09:22.332 [3432] dbg: config: read file .\etc\spamassassin/v310.pre
maj  1 17:09:22.333 [3432] dbg: config: read file .\etc\spamassassin/v312.pre
maj  1 17:09:22.333 [3432] dbg: config: read file .\etc\spamassassin/v320.pre
maj  1 17:09:22.334 [3432] dbg: config: read file .\etc\spamassassin/v330.pre
maj  1 17:09:22.334 [3432] dbg: config: read file .\etc\spamassassin/v340.pre
maj  1 17:09:22.334 [3432] dbg: config: using ".\share\spamassassin" for sys rules pre files
maj  1 17:09:22.335 [3432] dbg: config: using ".\share\spamassassin" for default rules dir
maj  1 17:09:22.335 [3432] dbg: config: using ".\etc\spamassassin" for site rules dir
maj  1 17:09:22.336 [3432] dbg: config: read file .\etc\spamassassin/ClamAV.cf
maj  1 17:09:22.338 [3432] dbg: config: read file .\etc\spamassassin/KAM.cf
maj  1 17:09:22.339 [3432] dbg: config: read file .\etc\spamassassin/botnet.cf
maj  1 17:09:22.339 [3432] dbg: config: read file .\etc\spamassassin/bwlist.cf
maj  1 17:09:22.340 [3432] dbg: config: read file .\etc\spamassassin/contact.cf
maj  1 17:09:22.340 [3432] dbg: config: read file .\etc\spamassassin/local.cf
maj  1 17:09:22.340 [3432] dbg: config: read file .\etc\spamassassin/rulestats.cf
maj  1 17:09:22.353 [3432] dbg: plugin: loading Mail::SpamAssassin::Plugin::URIDNSBL from @INC
maj  1 17:09:22.364 [3432] dbg: plugin: loading Mail::SpamAssassin::Plugin::Hashcash from @INC
maj  1 17:09:22.415 [3432] dbg: plugin: loading Mail::SpamAssassin::Plugin::SPFfrom @INC
maj  1 17:09:22.463 [3432] dbg: plugin: loading Mail::SpamAssassin::Plugin::Pyzor from @INC
maj  1 17:09:22.508 [3432] dbg: pyzor: network tests on, attempting Pyzor
maj  1 17:09:22.528 [3432] dbg: plugin: loading Mail::SpamAssassin::Plugin::Razor2 from @INC
maj  1 17:09:22.648 [3432] dbg: razor2: razor2 is available, version 2.84
maj  1 17:09:22.669 [3432] dbg: plugin: loading Mail::SpamAssassin::Plugin::SpamCop from @INC
maj  1 17:09:22.736 [3432] dbg: reporter: network tests on, attempting SpamCop
maj  1 17:09:22.756 [3432] dbg: plugin: loading Mail::SpamAssassin::Plugin::AutoLearnThreshold from @INC
maj  1 17:09:22.803 [3432] dbg: plugin: loading Mail::SpamAssassin::Plugin::WhiteListSubject from @INC
maj  1 17:09:22.833 [3432] dbg: plugin: loading Mail::SpamAssassin::Plugin::MIMEHeader from @INC
maj  1 17:09:22.876 [3432] dbg: plugin: loading Mail::SpamAssassin::Plugin::ReplaceTags from @INC
maj  1 17:09:22.920 [3432] dbg: plugin: loading Mail::SpamAssassin::Plugin::DKIM from @INC
maj  1 17:09:22.969 [3432] dbg: plugin: loading Mail::SpamAssassin::Plugin::Check from @INC
maj  1 17:09:23.026 [3432] dbg: plugin: loading Mail::SpamAssassin::Plugin::HTTPSMismatch from @INC
maj  1 17:09:23.072 [3432] dbg: plugin: loading Mail::SpamAssassin::Plugin::URIDetail from @INC
maj  1 17:09:23.121 [3432] dbg: plugin: loading Mail::SpamAssassin::Plugin::Bayes from @INC
maj  1 17:09:23.175 [3432] dbg: plugin: loading Mail::SpamAssassin::Plugin::BodyEval from @INC
maj  1 17:09:23.223 [3432] dbg: plugin: loading Mail::SpamAssassin::Plugin::DNSEval from @INC
maj  1 17:09:23.267 [3432] dbg: plugin: loading Mail::SpamAssassin::Plugin::HTMLEval from @INC
maj  1 17:09:23.311 [3432] dbg: plugin: loading Mail::SpamAssassin::Plugin::HeaderEval from @INC
maj  1 17:09:23.364 [3432] dbg: plugin: loading Mail::SpamAssassin::Plugin::MIMEEval from @INC
maj  1 17:09:23.415 [3432] dbg: plugin: loading Mail::SpamAssassin::Plugin::RelayEval from @INC
maj  1 17:09:23.459 [3432] dbg: plugin: loading Mail::SpamAssassin::Plugin::URIEval from @INC
maj  1 17:09:23.501 [3432] dbg: plugin: loading Mail::SpamAssassin::Plugin::WLBLEval from @INC
maj  1 17:09:23.551 [3432] dbg: plugin: loading Mail::SpamAssassin::Plugin::VBounce from @INC
maj  1 17:09:23.594 [3432] dbg: plugin: loading Mail::SpamAssassin::Plugin::ImageInfo from @INC
maj  1 17:09:23.643 [3432] dbg: plugin: loading Mail::SpamAssassin::Plugin::FreeMail from @INC
maj  1 17:09:23.690 [3432] dbg: plugin: loading Mail::SpamAssassin::Plugin::AskDNS from @INC
maj  1 17:09:23.736 [3432] dbg: config: fixed relative path: .\etc\spamassassin/clamav.pm
maj  1 17:09:23.777 [3432] dbg: plugin: loading ClamAV from C:\SpamAssassin\etc\spamassassin\clamav.pm
maj  1 17:09:24.114 [3432] dbg: plugin: loading Mail::SpamAssassin::Plugin::Botnet from @INC
maj  1 17:09:24.162 [3432] dbg: Botnet: version 0.9
maj  1 17:09:24.183 [3432] dbg: plugin: Mail::SpamAssassin::Plugin::FreeMail=HASH(0x3162af4) implements 'parse_config', priority 0
maj  1 17:09:24.225 [3432] dbg: plugin: Mail::SpamAssassin::Plugin::Botnet=HASH(0x326aec4) implements 'parse_config', priority 0
maj  1 17:09:24.267 [3432] dbg: Botnet: setting botnet_pass_auth to 0
maj  1 17:09:24.288 [3432] dbg: Botnet: setting botnet_pass_trusted to public
maj  1 17:09:24.309 [3432] dbg: Botnet: adding ^127\.0\.0\.1$ to botnet_skip_ip
maj  1 17:09:24.330 [3432] dbg: Botnet: adding ^10\..*$ to botnet_skip_ip
maj  1 17:09:24.351 [3432] dbg: Botnet: adding ^172\.1[6789]\..*$ to botnet_skip_ip
maj  1 17:09:24.391 [3432] dbg: Botnet: adding ^172\.2[0-9]\..*$ to botnet_skip_ip
maj  1 17:09:24.432 [3432] dbg: Botnet: adding ^172\.3[01]\..*$ to botnet_skip_ip
maj  1 17:09:24.472 [3432] dbg: Botnet: adding ^192\.168\..*$ to botnet_skip_ip
maj  1 17:09:24.493 [3432] dbg: Botnet: adding ^128\.223\.98\.16$ to botnet_pass_ip
maj  1 17:09:24.533 [3432] dbg: Botnet: adding (\.|\A)amazon\.com$ to botnet_pass_domains
maj  1 17:09:24.575 [3432] dbg: Botnet: adding (\.|\A)apple\.com$ to botnet_pass_domains
maj  1 17:09:24.614 [3432] dbg: Botnet: adding (\.|\A)ebay\.com$ to botnet_pass_domains
maj  1 17:09:24.656 [3432] dbg: Botnet: adding (\b|\d).*dsl.*(\b|\d) to botnet_clientwords
maj  1 17:09:24.697 [3432] dbg: Botnet: adding (\b|\d)cable(\b|\d) to botnet_clientwords
maj  1 17:09:24.738 [3432] dbg: Botnet: adding (\b|\d)catv(\b|\d) to botnet_clientwords
maj  1 17:09:24.780 [3432] dbg: Botnet: adding (\b|\d)ddns(\b|\d) to botnet_clientwords
maj  1 17:09:24.820 [3432] dbg: Botnet: adding (\b|\d)dhcp(\b|\d) to botnet_clientwords
maj  1 17:09:24.861 [3432] dbg: Botnet: adding (\b|\d)dial(-?up)?(\b|\d) to botnet_clientwords
maj  1 17:09:24.903 [3432] dbg: Botnet: adding (\b|\d)dip(\b|\d) to botnet_clientwords
maj  1 17:09:24.944 [3432] dbg: Botnet: adding (\b|\d)docsis(\b|\d) to botnet_clientwords
maj  1 17:09:24.985 [3432] dbg: Botnet: adding (\b|\d)dyn(amic)?(ip)?(\b|\d) tobotnet_clientwords
maj  1 17:09:25.025 [3432] dbg: Botnet: adding (\b|\d)modem(\b|\d) to botnet_clientwords
maj  1 17:09:25.067 [3432] dbg: Botnet: adding (\b|\d)ppp(oe)?(\b|\d) to botnet_clientwords
maj  1 17:09:25.108 [3432] dbg: Botnet: adding (\b|\d)res(net|ident(ial)?)?(\b|\d) to botnet_clientwords
maj  1 17:09:25.146 [3432] dbg: Botnet: adding (\b|\d)bredband(\b|\d) to botnet_clientwords
maj  1 17:09:25.187 [3432] dbg: Botnet: adding (\b|\d)client(\b|\d) to botnet_clientwords
maj  1 17:09:25.229 [3432] dbg: Botnet: adding (\b|\d)fixed(\b|\d) to botnet_clientwords
maj  1 17:09:25.270 [3432] dbg: Botnet: adding (\b|\d)ip(\b|\d) to botnet_clientwords
maj  1 17:09:25.312 [3432] dbg: Botnet: adding (\b|\d)pool(\b|\d) to botnet_clientwords
maj  1 17:09:25.353 [3432] dbg: Botnet: adding (\b|\d)static(\b|\d) to botnet_clientwords
maj  1 17:09:25.394 [3432] dbg: Botnet: adding (\b|\d)user(\b|\d) to botnet_clientwords
maj  1 17:09:25.436 [3432] dbg: Botnet: adding (\b|\d)e?mail(out)?(\b|\d) to botnet_serverwords
maj  1 17:09:25.477 [3432] dbg: Botnet: adding (\b|\d)mta(\b|\d) to botnet_serverwords
maj  1 17:09:25.518 [3432] dbg: Botnet: adding (\b|\d)mx(pool)?(\b|\d) to botnet_serverwords
maj  1 17:09:25.560 [3432] dbg: Botnet: adding (\b|\d)relay(\b|\d) to botnet_serverwords
maj  1 17:09:25.602 [3432] dbg: Botnet: adding (\b|\d)smtp(\b|\d) to botnet_serverwords
maj  1 17:09:25.643 [3432] dbg: Botnet: adding (\b|\d)exch(ange)?(\b|\d) to botnet_serverwords
maj  1 17:09:25.692 [3432] dbg: plugin: loading Mail::SpamAssassin::Plugin::Rulestats from @INC
maj  1 17:09:25.767 [3432] dbg: config: warning: no description set for KAM_RPTR_SUSPECT
maj  1 17:09:25.809 [3432] dbg: config: warning: no description set for KAM_RAPTOR
maj  1 17:09:25.852 [3432] dbg: config: warning: no description set for CBJ_GiveMeABreak
maj  1 17:09:25.893 [3432] dbg: config: warning: no description set for KAM_BADPDF2
maj  1 17:09:25.934 [3432] dbg: config: warning: no description set for KAM_RPTR_FAILED
maj  1 17:09:25.977 [3432] dbg: config: warning: no description set for KAM_RPTR_PASSED
maj  1 17:09:26.019 [3432] dbg: config: warning: no description set for KAM_IFRAME
maj  1 17:09:26.255 [3432] dbg: rules: CBJ_GiveMeABreak merged duplicates: KAM_IFRAME KAM_RAPTOR KAM_RPTR_FAILED KAM_RPTR_PASSED KAM_RPTR_SUSPECT
maj  1 17:09:26.297 [3432] dbg: config: finish parsing
maj  1 17:09:26.330 [3432] dbg: plugin: Mail::SpamAssassin::Plugin::ReplaceTags=HASH(0x2e11278) implements 'finish_parsing_end', priority 0
maj  1 17:09:26.370 [3432] dbg: plugin: Mail::SpamAssassin::Plugin::FreeMail=HASH(0x3162af4) implements 'finish_parsing_end', priority 0
maj  1 17:09:26.412 [3432] dbg: replacetags: replacing tags
maj  1 17:09:26.437 [3432] dbg: replacetags: done replacing tags
maj  1 17:09:26.458 [3432] dbg: FreeMail: no freemail_domains entries defined, disabling plugin
maj  1 17:09:26.500 [3432] dbg: plugin: Mail::SpamAssassin::Plugin::Bayes=HASH(0x2f248f8) implements 'learner_new', priority 0
maj  1 17:09:26.542 [3432] dbg: bayes: learner_new self=Mail::SpamAssassin::Plugin::Bayes=HASH(0x2f248f8), bayes_store_module=Mail::SpamAssassin::BayesStore::MySQL
maj  1 17:09:26.624 [3432] dbg: bayes: using username: vscan
maj  1 17:09:26.644 [3432] dbg: bayes: learner_new: got store=Mail::SpamAssassin::BayesStore::MySQL=HASH(0x2958934)
maj  1 17:09:26.686 [3432] dbg: plugin: Mail::SpamAssassin::Plugin::Bayes=HASH(0x2f248f8) implements 'learner_is_scan_available', priority 0
maj  1 17:09:26.754 [3432] dbg: bayes: database connection established
maj  1 17:09:26.771 [3432] dbg: bayes: found bayes db version 3
maj  1 17:09:26.791 [3432] dbg: bayes: Using userid: 2
maj  1 17:09:26.814 [3432] dbg: config: score set 3 chosen.
maj  1 17:09:26.834 [3432] dbg: dns: socket module for IPv6 support not available
maj  1 17:09:26.875 [3432] dbg: dns: EDNS, UDP payload size 4096
maj  1 17:09:26.897 [3432] dbg: dns: servers obtained from Net::DNS : [192.168.0.50]:53
maj  1 17:09:26.938 [3432] dbg: dns: nameservers set to 192.168.0.50
maj  1 17:09:26.960 [3432] dbg: dns: using socket module: IO::Socket::INET, forced IPv4
maj  1 17:09:27.000 [3432] dbg: dns: is Net::DNS::Resolver available? yes
maj  1 17:09:27.022 [3432] dbg: dns: Net::DNS version: 0.66
maj  1 17:09:27.043 [3432] dbg: sa-learn: spamtest initialized
maj  1 17:09:27.065 [3432] dbg: learn: initializing learner
maj  1 17:09:27.088 [3432] dbg: plugin: Mail::SpamAssassin::Plugin::Bayes=HASH(0x2f248f8) implements 'learner_sync', priority 0
maj  1 17:09:27.130 [3432] dbg: bayes: bayes journal sync starting
maj  1 17:09:27.152 [3432] dbg: bayes: bayes journal sync completed
maj  1 17:09:27.172 [3432] dbg: plugin: Mail::SpamAssassin::Plugin::Bayes=HASH(0x2f248f8) implements 'learner_expire_old_training', priority 0
maj  1 17:09:27.215 [3432] dbg: bayes: expiry starting
maj  1 17:09:27.238 [3432] dbg: bayes: expiry completed
maj  1 17:09:27.260 [3432] dbg: archive-iterator: _set_default_message_selection_opts After: Scanprob[1], want_date[0], cache[0], from_regex[^From \S+ ?(\S\S\S\S\S\S .\d .\d:\d\d:\d\d \d{4}|.\d-\d\d-\d{4}_\d\d:\d\d:\d\d_)]
maj  1 17:09:27.333 [3432] dbg: config: time limit 120.0 s
maj  1 17:09:27.355 [3432] dbg: message: main message type: text/plain
maj  1 17:09:27.377 [3432] dbg: learn: learning spam
maj  1 17:09:27.398 [3432] dbg: plugin: Mail::SpamAssassin::Plugin::Bayes=HASH(0x2f248f8) implements 'learn_message', priority 0
maj  1 17:09:27.439 [3432] dbg: check: pms new, time limit in 119.894 s
maj  1 17:09:27.461 [3432] dbg: metadata: X-Spam-Relays-Trusted:
maj  1 17:09:27.481 [3432] dbg: metadata: X-Spam-Relays-Untrusted:
maj  1 17:09:27.503 [3432] dbg: metadata: X-Spam-Relays-Internal:
maj  1 17:09:27.523 [3432] dbg: metadata: X-Spam-Relays-External:
maj  1 17:09:27.543 [3432] dbg: plugin: Mail::SpamAssassin::Plugin::AskDNS=HASH(0x3162ef0) implements 'extract_metadata', priority 0
maj  1 17:09:27.585 [3432] dbg: dns: clear_resolver
maj  1 17:09:27.606 [3432] dbg: dns: socket module for IPv6 support not available
maj  1 17:09:27.648 [3432] dbg: dns: EDNS, UDP payload size 4096
maj  1 17:09:27.668 [3432] dbg: dns: nameservers set to 192.168.0.50
maj  1 17:09:27.690 [3432] dbg: dns: using socket module: IO::Socket::INET, forced IPv4
maj  1 17:09:27.731 [3432] dbg: dns: is Net::DNS::Resolver available? yes
maj  1 17:09:27.752 [3432] dbg: dns: Net::DNS version: 0.66
maj  1 17:09:27.774 [3432] dbg: dns: dns_available set to yes in config file, skipping test
maj  1 17:09:27.814 [3432] dbg: check: tagrun - action 0 blocking on tags SENDERDOMAIN
maj  1 17:09:27.849 [3432] dbg: message: ---- MIME PARSER START ----
maj  1 17:09:27.870 [3432] dbg: message: parsing normal part
maj  1 17:09:27.891 [3432] dbg: message: storing a body to memory
maj  1 17:09:27.912 [3432] dbg: message: ---- MIME PARSER END ----
maj  1 17:09:27.934 [3432] dbg: message: decoding other encoding type (7bit), ignoring
maj  1 17:09:27.976 [3432] dbg: check: tagrun - tag SENDERDOMAIN is still blocking action 0
maj  1 17:09:28.039 [3432] dbg: bayes: seen (31dcbefd2524b07c65d551d282ce77902f3804c7@sa_generated) put
maj  1 17:09:28.081 [3432] dbg: bayes: learned '31dcbefd2524b07c65d551d282ce77902f3804c7@sa_generated', atime: 1058995800
Learned tokens from 1 message(s) (1 message(s) examined)
maj  1 17:09:28.144 [3432] dbg: plugin: Mail::SpamAssassin::Plugin::Bayes=HASH(0x2f248f8) implements 'learner_close', priority 0

C:\SpamAssassin>
:shock:
SørenR.

“With age comes wisdom, but sometimes age comes alone.”
- Oscar Wilde

User avatar
katip
Senior user
Senior user
Posts: 685
Joined: 2006-12-22 07:58
Location: Istanbul

Re: SA bayes with mySQL

Post by katip » 2017-05-01 17:59

well done!

for me, "unknown" is good, indeed it's unknown :lol:
now i'm going to change our production setup. if all goes well also there, i'll post a HOW-TO.
happy Workers' Day btw... ;)
Katip
--
HMS 5.7.0-B2428-LTS-64-bit, MySQL 5.7.24, SA 3.4.2, ClamAV 0.101.2 + SaneS

Post Reply