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: James Cameron <james.cameron AT compaq.com>
  • To: TDS Development Group <freetds AT franklin.oit.unc.edu>
  • Subject: Re: via PHP to Microsoft SQL Server V7.0
  • Date: Wed, 19 Jan 2000 11:21:33 +1100


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)




Archive powered by MHonArc 2.6.24.

Top of Page