[RESOLVED] mysql is not showing in php_info();

[leetkrew]

Problem

PHP is not loading mysql / mysqli extension

Current Settings

i) Operating System is Windows Server 2003 / IIS6 / ISAPI
ii) PHP installation path: C:\PHP
iii) extension_dir = C:\PHP\ext
iv) IIS is running with PHP 5.26
v) I can login to mysql console

What i did so far

i) on php.ini, extension_dir, i put this changes
-> extension_dir = "./ext"
-> extension_dir = "./ext/"
-> extension_dir = "C:\PHP\ext"
-> extension_dir = "C:\PHP\ext\"
ii) with the same file, i uncommented the following:
-> extension=php_bz2.dll
-> extension=php_gd2.dll
-> extension=php_mssql.dll
-> extension=php_mysql.dll
-> extension=php_mysqli.dll
-> extension=php_oci8.dll

iii) downloaded PHP and PECL ZIP packages, copied PECL dll files to C:\PHP\EXT directory

iv) Uncommented all extensions and none of them showed on phpinfo

i do restart the whole server everytime i commit changes.

please disregard the " -> " thing. I put that for indentation purposes only

please help.. thanks =)

---

EDIT:

using file monitor tool, i found out that C:\PHP\PHP.INI is not loaded. I moved it in C:\WINDOWS directory, uncommented all extensions and it solves the problem fore some extensions.

i checked it on my PHPINFO page and the following is not loaded. The following files has been read by the system but not loaded.

extension=php_curl.dll
extension=php_exif.dll
extension=php_fdf.dll
extension=php_ifx.dll
extension=php_interbase.dll
extension=php_ldap.dll
extension=php_mcrypt.dll
extension=php_mhash.dll
extension=php_msql.dll
extension=php_mysql.dll
extension=php_mysqli.dll
extension=php_oci8.dll
extension=php_openssl.dll
extension=php_pdo_firebird.dll
extension=php_pdo_oci.dll
extension=php_pdo_oci8.dll
extension=php_pdo_mysql.dll
extension=php_pdo_pgsql.dll
extension=php_pgsql.dll
extension=php_pspell.dll
extension=php_sybase_ct.dll

---

edit
php_mysql.dll is only being read if i accessed phpmyadmin. But still, phpmyadmin told me that mysql is not loaded

[leetkrew]

i just copied libmysql.dll to C:\WINDOWS\system32 and it works.

thanks anyway =)

[bradgrafelman]

As I've advocated elsewhere, note that you should never copy any DLL's/files outside of the main PHP directory. Instead, leave libmysql.dll (and others) in the main PHP directory. Then, add the main PHP directory to your system's PATH environment variable (as per the installation instructions in the PHP manual - [man]windows.install.manual[/man]) and reboot the system.

[leetkrew]

thanks... i moved it into my php directory and restarted IIS but i cannot reboot the system now because there are too many active transactions/connections on the server. =)