Search Postgresql Archives

Re: PostgreSQl, PHP and IIS

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On 9/22/18 3:06 AM, Mark Williams wrote:
"Fatal error: Call to undefined function pg_connect".

Obviously, that is to be expected if pgsql module is not loading.

Went back over your previous post and saw:

"I have copied the version of libpq.dll from the lib folder of the postgresql installation to the root folder of the PHP installation.

I have added the bin folder of the postgresql installation to the Windows system search path.
"

I would say add the lib/ of the Postgres install to the search path.


__

-----Original Message-----
From: Adrian Klaver <adrian.klaver@xxxxxxxxxxx>
Sent: 21 September 2018 23:02
To: Mark Williams <markwillimas@xxxxxxxxx>;
pgsql-general@xxxxxxxxxxxxxxxxxxxx
Subject: Re: PostgreSQl, PHP and IIS

On 9/21/18 10:35 AM, Mark Williams wrote:
I have PHP v7.2.7 and PostgreSQL v10 with Windows IIS.

I am trying to get this to work following any advice I have been able
to find on the web, but with no success. My configuration so far is as
below.

PHP.ini extension list includes both php_pdo_pgsql.dll and php_pgsql.dll.

Both these dlls are located in the correct extensions directory
according to phpinfo.

According to phpinfo the Configuration File Path is "C:\Windows" and
the Loaded Configuration File is "C:\Program Files\PHP\v7.2\php.ini".
I have the same php.ini file at both locations.

I have copied the version of libpq.dll from the lib folder of the
postgresql installation to the root folder of the PHP installation.

I have added the bin folder of the postgresql installation to the
Windows system search path.

Phpinfo shows that pdo_pgsql extension is loaded but not pgsql.

I have also tried copying the dependent dlls (ssleay32.dll,
libeay32.dll, libintl-8.dll, libiconv-2.dll) from the postgresql bin
folder to the php root folder).

Phpinfo show php_pdo_pgsql is enabled, but not php_pgsql.dll and an
undefined function call error is displayed by php when I try and run
any pg php functions.

Can anyone please shed any light on what more I need to do?

So what is the error you are getting?

Or to put it another way, what is not happening?


Regards,

Mark



--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx




--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx




[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux