Xojo CGI errors

Targets Web
1

I’m running my Xojo web application on a CentOS 32Bit server using Apache with the CGI method and it seems to work fine for the most part but occasionally when a user tries to connect they get “Oops! Page cannot be found” or something similar. If they refresh it usually loads the second time. When this happens I see either one or both of the following errors in my Apache logs:

[Thu Apr 17 11:40:17 2014] [error] [client xxx.xxx.xx.xxx] Script timed out before returning headers: closeout.cgi, referer: http://mysite.com/cgi-bin/NewOrder/closeout.cgi

or

[Thu Apr 17 11:40:43 2014] [warn] [client xxx.xxx.xx.xxx] Timeout waiting for output from CGI script /var/www/cgi-bin/NewOrder/closeout.cgi, referer: http://mysite.ccom/cgi-bin/NewOrder/closeout.cgi

Any idea what might be causing this?

2

I’ve seen this before and I’ve never been able to pin down why it happens. However to resolve it I would SSH into the server and navigate to the folder holding the cgi. Then I would run “perl FILENAME.cgi” and basically you’ll see some HTML outputted. After that the app seems to work fine.

3

Hi Phillip.

I did try that and I did see the output as expected but I still get the errors.

4

I had the same issue with a couple of Xojo database driven web applications. Changing/Tweaking the Apache CGI Timeout Directives did the trick for me. :slight_smile:

5

Lee,

Can you tell me what directives and in what files you changed to eliminate the timeout?

6

I never did. I ended up recompiling the program to run as a standalone app rather than a CGI app. It’s not ideal but it seems to run more stable this way.