Skip site navigation (1) Skip section navigation (2)

Re: Undefined function pg_connect()

From: Gustavo Amarilla Santacruz <gusamasan(at)gmail(dot)com>
To: Chris <dmagick(at)gmail(dot)com>
Cc: Bill Moran <wmoran(at)potentialtech(dot)com>, pgsql-php(at)postgresql(dot)org
Subject: Re: Undefined function pg_connect()
Date: 2010-01-30 01:07:27
Message-ID: e4ea2d811001291707l62c3c8ccs4a74b9d95a43bc8b@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-php
On Thu, Jan 28, 2010 at 8:53 PM, Chris <dmagick(at)gmail(dot)com> wrote:

> Gustavo Amarilla Santacruz wrote:
>
>> Thank you, Bill Moran.
>>
>> My httpd is stoped, for default.
>>
>> I used the command: service httpd start; then, the following message was
>> displayed:
>>
>> Starting httpd: [Thu Jan 28 20:27:39 2010] [warn] module perl_module is
>> already loaded, skipping
>> [Thu Jan 28 20:27:39 2010] [warn] module php5_module is already loaded,
>> skipping
>> httpd: Could not reliably determine the server's fully qualified domain
>> name, using localhost.localdomain for ServerName
>>                                                           [  OK  ]
>>
>>
>> But the pg_connect function is not recognized.
>>
>
> Does a phpinfo() page show it loading anything re: pgsql ?
>
> Anything in apache logs (/var/log/httpd/error.log probably) ?
>
> Could seLinux be involved somehow (I'm not really sure where to look for
> this, something in /var/log should have some info) ?
>
>
> On your phpinfo page, it should have something like this:
>
> Configuration File (php.ini) Path       /etc/php.ini
> Scan this dir for additional .ini files         /etc/php.d
>
>
> Check whether the rpm put a file in that extra directory, like:
>
> # cat /etc/php.d/pgsql.ini
> ; Enable pgsql extension module
> extension=pgsql.so
>
> If it didn't, try doing it manually (and restart httpd) and see if pgsql
> shows up in your phpinfo page now.
>
>
> --
> Postgresql & php tutorials
> http://www.designmagick.com/
>
>


Thank you, Chris



*1) Does a phpinfo() page show it loading anything re: pgsql ?*

No, no matter info on pgsql.


*2) Anything in apache logs (/var/log/httpd/error.log probably) ?*

Yes, i found this:

.
.
.
PHP Warning:  PHP Startup: Unable to load dynamic library
'./;/usr/lib/php/modules/;/usr/lib/pgsql/curl.so' -
./;/usr/lib/php/modules/;/usr/lib/pgsql/curl.so: cannot open shared object
file: No such file or directory in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library
'./;/usr/lib/php/modules/;/usr/lib/pgsql/fileinfo.so' -
./;/usr/lib/php/modules/;/usr/lib/pgsql/fileinfo.so: cannot open shared
object file: No such file or directory in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library
'./;/usr/lib/php/modules/;/usr/lib/pgsql/json.so' -
./;/usr/lib/php/modules/;/usr/lib/pgsql/json.so: cannot open shared object
file: No such file or directory in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library
'./;/usr/lib/php/modules/;/usr/lib/pgsql/ldap.so' -
./;/usr/lib/php/modules/;/usr/lib/pgsql/ldap.so: cannot open shared object
file: No such file or directory in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library
'./;/usr/lib/php/modules/;/usr/lib/pgsql/mysql.so' -
./;/usr/lib/php/modules/;/usr/lib/pgsql/mysql.so: cannot open shared object
file: No such file or directory in Unknown on line 0
.
.
.


*
3) On your phpinfo page, it should have something like this:

Configuration File (php.ini) Path       /etc/php.ini
Scan this dir for additional .ini files         /etc/php.d

*
Yes, the phpinfo page has this information.

*
4) Check whether the rpm put a file in that extra directory, like:

# cat /etc/php.d/pgsql.ini
; Enable pgsql extension module
extension=pgsql.so*


Yes, the rpm put that file in /etc/php.d




----------------------------
Gustavo Amarilla

In response to

Responses

pgsql-php by date

Next:From: Gustavo Amarilla SantacruzDate: 2010-01-30 12:33:24
Subject: Re: Undefined function pg_connect()
Previous:From: Jaime CasanovaDate: 2010-01-29 17:01:32
Subject: Re: capturing errors

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group