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