If you know the RadAcctId you can do this to each record that needs a stop time:Thanks for the reply I found that there are certain users that has 0000-00-00 00:00:00 value in their AcctstopTime in my SQL database.Unless I change the the Simultaneous-Use = 2 they will not be able to login again. So temporarily I changed the affected dialup users Simultaneous-Use = 2 until I solved the issue.
What will I do to the radacct tables?Shall I delete the record of AcctStopTime and AcctStartTime of all affected users?How will I do it?Please Advise!
Thanks again!
Bernie
update radacct set AcctStopTime = NOW() where RadAcctId = yourRadAcctId
That will make it appear as if the user has logged out but you will still have record of at least the connection start time.
Keith Yoder
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
