From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | Mark Williams <markwillimas(at)gmail(dot)com>, pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Re: PostgreSQl, PHP and IIS |
Date: | 2018-09-22 15:45:13 |
Message-ID: | 133bcc16-cb82-0d15-5b01-ea8444177e67@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(dot)klaver(at)aklaver(dot)com>
> Sent: 21 September 2018 23:02
> To: Mark Williams <markwillimas(at)gmail(dot)com>;
> pgsql-general(at)lists(dot)postgresql(dot)org
> 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(dot)klaver(at)aklaver(dot)com
>
>
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Robert Haas | 2018-09-23 04:14:00 | Re: Code of Conduct plan |
Previous Message | Christoph Moench-Tegeder | 2018-09-22 14:58:18 | Re: postgresql systemd service fails to start only on boot but not manually |