A mystery: Why were my settings not working?

[saturday]

I was having problems getting mysql to work with php on my apache
server. Thankfully I got it working after reading a different thread,
which had me copy over the libmysql file to the apache/bin folder, but
this leaves the question: why didn't it work in the first place? It was
driving me nuts, and I'd still like to know why.

My settings before I dragged over the file:

XP Pro SP2
Latest PHP installed in "C:\Program Files\php"
Latest mysql with the latest Connector\PHP files in the proper PHP
dir's.

From phpinfo(): Configuration File (php.ini) Path: C:\Program Files\php\php.ini

PHP Core
extension_dir: c:\Program Files\php\ext

Apache Environment
Path: "C:\Program Files\Microsoft DirectX SDK (February
2006)\Utilities\Bin\x86";C:\Program Files\Microsoft DirectX 9.0 SDK
(October
2005)\Utilities\Bin\x86;C:\WINDOWS\system32;C:\WIN DOWS;C:\WINDOWS\System32\Wbem;"C:\Program
Files\php";C:\Program Files\QuickTime\QTSystem\

(the path was set up many restarts ago)
From php.ini extension=php_mysql.dll enabled
From the apache httpd.conf file # For PHP 5 do something like this:
LoadModule php5_module "c:/Program Files/php/php5apache2.dll"
AddType application/x-httpd-php .php

# configure the path to php.ini
PHPIniDir "C:/Program Files/php"
From the Apache error log: Unable to load dynamic library 'c:\\Program
Files\\php\\ext\\php_mysql.dll'

From all the FAQ's and guides I read, that configuration should have

been a go. What was I doing wrong?

[Jerry Stuckle]

sa******@gmail.com wrote:

I was having problems getting mysql to work with php on my apache
server. Thankfully I got it working after reading a different thread,
which had me copy over the libmysql file to the apache/bin folder, but
this leaves the question: why didn't it work in the first place? It was
driving me nuts, and I'd still like to know why.

My settings before I dragged over the file:

XP Pro SP2
Latest PHP installed in "C:\Program Files\php"
Latest mysql with the latest Connector\PHP files in the proper PHP
dir's.

From phpinfo():

Configuration File (php.ini) Path: C:\Program Files\php\php.ini

PHP Core
extension_dir: c:\Program Files\php\ext

Apache Environment
Path: "C:\Program Files\Microsoft DirectX SDK (February
2006)\Utilities\Bin\x86";C:\Program Files\Microsoft DirectX 9.0 SDK
(October
2005)\Utilities\Bin\x86;C:\WINDOWS\system32;C:\WIN DOWS;C:\WINDOWS\System32\Wbem;"C:\Program
Files\php";C:\Program Files\QuickTime\QTSystem\

(the path was set up many restarts ago)

From php.ini

extension=php_mysql.dll enabled

From the apache httpd.conf file

# For PHP 5 do something like this:
LoadModule php5_module "c:/Program Files/php/php5apache2.dll"
AddType application/x-httpd-php .php

# configure the path to php.ini
PHPIniDir "C:/Program Files/php"

From the Apache error log:

Unable to load dynamic library 'c:\\Program
Files\\php\\ext\\php_mysql.dll'

From all the FAQ's and guides I read, that configuration should have

been a go. What was I doing wrong?

Sounds like the directory where libmysql.dll existed was not in your PATH. It
works later because that where you have Apache (either full or relative path) is.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
js*******@attglobal.net
==================