Re: Can't get ODBC from Windows to Linux/Postgres to work

On Tue, 2002-03-12 at 01:51, Jeff Martin wrote:
> > Does pg_hba.conf allow TCP/IP access?
> I think the problem is here.  The documentation within the pg_hba.conf
> file suggests that all TCP/IP connections need to use IDENT authentication.
> I just turned on the ident deamon on the Linux box hosting the database,
> but still can't make the connection.  Anyone know more about ident
> authentication with the postgres database?

It is the remote (client) end of the connection that runs identd; in
this case, that is the Microsoft box.


    MS box ----->-- ODBC request ------> PostgreSQL server
                                                |
      --<--------- ident request -----<---------
      |
      -------->--- ident response ------>-------
                                                |
         <--- connection refused --- No <- validation OK?
                                                |
                                               Yes
                                                |
      <----------- ODBC connection -----<-------


identd responds to a request to know who is trying to make the
connection.  It is inherently insecure, since you are depending on the
client end to tell the truth.  In the case of a Microsft system, that
seems very unwise!

Quite likely, in this case, the connection problem is because the
Microsoft box is not running an ident server.

--
Oliver Elphick                                Oliver.Elphick@lfix.co.uk
Isle of Wight                              http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839  932A 614D 4C34 3E1D 0C1C

     "And now abideth faith, hope, love, these three; but
      the greatest of these is love."
                            I Corinthians 13:13