The user is running under tha name "apache". I tried creating the user "apache"
in pgsql and granting permission to that user, but that didn't work either,
which I find strange. It would seem that life is MUCH easier if Apache and
Postgres are installed on the same host, but that's not the case...
I'm reinstalling the apache machine now anyway, because I don't like the
way RH installed the rpm's
Steve
>-- Original Message --
>Reply-To: <nickf@ontko.com>
>From: "Nick Fankhauser" <nickf@ontko.com>
>To: "Steven Cuthbertson" <steven@tie.cl>,
> <pgsql-admin@postgresql.org>
>Subject: Re: [ADMIN] Permission on tables
>Date: Fri, 26 Apr 2002 09:24:55 -0500
>
>
>
>> grant ALL on mytable to PUBLIC;
>>
>> Q: Is this dangerous? What is encompassed by "ALL"? Read? Write?
>
>Sounds unwise to me, but I'm not a PHP-er.
>
>In the Tomcat/Apache world, I can tell you that we generally grant select
>on
>mytable to "www-data".
>"www-data is the user that Apache runs as by default. I'd suggest finding
>the Apache or PHP user & then granting only those privileges needed to only
>that user.
>
>Are you sure that you aren't just getting a more general rejection of your
>connection due to problem in pg_hba? You mention that the servers are
>separated. You could test the connectivity & authorization from X to Y by
>trying (from X) psql -hY
>
>regards,
>
>-Nick
>
>---------------------------------------------------------------------
>Nick Fankhauser
>
> nickf@doxpop.com Phone 1.765.965.7363 Fax 1.765.962.9788
>doxpop - Court records at your fingertips - http://www.doxpop.com/
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 4: Don't 'kill -9' the postmaster
________________________________________
Obtenga su direccion de correo en http://www.internetempresas.cl