From: | Robert Treat <xzilla(at)users(dot)sourceforge(dot)net> |
---|---|
To: | nickf(at)ontko(dot)com |
Cc: | fred <fred(at)skyturn(dot)net>, pgsql-admin(at)postgresql(dot)org |
Subject: | Re: USERS |
Date: | 2002-11-06 18:42:36 |
Message-ID: | 1036608156.8099.19.camel@camel |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Are you using phpPgAdmin? If so I can help you out with that, just lmk.
In the mean time, look for some FATAL messages in your log file that
might further explain why the connection is failing.
Robert Treat
On Wed, 2002-11-06 at 08:46, Nick Fankhauser wrote:
> Fred-
>
> I'm not familiar with phppgsql, so I can't help with the specific problem
> there, but perhaps someone else on the list can help with the next step. You
> do seem to be getting a connection at this point, but are having some sort
> of authorization problem in PHP.
>
> You may also want to try the pgsql-php mailing list.
>
> -Nick
>
> > -----Original Message-----
> > From: fred [mailto:fred(at)skyturn(dot)net]
> > Sent: Wednesday, November 06, 2002 8:36 AM
> > To: nickf(at)ontko(dot)com
> > Cc: pgsql-admin(at)postgresql(dot)org
> > Subject: Re: [ADMIN] USERS
> >
> >
> > Thank you very much.
> >
> > I have follow the instruction.
> > I start postmaster like that:
> > pg_ctl start -D /var/lib/pgsql/data/ -l /tmp/pglog
> >
> > and when I try connect with phpPgsql, I have :
> > /usr/bin/postmaster child[4749]: starting with (postgres -d16 -v131072 -p
> > fred
> > in the log file (so i think that the connection is good), but I have :
> > Access denied.
> > on phpPgsql web page.
> >
> > my pg_hba.conf:
> >
> > local all trust
> > host all 127.0.0.1 255.255.255.255 trust
> > host all 192.168.0.125 255.255.255.0 password passwords
> >
> > If you have little time more to help me,
> > it will be very good.
> >
> >
> >
> >
> >
> > On Wednesday 6 November 2002 11:49, you wrote:
> > > Fred:
> > >
> > > Try following this link to the interactive Doc:
> > > http://www.postgresql.org/idocs/
> > >
> > >
> > > This link will tell you how to allow tcp/ip access using the pg_hba.conf
> > > file:
> > > http://www.postgresql.org/idocs/index.php?client-authentication.html
> > >
> > >
> > >
> > > This link will tell you how to make sure the server is accepting ip
> > > connections (search for tcpip_socket)
> > > http://www.postgresql.org/idocs/index.php?runtime-config.html
> > >
> > > > -----Original Message-----
> > > > From: pgsql-admin-owner(at)postgresql(dot)org
> > > > [mailto:pgsql-admin-owner(at)postgresql(dot)org]On Behalf Of fred
> > > > Sent: Wednesday, November 06, 2002 4:41 AM
> > > > To: pgsql-admin(at)postgresql(dot)org
> > > > Subject: [ADMIN] USERS
> > > >
> > > >
> > > > Hello,
> > > >
> > > > I'm new on the list.
> > > > I have to use the sgbdr postgres for my work.
> > > > Everything is ok 'localy' but I have permissions trouble by tcp.
> > > > Is someone now good docs about the users management whith postgres ?
> > > > Thank's a lot for your support.
> > > >
> > > > ---------------------------(end of
> > broadcast)---------------------------
> > > > TIP 3: if posting/reading through Usenet, please send an appropriate
> > > > subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> > > > message can get through to the mailing list cleanly
> > >
> > > ---------------------------(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)
> >
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
From | Date | Subject | |
---|---|---|---|
Next Message | Jeff Self | 2002-11-06 19:25:23 | Set Datestyle doesn't appear to be working |
Previous Message | Michael Ansley (UK) | 2002-11-06 17:55:47 | Re: schema design |