Skip to Content.
Sympa Menu

freetds - Re: AW: AW: [freetds] connect problem to mssql 7.0

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Frediano Ziglio <freddyz77 AT tin.it>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: AW: AW: [freetds] connect problem to mssql 7.0
  • Date: Mon, 08 Dec 2003 22:16:42 -0000

Il lun, 2003-12-08 alle 12:48, roland bole ha scritto:
> Hi freddy77
>
> Do you have time to think about my problem ?
>
>
> Roland
>

A bit...

>
> -----Ursprüngliche Nachricht-----
> Von: freetds-bounces AT lists.ibiblio.org
> [mailto:freetds-bounces AT lists.ibiblio.org] Im Auftrag von roland bole
> Gesendet: Samstag, 06. Dezember 2003 20:13
> An: 'FreeTDS Development Group'
> Betreff: AW: AW: [freetds] connect problem to mssql 7.0
>
>
>
> ...
> >
> > I freddy77 i did an update.
> >
> > But my problems are still the same.
> >
> > Let me give you short discribtion.
> >
> > I uses persitent connection with php to connect to an mssql 7.0 server
> from
> > a debian box.
> >
> > Freetds works perfect for sometimes, but if I do for ca. 5 6 minutes
> nothing
> > the connection is dead and the dumpfile ist full of the following ....
> > ---
> > 2003-12-06 07:18:42 leaving tds_process_default_tokens() connection dead
> > 2003-12-06 07:18:42 inside tds_process_default_tokens() marker is 0
> > ----
> >
>
> >>It would be interesting to see some rows before these... What's last
> >>command? Perhaps there is some mssql configuration that disconnect too
> >>lazy processes??
>
>
> > After a restart from the apache server it works again, until the next
> break.
> >
> > I use apache 1.3.26 and php 4.3.4
> >
> > i build freetds: ./configure --enable-msdblib
> >
> > What can I do, is there any timeout from the mssql server?
> >
> >
> > Please help, I have to solve this problem very quickly.
> >
> > Roland
>
>
> freddy77
>
>
>
> ok,
>
> Here is one dump short befor the error occurred
> -------
> 2003-12-06 20:00:57 dbdatlen() type = 39
> 2003-12-06 20:00:57 leaving dbdatlen() returning 11
> 2003-12-06 20:00:57 inside dbnextrow()
> 2003-12-06 20:00:57 processing row tokens. marker is fd
> 2003-12-06 20:00:57 leaving dbnextrow() returning -2

All seem correct here...

> 2003-12-06 20:02:04 UNIMPLEMENTED dbsetlogintime()
> 2003-12-06 20:02:04 UNIMPLEMENTED dbsettime()
> 2003-12-06 20:02:04 UNIMPLEMENTED dbsetmaxprocs()

It seem PHP is doing another connection... why?? These line are
strange... Why PHP init a connection and then stop ? Note there a a 2
minute gap between reading data and setting login time...

> Sending packet @ 2003-12-06 20:02:04
> 0000 01 01 00 18 00 00 01 00 75 00 73 00 65 00 20 00 |........u .s.e. .|
> 0010 45 00 4c 00 42 00 45 00 |E.L.B.E.|
>
>
> TDS: Write failed in tds_write_packet
> Error: 104 (Connection reset by peer)
> 2003-12-06 20:02:04 inside tds_process_default_tokens() marker is 0
> 2003-12-06 20:02:04 leaving tds_process_default_tokens() connection dead
> 2003-12-06 20:02:04 inside tds_process_default_tokens() marker is 0
> 2003-12-06 20:02:04 leaving tds_process_default_tokens() connection dead
>

The missed conversion seem the real problem...
Did you read UG about problems with dump and apache ?

freddy77






Archive powered by MHonArc 2.6.24.

Top of Page