ODBC problem authenticating
От | Patrick Meylemans |
---|---|
Тема | ODBC problem authenticating |
Дата | |
Msg-id | 5.2.0.9.0.20030307133313.04566528@server04.site04.wtcm.be обсуждение исходный текст |
Список | 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
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 по дате отправления: