Authentification

Hello,

I´m using PostgreSQL 7.1.2 (from Debian).  My pg_hba.conf looks like

# default
local        all                                           peer sameuser
host         all         127.0.0.1     255.0.0.0           ident sameuser
# added myself to cope with the problem
host         all         127.0.0.1     255.0.0.0           crypt

To check, whether users can connect via crypt method I wrote a small
python script:

#!/usr/bin/python

def hello():
     import sys
     from pg import DB
     conn = DB('test',user='testuser',passwd='test')
     x = conn.query("SELECT * from testtable")
     return x

print hello()


/var/log/postgresql.log shows:
Peer authentication failed for user 'testuser'


I can correctly log in on the Linux system with the testuser account
and the script works if I run it from this account *and* deleting
the passwd option from the connection string - but that´s the ident
authenification method.  With password option the connection can not
be established.

Moreover I have read the postgresql docs especially auth-methods.html.

I tried to alter the pg_shadow password using

  test=# alter user testuser with password 'test' ;

but I´m not sure if this works because of the strange sounding
paragraph in auth-methods.html:

   Note that using alternative passwords like this means that one can no
   longer use ALTER USER to change one's password. It will still appear
   to work but the password one is actually changing is not the password
   that the system will end up using.

I also gave those alternate passwords a try and did

 /usr/lib/postgresql/bin/pg_passwd /etc/postgresql/passwd
  Username: testuser
  New password:
  Re-enter new password:

and changed the pg_hba.conf line to

  host         all         127.0.0.1     255.0.0.0           crypt  passwd

But nothing changed.

Can anybody help me out this trouble?

Kind regards

        Andreas.