php-windows Digest 14 Nov 2005 23:31:43 -0000 Issue 2823
Topics (messages 26480 through 26481):
mssql tcp
26480 by: Joakim Ling
Exec problem (using Winzip - command line)
26481 by: Chuck Anderson
Administrivia:
To subscribe to the digest, e-mail:
[EMAIL PROTECTED]
To unsubscribe from the digest, e-mail:
[EMAIL PROTECTED]
To post to the list, e-mail:
[email protected]
----------------------------------------------------------------------
--- Begin Message ---
Hi
When I connect to my MSSQL server (internal) with mssql_connect, make a
few queries etc and then close the connection link. It creates a TCP
connection each time (for every query). I'm running Win 2003 STD, IIS6,
PHP5, MSSQL2000. The problem is that the connection doesn't close
correctly so after a few minutes I will have a lot of TCP connections
that looks like this:
(With "netstat -ap tcp")
TCP w1new:22953 w1new:ms-sql-s TIME_WAIT
TCP w1new:22954 w1new:ms-sql-s TIME_WAIT
TCP w1new:22955 w1new:ms-sql-s TIME_WAIT
TCP w1new:22956 w1new:ms-sql-s TIME_WAIT
TCP w1new:22957 w1new:ms-sql-s TIME_WAIT
TCP w1new:22958 w1new:ms-sql-s TIME_WAIT
TCP w1new:22959 w1new:ms-sql-s TIME_WAIT
TCP w1new:22960 w1new:ms-sql-s TIME_WAIT
TCP w1new:22961 w1new:ms-sql-s TIME_WAIT
TCP w1new:22962 w1new:ms-sql-s TIME_WAIT
TCP w1new:22963 w1new:ms-sql-s TIME_WAIT
TCP w1new:22964 w1new:ms-sql-s TIME_WAIT
TCP w1new:22965 w1new:ms-sql-s TIME_WAIT
After rebooting and running a few minutes the list is full and Windows
begins to act really strange, not so strange when mssql has more then
10000 TIME_WAIT connections waiting to close, but how to close them????
mssql_close(); has no effect to this problem.
I changed the TCPTimeWaitDelay value to 30 in regedit to increase
connections, but still a huge problem. Anyone experience this before or
knows if converting to ODBC would work better?
Best regards
Joakim Ling
--- End Message ---
--- Begin Message ---
I wrote a script to backup my Thunderbird user profile every night by
zipping the whole profile (with subfolders) into a zip file.
I use exec to call Winzip with command line parameters (see -
http://www.memecode.com/docs/winzip.html)
The script worked fine until I tried it under my Apache 2.0 installation
(I usually use 1.3). The exec command starts Winzip (I can see it in
task manager), but it just sits and pins - doing nothing. The Php
script times out.
I can not figure out what the problem could be. exec($cmd, $output,
$retval) with $cmd = 'dir 'works, as does changing $cmd to another
program in my Program Files folder. It appears that it is only Winzip
(in Program Files/WinZip) that will not work.
Any ideas what it could be?
--- End Message ---
