PGSQL未加载到IIS 5.3下的PHP 5.3 Windows中 [英] PGSQL not loaded in PHP 5.3 Windows under IIS

问题描述

我知道有关PGSQL无法加载的问题还有其他问题，但我找不到适合我的解决方案，直接解决了Windows下的IIS设置（显然）。使用PostgreSQL 8.4。

I know there are other questions about problems with PGSQL not loading, but I haven't found a solution that works for me and directly addresses an IIS setup under Windows (obviously). Using PostgreSQL 8.4.

由于我是PHP的完全新手（只是试图让MantisBT运行），我觉得这很难调试/研究。

Since I am a complete novice in PHP (only trying to get MantisBT to run) I find this extremely hard to debug/research.

我已经设置了PostgreSQL bin文件夹和PHP文件夹的路径（首先是v5.3子文件夹，之后是PHP根目录）。我已经检查过所有这三个文件夹中都存在libpq.dll，我尝试将libpq.dll从PostgreSQL文件夹复制到两个PHP文件夹中。我已经确定php.ini包含

I've set the path to both PostgreSQL bin folder and the PHP folders (v5.3 subfolder first and the PHP root after that). I've checked that libpq.dll is present in all three of these folders and I've tried copying the libpq.dll from the PostgreSQL folder to both PHP folders. I've made sure php.ini contains

extension=php_pdo_pgsql.dll
extension=php_pgsql.dll

两个PHP文件夹（root和v5.3）中的

。

in both PHP folders (root as well as v5.3).

还有什么要检查/尝试/检查？

What more to check/try/examine?

推荐答案

尝试 phpinfo（）再次，它报告

Loaded Configuration File = C:\Program Files (x86)\PHP\v5.3\php.ini

这是正确的，包含 extension = php_pdo_pgsql.dll 和 extension = php_pgsql.dll 。至于dll是在正确的地方（@Richard），我确实需要确定dll：s是什么以及它们应该位于何处，但我有 C：\Program文件（x86）\PHP \v5.3 \\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\ c $ c> php_pgsql.dll （版本5.3.12.0）。

which is correct and contains extension=php_pdo_pgsql.dll and extension=php_pgsql.dll. As for "the dll's are in the right place" (@Richard), I have problems making sure exactly what dll:s are needed and where they should be located, but I have in C:\Program Files (x86)\PHP\v5.3\ext\ both php_pdo_pgsql.dll (version 5.3.12.0) and php_pgsql.dll (version 5.3.12.0).

我读到了对 libpq的依赖。 dll ，这出现在 C：\Program Files（x86）\ PHP \v5.3 \ 中。在我的调试早期，我将新的 libpq.dll （版本8.4.4.10133）从PostgreSQL复制到该文件夹​​，已阅读某处可能解决问题的地方。我现在尝试恢复到PHP附带的旧版本（8.3.6.9034）和VOILA !!!!突然 phpinfo（）表示它已经加载了pdo和非pdo pgsql模块。

I read about a dependency on libpq.dll and this is present in C:\Program Files (x86)\PHP\v5.3\. Early in my "debugging" I copied the new libpq.dll (version 8.4.4.10133) from PostgreSQL to that folder, having read somewhere that it might solve the problem. I now tried reverting to the old version (8.3.6.9034) that shipped with PHP, and VOILA!!!! Suddenly phpinfo() says it has loaded both pdo and non-pdo pgsql modules.

MantisBT现在加载登录屏幕至少。哇！

MantisBT now loads the login screen at least. Whew!

这篇关于PGSQL未加载到IIS 5.3下的PHP 5.3 Windows中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！