Re: Undefined function pg_connect() - Mailing list pgsql-php
| From | Gustavo Amarilla Santacruz |
|---|---|
| Subject | Re: Undefined function pg_connect() |
| Date | |
| Msg-id | e4ea2d811001291707l62c3c8ccs4a74b9d95a43bc8b@mail.gmail.com Whole thread Raw |
| In response to | Re: Undefined function pg_connect() (Chris <dmagick@gmail.com>) |
| Responses |
Re: Undefined function pg_connect()
(Gustavo Amarilla Santacruz <gusamasan@gmail.com>)
|
| List | pgsql-php |
On Thu, Jan 28, 2010 at 8:53 PM, Chris <dmagick@gmail.com> wrote:
Gustavo Amarilla Santacruz wrote:Does a phpinfo() page show it loading anything re: pgsql ?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.
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.
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