Thanks for your reply for Simultaneous-Use -Issue But i am still having some problems
radcheck tabled in mysql has the following entries for a certain user. 2496 | [EMAIL PROTECTED] | Auth-Type | := | Local | 2497 | [EMAIL PROTECTED] | Simultaneous-Use | := | 1 | 2498 | [EMAIL PROTECTED] | User-Password | == | seesa | I have Simultaneous-Use enabled in my radius configuration and still i dont see it working. It accepts multiple logins at the same time. Basiaclly the NAS doesnt keep any record of logins and i am ( & have to ) only rely on radius accounting. On radius accounting , i do see two sessions started . I am at a situation where Radius Accounting is able to log two sessions but Radius is not limiting loggings based on the Simultaneous-Use restrictions. Note: I read the documentation Simultaneous-Use ( in installation documentation ) and it explains the concept making an assumption that NAS should have the list of logged in users against which radius can verify its list of logged in users. Is it possible to just implement Sim-Use based on what radius has without worrying about what NAS has. ( If so .. please guide me in the right direction ) ... Thanks On Mon, 14 Mar 2005 09:20:53 -0500 (EST), Dustin Doris <[EMAIL PROTECTED]> wrote: > You can use sql. Notice in the radiusd.conf file under the session > section it lists radutmp and sql, with a note that says See "Simultaneous > Use Checking Querie" in sql.conf. It even says that the rlm_sql module is > *much* faster at it. > > > On Sat, 12 Mar 2005, Rad Adm wrote: > > > Thanks for the reply. > > > > The problem is that the NAS ( can not ) send NAS-Port Attribute and > > that is not changeable at the moment . So that eliminates the options > > of using radutmp. > > > > Basically i am trying to implement concurrency and while trying to do > > that i wanted to get radutmp going so that radius can figure out the > > list of users who have active sessions in radius. > > > > Now knowing that radutmp can not work .. do you have any suggestion as > > to how i am implement User Concurrency. > > > > Here some info as to what info is available from the NAS. > > > > Each time a user connects to my NAS , it send a Accounting Start > > packet and on user disconnect a Accounting Stop packet. > > > > In my Radius 's mysql database the table "radacct" gets a data record > > based on each user as he/she logs in. > > > > The record on start of the session looks as follow. ( The end time of > > the record gets modified in the same record. ) > > > > > > | 1129 | 481 | d5612d46b9cb2657 | > > [EMAIL PROTECTED] | | 10.45.0.45 | 0 | > > | 2005-03-12 00:51:45 | 0000-00-00 00:00:00 | 0 | > > | | | 0 | > > 0 | | | > > | | | | 0 | > > 0 | > > > > > > and At the end of the session the record gets modified to > > > > | 1129 | 481 | d5612d46b9cb2657 | > > [EMAIL PROTECTED] | | 10.45.0.45 | 0 | > > | 2005-03-12 00:51:45 | 2005-03-12 01:04:59 | 0 | > > | | | 0 | > > 0 | | | > > | | | | 0 | > > 0 | > > > > > > Given this information what would you suggest is the best way to go about > > and > > implement user concurrency . > > > > > > > > Table Description of radacct > > +--------------------+-------------+------+-----+---------------------+----------------+ > > | Field | Type | Null | Key | Default > > | Extra | > > +--------------------+-------------+------+-----+---------------------+----------------+ > > | RadAcctId | bigint(21) | | PRI | NULL > > | auto_increment | > > | AcctSessionId | varchar(32) | | MUL | > > | | > > | AcctUniqueId | varchar(32) | | MUL | > > | | > > | UserName | varchar(64) | | MUL | > > | | > > | Realm | varchar(64) | YES | | > > | | > > | NASIPAddress | varchar(15) | | MUL | > > | | > > | NASPortId | int(12) | YES | | NULL > > | | > > | NASPortType | varchar(32) | YES | | NULL > > | | > > | AcctStartTime | datetime | | MUL | 0000-00-00 00:00:00 > > | | > > | AcctStopTime | datetime | | MUL | 0000-00-00 00:00:00 > > | | > > | AcctSessionTime | int(12) | YES | | NULL > > | | > > | AcctAuthentic | varchar(32) | YES | | NULL > > | | > > | ConnectInfo_start | varchar(32) | YES | | NULL > > | | > > | ConnectInfo_stop | varchar(32) | YES | | NULL > > | | > > | AcctInputOctets | bigint(12) | YES | | NULL > > | | > > | AcctOutputOctets | bigint(12) | YES | | NULL > > | | > > | CalledStationId | varchar(50) | | | > > | | > > | CallingStationId | varchar(50) | | | > > | | > > | AcctTerminateCause | varchar(32) | | | > > | | > > | ServiceType | varchar(32) | YES | | NULL > > | | > > | FramedProtocol | varchar(32) | YES | | NULL > > | | > > | FramedIPAddress | varchar(15) | | MUL | > > | | > > | AcctStartDelay | int(12) | YES | | NULL > > | | > > | AcctStopDelay | int(12) | YES | | NULL > > | | > > +--------------------+-------------+------+-----+---------------------+----------------+ > > 24 rows in set (0.00 sec) > > > > > > > > On Sat, 12 Mar 2005 11:24:13 -0500, Alan DeKok <[EMAIL PROTECTED]> wrote: > > > Rad Adm <[EMAIL PROTECTED]> wrote: > > > > On establishing a connections the radutmp related messages in debug > > > > (-X) mode are as follows... while there is no file radutmp the way i > > > > would expect it to be.. > > > ... > > > > rlm_radutmp: No NAS-Port seen. Cannot do anything. > > > > > > The server is telling you what's going wrong, and why. > > > > > > The solution is to get the NAS to send a NAS-Port attribute in the > > > request. If that doesn't happen, you won't be able to use radutmp. > > > > > > Alan DeKok. > > > > > > - > > > List info/subscribe/unsubscribe? See > > > http://www.freeradius.org/list/users.html > > > > > > > - > > List info/subscribe/unsubscribe? See > > http://www.freeradius.org/list/users.html > > > > - > List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html > - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
