Topic: PHP/Postgres/E-smith Issue

[Allen McGrath]

All:

Ok, I hope you can help me, or point me in a good direction. I am new to E-smith, so if my question seems obvious or out of place, please forgive:

we have E-smith installed on our intranet machine.  From what I'm told, when it was installed, PHP/APACHE/MySQL were installed (RPMs).  Postgres was installed at a later time by a developer who has since left.

I am attempting to connect to the Postgres database via PHP, but continullay receive a message stating that pg_pconnect is not a valid function.  The RPM
php-pgsql-4.0.3pl1-4 is installed.  I can connect to Postgres via psql.  PHP was configured with --with-pgsql=shared' parameter, among others.

Any ideas as to why PHP does not recognize the Postgres functions? Do I need to recompile PHP?  If so, how? Should (how do) I install postgres using E-smith?(I'm used to using only source, so again, please forgive). Thanks in advance.

[Lloyd Keen]

Check to make sure you have the following line "extension=pgsql.so" in /etc/php.ini

[Dan Brown]

Look at a phpinfo page (create a page containing only , including the angle brackets, and save it as test.php); it should indicate postgres support somewhere on the page.  If not, check what Lloyd suggested.