DB-Library connection trouble #654

taozuhong · 2025-04-28T03:11:54Z

taozuhong
Apr 28, 2025

Environment

freetds: 1.5.1
SQL Server: 2017
Platform: Windows + Docker + WSL2

Issue detail

SQL Server 2017 was installed via docker image, port mapped as 1417, It can be connected via Navicat and tsql command as follow:

But failed with DBKangaroo app via DB-Library, the app code and TDSDUMP log as follow:

 Login login = new Login();
 login.set_app("Kangaroo");
 login.set_host(server.host);
 // login.set_port(server.port);
 login.set_dbname(server.initial);
 login.set_user(server.username);
 login.set_password(server.password);
 login.set_charset("UTF-8");
 login.set_utf16(0);
 login.set_network_auth(1);

 m_connection = login.open(server.host);
 if (null == m_connection) {
     string server_host = "%s:%i".printf(server.host, server.port);
     m_connection = login.open(server_host);
 }

The above code can connect SQL Server 2008/2017/2022 installed on Windows directly

log.c:187:Starting log file for FreeTDS 1.5.1
	on 2025-04-28 11:00:54 with debug flags 0x4fff.
dblib.c:1201:tdsdbopen(000002325b6b2150, localhost:1417, [microsoft])
dblib.c:1227:tdsdbopen: dbproc->dbopts = 000002326bfa8380
dblib.c:1238:tdsdbopen: tds_set_server(00000232570187d0, "localhost:1417")
dblib.c:254:dblib_get_tds_ctx(void)
dblib.c:1255:tdsdbopen: About to call tds_read_config_info...
dblib.c:221:dblib_add_connection(00007ffc32764080, 000002326cdf8dc0)
config.c:164:Getting connection information for [localhost:1417].
config.c:168:Attempting to read conf files.
config.c:338:... $FREETDSCONF not set.  Trying $FREETDS/etc.
config.c:352:... $FREETDS not set.  Trying $HOME.
config.c:300:Found conf file 'C:\Users\taozuhong\AppData\Roaming\.freetds.conf' (.freetds.conf).
config.c:518:Looking for section global.
config.c:577:	Found section global.
config.c:580:Got a match.
config.c:607:	tds version = 'auto'
config.c:979:Setting tds version to auto (0x0).
config.c:607:	enable tls v1 = 'false'
config.c:607:	dump file = '/tmp/freetds.log'
config.c:607:	debug flags = '0xffff'
config.c:577:	Found section egserver50.
config.c:577:	Found section egserver73.
config.c:577:	Found section sql2008.
config.c:577:	Found section sql2017.
config.c:577:	Found section docker2017.
config.c:577:	Found section sql2022.
config.c:591:	Reached EOF
config.c:518:Looking for section localhost:1417.
config.c:577:	Found section global.
config.c:577:	Found section egserver50.
config.c:577:	Found section egserver73.
config.c:577:	Found section sql2008.
config.c:577:	Found section sql2017.
config.c:577:	Found section docker2017.
config.c:577:	Found section sql2022.
config.c:591:	Reached EOF
config.c:306:[localhost:1417] not found.
config.c:296:Could not open 'c:\freetds.conf' ((default)).
config.c:338:... $FREETDSCONF not set.  Trying $FREETDS/etc.
config.c:352:... $FREETDS not set.  Trying $HOME.
config.c:300:Found conf file 'C:\Users\taozuhong\AppData\Roaming\.freetds.conf' (.freetds.conf).
config.c:518:Looking for section global.
config.c:577:	Found section global.
config.c:580:Got a match.
config.c:607:	tds version = 'auto'
config.c:979:Setting tds version to auto (0x0).
config.c:607:	enable tls v1 = 'false'
config.c:607:	dump file = '/tmp/freetds.log'
config.c:607:	debug flags = '0xffff'
config.c:577:	Found section egserver50.
config.c:577:	Found section egserver73.
config.c:577:	Found section sql2008.
config.c:577:	Found section sql2017.
config.c:577:	Found section docker2017.
config.c:577:	Found section sql2022.
config.c:591:	Reached EOF
config.c:518:Looking for section localhost.
config.c:577:	Found section global.
config.c:577:	Found section egserver50.
config.c:577:	Found section egserver73.
config.c:577:	Found section sql2008.
config.c:577:	Found section sql2017.
config.c:577:	Found section docker2017.
config.c:577:	Found section sql2022.
config.c:591:	Reached EOF
config.c:306:[localhost] not found.
config.c:296:Could not open 'c:\freetds.conf' ((default)).
config.c:860:Setting 'dump_file' to 'tds.log' from $TDSDUMP.
config.c:746:tds_config_login: client_charset is UTF-8.
config.c:755:tds_config_login: database_name is Kangaroo.
config.c:860:Setting 'dump_file' to 'tds.log' from $TDSDUMP.
dblib.c:1291:tdsdbopen: Calling tds_connect_and_login(000002326cdf8dc0, 000002326c8541f0)
iconv.c:371:tds_iconv_open(00000232682940b0, UTF-8, 0)
iconv.c:390:setting up conversions for client charset "UTF-8"
iconv.c:392:preparing iconv for "UTF-8" <-> "UCS-2LE" conversion
iconv.c:431:tds_iconv_open: done
net.c:369:Connecting with protocol version 7.4
net.c:295:Connecting to ::1 port 1417
net.c:317:tds_setup_socket: connect(2) returned "无法立即完成一个非阻止性套接字操作。
"
net.c:295:Connecting to 127.0.0.1 port 1417
net.c:317:tds_setup_socket: connect(2) returned "无法立即完成一个非阻止性套接字操作。
"
net.c:506:tds_open_socket() succeeded
packet.c:848:Sending packet
0000 12 01 00 3a 00 00 00 00-00 00 1a 00 06 01 00 20 |...:.... ....... |
0010 00 01 02 00 21 00 0c 03-00 2d 00 04 04 00 31 00 |....!... .-....1.|
0020 01 ff 09 00 00 00 00 00-00 4d 53 53 51 4c 53 65 |..	..... .MSSQLSe|
0030 72 76 65 72 00 50 49 00-00 00                   |rver.PI. ..|

packet.c:406: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 0e 00 0b d5 00 00-00 00 00                |........ ...|

login.c:1463:detected crypt flag 0
tls.c:1091:setting default openssl cipher to:HIGH:!SSLv2:!aNULL:-DH
tls.c:158:in tds_push_func_login
tls.c:128:in tds_pull_func_login
packet.c:848:Sending packet
0000 12 01 06 19 00 00 00 00-16 03 01 06 0c 01 00 06 |........ ........|
0010 08 03 03 f9 97 ab 80 32-d7 38 f8 ad 69 7d a5 e0 |.......2 .8..i}..|
0020 c1 dc 5d 85 4d 93 e6 58-67 f1 2e 48 3c 73 60 15 |..].M..X g..H<s`.|
0030 9b f3 bc 20 a4 23 0a dc-6a d5 b3 18 c3 cc 44 78 |... .#.. j.....Dx|
0040 89 6e f2 53 6d 65 da 63-dd 0a 42 65 97 dd 72 49 |.n.Sme.c ..Be..rI|
0050 6d 43 0c 4f 00 52 13 02-13 03 13 01 c0 2c c0 30 |mC.O.R.. .....,.0|
0060 cc a9 cc a8 c0 ad c0 5d-c0 61 c0 2b c0 2f c0 ac |.......] .a.+./..|
0070 c0 5c c0 60 c0 24 c0 28-c0 73 c0 77 c0 23 c0 27 |.\.`.$.( .s.w.#.'|
0080 c0 72 c0 76 c0 0a c0 14-c0 09 c0 13 00 9d c0 9d |.r.v.... .	......|
0090 c0 51 00 9c c0 9c c0 50-00 3d 00 c0 00 3c 00 ba |.Q.....P .=...<..|
00a0 00 35 00 84 00 2f 00 41-01 00 05 6d ff 01 00 01 |.5.../.A ...m....|
00b0 00 00 0b 00 04 03 00 01-02 00 0a 00 12 00 10 11 |........ ........|
00c0 ec 00 1d 00 17 00 1e 00-18 00 19 01 00 01 01 00 |........ ........|
00d0 23 00 00 00 16 00 00 00-17 00 00 00 0d 00 36 00 |#....... ......6.|
00e0 34 09 05 09 06 09 04 04-03 05 03 06 03 08 07 08 |4	.	.	.. ........|
00f0 08 08 1a 08 1b 08 1c 08-09 08 0a 08 0b 08 04 08 |........ 	.......|
0100 05 08 06 04 01 05 01 06-01 03 03 03 01 03 02 04 |........ ........|
0110 02 05 02 06 02 00 2b 00-05 04 03 04 03 03 00 2d |......+. .......-|
0120 00 02 01 01 00 33 04 ea-04 e8 11 ec 04 c0 f7 44 |.....3.. .......D|
0130 62 52 53 19 30 2b 7d 19-35 a0 7d a8 52 55 03 4b |bRS.0+}. 5.}.RU.K|
0140 3b 63 04 b9 9b 05 2c 7b-5b f7 bc 5b 14 07 2a b5 |;c....,{ [..[..*.|
0150 48 71 1e 9b 23 59 04 20-90 b0 88 d9 f1 78 1c 02 |Hq..#Y.  .....x..|
0160 5d 12 10 64 3a 12 14 21-26 5f 6c db 0b e4 c9 03 |]..d:..! &_l.....|
0170 e6 47 bc 90 29 63 78 a3-49 0b aa 6a af 94 66 d5 |.G..)cx. I..j..f.|
0180 d6 70 9d 66 7d 62 e6 3c-c5 eb 3c 2f 5b 66 73 65 |.p.f}b.< ..</[fse|
0190 90 4c 93 25 36 22 21 5f-eb ac fc 38 46 2b 1b 9e |.L.%6"!_ ...8F+..|
01a0 74 30 12 8c f4 b3 19 cb-38 62 66 84 8d b5 5e a3 |t0...... 8bf...^.|
01b0 26 b0 9b f9 66 15 3a 2a-08 97 08 69 b8 aa 02 e0 |&...f.:* ...i....|
01c0 7f d8 96 01 96 73 0c 86-7a ba e4 8a 57 30 e6 bc |.....s.. z...W0..|
01d0 8c 3a c6 82 63 38 d6 c9-85 5f 88 bc e4 a9 59 c1 |.:..c8.. ._....Y.|
01e0 ac 0a c9 75 7a bc 24 01-56 c5 3c d8 c3 8b b8 f1 |...uz.$. V.<.....|
01f0 c8 05 03 55 99 f6 a9 66-54 73 d6 65 bc 83 ac 5f |...U...f Ts.e..._|
0200 13 5c 6a 60 ea 96 c0 b1-53 4f 58 14 48 a6 30 e0 |.\j`.... SOX.H.0.|
0210 d0 08 42 15 2a 20 db 1a-8f db 6f 65 30 a4 44 50 |..B.* .. ..oe0.DP|
0220 4b 8d 51 aa 5c fa 9f 7f-f7 6f 42 73 87 a1 d8 a6 |K.Q.\... .oBs....|
0230 c7 ca 31 64 2a 5b 69 06-86 88 4a 7a 7e 36 c1 c0 |..1d*[i. ..Jz~6..|
0240 fa 98 52 50 33 1e fb 1a-f5 58 86 5c e8 60 7d d6 |..RP3... .X.\.`}.|
0250 5e b8 31 2c df 33 67 d1-17 5b 79 f6 24 16 09 a7 |^.1,.3g. .[y.$.	.|
0260 b4 d4 01 c2 f6 50 65 35-6e d8 89 77 ab 7c 17 7a |.....Pe5 n..w.|.z|
0270 40 ad 17 36 39 aa 54 10-0a d6 4a 6d e7 62 c5 05 |@..69.T. ..Jm.b..|
0280 02 23 97 61 fe 38 7d 7d-b8 76 ff ab 84 66 65 42 |.#.a.8}} .v...feB|
0290 67 bc 95 c0 17 06 83 75-c0 31 14 43 9e 1a ce 67 |g......u .1.C...g|
02a0 66 02 dc e5 83 b3 a5 5f-d4 16 8c a9 a2 9c 17 91 |f......_ ........|
02b0 02 7b 26 63 66 43 95 10-b9 5c 28 0c 40 da 2a 0f |.{&cfC.. .\(.@.*.|
02c0 65 91 48 bc 65 51 fa 7a-14 cd b7 73 58 e6 40 aa |e.H.eQ.z ...sX.@.|
02d0 7b ba 14 f3 c7 df 67 01-31 d7 9e b9 b4 56 73 9b |{.....g. 1....Vs.|
02e0 a8 50 1b 32 3c b8 a6 60-53 74 c4 d7 91 4d 72 45 |.P.2<..` St...MrE|
02f0 7e d8 5b 80 f3 97 86 92-ca c9 2c 52 87 0b 06 8c |~.[..... ..,R....|
0300 f5 5b de f7 85 90 e7 58-6e 56 2f d8 95 35 87 b3 |.[.....X nV/..5..|
0310 7f 4b 65 3b 61 0c 2b c7-d9 88 1b 56 20 70 d7 3d |.Ke;a.+. ...V p.=|
0320 4a 0a 83 a1 87 66 d9 da-5d 50 6b 5c 78 49 5c 7d |J....f.. ]Pk\xI\}|
0330 46 4b fb fa 0b a6 36 cc-19 db 30 e8 12 74 97 35 |FK....6. ..0..t.5|
0340 29 b9 d0 88 66 67 4d 04-41 3b 21 a2 cb f3 86 9c |)...fgM. A;!.....|
0350 59 79 0d ad 98 79 de 5a-9a da f4 cb 43 8a aa 8c |Yy...y.Z ....C...|
0360 26 20 44 d1 8d e8 d5 51-e1 2a bd e7 fc 3b bb d1 |& D....Q .*...;..|
0370 bb b1 d9 51 a3 40 5f 3b-30 7d 98 09 bb 6c b7 70 |...Q.@_; 0}.	.l.p|
0380 b1 c2 50 65 a8 cd 5e 40-bc 89 5b 19 84 6b 82 c2 |..Pe..^@ ..[..k..|
0390 e5 03 70 18 a6 eb aa a7-01 a3 9a 93 33 41 53 08 |..p..... ....3AS.|
03a0 12 29 17 be 70 76 cb 70-42 9b 03 2c 85 99 a8 96 |.)..pv.p B..,....|
03b0 87 6b 97 51 cb 18 f0 e6-84 63 ba 52 8b a8 ca aa |.k.Q.... .c.R....|
03c0 4a 1c 78 99 0e 1e 37 91-f7 cc bf 3d c8 4a e1 f0 |J.x...7. ...=.J..|
03d0 b0 c5 33 1a cd 48 af 4a-d7 62 01 10 1e 2a 8c 7b |..3..H.J .b...*.{|
03e0 cd 33 ab 1e 00 0d b6 ac-33 de 51 ce de 3a 00 4e |.3...... 3.Q..:.N|
03f0 50 08 b5 e7 89 5c 39 a9-08 32 51 27 73 2e 45 3b |P....\9. .2Q's.E;|
0400 bb 20 1b bc 90 26 7c 68-87 53 aa 0c 89 34 f9 1f |. ...&|h .S...4..|
0410 3d c1 9b 7e 41 b9 15 c5-3a 9b a2 21 b0 64 43 91 |=..~A... :..!.dC.|
0420 63 7b 3a 8c 0f 0c 79 cc-8c d8 48 d9 c5 9c 8c c8 |c{:...y. ..H.....|
0430 88 e5 b0 44 7a f6 b1 31-a7 b3 18 12 1c 04 f4 b3 |...Dz..1 ........|
0440 15 57 45 fe ca 9c 53 80-72 52 67 4b 14 20 66 20 |.WE...S. rRgK. f |
0450 dc 25 81 1a 8b c7 c8 cf-5b e4 a7 6a a8 3f 92 79 |.%...... [..j.?.y|
0460 72 1c 77 1b d2 62 37 6b-88 10 90 46 30 86 07 c6 |r.w..b7k ...F0...|
0470 91 54 cb 62 52 b1 d4 0a-6b ef a2 a4 99 a6 84 95 |.T.bR... k.......|
0480 9a 3f f9 f8 8f 12 70 2f-62 07 30 92 72 90 5d 04 |.?....p/ b.0.r.].|
0490 a0 fc a7 ad 74 62 4d 7a-92 b3 9d 50 c4 4a e8 20 |....tbMz ...P.J. |
04a0 87 01 c2 0c 21 60 f1 d6-13 90 61 63 49 26 3a 83 |....!`.. ..acI&:.|
04b0 38 15 5b e5 bd 4a d9 a5-03 93 8c 0b 58 a7 69 a8 |8.[..J.. ....X.i.|
04c0 8a dd b2 88 82 06 6c 33-52 8b a7 98 bb 42 76 24 |......l3 R....Bv$|
04d0 56 59 a1 15 41 84 14 49-56 ac c7 98 46 39 2c 08 |VY..A..I V...F9,.|
04e0 d5 28 43 93 29 e7 29 46-e4 e2 6a 42 39 b1 cd 36 |.(C.).)F ..jB9..6|
04f0 68 1c e8 4a 9f 67 46 e0-68 ab 57 dc be da b6 17 |h..J.gF. h.W.....|
0500 6f 5a 9f f5 73 a3 39 50-83 f4 14 34 82 72 0f f3 |oZ..s.9P ...4.r..|
0510 f8 80 e1 a3 23 29 c8 b8-d2 35 85 3b 10 7c 2c eb |....#).. .5.;.|,.|
0520 30 dc e8 3e 02 7c 17 dd-13 be 81 b7 93 a2 96 9c |0..>.|.. ........|
0530 50 d4 2f 60 53 90 97 4b-2a ea 5b 28 19 8a 55 37 |P./`S..K *.[(..U7|
0540 cb 19 e4 e0 4d 40 d6 b9-fd 3c 7c c3 a9 95 5c 88 |....M@.. .<|...\.|
0550 1a bd 45 b3 f1 46 98 74-98 36 a4 09 93 b0 76 38 |..E..F.t .6.	..v8|
0560 e4 3b 53 e5 0a ca 3c 84-7c df b3 a2 e3 90 32 d8 |.;S...<. |.....2.|
0570 a8 ce 7b 36 1f c5 eb 07-69 94 06 fc 7b 67 a0 ab |..{6.... i...{g..|
0580 bf e0 30 81 e6 94 46 44-b1 43 fb e6 4b 7d 24 6c |..0...FD .C..K}$l|
0590 d4 58 c1 47 17 12 2c 81-72 55 28 41 43 c1 a7 7d |.X.G..,. rU(AC..}|
05a0 d9 0a 48 c6 5a eb a8 68-2f 79 1b 2e 45 ad 79 e2 |..H.Z..h /y..E.y.|
05b0 a5 73 bc e4 fe 83 5e 43-5f d8 f2 64 87 89 78 be |.s....^C _..d..x.|
05c0 7c 5e 2b f0 14 6e 33 c4-f7 df 41 b4 1f 47 44 3c ||^+..n3. ..A..GD<|
05d0 87 1d 84 c6 45 91 53 52-38 8a 77 99 d0 17 d4 69 |....E.SR 8.w....i|
05e0 40 6d 07 19 34 38 b6 97-30 53 1b 70 c5 0a 00 1d |@m..48.. 0S.p....|
05f0 00 20 55 0d 1c 38 ba 0a-79 1d b6 ef bb bb 35 9f |. U..8.. y.....5.|
0600 2d 19 8a ab a2 49 1f 95-94 3f e2 2a 04 d1 b9 88 |-....I.. .?.*....|
0610 ef 08 00 1b 00 03 02 00-01                      |........ .|

packet.c:406:Received packet
0000 12 01 04 7b 00 00 00 00-16 03 03 00 3d 02 00 00 |...{.... ....=...|
0010 39 03 03 52 ca 63 85 2a-f9 f3 68 ab 35 93 4d b6 |9..R.c.* ..h.5.M.|
0020 fd dc c2 80 15 f4 46 ff-c8 08 ec 01 12 80 c8 38 |......F. .......8|
0030 26 0d 27 00 c0 30 00 00-11 ff 01 00 01 00 00 0b |&.'..0.. ........|
0040 00 04 03 00 01 02 00 23-00 00 16 03 03 02 d1 0b |.......# ........|
0050 00 02 cd 00 02 ca 00 02-c7 30 82 02 c3 30 82 01 |........ .0...0..|
0060 ab 02 08 a5 b9 ff 71 a5-bb f3 e6 30 0d 06 09 2a |......q. ...0..	*|
0070 86 48 86 f7 0d 01 01 0b-05 00 30 23 31 21 30 1f |.H...... ..0#1!0.|
0080 06 03 55 04 03 0c 18 53-53 4c 5f 53 65 6c 66 5f |..U....S SL_Self_|
0090 53 69 67 6e 65 64 5f 46-61 6c 6c 62 61 63 6b 30 |Signed_F allback0|
00a0 20 17 0d 32 35 30 34 32-37 32 33 35 35 35 33 5a | ..25042 7235553Z|
00b0 18 0f 32 30 35 35 30 34-32 37 32 33 35 35 35 33 |..205504 27235553|
00c0 5a 30 23 31 21 30 1f 06-03 55 04 03 0c 18 53 53 |Z0#1!0.. .U....SS|
00d0 4c 5f 53 65 6c 66 5f 53-69 67 6e 65 64 5f 46 61 |L_Self_S igned_Fa|
00e0 6c 6c 62 61 63 6b 30 82-01 22 30 0d 06 09 2a 86 |llback0. ."0..	*.|
00f0 48 86 f7 0d 01 01 01 05-00 03 82 01 0f 00 30 82 |H....... ......0.|
0100 01 0a 02 82 01 01 00 a9-fb c1 ad 59 a5 a4 ca 54 |........ ...Y...T|
0110 3c 4c c9 f0 38 a9 76 8c-99 62 10 1f 82 9d 75 8d |<L..8.v. .b....u.|
0120 a7 e6 57 bc 58 35 69 29-f9 ad a8 73 9b 1c 9b a1 |..W.X5i) ...s....|
0130 6f 13 eb 88 da 89 bb fb-04 8f 21 10 ee 20 1e fe |o....... ..!.. ..|
0140 5c 2a a9 d2 2d c6 b5 00-e2 b9 e8 4d a1 d4 8b ce |\*..-... ...M....|
0150 3f aa 18 66 cb f6 ea 46-72 4b f2 dd 8b 54 c0 e8 |?..f...F rK...T..|
0160 f5 78 aa 98 ca b1 32 86-a0 eb b7 bf 50 04 d8 39 |.x....2. ....P..9|
0170 0a 77 46 58 73 51 b1 8c-d4 8f 91 1e 6b ed 38 b6 |.wFXsQ.. ....k.8.|
0180 ee a5 f0 2b 97 2a 62 ca-28 50 2d 84 ad 78 60 ea |...+.*b. (P-..x`.|
0190 15 87 f3 23 a7 c9 d2 59-3c b9 23 e9 36 7f af a4 |...#...Y <.#.6...|
01a0 d2 45 87 5f 4d 4d 5d 1c-e7 72 fa ed d6 bc 43 27 |.E._MM]. .r....C'|
01b0 db f6 65 57 57 8f 98 7a-66 9a 02 eb fa cd f4 bb |..eWW..z f.......|
01c0 42 0b 8c 22 10 63 1a 1b-9c 8e 44 37 3e 0d 86 6a |B..".c.. ..D7>..j|
01d0 c7 b3 54 4c 1f b0 60 3f-90 dd 94 07 62 73 7c 3d |..TL..`? ....bs|=|
01e0 d7 20 84 c7 b2 f0 c0 28-a7 a2 2f 43 02 cb d6 5d |. .....( ../C...]|
01f0 70 98 97 b4 18 8d 7f 93-ad 2d 85 80 d6 21 3d 2f |p....... .-...!=/|
0200 f3 f4 9a dd c2 24 37 02-03 01 00 01 30 0d 06 09 |.....$7. ....0..	|
0210 2a 86 48 86 f7 0d 01 01-0b 05 00 03 82 01 01 00 |*.H..... ........|
0220 0a ac 29 a3 9f 81 6f 9b-1f 1d a8 94 cb 46 96 77 |..)...o. .....F.w|
0230 3a b6 37 8d 25 3e c3 56-a1 7f 5d 5f 72 9f 6b f1 |:.7.%>.V ..]_r.k.|
0240 eb c4 1e 18 89 21 ac 67-48 9e f6 da 6f c1 2e 0f |.....!.g H...o...|
0250 db bb 8a f5 76 ee 29 11-72 f5 94 02 b9 f5 a8 44 |....v.). r......D|
0260 60 ac 52 c2 de b5 26 91-4d df 13 14 36 3d 3c f0 |`.R...&. M...6=<.|
0270 62 9a 5c 38 5b 37 e6 f5-b1 03 d6 a8 77 e8 a7 de |b.\8[7.. ....w...|
0280 87 93 d3 14 5a 34 12 84-b9 75 d7 79 87 73 57 b5 |....Z4.. .u.y.sW.|
0290 41 4a c3 42 4e cd 24 9c-c9 f2 a7 c8 2b f4 38 49 |AJ.BN.$. ....+.8I|
02a0 6c 0b a6 7b 04 3b ff 19-43 90 d5 cd a9 86 ef e3 |l..{.;.. C.......|
02b0 b3 75 71 ae 26 03 26 d9-fc 1e d1 4b 2f fc 96 d1 |.uq.&.&. ...K/...|
02c0 15 2a 96 d4 ea ea db dc-7e 57 ca e0 9f f1 6a de |.*...... ~W....j.|
02d0 e3 ab da 6f e0 9e 77 21-53 a6 07 71 2a 5f 12 a5 |...o..w! S..q*_..|
02e0 a8 10 55 61 db d0 f2 46-9f 2c 23 97 54 61 1e 24 |..Ua...F .,#.Ta.$|
02f0 8e 99 b2 f3 b2 58 79 9a-ef b0 b8 73 c9 fd 73 06 |.....Xy. ...s..s.|
0300 1a 44 b1 01 d6 8c 39 71-24 ad 4c 56 41 e9 b2 d2 |.D....9q $.LVA...|
0310 3e d2 53 7c 6b c2 3d 15-38 10 22 72 d3 2f c8 95 |>.S|k.=. 8."r./..|
0320 16 03 03 01 4d 0c 00 01-49 03 00 17 41 04 3a 21 |....M... I...A.:!|
0330 9a fb db 23 e3 47 2e 57-d0 a1 75 8b 5e cc 3f fa |...#.G.W ..u.^.?.|
0340 99 04 13 ac e6 84 b6 86-48 44 4d 09 51 08 44 89 |........ HDM	Q.D.|
0350 58 94 d5 3f ea f5 4f 93-67 f1 a0 8b f3 5c eb 51 |X..?..O. g....\.Q|
0360 89 e5 7f 36 a7 9d 5d 49-d9 7d 99 e5 95 06 04 01 |...6..]I .}......|
0370 01 00 0f 7a dc bb ce 30-a2 d8 e7 e7 de 1f 01 f8 |...z...0 ........|
0380 10 4b 35 a5 c0 20 f9 17-1e 9c af b2 9a 94 59 5e |.K5.. .. ......Y^|
0390 a1 33 5e aa 85 7b cf d5-85 5d 72 c3 c9 0e 60 d5 |.3^..{.. .]r...`.|
03a0 ad f3 f4 c5 fc a5 1e 30-68 f0 c1 b7 6e 1a 55 28 |.......0 h...n.U(|
03b0 ef 5c 41 49 b0 bf 3c 87-ed 21 72 29 75 5f 92 ff |.\AI..<. .!r)u_..|
03c0 1d 3e 67 db 1e be 67 84-39 01 e5 75 a5 d7 fe 63 |.>g...g. 9..u...c|
03d0 e0 bc ec 91 16 59 d4 8a-b9 d4 86 f3 11 fa 59 bd |.....Y.. ......Y.|
03e0 ea 80 05 42 fc 1a 53 3f-23 78 db 56 0e 6e 46 a0 |...B..S? #x.V.nF.|
03f0 b6 a4 c8 3f 03 df d8 b2-93 32 73 e2 54 45 30 6d |...?.... .2s.TE0m|
0400 8c 3c b2 8f a3 57 7f d1-4e ce 61 93 0a 29 ea ee |.<...W.. N.a..)..|
0410 06 76 b5 d3 f2 91 e0 87-ef 4c 6a bb 15 70 03 35 |.v...... .Lj..p.5|
0420 8b 41 29 b3 05 be 5e ef-4b 9b 6e 1e f3 53 c7 21 |.A)...^. K.n..S.!|
0430 d9 74 bf ea 15 36 09 08-ad 0b e7 af 52 07 91 a8 |.t...6	. ....R...|
0440 d8 34 22 31 4f 52 69 6b-c0 70 c7 ff b0 bc b3 46 |.4"1ORik .p.....F|
0450 01 32 87 fd fe 58 64 a6-1c 0e c6 d2 45 29 bc 69 |.2...Xd. ....E).i|
0460 7b 8f 41 be 17 fc 5c 85-7b 4a fa f4 4a 0e 29 1d |{.A...\. {J..J.).|
0470 e8 1a 16 03 03 00 04 0e-00 00 00                |........ ...|

tls.c:128:in tds_pull_func_login
tls.c:128:in tds_pull_func_login
tls.c:128:in tds_pull_func_login
tls.c:128:in tds_pull_func_login
tls.c:128:in tds_pull_func_login
tls.c:128:in tds_pull_func_login
tls.c:128:in tds_pull_func_login
tls.c:158:in tds_push_func_login
tls.c:128:in tds_pull_func_login
packet.c:848:Sending packet
0000 12 01 00 86 00 00 00 00-16 03 03 00 46 10 00 00 |........ ....F...|
0010 42 41 04 fe 35 21 a6 a2-74 c6 65 6a fe 62 29 93 |BA..5!.. t.ej.b).|
0020 fe 01 1e 8f e6 58 54 f6-99 57 37 67 db 98 66 de |.....XT. .W7g..f.|
0030 44 64 16 77 4c 69 78 83-31 df 5d 7d 17 ac f8 bf |Dd.wLix. 1.]}....|
0040 bb 66 57 45 41 a5 bc ff-b0 4a 67 d0 93 b3 ce e5 |.fWEA... .Jg.....|
0050 91 3f bc 14 03 03 00 01-01 16 03 03 00 28 98 e4 |.?...... .....(..|
0060 cf 22 40 e3 ea e0 84 62-cd d4 05 25 fa 7b d7 61 |."@....b ...%.{.a|
0070 32 89 ad 7a fc 7f bf ab-91 3a 7b 12 a8 b6 19 46 |2..z.... .:{....F|
0080 84 a4 ed d3 4c 4b      -                        |....LK|

packet.c:406:Received packet
0000 12 01 00 ea 00 00 00 00-16 03 03 00 aa 04 00 00 |........ ........|
0010 a6 00 00 01 2c 00 a0 ce-33 fb e9 91 78 78 83 f0 |....,... 3...xx..|
0020 5f b6 a2 0e d0 20 20 67-09 f2 1a 7d 90 b5 35 1f |_....  g 	..}..5.|
0030 65 2d 54 7d f8 24 0c 41-fd 76 96 05 3e cd ed 15 |e-T}.$.A .v..>...|
0040 85 43 0c 43 ec 7e 61 de-d3 09 fa 63 86 0d 59 1b |.C.C.~a. .	.c..Y.|
0050 75 b0 9d 7c 96 bd 00 0c-16 e2 9c 9e 34 62 d0 2f |u..|.... ....4b./|
0060 61 62 25 f1 92 66 7e b4-34 a2 c8 ae 87 b4 f9 40 |ab%..f~. 4......@|
0070 ba 18 ee 7c e4 a2 7a 71-10 fb e1 b0 27 e2 97 fc |...|..zq ....'...|
0080 ca 82 37 4b a6 7b 7c 64-f4 c0 5c 0f d4 af f7 10 |..7K.{|d ..\.....|
0090 d7 f1 86 36 dc 55 1b 8d-ba 39 2e 3d ad 9e c3 af |...6.U.. .9.=....|
00a0 46 b0 45 a3 bf 05 b8 58-9d 50 3d 54 03 b9 28 2b |F.E....X .P=T..(+|
00b0 ca cf 10 89 bb 42 e3 14-03 03 00 01 01 16 03 03 |.....B.. ........|
00c0 00 28 8d 51 82 3d 80 77-24 d5 32 23 b9 49 00 38 |.(.Q.=.w $.2#.I.8|
00d0 f3 b3 7f dc de bc 89 bd-0e 3f 0d 84 2b 16 50 c9 |........ .?..+.P.|
00e0 ed 61 f0 3c 13 06 41 b7-ce de                   |.a.<..A. ..|

tls.c:128:in tds_pull_func_login
tls.c:128:in tds_pull_func_login
tls.c:128:in tds_pull_func_login
tls.c:128:in tds_pull_func_login
tls.c:128:in tds_pull_func_login
tls.c:1139:handshake succeeded!!
login.c:1055:using SSPI authentication for '' account
login.c:1153:quietly sending TDS 7+ login packet
token.c:423:tds_process_login_tokens()
packet.c:406:Received packet
0000 04 01 00 21 00 00 00 00-ed 16 00 a1 14 30 12 a0 |...!.... .....0..|
0010 03 0a 01 03 a1 0b 06 09-2a 86 48 82 f7 12 01 02 |.......	 *.H.....|
0020 02                     -                        |.|

token.c:427:looking for login token, got  ed(AUTH)
token.c:131:tds_process_default_tokens() marker is ed(AUTH)
token.c:474:TDS_AUTH_TOKEN PDU size 22
login.c:693:login packet accepted
query.c:3797:tds_disconnect() 
util.c:179:Changed query state from IDLE to DEAD
util.c:333:tdserror(00000084c61feff0, 000002326cdf8dc0, 20002, 0)
util.c:363:tdserror: client library returned TDS_INT_CANCEL(2)
util.c:386:tdserror: returning TDS_INT_CANCEL(2)
dblib.c:8185:dbperror(000002325203d480, 20002, 0)
dblib.c:8253:dbperror: Calling dblib_err_handler with msgno = 20002; msg->msgtext = "TDS server connection failed (localhost)"
dblib.c:6354:dbgetchar(000002325203d480, 0)
dblib.c:6356:dbgetchar() bufsz = 0, pos = 0
dblib.c:6002:dbgetuserdata(000002325203d480)
dblib.c:8275:dbperror: dblib_err_handler for msgno = 20002; msg->msgtext = "TDS server connection failed (localhost)" -- returns 2 (INT_CANCEL)
util.c:333:tdserror(0000023267bf3f70, 000002326cdf8dc0, 20002, 0)
dblib.c:8185:dbperror(000002325203d480, 20002, 0)
dblib.c:8253:dbperror: Calling dblib_err_handler with msgno = 20002; msg->msgtext = "TDS server connection failed (localhost)"
dblib.c:6354:dbgetchar(000002325203d480, 0)
dblib.c:6356:dbgetchar() bufsz = 0, pos = 0
dblib.c:6002:dbgetuserdata(000002325203d480)
dblib.c:8275:dbperror: dblib_err_handler for msgno = 20002; msg->msgtext = "TDS server connection failed (localhost)" -- returns 2 (INT_CANCEL)
util.c:363:tdserror: client library returned TDS_INT_CANCEL(2)
util.c:386:tdserror: returning TDS_INT_CANCEL(2)
dblib.c:1300:tdsdbopen: tds_connect_and_login failed for "localhost"!
dblib.c:1510:dbclose(000002325203d480)
dblib.c:239:dblib_del_connection(00007ffc32764080, 000002326cdf8dc0)
mem.c:665:tds_free_all_results()
dblib.c:281:dblib_release_tds_ctx(1)
dblib.c:6104:dbfreebuf(000002325203d480)
dblib.c:748:dbloginfree(000002325b6b2150)

tds.log

freddy77 · 2025-04-28T06:21:44Z

freddy77
Apr 28, 2025
Maintainer

Looking at the logs

log.c:187:Starting log file for FreeTDS 1.5.1
on 2025-04-28 11:00:54 with debug flags 0x4fff.
dblib.c:1201:tdsdbopen(000002325b6b2150, localhost:1417, [microsoft])

I suppose you are passing "localhost:1417" from PHP.

config.c:164:Getting connection information for [localhost:1417].
config.c:168:Attempting to read conf files.
config.c:338:... $FREETDSCONF not set. Trying $FREETDS/etc.
config.c:352:... $FREETDS not set. Trying $HOME.
config.c:300:Found conf file 'C:\Users\taozuhong\AppData\Roaming.freetds.conf' (.freetds.conf).

So PHP is on Windows

config.c:306:[localhost:1417] not found.
...
config.c:306:[localhost] not found.

There are neither "localhost:1417" not "localhost" in the configuration.

config.c:746:tds_config_login: client_charset is UTF-8.
config.c:755:tds_config_login: database_name is Kangaroo.

no idea where these settings came from, probably PHP.

net.c:506:tds_open_socket() succeeded

TCP connection succeeded

tls.c:1139:handshake succeeded!!

TLS setup succeeded

login.c:1055:using SSPI authentication for '' account
login.c:1153:quietly sending TDS 7+ login packet
token.c:423:tds_process_login_tokens()
packet.c:406:Received packet
0000 04 01 00 21 00 00 00 00-ed 16 00 a1 14 30 12 a0 |...!.... .....0..|
0010 03 0a 01 03 a1 0b 06 09-2a 86 48 82 f7 12 01 02 |....... *.H.....|
0020 02 - |.|

token.c:427:looking for login token, got ed(AUTH)
token.c:131:tds_process_default_tokens() marker is ed(AUTH)
token.c:474:TDS_AUTH_TOKEN PDU size 22
login.c:693:login packet accepted
query.c:3797:tds_disconnect()
util.c:179:Changed query state from IDLE to DEAD

Here you are using integrated authentication while with tsql test you used standard sql username/password. Is this expected? Did you join the docker image to the AD domain?

1 reply

taozuhong Apr 28, 2025
Author

 Login login = new Login();
 login.set_app("Kangaroo");
 login.set_host(server.host);
 // login.set_port(server.port);
 login.set_dbname(server.initial);
 login.set_user(server.username);
 login.set_password(server.password);
 login.set_charset("UTF-8");
 login.set_utf16(0);
 login.set_network_auth(1);

 m_connection = login.open(server.host);
 if (null == m_connection) {
     string server_host = "%s:%i".printf(server.host, server.port);
     m_connection = login.open(server_host);
 }

The Vala code translate to C code, then call dblib api directly, the code logic opens the connection two times, the hostname without port at the first time, then cancat the hostname and port together at the second time while the first time failed

Did you join the docker image to the AD domain?

the SQL Server 2017 docker image without AD domain.

I want to open the connection with host/port/user/password directly, without configuration file.

freddy77 · 2025-04-29T07:08:16Z

freddy77
Apr 29, 2025
Maintainer

Can you try removing the

login.set_network_auth(1);

line?

0 replies

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Uh oh!

DB-Library connection trouble #654

Uh oh!

{{title}}

Uh oh!

Uh oh!

{{editor}}'s edit

{{editor}}'s edit

Uh oh!

Replies: 2 comments 1 reply

Uh oh!

{{title}}

Uh oh!

Uh oh!

{{title}}

Uh oh!

Uh oh!

{{editor}}'s edit

{{editor}}'s edit

Uh oh!

Uh oh!

{{title}}

Uh oh!

Select a reply

Uh oh!

DB-Library connection trouble #654

Uh oh!

Uh oh!

taozuhong Apr 28, 2025

Environment

Issue detail

Replies: 2 comments · 1 reply

Uh oh!

freddy77 Apr 28, 2025 Maintainer

Uh oh!

Uh oh!

taozuhong Apr 28, 2025 Author

Uh oh!

freddy77 Apr 29, 2025 Maintainer

taozuhong
Apr 28, 2025

Replies: 2 comments 1 reply

freddy77
Apr 28, 2025
Maintainer

taozuhong Apr 28, 2025
Author

freddy77
Apr 29, 2025
Maintainer