[freetds] what now, Kerberos?

jklowden at schemamania.org jklowden at schemamania.org
Wed Nov 17 10:54:39 EST 2010


I have configured and built Kerberos on RHEL and am logged in using my 
Windows domain account, but my SQL Server 2000 box rejects my login 
(which of course works elsewhere).  

How do I debug this?  How do I know if it's a technical problem with
FreeTDS or an administrative problem with the RHEL setup?  

$ TDSDUMP=stdout ./build/src/apps/tsql -S mpquant -U '' -P ''
log.c:196:Starting log file for FreeTDS 0.83.dev.20101115
        on 2010-11-17 10:32:41 with debug flags 0x4fff.
locale is "en_US.UTF-8"
locale charset is "UTF-8"
using default charset "ISO-8859-1"
[... iconv ...]
net.c:205:Connecting to 10.82.32.177 port 2500 (TDS version 7.1)
net.c:261:tds_open_socket: connect(2) returned "Operation now in progress"
net.c:301:tds_open_socket() succeeded
util.c:156:Changed query state from DEAD to IDLE
net.c:730:Sending packet
0000 12 01 00 34 00 00 00 00-00 00 15 00 06 01 00 1b |...4.... ........|
0010 00 01 02 00 1c 00 0c 03-00 28 00 04 ff 08 00 01 |........ .(......|
0020 55 00 00 02 4d 53 53 51-4c 53 65 72 76 65 72 00 |U...MSSQ LServer.|
0030 b1 71 00 00            -                        |.q..|

net.c:546:Received header
0000 04 01 00 25 00 00 01 00-                        |...%....|

net.c:600:Received packet
0000 04 01 00 25 00 00 01 00-00 00 15 00 06 01 00 1b |...%.... ........|
0010 00 01 02 00 1c 00 01 03-00 1d 00 00 ff 08 00 07 |........ ........|
0020 f7 00 00 02 00         -                        |.....|

login.c:1047:detected flag 2
gssapi.c:172:kerberos name MSSQLSvc/mpquant.eg.com:2500
login.c:458:login packet rejected
util.c:156:Changed query state from IDLE to DEAD
util.c:331:tdserror(0x151775d0, 0x15177870, 20002, 0)
Error 20002 (severity 9):
        Adaptive Server connection failed
util.c:361:tdserror: client library returned TDS_INT_CANCEL(2)
util.c:384:tdserror: returning TDS_INT_CANCEL(2)
mem.c:615:tds_free_all_results()
There was a problem connecting to the server

Thanks for any help.  

--jkl



More information about the FreeTDS mailing list