Database permissions

From: Art Fore <art(dot)fore(at)comcast(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Database permissions
Date: 2005-02-09 02:13:24
Message-ID: 420971C4.2000103@comcast.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I had this working once before, but restarted the database and things
went to hell. This user authentication for postgresql I will have to say
is the most complex I have seen. Need a block diagram of how it works to
understand it.

Have .pgpass in postgres home directory, data directory is
/home/postgres/data Per the md5 instructions.

pg_shadow has postgres md5 password, and my password.

Host computer is suse 9.2 at 192.168.121.252

I can acces phproject database from windows machine with no problem.
I can access database with pgadmin3 from windows machine, no problem.

Can no longer access via ODBC on windows machine

Can no longer access from phppgadmin on windows machine

Can no longer access from webmin on host machine. All I get is
FATAL: IDENT authentication failed for user afore

or for user postgres

pg_hba.conf is below

#local all all trust
# IPv4-style local connections:
host MPC all 192.168.121.0 255.255.255.0 trust
# IPv6-style local connections:
#host all all ::1
ffff:ffff:ffff:ffff:ffff:ffff:ffff:ffff trust
#local all all
ident sameuser
local all all ident md5
host template1 all 192.168.121.0 255.255.255.0 trust
host phprojekt all 192.168.121.252 255.255.255.0 trust
host phpPgAdmin all 192.168.121.252 255.255.255.0 trust

Any help would be welcome.

Art

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David Garamond 2005-02-09 02:55:47 checking SQL statement/subexpression validity
Previous Message Art Fore 2005-02-09 01:30:23 Re: Hoow do you drop a column in a table