Re: [dspam-users] another sql error

[Peter Santiago]

Quoting Colin Brace <[EMAIL PROTECTED]>:

On Mon, 5 May 2008 12:48:47 +0200, Bonnetot Jean-Daniel
<[EMAIL PROTECTED]> wrote:

Fri, 02 May 2008 02:34:43 +0200, Colin Brace:

OK. did that. Alas, another SQL error:

[05/02/2008 01:47:24] 11421: ERROR:  permission denied for relation
dspam_virtual_uids
: SELECT uid FROM dspam_virtual_uids WHERE username = 'colin'

Check your dspam SQL user and his permissions. Is he authorized to
read/write dspam_virtual_uids table?

Since I am very new to Postgres, I am using phpPgAdmin to deal with the
database. I see the following privileges are indicated for the dspam db:

Type    User/Group      CREATE  TEMPORARY       CONNECT         Grantor
public          No      Yes     Yes     dspam
user    dspam   Yes     Yes     Yes     dspam

I've run this command:

su - pgsql -c 'cat /usr/local/share/examples/dspam/pgsql/pgsql_objects.sql
| psql -U pgsql dspam'

so I assume the structure is set up correctly, but I don't seen anywhere to
configure permissions for the "dspam_virtual_uids" table; in fact, I don't
see this table anywhere. Is this something I need to do on the command
line?

Thanks, and excuses for my ignorance of postgres.

--
  Colin Brace
  Amsterdam
  http://lim.nl


!DSPAM:1011,48223359122631102810327!

--
Peter Santiago         [EMAIL PROTECTED]
My website:            www.psinergybbs.com
My spamtrap address:   [EMAIL PROTECTED]

----------------------------------------------------------------

                -- Prof. Seager, C&O 351
----------------------------------------------------------------
This message was sent using IMP, the Internet Messaging Program.

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. "This is lemma 1.1. We start a new chapter so the numbers all go back to one."

smime.p7s
Description: S/MIME Cryptographic Signature

!DSPAM:1011,482281a4122637928851567!