Autosignup and mysql notes

Jason Spence thalakan at frys.com
Sun Jan 7 19:14:29 PST 2001


Hi -

I've been troubleshooting a problem with the autosignup system's
fs_signup_server process and intermittent connection dropping.  I
finally tracked the problem down to an 8 hour default timeout on the
mysql daemon (running on a seperate computer and talking using
TCP/IP).

The solution was to put

[mysqld]
set-variable = wait_timeout=800000

in /etc/my.cnf (may vary on your system, use strings on your server
binary to find the location).  The default value is 28800, 8 hours.
You can use "mysqladmin variables" to check if it was properly set
after you restart the daemon.

Hope this saves you people some headaches,

 - Jason



More information about the freeside-users mailing list