Andrew Pilley <[EMAIL PROTECTED]> wrote: > Hey. Just a quick question. if a radius+mysql server is unexpectedly > shut down (power failure or otherwise) without being given a chance to > quit, and there are active sessions, will freeradius clean out any > leftover sessions in the raddacct table?
Uh, when? If it dies when the power goes off, it doesn't have time to clean them out. When the power comes back up, the server won't root through all of the accounting data, to "fix" it, as that is pointless. > and what if only the radius+mysql server died, and the sessions were > still active? Sessions were? On the NAS? If you're thinking that "active sessions" are stored in the SQL database, you're wrong. The server gets information about active sessions from the NAS, and stores that information in the database. But the information amay be delayed seconds to minutes, and it may be wrong. You're better off thinking of the SQL database as a collection of "the most recent things the NAS told me about". But it's NOT a "list of active sessions". > I'm just looking into things i have to do on startup of the system to > possibly handle catastrophic failures and dealing with accounting > adequately. I'm using an ascend 4000max series access server. I don't understand what you're worried about. If the power goes off to the server and/or the SQL database, then the collection of "things the NAS told it" is untouched. If the power to the NAS goes off, then you can tell the old information in the database about a NAS port is no longer valid, when new information for that NAS port comes in. Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
