Skip to Content.
Sympa Menu

freetds - Re: via PHP to Microsoft SQL Server V7.0

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Brian Bruns <camber AT umcc.ais.org>
  • To: TDS Development Group <freetds AT franklin.oit.unc.edu>
  • Subject: Re: via PHP to Microsoft SQL Server V7.0
  • Date: Tue, 18 Jan 2000 19:32:53 -0500 (EST)



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')
>
>





Archive powered by MHonArc 2.6.24.

Top of Page