pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
User Admin in pgsql
4+ messages / 3 participants
[nested] [flat]

* User Admin in pgsql
@ 2004-12-15 08:14  daxiawj <daxiawj@gmail.com>
  0 siblings, 1 reply; 4+ messages in thread

From: daxiawj @ 2004-12-15 08:14 UTC (permalink / raw)
  To: pgsql-admin

Hello all,
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. 
I know that a SQL command Alter could de used to alternate my password,
I tried it like this:" alter user xxxx with encrypted password
'xxxxxxx';", But it doesn't work at all.
What can I do?

BTW: My OS is GNU/Debian Sid 3.1, PostGreSQL 7.4.6 Now.
Thank you!
-- 
Wang Jun@ Atmos. Dep. of Nju Nanjing Jiangsu China. 
GNU is Not Unix, BSD is Powerful,
Ada is Beautiful, Nju is Graceful.




^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: User Admin in pgsql
@ 2004-12-15 08:41  Michael Fuhr <mike@fuhr.org>
  parent: daxiawj <daxiawj@gmail.com>
  0 siblings, 0 replies; 4+ messages in thread

From: Michael Fuhr @ 2004-12-15 08:41 UTC (permalink / raw)
  To: daxiawj <daxiawj@gmail.com>; +Cc: pgsql-admin

On Wed, Dec 15, 2004 at 04:14:48PM +0800, daxiawj wrote:

> 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.

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



^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* [Re]:User Admin in pgsql
@ 2004-12-15 12:42  Wang Jun <daxiawj@gmail.com>
  0 siblings, 1 reply; 4+ messages in thread

From: Wang Jun @ 2004-12-15 12:42 UTC (permalink / raw)
  To: Michael Fuhr <mike@fuhr.org>; +Cc: pgsql-admin


> > 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.

Attachments:

pg_hba.conf (text/plain, 933B) download #This is my admin user account local all pgAdminWang password host all pgAdminWang 127.0.0.1 255.255.255.0 password host all pgAdminWang 192.168.0.114 255.255.255.0 password #this is Common user account local all wang password host all wang 127.0.0.1 255.255.255.255 password # System defaults, haven't changed yet. local all postgres ident sameuser local all all ident sameuser host all all 127.0.0.1 255.255.255.255 ident sameuser host all all ::1 ffff:ffff:ffff:ffff:ffff:ffff:ffff:ffff ident sameuser host all all ::ffff:127.0.0.1/128 ident sameuser host all all 0.0.0.0 0.0.0.0 reject
^ permalink raw reply [nested|flat] 4+ messages in thread

* Re: [Re]:User Admin in pgsql
@ 2004-12-15 16:59  Michael Fuhr <mike@fuhr.org>
  parent: Wang Jun <daxiawj@gmail.com>
  0 siblings, 0 replies; 4+ messages in thread

From: Michael Fuhr @ 2004-12-15 16:59 UTC (permalink / raw)
  To: Wang Jun <daxiawj@gmail.com>; +Cc: pgsql-admin

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/



^ permalink  raw  reply  [nested|flat] 4+ messages in thread


end of thread, other threads:[~2004-12-15 16:59 UTC | newest]

Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-12-15 08:14 User Admin in pgsql daxiawj <daxiawj@gmail.com>
2004-12-15 08:41 ` Michael Fuhr <mike@fuhr.org>
2004-12-15 12:42 [Re]:User Admin in pgsql Wang Jun <daxiawj@gmail.com>
2004-12-15 16:59 ` Re: [Re]:User Admin in pgsql Michael Fuhr <mike@fuhr.org>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox