Hi, Clearly I'm missing something simple here. I'm trying to create accounts that will renew on a daily or weekly basis. I've put this code into my radiusd.conf file $INCLUDE ${confdir}/sql.conf sqlcounter dailycounter { counter-name = Daily-Session-Time check-name = Max-Daily-Session sqlmod-inst = sql key = User-Name reset = daily query = "SELECT SUM(AcctSessionTime) FROM radacct WHERE UserName='%{%k}'" } I've created this account in the MySQL radcheck table. ropgis12 User-Password := gisnopum ropgis12 Simultaneous-Use:= 1 ropgis12 Max-Daily-Session := 1800 radiusd -X gives the following result. rlm_sql (sql): Reserving sql socket id: 0 rlm_sql: Failed to create the pair: Unknown attribute "Max-Daily-Session" rlm_sql (sql): Error getting data from database rlm_sql (sql): SQL query error; rejecting user rlm_sql (sql): Released sql socket id: 0 modcall[authorize]: module "sql" returns fail for request 39 modcall: group authorize returns fail for request 39 I can't understand why Max-Daily-Session is an unknown attribute when it's declared in the radiusd.conf and radius loads with no errors. As usual any help would be appreciated. Sean Bracken
Sean wrote:
I can't understand why Max-Daily-Session is an unknown attribute when it's declared in the radiusd.conf and radius loads with no errors.
Because attributes are defined in the dictionaries. Arguably, the sqlcounter module should look up that attribute, and either complain if it doesn't exist, or else create it. That doesn't happen right now. Alan DeKok. -- http://deployingradius.com - The web site of the book http://deployingradius.com/blog/ - The blog
participants (2)
-
Alan DeKok -
Sean