[RESOLVED] php_pgsql.dll' - The operating system cannot run %1.

gzur

I had PHP running with postgreSQL fine until something happened. I have as of yet been unable to figure out what, but it caused PHP to fail in loading up php_pgsql.dll.

apache's error.log gives me the following on startup:

[FONT="Courier New"]PHP Warning: PHP Startup: Unable to load dynamic library 'C:\PHP5\ext\php_pgsql.dll' - The operating system cannot run %1.\r\n in Unknown on line 0[/FONT]

The problem is not that it can't find the .dll, if I rename it I get File Not Found error.

I've tried reinstalling PHP but to no avail.

I found some info regarding a failed dependency which I encountered with Dependency Walker, but following that lead led me nowhere.

I've twiddled around with all the configs I can find.

Any ideas?

bradgrafelman

What operating system are you using? Do you have IE7 installed as mentioned in that article?

Also, have you added the PHP directory to your system's PATH environment variable (and then restarted Windows itself - not just Apache)?

gzur

Oh yeah, I totally forgot to mention that didn't I 🙂

I'm running PHP 5.2.8 on Apache 2.0.61 under Windows Server 2003 R2 SP2

I DID have IE7 installed, but I uninstalled it and it didn't have any effect.

My PATH variable is firmly set to C:\PHP5

this is what apache spits out when I start it up.

PHP Warning:  PHP Startup: Unable to load dynamic library 'C:\\PHP5\\ext\\php_pgsql.dll' - The operating system cannot run %1.\r\n in Unknown on line 0
[Tue Feb 10 10:31:10 2009] [notice] Apache/2.0.61 (Win32) PHP/5.2.8 configured -- resuming normal operations
[Tue Feb 10 10:31:10 2009] [notice] Server built: Sep  5 2007 09:55:35
[Tue Feb 10 10:31:10 2009] [notice] Parent: Created child process 4476
[Tue Feb 10 10:31:10 2009] [notice] mod_python: Creating 8 session mutexes based on 0 max processes and 250 max threads.
PHP Warning:  PHP Startup: Unable to load dynamic library 'C:\\PHP5\\ext\\php_pgsql.dll' - The operating system cannot run %1.\r\n in Unknown on line 0
[Tue Feb 10 10:31:10 2009] [notice] Child 4476: Child process is running
[Tue Feb 10 10:31:10 2009] [notice] Child 4476: Acquired the start mutex.
[Tue Feb 10 10:31:10 2009] [notice] Child 4476: Starting 250 worker threads.

php_pgsql.dll is PHP's PostgreSQL driver. I've tried re-installing PHP, I've even set up a parallel instance of Apache.
But to no avail.

gzur

I downloaded the version of postgreSQL I was using (8.2) and copied all the DLL's from it into my %WINDIR%\system32\

And then it started working like a charm.

Thanks for the help anyway 🙂

bradgrafelman

Just as a note, DLL's normally should never be copied from outside their original directory into the system32 directory; instead, the directory of the product in question should be added to the system's PATH environment variable.

One of the main reasons this holds true (for PHP, MySQL, PostgreSQL, and other software) is simply to prevent old libraries from hanging around after a product is uninstalled, upgraded, etc.