Thread: [Re]:User Admin in pgsql

[Re]:User Admin in pgsql

From
Wang Jun
Date:
> > After I Updatded my pgsql from 7.3 to 7.4.6 in debian with
> "aptitude", I
> > found that my admin user account's password has gone--everytime when
> I
> > login into  psql, I don't need type my password any more, and every
> > other user account too.
>
> Have you looked at pg_hba.conf?  See the "Client Authentication"
> chapter in the documentation for details.


Thanks for your help!
I have modified my pg_hda.conf as the DOC said, and I can login with my
password use "psql" in terminal. But it still remains a problem that I
can't acess to my database through webclients such as PhpPgAdmin and my
other phpclient.

What's wrong then?
Thank you again!


--
Wang Jun@ Atmos. Dep. of Nju Nanjing Jiangsu China.
GNU is Not Unix, BSD is Powerful,
Ada is Beautiful, Nju is Graceful.

Attachment

Re: [Re]:User Admin in pgsql

From
Michael Fuhr
Date:
On Wed, Dec 15, 2004 at 08:42:17PM +0800, Wang Jun wrote:

> I have modified my pg_hda.conf as the DOC said, and I can login with my
> password use "psql" in terminal. But it still remains a problem that I
> can't acess to my database through webclients such as PhpPgAdmin and my
> other phpclient.

What's the exact error message?  What's different between the psql
connections and the PHP connections?  One possibility is that psql
is using a local (Unix socket) connection and PHP is using a host
(TCP/IP) connection, and the server isn't accepting TCP/IP connections
on the required interface.  Have you looked at the tcpip_socket and
virtual_host settings in postgresql.conf?  Be sure to restart
PostgreSQL if you change anything.

The "Client Authentication" and "Server Run-time Environment"
chapters of the documentation describe how to configure pg_hba.conf
and postgresql.conf.

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/