I had problems with PHP5/Apache2.2/MySQL 5 installation on a WinXp machine.
I got the
Fatal error: call to undefined function - mysql_connect().
1, use correct version of ext\php_mysql.dll and libmysql.dll
2, !!! edit the CORRECT php.ini (%windir%\php.ini) like c:\windows\php.ini !!!
3, add php installation dir to PATH
4, edit php.ini to load extension php_mysql.dll
Installation of extensions on Windows
After installing PHP and a web server on Windows, you will probably want to install some extensions for added functionality. You can choose which extensions you would like to load when PHP starts by modifying your php.ini. You can also load a module dynamically in your script using dl().
The DLLs for PHP extensions are prefixed with php_.
Many extensions are built into the Windows version of PHP. This means additional DLL files, and the extension directive, are not used to load these extensions. The Windows PHP Extensions table lists extensions that require, or used to require, additional PHP DLL files. Here's a list of built in extensions:
The default location PHP searches for extensions is C:\php4\extensions in PHP 4 and C:\php5 in PHP 5. To change this setting to reflect your setup of PHP edit your php.ini file:
You will need to change the extension_dir setting to point to the directory where your extensions lives, or where you have placed your php_*.dll files. For example:
extension_dir = C:\php\extensions
Enable the extension(s) in php.ini you want to use by uncommenting the extension=php_*.dll lines in php.ini. This is done by deleting the leading ; from the extension you want to load.
Example #1 Enable Bzip2 extension for PHP-Windows
// change the following line from ... ;extension=php_bz2.dll // ... to extension=php_bz2.dll
Some of the extensions need extra DLLs to work. Couple of them can be found in the distribution package, in the C:\php\dlls\ folder in PHP 4 or in the main folder in PHP 5, but some, for example Oracle (php_oci8.dll) require DLLs which are not bundled with the distribution package. If you are installing PHP 4, copy the bundled DLLs from C:\php\dlls folder to the main C:\php folder. Don't forget to include C:\php in the system PATH (this process is explained in a separate FAQ entry).
Some of these DLLs are not bundled with the PHP distribution. See each extensions documentation page for details. Also, read the manual section titled Installation of PECL extensions for details on PECL. An increasingly large number of PHP extensions are found in PECL, and these extensions require a separate download.
Note: If you are running a server module version of PHP remember to restart your web server to reflect your changes to php.ini.
The following table describes some of the extensions available and required additional dlls.
|php_bz2.dll||bzip2 compression functions||None|
|php_calendar.dll||Calendar conversion functions||Built in since PHP 4.0.3|
|php_ctype.dll||ctype family functions||Built in since PHP 4.3.0|
|php_curl.dll||CURL, Client URL library functions||Requires: libeay32.dll, ssleay32.dll (bundled)|
|php_dba.dll||DBA: DataBase (dbm-style) Abstraction layer functions||None|
|php_domxml.dll||PHP 4 domxml functions||PHP <= 4.2.0 requires: libxml2.dll (bundled) PHP >= 4.3.0 requires: iconv.dll (bundled)|
|php_dotnet.dll||.NET functions||PHP <= 4.1.1|
|php_exif.dll||EXIF functions||php_mbstring.dll. And, php_exif.dll must be loaded after php_mbstring.dll in php.ini.|
|php_fbsql.dll||FrontBase functions||PHP <= 4.2.0|
|php_fdf.dll||FDF: Forms Data Format functions.||Requires: fdftk.dll (bundled)|
|php_filepro.dll||filePro functions||Read-only access|
|php_ftp.dll||FTP functions||Built-in since PHP 4.0.3|
|php_gd.dll||GD library image functions||Removed in PHP 4.3.2. Also note that truecolor functions are not available in GD1, instead, use php_gd2.dll.|
|php_gd2.dll||GD library image functions||GD2|
|php_gettext.dll||Gettext functions||PHP <= 4.2.0 requires gnu_gettext.dll (bundled), PHP >= 4.2.3 requires libintl-1.dll, iconv.dll (bundled).|
|php_iconv.dll||ICONV characterset conversion||Requires: iconv-1.3.dll (bundled), PHP >=4.2.1 iconv.dll|
|php_ifx.dll||Informix functions||Requires: Informix libraries|
|php_iisfunc.dll||IIS management functions||None|
|php_imap.dll||IMAP POP3 and NNTP functions||None|
|php_ingres.dll||Ingres functions||Requires: Ingres libraries|
|php_interbase.dll||InterBase functions||Requires: gds32.dll (bundled)|
|php_java.dll||Java functions||PHP <= 4.0.6 requires: jvm.dll (bundled)|
|php_ldap.dll||LDAP functions||PHP <= 4.2.0 requires libsasl.dll (bundled), PHP >= 4.3.0 requires libeay32.dll, ssleay32.dll (bundled)|
|php_mbstring.dll||Multi-Byte String functions||None|
|php_mcrypt.dll||Mcrypt Encryption functions||Requires: libmcrypt.dll|
|php_mhash.dll||Mhash functions||PHP >= 4.3.0 requires: libmhash.dll (bundled)|
|php_mime_magic.dll||Mimetype functions||Requires: magic.mime (bundled)|
|php_ming.dll||Ming functions for Flash||None|
|php_msql.dll||mSQL functions||Requires: msql.dll (bundled)|
|php_mssql.dll||MSSQL functions||Requires: ntwdblib.dll (bundled)|
|php_mysql.dll||MySQL functions||PHP >= 5.0.0, requires libmysql.dll (bundled)|
|php_mysqli.dll||MySQLi functions||PHP >= 5.0.0, requires libmysql.dll (libmysqli.dll in PHP <= 5.0.2) (bundled)|
|php_oci8.dll||Oracle 8 functions||Requires: Oracle 8.1+ client libraries|
|php_openssl.dll||OpenSSL functions||Requires: libeay32.dll (bundled)|
|php_overload.dll||PHP 4 Object overloading functions||Built in since PHP 4.3.0, removed as of PHP 5.0.0|
|php_shmop.dll||Shared Memory functions||None|
|php_snmp.dll||SNMP get and walk functions||NT only!|
|php_soap.dll||SOAP functions||PHP >= 5.0.0|
|php_sybase_ct.dll||Sybase functions||Requires: Sybase client libraries|
|php_tidy.dll||Tidy functions||PHP >= 5.0.0|
|php_tokenizer.dll||Tokenizer functions||Built in since PHP 4.3.0|
|php_xmlrpc.dll||XML-RPC functions||PHP >= 4.2.1 requires: iconv.dll (bundled)|
|php_xslt.dll||XSLT functions||PHP <= 4.2.0 requires sablot.dll, expat.dll (bundled). PHP >= 4.2.1 requires sablot.dll, expat.dll, iconv.dll (bundled).|
|php_yaz.dll||YAZ functions||Requires: yaz.dll (bundled)|
|php_zip.dll||Zip File functions||Read only access|
|php_zlib.dll||ZLib compression functions||Built in since PHP 4.3.0|
I got the following error:
PHP Warning: PHP Startup: Unable to load dynamic library 'C:\PHP\ext\php_curl.dll'
By using sysinternals procmon I saw that it failed after trying to load "zlib.dll". I found this file deployed with other software (in my case, Miranda IM) and copied it to the PHP installation directory. It worked fine after that. Hope that helps.
I just recently tried to upgrade my php install on WinXP using the php-5.2.6-win32-installer.msi and with fingers crossed, tried to see if things still worked or not.
Unfortunately, they didn't. I did see many posts here and elsewhere on the web regarding the error message:
"Unable to load dynamic link library 'ext\php_xxxxx.dll' - The specified module could not be found."
php.net says in the past when upgrading to simply copy over new php files, but now recommends using the windows installer. Maybe the installer isn't quite up to the task yet.
1. Completely uninstall current version of php (using Windows Control Panel > Add or Remove Programs).
2. Download the current php binaries for Windows (at php.net/downloads.php under Windows Binaries). Should be format: PHP 5.x.x zip package. Again, download the binaries, NOT the installer.
3. Follow these easy steps
4. Set your PATH for Windows to find php (if you haven't already):
a. Right-click on My Computer
c. Advanced Tab > Environment Variables
d. Under System variables, scroll down to find "Path", select and click on Edit
e. Add path to your php install on the end (make sure to precede with semi-colon ";"). Mine was ";G:\Apache\php"
f. Click Okay. (then "Okay" on each of the other open windows).
5. Test php install. (see ricocheting link above for testing).
6. Getting the extensions to work again:
a. Open php.ini
b. uncomment each extension, restart Apache.
7. Special note on libmysql.dll and problems getting MySQL to work:
- You may have copied over this file into your Windows/System32 (or WINNT/System32 for me) to get mysql to work in the past. If so, replace it with the most recent version you get with the upgrade (in top dir).
- If this is a fresh install, copy the libmysql.dll into your System32 folder.
1. The above tutorial link is to install php 5.x on Apache 2.2 for Win. If you're running Apache 2.0 like me, pay special attention to "Editing Apache Conf File" for correct LoadModule info.
2. If you ran the installer previously, double check your Apache conf where the php5 LoadModule stuff is. The installer might have messed with this a bit.
I hope this stuff helps.
In case you run PHP through Apache under Windows. If PHP complains that it can't load php_mysql.dll but loads other modules the problem is libmysql.dll located at the PHP root directory. In my case PHP and Apache are installed under different drives and the solution I came to was to copy libmysql.dll into C:/WINDOWS/system32. Probably appending your PHP directory to PATH variable would work but in my case phpinfo() reported no change in it
I had problems registering Curl extentions and it was cause by the old dll of libeay32.dll and ssleay32.dll which were already in my c:\windows\system32 I replaced them and all is now fine!!
I had a quick scan through the comments here before posting, as I've had a lot of trouble getting the mysql extension to work with PHP. There are a lot of people who say that adding c:\PHP\ext\ (and variations of) to the path is the answer. There are also a lot of people who find that this doesn't work and end up putting their php.ini and libmysql.dll into the windows and or system32 directories.
I found an old school solution to this problem: Move the entries for c:\php\;c:\php\ext\;c:\mysql\bin\; to the very start of the PATH variable. In the dark old days of DOS before Windows I remember often having to reorganise items in the PATH to get stuff working!
Now it all works like a charm.
I had problem with extensions - they don't loaded (without errors) on Windows installation and don't displayed in phpinfo().
Solve: full-specified directory name for extension_dir directive - "c:/php/ext/" instead "./"
I had a problem with the gd and mysqli mods on my PHP5.2/Apache2.2/Windows 2003 server. Even after enabling the options in the php.ini file and restarting the Apache service, the mods still would not load. I even tried to restart the Windows 2003 server that php is loaded on - and no go. After reviewing the system path variables in Windows, I noticed that the c:\php directory was set in the path variable, but not the folder for the gd, mysqli and others mods. So I added c:\php\ext to the path variable and rebooted the server. THAT FIXED IT!!
After upgrading to PHP5 with Apache 2.2.10 on windows server 2003 I was having troubles with the error saying Fatal error: call to undefined function - mysql_connect().
I had done everything I could think of or find on the internet and was still having the same error show up.
I then ran the phpinfo() function and it showed I was reading the correct php.ini from my C:/PHP/ path and it showed a mysql version.
The problem was it loaded the mysql files in my system32 directory which were from an earlier version. I simply removed these files from my system32 directory and it had fixed the problem since I had everything else correctly setup.
Make sure your php.ini file is read at all.
I had the problem that on a Windows 2003 Server the php.ini was not read, so only default values were used resulting in no extension modules to work, because they do not reside in C:\PHP5 but in D:\PHP\ext.
The output of phpinfo() told me the "Configuration File (php.ini) Path" was "C:\WINDOWS".
Well this sounded good to me because I had copied the php.ini file from D:\PHP to C:\WINDOWS.
But a path to a directory as a value of "Configuration File (php.ini) Path" instead of the full path to the php.ini file you expect to be read means that NO php.ini file could be found so that the default values are used.
What fixed the problem was adding a System variable "PHPRC" set to the path to the directory where the php.ini file is to be found.
After rebooting the Server everything was fine - the extension_dir was set correctly and after all I succeeded in connecting to my MySQL-Database-Server.
If you are having trouble getting extensions to run and changes to php.ini don't seem to make a jot of difference you may find that your php.ini is not being read and you are running on defaults.
The good news is that Elsint's fix (dated 26-Sep-2006) still works for php 5.2.6 under Windows Server 2003 SP2, on IIS6, running php as an ISAPI module.
run a test file
Load this in a browser and search the results for "Loaded Configuration File". This points to the .ini file in use, which I have found is not always the one I have been editing ...
If your problem is with extensions: search for extension_dir in the phpinfo() results. If the entry which follows is C:\PHP5, or some other directory which does not exist on your drive you may need the registry fix. The alternative is to put the php.ini file somewhere along the search path, but this is not quite as clean.
If you run the installer packages: php-5.2.5-win32-installer.msi or php-5.2.6-win32-installer.msi and choose the default install directory the following registry entires are added
InstallDir REG_SZ C:\Program Files\PHP\
WebServerType REG_SZ iis4ISAPI
However, the installers above do not create the IniFilePath registry entry.
So: you either go for a direct registry hack or create and run a registry file named: "[whatever].reg"
If your install directory is the default for the above installers the contents should be the 4 (four) lines below (counting the blank one!) between the pseudo tags.
Windows Registry Editor Version 5.00
(Note you have to have the double backslashes for the .reg file to work even though Windows reports it worked without them).
Once you have the new registry key in place you may find it sufficient to restart the World Wide Web Publishing Service, which is also restarted if you take the slightly longer option of restarting the IIS Admin Service.
If this works for you and you want to backtrack by undoing the registry changes to test if this was the fix that did it: you may need a reboot (not just a service restart) because of some rather irritating persistencies.
If you get errors like this:
PHP Notice: Constant XML_ELEMENT_NODE already defined in Unknown on line 0
And many more complaining about XML constants, comment out the line:
in your php.ini. That extension seems to be compiled into PHP when you get those errors or something else is including the functionality before that dll.
Consider the following from an httpd.conf file...
LoadModule php5_module "E:/xyz/php/php5apache2_2.dll"
...which led to the dreaded...
PHP Warning: PHP Startup: Unable to load dynamic library 'E:\\xyz\\php\\ext\\php_mysql.dll' - The specified module could not be found.
Note, however, that PHP.exe apparently was found and executed php pages in Apache, but the MySQL functions therein failed.
Because PHP dir was not in $PATH, php5apache2_2.dll failed to find php_mysql.dll (the only extension I enabled) during Apache 2.2 start.
== Caveat (!)
The BIG issue is that, setting $PATH in...
<desk icon>My Computer
...didn't export the $PATH change such that restarting the Apache service (in MMC) would pick it up. So I tested the working solution (adding PHP dir to $PATH), but it failed because of HOW I set it. It succeeded only when I REBOOTED after changing the $PATH. There may be an easier way that this, but I do not know it at present.
Consider whether PHP dir should need to be in $PATH at all, when PHP.exe apparently was found and executes php pages in Apache, but php5apache2_2.dll failed to find whatever was needed to load the extensions. This should perhaps be addressed.
Note that on a WAMP installation (W2K,Apache,MySQL,PHP), only PHP is required in $PATH.
As far as my experience says, 95% of ext\php_mysql.dll - The specified module could not be found - error can be sorted out on Win 2003, IIS 6, PHP5.2.
Replace the php_mysql.dll and libmysql.dll downloaded from http://dev.mysql.com/downloads/connector/php/ into extensions directory.
For MSSQL connectivity problems, replace the ntwdblib.dll in php dir with the one copied from system32 directory. Ofcourse the filesize will be less, no problem, replace it.
Under windows, given an error similar to
PHP Warning: PHP Startup: Unable to load dynamic library 'c:\\php\\ext\\php_mysql.dll' - The specified module could not be found.\r\n in Unknown on line 0
When PHP definitely should be able to find the module, it's fairly common knowledge that this error can also be caused by certain dlls not being in the PATH. These dlls (usually libeay32 and ssleay32) are generally found in your base php directory, and the modern windows installers add the base php directory to the PATH so that you don't need to worry about it. However, if when installing earlier versions you decided on moving libeay32, ssleay32 et al to C:\Windows\System32 instead of changing the PATH, then php will still end up with the old versions and the out of date versions will cause the same error as above. Don't fall into the trap like I did.
Installing PHP extensions for IIS for the first time is sort of a baptism by fire -- you will get your hands dirty, and other suitable metaphors of nastiness. Hopefully, you won't have to spend too many days googling around fora and restarting IIS 10 million times as I did until I finally realized both what was going on and what crazy things I'd done wrong.
THIS (peter)guy really goes into terrific detail and troubleshooting, (with very good reasons and explanations of extension dependencies not listed on the current php page you're now reading):
Most of this is applicable for IIS5.1 as well, as far as I've found.
The main problem I'd been butting my head up against was extensions being reported as not found, even though the .DLLs were definitely in C:\PHP\ext, and my PATH env var was setup correctly.
The error messaging during dynamic loading of implicitly-linked libraries should be more specific, telling you that in fact it is a particular dependency of a dependency which is missing -- usually some obscure third-party .dll -- and name it!
Eventually I stopped being so greedy and just cut down on the extensions I thought I needed by commenting them out in php.ini. That eliminated the startup errors. Apparently some of these extensions or their requirements, which either come with the base PHP install zip or the PECL extensions, are either too obscure or too fragile to be necessary anyway.
Good luck, and I hope anyone who runs into the same trouble can hit upon this or Peter Guy's page directly before they go too crazy.
When confronted with the problem "PHP Warning: PHP Startup: Unable to load dynamic library './php_mysql.dll' - Access is denied.\r\n in Unknown on line 0" I found I had to make the permissions "chmod.exe 755 php_mysql.dll"
(This is on a Windows XP, but I am running Cygwin).
I just installed PHP5.2 + Apache2.2 + MySQL5 on Windows XP. Three imporatant things.
1. I tryed to put php.ini in windows directory like in early version. But php can't load it and using default values only. After I put php.ini into php installation directory, everything is fine.
2. You still need to copy libmysql.dll to windows\system32 directory for the mysql extension to work.
3. Don't forget for apache 2.2, you need php5apache2_2.dll instead of php5apache2.dll.
We tried to install PHP 4 ISAPI Module on IIS 6 on a Windows Server 2003 SP2 at the office.
The only way we found out to make these extensions work, is by putting the extensions DLLs in the System32\inetsrv in the Windows directory. We did the same previously with the
php4isapi.dll and php4ts.dll to make PHP work. The system was asking for a password previously.
We cannot explain it, it seems like a problem only occuring with SP2 installed because we never had this problem before. Giving the right permission to the PHP and extensions folders didn't do anything good. It always gave use a permission denied error. We even tried to give full control to Everyone on the PHP folder, same result.
I hope it can help.
Installing PHP5.1.6 on an IIS5.1 system.
Some extensions are not working because of registry(like LDAP).
You need to create a registry file named: "inifilepath.reg"
Content should be the 3 lines under,be sure to define your PHP path correct:
Windows Registry Editor Version 5.00
After creating this file, double click it, click yes, and restart IIS. Hopefully this might solve problem for some, as it solved for me.
If You try to install PHP5 to IIS6 with Oracle....
Then You need some kind of pilot-exams, not for big planes, just a little one.
So: After installations (php.ini is correct see above ie.: extenstion = php_oci8.dll etc)
If You use anonymous access, You'll have a builtin user to use it. Make this user local administrator, or give minimum read access to PHP folder (ie.: c:\php) and ORAHOME (ie. c:\ora92) folders.
If You use Windows Integrated authentication, give for Domain Users minimum read access to PHP folder (ie.: c:\php) and ORAHOME (ie. c:\ora92) folders.
[editor note: this should be fixed in PHP 5.1.0]
The order of the extensions listed in php.ini is causing problems... one must check that a particular extension A is enabled and above extension B if B requires A to be enabled.
The original ordering doesnt make sure that this always happens (ie, A is above B)
I came into this problem when I tried to enable the exif extension under windows. I knew mbstring is required but I kept getting errors even after I enabled both.
The problem can only be fixed by moving the mbstring line above the exif line...