Skip site navigation (1) Skip section navigation (2)

Re: JDBC connection issue

From: Blaine Simpson <blaine(dot)simpson(at)admc(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: JDBC connection issue
Date: 2004-07-21 22:35:36
Message-ID: 40FEEFB8.8080603@admc.com (view raw or flat)
Thread:
Lists: pgsql-jdbc
Kris Jurka wrote:

>On Wed, 21 Jul 2004, Blaine Simpson wrote:
>
>  
>
>>Use "md5" instead of "trust".  Besides trust having all sorts of
>>problems to do with ident daemons, I don't even know if the JDBC driver
>>will work with ident, since JDBC network drivers generally pass a
>>username and password.
>>    
>>
>
>"trust" has nothing to do with "ident" authentication, trust does not do
>any authentication at all and just lets you in.  Using ident
>authentication can be a little tricky with JDBC simply because it uses
>tcp/ip to connect as opposed to unix sockets.  On the server side these
>use different code paths for ident authentication with unix sockets
>requiring kernel support for passing user information and tcp/ip sockets
>requiring an ident server.
>  
>
Thanks for the correction.  I understand now that ident should work if 
you can satisfy
the ident requirements.

I still stand by what I said about trust.  If you use TCP/IP, with or 
without JDBC,
then if you use "trust" you  will have to deal with "... problems to do 
with ident
deamons".   You just said that if you use "trust" with TCP/IP you need 
an ident
server (due to differences in local vs. network socket handling in 
server code).
Therefore, if you're running TCP/IP, "trust" has a lot to do with 
"ident" authentication.
You don't need an ident server if you use "md5", you do need an ident 
server if you
 use "trust".

>In any case the JDBC driver works fine with both trust and ident 
>authentication, as far as I know the only authentication method that are 
>unsupported by the JDBC driver is kerberos.
>
>Kris Jurka
>  
>


-- 
ICF:  703-934-3692       Cell:  703-944-9317


In response to

Responses

pgsql-jdbc by date

Next:From: Blaine SimpsonDate: 2004-07-21 23:41:02
Subject: Re: JDBC connection issue
Previous:From: Kris JurkaDate: 2004-07-21 22:14:11
Subject: Re: JDBC connection issue

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group