Hello Beth -
On Tue, 02 May 2000, Beth Morgan wrote:
> Hi all,
>
> We are running Radiator 2.15, using mysqld Ver 3.22.29 for
> freebsdelf3.3. Every week or so I am having to reboot the machine when
> it stops wanting to authenticate because of a SQL timeout. Here's what
> the log says:
>
> ----------
> Mon May 1 16:15:18 2000: ERR: do failed for 'insert into RADUSAGE
> (USERNAME, TIME_STAMP, ACCTSTATUSTYPE, ACCTDELAYTIME,
> ACCTINPUTOCTETS, ACCTOUTPUTOCTETS, ACCTSESSIONID, ACCTSESSIONTIME,
> ACCTTERMINATECAUSE, FRAMEDIPADDRESS, NASIDENTIFIER, NASPORT, DNIS,
> CONNECTINFO)
> values
> ('mgentry', 957211998, 2, 0, 5870, 917, '100729031', 36,
> 1, '12.20.159.237', '12.4.96.42', 1538, '', '28800_BPS')': SQL Timeout
>
> ----------
>
> When I ps auxw, I can see that mysqld is running.
>
> Has anyone run into this and know how I can go about resolving it?
>
If it is a transient problem with the database, Radiator will try to reopen the
connection according to the SQL parameters in section 6.24 of the manual.
Have a look at sections 6.24.4 Timeout and 6.24.5 FailureBackoffTime.
> Also, is there any kind of monitoring software that anyone knows of that
> can check Radiator maybe every minute to see that it's running - and
> MySQL?
>
Some people use MRTG for this purpose. There is a sample configuration in the
FAQ: http://www.open.com.au/radiator/faq.html#50
regards
Hugh
--
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald,
Platypus, Freeside, Interbiller, TACACS+, PAM, external, etc, etc.
Available on Unix, Linux, FreeBSD, Windows 95/98/2000, NT, MacOS X.
===
Archive at http://www.starport.net/~radiator/
Announcements on [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.
