Skip to Content.
Sympa Menu

freetds - Re: [freetds] Sybase Connection - trouble without protocol fallback

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Fredy Paquet <fredy AT opag.ch>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Cc: Frediano Ziglio <freddy77 AT gmail.com>
  • Subject: Re: [freetds] Sybase Connection - trouble without protocol fallback
  • Date: Mon, 26 Jun 2017 07:10:25 +0200

Hello Frediano

Attached, there are two TDSDUMPs which were produced using the compiled
fisql command. You can see the login packets using protocol version 5.0
are slightly different.

Between the two runs we were just commenting out the "tds version" line.
We've stripped out some config search lines for clarity ...

It looks to me as if something isn't reset correctly between the trials.
I have some time this week to help searching.

Can you give me some pointers where to start searching?

fp

-- fisql_bad.log

$ vs $FREETDS
[MOKO]
host = 192.168.100.2
port = 2025
tds version = 5.0

$ setenv TDSDUMP /tmp/fisql_bad.log
$ fisql -SMOKO -Ukommerz -Pguruguru < /dev/null
Changed database context to 'casy'.
$ vs $TDSDUMP
# Search for: tds_process_login_tokens()

-- fisql_ok.log

$ vs $FREETDS
[MOKO]
host = 192.168.100.2
port = 2025
# tds version = 5.0

$ setenv TDSDUMP /tmp/fisql_ok.log
$ fisql -SMOKO -Ukommerz -Pguruguru < /dev/null
Changed database context to 'casy'.
$ vs $TDSDUMP


>
> Try to use TDSDUMPCONFIG or TDSDUMP if this shed some light.
> You can post (privately if you want) some dumps (should not be really
> long as login is failing).
>
> Frediano
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> https://lists.ibiblio.org/mailman/listinfo/freetds

--
Fredy Paquet
Mitglied der Geschäftsleitung
OPAG Informatik AG
Fabrikmattenweg 11
CH-4144 Arlesheim
http://www.opag.ch
Tel. ++41 61 716 92 22
Fax. ++41 61 716 92 29
log.c:168:Starting log file for FreeTDS 1.1.dev.20170626
	on 2017-06-26 06:51:54 with debug flags 0x4fff.
dblib.c:1176:tdsdbopen(0x1338280, MOKO, [sybase])
dblib.c:1202:tdsdbopen: dbproc->dbopts = 0x1339220
dblib.c:1213:tdsdbopen: tds_set_server(0x13382a0, "MOKO")
dblib.c:256:dblib_get_tds_ctx(void)
dblib.c:1230:tdsdbopen: About to call tds_read_config_info...
config.c:169:Getting connection information for [MOKO].
config.c:173:Attempting to read conf files.
config.c:359:... $FREETDSCONF not set.  Trying $FREETDS/etc.
config.c:298:Could not open '/home/fredy/src/local/freetds.conf/etc/freetds.conf' ((from $FREETDS/etc)).
config.c:298:Could not open '/home/fredy/.freetds.conf' ((.freetds.conf)).
config.c:302:Found conf file '/opt/casy/sybase/.Linux.3.x86_64/freetds.conf' (default).
config.c:510:Looking for section global.
config.c:569:	Found section global.
config.c:572:Got a match.
config.c:595:	text size = '64512'
config.c:569:	Found section morini.
...
config.c:569:	Found section egserver70.
config.c:583:	Reached EOF
config.c:510:Looking for section MOKO.
config.c:569:	Found section global.
config.c:569:	Found section morini.
...
config.c:569:	Found section moko.
config.c:572:Got a match.
config.c:595:	host = '192.168.100.2'
config.c:632:Found host entry 192.168.100.2 
config.c:635:IP addr is 192.168.100.2.
config.c:595:	port = '2025'
config.c:595:	tds version = '5.0'
config.c:931:Setting tds version to 5.0 (0x500).
config.c:569:	Found section moko_win.
...
config.c:583:	Reached EOF
config.c:306:Success: [MOKO] defined in /opt/casy/sybase/.Linux.3.x86_64/freetds.conf.
config.c:809:Setting 'dump_file' to '/tmp/fisql_bad.log' from $TDSDUMP.
config.c:809:Setting 'dump_file' to '/tmp/fisql_bad.log' from $TDSDUMP.
dblib.c:1257:tdsdbopen: Calling tds_connect_and_login(0x1339590, 0x1339c00)
iconv.c:325:tds_iconv_open(0x1339590, UTF-8)
iconv.c:355:Using trivial iconv
iconv.c:185:local name for ISO-8859-1 is ISO-8859-1
iconv.c:185:local name for UTF-8 is UTF-8
iconv.c:185:local name for UCS-2LE is UCS-2LE
iconv.c:185:local name for UCS-2BE is UCS-2BE
iconv.c:347:setting up conversions for client charset "UTF-8"
iconv.c:349:preparing iconv for "UTF-8" <-> "UCS-2LE" conversion
iconv.c:388:tds_iconv_open: done
net.c:362:Connecting with protocol version 5.0
net.c:289:Connecting to 192.168.100.2 port 2025
net.c:311:tds_setup_socket: connect(2) returned "Operation now in progress"
net.c:499:tds_open_socket() succeeded
packet.c:742:Sending packet
0000 02 00 02 00 00 00 00 00-6d 6f 6b 6f 00 00 00 00 |........ moko....|
0010 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
0020 00 00 00 00 00 00 04 6b-6f 6d 6d 65 72 7a 00 00 |.......k ommerz..|
0030 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
0040 00 00 00 00 00 07 67 75-72 75 67 75 72 75 00 00 |......gu ruguru..|
0050 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
0060 00 00 00 00 08 35 39 35-38 00 00 00 00 00 00 00 |.....595 8.......|
0070 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
0080 00 00 00 04 03 01 06 0a-09 01 00 00 00 00 00 00 |........ ........|
0090 00 00 00 00 66 69 73 71-6c 00 00 00 00 00 00 00 |....fisq l.......|
00a0 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
00b0 00 00 05 4d 4f 4b 4f 00-00 00 00 00 00 00 00 00 |...MOKO. ........|
00c0 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
00d0 00 04 00 08 67 75 72 75-67 75 72 75 00 00 00 00 |....guru guru....|
00e0 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
00f0 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
0100 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
0110 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
0120 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
0130 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
0140 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
0150 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
0160 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
0170 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
0180 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
0190 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
01a0 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
01b0 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
01c0 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
01d0 00 0a 05 00 00 00 44 42-2d 4c 69 62 72 61 72 79 |......DB -Library|
01e0 0a 05 00 00 00 00 0d 11-75 73 5f 65 6e 67 6c 69 |........ us_engli|
01f0 73 68 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |sh...... ........|

packet.c:742:Sending packet
0000 02 01 00 6b 00 00 00 00-00 00 00 00 00 00 0a 00 |...k.... ........|
0010 00 00 a0 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
0020 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
0030 00 00 00 00 00 00 00 00-00 00 00 00 01 35 31 32 |........ .....512|
0040 00 00 00 03 00 00 00 00-e2 20 00 01 0e 00 00 60 |........ . .....`|
0050 08 81 85 ea 8f 6d 7f ff-ff ff fe 02 0e 00 00 00 |.....m.. ........|
0060 00 00 00 00 00 00 02 68-00 00 00                |.......h ...|

token.c:305:tds_process_login_tokens()
packet.c:640:Received packet
0000 0f 01 01 74 00 00 00 00-ad 0d 00 07 05 00 00 00 |...t.... ........|
0010 03 41 53 45 0f 07 00 00-65 03 01 1e 00 ec 22 00 |.ASE.... e.....".|
0020 03 00 00 00 00 00 00 00-38 00 00 00 00 00 00 00 |........ 8.......|
0030 e1 fc 00 00 00 00 00 00-00 00 00 00 e1 20 00 00 |........ ..... ..|
0040 00 00 d7 01 00 00 00 fc-00 00 00 2d 2d 2d 2d 2d |........ ...-----|
0050 42 45 47 49 4e 20 52 53-41 20 50 55 42 4c 49 43 |BEGIN RS A PUBLIC|
0060 20 4b 45 59 2d 2d 2d 2d-2d 0a 4d 49 47 4a 41 6f | KEY---- -.MIGJAo|
0070 47 42 41 4d 43 50 69 47-76 62 7a 49 33 30 65 2f |GBAMCPiG vbzI30e/|
0080 39 34 4f 31 76 73 37 46-5a 62 52 44 37 77 50 49 |94O1vs7F ZbRD7wPI|
0090 6e 4f 31 4f 48 5a 4b 6c-42 41 4c 4c 77 37 79 66 |nO1OHZKl BALLw7yf|
00a0 76 4b 66 35 38 6e 78 68-55 4f 0a 4c 33 52 51 32 |vKf58nxh UO.L3RQ2|
00b0 50 34 68 64 4c 31 56 56-52 2b 30 70 55 6e 39 44 |P4hdL1VV R+0pUn9D|
00c0 46 53 39 52 78 4b 37 2f-4f 78 49 71 42 4a 58 6b |FS9RxK7/ OxIqBJXk|
00d0 76 56 74 79 79 43 6a 66-44 43 7a 6b 33 31 6d 49 |vVtyyCjf DCzk31mI|
00e0 43 6a 7a 66 53 42 38 4b-33 79 35 0a 55 59 42 69 |CjzfSB8K 3y5.UYBi|
00f0 70 44 66 55 63 33 64 42-4e 37 58 6a 4b 43 74 6f |pDfUc3dB N7XjKCto|
0100 43 59 4b 2f 7a 57 41 72-66 54 64 47 35 41 79 65 |CYK/zWAr fTdG5Aye|
0110 49 56 41 70 72 37 5a 67-39 7a 34 7a 67 6c 54 62 |IVApr7Zg 9z4zglTb|
0120 41 67 4d 42 41 41 45 3d-0a 2d 2d 2d 2d 2d 45 4e |AgMBAAE= .-----EN|
0130 44 20 52 53 41 20 50 55-42 4c 49 43 20 4b 45 59 |D RSA PU BLIC KEY|
0140 2d 2d 2d 2d 2d 0a 00 20-00 00 00 8c bc fe f2 ea |-----..  ........|
0150 08 1d 81 69 eb 13 22 dc-21 e4 a5 f4 39 42 4e 28 |...i..". !...9BN(|
0160 f8 92 c1 67 cd 15 b4 d0-dc e2 52 fd 00 00 02 00 |...g.... ..R.....|
0170 00 00 00 00            -                        |....|

token.c:313:looking for login token, got  ad(LOGINACK)
token.c:351:server reports TDS version 5.0.0.0
token.c:353:Product name for 0x5000000 is unknown
token.c:385:Product version F070000
token.c:313:looking for login token, got  65(MSG)
token.c:132:tds_process_default_tokens() marker is 65(MSG)
token.c:313:looking for login token, got  ec(TDS5_PARAMFMT)
token.c:132:tds_process_default_tokens() marker is ec(TDS5_PARAMFMT)
token.c:1633:tds_get_data_info(0x1339590, 0x133b220, 1) [for parameter]
token.c:1695:processing result. type = 56(int), varint_size 0
token.c:1700:processing result. column_size 4
token.c:1633:tds_get_data_info(0x1339590, 0x133c1b0, 1) [for parameter]
token.c:1695:processing result. type = 225(longbinary), varint_size 5
token.c:1700:processing result. column_size 252
token.c:1633:tds_get_data_info(0x1339590, 0x133c270, 1) [for parameter]
token.c:1695:processing result. type = 225(longbinary), varint_size 5
token.c:1700:processing result. column_size 32
token.c:313:looking for login token, got  d7(TDS5_PARAMS)
token.c:132:tds_process_default_tokens() marker is d7(TDS5_PARAMS)
data.c:739:tds_get_data: type 56, varint size 0
data.c:783:tds_get_data(): wire column size is 4 
data.c:739:tds_get_data: type 225, varint size 5
data.c:783:tds_get_data(): wire column size is 252 
data.c:739:tds_get_data: type 225, varint size 5
data.c:783:tds_get_data(): wire column size is 32 
token.c:313:looking for login token, got  fd(DONE)
token.c:132:tds_process_default_tokens() marker is fd(DONE)
token.c:2087:tds_process_end: more_results = 0
		was_cancelled = 0
		error = 0
		done_count_valid = 0
token.c:2104:                rows_affected = 0
token.c:2107:tds_process_end() state set to TDS_IDLE
token.c:422:tds_process_login_tokens() returning TDS_FAIL
login.c:532:login packet accepted
query.c:3758:tds_disconnect() 
mem.c:654:tds_free_all_results()

log.c:168:Starting log file for FreeTDS 1.1.dev.20170626
	on 2017-06-26 06:54:43 with debug flags 0x4fff.
dblib.c:1176:tdsdbopen(0x12c2280, MOKO, [sybase])
dblib.c:1202:tdsdbopen: dbproc->dbopts = 0x12c3220
dblib.c:1213:tdsdbopen: tds_set_server(0x12c22a0, "MOKO")
dblib.c:256:dblib_get_tds_ctx(void)
dblib.c:1230:tdsdbopen: About to call tds_read_config_info...
config.c:169:Getting connection information for [MOKO].
config.c:173:Attempting to read conf files.
config.c:359:... $FREETDSCONF not set.  Trying $FREETDS/etc.
config.c:298:Could not open '/home/fredy/src/local/freetds.conf/etc/freetds.conf' ((from $FREETDS/etc)).
config.c:298:Could not open '/home/fredy/.freetds.conf' ((.freetds.conf)).
config.c:302:Found conf file '/opt/casy/sybase/.Linux.3.x86_64/freetds.conf' (default).
config.c:510:Looking for section global.
config.c:569:	Found section global.
config.c:572:Got a match.
config.c:595:	text size = '64512'
config.c:569:	Found section morini.
...
config.c:569:	Found section egserver70.
config.c:583:	Reached EOF
config.c:510:Looking for section MOKO.
config.c:569:	Found section global.
config.c:569:	Found section morini.
...
config.c:569:	Found section moko.
config.c:572:Got a match.
config.c:595:	host = '192.168.100.2'
config.c:632:Found host entry 192.168.100.2 
config.c:635:IP addr is 192.168.100.2.
config.c:595:	port = '2025'
config.c:569:	Found section moko_win.
...
config.c:583:	Reached EOF
config.c:306:Success: [MOKO] defined in /opt/casy/sybase/.Linux.3.x86_64/freetds.conf.
config.c:809:Setting 'dump_file' to '/tmp/fisql_ok.log' from $TDSDUMP.
config.c:809:Setting 'dump_file' to '/tmp/fisql_ok.log' from $TDSDUMP.
dblib.c:1257:tdsdbopen: Calling tds_connect_and_login(0x12c3590, 0x12c3c00)
iconv.c:325:tds_iconv_open(0x12c3590, UTF-8)
iconv.c:355:Using trivial iconv
iconv.c:185:local name for ISO-8859-1 is ISO-8859-1
iconv.c:185:local name for UTF-8 is UTF-8
iconv.c:185:local name for UCS-2LE is UCS-2LE
iconv.c:185:local name for UCS-2BE is UCS-2BE
iconv.c:347:setting up conversions for client charset "UTF-8"
iconv.c:349:preparing iconv for "UTF-8" <-> "UCS-2LE" conversion
iconv.c:388:tds_iconv_open: done
net.c:362:Connecting with protocol version 7.3
net.c:289:Connecting to 192.168.100.2 port 2025
net.c:311:tds_setup_socket: connect(2) returned "Operation now in progress"
net.c:499:tds_open_socket() succeeded
packet.c:742: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 0a 18 00-00 00                   |rver.... ..|

packet.c:640:Received packet
0000 00 01 00 08 00 00 00 00-                        |........|

login.c:532:login packet rejected
query.c:3758:tds_disconnect() 
util.c:165:Changed query state from IDLE to DEAD
util.c:319:tdserror(0x7ffcb742f400, 0x12c3590, 20002, 0)
util.c:349:tdserror: client library returned TDS_INT_CANCEL(2)
util.c:372:tdserror: returning TDS_INT_CANCEL(2)
net.c:362:Connecting with protocol version 7.2
net.c:289:Connecting to 192.168.100.2 port 2025
net.c:311:tds_setup_socket: connect(2) returned "Operation now in progress"
net.c:499:tds_open_socket() succeeded
packet.c:742: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 0a 18 00-00 00                   |rver.... ..|

packet.c:640:Received packet
0000 00 01 00 08 00 00 00 00-                        |........|

login.c:532:login packet rejected
query.c:3758:tds_disconnect() 
util.c:165:Changed query state from IDLE to DEAD
util.c:319:tdserror(0x7ffcb742f400, 0x12c3590, 20002, 0)
util.c:349:tdserror: client library returned TDS_INT_CANCEL(2)
util.c:372:tdserror: returning TDS_INT_CANCEL(2)
net.c:362:Connecting with protocol version 7.1
net.c:289:Connecting to 192.168.100.2 port 2025
net.c:311:tds_setup_socket: connect(2) returned "Operation now in progress"
net.c:499:tds_open_socket() succeeded
packet.c:742: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 0a 18 00 00            -                        |....|

packet.c:640:Received packet
0000 00 01 00 08 00 00 00 00-                        |........|

login.c:532:login packet rejected
query.c:3758:tds_disconnect() 
util.c:165:Changed query state from IDLE to DEAD
util.c:319:tdserror(0x7ffcb742f400, 0x12c3590, 20002, 0)
util.c:349:tdserror: client library returned TDS_INT_CANCEL(2)
util.c:372:tdserror: returning TDS_INT_CANCEL(2)
net.c:362:Connecting with protocol version 7.0
net.c:289:Connecting to 192.168.100.2 port 2025
net.c:311:tds_setup_socket: connect(2) returned "Operation now in progress"
net.c:499:tds_open_socket() succeeded
login.c:936:quietly sending TDS 7+ login packet
token.c:305:tds_process_login_tokens()
packet.c:640:Received packet
0000 00 01 00 08 00 00 00 00-                        |........|

util.c:165:Changed query state from IDLE to DEAD
util.c:319:tdserror(0x7ffcb742f400, 0x12c3590, 20017, 0)
util.c:349:tdserror: client library returned TDS_INT_CANCEL(2)
util.c:372:tdserror: returning TDS_INT_CANCEL(2)
token.c:313:looking for login token, got  0()
token.c:132:tds_process_default_tokens() marker is 0()
token.c:135:leaving tds_process_default_tokens() connection dead
login.c:532:login packet accepted
util.c:319:tdserror(0x7ffcb742f400, 0x12c3590, 20002, 0)
util.c:349:tdserror: client library returned TDS_INT_CANCEL(2)
util.c:372:tdserror: returning TDS_INT_CANCEL(2)
net.c:362:Connecting with protocol version 5.0
net.c:289:Connecting to 192.168.100.2 port 2025
net.c:311:tds_setup_socket: connect(2) returned "Operation now in progress"
net.c:499:tds_open_socket() succeeded
packet.c:742:Sending packet
0000 02 01 02 63 00 00 00 00-6d 6f 6b 6f 00 00 00 00 |...c.... moko....|
0010 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
0020 00 00 00 00 00 00 04 6b-6f 6d 6d 65 72 7a 00 00 |.......k ommerz..|
0030 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
0040 00 00 00 00 00 07 00 00-00 00 00 00 00 00 00 00 |........ ........|
0050 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
0060 00 00 00 00 00 36 31 35-34 00 00 00 00 00 00 00 |.....615 4.......|
0070 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
0080 00 00 00 04 03 01 06 0a-09 01 00 00 00 00 00 00 |........ ........|
0090 00 00 00 00 66 69 73 71-6c 00 00 00 00 00 00 00 |....fisq l.......|
00a0 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
00b0 00 00 05 4d 4f 4b 4f 00-00 00 00 00 00 00 00 00 |...MOKO. ........|
00c0 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
00d0 00 04 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
00e0 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
00f0 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
0100 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
0110 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
0120 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
0130 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
0140 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
0150 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
0160 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
0170 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
0180 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
0190 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
01a0 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
01b0 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
01c0 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
01d0 00 00 05 00 00 00 44 42-2d 4c 69 62 72 61 72 79 |......DB -Library|
01e0 0a 05 00 00 00 00 0d 11-75 73 5f 65 6e 67 6c 69 |........ us_engli|
01f0 73 68 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |sh...... ........|
0200 00 00 00 00 00 00 0a 00-00 00 a0 00 00 00 00 00 |........ ........|
0210 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
0220 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
0230 00 00 00 00 01 35 31 32-00 00 00 03 00 00 00 00 |.....512 ........|
0240 e2 20 00 01 0e 00 00 60-08 81 85 ea 8f 6d 7f ff |. .....` .....m..|
0250 ff ff fe 02 0e 00 00 00-00 00 00 00 00 00 02 68 |........ .......h|
0260 00 00 00               -                        |...|

token.c:305:tds_process_login_tokens()
packet.c:640:Received packet
0000 0f 01 01 74 00 00 00 00-ad 0d 00 07 05 00 00 00 |...t.... ........|
0010 03 41 53 45 0f 07 00 00-65 03 01 1e 00 ec 22 00 |.ASE.... e.....".|
0020 03 00 00 00 00 00 00 00-38 00 00 00 00 00 00 00 |........ 8.......|
0030 e1 fc 00 00 00 00 00 00-00 00 00 00 e1 20 00 00 |........ ..... ..|
0040 00 00 d7 01 00 00 00 fc-00 00 00 2d 2d 2d 2d 2d |........ ...-----|
0050 42 45 47 49 4e 20 52 53-41 20 50 55 42 4c 49 43 |BEGIN RS A PUBLIC|
0060 20 4b 45 59 2d 2d 2d 2d-2d 0a 4d 49 47 4a 41 6f | KEY---- -.MIGJAo|
0070 47 42 41 4d 43 50 69 47-76 62 7a 49 33 30 65 2f |GBAMCPiG vbzI30e/|
0080 39 34 4f 31 76 73 37 46-5a 62 52 44 37 77 50 49 |94O1vs7F ZbRD7wPI|
0090 6e 4f 31 4f 48 5a 4b 6c-42 41 4c 4c 77 37 79 66 |nO1OHZKl BALLw7yf|
00a0 76 4b 66 35 38 6e 78 68-55 4f 0a 4c 33 52 51 32 |vKf58nxh UO.L3RQ2|
00b0 50 34 68 64 4c 31 56 56-52 2b 30 70 55 6e 39 44 |P4hdL1VV R+0pUn9D|
00c0 46 53 39 52 78 4b 37 2f-4f 78 49 71 42 4a 58 6b |FS9RxK7/ OxIqBJXk|
00d0 76 56 74 79 79 43 6a 66-44 43 7a 6b 33 31 6d 49 |vVtyyCjf DCzk31mI|
00e0 43 6a 7a 66 53 42 38 4b-33 79 35 0a 55 59 42 69 |CjzfSB8K 3y5.UYBi|
00f0 70 44 66 55 63 33 64 42-4e 37 58 6a 4b 43 74 6f |pDfUc3dB N7XjKCto|
0100 43 59 4b 2f 7a 57 41 72-66 54 64 47 35 41 79 65 |CYK/zWAr fTdG5Aye|
0110 49 56 41 70 72 37 5a 67-39 7a 34 7a 67 6c 54 62 |IVApr7Zg 9z4zglTb|
0120 41 67 4d 42 41 41 45 3d-0a 2d 2d 2d 2d 2d 45 4e |AgMBAAE= .-----EN|
0130 44 20 52 53 41 20 50 55-42 4c 49 43 20 4b 45 59 |D RSA PU BLIC KEY|
0140 2d 2d 2d 2d 2d 0a 00 20-00 00 00 8e 57 9e 60 91 |-----..  ....W.`.|
0150 37 5d 8c 5f a5 c4 8f f4-c6 44 dd d8 6d b2 94 58 |7]._.... .D..m..X|
0160 18 38 fb 2d a7 07 e3 f7-dd 23 0b fd 00 00 02 00 |.8.-.... .#......|
0170 00 00 00 00            -                        |....|

token.c:313:looking for login token, got  ad(LOGINACK)
token.c:351:server reports TDS version 5.0.0.0
token.c:353:Product name for 0x5000000 is unknown
token.c:385:Product version F070000
token.c:313:looking for login token, got  65(MSG)
token.c:132:tds_process_default_tokens() marker is 65(MSG)
token.c:313:looking for login token, got  ec(TDS5_PARAMFMT)
token.c:132:tds_process_default_tokens() marker is ec(TDS5_PARAMFMT)
token.c:1633:tds_get_data_info(0x12c3590, 0x12c5250, 1) [for parameter]
token.c:1695:processing result. type = 56(int), varint_size 0
token.c:1700:processing result. column_size 4
token.c:1633:tds_get_data_info(0x12c3590, 0x12c39d0, 1) [for parameter]
token.c:1695:processing result. type = 225(longbinary), varint_size 5
token.c:1700:processing result. column_size 252
token.c:1633:tds_get_data_info(0x12c3590, 0x12c3a90, 1) [for parameter]
token.c:1695:processing result. type = 225(longbinary), varint_size 5
token.c:1700:processing result. column_size 32
token.c:313:looking for login token, got  d7(TDS5_PARAMS)
token.c:132:tds_process_default_tokens() marker is d7(TDS5_PARAMS)
data.c:739:tds_get_data: type 56, varint size 0
data.c:783:tds_get_data(): wire column size is 4 
data.c:739:tds_get_data: type 225, varint size 5
data.c:783:tds_get_data(): wire column size is 252 
data.c:739:tds_get_data: type 225, varint size 5
data.c:783:tds_get_data(): wire column size is 32 
token.c:313:looking for login token, got  fd(DONE)
token.c:132:tds_process_default_tokens() marker is fd(DONE)
token.c:2087:tds_process_end: more_results = 0
		was_cancelled = 0
		error = 0
		done_count_valid = 0
token.c:2104:                rows_affected = 0
token.c:2107:tds_process_end() state set to TDS_IDLE
packet.c:742:Sending packet
0000 0f 01 01 48 00 00 00 00-65 03 01 1f 00 ec 0e 00 |...H.... e.......|
0010 01 00 00 00 00 00 00 00-e1 ff ff ff 7f 00 d7 80 |........ ........|
0020 00 00 00 1f 4a ed 7f 2c-31 e9 fb 32 74 4f 8b 97 |....J.., 1..2tO..|
0030 41 bd 89 85 15 33 63 4c-e1 2f f7 a1 9e 8b 47 66 |A....3cL ./....Gf|
0040 c5 57 a6 74 fb e1 28 0a-9f 41 5b 69 ec d1 0b 86 |.W.t..(. .A[i....|
0050 ae 85 2c 36 db cc 01 18-bd ab 2b 0f 0c 78 86 1f |..,6.... ..+..x..|
0060 29 33 51 e6 8e c6 fa 08-49 8c 4f ab 12 80 00 5c |)3Q..... I.O....\|
0070 ef c3 a8 2a 47 a1 76 9f-38 66 99 54 31 f6 63 05 |...*G.v. 8f.T1.c.|
0080 90 23 be 72 9c cb 96 82-16 b4 ac 8e ab 20 bc a2 |.#.r.... ..... ..|
0090 52 cb ba e9 a2 d5 a1 be-52 c8 7b f2 09 ec 56 94 |R....... R.{...V.|
00a0 bd b8 96 65 03 01 20 00-ec 17 00 02 00 00 00 00 |...e.. . ........|
00b0 00 00 00 27 ff 00 00 00-00 00 00 00 e1 ff ff ff |...'.... ........|
00c0 7f 00 d7 00 80 00 00 00-1f 4a ed 7f 2c 31 e9 fb |........ .J..,1..|
00d0 32 74 4f 8b 97 41 bd 89-85 15 33 63 4c e1 2f f7 |2tO..A.. ..3cL./.|
00e0 a1 9e 8b 47 66 c5 57 a6-74 fb e1 28 0a 9f 41 5b |...Gf.W. t..(..A[|
00f0 69 ec d1 0b 86 ae 85 2c-36 db cc 01 18 bd ab 2b |i......, 6......+|
0100 0f 0c 78 86 1f 29 33 51-e6 8e c6 fa 08 49 8c 4f |..x..)3Q .....I.O|
0110 ab 12 80 00 5c ef c3 a8-2a 47 a1 76 9f 38 66 99 |....\... *G.v.8f.|
0120 54 31 f6 63 05 90 23 be-72 9c cb 96 82 16 b4 ac |T1.c..#. r.......|
0130 8e ab 20 bc a2 52 cb ba-e9 a2 d5 a1 be 52 c8 7b |.. ..R.. .....R.{|
0140 f2 09 ec 56 94 bd b8 96-                        |...V....|

packet.c:640:Received packet
0000 04 01 00 9f 00 00 00 00-e3 0d 00 01 04 63 61 73 |........ .....cas|
0010 79 06 6d 61 73 74 65 72-e5 3e 00 45 16 00 00 02 |y.master .>.E....|
0020 0a 05 5a 5a 5a 5a 5a 00-01 00 24 00 43 68 61 6e |..ZZZZZ. ..$.Chan|
0030 67 65 64 20 64 61 74 61-62 61 73 65 20 63 6f 6e |ged data base con|
0040 74 65 78 74 20 74 6f 20-27 63 61 73 79 27 2e 0a |text to  'casy'..|
0050 05 53 43 4f 54 54 00 00-00 e3 07 00 04 04 32 30 |.SCOTT.. ......20|
0060 34 38 00 ad 0d 00 05 05-00 00 00 03 41 53 45 0f |48...... ....ASE.|
0070 07 00 00 e2 20 00 01 0e-00 00 60 08 81 85 ea 8b |.... ... ..`.....|
0080 61 7f ff ff ff e6 02 0e-00 00 00 00 00 00 00 00 |a....... ........|
0090 00 02 00 00 00 00 fd 00-00 02 00 0c 00 00 00    |........ .......|

token.c:313:looking for login token, got  e3(ENVCHANGE)
token.c:132:tds_process_default_tokens() marker is e3(ENVCHANGE)
token.c:313:looking for login token, got  e5(EED)
token.c:132:tds_process_default_tokens() marker is e5(EED)
token.c:2350:tds_process_info() reading message 5701 from server
token.c:2422:tds_process_info() calling client msg handler
token.c:2439:tds_process_info() returning TDS_SUCCESS
token.c:313:looking for login token, got  e3(ENVCHANGE)
token.c:132:tds_process_default_tokens() marker is e3(ENVCHANGE)
token.c:2242:changing block size from  to 2048
token.c:313:looking for login token, got  ad(LOGINACK)
token.c:351:server reports TDS version 5.0.0.0
token.c:353:Product name for 0x5000000 is unknown
token.c:385:Product version F070000
token.c:313:looking for login token, got  e2(CAPABILITY)
token.c:132:tds_process_default_tokens() marker is e2(CAPABILITY)
token.c:313:looking for login token, got  fd(DONE)
token.c:132:tds_process_default_tokens() marker is fd(DONE)
token.c:2087:tds_process_end: more_results = 0
		was_cancelled = 0
		error = 0
		done_count_valid = 0
token.c:2104:                rows_affected = 12
token.c:2107:tds_process_end() state set to TDS_IDLE
token.c:422:tds_process_login_tokens() returning TDS_SUCCESS
mem.c:654:tds_free_all_results()




Archive powered by MHonArc 2.6.24.

Top of Page