problem z freeradius i rlm_sqlcounter

Przemysław Backiel przemyslaw.backiel w backiel.com.pl
Nie, 8 Sty 2006, 00:06:34 CET


Witam,

mam taki problem

zrobiłem plik sqlcounter o treści:
sqlcounter noresetcounter {
                 counter-name = Max-All-Session-Time
                 check-name = Max-All-Session
                 sqlmod-inst = sql
                 key = User-Name
                 reset = never

                 query = "SELECT SUM(AcctSessionTime) FROM radacct WHERE 
UserName='%{%k}'"

         }


sqlcounter dailycounter {
                 driver = "rlm_sqlcounter"
                 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}'"


         }

sqlcounter monthlycounter {
                 counter-name = Monthly-Session-Time
                 check-name = Max-Monthly-Session
                 sqlmod-inst = sql
                 key = User-Name
                 reset = monthly
                 query = "SELECT SUM(AcctSessionTime) FROM radacct WHERE 
UserName='%{%k}'"


includuje ten plik w radius.conf

lecz gdy autentykuje klienta z ustawionym max-session-time to dostaje:
rlm_sql (sql): sql_set_user escaped user --> 'przemek'
radius_xlat:  'SELECT id,UserName,Attribute,Value,op FROM radcheck WHERE 
Username = 'przemek' ORDER BY id'
rlm_sql (sql): Reserving sql socket id: 2
rlm_sql: unknown attribute Max-All-Session
rlm_sql (sql): Error getting data from database
rlm_sql (sql): SQL query error; rejecting user
rlm_sql (sql): Released sql socket id: 2
   modcall[authorize]: module "sql" returns fail for request 2
modcall: group authorize returns fail for request 2


co robie nie tak?
-- 
Z powazaniem
Przemyslaw Backiel



Więcej informacji o liście dyskusyjnej pld-users-pl