ODBC problem authenticating - Mailing list pgsql-admin

From Patrick Meylemans
Subject ODBC problem authenticating
Date
Msg-id 5.2.0.9.0.20030307133313.04566528@server04.site04.wtcm.be
Whole thread Raw
List pgsql-admin
Dear,

I'm running postgresql 7.3.2, the pg_hba.conf file :

# TYPE  DATABASE    USER        IP-ADDRESS        IP-MASK           METHOD

local   all         all                                             trust
host    all         all         127.0.0.1         255.255.255.255   trust
host    all         all         172.16.0.131      255.255.255.255   password passwd

The passwd file in the data directory :
 
[root@shadow data]# grep mey2 passwd
mey2:SL/.8laZSbQ1Q

Check if the given password is correct :

[root@shadow data]# perl -e "print crypt("jefke","SL")"
SL/.8laZSbQ1Q

When connecting to this server with ODBC (username mey2 password jefke) I get the message :

An error has occured ...
Number: -2147217843
Description: FATAL: Password authentication failed for user mey2

I'm getting the same message if i try another application (access) and use an ODBC link

It was working till version 7.2.3 ....

Kind regards

Patrick Meylemans

pgsql-admin by date:

Previous
From: LORENZ
Date:
Subject: Fatal Error
Next
From: Stephan Szabo
Date:
Subject: Re: Appliying Rules and Triggers