Skip to Content.
Sympa Menu

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

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "roland bole" <roland.bole AT gmx.at>
  • To: "'FreeTDS Development Group'" <freetds AT lists.ibiblio.org>
  • Subject: AW: AW: AW: [freetds] connect problem to mssql 7.0
  • Date: Tue, 9 Dec 2003 11:28:35 +0100

Thanks for your reply.

I changed the freetds.conf file to get the following dump

pid: 11842:2003-12-09 11:16:32 processing row. column size is 11
pid: 11842:2003-12-09 11:16:32 clearing column 0 NULL bit
pid: 11842:2003-12-09 11:16:32 leaving dbnextrow() returning -1
pid: 11842:2003-12-09 11:16:32 dbdatlen() type = 39
pid: 11842:2003-12-09 11:16:32 leaving dbdatlen() returning 11
pid: 11842:2003-12-09 11:16:32 dbdatlen() type = 39
pid: 11842:2003-12-09 11:16:32 leaving dbdatlen() returning 11
pid: 11842:2003-12-09 11:16:32 inside dbnextrow()
pid: 11842:2003-12-09 11:16:32 processing row tokens. marker is fd
pid: 11842:2003-12-09 11:16:32 leaving dbnextrow() returning -2
pid: 11842:2003-12-09 11:16:38 UNIMPLEMENTED dbsetlogintime()
pid: 11842:2003-12-09 11:16:38 UNIMPLEMENTED dbsettime()
pid: 11842:2003-12-09 11:16:38 UNIMPLEMENTED dbsetmaxprocs()
-- old PID
-- new PID
pid: 11846:2003-12-09 11:16:43 UNIMPLEMENTED dbsetlogintime()
pid: 11846:2003-12-09 11:16:43 UNIMPLEMENTED dbsettime()
pid: 11846:2003-12-09 11:16:43 UNIMPLEMENTED dbsetmaxprocs()
pid: 11846:2003-12-09 11:16:49 UNIMPLEMENTED dbsetlogintime()
pid: 11846:2003-12-09 11:16:49 UNIMPLEMENTED dbsettime()
pid: 11846:2003-12-09 11:16:49 UNIMPLEMENTED dbsetmaxprocs()
pid: 11846:Sending packet @ 2003-12-09 11:16:49
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.|


pid: 11846:TDS: Write failed in tds_write_packet
Error: 104 (Connection reset by peer)
pid: 11846:2003-12-09 11:16:49 inside tds_process_default_tokens() marker is
0
pid: 11846:2003-12-09 11:16:49 leaving tds_process_default_tokens()
connection dead
pid: 11846:2003-12-09 11:16:49 inside tds_process_default_tokens() marker is
0
pid: 11846:2003-12-09 11:16:49 leaving tds_process_default_tokens()
connection dead
pid: 11846:2003-12-09 11:16:49 inside tds_process_default_tokens() marker is
0
pid: 11846:2003-12-09 11:16:49 leaving tds_process_default_tokens()
connection dead
pid: 11846:2003-12-09 11:16:49 inside tds_process_default_tokens() marker is
0
pid: 11846:2003-12-09 11:16:49 leaving tds_process_default_tokens()
connection dead


you are right, the problem is that apache use a new PID and the result is
that freetds can not work with this new connect.

I don’t know why apache change the PID.

Ok we have the error, what can I do to solve this problem ?

Roland



-----Ursprüngliche Nachricht-----
Von: freetds-bounces AT lists.ibiblio.org
[mailto:freetds-bounces AT lists.ibiblio.org] Im Auftrag von Frediano Ziglio
Gesendet: Montag, 08. Dezember 2003 23:17
An: FreeTDS Development Group
Betreff: Re: AW: AW: [freetds] connect problem to mssql 7.0

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


_______________________________________________
FreeTDS mailing list
FreeTDS AT lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds






Archive powered by MHonArc 2.6.24.

Top of Page