Topic: PHP/PostgreSQL app on SME 5.5

[Jack McCauley]

We are developing a production control application on a Redhat 7.0 system with the intention of eventually deploying on a SME server.  The development system works fine, but when I try to move everything to the SME server I get no joy.

We are using PostgreSQL as the database, and the application itself is written in PHP.  PostgreSQL 7.2.1 has been loaded, and it seem to be running fine, and the database has been dumped from the development system and reloaded on the production system, and it all seems to be there and correct.  This was all done to a fresh SME5.5 load.

I am trying to run from an ibay, and I believe I have everything loaded correctly but when I try to run the index.php script under IE6.0, I get "Done" at the lower left corner of the page but no display.  When I run a .php file with just the following contents:

phpinfo();
?>

I get the normal php information screen which seems to that there is no PostgreSQL support available.  At least there is no pgsql section listed.  I have checked that the php-pgsql-4.1.2-2es3.i386.rpm is loaded, and even tried reloading it. I have not yet tried another browser, but I guess that would be a logical troubleshooting step.

If anyone has any ideas, please respond...jmm

[Luciano Terra]

You must load pg extension in /etc/php.ini


mkdir -p /etc/e-smith/templates-custom/etc/php.ini/
cd /etc/e-smith/templates-custom/etc/php.ini/
echo "extension=pgsql.so"> \ /etc/e-smith/templates-custom/etc/php.ini/70DynamicExtension80Postgres
/sbin/e-smith/expand-template /etc/php.ini
service httpd restart


Regard's
Luciano Terra