Re: Undefined function pg_connect() - Mailing list pgsql-php

On Thu, Jan 28, 2010 at 8:53 PM, Chris <dmagick@gmail.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