PHP - MySQL - IIS XPP issue
Posted 29 October 2006 - 12:28 AM
* PHP 5.1.6 installed
Could not find a suitable database driver!
o For MySQL, compile PHP using --with-mysql, or install the mysql.so module
o For PostgreSQL, compile PHP using --with-pgsql, or install the pgsql.so module
PHP. Installed PHP5 from php-5.1.6-Win32.zip into standard C:\PHP directory. Can browse to and execute simple scripts OK. Added C:\PHP and C:\PHP\ext to my PATH.
MySQL. Installed from mysql-essential-5.0.24a-win32.msi. Running it as a service and can do things like mysqlshow OK. Also downloaded and installed php_5.1.6_mysqli_5.0.26-win32.zip, putting php_mysqli.dll into C:\PHP\ext.
PHP.INI Copied php.ini-recommended to php.ini.
Unremmed extension=php_mysqli.dll. Set extension_dir = "C:\PHP\ext". Set sql.safe_mode = Off. Set doc_root = c:\inetpub\wwwroot.
Have read lots of posts, but no luck. Any help MOST appreciated.
Posted 29 October 2006 - 12:53 PM
So enable extension=php_mysql.dll from within the php.ini. Restart your server.
The MySQL Improved Library has a completely different function library. Also You don't need to enable the MySQL Improved Library if you have MySQL5 installed.
Posted 29 October 2006 - 07:07 PM
"PHP Startup: Unable to load dynamic library 'C:\PHP\ext\php_mysql.dll' - The specificed module could not be found." Then another ditto about mysqli (both of which are currently unremmed in php.ini).
Then I get the same error as at first.
The path is currect and both dlls are there.
I would change to Apache, but can't in my environment.
Posted 30 October 2006 - 07:32 PM
The above file should be located in the WINDOWS (or WINNT) folder if you have not added your PHP folder to the Windows PATH variable. PHP needs to find this file in order to load up the mysql(i) extension
Also make sure there is no older version of libmysql.dll that PHP might be finding too.
Posted 31 October 2006 - 01:47 AM
Guess I'll find a simple script to run something in MySQL to see whether that's working WITHOUT Mediawiki.
Posted 31 October 2006 - 06:30 PM
<?php echo "Connecting to MySQL Server...." $conn = mysql_connect("localhost", "username", "password"); echo "<br />Connection established!<br /><br />Selecting Database...."; mysql_select_db("mysql"); echo "Database selected!!<br /><br />"; ?>
If you get the following output:
Then the mysql extension is loaded.
Connecting to MySQL Server....
Posted 03 November 2006 - 01:17 AM
Thank you all!
Posted 03 November 2006 - 05:44 PM
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users