nach langem hin und her geht jetzt mein spamassassin mit der mysql verbindung.
leider klappt noch einiges nicht.
hier mal das system.
die /etc/default/spamassassin sieht so aus:
Code: Select all
ENABLED=1
OPTIONS="--max-children 5 --nouser-config --sql-config"
Code: Select all
#
# User scores (SQL)
#
user_scores_dsn DBI:mysql:antispam:localhost
user_scores_sql_username antispam
user_scores_sql_password xxx
user_scores_sql_custom_query SELECT preference, value FROM userpref WHERE username = _USERNAME_ ORDER BY username ASC
#
# AWL
#
auto_whitelist_factory Mail::SpamAssassin::SQLBasedAddrList
user_awl_dsn DBI:mysql:antispam:localhost
user_awl_sql_username antispam
user_awl_sql_password xxx
user_awl_sql_table awl
#
# Bayes
#
bayes_store_module Mail::SpamAssassin::BayesStore::SQL
bayes_sql_dsn DBI:mysql:antispam:localhost
bayes_sql_username antispam
bayes_sql_password xxx
bayes_sql_override_username vmail
bayes_auto_learn 1
bayes_auto_learn_threshold_nonspam 0.1
bayes_auto_learn_threshold_spam 12.0
# How many hits before a message is considered spam.
required_score 4.0
# Encapsulate spam in an attachment (0=no, 1=yes, 2=safe)
report_safe 1
# Enable the Bayes system
use_bayes 1
# Enable Bayes auto-learning
bayes_auto_learn 1
# Enable or disable network checks
skip_rbl_checks 0
use_razor2 1
use_dcc 1
use_pyzor 1
# Mail using languages used in these country codes will not be marked
# as being possibly spam in a foreign language.
ok_languages all
# Mail using locales used in these country codes will not be marked
# as being possibly spam in a foreign language.
ok_locales all
Code: Select all
--
-- Datenbank: `antispam`
--
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `awl`
--
CREATE TABLE `awl` (
`username` varchar(100) NOT NULL default '',
`email` varchar(200) NOT NULL default '',
`ip` varchar(10) NOT NULL default '',
`count` int(11) default '0',
`totscore` float default '0',
PRIMARY KEY (`username`,`email`,`ip`)
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `bayes_expire`
--
CREATE TABLE `bayes_expire` (
`id` int(11) NOT NULL default '0',
`runtime` int(11) NOT NULL default '0',
KEY `bayes_expire_idx1` (`id`)
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `bayes_global_vars`
--
CREATE TABLE `bayes_global_vars` (
`variable` varchar(30) NOT NULL default '',
`value` varchar(200) NOT NULL default '',
PRIMARY KEY (`variable`)
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `bayes_seen`
--
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`)
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `bayes_token`
--
CREATE TABLE `bayes_token` (
`id` int(11) NOT NULL default '0',
`token` char(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`),
KEY `bayes_token_idx1` (`token`),
KEY `bayes_token_idx2` (`id`,`atime`)
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `bayes_vars`
--
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 KEY `bayes_vars_idx1` (`username`)
) TYPE=MyISAM AUTO_INCREMENT=3 ;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `userpref`
--
CREATE TABLE `userpref` (
`username` varchar(100) NOT NULL default '',
`preference` varchar(50) NOT NULL default '',
`value` varchar(100) NOT NULL default '',
`prefid` int(11) NOT NULL auto_increment,
PRIMARY KEY (`prefid`),
KEY `username` (`username`)
) TYPE=MyISAM AUTO_INCREMENT=10 ;
Code: Select all
X-Spam-Checker-Version: SpamAssassin 3.0.3 (2005-04-27) on enterprise
X-Spam-Level:
X-Spam-Status: No, score=0.0 required=4.0 tests=none autolearn=ham
version=3.0.3
die userprefs werden also noch nicht beachtet.
warum nicht? kann mir jemand helfen?