hide mysql_servers = localhost/psa/admin/password
MYSQL_Q_USERS = SELECT concat(mail_name,'@',name) ¥
FROM mail,domains ¥
WHERE dom_id=domains.id ¥
AND concat(mail_name,'@',name)='${quote_mysql:$local_part}@${quote_mysql:$domain}';
MYSQL_Q_ALIAS = SELECT concat(alias,'@',name) ¥
FROM mail,domains,mail_aliases ¥
WHERE mn_id=mail.id=dom_id=domains.id ¥
AND concat(alias,'@',name)='${quote_mysql:$local_part}@${quote_mysql:$domain}';
local_system:
driver = redirect
file_transport = address_file
pipe_transport = address_pipe
data = ${lookup{$local_part}wildlsearch{/etc/aliases}}
# data = ${lookup{$local_part}lsearch{/etc/aliases}}
condition = "${if eq{$domain}{$primary_hostname} {yes}{no}}"
retry_use_local_part
pass_router = route_amavis
bayes_store_module Mail::SpamAssassin::BayesStore::MySQL
bayes_sql_dsn DBI:driver:database:hostname[:port]
bayes_sql_username dbusername
bayes_sql_password dbpassword
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;
CREATE TABLE bayes_global_vars (
variable varchar(30) NOT NULL default '',
value varchar(200) NOT NULL default '',
PRIMARY KEY (variable)
) TYPE=MyISAM;
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)
) TYPE=MyISAM;
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),
INDEX bayes_token_idx1 (token),
INDEX bayes_token_idx2 (id, atime)
) TYPE=MyISAM;
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)
) TYPE=MyISAM;
