<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 TRANSITIONAL//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; CHARSET=UTF-8">
<META NAME="GENERATOR" CONTENT="GtkHTML/3.28.3">
</HEAD>
<BODY>
Here is some more informations about how we solve this issue for people who use dd-wrt as chillispot hotspot (like you Dagia):<BR>
______________________________________________________________________________________________________________<BR>
So first you should check that your router support or special firmware (dd-wrt firmware base+ Ead-Ard powertools)<BR>
<BR>
here is the database url: <BR>
<BR>
<A HREF="https://www.yzy-oui-fi.com/newhome/device_db.php">https://www.yzy-oui-fi.com/newhome/device_db.php</A><BR>
<BR>
<BR>
then you should register the router loaded with the firmware in our Ead-Ard server(keep cool it is free of any charge! :) )<BR>
<BR>
here is the url to register your device:<BR>
<BR>
<A HREF="https://www.yzy-oui-fi.com/addnewdev.php?lang=en">https://www.yzy-oui-fi.com/addnewdev.php?lang=en</A><BR>
<BR>
there is also a wiki that explain how it works with our captive portal, this will be a little bit different than yours, but this will give you a good idea of the ead-ard system.<BR>
<BR>
<A HREF="http://wiki.yzy-oui-fi.com/dashboard/wiki/index.php/DD-WRT_Firmware_Wisp_E3dition">http://wiki.yzy-oui-fi.com/dashboard/wiki/index.php/DD-WRT_Firmware_Wisp_E3dition</A><BR>
<BR>
<BR>
And now....here is the server side:<BR>
<BR>
1°) you should create a subdirectory to your web directory called wifi-1.1.1<BR>
2°) you should create a mysql table in your freeradius database called heartbeat<BR>
----------------<BR>
CREATE TABLE `heartbeat` (<BR>
`mac` varchar(20) NOT NULL default '',<BR>
`hostname` varchar(128) default NULL,<BR>
`ssid` varchar(32) default NULL,<BR>
`wanip` varchar(16) default NULL,<BR>
`realip` varchar(16) default NULL,<BR>
`thetime` datetime default NULL,<BR>
`ext` varchar(255) default NULL,<BR>
`notes` longtext,<BR>
`nasid` varchar(255) default NULL,<BR>
`om` varchar(1) NOT NULL default '1',<BR>
PRIMARY KEY (`mac`),<BR>
UNIQUE KEY `hbind1` (`realip`,`mac`)<BR>
) ENGINE=MyISAM DEFAULT CHARSET=latin1;<BR>
----------------<BR>
<BR>
<BR>
3°) in the wifi-1.1.1 directory place the heartbeat.php (see zip file this file is based on wifigator kind of heartbeat, if you run freeradius 2 or higher you probably have to make some change in db table and field name)<BR>
4°) modify its mysql connection to your information<BR>
<BR>
So if everything is ok every 15 minute your router should send its online status to the freeradius server(assumption your freeradius server also run a php webserver and mysql is used to run freeradius).<BR>
<BR>
Now you need a cron job ran on server side that will check if a router is considered as down querying heartbeat table and compare last status with the current time and act in radacct table to close opened session....<BR>
<BR>
5°)here is the user session closing script <BR>
<BR>
you will need to run the following from cron job<BR>
<BR>
"wget <A HREF="http://yourdomain/yourdirectory/checksession2close.php">http://yourdomain/yourdirectory/checksession2close.php</A>"<BR>
<BR>
you could set the cron loop to 5 minutes , less is not recommanded.<BR>
<BR>
So here you are, with all this and with some mods, your session should closed at least 20 minutes after your device went down<BR>
<BR>
______________________________________________________________________________________________________________<BR>
<BR>
Le jeudi 20 juin 2013 à 09:02 +0200, yzy-oui-fi a écrit :<BR>
<BLOCKQUOTE TYPE=CITE>
I guess you will need an external client/server status script (this is what we have done with our captiv portal server). the router send its status within a loop to the freeradius server, and the server will check the status sent avairage, if avairage exceed defined loop, then we close every attached user account session. <BR>
<BR>
Le mercredi 19 juin 2013 à 23:21 -0700, Dagia Dorjsuren a écrit : <BR>
<BLOCKQUOTE TYPE=CITE>
Hello,<BR>
<BR>
Does anyone know how to solve following issue? <BR>
<BR>
In this case :<BR>
<BR>
1. NAS (Chillispot based access point)<BR>
2. Freeradius<BR>
<BR>
If NAS is shutdowned, the freeradius keeps all user logins of that NAS. In this case, the users session is alive. In fact, freeradius doesn't know if NAS's status is shutdowned or running. Is there any configuration that freeradius disconnects the users automatically when NAS is shutdowned? On the other hand, I would like to terminate the user's session when NAS is shutdowned or unavailable.<BR>
<BR>
<BR>
<PRE>
-
List info/subscribe/unsubscribe? See <A HREF="http://www.freeradius.org/list/users.html">http://www.freeradius.org/list/users.html</A>
</PRE>
</BLOCKQUOTE>
<BR>
<PRE>
-
List info/subscribe/unsubscribe? See <A HREF="http://www.freeradius.org/list/users.html">http://www.freeradius.org/list/users.html</A>
</PRE>
</BLOCKQUOTE>
<BR>
</BODY>
</HTML>