FreeTDS Development Group

[James Cameron <james.cameron AT compaq.com>]

A great improvement since yesterday, no doubt due to the help here.

I've got past the stalled connection problem, but unfortunately I do not
know how I did that.  It may have been after a rebuild of freetds.  The
server is no longer logging invalid packet messages.

Now, however, the login packet is being rejected due to error.  The
server returns an 0xaa then an 0xfd packet, which are TDS_ERR_TOKEN and
TDS_DONE_TOKEN respectively, in both 4.2 and 7.0 modes.

        Msg 18456, Level 14, State 1, Server , Line 0
        Login failed for user 'cameron'.

The server isn't telling me in the errorlog what the problem is.  The
information in the TDSDUMP log is interesting ... it suggests that the
server name is sent, along with username, password, and an identifier of
the application making the request; PHP-3.0 in this case.

So have I put everything in the right place?  My expert tells me that
the login is database specific, and he has given me a database name. 
Where does that go?

# cat $TDSDUMP
Sending packet @ 2000-01-19 10:33:13
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 61 6d 65 72 6f 6e 00 00  
|.......cameron..|
0030  00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00  
|................|
0040  00 00 00 00 00 07 6e 65 74 72 65 6b 00 00 00 00  
|......netrek....|
0050  00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00  
|................|
0060  00 00 00 00 06 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 33 2e 30 00 00 00 00 00   |....PHP
3.0.....|
00a0  00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00  
|................|
00b0  00 00 07 6e 6f 64 64 79 00 00 00 00 00 00 00 00  
|...noddy........|
00c0  00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00  
|................|
00d0  00 05 6e 65 74 72 65 6b 00 00 00 00 00 00 00 00  
|..netrek........|
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 06 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-01-19 10:33:13
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 69 73 6f  
|.............iso|
0020  5f 31 00 00 00 00 00 00 00 00 00 00 00 00 00 00  
|_1..............|
0030  00 00 00 00 00 00 00 00 00 00 00 05 01 35 31 32  
|.............512|
0040  00 00 00 03 00 00 00 00 00 00 00 00               |............|


2000-01-19 10:33:13 inside tds_process_login_tokens()
2000-01-19 10:33:18 inside tds_process_default_tokens() marker is aa
2000-01-19 10:33:18 inside tds_process_default_tokens() marker is fd
2000-01-19 10:33:18 leaving tds_process_login_tokens() returning 0
# echo $DBLIB_VERSION
4
# echo $TDSVER
42
# cat $SYBASE/interfaces
noddy
        query tcp ether 10.0.0.4 1433
        master tcp ether 10.0.0.4 1433
# tcpdump port 1433
tcpdump: listening on eth0
10:38:58.408576 nestor.1184 > idda.1433: S 3832018914:3832018914(0) win
32120 <mss 1460,sackOK,timestamp 832312[|tcp]> (DF)
10:38:58.408576 idda.1433 > nestor.1184: S 4294966272:4294966272(0) ack
3832018915 win 33580 <mss 1460,nop,wscale 0> (DF)
10:38:58.408576 nestor.1184 > idda.1433: . ack 1 win 32120 (DF)
10:38:58.438561 nestor.1184 > idda.1433: P 1:513(512) ack 1 win 32120
(DF)
10:38:58.588560 idda.1433 > nestor.1184: . ack 513 win 33068 (DF)
10:38:58.588560 nestor.1184 > idda.1433: P 513:589(76) ack 1 win 32120
(DF)
10:38:58.688560 idda.1433 > nestor.1184: . ack 589 win 32992 (DF)
10:39:01.177593 idda.1433 > nestor.1184: P 1:65(64) ack 589 win 33580
(DF)
10:39:01.197583 nestor.1184 > idda.1433: . ack 65 win 32120 (DF)
10:39:01.207578 nestor.1184 > idda.1433: F 589:589(0) ack 65 win 32120
(DF)
10:39:01.207578 idda.1433 > nestor.1184: . ack 590 win 33580 (DF)
10:39:01.207578 idda.1433 > nestor.1184: F 65:65(0) ack 590 win 33580
(DF)
10:39:01.207578 nestor.1184 > idda.1433: . ack 66 win 32120 (DF)


13 packets received by filter
0 packets dropped by kernel

./configure --with-tdsver=4.2 --prefix=/usr/local

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