Kerberos connection from Ubuntu 15.04 not working (also tried 14.10)
Laurence Dawson <[email protected]>
| Newsgroups | gmane.comp.db.tds.freetds |
|---|---|
| Message-ID | <CAGq1CuYUaVySm3bAQvC61HOQYvKSAkFqtATUaY3NfSNvwjS=Og@mail.gmail.com> |
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: [email protected] Valid starting Expires Service principal 06/02/2015 14:53:56 06/03/2015 00:53:56 krbtgt/ [email protected] 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 _______________________________________________ FreeTDS mailing list [email protected] http://lists.ibiblio.org/mailman/listinfo/freetds
krb5.log
(application/octet-stream, 1.9 KB)
[1510] 1433275655.981851: ccselect module realm chose cache FILE:/tmp/krb5cc_1000 with client principal [email protected] for server principal MSSQLSvc/ndcsunvcs001sg1.int.asurion.com:[email protected] [1510] 1433275655.981936: Getting credentials [email protected] -> MSSQLSvc/ndcsunvcs001sg1.int.asurion.com:[email protected] using ccache FILE:/tmp/krb5cc_1000 [1510] 1433275655.981982: Retrieving [email protected] -> MSSQLSvc/ndcsunvcs001sg1.int.asurion.com:[email protected] from FILE:/tmp/krb5cc_1000 with result: -1765328243/Matching credential not found [1510] 1433275655.982011: Retrieving [email protected] -> krbtgt/[email protected] from FILE:/tmp/krb5cc_1000 with result: 0/Success [1510] 1433275655.982018: Starting with TGT for client realm: [email protected] -> krbtgt/[email protected] [1510] 1433275655.982022: Requesting tickets for MSSQLSvc/ndcsunvcs001sg1.int.asurion.com:[email protected], referrals on [1510] 1433275655.982045: Generated subkey for TGS request: rc4-hmac/E4AA [1510] 1433275655.982065: etypes requested in TGS request: aes256-cts, aes128-cts, des3-cbc-sha1, rc4-hmac, camellia128-cts, camellia256-cts [1510] 1433275655.982131: Encoding request body and padata into FAST request [1510] 1433275655.982194: Sending request (3474 bytes) to INT.ASURION.COM [1510] 1433275656.290466: Resolving hostname sdcinfdc301.int.asurion.com. [1510] 1433275656.320757: Resolving hostname monadint701.int.asurion.com. [1510] 1433275656.351143: Resolving hostname sdcadint705.int.asurion.com. [1510] 1433275656.381690: Resolving hostname sktadint706.int.asurion.com. [1510] 1433275656.412041: Resolving hostname jpiinfdc301.int.asurion.com. [1510] 1433275656.441351: Resolving hostname nedadint701.int.asurion.com. [1510] 1433275656.472813: Resolving hostname spcadint701.int.asurion.com. [1510] 1433275656.503010: Resolving hostname ndcdcdr901.int.asurion.com.
tds.log
(application/octet-stream, 18.7 KB)
log.c:167:Starting log file for FreeTDS 0.95rc3
on 2015-06-02 15:07:35 with debug flags 0x4fff.
iconv.c:328:tds_iconv_open(0x1c963a0, UTF-8)
iconv.c:187:local name for ISO-8859-1 is ISO-8859-1
iconv.c:187:local name for UTF-8 is UTF-8
iconv.c:187:local name for UCS-2LE is UCS-2LE
iconv.c:187:local name for UCS-2BE is UCS-2BE
iconv.c:346:setting up conversions for client charset "UTF-8"
iconv.c:348:preparing iconv for "UTF-8" <-> "UCS-2LE" conversion
iconv.c:395:preparing iconv for "ISO-8859-1" <-> "UCS-2LE" conversion
iconv.c:400:tds_iconv_open: done
net.c:916:tds7_get_instance_port(10.3.56.55, prod1)
net.c:989:instance info
0000 05 8e 00 53 65 72 76 65-72 4e 61 6d 65 3b 4e 44 |...Serve rName;ND|
0010 43 53 55 4e 56 43 53 30-30 31 53 47 31 3b 49 6e |CSUNVCS0 01SG1;In|
0020 73 74 61 6e 63 65 4e 61-6d 65 3b 50 52 4f 44 31 |stanceNa me;PROD1|
0030 3b 49 73 43 6c 75 73 74-65 72 65 64 3b 59 65 73 |;IsClust ered;Yes|
0040 3b 56 65 72 73 69 6f 6e-3b 31 30 2e 35 30 2e 31 |;Version ;10.50.1|
0050 36 30 30 2e 31 3b 74 63-70 3b 33 37 32 30 31 3b |600.1;tc p;37201;|
0060 6e 70 3b 5c 5c 4e 44 43-53 55 4e 56 43 53 30 30 |np;\\NDC SUNVCS00|
0070 31 53 47 31 5c 70 69 70-65 5c 4d 53 53 51 4c 24 |1SG1\pip e\MSSQL$|
0080 50 52 4f 44 31 5c 73 71-6c 5c 71 75 65 72 79 3b |PROD1\sq l\query;|
0090 3b - |;|
net.c:1030:instance port is 37201
net.c:202:Connecting to 10.3.56.55 port 37201 (TDS version 7.2)
net.c:274:tds_open_socket: connect(2) returned "Operation now in progress"
net.c:313:tds_open_socket() succeeded
util.c:165:Changed query state from DEAD to IDLE
packet.c:740:Sending packet
0000 12 01 00 34 00 00 00 00-00 00 1a 00 06 01 00 20 |...4.... ....... |
0010 00 01 02 00 21 00 06 03-00 27 00 04 04 00 2b 00 |....!... .'....+.|
0020 01 ff 09 00 00 00 00 00-00 70 72 6f 64 31 00 e6 |........ .prod1..|
0030 05 00 00 00 - |....|
packet.c:639:Received packet
0000 04 01 00 2b 00 00 01 00-00 00 1a 00 06 01 00 20 |...+.... ....... |
0010 00 01 02 00 21 00 01 03-00 22 00 00 04 00 22 00 |....!... ."....".|
0020 01 ff 0a 32 0f a0 00 00-00 00 00 |...2.... ...|
login.c:1106:detected flag 0
tls.c:115:in tds_push_func_login
tls.c:81:in tds_pull_func_login
packet.c:740:Sending packet
0000 12 01 00 5b 00 00 00 00-16 03 01 00 4e 01 00 00 |...[.... ....N...|
0010 4a 03 01 5f db c1 e8 a8-89 0f 79 b6 a8 d2 4f a9 |J.._.... ..y...O.|
0020 0e b7 bd 76 37 7f fb fa-ba 47 be 46 a2 a3 93 c8 |...v7... .G.F....|
0030 fb 94 20 00 00 18 00 39-00 38 00 35 00 16 00 13 |.. ....9 .8.5....|
0040 00 0a 00 33 00 32 00 2f-00 05 00 04 00 ff 01 00 |...3.2./ ........|
0050 00 09 00 23 00 00 00 0f-00 01 01 |...#.... ...|
tls.c:93:have 0
tls.c:97:before read
packet.c:639:Received packet
0000 12 01 0b 40 00 00 00 00-16 03 01 0b 33 02 00 00 |...@.... ....3...|
0010 4d 03 01 55 6e 0d 07 8c-f3 00 ba 98 5b 27 82 d5 |M..Un... ....['..|
0020 ee ff b4 dc 9f 00 d7 ad-75 ee e1 be bb 54 33 8f |........ u....T3.|
0030 75 85 c4 20 3e 02 00 00-42 2c 8e 1d 30 16 d5 95 |u.. >... B,..0...|
0040 02 2b 1e f6 a5 f8 59 13-88 05 98 07 03 d6 a8 a2 |.+....Y. ........|
0050 2a 88 ce 59 00 2f 00 00-05 ff 01 00 01 00 0b 00 |*..Y./.. ........|
0060 0a da 00 0a d7 00 05 eb-30 82 05 e7 30 82 04 cf |........ 0...0...|
0070 a0 03 02 01 02 02 0a 3e-c0 85 31 00 02 00 3f 25 |.......> ..1...?%|
0080 17 30 0d 06 09 2a 86 48-86 f7 0d 01 01 05 05 00 |.0...*.H ........|
0090 30 51 31 13 30 11 06 0a-09 92 26 89 93 f2 2c 64 |0Q1.0... ..&...,d|
00a0 01 19 16 03 6f 72 67 31-17 30 15 06 0a 09 92 26 |....org1 .0.....&|
00b0 89 93 f2 2c 64 01 19 16-07 61 73 75 72 69 6f 6e |...,d... .mycompn|
00c0 31 14 30 12 06 0a 09 92-26 89 93 f2 2c 64 01 19 |1.0..... &...,d..|
00d0 16 04 70 72 6f 64 31 0b-30 09 06 03 55 04 03 13 |..prod1. 0...U...|
00e0 02 63 61 30 1e 17 0d 31-34 31 30 33 30 30 37 34 |.ca0...1 41030074|
00f0 33 35 31 5a 17 0d 31 39-31 30 32 39 30 37 34 33 |351Z..19 10290743|
0100 35 31 5a 30 2a 31 28 30-26 06 03 55 04 03 13 1f |51Z0*1(0 &..U....|
0110 4e 44 43 53 55 4e 56 43-53 30 30 31 53 47 31 2e |NDCSUNVC S001SG1.|
0120 69 6e 74 2e 61 73 75 72-69 6f 6e 2e 63 6f 6d 30 |int.myco mpa.com0|
0130 82 01 22 30 0d 06 09 2a-86 48 86 f7 0d 01 01 01 |.."0...* .H......|
0140 05 00 03 82 01 0f 00 30-82 01 0a 02 82 01 01 00 |.......0 ........|
0150 9e 79 77 08 d7 44 4b 37-b8 48 dc 15 b6 17 8f b9 |.yw..DK7 .H......|
0160 e3 ca f6 f7 c0 f5 a0 a9-17 a3 d4 e6 39 3c 9b 3a |........ ....9<.:|
0170 a1 23 d4 83 79 c6 c9 47-83 3c f6 bc 9b 71 76 bc |.#..y..G .<...qv.|
0180 0a 09 48 b6 ad 74 32 46-00 c7 60 63 f7 73 89 46 |..H..t2F ..`c.s.F|
0190 91 3d bc 52 5c 00 e8 2d-f4 e8 9e 98 ad 56 c7 dc |.=.R\..- .....V..|
01a0 8a 1e a0 1c 33 7b 06 11-f8 89 00 a8 b1 c7 de 38 |....3{.. .......8|
01b0 71 82 c2 bf b4 7f e4 e7-61 65 d2 4a 25 02 00 7c |q....... ae.J%..||
01c0 52 f5 03 8a f1 4c e4 b6-0d 68 2f e5 1b 70 3b 12 |R....L.. .h/..p;.|
01d0 5a e9 69 7a f0 df 58 fb-6c 80 91 d2 5a 4b 45 e3 |Z.iz..X. l...ZKE.|
01e0 48 b9 20 a1 67 75 f0 95-d6 97 d8 75 b9 2e bc 67 |H. .gu.. ...u...g|
01f0 2d a8 ec fc a7 2d 6f cd-7e 59 7f 25 95 7a d9 d5 |-....-o. ~Y.%.z..|
0200 90 df 30 36 93 c2 46 fb-3b 4a 1c b6 22 14 a4 3b |..06..F. ;J.."..;|
0210 52 f0 e1 3e 57 51 31 cf-eb d0 11 60 ec e5 9e 49 |R..>WQ1. ...`...I|
0220 42 91 83 00 03 93 86 cd-0c 73 ea bc fe 98 80 02 |B....... .s......|
0230 bf ac f6 3b 93 69 c8 fa-2a 54 bc 5e d1 a0 b8 ba |...;.i.. *T.^....|
0240 da 97 97 0b 76 de ff c1-d8 ce 62 fc 74 78 4d 67 |....v... ..b.txMg|
0250 02 03 01 00 01 a3 82 02-e6 30 82 02 e2 30 3c 06 |........ .0...0<.|
0260 09 2b 06 01 04 01 82 37-15 07 04 2f 30 2d 06 25 |.+.....7 .../0-.%|
0270 2b 06 01 04 01 82 37 15-08 81 f4 d2 12 85 80 89 |+.....7. ........|
0280 3e 87 ad 81 0f 81 d0 a8-71 82 c8 c2 60 16 e1 b0 |>....... q...`...|
0290 48 82 eb a0 77 02 01 64-02 01 03 30 13 06 03 55 |H...w..d ...0...U|
02a0 1d 25 04 0c 30 0a 06 08-2b 06 01 05 05 07 03 01 |.%..0... +.......|
02b0 30 0e 06 03 55 1d 0f 01-01 ff 04 04 03 02 05 a0 |0...U... ........|
02c0 30 1b 06 09 2b 06 01 04-01 82 37 15 0a 04 0e 30 |0...+... ..7....0|
02d0 0c 30 0a 06 08 2b 06 01-05 05 07 03 01 30 1d 06 |.0...+.. .....0..|
02e0 03 55 1d 0e 04 16 04 14-2c 90 3c 23 16 92 3d 89 |.U...... ,.<#..=.|
02f0 da 40 9e 82 1a 55 e1 16-16 da ed 65 30 1a 06 03 |[email protected].. ...e0...|
0300 55 1d 11 04 13 30 11 82-0f 4e 44 43 53 55 4e 56 |U....0.. .NDCSUNV|
0310 43 53 30 30 31 53 47 31-30 1f 06 03 55 1d 23 04 |CS001SG1 0...U.#.|
0320 18 30 16 80 14 c6 0f f5-42 78 a5 f0 e9 9c fd e9 |.0...... Bx......|
0330 41 ed 4e 0e db 2e bb 6a-1a 30 82 01 03 06 03 55 |A.N....j .0.....U|
0340 1d 1f 04 81 fb 30 81 f8-30 81 f5 a0 81 f2 a0 81 |.....0.. 0.......|
0350 ef 86 81 ac 6c 64 61 70-3a 2f 2f 2f 43 4e 3d 63 |....ldap :///CN=c|
0360 61 2c 43 4e 3d 43 41 2c-43 4e 3d 43 44 50 2c 43 |a,CN=CA, CN=CDP,C|
0370 4e 3d 50 75 62 6c 69 63-25 32 30 4b 65 79 25 32 |N=Public %20Key%2|
0380 30 53 65 72 76 69 63 65-73 2c 43 4e 3d 53 65 72 |0Service s,CN=Ser|
0390 76 69 63 65 73 2c 43 4e-3d 43 6f 6e 66 69 67 75 |vices,CN =Configu|
03a0 72 61 74 69 6f 6e 2c 44-43 3d 70 72 6f 64 2c 44 |ration,D C=prod,D|
03b0 43 3d 61 73 75 72 69 6f-6e 2c 44 43 3d 6f 72 67 |C=mycomp n,DC=org|
03c0 3f 63 65 72 74 69 66 69-63 61 74 65 52 65 76 6f |?certifi cateRevo|
03d0 63 61 74 69 6f 6e 4c 69-73 74 3f 62 61 73 65 3f |cationLi st?base?|
03e0 6f 62 6a 65 63 74 43 6c-61 73 73 3d 63 52 4c 44 |objectCl ass=cRLD|
03f0 69 73 74 72 69 62 75 74-69 6f 6e 50 6f 69 6e 74 |istribut ionPoint|
0400 86 1e 68 74 74 70 3a 2f-2f 77 77 77 63 61 2f 43 |..http:/ /wwwca/C|
0410 65 72 74 45 6e 72 6f 6c-6c 2f 63 61 2e 63 72 6c |ertEnrol l/ca.crl|
0420 86 1e 68 74 74 70 3a 2f-2f 77 77 77 63 61 2f 43 |..http:/ /wwwca/C|
0430 65 72 74 45 6e 72 6f 6c-6c 2f 63 61 2e 63 72 6c |ertEnrol l/ca.crl|
0440 30 81 fc 06 08 2b 06 01-05 05 07 01 01 04 81 ef |0....+.. ........|
0450 30 81 ec 30 81 a9 06 08-2b 06 01 05 05 07 30 02 |0..0.... +.....0.|
0460 86 81 9c 6c 64 61 70 3a-2f 2f 2f 43 4e 3d 63 61 |...ldap: ///CN=ca|
0470 2c 43 4e 3d 41 49 41 2c-43 4e 3d 50 75 62 6c 69 |,CN=AIA, CN=Publi|
0480 63 25 32 30 4b 65 79 25-32 30 53 65 72 76 69 63 |c%20Key% 20Servic|
0490 65 73 2c 43 4e 3d 53 65-72 76 69 63 65 73 2c 43 |es,CN=Se rvices,C|
04a0 4e 3d 43 6f 6e 66 69 67-75 72 61 74 69 6f 6e 2c |N=Config uration,|
04b0 44 43 3d 70 72 6f 64 2c-44 43 3d 61 73 75 72 69 |DC=prod, DC=mycom|
04c0 6f 6e 2c 44 43 3d 6f 72-67 3f 63 41 43 65 72 74 |pa,DC=or g?cACert|
04d0 69 66 69 63 61 74 65 3f-62 61 73 65 3f 6f 62 6a |ificate? base?obj|
04e0 65 63 74 43 6c 61 73 73-3d 63 65 72 74 69 66 69 |ectClass =certifi|
04f0 63 61 74 69 6f 6e 41 75-74 68 6f 72 69 74 79 30 |cationAu thority0|
0500 3e 06 08 2b 06 01 05 05-07 30 02 86 32 68 74 74 |>..+.... .0..2htt|
0510 70 3a 2f 2f 77 77 77 63-61 2f 43 65 72 74 45 6e |p://wwwc a/CertEn|
0520 72 6f 6c 6c 2f 63 61 2e-70 72 6f 64 2e 61 73 75 |roll/ca. prod.myc|
0530 72 69 6f 6e 2e 6f 72 67-5f 63 61 2e 63 72 74 30 |ompa.org _ca.crt0|
0540 0d 06 09 2a 86 48 86 f7-0d 01 01 05 05 00 03 82 |...*.H.. ........|
0550 01 01 00 42 8c ea a8 55-db 50 f6 4a f2 8c 4a a9 |...B...U .P.J..J.|
0560 df f5 9a 6b c4 8d c4 36-ef 9d 04 b1 f0 68 43 11 |...k...6 .....hC.|
0570 0f 6f aa 08 b8 d5 57 0e-7d 66 3e 2a 18 17 58 8a |.o....W. }f>*..X.|
0580 15 a3 6a 60 13 58 17 16-26 ed a7 2e 31 ff cf cf |..j`.X.. &...1...|
0590 87 3b 6c 48 e1 96 54 e9-fb 6b d0 44 d8 98 c6 61 |.;lH..T. .k.D...a|
05a0 c6 c5 8c 3e e5 2e 9e 4d-45 36 81 24 6d e8 a8 eb |...>...M E6.$m...|
05b0 32 0a ea f7 0c 65 9b 6b-8a 05 9b bf 05 a5 27 bb |2....e.k ......'.|
05c0 c7 89 6e ad e7 4c 59 e3-76 4b d9 d8 06 08 27 55 |..n..LY. vK....'U|
05d0 be ae aa 4f 41 01 04 3d-b0 ef 11 f3 b6 71 21 10 |...OA..= .....q!.|
05e0 87 76 dc 1d 08 44 7f 6b-5d a8 eb 1b 28 e1 ae 45 |.v...D.k ]...(..E|
05f0 bd 5c 17 78 00 2c 94 bb-d5 90 3b cf c2 73 ed 37 |.\.x.,.. ..;..s.7|
0600 f7 69 b9 01 16 e9 69 c7-86 e5 f3 3c 99 b3 1f 46 |.i....i. ...<...F|
0610 e7 7f e5 00 65 c3 1b 2c-86 9a 57 85 64 58 62 3d |....e.., ..W.dXb=|
0620 7e 9e 50 9f 6d 9a 1e ba-a0 9e 43 bb e4 09 b3 a7 |~.P.m... ..C.....|
0630 13 2c 37 ec fd 5a c8 6d-a2 20 c1 65 55 fc b3 fa |.,7..Z.m . .eU...|
0640 3a 65 e3 8d a7 08 66 61-84 cc 5b c0 89 68 dd 3a |:e....fa ..[..h.:|
0650 a4 ee 04 00 04 e6 30 82-04 e2 30 82 02 ca a0 03 |......0. ..0.....|
0660 02 01 02 02 0a 61 c0 1f-d6 00 01 00 00 00 05 30 |.....a.. .......0|
0670 0d 06 09 2a 86 48 86 f7-0d 01 01 0b 05 00 30 11 |...*.H.. ......0.|
0680 31 0f 30 0d 06 03 55 04-03 13 06 72 6f 6f 74 63 |1.0...U. ...rootc|
0690 61 30 1e 17 0d 31 32 30-38 32 31 32 31 31 37 35 |a0...120 82121175|
06a0 32 5a 17 0d 33 32 30 38-32 31 31 38 32 36 33 34 |2Z..3208 21182634|
06b0 5a 30 51 31 13 30 11 06-0a 09 92 26 89 93 f2 2c |Z0Q1.0.. ...&...,|
06c0 64 01 19 16 03 6f 72 67-31 17 30 15 06 0a 09 92 |d....org 1.0.....|
06d0 26 89 93 f2 2c 64 01 19-16 07 61 73 75 72 69 6f |&...,d.. ..mycomp|
06e0 6e 31 14 30 12 06 0a 09-92 26 89 93 f2 2c 64 01 |n1.0.... .&...,d.|
06f0 19 16 04 70 72 6f 64 31-0b 30 09 06 03 55 04 03 |...prod1 .0...U..|
0700 13 02 63 61 30 82 01 22-30 0d 06 09 2a 86 48 86 |..ca0.." 0...*.H.|
0710 f7 0d 01 01 01 05 00 03-82 01 0f 00 30 82 01 0a |........ ....0...|
0720 02 82 01 01 00 a2 2a fe-5b bc 17 af 9b 7a f4 61 |......*. [....z.a|
0730 7e 32 fc d4 12 f7 fc 88-4c 47 c4 6b 43 61 80 c1 |~2...... LG.kCa..|
0740 5a 67 82 8c 38 c2 67 70-aa 64 78 f7 47 44 6c 5e |Zg..8.gp .dx.GDl^|
0750 34 d5 da 56 92 97 b9 77-45 4f f5 d0 e2 6b c1 cb |4..V...w EO...k..|
0760 d2 be 21 b4 42 91 cb db-aa 95 71 45 05 f1 6d bc |..!.B... ..qE..m.|
0770 fc 1b 31 13 98 7c 18 58-99 95 55 fd 36 9a c6 e7 |..1..|.X ..U.6...|
0780 b0 6a 1c 43 c7 4d 7e 7a-a9 40 1e 20 72 e1 15 dc |.j.C.M~z .@. r...|
0790 e1 7b b8 b4 96 24 58 9b-4b 23 b0 86 19 2f dd 5a |.{...$X. K#.../.Z|
07a0 03 c6 3e f4 37 e6 29 c2-2e 32 4d c7 f7 3e 3a d9 |..>.7.). .2M..>:.|
07b0 b2 93 16 24 5a 9d 5a 98-d8 78 d5 f1 6d 5f bc 28 |...$Z.Z. .x..m_.(|
07c0 a2 68 9c 00 96 40 6a 5e-90 8e 1b 11 69 0c 6c d0 |.h...@j^ ....i.l.|
07d0 90 c7 cb 61 b8 25 9c fa-12 53 d4 05 96 8d b4 e1 |...a.%.. .S......|
07e0 c8 15 c0 67 8c 1c ef b8-d7 02 a5 e3 60 8d ea 7b |...g.... ....`..{|
07f0 6c 26 49 11 a0 29 ac b3-67 f2 1a 32 64 d9 59 99 |l&I..).. g..2d.Y.|
0800 f7 35 06 31 43 14 c3 f1-e8 d0 d9 e2 b7 11 cd e3 |.5.1C... ........|
0810 7e 10 1c a9 e0 8e 4d d5-0b 46 8a e2 40 53 0f d4 |~.....M. .F..@S..|
0820 26 c2 0f c5 23 02 03 01-00 01 a3 81 fb 30 81 f8 |&...#... .....0..|
0830 30 10 06 09 2b 06 01 04-01 82 37 15 01 04 03 02 |0...+... ..7.....|
0840 01 02 30 23 06 09 2b 06-01 04 01 82 37 15 02 04 |..0#..+. ....7...|
0850 16 04 14 26 c7 53 5f 83-00 45 3c 67 11 8c ab c0 |...&.S_. .E<g....|
0860 6b 26 7c 30 49 c5 4a 30-1d 06 03 55 1d 0e 04 16 |k&|0I.J0 ...U....|
0870 04 14 c6 0f f5 42 78 a5-f0 e9 9c fd e9 41 ed 4e |.....Bx. .....A.N|
0880 0e db 2e bb 6a 1a 30 11-06 03 55 1d 20 04 0a 30 |....j.0. ..U. ..0|
0890 08 30 06 06 04 55 1d 20-00 30 19 06 09 2b 06 01 |.0...U. .0...+..|
08a0 04 01 82 37 14 02 04 0c-1e 0a 00 53 00 75 00 62 |...7.... ...S.u.b|
08b0 00 43 00 41 30 0b 06 03-55 1d 0f 04 04 03 02 01 |.C.A0... U.......|
08c0 86 30 0f 06 03 55 1d 13-01 01 ff 04 05 30 03 01 |.0...U.. .....0..|
08d0 01 ff 30 1f 06 03 55 1d-23 04 18 30 16 80 14 bd |..0...U. #..0....|
08e0 8d d9 ab 5b 40 27 ff b3-51 6d a8 bf e1 62 3f cc |...[@'.. Qm...b?.|
08f0 e1 4a 08 30 33 06 03 55-1d 1f 04 2c 30 2a 30 28 |.J.03..U ...,0*0(|
0900 a0 26 a0 24 86 22 68 74-74 70 3a 2f 2f 77 77 77 |.&.$."ht tp://www|
0910 63 61 2f 43 65 72 74 45-6e 72 6f 6c 6c 2f 72 6f |ca/CertE nroll/ro|
0920 6f 74 63 61 2e 63 72 6c-30 0d 06 09 2a 86 48 86 |otca.crl 0...*.H.|
0930 f7 0d 01 01 0b 05 00 03-82 02 01 00 19 39 86 fc |........ .....9..|
0940 3a ae 7a cb 37 16 65 d8-24 2b 1f 6a 84 e7 e3 b7 |:.z.7.e. $+.j....|
0950 ec f4 0a a1 1b b0 31 18-25 cb ed a0 5a 6f 73 1e |......1. %...Zos.|
0960 d1 d1 35 0c 81 94 00 d1-e6 24 80 7e dc 36 dd 82 |..5..... .$.~.6..|
0970 c3 6a 79 5b ab b5 4d 42-7e f9 96 13 7f fd 92 7c |.jy[..MB ~......||
0980 15 75 d6 e0 1f 5e 39 52-c9 ef 45 e2 47 b6 db f0 |.u...^9R ..E.G...|
0990 ce 2c 5c d9 37 06 78 f6-bc e2 7c 3a e0 4f d6 13 |.,\.7.x. ..|:.O..|
09a0 5b e4 29 0c b5 c0 c5 71-9b 26 e8 d1 51 70 c0 57 |[.)....q .&..Qp.W|
09b0 89 af 69 91 ed 97 dd 75-27 bf f3 54 8b 57 b8 a3 |..i....u '..T.W..|
09c0 7d f4 83 e1 2b 51 99 ea-16 bf 8d 3a 6d be 4d 9b |}...+Q.. ...:m.M.|
09d0 e1 91 ed 7b bf f3 a4 a9-4d bd 79 92 27 b8 a1 cc |...{.... M.y.'...|
09e0 d3 af e2 fa 35 30 8b bf-20 e1 6b 3c ec 6b be 11 |....50.. .k<.k..|
09f0 76 3f c3 8c d1 60 13 1a-6a cb 4f c6 3d f1 0b 65 |v?...`.. j.O.=..e|
0a00 01 29 6f 85 a0 64 b1 08-3e 62 db ba 54 0a 69 9e |.)o..d.. >b..T.i.|
0a10 21 16 45 ee bb 8f 06 89-fb 15 67 8b b2 64 f7 3d |!.E..... ..g..d.=|
0a20 21 12 03 e5 4a e8 c6 b9-34 e7 57 42 1e 0f 8e 28 |!...J... 4.WB...(|
0a30 e6 25 e9 c3 e6 f3 96 92-44 cf 8b 1d 2f 55 dc c8 |.%...... D.../U..|
0a40 34 fc 03 14 14 ba 15 e2-de 8e d4 2c ba ef b2 9f |4....... ...,....|
0a50 50 2e a8 b0 c9 ee 8c 3f-41 c9 e6 2f ab 8a 9b 5d |P......? A../...]|
0a60 5d e0 94 45 15 d8 7c 8e-1e 0a 08 cd 52 84 36 97 |]..E..|. ....R.6.|
0a70 1a 2a ad 41 44 ba f2 98-85 26 4f fb f8 4d 64 0e |.*.AD... .&O..Md.|
0a80 d6 3f 4a e3 a5 3e ff d5-da e5 1e 91 42 ef 9b be |.?J..>.. ....B...|
0a90 ec cc d3 40 51 07 1c 79-81 31 a6 85 79 5c e0 02 |[email protected] .1..y\..|
0aa0 3a 2f ac f9 0d 13 a3 9d-f9 1a 0c 84 c1 89 53 85 |:/...... ......S.|
0ab0 8c 2f b3 2e 2b 12 0b 61-cf 19 f9 a3 63 61 cc c1 |./..+..a ....ca..|
0ac0 15 aa dd 52 20 12 79 4e-13 ad 78 e0 0c 0a c4 62 |...R .yN ..x....b|
0ad0 05 ed 0a 28 ff 9d 8a 31-43 62 99 32 a4 91 ff c0 |...(...1 Cb.2....|
0ae0 d2 e5 cd 6a 87 4d fd 20-42 21 36 26 56 10 90 1c |...j.M. B!6&V...|
0af0 d9 bf 19 a7 da 27 b1 ca-c6 df 2f 3c a8 70 1b de |.....'.. ../<.p..|
0b00 79 36 b1 52 90 e8 b7 e1-b6 39 36 44 d1 75 4f 45 |y6.R.... .96D.uOE|
0b10 5c 6f 5e b7 e4 0d c4 08-21 69 17 4a db 45 9b 6e |\o^..... !i.J.E.n|
0b20 86 8e c6 1f 5f ee a0 60-f8 7f b5 3b f5 3b 86 4f |...._..` ...;.;.O|
0b30 02 6b f5 d0 e8 f7 98 2f-99 4e 25 11 0e 00 00 00 |.k...../ .N%.....|
tls.c:100:after read
tls.c:93:have 2872
tls.c:104:read 5 bytes
tls.c:81:in tds_pull_func_login
tls.c:93:have 2867
tls.c:104:read 2867 bytes
tls.c:115:in tds_push_func_login
packet.c:740:Sending packet
0000 12 01 01 4e 00 00 00 00-16 03 01 01 06 10 00 01 |...N.... ........|
0010 02 01 00 55 90 a3 46 fd-34 1c 6e 60 6e 27 06 86 |...U..F. 4.n`n'..|
0020 98 2a e9 b9 5a b8 99 8b-a0 43 3a 03 e9 85 29 d3 |.*..Z... .C:...).|
0030 3a d1 f6 7a 0f d3 4f 7c-c8 a5 68 d7 a0 fe 8d 89 |:..z..O| ..h.....|
0040 37 01 24 18 80 18 e5 f9-5f 20 bd 27 0d 93 31 90 |7.$..... _ .'..1.|
0050 cd ef 2f 8f 96 8d 44 36-be 01 6c 79 ea 13 d2 81 |../...D6 ..ly....|
0060 f9 fe b0 f8 5c 65 7f bb-22 e1 52 d1 d1 1f 2d ff |....\e.. ".R...-.|
0070 8e 41 d8 86 e1 a0 6b 4f-2d ed ce e0 26 f8 ea e2 |.A....kO -...&...|
0080 b7 1d 9c 09 b5 11 d2 63-67 1f d0 43 f1 d7 fb 8d |.......c g..C....|
0090 94 22 e4 3e 63 1b 5a 8a-6f fb cc 25 e9 c0 b8 f4 |.".>c.Z. o..%....|
00a0 47 93 3d 3b c8 19 bb 35-34 9d d9 2d 3c 00 70 20 |G.=;...5 4..-<.p |
00b0 1b 6c d7 49 88 72 0a c5-64 ac 8a 16 e8 c9 0b 4f |.l.I.r.. d......O|
00c0 d9 0a 1c d3 84 1f aa 6c-6c da a9 22 7e da 06 b2 |.......l l.."~...|
00d0 bb 54 c2 5d 4a 8c f7 b7-49 73 3f 3d fc 86 4a e4 |.T.]J... Is?=..J.|
00e0 a4 c4 11 9a 3d 4a 34 d9-ac 2e b3 f3 3d d6 7f 7f |....=J4. ....=...|
00f0 86 59 fe fe ee d6 c4 71-db 9c 4c ec 9e 68 e4 e1 |.Y.....q ..L..h..|
0100 f8 d8 9f 77 5a 21 23 cc-98 ba b4 5c 40 65 c3 31 |...wZ!#. ...\@e.1|
0110 79 d8 42 14 03 01 00 01-01 16 03 01 00 30 50 b2 |y.B..... .....0P.|
0120 39 81 b8 95 ce 09 73 2d-b1 65 7c e5 5b e6 ee dd |9.....s- .e|.[...|
0130 f1 97 c7 4e d3 71 f4 06-b7 25 5a 9a 4c b8 e2 27 |...N.q.. .%Z.L..'|
0140 b6 af c3 6e c5 f7 3e 18-2c 64 6a 48 2b f1 |...n..>. ,djH+.|
tls.c:81:in tds_pull_func_login
tls.c:93:have 0
tls.c:97:before read
packet.c:639:Received packet
0000 12 01 00 43 00 00 00 00-14 03 01 00 01 01 16 03 |...C.... ........|
0010 01 00 30 ab 8c 73 b4 7a-75 3a 93 c4 ea f5 ff 48 |..0..s.z u:.....H|
0020 b8 4d f7 a1 14 c3 28 59-5d b5 7b de 83 10 77 94 |.M....(Y ].{...w.|
0030 5a 26 82 cb af 46 6b 40-86 89 ad 50 29 57 d7 8e |Z&...Fk@ ...P)W..|
0040 80 38 98 - |.8.|
tls.c:100:after read
tls.c:93:have 59
tls.c:104:read 5 bytes
tls.c:81:in tds_pull_func_login
tls.c:93:have 54
tls.c:104:read 1 bytes
tls.c:81:in tds_pull_func_login
tls.c:93:have 53
tls.c:104:read 5 bytes
tls.c:81:in tds_pull_func_login
tls.c:93:have 48
tls.c:104:read 48 bytes
tls.c:854:handshake succeeded!!
login.c:797:using GSS authentication
gssapi.c:218:using kerberos name MSSQLSvc/ndcsunvcs001sg1.int.asurion.com:37201
gssapi.c:230:gss_import_name: GSS_S_COMPLETE: gss_import_name completed successfully.
gssapi.c:318:gss_init_sec_context: actual mechanism at 0x(nil)
gssapi.c:334:gss_init_sec_context: min_stat 22 "Invalid argument"
gssapi.c:374:gss_init_sec_context: GSS_S_FAILURE: The routine failed for reasons that are not defined at the GSS level.
login.c:472:login packet rejected
query.c:3769:tds_disconnect()
util.c:165:Changed query state from IDLE to DEAD
util.c:322:tdserror(0x1c96110, 0x1c963a0, 20002, 0)
util.c:352:tdserror: client library returned TDS_INT_CANCEL(2)
util.c:375:tdserror: returning TDS_INT_CANCEL(2)
mem.c:644:tds_free_all_results()