From: | Barker <barkerds(at)snybufaf(dot)buffalostate(dot)edu> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Warning: PostgreSQL query failed: ERROR: [my_tabel]: |
Date: | 2002-08-09 12:39:47 |
Message-ID: | Pine.OSF.4.05.10208090837020.18518-100000@snybufaf.buffalostate.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Yes, the webserver is apache, and read/write permission is granted
as seen below.
The example below shows that the permission-denied problem happens
in the Unix mode too for the apache user, but not for the postgres
superuser.
--------------------------------------------------------
[root(at)linux5 octave]# psql --version
psql (PostgreSQL) 7.2.1
...
[root(at)linux5 octave]# psql -U apache octave
Welcome to psql, the PostgreSQL interactive terminal.
...
octave=> \z
Access privileges for database "octave"
Table | Access privileges
-------+--------------------------------
form | {=,postgres=arwdRxt,apache=rw}
use | {=,postgres=arwdRxt,apache=rw}
(2 rows)
octave=> INSERT INTO use VALUES ('date', 'time', 'ip', 'port', 'Mozilla'
);
ERROR: use: Permission denied.
-------------------------------------------------------------------
Thanks for helping,
Steve Barker
On Fri, 9 Aug 2002, Cornelia Boenigk wrote:
> Hi Steve
>
> Does the webserver have the privileges to insert records in your
> tables?
> Maybe you have to grant this rights.
>
> See the GRANT statement in the pg docs for information.
>
> regards
> Conni
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
>
From | Date | Subject | |
---|---|---|---|
Next Message | Nigel J. Andrews | 2002-08-09 12:51:36 | Re: Warning: PostgreSQL query failed: ERROR: [my_tabel]: |
Previous Message | frbn | 2002-08-09 12:31:57 | Re: handling transactions from C (libpq) |