FreeTDS Development Group

[Brian Bruns <camber AT umcc.ais.org>]

Yes, this is an indication that you have a valid login packet and simply
the server is saying that either the username or password is incorrect.
Much like unix simply gives you a 'login incorrect' message :-)

So, that's good.  when the login succeeds you'd see an additional
TDS_LOGIN_ACK_TOKEN...TDS 4.2 and 7.0 do this only if login succeeds, TDS
5.0 sends it all the time but sets a flag inside to say whether it
succeeded/failed.

Anyway...assuming you can login from another package...start looking to
see if they are using a different authorization scheme than user/pass.

Brian

On Wed, 19 Jan 2000, James Cameron wrote:

> 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)
> 
> ---
> You are currently subscribed to freetds as: camber AT ais.org
> To unsubscribe, forward this message to $subst('Email.Unsub')
> 
>