Skip to Content.
Sympa Menu

freetds - RE: [freetds] What the hell have I done!?

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: James Vanns <jimv AT canterbury.ac.uk>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: RE: [freetds] What the hell have I done!?
  • Date: Tue, 05 Aug 2003 14:52:29 +0100

OK, here is the full dump:

Starting log file with debug level 99.
2003-08-05 14:51:34.502371 iconv will convert client-side data to the ""
character set
2003-08-05 14:51:34.502595 Connecting addr 5.0.8.210 port 1433 with TDS
version 8.0
2003-08-05 14:51:34.503463 inside tds_process_login_tokens()
Received header @ 2003-08-05 14:51:34.509384
0000 04 01 01 71 00 3b 01 00 |...q.;..|


Received packet @ 2003-08-05 14:51:34.510624
0000 e3 1b 00 01 06 6d 00 61 00 73 00 74 00 65 00 72 |.....m.a
.s.t.e.r|
0010 00 06 6d 00 61 00 73 00 74 00 65 00 72 00 ab 62 |..m.a.s.
t.e.r..b|
0020 00 45 16 00 00 02 00 25 00 43 00 68 00 61 00 6e |.E.....%
.C.h.a.n|
0030 00 67 00 65 00 64 00 20 00 64 00 61 00 74 00 61 |.g.e.d.
.d.a.t.a|
0040 00 62 00 61 00 73 00 65 00 20 00 63 00 6f 00 6e |.b.a.s.e .
.c.o.n|
0050 00 74 00 65 00 78 00 74 00 20 00 74 00 6f 00 20 |.t.e.x.t .
.t.o. |
0060 00 27 00 6d 00 61 00 73 00 74 00 65 00 72 00 27 |.'.m.a.s
.t.e.r.'|
0070 00 2e 00 06 48 00 55 00 4d 00 42 00 55 00 47 00 |....H.U.
M.B.U.G.|
0080 00 00 00 e3 08 00 07 05 09 04 d0 00 34 00 e3 17 |........
....4...|
0090 00 02 0a 75 00 73 00 5f 00 65 00 6e 00 67 00 6c |...u.s._
.e.n.g.l|
00a0 00 69 00 73 00 68 00 00 ab 66 00 47 16 00 00 01 |.i.s.h..
.f.G....|
00b0 00 27 00 43 00 68 00 61 00 6e 00 67 00 65 00 64 |.'.C.h.a
.n.g.e.d|
00c0 00 20 00 6c 00 61 00 6e 00 67 00 75 00 61 00 67 |. .l.a.n
.g.u.a.g|
00d0 00 65 00 20 00 73 00 65 00 74 00 74 00 69 00 6e |.e. .s.e
.t.t.i.n|
00e0 00 67 00 20 00 74 00 6f 00 20 00 75 00 73 00 5f |.g. .t.o .
.u.s._|
00f0 00 65 00 6e 00 67 00 6c 00 69 00 73 00 68 00 2e |.e.n.g.l
.i.s.h..|
0100 00 06 48 00 55 00 4d 00 42 00 55 00 47 00 00 00 |..H.U.M.
B.U.G...|
0110 00 ad 36 00 01 71 00 00 01 16 4d 00 69 00 63 00 |..6..q..
..M.i.c.|
0120 72 00 6f 00 73 00 6f 00 66 00 74 00 20 00 53 00 |r.o.s.o. f.t.
.S.|
0130 51 00 4c 00 20 00 53 00 65 00 72 00 76 00 65 00 |Q.L. .S.
e.r.v.e.|
0140 72 00 00 00 00 00 08 00 02 f8 e3 13 00 04 04 34 |r.......
.......4|
0150 00 30 00 39 00 36 00 04 34 00 30 00 39 00 36 00 |.0.9.6..
4.0.9.6.|
0160 fd 00 00 00 00 00 00 00 00 |........ .|


2003-08-05 14:51:34.510833 inside tds_process_default_tokens() marker is
e3(ENVCHANGE)
2003-08-05 14:51:34.510881 inside tds_process_default_tokens() marker is
ab(INFO)
2003-08-05 14:51:34.510899 Msg 5701, Level 0, State 2, Server HUMBUG,
Line 0
Changed database context to 'master'.
2003-08-05 14:51:34.510914 inside tds_process_default_tokens() marker is
e3(ENVCHANGE)
2003-08-05 14:51:34.510970 inside tds_process_default_tokens() marker is
e3(ENVCHANGE)
2003-08-05 14:51:34.510985 inside tds_process_default_tokens() marker is
ab(INFO)
2003-08-05 14:51:34.511000 Msg 5703, Level 0, State 1, Server HUMBUG,
Line 0
Changed language setting to us_english.
2003-08-05 14:51:34.511014 inside tds_process_default_tokens() marker is
e3(ENVCHANGE)
2003-08-05 14:51:34.511029 increasing block size from 4096 to 4096
2003-08-05 14:51:34.511067 inside tds_process_default_tokens() marker is
fd(DONE)
2003-08-05 14:51:34.511119 inside tds_process_end() more_results = 0,
was_cancelled = 0
2003-08-05 14:51:34.511133 inside tds_process_default_tokens() setting
state to COMPLETED
Sending packet @ 2003-08-05 14:51:34.511158
0000 01 01 00 22 00 00 01 00 73 00 65 00 6c 00 65 00 |..."....
s.e.l.e.|
0010 63 00 74 00 20 00 40 00 40 00 73 00 70 00 69 00 |c.t. .@.
@.s.p.i.|
0020 64 00 |d.|


2003-08-05 14:51:34.512080 processing result tokens. marker is 0()
2003-08-05 14:51:34.512138 inside tds_process_default_tokens() marker is
0()
Unknown marker: 0(0)!!
2003-08-05 14:51:34.512158 tds_set_spid() failed
2003-08-05 14:51:34.512169 leaving tds_process_login_tokens() returning
0


What to I set the TDSDUMPCONFIG variable to? A file?

Cheers

Jim

On Tue, 2003-08-05 at 14:13, Thompson, Bill D (London) wrote:
> James,
>
> Is this the full dump ?
>
> Could you try setting the TDSDUMPCONFIG env variable and showing us the
> output.
>
> Do you ever get a "Received packet" section in your dump ?
>
> Bill
>
> > -----Original Message-----
> > From: James Vanns [SMTP:jimv AT canterbury.ac.uk]
> > Sent: 05 August 2003 12:43
> > To: FreeTDS Development Group
> > Subject: [freetds] What the hell have I done!?
> >
> > Hello (again!), thanks for all help previously but since I modified my
> > code the other day I can't even connect to the M$ SQL Server properly!
> > When trying to connect to the server using the TDS library it fails and
> > the dump log shows this:
> >
> > Sending packet @ 2003-08-05 12:37:07.133714
> > 0000 01 01 00 22 00 00 01 00 73 00 65 00 6c 00 65 00 |..."....
> > s.e.l.e.|
> > 0010 63 00 74 00 20 00 40 00 40 00 73 00 70 00 69 00 |c.t. .@.
> > @.s.p.i.|
> > 0020 64 00 |d.|
> >
> >
> > 2003-08-05 12:37:07.134595 processing result tokens. marker is 0()
> > 2003-08-05 12:37:07.134610 inside tds_process_default_tokens() marker is
> > 0()
> > Unknown marker: 0(0)!!
> > 2003-08-05 12:37:07.134628 tds_set_spid() failed
> > 2003-08-05 12:37:07.134639 leaving tds_process_login_tokens() returning
> > 0
> >
> > Why would tds_set_spid() fail? Why should it suddenly start doing this!?
> > I havn't even changed the login code:
> >
> > TDSSOCKET* login (TDSLOGIN *credentials) {
> > TDSCONNECTINFO *info = NULL;
> > TDSSOCKET *socket = tds_alloc_socket (context, BUFSIZ);
> >
> > if (!socket)
> > return NULL;
> >
> > tds_set_parent (socket, NULL);
> > info = tds_read_config_info (NULL, credentials, context->locale);
> >
> > if (!info)
> > return NULL;
> >
> > if ((tds_connect (socket, info)) == TDS_FAIL)
> > return NULL;
> >
> > tds_free_connect (info);
> >
> > return socket;
> > }
> >
> >
> > Thanks yet again!
> >
> > Jim
> >
> > --
> > James Vanns BSc (Hons) MCP
> > Linux Systems Administrator
> > Senior Software Engineer (Linux / C & C++)
> > Canterbury Christ Church University College
> > Public Key: http://pgp.mit.edu:11371/pks/lookup?op=get&search=0x24045370
> >
> > _______________________________________________
> > FreeTDS mailing list
> > FreeTDS AT lists.ibiblio.org
> > http://lists.ibiblio.org/mailman/listinfo/freetds
>
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
--
James Vanns BSc (Hons) MCP
Linux Systems Administrator
Senior Software Engineer (Linux / C & C++)
Canterbury Christ Church University College
Public Key: http://pgp.mit.edu:11371/pks/lookup?op=get&search=0x24045370





Archive powered by MHonArc 2.6.24.

Top of Page