Colin,
You need to create the virtual_users table with the
virtual_users.sql file from tools.pgsql_drv:
----
tools.pgsql_drv> more virtual_users.sql
/* $Id: virtual_users.sql,v 1.1 2004/10/24 20:51:55 jonz Exp $ */
CREATE SEQUENCE dspam_virtual_uids_seq;
CREATE TABLE dspam_virtual_uids (
uid smallint DEFAULT nextval('dspam_virtual_uids_seq') PRIMARY KEY,
username varchar(128)
) WITHOUT OIDS;
CREATE UNIQUE INDEX id_virtual_uids_01 ON dspam_virtual_uids(username);
CREATE UNIQUE INDEX id_virtual_uids_02 ON dspam_virtual_uids(uid);
----
Ken
On Thu, May 01, 2008 at 11:18:04PM +0200, Colin Brace wrote:
>
> Hi all,
>
> Anyone know what this sql error means and how to fix it?:
>
> [05/01/2008 22:50:59] 204: ERROR: relation "dspam_virtual_uids" does not
> exist
> : SELECT uid FROM dspam_virtual_uids WHERE username = '[EMAIL PROTECTED]'
>
> I've been trying for several days to get dspam working with postfix (under
> FreeBSD). Someone offlist said I needed to compile it with the virtual
> users option, which I did, even though I don't think I need it. Basically,
> I am just trying to set dspam up for use with a very small number of system
> users.
>
> Just now I tried to use the hash driver instead of Postgres:
>
> #StorageDriver /usr/local/lib/libpgsql_drv.so
> StorageDriver /usr/local/lib/libhash_drv.so
>
> no error message, but also nothing written to the log either, so I am not
> sure the sql error is my only problem at this point.
>
> Thanks.
>
> --
> Colin Brace
> Amsterdam
> http://lim.nl
>
>
