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

ID: 18342 Updated by: sniper@php.net Reported By: phpbug@gpsnow.fsnet.co.uk -Status: Open +Status: Bogus Bug Type: MySQL related Operating System: Windows 2000 PHP Version: 4.1.2 New Comment: Thank you for taking the time to report a problem with PHP. Unfortunately you are not using a current version of PHP -- the problem might already be fixed. Please download a new PHP version from http://www.php.net/downloads.php If you are able to reproduce the bug with one of the latest versions of PHP, please change the PHP version on this bug report to the version you tested and change the status back to "Open". Again, thank you for your continued support of PHP. Previous Comments: ------------------------------------------------------------------------ [2002-07-14 16:30:52] phpbug@gpsnow.fsnet.co.uk 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 this bug report at http://bugs.php.net/?id=18342&edit=1