pg.ddx.io pgsql-admin@postgresql.org mailing list archivehelp / color / mirror / Atom feed
psql on Linux vs Windows, major GSS differences 2+ messages / 2 participants [nested] [flat]
* psql on Linux vs Windows, major GSS differences @ 2014-08-29 13:54 Jeffrey Shaw <shawjef3@gmail.com> 0 siblings, 1 reply; 2+ messages in thread From: Jeffrey Shaw @ 2014-08-29 13:54 UTC (permalink / raw) To: pgsql-admin Hello all, I'm attempting to get Windows domain users to be able to connect to a PostgreSQL server running on CentOS 7. Linux clients authenticated to the domain are able to connect, whereas Windows clients are not. I've been looking at Wireshark packet captures, and there's a big difference between Linux and Windows psql. After sending a message to the server containing key-value pairs containing the user name and other information such as encoding, psql on Linux sends a packet that wireshark shows as ">p", and it contains a kerberos password. psql on Windows does not send that message. The error the Windows client prints is psql: SSPI continuation error: The specified target is unknown or unreachable (80090303) Another difference is that psql on Windows sends the user name without the domain appended, for example "jeff.shaw" instead of "jeff.shaw@domain.com". The psql on Linux does append the domain name. I've verified that both the client and server have valid dns and reverse dns entries. I'm using the binaries from enterprisedb for PostgreSQL 9.4 beta 2 on both the client and server. I'm wondering if the problem is that the Windows version is not compiled with GSS support. pg_config reports that the Linux build is configured --with-gssapi, whereas that does not appear in the Windows version. Jeff ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: psql on Linux vs Windows, major GSS differences @ 2015-07-27 07:04 evgenyfr <evgenyfr@gmail.com> parent: Jeffrey Shaw <shawjef3@gmail.com> 0 siblings, 0 replies; 2+ messages in thread From: evgenyfr @ 2015-07-27 07:04 UTC (permalink / raw) To: pgsql-admin Hello , do you found how to resolve this issue ? have same error from Windowd 7 (PC): psql: SSPI continuation error: The specified target is unknown or unreachable (80090303) from linux machine with psql -Hservername working fine . Regards, Evgeny -- View this message in context: http://postgresql.nabble.com/psql-on-Linux-vs-Windows-major-GSS-differences-tp5816885p5859510.html Sent from the PostgreSQL - admin mailing list archive at Nabble.com. -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2015-07-27 07:04 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2014-08-29 13:54 psql on Linux vs Windows, major GSS differences Jeffrey Shaw <shawjef3@gmail.com> 2015-07-27 07:04 ` evgenyfr <evgenyfr@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox