On Thu, 08 May 2008 12:29:19 +0800, Peter Santiago <[EMAIL PROTECTED]> wrote:
> If you have downloaded the source for dspam, look under the > src/tools.pgsql_drv when extracted. Use the virtual_users.sql script > to create the missing table. I've done that already: # su - pgsql -c 'cat /usr/local/share/examples/dspam/pgsql/virtual_users.sql | psql -U pgsql dspam' ERROR: relation "dspam_virtual_uids_seq" already exists ERROR: relation "dspam_virtual_uids" already exists ERROR: relation "id_virtual_uids_01" already exists ERROR: relation "id_virtual_uids_02" already exists Still get the error: cat junk-1.txt | dspam --mode=teft --user=colin --source=corpus --class=spam 37446: [05/08/2008 21:08:45] query error: ERROR: permission denied for relation dspam_virtual_uids : see sql.errors for more details 37446: [05/08/2008 21:08:45] query error: ERROR: permission denied for relation dspam_virtual_uids : see sql.errors for more details 37446: [05/08/2008 21:08:45] bailing on error -2 37446: [05/08/2008 21:08:45] received invalid result (! DSR_ISSPAM || DSR_INNOCENT) : -2 37446: [05/08/2008 21:08:45] query error: ERROR: permission denied for relation dspam_virtual_uids : see sql.errors for more details 37446: [05/08/2008 21:08:45] process_message returned error -2. dropping message. $ tail -2 /var/log/dspam/sql.errors [05/08/2008 21:08:45] 37446: ERROR: permission denied for relation dspam_virtual_uids : SELECT uid FROM dspam_virtual_uids WHERE username = 'colin' Other thoughts? Thanks. -- Colin Brace Amsterdam http://lim.nl !DSPAM:1011,4823512b150921954213407!
