Обсуждение: ODBC error - Password authentication
Hi, couldyou kindly help me out. I have the PostgreSQL ODBC driver installed, however I can't seem to connect to my PostgreSQL database when I set the the authentication method to md5 in my pg_hba.conf file. I get a password authentication error. However when I change the authentication to password I do not a password authentication error. Any idea what the problem is ?? thanks Femi BT Group Registered office: 81 Newgate Street London EC1A 7AJ Registered in England and Wales no. 419081 This electronic message contains information from BT Group plc which may be privileged or confidential. The information is intended to be for the use of the individual(s) or entity named above. If you are not the intended recipient be aware that any disclosure, copying, distribution or use of the contents of this information is prohibited. If you have received this electronic message in error, please notify us by telephone or email (to the numbers or address above) immediately.
> -----Original Message----- > From: babafemi.osoba@bt.com [mailto:babafemi.osoba@bt.com] > Sent: 07 June 2002 11:00 > To: pgsql-odbc@postgresql.org > Subject: [ODBC] ODBC error - Password authentication > > > Hi, > > couldyou kindly help me out. I have the PostgreSQL ODBC > driver installed, however I can't seem to connect to my > PostgreSQL database when I set the the authentication method > to md5 in my pg_hba.conf file. I get a password > authentication error. However when I change the > authentication to password I do not a password authentication > error. Any idea what the problem is ?? > What version of the driver do you have installed? Regards, Dave.
> -----Original Message----- > From: babafemi.osoba@bt.com [mailto:babafemi.osoba@bt.com] > Sent: 07 June 2002 14:33 > To: Dave Page > Subject: RE: [ODBC] ODBC error - Password authentication > > > > Version: 7.01.00.09 Hmm, that's new enough. Do you have any other entries in pg_hba.conf that may be confusing matters? Regards, Dave. > > -----Original Message----- > > From: Dave Page [SMTP:dpage@vale-housing.co.uk] > > Sent: 07 June 2002 14:30 > > To: babafemi.osoba; pgsql-odbc > > Subject: RE: [ODBC] ODBC error - Password authentication > > > > > > > -----Original Message----- > > > From: babafemi.osoba@bt.com [mailto:babafemi.osoba@bt.com] > > > Sent: 07 June 2002 11:00 > > > To: pgsql-odbc@postgresql.org > > > Subject: [ODBC] ODBC error - Password authentication > > > > > > > > > Hi, > > > > > > couldyou kindly help me out. I have the PostgreSQL ODBC > > > driver installed, however I can't seem to connect to my > > > PostgreSQL database when I set the the authentication method > > > to md5 in my pg_hba.conf file. I get a password > > > authentication error. However when I change the > > > authentication to password I do not a password authentication > > > error. Any idea what the problem is ?? > > > > > > > What version of the driver do you have installed? > > > > Regards, Dave. >
Please keep replies on the list... > -----Original Message----- > From: babafemi.osoba@bt.com [mailto:babafemi.osoba@bt.com] > Sent: 07 June 2002 15:23 > To: Dave Page > Subject: RE: [ODBC] ODBC error - Password authentication > > > These are the entries in my pg_hba.conf file. > > local all > trust > host all 127.0.0.1 > 255.255.255.255 md5 > host sameuser 132.146.232.115 255.255.255.255 > md5 > > The ODBC driver is installed on machine 132.146.232.115. > Interestingly, I can connect to the DB with psql on the local > machine (127.0.0.1) using md5 without any problems. I have > attached the conf file. > Are you sure your local psql connection isn't being allowed by the line: local all trust I have never tried using sameuser (I'm hacking code on my dev box and can't try it right now) - can you try changing that to 'all' temporarily, and testing again please? Regards, Dave.
> -----Original Message----- > From: babafemi.osoba@bt.com [mailto:babafemi.osoba@bt.com] > Sent: 07 June 2002 15:43 > To: Dave Page > Subject: RE: [ODBC] ODBC error - Password authentication > > > Right, I have just changed sameuser to 'all' and removed the line > > local all trust. > > Unfortunately I still have the same situation i.e. plsql > conects fine but ODBC driver returns authentication error for user. > That's me out of ideas I'm afraid. Anyone else? Regards, Dave.
babafemi.osoba@bt.com wrote: > > Hi, > > couldyou kindly help me out. I have the PostgreSQL ODBC driver > installed, however I can't seem to connect to my PostgreSQL > database when I set the the authentication method to md5 in my > pg_hba.conf file. I get a password authentication error. However > when I change the authentication to password I do not a password > authentication error. Any idea what the problem is ?? Could you send me the Mylog output ? regards, Hiroshi Inoue http://w2422.nsk.ne.jp/~inoue/