Re: bayes not working?

On Mon, 2007-08-20 at 22:02 +0200, Jeffrey Schilperoord
wrote:
> 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. 

Thanks again....

mx1# grep -i "postgres.*error" /var/log/messages
Aug 20 16:00:07 mx1 postgres[79809]: [5-1] ERROR:  function
put_tokens(integer, "unknown", integer, integer,
integer) does not exist at character 8
Aug 20 16:16:12 mx1 postgres[80227]: [5-1] ERROR:  function
put_tokens(integer, "unknown", integer, integer,
integer) does not exist at character 8
Aug 20 16:16:49 mx1 postgres[80234]: [5-1] ERROR:  function
put_tokens(integer, "unknown", integer, integer,
integer) does not exist at character 8
Aug 20 16:18:20 mx1 postgres[80276]: [5-1] ERROR:  function
put_tokens(integer, "unknown", integer, integer,
integer) does not exist at character 8
Aug 20 16:22:39 mx1 postgres[80403]: [5-1] ERROR:  function
put_tokens(integer, "unknown", integer, integer,
integer) does not exist at character 8
Aug 20 16:23:08 mx1 postgres[80447]: [5-1] ERROR:  function
put_tokens(integer, "unknown", integer, integer,
integer) does not exist at character 8
Aug 20 16:23:40 mx1 postgres[80454]: [5-1] ERROR:  function
put_tokens(integer, "unknown", integer, integer,
integer) does not exist at character 8

Function is not there nor in your sql. Does this help...

http://w
ww.maiamailguard.com/maia/ticket/420

Yes, looks like I don't have my bayes_pg.sql file loaded
for
SpamAssassin...just loaded the current copy of bayes_pg.sql
from SA
source, let's see what happens. It's a test machine with a
good backup,
but I got my functions now, ran process_quarantine and my
tokens are
comin' in  

mx1# psql -U vscan maia <
/usr/local/share/doc/p5-Mail-SpamAssassin/sql/bayes_pg.sql
ERROR:  relation "bayes_expire" already exists
ERROR:  relation "bayes_expire_idx1" already
exists
ERROR:  relation "bayes_global_vars" already
exists
ERROR:  duplicate key violates unique constraint
"bayes_global_vars_pkey"
ERROR:  relation "bayes_seen" already exists
ERROR:  relation "bayes_token" already exists
ERROR:  relation "bayes_token_idx1" already
exists
NOTICE:  CREATE TABLE will create implicit sequence
"bayes_vars_id_seq1" for serial column
"bayes_vars.id"
ERROR:  relation "bayes_vars" already exists
ERROR:  relation "bayes_vars_idx1" already exists
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION

-- 
Robert

_______________________________________________
Maia-users mailing list
Maia-usersrenaissoft.com
http://www.renaissoft.com/mailman/listinfo/maia-users