#42733 [NEW]: Additional information about windows error 10106

From: andrey@php.net Operating system: Windows PHP version: Irrelevant PHP Bug Type: Documentation problem Bug description: Additional information about windows error 10106 Description: ------------ Hi, one can find this information on the web and it's not libmysql's problem but PHP one, but still in most cases mysql connections fail and the community starts to blame MySQL. Could the following be added to ext/mysql and ext/mysqli's documentation "If you get this error : 'Warning: mysql_connect(): Can't create TCP/IP socket (10106)' please check the value of variables_order in your php.ini file. Ensure that the environment variables are copied, namely $_ENV is not empty. You should have 'E' as part of variables_order. On Windows, if the environment is not copied the SYSTEMROOT environment variable won't be available and PHP will have problems loading Winsock. Reproduce code: --------------- Check for the error message on the internet. Quite few hits. Expected result: ---------------- -- Edit bug report at http://bugs.php.net/?id=42733&edit=1 -- Try a CVS snapshot (PHP 4.4): http://bugs.php.net/fix.php?id=42733&r=trysnapshot44 Try a CVS snapshot (PHP 5.2): http://bugs.php.net/fix.php?id=42733&r=trysnapshot52 Try a CVS snapshot (PHP 6.0): http://bugs.php.net/fix.php?id=42733&r=trysnapshot60 Fixed in CVS: http://bugs.php.net/fix.php?id=42733&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=42733&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=42733&r=needtrace Need Reproduce Script: http://bugs.php.net/fix.php?id=42733&r=needscript Try newer version: http://bugs.php.net/fix.php?id=42733&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=42733&r=support Expected behavior: http://bugs.php.net/fix.php?id=42733&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=42733&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=42733&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=42733&r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=42733&r=php3 Daylight Savings: http://bugs.php.net/fix.php?id=42733&r=dst IIS Stability: http://bugs.php.net/fix.php?id=42733&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=42733&r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=42733&r=float No Zend Extensions: http://bugs.php.net/fix.php?id=42733&r=nozend MySQL Configuration Error: http://bugs.php.net/fix.php?id=42733&r=mysqlcfg