Обсуждение: ODBC problem authenticating

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