On 06/29/2011 09:55 PM, Lawrence @ Rogers wrote: > On 29/06/2011 4:58 PM, JKL wrote: >> select count(spam_count) from bayes_vars > Run this query > > SELECT username,spam_count,ham_count FROM bayes_vars > > This will give a list of usernames that have been used to learn ham > and spam into SpamAssassin's Bayes MySQL DB. For a site-wide > installation, this should only return one result. > > To answer your previous question, I meant to simply add the > bayes_sql_override_username setting to your local.cf and restart > spamassassin > > If you are using Postfix with the postfix username, set it as > > bayes_sql_override_username postfix > > This ensures that all future e-mails are labeled as being learned from > the postfix user, regardless of whether you did it manually using > sa-learn via ssh or another interface, or auto-learning is used. For > one site-wide Bayes installation, this is what you want. > > Regards, > Lawrence >
Hi there, This is the table I have in mysql, and the one I intend to populate with data:- mysql> describe bayes_vars; +--------------------+--------------+------+-----+------------+----------------+ | Field | Type | Null | Key | Default | Extra | +--------------------+--------------+------+-----+------------+----------------+ | id | int(11) | NO | PRI | NULL | auto_increment | | username | varchar(200) | NO | UNI | | | | spam_count | int(11) | NO | | 0 | | | ham_count | int(11) | NO | | 0 | | | token_count | int(11) | NO | | 0 | | | last_expire | int(11) | NO | | 0 | | | last_atime_delta | int(11) | NO | | 0 | | | last_expire_reduce | int(11) | NO | | 0 | | | oldest_token_age | int(11) | NO | | 2147483647 | | | newest_token_age | int(11) | NO | | 0 | | +--------------------+--------------+------+-----+------------+----------------+ 10 rows in set (0.00 sec) The configuration I intend to use for Bayes is: -------------------- START local.cf ------------------------------- rewrite_header Subject *****SPAM***** report_safe 0 report_hostname xxx.xxx.com dns_available yes use_dcc 1 dcc_path /usr/local/bin/dccproc dcc_home /var/dcc use_pyzor 1 pyzor_path /usr/bin/pyzor pyzor_timeout 5 use_razor2 1 razor_config /etc/razor/razor-agent.conf razor_timeout 5 required_score 6.0 use_bayes 1 skip_rbl_checks 1 bayes_auto_learn 0 # bayes_auto_learn_threshold_nonspam 0.1 # bayes_auto_learn_threshold_spam 13.0 bayes_expiry_max_db_size 300000 bayes_auto_expire 1 bayes_sql_override_username postfix # I don't understand what this setting does, nor why its postfix. Postfix has no intereaction with SA in my set-up as postfix pipes the mail into dovecot,and dovecot handles the spamc portion before filing the email. |bayes_store_module Mail::SpamAssassin::BayesStore::MySQL bayes_sql_dsn DBI:mysql:spamassassin:localhost bayes_sql_username |shamster_user |bayes_sql_password shamster||_password| ifplugin Mail::SpamAssassin::Plugin::Shortcircuit shortcircuit USER_IN_WHITELIST on shortcircuit SUBJECT_IN_WHITELIST on shortcircuit USER_IN_BLACKLIST on shortcircuit SUBJECT_IN_BLACKLIST on loadplugin Mail::SpamAssassin::Plugin::Rule2XSBody endif score RDNS_DYNAMIC 2.639 0.363 1.663 1.700 meta __PILL_PRICE_1 (0) meta __PILL_PRICE_2 (0) meta __PILL_PRICE_3 (0) -------------------- END local.cf ------------------------------- N.B Yes, I know there are some custom rules in the local.cf and these'll be lost after an upgrade of SA, but I have reasonable backups. * Questions Does the configuration above look correct? Will SA only write into the table bayes_vars, or will it touch other tables?
