[RESOLVED] Yet another PhP 5 & MySQL not talking issue

leatherback

Sorry...,

I am annoyed at not being able to figure this out. I see a lot of posts about this topic, but I cannot figure out what is going wrong.

I get the error: 'Cannot load mysql extension. Please check your PHP configuration.' in phpmyadmin.
Php doesn't understand mysql commands
phpinfo() doesn't show the mysql module loaded.

I reinstalled my server, as my provider moved to php 5.0.4 / mysql 4.1.2

So I got:
Apache 2.2.4 / mysql 4.1.2 / php 5.2.1 / phpmyadmin 2.1.0.0.2 on win200 pro

Installed the bunch in:
c:/web/apache
c:/web/apache/php
c:/web/apache/phpmyadmin
c:/web/mysql

Apache works, php works, mysql works.

I added C:\web\mysql\bin;c:\web\apache\php to the paths
I loaded the modules in php.ini:
extension=php_mysql.dll
extension=php_mysqli.dll
which are both present in
extension_dir = "C:/web/apache/php"

What am I missing?

Thanks

Jelle

bradgrafelman

If you do a phpinfo(), does it show the correct path to your php.ini file as well as your extension directory? If you look in c:\web\apache\php\, do you see 'libmysql.dll' ? Are there any weird security permissions on the PHP folder (properties of folder, Security tab) itself?

Can you tell us the value of your PATH system environment variable? Sounds like you know where it is, but just in case you don't: Properties of My Computer -> Advanced tab -> Environment Variables button -> System variables table -> PATH. Just click on it, click edit, and copy and paste its value in a post for us to see (in addition to the answers to the above questions, of course :p).

leatherback

What a difference some sleep makes!

Thanks Brad, for the suggestions. It was indeed a system PATH variable thing; Yes.. php_mysql.dll and php_mysqli.dll were in my extensions folder. But not in the php main folder, which is where the systems PATH was pointing to.

I copied the php_mysql.dll and php_mysqli.dll function libraries from the extension folder into the php main folder, which solved the problem (Possibly I should have changed the PATH variable to point to the extension folder, instead of to the main php folder, but I am not sure what trouble that would have given me)..

Anyway.. Problem solved!