Обсуждение: 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.
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@postgresql.org > [mailto:pgsql-admin-owner@postgresql.org]On Behalf Of fred > Sent: Wednesday, November 06, 2002 4:41 AM > To: pgsql-admin@postgresql.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@postgresql.org so that your > message can get through to the mailing list cleanly >
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@postgresql.org > > [mailto:pgsql-admin-owner@postgresql.org]On Behalf Of fred > > Sent: Wednesday, November 06, 2002 4:41 AM > > To: pgsql-admin@postgresql.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@postgresql.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@postgresql.org)
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@skyturn.net] > Sent: Wednesday, November 06, 2002 8:36 AM > To: nickf@ontko.com > Cc: pgsql-admin@postgresql.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@postgresql.org > > > [mailto:pgsql-admin-owner@postgresql.org]On Behalf Of fred > > > Sent: Wednesday, November 06, 2002 4:41 AM > > > To: pgsql-admin@postgresql.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@postgresql.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@postgresql.org) >
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@skyturn.net] > > Sent: Wednesday, November 06, 2002 8:36 AM > > To: nickf@ontko.com > > Cc: pgsql-admin@postgresql.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@postgresql.org > > > > [mailto:pgsql-admin-owner@postgresql.org]On Behalf Of fred > > > > Sent: Wednesday, November 06, 2002 4:41 AM > > > > To: pgsql-admin@postgresql.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@postgresql.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@postgresql.org) > > > > > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
Thank you very mutch. On Wednesday 6 November 2002 14: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@skyturn.net] > > Sent: Wednesday, November 06, 2002 8:36 AM > > To: nickf@ontko.com > > Cc: pgsql-admin@postgresql.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@postgresql.org > > > > [mailto:pgsql-admin-owner@postgresql.org]On Behalf Of fred > > > > Sent: Wednesday, November 06, 2002 4:41 AM > > > > To: pgsql-admin@postgresql.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@postgresql.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@postgresql.org)