You can close all open sessions by altering AcctStopTime: UPDATE radacct SET AcctStopTime='whatever' WHERE AcctStopTime='1900-01-01 00:00:00' Or you can just delete them all (probably better if you are charging customers monthly and not by time online): DELETE FROM radacct WHERE AcctStopTime='1900-01-01 00:00:00' Freeradius might grumble a bit if you delete open sessions for current users too, but it will go on. If you want to keep current open sessions you should add something like - AND AcctStartTime<'2007-03-13 00:00:00' - at the end of SQL statements. Ivan Kalik Kalik Informatika ISP Dana 13/3/2007, "satish patel" <linuxtrap@yahoo.co.in> piše:
Tanks dear
But dear my problem is i am useing simultaneous-use with sql and it is working fine but my problem is users connect with NAS ( cisco vpdn ) but some user stuck in mssql database radacct tables means user connection error or any other error users got disconnect and then they try for login i got some log
user already login because in radacct table use AcctStopTime = 1/1/1900 thats why those user not able to login how can i automaticaly close this session is there any attribute which is automaticaly clear idle session one more thing i have set idle-timeout attributes but it's also not work ??? what is the problem of users stuck in database thats why i want to change my simultaneouse-use with checkrad script .... is it solve by checkrad script.....!!!!???
tnt@kalik.co.yu wrote: radwho lists online users according to radutmp checkrad doesn't use radwho. It "asks" NAS if user so and so is on port so and so with session ID so and so. In session you choose if looking for online users will be done in database or radutmp. checkrad will be called when online user is detecded if you put "cisco" as nastype. If you put "other" it won't.
Ivan Kalik Kalik Informatika ISP
Dana 12/3/2007, "satish patel" piše:
anyone help me please
I have many problem for simultaneous login user problem i have freeradius-11.0 with MSSQL with cisco VPDN configuration i dont know why simultaneous not working with checkrad script
can u explain me i have confusen in radwho and checkrad command so checkrad command use radwho output ???? and what is sql base simultenoues detection if i enable sql in /etc/radb/radius.conf in session part
like :-
Session { # radtump sql }
what is the radutmp and sql if i use radutmp then checkrad call by radius or not i have confuseion in checkrad and sql base simultenous use can u explain me
$ cat ~/satish/url.txt
System administrator ( Data Center )
please visit this site
--------------------------------- Heres a new way to find what you're looking for - Yahoo! Answers
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
$ cat ~/satish/url.txt
System administrator ( Data Center )
please visit this site
--------------------------------- Heres a new way to find what you're looking for - Yahoo! Answers