Hi Folks -
I am encountering a problem with PHP5 and postgresql on a fedora core 3 box. I have a database driven report application written in PHP5 on a remote server. This application allows a user to submit a sql statement created by php based on user input parameters to the postgresql server. The application works great as long as the database server can return the result set within what appears to be 2 minutes. If the query takes longer than two minutes to execute the database server will eventually finish the work but no rows of data appear on the web page. I am thinking that the network socket connection between the php engine and the postgresql database server gets dropped after two minutes and that is way the results never arrive at the php page. If you think this might be a plausible explanation can you provide some assistance as to how I can go about adressing this problem? I have tried alot of things and fiddled with all kinds of parameters in php.ini and in the postpgresql.conf file but nothing seems to help. I have cranked up the php script run time and parse time to 3600 seconds and cranked up the amount of memory the script is allowed to eat up to 64 megs. But still any query that takes longer than two minutes does not display results.
Thanks,
Juan
