Bug #18342: Can't create TCP/IP socket (10106)

From: phpbug@gpsnow.fsnet.co.uk Operating system: Windows 2000 PHP version: 4.1.2 PHP Bug Type: MySQL related Bug description: Can't create TCP/IP socket (10106) i am trying to install snort in windows, and followed the steps mentioned here http://www.silicondefense.com/techsupport/winsnortacid-iis_1.8.7.htm everything else works, snort on windows works, mysql server on windows works, except php. i have downloaded the php.exe and placed into c:\php\ folder the php4ts.dll and the .exe. then php.ini in the c:\winnt\system32 folder. From iis i can run simple php scripts like <? phpinfo() ; ?> and therefore i know that php interpreter is doing its job fine and it has been installed in IIS 5 correctly. but when i try to use ACID (that runs php code in adodb1.9), I get an error ===================================== Warning: Can't create TCP/IP socket (10106) in C:\Snort\ADODB\drivers\adodb-mysql.inc.php on line 115 Database ERROR:Can't create TCP/IP socket (10106) ===================================== Now this error has been mentioned on the web many places, just search for 'TCP/IP socket (10106)' on google.com somebody says it is to do with winsock dll and some body says it is to do with php.ini file mysql.default_port variable. i've tried everything but get the same error. please help me, it is becoming a headache. this could be a problem introduced due to a small change in this newer version of php so it becomes incompatible with ADODB 1.90. but i don't know what it is. does anybody know how to fix this problem? to reproduce the problem: install php cgi on windows 2000 iis 5. place a file named test.php in the root directory of the website. content just one line: <? phpinfo() ; ?> now download and unzip ADODB 1.9 download location and a file modification instructed here: http://www.silicondefense.com/techsupport/winsnortacid-iis_1.8.7.htm create another file called test2.php with this content <?php include('c:\adodb\adodb.inc.php'); $c = NewADOConnection('mysql'); $c->PConnect('servername','username','nothing'); ?> open a browser and visit http://localhost/test2.php now we should get an error saying the server canot be found because a server called 'servername' cannot be found. instead we get the error tcp socket could not be created. now even when i have a server installed and guaranteed to be working i am stuck with this tcp socket creation error. its a problem with php.exe because the interpreter is not allowing reused php code to create a socket. it will allow tcp socket creation if attempted in test2.php itself. -- Edit bug report at http://bugs.php.net/?id=18342&edit=1 -- Fixed in CVS: http://bugs.php.net/fix.php?id=18342&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=18342&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=18342&r=needtrace Try newer version: http://bugs.php.net/fix.php?id=18342&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=18342&r=support Expected behavior: http://bugs.php.net/fix.php?id=18342&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=18342&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=18342&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=18342&r=globals