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
