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
Instalação de extensões no Windows
Depois de instalar o PHP e um servidor web no Windows, você provavelmente desejará instalar algumas extensões para ter funcionalidades extras. Você pode escolher quais extensões você quer que o PHP carregue quando é iniciado modificando o arquivo php.ini. Você também pode carregar um módulo dinamicamente no seu script usando dl().
Os DLLs para extensões do PHP são prefixadas com php_.
Muitas extensões são compiladas dentro da versão para Windows. Isso significa que arquivos DLL adicionais, e a diretiva extension, não são utilizadas para carregar essas extensões. A tabela de Extensões PHP lista extensões que requerem, ou costumavam requerer, arquivos DLL adicionais do PHP. Aqui está uma lista das extensões já compiladas dentro do PHP:
A localização padrão que o PHP procura por extensões é C:\php4\extensions no PHP 4 e C:\php5 no PHP 5. Para mudar esta configuração para refletir sua instalação do PHP, edite o arquivo php.ini:
Você precisará mudar a configuração extension_dirpara apontar o diretório onde suas extensões estão guardadas, ou onde você colocou os arquivos php_*.dll. Por exemplo:
extension_dir = C:\php\extensions
Habilite a(s) extensão(ões) no arquivo php.ini que você quiser descomentando as linhas extension=php_*.dll. Isso é feito removendo o ; na antes da linha com a extensão que você quer carregar.
Exemplo #1 Habilitar a extensão Bzip2 para o PHP-Windows
// Mude a seguinte linha de ... ;extension=php_bz2.dll // ... para extension=php_bz2.dll
Algumas das extensões precisam de DLLs extras para funcionarem. Algumas delas podem ser encontradas no pacote da distribuição, na pasta C:\php\dlls\ no PHP 4 ou na pasta principal no PHP 5, mas algumas, por exemplo o Oracle (php_oci8.dll) requerem DLLs que não estão agregadas ao pacote da distribuição. Se você estiver instalando o PHP 4, copie as DLLs agregadas da pasta C:\php\dlls para a pasta principal C:\php. Não se esqueça de incluir C:\php na variável de ambiente PATH (esse processo é explicado em outra página, nesse FAQ).
Algumas destas dlls não sao embutidas com a distribuição do PHP. Veja a documentação de cada extensão para maiores detalhes. Também leia o manual na sessão entitulada Instalação de extensões PECL para detalhes sobre PECL. Um crestente número de extensões para o PHP são encontradas no PECL, e estas extensões precisam de um download separado.
Nota: Se você estiver executando a versão de módulo do servidor do PHP lembre de reiniciar o servidor web para que as mudanças no arquivo php.ini sejam efetivadas.
A tabela a seguir descreve algumas das extensões disponíveis e as dlls adicionais requeridas.
|php_bz2.dll||Funções de Compressão de bzip2||Nenhuma|
|php_calendar.dll||Funções de Conversão de Calendar||Integrado desde o PHP 4.0.3|
|php_crack.dll||Funções de Crack||Nenhuma|
|php_ctype.dll||Família de Funções ctype||Integrado desde o PHP 4.3.0|
|php_curl.dll||Biblioteca de Funções de Cliente URL - CURL||Requer: libeay32.dll, ssleay32.dll (agregado)|
|php_dba.dll||Camada de Funções de Abstração de Banco de Dados DBA||Nenhuma|
|php_dbase.dll||Funções de dBase||Nenhuma|
|php_domxml.dll||Funções DOM XML||PHP <= 4.2.0 requer: libxml2.dll (agregado) PHP >= 4.3.0 requer: iconv.dll (agregado)|
|php_dotnet.dll||Funções .NET||PHP <= 4.1.1|
|php_exif.dll||Funções EXIF||php_mbstring.dll. e, php_exif.dll devem ser carregados depois de php_mbstring.dll no arquivo php.ini.|
|php_fbsql.dll||Funções FrontBase||PHP <= 4.2.0|
|php_fdf.dll||Funções de Formato de Dados de Formulários (Forms Data Format) FDF.||Requer: fdftk.dll (agregado)|
|php_filepro.dll||Funções de filePro||Acesso apenas de Leitura|
|php_ftp.dll||Funções de FTP||Integrado desde o PHP 4.0.3|
|php_gd.dll||Funções da biblioteca de imagens GD||Removido no PHP 4.3.2. Note também que funções truecolor functions não estão disponíveis no GD1, ao invés, use php_gd2.dll.|
|php_gd2.dll||Funções da biblioteca de imagens GD||GD2|
|php_gettext.dll||Funções de Gettext||PHP <= 4.2.0 requer gnu_gettext.dll (agregado), PHP >= 4.2.3 requer libintl-1.dll, iconv.dll (agregado).|
|php_hyperwave.dll||Funções de HyperWave||Nenhuma|
|php_iconv.dll||Conversão de tabela de caracteres ICONV||Requer: iconv-1.3.dll (agregado), PHP >=4.2.1 iconv.dll|
|php_ifx.dll||Funções de Informix||Requer: Informix libraries|
|php_iisfunc.dll||Funções de manuseio de IIS||Nenhuma|
|php_imap.dll||Funções de IMAP POP3 e NNTP||Nenhuma|
|php_ingres.dll||Funções de Ingres II||Requer: Ingres II libraries|
|php_interbase.dll||Funções de InterBase||Requer: gds32.dll (agregado)|
|php_java.dll||Funções de Java||PHP <= 4.0.6 requer: jvm.dll (agregado)|
|php_ldap.dll||Funções de LDAP||PHP <= 4.2.0 requer libsasl.dll (agregado), PHP >= 4.3.0 requer libeay32.dll, ssleay32.dll (agregado)|
|php_mbstring.dll||Funções de Multi-Byte String||Nenhuma|
|php_mcrypt.dll||Funções de Mcrypt Encryption||Requer: libmcrypt.dll|
|php_mhash.dll||Funções de Mhash||PHP >= 4.3.0 requer: libmhash.dll (agregado)|
|php_mime_magic.dll||Funções de Mimetype||Requer: magic.mime (agregado)|
|php_ming.dll||Funções de Ming para Flash||Nenhuma|
|php_msql.dll||Funções de mSQL||Requer: msql.dll (agregado)|
|php_mssql.dll||Funções de MSSQL||Requer: ntwdblib.dll (agregado)|
|php_mysql.dll||Funções de MySQL||PHP >= 5.0.0, requer libmysql.dll (agregado)|
|php_mysqli.dll||Funções de MySQLi||PHP >= 5.0.0, requer libmysql.dll (libmysqli.dll in PHP <= 5.0.2) (agregado)|
|php_oci8.dll||Funções de Oracle 8||Requer: Oracle 8.1+ client libraries|
|php_openssl.dll||Funções de OpenSSL||Requer: libeay32.dll (agregado)|
|php_overload.dll||Funções de Overload||Integrado desde o PHP 4.3.0 >= 5.0.0|
|php_pdf.dll||Funções de PDF||Nenhuma|
|php_pgsql.dll||Funções de PostgreSQL||Nenhuma|
|php_printer.dll||Funções de Impressora||Nenhuma|
|php_shmop.dll||Funções de Memória Compartilhada||Nenhuma|
|php_snmp.dll||Funções de get and walk de SNMP||Apenas no NT!|
|php_soap.dll||Funções de SOAP||PHP >= 5.0.0|
|php_sockets.dll||Funções de Socket||Nenhuma|
|php_sybase_ct.dll||Funções de Sybase||Requer: bibliotecas de cliente do Sybase|
|php_tidy.dll||Funções de Tidy||PHP >= 5.0.0|
|php_tokenizer.dll||Funções de Tokenizer||Integrado desde o PHP 4.3.0|
|php_w32api.dll||Funções de W32api||Nenhuma|
|php_xmlrpc.dll||Funções de XML-RPC||PHP >= 4.2.1 requer: iconv.dll (agregado)|
|php_xslt.dll||Funções de XSLT||PHP <= 4.2.0 requer sablot.dll, expat.dll (agregado). PHP >= 4.2.1 requer sablot.dll, expat.dll, iconv.dll (agregado).|
|php_yaz.dll||Funções do YAZ||Requer: yaz.dll (agregado)|
|php_zip.dll||Funções para Arquivos Zip||Acesso apenas de leitura|
|php_zlib.dll||Funções de compressão de ZLib||Integrado desde o 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...