| From: | Patrick Meylemans <Patrick(dot)Meylemans(at)wtcm(dot)be> |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org |
| Subject: | ODBC problem authenticating |
| Date: | 2003-03-07 12:44:18 |
| Message-ID: | 5.2.0.9.0.20030307133313.04566528@server04.site04.wtcm.be |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)shadow data]# grep mey2 passwd
mey2:SL/.8laZSbQ1Q
Check if the given password is correct :
[root(at)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrew Sullivan | 2003-03-07 13:29:19 | Re: Fatal Error |
| Previous Message | LORENZ | 2003-03-07 12:28:54 | Fatal Error |