From: Zian dot Choy at gmail dot com
Operating system: Windows XP SP3
PHP version: 5.2.6
PHP Bug Type: Unknown/Other Function
Bug description: Installer does not correctly configure MySQL support
Description:
------------
Viewing a PHP file that attempts to connect to MySQL results in a HTTP
500.
Reproduce code:
---------------
1. Install the latest version of Apache using the Windows installer with
Open SSL, using all defaults
2. Stop Apache
3. Install the latest version of PHP using the MSI.
In the configuration of the PHP install...
1. Pick "Apache 2.2"
2. Point the installer at Apache's conf directory
3. Under "Extensions," select MySQL and MySQLi
4. Start Apache
5. Start MySQL
6. Run the following code inside a file:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>SQL Test</title>
</head>
<body>
<?php
$dbServer='localhost';
// username and password
$dbUser='[root username]';
$dbPass='[password]';
// name of database
$dbName='test';
$link = mysql_connect("$dbServer", "$dbUser", "$dbPass") or
die("Could not connect");
print "Connected successfully<br>";
mysql_select_db("$dbName") or die("Could not select database");
print "Database selected successfully<br>";
mysql_close($link);
?>
</body>
</html>
Expected result:
----------------
I expected to see:
Connected successfully
Database selected successfully
Actual result:
--------------
The IE7 HTTP 500 error screen and the following entry in the Apache
error.log file:
[Fri May 09 22:03:08 2008] [error] [client 127.0.0.1] PHP Fatal error:
Call to undefined function mysql_connect() in C:\\Program Files\\Apache
Software Foundation\\Apache2.2\\htdocs\\sql.php on line 14
--
Edit bug report at http://bugs.php.net/?id=44958&edit=1
--
Try a CVS snapshot (PHP 5.2):
http://bugs.php.net/fix.php?id=44958&r=trysnapshot52
Try a CVS snapshot (PHP 5.3):
http://bugs.php.net/fix.php?id=44958&r=trysnapshot53
Try a CVS snapshot (PHP 6.0):
http://bugs.php.net/fix.php?id=44958&r=trysnapshot60
Fixed in CVS: http://bugs.php.net/fix.php?id=44958&r=fixedcvs
Fixed in release:
http://bugs.php.net/fix.php?id=44958&r=alreadyfixed
Need backtrace: http://bugs.php.net/fix.php?id=44958&r=needtrace
Need Reproduce Script: http://bugs.php.net/fix.php?id=44958&r=needscript
Try newer version: http://bugs.php.net/fix.php?id=44958&r=oldversion
Not developer issue: http://bugs.php.net/fix.php?id=44958&r=support
Expected behavior: http://bugs.php.net/fix.php?id=44958&r=notwrong
Not enough info:
http://bugs.php.net/fix.php?id=44958&r=notenoughinfo
Submitted twice:
http://bugs.php.net/fix.php?id=44958&r=submittedtwice
register_globals: http://bugs.php.net/fix.php?id=44958&r=globals
PHP 4 support discontinued: http://bugs.php.net/fix.php?id=44958&r=php4
Daylight Savings: http://bugs.php.net/fix.php?id=44958&r=dst
IIS Stability: http://bugs.php.net/fix.php?id=44958&r=isapi
Install GNU Sed: http://bugs.php.net/fix.php?id=44958&r=gnused
Floating point limitations: http://bugs.php.net/fix.php?id=44958&r=float
No Zend Extensions: http://bugs.php.net/fix.php?id=44958&r=nozend
MySQL Configuration Error: http://bugs.php.net/fix.php?id=44958&r=mysqlcfg
