[freeside] Autosignup and mysql notes

[Kristian Hoffmann]

Thank you!

-Kristian

On Sun, 7 Jan 2001, Jason Spence wrote:

> 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
>