ID: 38070
User updated by: rodney at nerdsindenial dot com
Reported By: rodney at nerdsindenial dot com
Status: Bogus
Bug Type: MySQL related
Operating System: Windows XP Pro/sp2
PHP Version: 5.1.4
New Comment:
Performed the following steps:
1. Removed PHP via Add/Remove Programs from control panel
application in Windows XP.
2. Deleted entire PHP directory. Saved php.ini configuration file
before deletion.
3. Unzipped and extracted php5.2-win32-200607112230.zip
4. Restored php.ini
5. Restarted Apache 2.2.2 server
The results were unchanged in the ./apache2.2/logs/errors.log
[Tue Jul 11 18:01:11 2006] [notice] Parent: Received restart signal --
Restarting the server.
[Tue Jul 11 18:01:11 2006] [notice] Child 3280: Exit event signaled.
Child process is ending.
[Tue Jul 11 18:01:12 2006] [notice] Child 3280: Released the start
mutex
[Tue Jul 11 18:01:13 2006] [notice] Child 3280: Waiting for 250 worker
threads to exit.
[Tue Jul 11 18:01:13 2006] [notice] Child 3280: All worker threads have
exited.
[Tue Jul 11 18:01:13 2006] [notice] Child 3280: Child process is
exiting
[Tue Jul 11 18:06:35 2006] [notice] Apache/2.2.2 (Win32) PHP/5.2.0-dev
configured -- resuming normal operations
[Tue Jul 11 18:06:35 2006] [notice] Server built: Apr 29 2006 18:32:31
[Tue Jul 11 18:06:35 2006] [notice] Parent: Created child process 1764
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 18:06:51 2006] [notice] Child 1764: Child process is
running
[Tue Jul 11 18:06:51 2006] [notice] Child 1764: Acquired the start
mutex.
[Tue Jul 11 18:06:51 2006] [notice] Child 1764: Starting 250 worker
threads.
[Tue Jul 11 18:06:51 2006] [notice] Child 1764: Starting thread to
listen on port 80.
Thank you for your response. If I were only looking at the
modification dates I would
say there was a mix of 2 different installations. The API dates in the
error log look
like internal timestamps picked up by PHP StartUp. It looks like a new
link/build with
an old compiled DLL of libmysql.dll. I believe that the php_mysql.dll
is build on top of
this to support get_module(). After performing the steps above, the
results did not change.
Irie, and many thanks
Previous Comments:
------------------------------------------------------------------------
[2006-07-11 23:14:37] [EMAIL PROTECTED]
You're mixing modules from different versions of PHP.
------------------------------------------------------------------------
[2006-07-11 18:45:24] rodney at nerdsindenial dot com
Description:
------------
I have the same problem and have tried most of the proposed solution
(change PHPRC, eliminate all of the php.ini files but one; move
php_mysql.dll and/or libmysql.dll to php/ext and php). I can create and
populate a database
in MySQL v5.1; install and run PHP5.2 (this is from the daily build
directory to pick up the fixes php5_apache2.dll -> php_apache2_2.dll to
solve dependency issues with missing dll for LoadModule php5_module
modules/php_apache2.dll (broken, need new name) in "X":\php\php.ini) I
found this solution and directory in the www.php.net FAQ's. I was able
to run PHP scripts from a mozilla FireFox client on the Apache server
in the .\Apache2.2\httdocs directory including phpinfo(). The Apache
v2.2.2 server installed and ran without a hitch. HOWEVER, I COULD NOT
link to mysql_connect() or any other mysql function within a PHP
script. I finally changed display_startup_errors in the php.ini file
from off-to-on and restarted
the Apache 2.2.2 server. It displayed the following in a warning dialog
box:
PHP Startup: Unable to initialize module
Module compiled with module API=20050613, debug=0, thread-safety=1
PHP compiled with module API=20050922, debug=0, thread-safety=1
These options need to match
OK
I am not able to compile the source for libmysql.dll or php_mysql.d..
(PECL).
It looks like a recompile of the mysql "shared" libraries may solve
either all
or part of the problem. I hope the developers at www.php.net are
listening??
Irie
Rodney
Reproduce code:
---------------
<?PHP
$dbUser = "root";
$dbPass = "";
$dbName = "DVDRentals";
$dbHost = "THIRDWORLD";
if(!($link=mysql_pconnect($dbHost, $dbUser, $dbPass)))
{
error_log(mysql_error(), 3, "/tmp/phplog.err");
}
if(!mysql_select_db($dbName, '127.0.0.1'))
{
error_log(mysql_error(), 3, "/tmp/phplog.err");
}
$queryDVD = "SELECT \* FROM DVDs";
$result = mysql_query($queryDVD, $link1);
$array1 = mysql_fetch($result);
print($array1);
mysql_close($link);
?>
Expected result:
----------------
At least an attempted connect to the database.
Actual result:
--------------
Connect To MySQL Server and List DVD's
Fatal error: Call to undefined function mysql_pconnect() in D:\Program
Files\Apache Software Foundation\Apache2.2\htdocs\listDVDs.html on line
14
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=38070&edit=1
