Steve Have you tried connecting just using psql to make sure you've got authorization working over the network? It kind of sounds like that might the the issue.
-Nick > -----Original Message----- > From: Steven Cuthbertson [mailto:[EMAIL PROTECTED]] > Sent: Friday, April 26, 2002 2:24 PM > To: [EMAIL PROTECTED]; [EMAIL PROTECTED] > Subject: Re: [ADMIN] Permission on tables > > > 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 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]