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" <[EMAIL PROTECTED]> 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.....!!!!???
>
>
>
>[EMAIL PROTECTED] 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
>>
>>http://linux.tulipit.com
>>
>>---------------------------------
>> 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
>
>http://linux.tulipit.com
>
>---------------------------------
> 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
