If the table is the same as in my example (straight from
maia-pgsql.sql
file in the tarball) you should be fine. But then we still
got the
problem that your bayes_token table is empty right? Do you
have any
errors from postgresql in your logfiles ?(on my system it is
logging to
/var/log/messages)
When I tested postgresql these errors showed up in my
logfile :
Jul 31 13:00:06 freedom postgres[46681]: [3-1] ERROR:
invalid input
syntax for type bytea
Jul 31 13:00:06 freedom postgres[46681]: [3-2] STATEMENT:
INSERT INTO
bayes_token
Jul 31 13:00:06 freedom postgres[46681]: [3-3]
(id,
token, spam_count, ham_count, atime)
Jul 31 13:00:06 freedom postgres[46681]: [3-4]
VALUES ($1,$2,$3,$4,$5)
Can you find something like this in your log files ? This
could explain
why your bayes_token table is empty. Because errors occur on
insert
statements.
If you really want to be sure that dcc, pyzor and razor are
working you
could run maia with the following command:
amavisd-maia debug-sa
Good luck,
Jeffrey Schilperoord
-----Oorspronkelijk bericht-----
Van: Robert Fitzpatrick [mailto:lists webtent.net]
Verzonden: maandag 20 augustus 2007 20:31
Aan: Jeffrey Schilperoord
CC: Maia Users
Onderwerp: RE: [Maia-users] bayes not working?
On Mon, 2007-08-20 at 20:05 +0200, Jeffrey Schilperoord
wrote:
> Hi,
>
> CREATE TABLE bayes_token (
> id INTEGER NOT NULL DEFAULT '0',
> token BYTEA NOT NULL DEFAULT '',
> spam_count INTEGER NOT NULL DEFAULT '0',
> ham_count INTEGER NOT NULL DEFAULT '0',
> atime INTEGER NOT NULL DEFAULT '0',
> PRIMARY KEY (id, token)
> ) WITHOUT OIDS;
> CREATE INDEX bayes_token_idx1 ON bayes_token (token);
>
> This is the table definition for bayes_token pgsql
(from the maia
> tarball) The only real difference i see that in your
example that i
cant
> really find a primary key (maybe i overlooked it).
I do have 'PRIMARY KEY (id, token)', do you mean the primary
key I have
in my table should not be there?
>
> [75959] dbg: dcc: local tests only, disabling DCC
>
> Did you see that line from the output of spamassassin
--lint ? I think
> this command doesnt look at the amavisd.conf file and
uses only local
> tests by default.
So, no worries then? Yeah, I was pretty sure the DCC and the
lot was
working.
--
Robert
_______________________________________________
Maia-users mailing list
Maia-usersrenaissoft.com
http://www.renaissoft.com/mailman/listinfo/maia-users
|
