Skip to Content.
Sympa Menu

freetds - [freetds] Kerberos connection from Ubuntu 15.04 not working (also tried 14.10)

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Laurence Dawson <larry.dawson AT gmail.com>
  • To: freetds AT lists.ibiblio.org
  • Subject: [freetds] Kerberos connection from Ubuntu 15.04 not working (also tried 14.10)
  • Date: Tue, 2 Jun 2015 15:49:38 -0500

I have tried both tsql -S sqlhostname and tsql -S sqlhosthame -U '' -P ''
as suggested in a previous similar message on this list. My login is
failing with the error below in both cases.

I have established a tgt using kinit, but have not 'joined the domain' with
this machine. It doesn't seem like that should be necessary, as I'm just
trying to connect with my user principal:


fakeuser@lpdt430lub:~$ KRB5_TRACE=krb5.log TDSDUMP=tds.log
/opt/freetds/bin/tsql -S prod1 -U '' -P ''
locale is "en_US.UTF-8"
locale charset is "UTF-8"
using default charset "UTF-8"
Error 20002 (severity 9):
Adaptive Server connection failed
There was a problem connecting to the server



fakeuser@lpdt430lub:~$ klist
Ticket cache: FILE:/tmp/krb5cc_1000
Default principal: My.Username AT INT.MYCOMPANY.COM

Valid starting Expires Service principal
06/02/2015 14:53:56 06/03/2015 00:53:56 krbtgt/
INT.MYCOMPANY.COM AT INT.MYCOMPANY.COM
renew until 06/03/2015 14:53:52

[Note that I have edited the text above, and the log files to replace my
username and company name with fakes - at least for simple text searches]

TDS Version info:
Compile-time settings (established with the "configure" script)
Version: freetds v0.95rc3
freetds.conf directory: /opt/freetds-0.95rc3/etc
MS db-lib source compatibility: yes
Sybase binary compatibility: no
Thread safety: yes
iconv library: yes
TDS version: 7.2
iODBC: no
unixodbc: no
SSPI "trusted" logins: no
Kerberos: yes
OpenSSL: yes
GnuTLS: no

Attachment: krb5.log
Description: Binary data

Attachment: tds.log
Description: Binary data



  • [freetds] Kerberos connection from Ubuntu 15.04 not working (also tried 14.10), Laurence Dawson, 06/02/2015

Archive powered by MHonArc 2.6.24.

Top of Page