弁財天

ゴフマン「専門家を信じるのではなく、自分自身で考えて判断せよ」

関数rpad(bytea, integer, unknown)は存在しません

[Bug 6464] New: rpad needs its first argument to be of type text and not bytearray

spamd を起動中: 5月 07 08:53:53.720 [22975] warn: Use of uninitialized value $opt{"syslog-socket"} in lc at /usr/local/bin/spamd line 444.
trivial fix to: Use of uninitialized value $opt{"syslog-socket"} in lc

BayesianフィルタのDBにUTF-8のPostgreSQLを使うことはできない
ERROR: invalid byte sequence for encoding "UTF8": 0xf9 HINT: This error can also happen if the byte sequence does not match the encoding expected by the server, which is controlled by "client_encoding". STATEMENT: INSERT INTO bayes_token (id, token, spam_count, ham_count, atime) VALUES ($1,$2,$3,$4,$5) ERROR: invalid byte sequence for encoding "UTF8": 0xc402 HINT: This error can also happen if the byte sequence does not match the encoding expected by the server, which is controlled by "client_encoding". STATEMENT: SELECT spam_count, ham_count, atime FROM bayes_token WHERE id = $1 AND token = $2

/etc/mail/spamassassin/sql.cfは削除
$HOME/spamassassin/bayes_seen
$HOME/spamassassin/bayes_toks
のDBファイルに戻す

$ file bayes_* bayes_seen: Berkeley DB (Hash, version 9, native byte-order) bayes_toks: Berkeley DB (Hash, version 9, native byte-order) $

投稿されたコメント:

コメント
コメントは無効になっています。