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: <[EMAIL PROTECTED]> >From: "Nick Fankhauser" <[EMAIL PROTECTED]> >To: "Steven Cuthbertson" <[EMAIL PROTECTED]>, > <[EMAIL PROTECTED]> >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 > > [EMAIL PROTECTED] 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 ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
