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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Gustavo Amarilla Santacruz | 2010-01-30 12:33:24 | Re: Undefined function pg_connect() |
Previous Message | Jaime Casanova | 2010-01-29 17:01:32 | Re: capturing errors |