Hi I'm trying to setup spamassassin with postgres for with bayes_sql, awl_sql, dcc, razor using sql user_pref etc.
I have configured the database with: http://spamassassin.apache.org/full/3.1.x/dist/sql/awl_pg.sql wget http://spamassassin.apache.org/full/3.1.x/dist/sql/bayes_pg.sql wget http://spamassassin.apache.org/full/3.1.x/dist/sql/userpref_pg.sql I'm using: spamassassin-3.1.3 postgresql-8.1.4 I can see that spamd is using the right sql user_pref but I get a lot of postgres encoding errors when scanning mails.
From mailllog:
Jul 6 04:07:48 BlackPete spamd[4192]: bayes: tok_get: SQL error: ERROR: invalid byte sequence for encoding "UTF8": 0xc829 Jul 6 04:07:48 BlackPete spamd[4192]: bayes: _put_token: SQL error: ERROR: invalid byte sequence for encoding "UTF8": 0xc829 I guess this has something to do with string-escaping in postgres. How do I solv this problem? Best regards, Martin
