FreeTDS Development Group

["roland bole" <roland.bole AT gmx.at>]

Thanks for our help and effort.

With netstat i can see that they are divers connections to my mssql server.
If I compare the PID I can see one httpd id is  equal to one connection to
my mssql server on port 1433

That means php open a new connection to the new PID from httpd.

> When first process finish connections are automatically closed... or 
> not ??
I think so, 

i can not reproduce the error, with my testscript, because the error
occurred without any system. (I can see anyone)

after a restart the apache it works fine, and the connections closed
automatically.

what should I do to get a stable connection?


Roland






-----Ursprüngliche Nachricht-----
Von: freetds-bounces AT lists.ibiblio.org
[mailto:freetds-bounces AT lists.ibiblio.org] Im Auftrag von ZIGLIO Frediano
Gesendet: Dienstag, 09. Dezember 2003 14:35
An: FreeTDS Development Group
Betreff: RE: [freetds] connect problem to mssql 7.0

> 
> >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...
> I use mssql_pconnect to connect, php should establish a new connection
> 
> >When first process finish connections are automatically closed... or 
> >not ??
> How can I assert this?
> 

I would process in such way:
1- reduce php source. Does a script like
 - pconnect
 - select
 - display
 cause the problem? This should be the only script executed by the server.
2- use a packet capturer (ethereal or whatever) to test connections.

>From packet capture you should see the connection close and not the open...

If you got 1 working and you don't know what to do next send script to ML,
we'll try to reproduce and fix it.

> 
> >Perhaps it's a PHP problem? You spotted a very strange problem...
> I use the mssql PHP Functions according the php manual
> There are only simple queries with joins.
> 
> Perhaps there is a problem with environment variables I 
> didn´t set one.
> 

I don't know...

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