Skip to Content.
Sympa Menu

freetds - freetds-0.51pre1 64-bit alpha login failure

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: James Cameron <cameron AT stl.dec.com>
  • To: freetds AT franklin.oit.unc.edu
  • Subject: freetds-0.51pre1 64-bit alpha login failure
  • Date: Mon, 06 Nov 2000 14:49:31 +1100


G'day,

Up until now I've been using 0.50 on Intel only. I've just tried
identical code on Intel and Alpha and I'm seeing a problem.

The connection fails from the Alpha machine.

DB-Library: Login incorrect.

Enabling TDSDUMP reveals that the first packet to the server is the same
length (512 bytes) on both architectures. The contents and offsets
differ. The second packet, however, is a different size. It is longer
on the 64-bit machine.

I also tried it under a different operating system and compiler,
different Alpha, and got same result.

Summary of test configurations ...

Arch Intel, Linux, gcc, works fine.
Arch Alpha, Linux, gcc, fails to login.
Arch Alpha, Tru64, cc, fails to login.

Each was using freetds-0.51pre1 with php-4.0.3pl1 and a command-line
triggered PHP script.

Here is the Alpha TDSDUMP output ... [passwords edited out]
Both Alphas generated the same TDSDUMP output.

2000-11-06 14:24:30 Connecting addr 10.0.0.4 port 1433
Sending packet @ 2000-11-06 14:24:30
0000 02 00 02 00 00 00 00 00 00 00 00 00 00 00 00 00
|................|
0010 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
|................|
0020 00 00 00 00 00 00 00 63 73 6d 6f 6e 73 79 73 74
|.......csmonsyst|
0030 65 6d 00 00 00 00 00 00 00 00 00 00 00 00 00 00
|em..............|
0040 00 00 00 00 00 0b xx xx xx xx xx xx xx xx xx 00
|......xxxxxxxxx.|
0050 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
|................|
0060 00 00 00 00 09 33 37 38 37 36 00 00 00 00 00 00
|.....37876......|
0070 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
|................|
0080 00 00 00 05 03 01 06 0a 09 01 00 00 00 00 00 00
|................|
0090 00 00 00 00 00 00 00 00 50 48 50 20 34 2e 30 00 |........PHP
4.0.|
00a0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
|................|
00b0 00 00 00 00 00 00 07 43 53 4d 61 69 6e 00 00 00
|.......CSMain...|
00c0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
|................|
00d0 00 00 00 00 00 06 00 09 xx xx xx xx xx xx xx xx
|........xxxxxxxx|
00e0 xx 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
|x...............|
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 00 00 00 0b 05 00 00 00 44 42 2d 4c 69 62
|..........DB-Lib|
01e0 72 61 72 79 0a 05 00 00 00 00 0d 11 00 00 00 00
|rary............|
01f0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
|................|


Sending packet @ 2000-11-06 14:24:30
0000 02 01 00 61 00 00 00 00 00 00 00 00 00 00 00 00
|...a............|
0010 00 00 00 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 00 00 00 00
|................|
0040 01 35 31 32 00 00 00 03 00 00 00 00 e2 12 00 01
|.512............|
0050 07 03 6d 7f ff ff ff fe 02 07 00 00 0a 68 00 00
|..m..........h..|
0060 00 |.|


2000-11-06 14:24:30 inside tds_process_login_tokens()
2000-11-06 14:24:34 inside tds_process_default_tokens() marker is 0
2000-11-06 14:24:34 leaving tds_process_default_tokens() connection dead

And here is the TDSDUMP from the working Intel system ...

2000-11-06 14:23:03 Connecting addr 10.0.0.4 port 1433
Sending packet @ 2000-11-06 14:23:03
0000 02 00 02 00 00 00 00 00 00 00 00 00 00 00 00 00
|................|
0010 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
|................|
0020 00 00 00 00 00 00 00 63 73 6d 6f 6e 73 79 73 74
|.......csmonsyst|
0030 65 6d 00 00 00 00 00 00 00 00 00 00 00 00 00 00
|em..............|
0040 00 00 00 00 00 0b xx xx xx xx xx xx xx xx xx 00
|......xxxxxxxxx.|
0050 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
|................|
0060 00 00 00 00 09 33 37 38 37 36 00 00 00 00 00 00
|.....37876......|
0070 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
|................|
0080 00 00 00 05 03 01 06 0a 09 01 00 00 00 00 02 00
|................|
0090 00 00 00 00 50 48 50 20 34 2e 30 00 00 00 00 00 |....PHP
4.0.....|
00a0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
|................|
00b0 00 00 07 43 53 4d 61 69 6e 00 00 00 00 00 00 00
|...CSMain.......|
00c0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
|................|
00d0 00 06 xx xx xx xx xx xx xx xx xx 00 00 00 00 00
|..xxxxxxxxx.....|
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 09 04 02 00 00 44 42 2d 4c 69 62 72 61 72 79
|......DB-Library|
01e0 0a 00 00 00 00 00 0d 11 00 00 00 00 00 00 00 00
|................|
01f0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
|................|


Sending packet @ 2000-11-06 14:23:03
0000 02 01 00 4c 00 00 00 00 00 00 00 00 00 00 00 00
|...L............|
0010 00 00 00 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 00 00 00 00 |............|


2000-11-06 14:23:03 inside tds_process_login_tokens()
2000-11-06 14:23:07 inside tds_process_default_tokens() marker is e3
2000-11-06 14:23:07 inside tds_process_default_tokens() marker is ab
2000-11-06 14:23:07 Msg 5701, Level 0, State 2, Server EVTSQL, Line 0
[and so on, normal stuff]

--
James Cameron (cameron AT stl.dec.com)

"Did I ask for fries?"



  • freetds-0.51pre1 64-bit alpha login failure, James Cameron, 11/05/2000

Archive powered by MHonArc 2.6.24.

Top of Page