Skip to Content.
Sympa Menu

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

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "ZIGLIO Frediano" <Frediano.Ziglio AT vodafone.com>
  • To: "FreeTDS Development Group" <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] connect problem to mssql 7.0
  • Date: Tue, 9 Dec 2003 11:51:11 +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
>

Apache 1.3 should change PID simply cause after some request it stop sub
process and fork another apache... This to keep itself stable. However I
don't understand why PHP do not make another connection... When first
process finish connections are automatically closed... or not ??
Perhaps it's a PHP problem? You spotted a very strange problem...

freddy77




Archive powered by MHonArc 2.6.24.

Top of Page