#44958 [Bgs]: Installer does not correctly configure MySQL support
ID: 44958 User updated by: Zian dot Choy at gmail dot com Reported By: Zian dot Choy at gmail dot com Status: Bogus Bug Type: *General Issues Operating System: Windows XP SP3 PHP Version: 5.2.6 Assigned To: jmertic New Comment: >your configure settings should be What are "configure settings"? >mysqli extension requires the location of mysql_config file, mysql >extension requires the path of your mysql installation. Then this should be clearly stated somewhere in the installation process. Previous Comments: [2008-05-14 13:04:10] [EMAIL PROTECTED] When using the mysqli extension together with the mysql extension you have to use the same libraries and include files. mysqli extension requires the location of mysql_config file, mysql extension requires the path of your mysql installation. If you installed MySQL 4.1 for example with prefix /usr/local/mysql-4.1 your configure settings should be --with-mysql=/usr/local/mysql-4.1 --with-mysqli=/usr/local/mysql-4.1/bin/mysql_config Tested used the steps listed and it worked fine for me. [2008-05-14 07:22:31] sudakadam at gmail dot com Here is another test case. 1. Installed IIS first. 2. Installed MySql second. 3. used installer php-5.2.5-win32-installer.msi to install and chose to configure IIS. (And selected extra and additional things too) 4. Tried all known options to enable mysql support (edit php.ini, environment variables, php_mysql.dll etc) Tested with simple phpMyAdmin installation. It shows clearly that PHP is not configured with MySql support. [2008-05-10 22:57:46] [EMAIL PROTECTED] Assigned to the installer maintainer. [2008-05-10 05:04:15] Zian dot Choy at gmail dot com 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: SQL Test "; mysql_select_db("$dbName") or die("Could not select database"); print "Database selected successfully"; mysql_close($link); ?> 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 this bug report at http://bugs.php.net/?id=44958&edit=1
#44958 [NEW]: Installer does not correctly configure MySQL support
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: SQL Test "; mysql_select_db("$dbName") or die("Could not select database"); print "Database selected successfully"; mysql_close($link); ?> 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