Mysql "server has gone away: problem with FastCGI

RT Users
1

Hi!

I have been trying to use RT (3.0.4) for my support site. I am using the
fastcgi module, because mod_perl is not installed (conflicts with
mod_php). However, all my intial enthusiasm of using RT started waning
as I started getting the “mysql server has gone away” error because of
the connection being timed out after a period of inactivity.

I have googled as much as I could. I could gather:

  1. The timeout can be extended by tweaking mysql: I would rather not. My
    usage of RT is light, and just because of this I cant let connections
    hanging on the other
    web applications on sites hosted in my server.
  2. I could use the normal CGI function: For the life of me I could not
    locate how. I mean I located how to use the fscgi module after a while.
    The documentation is too
    focussed on mod_perl.
  3. Maybe I can tweak fcgi instead and see if database connection can be
    restarted if found down. No clue how

At the very least the error that the script shows (some mason directory
permissions being incorrect) is really misleading.

Help! Anyone?

  • Sandip

Sandip Bhattacharya http://www.sandipb.net
sandip at puroga.com
Puroga Technologies Pvt. Ltd.
http://www.puroga.com

2

Sandip Bhattacharya wrote:

mod_php). However, all my intial enthusiasm of using RT started waning
as I started getting the “mysql server has gone away” error because of
the connection being timed out after a period of inactivity.

RT 3.0.5 onwards have much better handling of this problem.
Phil Homewood, Systems Janitor, http://www.SnapGear.com
pdh@snapgear.com Ph: +61 7 3435 2810 Fx: +61 7 3891 3630
SnapGear - Custom Embedded Solutions and Security Appliances