[RADIATOR] MySQL accounting gets entered but not deleted

2015-08-14 Thread Gabe Carmichael
Good morning,
I am not good with mysql at all, but the example strings got me up and
running. I seem to have the radonline table auto purging after a user logs
off but the entry still exists in the accounting table. Is there a way to
have it flush those entries after a certain amount of time?

-- 

Gabe Carmichael
Systems Analyst - Networking/Email
Lower Kuskokwim School District
907-543-4860
LKSD Internal 4 digit dial - 4860
Skype: gabes72riv
g...@lksd.org gabe_carmich...@lksd.org
___
radiator mailing list
radiator@open.com.au
http://www.open.com.au/mailman/listinfo/radiator

Re: [RADIATOR] MySQL accounting gets entered but not deleted

2015-08-14 Thread Hugh Irvine

Hello Gabe -

The RADONLINE table is used to maintain a list of “who is connected now”, ie. 
records are entered when a user connects (an accounting start message) and 
removed when the user disconnects (an accounting stop message).

The ACCOUNTING table is an historical record of all connections over time and 
is usually kept for some period of time for audit and/or billing purposes.

If you don’t want any records in the ACCOUNTING table, just disable the inserts.

If you need more help send me a copy of your configuration file and I will be 
happy to assist.

regards

Hugh


 On 15 Aug 2015, at 05:38, Gabe Carmichael g...@lksd.org wrote:
 
 Good morning,
 I am not good with mysql at all, but the example strings got me up and 
 running. I seem to have the radonline table auto purging after a user logs 
 off but the entry still exists in the accounting table. Is there a way to 
 have it flush those entries after a certain amount of time?
 
 -- 
 Gabe Carmichael
 Systems Analyst - Networking/Email
 Lower Kuskokwim School District
 907-543-4860
 LKSD Internal 4 digit dial - 4860
 Skype: gabes72riv
 g...@lksd.org
 
 ___
 radiator mailing list
 radiator@open.com.au
 http://www.open.com.au/mailman/listinfo/radiator


--

Hugh Irvine
h...@open.com.au

Radiator: the most portable, flexible and configurable RADIUS server 
anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald, 
Platypus, Freeside, TACACS+, PAM, external, Active Directory, EAP, TLS, 
TTLS, PEAP, TNC, WiMAX, RSA, Vasco, Yubikey, MOTP, HOTP, TOTP,
DIAMETER, SIM, etc. 
Full source on Unix, Linux, Windows, MacOSX, Solaris, VMS, NetWare etc.

___
radiator mailing list
radiator@open.com.au
http://www.open.com.au/mailman/listinfo/radiator