\u4ed5\u4e8b\u3067\u307e\u305f spamassassin \u3092\u4f7f\u3063\u3066\u307e\u3059\u3002\u4eca\u56de\u306f\u5ff5\u9858\u306e FreeBSD postfix postgresql\u3000\u306e\u7d44\u307f\u5408\u308f\u305b\u3067\u3059\u3002
\n\u3084\u3071\u308a postfix \u3067\u306a\u3044\u3068\u3002<\/p>\n
maillog \u3067\u3001<\/p>\n
spamd: still running as root: user not specified with -u, not found, or set to root, falling back to nobody<\/p>\n
\u307f\u305f\u3044\u306a\u30a8\u30e9\u30fc\u304c\u51fa\u307e\u3057\u305f\u3002
\n\u306a\u3093\u304bspamd\u304croot\u3067\u52d5\u3044\u3066\u308b\u307f\u305f\u3044\u306a\u611f\u3058\u3089\u3057\u3044\u3067\u3059\u3002\u3067\u3059\u306e\u3067\u3001<\/p>\n
\/usr\/local\/etc\/rc.d\/sa-spamd\u3000\u3092<\/p>\n
ommand_args=”-d -d -x -r -v -q -u hogehoge -A 202.211.xx.xx -r ${pidfile}”<\/p>\n
\u3067 -u hogehoge \u307f\u305f\u3044\u306a\u611f\u3058\u3067\u5225\u306e\u30e6\u30fc\u30b6\u30fc\u306b\u3057\u3066\u3042\u3052\u308b\u3068\u884c\u3051\u305d\u3046\u3067\u3059\u3002<\/p>\n
\u3042\u3068\u3001-A 202.211.xx.xx \u306f\u3001<\/p>\n
spamd[40410]: spamd: unauthorized connection from noname.freedom.ne.jp [202.211.xx.xx] at port 24135 at \/usr\/local\/bin\/spamd line 1271.<\/p>\n
\u304cmaillog\u306b\u51fa\u305f\u6642\u306e\u5bfe\u51e6\u3067\u3059\u3002\u306a\u3093\u304b\u3053\u3046\u3057\u306a\u3044\u3068\u3001127.0.0.1\u304b\u3089\u3057\u304bspamd\u306f\u53d7\u3051\u4ed8\u3051\u3066\u304f\u308c\u306a\u3044\u307f\u305f\u3044\u3067\u3059\u3002<\/p>\n
pgsql\u306e\u5834\u5408\u306e\/usr\/local\/etc\/mail\/spamassassin\/sql.cf<\/p>\n
user_scores_dsn DBI:Pg:dbname=spamassassin;host=localhost;port=5432
\nuser_scores_sql_password xxxxxxx
\nuser_scores_sql_username zzzzzzz
\n\u00d7user_scores_sql_custom_query SELECT preference, value FROM _TABLE_ WHERE username = _USERNAME_ OR username = ‘$GLOBAL’ OR username = CONCAT(‘%’,_DOMAIN_) ORDER BY username ASC
\n\u25cbuser_scores_sql_custom_query SELECT preference, value FROM _TABLE_ WHERE username = _USERNAME_ OR username = ‘$GLOBAL’ OR username = ‘%’ || _DOMAIN_ ORDER BY username ASC<\/p>\n
\u203bpostgresql\u3067\u306fconcat\u306f\u4f7f\u3048\u306a\u3044\u3002<\/p>\n
pgsql\u306e\u5834\u5408\u306euserpref\u30c6\u30fc\u30d6\u30eb\u4f5c\u6210<\/p>\n
userpref<\/p>\n
http:\/\/www.koders.com\/sql\/fid0DF2E1AD66C6EB4CE480765A739AD867D8EA4A07.aspx?s=update<\/p>\n
CREATE TABLE userpref (
\n prefid bigserial NOT NULL unique primary key,
\n username varchar(100) NOT NULL,
\n preference varchar(30) NOT NULL,
\n value varchar(100) NOT NULL
\n);
\nCREATE INDEX userpref_username_idx ON userpref(username);<\/p>\n
pgsql\u306e\u5834\u5408\u306eawlf\u30c6\u30fc\u30d6\u30eb\u4f5c\u6210<\/p>\n
http:\/\/www.opensource.apple.com\/source\/SpamAssassin\/SpamAssassin-124.5\/SpamAssassin\/sql\/awl_pg.sql<\/p>\n
CREATE TABLE awl (
\n username varchar(100) NOT NULL default ”,
\n email varchar(200) NOT NULL default ”,
\n ip varchar(10) NOT NULL default ”,
\n count bigint default ‘0’,
\n totscore float default ‘0’
\n);
\nCREATE UNIQUE INDEX awl_pkey ON awl (username,email,ip);<\/p>\n
pgsql\u306e\u5834\u5408\u306ebayes\u30c6\u30fc\u30d6\u30eb\u4f5c\u6210<\/p>\n
http:\/\/svn.apache.org\/repos\/asf\/spamassassin\/branches\/3.0\/sql\/bayes_pg.sql
\nCREATE TABLE bayes_expire (
\n id integer NOT NULL default ‘0’,
\n runtime integer NOT NULL default ‘0’
\n);<\/p>\n
CREATE INDEX bayes_expire_idx1 ON bayes_expire (id);<\/p>\n
CREATE TABLE bayes_global_vars (
\n variable varchar(30) NOT NULL default ”,
\n value varchar(200) NOT NULL default ”,
\n PRIMARY KEY (variable)
\n);<\/p>\n
INSERT INTO bayes_global_vars VALUES (‘VERSION’,’3′);<\/p>\n
CREATE TABLE bayes_seen (
\n id integer NOT NULL default ‘0’,
\n msgid varchar(200) NOT NULL default ”,
\n flag character(1) NOT NULL default ”,
\n PRIMARY KEY (id,msgid)
\n);<\/p>\n
CREATE TABLE bayes_token (
\n id integer NOT NULL default ‘0’,
\n token char(5) NOT NULL default ”,
\n spam_count integer NOT NULL default ‘0’,
\n ham_count integer NOT NULL default ‘0’,
\n atime integer NOT NULL default ‘0’,
\n PRIMARY KEY (id,token)
\n);<\/p>\n
CREATE TABLE bayes_vars (
\n id serial NOT NULL,
\n username varchar(200) NOT NULL default ”,
\n spam_count integer NOT NULL default ‘0’,
\n ham_count integer NOT NULL default ‘0’,
\n token_count integer NOT NULL default ‘0’,
\n last_expire integer NOT NULL default ‘0’,
\n last_atime_delta integer NOT NULL default ‘0’,
\n last_expire_reduce integer NOT NULL default ‘0’,
\n oldest_token_age integer NOT NULL default ‘2147483647’,
\n newest_token_age integer NOT NULL default ‘0’,
\n PRIMARY KEY (id)
\n);<\/p>\n
CREATE INDEX bayes_vars_idx1 ON bayes_vars (username);<\/p>\n
smtp auth\u306b\u3064\u3044\u3066\u306f\u3053\u3053\u304c\u3059\u3054\u304f\u53c2\u8003\u306b\u306a\u308a\u307e\u3059\u3002
\nhttp:\/\/satospo.sakura.ne.jp\/blog_archives\/tech\/centos\/postfix_smtpauth.html<\/p>\n","protected":false},"excerpt":{"rendered":"
\u4ed5\u4e8b\u3067\u307e\u305f spamassassin \u3092\u4f7f\u3063\u3066\u307e\u3059\u3002\u4eca\u56de\u306f\u5ff5\u9858\u306e FreeBSD postfix postgresql\u3000\u306e\u7d44\u307f\u5408\u308f\u305b\u3067\u3059\u3002 \u3084\u3071\u308a postfix \u3067\u306a\u3044\u3068\u3002 maillog \u3067\u3001 spamd: stil […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[],"class_list":["post-153","post","type-post","status-publish","format-standard","hentry","category-8"],"_links":{"self":[{"href":"https:\/\/www.freedom.ne.jp\/hide\/hogehoge\/index.php?rest_route=\/wp\/v2\/posts\/153","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.freedom.ne.jp\/hide\/hogehoge\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.freedom.ne.jp\/hide\/hogehoge\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.freedom.ne.jp\/hide\/hogehoge\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.freedom.ne.jp\/hide\/hogehoge\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=153"}],"version-history":[{"count":3,"href":"https:\/\/www.freedom.ne.jp\/hide\/hogehoge\/index.php?rest_route=\/wp\/v2\/posts\/153\/revisions"}],"predecessor-version":[{"id":157,"href":"https:\/\/www.freedom.ne.jp\/hide\/hogehoge\/index.php?rest_route=\/wp\/v2\/posts\/153\/revisions\/157"}],"wp:attachment":[{"href":"https:\/\/www.freedom.ne.jp\/hide\/hogehoge\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=153"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.freedom.ne.jp\/hide\/hogehoge\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=153"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.freedom.ne.jp\/hide\/hogehoge\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=153"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}