pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedUser 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