Skip to Content.
Sympa Menu

freetds - Re: [freetds] using freetds 0.64 with MS SQL 2005 with ssl, encryption forced on at server results in query timeout error

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Bob Hetzel <beh AT case.edu>
  • To: freetds AT lists.ibiblio.org
  • Subject: Re: [freetds] using freetds 0.64 with MS SQL 2005 with ssl, encryption forced on at server results in query timeout error
  • Date: Tue, 05 Jun 2007 10:47:07 -0400


Thanks much, I can now compile the snapshot.

Upon testing again now though, I'm still left with the problem of not being able to properly sign into the server.

Here's what's in the freetds.log now...

log.c:190:Starting log file for FreeTDS 0.65.dev.20070605
on 2007-06-05 10:34:32 with debug flags 0x4fff.
iconv.c:197:names for ISO-8859-1: ISO-8859-1
iconv.c:197:names for UTF-8: UTF-8
iconv.c:197:names for UCS-2LE: UCS-2LE
iconv.c:197:names for UCS-2BE: UCS-2BE
iconv.c:363:iconv to convert client-side data to the "utf8" character set
iconv.c:516:tds_iconv_info_init: converting "UTF-8"->"UCS-2LE"
iconv.c:516:tds_iconv_info_init: converting "ISO-8859-1"->"UCS-2LE"
net.c:185:Connecting to 129.22.208.111 port 1433 (TDS version 8.0)
net.c:241:tds_open_socket: connect(2) returned "Operation now in progress"
net.c:284:tds_open_socket() succeeded
util.c:162:Changed query state from DEAD to IDLE
net.c:747: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 00 4d 53 53 51-4c 53 65 72 76 65 72 00 |U...MSSQ LServer.|
0030 a6 5c 00 00 - |.\..|

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

net.c:635:Received packet
0000 00 00 15 00 06 01 00 1b-00 01 02 00 1c 00 01 03 |........ ........|
0010 00 1d 00 00 ff 09 00 0b-e2 00 00 03 00 |........ .....|

login.c:1081:detected flag 3
net.c:982:in tds_push_func
net.c:941:in tds_pull_func
net.c:747:Sending packet
0000 12 01 00 41 00 00 00 00-16 03 01 00 34 01 00 00 |...A.... ....4...|
0010 30 03 01 46 65 74 78 57-ba 57 12 a1 db 13 0e 55 |0..FetxW .W.....U|
0020 55 81 3f 7f 19 8f 24 32-17 a9 0c a0 04 7d 97 f9 |U.?...$2 .....}..|
0030 86 bd 03 00 00 08 00 09-00 03 00 06 00 12 02 01 |........ ........|
0040 00 - |.|

net.c:954:have 0
net.c:958:before read
net.c:556:Received header
0000 12 01 02 62 00 00 00 00- |...b....|


net.c:635:Received packet
0000 16 03 01 02 55 02 00 00-46 03 01 46 65 74 78 8a |....U... F..Fetx.|
0010 d2 e6 ec 48 2b ad 12 76-57 5b 9d 81 57 70 bd c5 |...H+..v W[..Wp..|
0020 47 3e 61 c9 8d b4 28 7c-64 b3 62 20 87 21 00 00 |G>a...(| d.b .!..|
0030 a7 8d ba d3 75 fd 05 71-9c 46 31 bd 2b 2c e1 0e |....u..q .F1.+,..|
0040 a0 15 84 3d d8 10 9b d2-c2 8d 05 d8 00 09 00 0b |...=.... ........|
0050 00 02 03 00 02 00 00 01-fd 30 82 01 f9 30 82 01 |........ .0...0..|
0060 62 a0 03 02 01 02 02 10-d2 13 18 9f 75 ae 7d 97 |b....... ....u.}.|
0070 43 71 d3 a3 34 96 34 6d-30 0d 06 09 2a 86 48 86 |Cq..4.4m 0...*.H.|
0080 f7 0d 01 01 05 05 00 30-3b 31 39 30 37 06 03 55 |.......0 ;1907..U|
0090 04 03 1e 30 00 53 00 53-00 4c 00 5f 00 53 00 65 |...0.S.S .L._.S.e|
00a0 00 6c 00 66 00 5f 00 53-00 69 00 67 00 6e 00 65 |.l.f._.S .i.g.n.e|
00b0 00 64 00 5f 00 46 00 61-00 6c 00 6c 00 62 00 61 |.d._.F.a .l.l.b.a|
00c0 00 63 00 6b 30 1e 17 0d-30 37 30 36 30 31 31 38 |.c.k0... 07060118|
00d0 33 31 31 39 5a 17 0d 33-37 30 36 30 31 31 38 33 |3119Z..3 70601183|
00e0 31 31 39 5a 30 3b 31 39-30 37 06 03 55 04 03 1e |119Z0;19 07..U...|
00f0 30 00 53 00 53 00 4c 00-5f 00 53 00 65 00 6c 00 |0.S.S.L. _.S.e.l.|
0100 66 00 5f 00 53 00 69 00-67 00 6e 00 65 00 64 00 |f._.S.i. g.n.e.d.|
0110 5f 00 46 00 61 00 6c 00-6c 00 62 00 61 00 63 00 |_.F.a.l. l.b.a.c.|
0120 6b 30 81 9f 30 0d 06 09-2a 86 48 86 f7 0d 01 01 |k0..0... *.H.....|
0130 01 05 00 03 81 8d 00 30-81 89 02 81 81 00 cc b7 |.......0 ........|
0140 b9 25 ba 5b 84 30 f7 b3-89 f5 2c e0 56 63 09 56 |.%.[.0.. ..,.Vc.V|
0150 c8 19 c3 98 06 4c a5 5b-7e 5b 7a 8d ec a6 c0 1a |.....L.[ ~[z.....|
0160 6d 55 69 22 1c 61 d6 d8-27 d3 b6 87 3c 03 7a 83 |mUi".a.. '...<.z.|
0170 fd 87 96 2d 9a 59 2b 19-9f c0 7e bd b4 40 ae 01 |...-.Y+. ..~..@..|
0180 4d c4 98 56 e3 f2 01 0f-37 59 f9 5f 01 7e b3 e3 |M..V.... 7Y._.~..|
0190 1f 12 e0 15 6b 44 0f 41-bb d7 4a de a2 05 85 b5 |....kD.A ..J.....|
01a0 f0 85 3c 43 8a b2 a5 c3-05 09 c4 ee 5a 5e b4 0b |..<C.... ....Z^..|
01b0 03 7f 5e e0 32 2c bc 69-35 b3 6b d8 77 a9 02 03 |..^.2,.i 5.k.w...|
01c0 01 00 01 30 0d 06 09 2a-86 48 86 f7 0d 01 01 05 |...0...* .H......|
01d0 05 00 03 81 81 00 6c 1b-f2 0f b5 96 5c 3c 53 18 |......l. ....\<S.|
01e0 e4 43 f4 1e d1 e3 28 ed-bb 54 78 87 44 63 31 9e |.C....(. .Tx.Dc1.|
01f0 bc 7d ae 9e e2 45 bb d4-17 ef 54 3c ef 82 94 e2 |.}...E.. ..T<....|
0200 65 d8 76 68 60 df 3e c8-8d 9d 1f e9 51 cc 20 67 |e.vh`.>. ....Q. g|
0210 4c ab 73 59 d6 26 3d d3-bf 67 20 9c 09 91 57 7d |L.sY.&=. .g ...W}|
0220 a7 e5 0d 03 06 eb 90 f9-af 5f c6 0d 39 fe 69 2c |........ ._..9.i,|
0230 29 bb e2 d8 e0 01 cf d4-bd 74 b0 7a ee f3 1d c9 |)....... .t.z....|
0240 48 3a 1a ad 75 20 9e 52-56 ed cc dc 2c da 1d 13 |H:..u .R V...,...|
0250 24 e9 e6 4e d2 7f 0e 00-00 00 |$..N.... ..|

net.c:961:after read
net.c:954:have 602
net.c:965:read 5 bytes
net.c:941:in tds_pull_func
net.c:954:have 597
net.c:965:read 597 bytes
net.c:982:in tds_push_func
net.c:747:Sending packet
0000 12 01 00 c6 00 00 00 00-16 03 01 00 86 10 00 00 |........ ........|
0010 82 00 80 c0 fd 69 84 40-23 10 de df 16 d8 47 4b |.....i.@ #.....GK|
0020 5a 7c 7a 0e 1c 33 ad 21-0d 94 f6 60 3b fc 39 e4 |Z|z..3.! ...`;.9.|
0030 9c a2 7d 51 17 65 77 68-ca 3c cc 40 26 b2 2e 5a |..}Q.ewh .<.@&..Z|
0040 3e 2c e5 c7 29 27 f4 4d-79 97 22 49 8e c2 4a a8 |>,..)'.M y."I..J.|
0050 34 1a 28 85 ec 87 93 41-36 2f 71 34 71 35 2c 6c |4.(....A 6/q4q5,l|
0060 42 85 9f d4 f9 f5 0b 26-99 72 5e 3c 3a 31 7a 5a |B......& .r^<:1zZ|
0070 f4 b4 91 7c c8 6c 7c e1-ed 42 11 b0 1d ed df 6f |...|.l|. .B.....o|
0080 23 fe 82 7b 55 96 f3 35-52 2c 98 c2 fb 36 c0 1b |#..{U..5 R,...6..|
0090 54 5a ed 14 03 01 00 01-01 16 03 01 00 28 2b 1c |TZ...... .....(+.|
00a0 ef 1e 67 72 8d b0 bc 7e-53 d9 6e da 68 a2 d2 32 |..gr...~ S.n.h..2|
00b0 42 14 ed 86 72 08 b7 77-ab ea 3e 7b ff 62 d2 b2 |B...r..w ..>{.b..|
00c0 7e 1e 4e 86 c4 3d - |~.N..=|

net.c:941:in tds_pull_func
net.c:954:have 0
net.c:958:before read
net.c:556:Received header
0000 12 01 00 3b 00 00 00 00- |...;....|

net.c:635:Received packet
0000 14 03 01 00 01 01 16 03-01 00 28 e9 00 2c 68 0a |........ ..(..,h.|
0010 83 a2 80 5f 12 91 dc 7e-e9 2f 42 68 27 5e 2f 3d |..._...~ ./Bh'^/=|
0020 92 3f d4 c8 ff 32 6a 9b-74 39 84 11 73 43 93 87 |.?...2j. t9..sC..|
0030 ba 00 98 - |...|

net.c:961:after read
net.c:954:have 51
net.c:965:read 5 bytes
net.c:941:in tds_pull_func
net.c:954:have 46
net.c:965:read 1 bytes
net.c:941:in tds_pull_func
net.c:954:have 45
net.c:965:read 5 bytes
net.c:941:in tds_pull_func
net.c:954:have 40
net.c:965:read 40 bytes
net.c:1243:handshake succeeded!!
write.c:136:tds_put_string converting 5 bytes of "gyrus"
write.c:164:tds_put_string wrote 10 bytes
write.c:136:tds_put_string converting 13 bytes of "sympa_listmgr"
write.c:164:tds_put_string wrote 26 bytes
write.c:136:tds_put_string converting 4 bytes of "TSQL"
write.c:164:tds_put_string wrote 8 bytes
write.c:136:tds_put_string converting 15 bytes of "pineal.case.edu"
write.c:164:tds_put_string wrote 30 bytes
write.c:136:tds_put_string converting 11 bytes of "TDS-Library"
write.c:164:tds_put_string wrote 22 bytes
write.c:136:tds_put_string converting 10 bytes of "us_english"
write.c:164:tds_put_string wrote 20 bytes
write.c:164:tds_put_string wrote 0 bytes
login.c:973:quietly sending TDS 7.0 login packet
token.c:309:tds_process_login_tokens()
net.c:941:in tds_pull_func
util.c:334:tdserror(0x80810a8, 0x80844b8, 20004, 104)
util.c:370:tdserror: client library returned TDS_INT_CANCEL(2)
util.c:391:tdserror: returning TDS_INT_CANCEL(2)
util.c:162:Changed query state from IDLE to DEAD
token.c:313:looking for login token, got 0()
token.c:107:tds_process_default_tokens() marker is 0()
token.c:110:leaving tds_process_default_tokens() connection dead
util.c:334:tdserror(0x80810a8, 0x80844b8, 20002, 0)
util.c:370:tdserror: client library returned TDS_INT_CANCEL(2)
util.c:391:tdserror: returning TDS_INT_CANCEL(2)
mem.c:564:tds_free_all_results()





Archive powered by MHonArc 2.6.24.

Top of Page