PHP, Postnuke, & MySQL

can you post an example?

I made the change to php.ini

php_mysql.dll is in the ext directory

where do I find libmysql.dll?

I searched for it and found about 5 different copies in different places.  Which one do I use?

Thanks.

you should be able to find it in your main php folder. when you unzip'd php just toss it in your system32 directory

ok.  Here is my current status.
I added the php directory to the system path.
I copied libmysql.dll to the system32 directory.
I verified that php_mysql.dll is in the directory c:\php\ext\

Here are the relevant lines from php.ini:

doc_root = "c:\Inetpub\wwwroot"
extension_dir = "./ext"
extension=php_mysql.dll

I can get the test.php file to show information, but when I run http://localhost/phpMyAdmin/index.php
I get the following popup notice:

PHP Startup: Unable to load dynamic library './php_mysql.dll' - The specified module could not be found.

I also get the following error in the browser:

cannot load mysql extension;
please check PHP configuration
Documentation

Here are the relavent lines from config.inc.php:

$cfg['Servers'][$i]['host']          = 'localhost';
$cfg['Servers'][$i]['port']          = '';
$cfg['Servers'][$i]['connect_type']  = 'tcp';
$cfg['Servers'][$i]['extension']     = 'mysql';
$cfg['Servers'][$i]['auth_type']     = 'config';
$cfg['Servers'][$i]['user']          = 'root';
$cfg['Servers'][$i]['password']      = 'password';


I greatly appreciate all the help.

extension_dir = "c:\php\ext\"

ok.  made that change.  I'm still getting the same errors, both the pop up and the browser error.  One other error I got, was I tried to restart IIS and recieved an error that said:

"Com Surrogate has encountered an error and needs to close"

oops

 extension_dir = "c:\php\ext"

there shouldnt be a trailing \

also try adding your php directory to your system path.

ok.  took off the slash.  Checked the system path.  It is below.

%SystemRoot%\system32;%SystemRoot%;%SystemRoot%\System32\Wbem;%SystemRoot%\PHP;%SystemRoot%\PHP\ext;%SystemRoot%\php

I put the PHP directory in both upper and lower case.  I'm still getting the same errors.

Thanks.

when was it added to your system path? if it was just recently i have heard cases of having to reboot the windows machine for the path change to take effect.

I restarted and still get the same errors.  What I find interesting is that the popup error says it can't load "./php_mysql.dll" shouldn't it be looking for c:\PHP\ext\php_mysql.dll?

you will get that error if it cant find php_mysql.dll or libmysql.dll where may i ask did you pick up your libmysql.dll ? please make sure this is the one that came packaged with php and not one you may have found elsewhere on your system.

ok.  just to make sure I had the correct files, I recopied them and restarted the server and it is working now.  I installed the postnuke files and ran the install.  It created the database files, but had an error updating the config.php file, so I made the changes that it told me it required.  I then ran http://localhost/postnuke/html/index.php and it said it had a database connection error.

mysql is running? the database server is set to localhost?  username and password for mysql supplied are accurate? database name is correct?

compared the config settings of postnuke which isn't working to the settings of phpMyAdmin which is working, and all settings are the same.

Here is how I have the files:

C:\Inetpub\wwwroot\phpMyAdmin\index.php

C:\Inetpub\wwwroot\postnuke\index.php

(in case that might help)

Thanks.

does postnuke output any other type of error message that may give more explanation? if phpmyadmin is working then php/mysql is all configured properly, something bugged with postnuke

all it says is "Problem with database connection"

any files you think I should check?

i'm not very familiar with postnuke. i tend to create CMS for my own needs. try opening up index.php after the includes etc. and

echo mysql_error(); to see whether it gives you anything descriptive

I didn't get any mysql error.  I did notice that phpMyAdmin had this error at the bottom:

The mbstring PHP extension was not found and you seem to be using a multibyte charset. Without the mbstring extension phpMyAdmin is unable to split strings correctly and it may result in unexpected results.

I went into php.ini and uncommented the appropriate extension line and rebooted the server, but I'm still getting that error.