#38071 [NEW]: Module unable to initialize, date miscompares

From: rodney at nerdsindenial dot com Operating system: Windows XP Pro PHP version: 5.1.4 PHP Bug Type: MySQL related Bug description: Module unable to initialize, date miscompares Description: ------------ I took this from the .\apache2.2\logs\error.log It is also related to Bug# 38070 (Modules fail to initialize) [Tue Jul 11 09:52:47 2006] [notice] Apache/2.2.2 (Win32) PHP/5.2.0-dev configured -- resuming normal operations [Tue Jul 11 09:52:47 2006] [notice] Server built: Apr 29 2006 18:32:31 [Tue Jul 11 09:52:47 2006] [notice] Parent: Created child process 3180 [Tue Jul 11 09:52:48 2006] [notice] Child 4372: Released the start mutex PHP Warning: PHP Startup: mysql: Unable to initialize module\nModule compiled with module API=20060613, debug=0, thread-safety=1\nPHP compiled with module API=20050922, debug=0, thread-safety=1\nThese options need to match\n in Unknown on line 0 PHP Warning: PHP Startup: snmp: Unable to initialize module\nModule compiled with module API=20060613, debug=0, thread-safety=1\nPHP compiled with module API=20050922, debug=0, thread-safety=1\nThese options need to match\n in Unknown on line 0 PHP Warning: PHP Startup: sockets: Unable to initialize module\nModule compiled with module API=20060613, debug=0, thread-safety=1\nPHP compiled with module API=20050922, debug=0, thread-safety=1\nThese options need to match\n in Unknown on line 0 [Tue Jul 11 09:52:48 2006] [notice] Child 3180: Child process is running [Tue Jul 11 09:52:48 2006] [notice] Child 3180: Acquired the start mutex. [Tue Jul 11 09:52:48 2006] [notice] Child 3180: Starting 250 worker threads. [Tue Jul 11 09:52:48 2006] [notice] Child 3180: Starting thread to listen on port 80. [Tue Jul 11 09:52:49 2006] [notice] Child 4372: Waiting for 250 worker threads to exit. [Tue Jul 11 09:52:49 2006] [notice] Child 4372: All worker threads have exited. [Tue Jul 11 09:52:49 2006] [notice] Child 4372: Child process is exiting I filed bug #38070 with http//bugs.php.net for the undefined function mysql_connect(). I check the dates in the DLLlibraries http://pecl4win.php.net/list_dlls.php File name MD5 sum Last update Size (KB) Downloads 1 expat.dll 3e860d331271c23e46efb1ba019701d1 2005-09-27 132 567 2 fdftk.dll 038da01c2530c016cd341326ccf7faac 2005-09-27 408 282 3 fribidi.dll a35e92908032cbf02a77369d69c418f6 2005-09-27 88 316 4 gds32.dll 5a89f713ec3f253977feac82d4842f04 2005-09-27 339 387 5 iconv.dll bdc04c0ec87fdd780e3cb858944539d8 2005-09-27 852 508 6 isapi_fcgi.dll 90b512f6592aaf2e2044a139b64b5477 2005-10-03 80 428 7 libeay32.dll 4b3305212fd45946a76f4b42c0d4c535 2005-09-27 1,056 308 8 libmcrypt.dll 31727051d9d8f48f2298785e93350738 2005-10-03 163 465 9 libmhash.dll c6fb6338e9659042ea82bfffcd8a5fb3 2005-09-27 162 341 10 libmysql.dll b439c729053e0413de1f136114363cac 2005-09-27 1,044 691 11 libmysqli.dll 93b01db4112b3c5ac0243fef41fd4809 2005-09-27 1,036 720 12 msql.dll 51a96ab8272b3f5dcd86eb40e7a52a60 2005-09-27 56 480 13 ntwdblib.dll 5e332688261363797426223e02de7d34 2005-09-27 272 298 14 sablot.dll 89f212d20a8b7b9a30b1e3284627febf 2005-09-27 376 364 15 ssleay32.dll fc73146bd24d5e180a3deace5cfe2605 2005-09-27 196 358 16 yaz.dll 08e82e525c80e324dbb4ad0d816d8386 2005-09-27 352 275 It looks like the dates are close to the ones from the Apache server start of PHP. There is some confusion; because, The dates I see from the PHP v5.X "X":\PHP libmysql.dll are from the build date http://snaps.php.net; however, the build DLL's dates do not match the PECL DLL's dates; which, are closer to the Apache dates. The dates in the Apache ./Apache2.2/lib and ./Apache2.2/bin match the "X":\PHP dates from the PHP v5.2 build. Irie Rodney Reproduce code: --------------- This happens when the Apache 2.2.2 server is restarted. Expected result: ---------------- Attempted connection to SQL server rather than undefined function mysql_connect(); Actual result: -------------- I took this from the .\apache2.2\logs\error.log [Tue Jul 11 09:52:47 2006] [notice] Apache/2.2.2 (Win32) PHP/5.2.0-dev configured -- resuming normal operations [Tue Jul 11 09:52:47 2006] [notice] Server built: Apr 29 2006 18:32:31 [Tue Jul 11 09:52:47 2006] [notice] Parent: Created child process 3180 [Tue Jul 11 09:52:48 2006] [notice] Child 4372: Released the start mutex PHP Warning: PHP Startup: mysql: Unable to initialize module\nModule compiled with module API=20060613, debug=0, thread-safety=1\nPHP compiled with module API=20050922, debug=0, thread-safety=1\nThese options need to match\n in Unknown on line 0 PHP Warning: PHP Startup: snmp: Unable to initialize module\nModule compiled with module API=20060613, debug=0, thread-safety=1\nPHP compiled with module API=20050922, debug=0, thread-safety=1\nThese options need to match\n in Unknown on line 0 PHP Warning: PHP Startup: sockets: Unable to initialize module\nModule compiled with module API=20060613, debug=0, thread-safety=1\nPHP compiled with module API=20050922, debug=0, thread-safety=1\nThese options need to match\n in Unknown on line 0 [Tue Jul 11 09:52:48 2006] [notice] Child 3180: Child process is running [Tue Jul 11 09:52:48 2006] [notice] Child 3180: Acquired the start mutex. [Tue Jul 11 09:52:48 2006] [notice] Child 3180: Starting 250 worker threads. [Tue Jul 11 09:52:48 2006] [notice] Child 3180: Starting thread to listen on port 80. [Tue Jul 11 09:52:49 2006] [notice] Child 4372: Waiting for 250 worker threads to exit. [Tue Jul 11 09:52:49 2006] [notice] Child 4372: All worker threads have exited. [Tue Jul 11 09:52:49 2006] [notice] Child 4372: Child process is exiting -- Edit bug report at http://bugs.php.net/?id=38071&edit=1 -- Try a CVS snapshot (PHP 4.4): http://bugs.php.net/fix.php?id=38071&r=trysnapshot44 Try a CVS snapshot (PHP 5.2): http://bugs.php.net/fix.php?id=38071&r=trysnapshot52 Try a CVS snapshot (PHP 6.0): http://bugs.php.net/fix.php?id=38071&r=trysnapshot60 Fixed in CVS: http://bugs.php.net/fix.php?id=38071&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=38071&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=38071&r=needtrace Need Reproduce Script: http://bugs.php.net/fix.php?id=38071&r=needscript Try newer version: http://bugs.php.net/fix.php?id=38071&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=38071&r=support Expected behavior: http://bugs.php.net/fix.php?id=38071&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=38071&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=38071&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=38071&r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=38071&r=php3 Daylight Savings: http://bugs.php.net/fix.php?id=38071&r=dst IIS Stability: http://bugs.php.net/fix.php?id=38071&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=38071&r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=38071&r=float No Zend Extensions: http://bugs.php.net/fix.php?id=38071&r=nozend MySQL Configuration Error: http://bugs.php.net/fix.php?id=38071&r=mysqlcfg