connection weirdness from MS Access when using ident and password

Поиск
Список
Период
Сортировка
От David M. Kaplan
Тема connection weirdness from MS Access when using ident and password
Дата
Msg-id 3D0EAAFB.7060404@ucdavis.edu
обсуждение исходный текст
Список pgsql-odbc
Hi,

I recently experienced a weird bug with the ODBC driver (or postgresql).
 I am running:

psqlodbc-07_02_0001
postgresql-server-7.2.1-5

I was trying to connect to a database using MS Access.  Initially, my
pg_hba.conf looked like:

host       all         127.0.0.1     0.0.0.0    ident    sameuser
host    all    192.168.1.2    255.255.255.128    password

where my machine is 192.168.1.1 and the MS client is 192.168.1.2.
 Connecting using ODBC failed with this configuration stating:

FATAL 1: IDENT authentification failed for user 'me' (#210)

Then I changed the order of the lines in my configuration file:

host    all    192.168.1.2    255.255.255.128    password
host       all         127.0.0.1     0.0.0.0    ident    sameuser

Now the ODBC connection worked with out problems.  In the first case, it
seems to be trying to use IDENT authentification, even though that
should only apply to localhost.

David K.



В списке pgsql-odbc по дате отправления:

Предыдущее
От: "Marek Mosiewicz"
Дата:
Сообщение: Re: [HACKERS] Native OLE DB. What do you think about it
Следующее
От: "Dave Page"
Дата:
Сообщение: Re: ODBC questions