I successfully configured freeradius 0.6 to authenticate against MySQL
server and also to add accounting information to the database.
I want to add simultaneous access check so I uncommented
"simul_count_query" in sql.conf and added "sql" into session{} section of
radiusd.conf.
>From the radiusd log I see that the query is defined, but never used. What
am I missing?
Thank you very much
Niccolo Rigacci
Italy
This is the relevand part of radiusd.conf
-----------------------------------------
accounting {
detail
sql
radutmp
}
session {
sql
}
This is the radiusd log
-----------------------------------------
sql: simul_count_query = "SELECT COUNT(*) FROM radacct WHERE
UserName='%{SQL-User-Name}' AND AcctStopTime = 0"^M
sql: simul_verify_query = "SELECT RadAcctId, AcctSessionId,
UserName, NASIPAddress, NASPortId, FramedIPAddress,
CalledStationId FROM radacct WHERE UserN
sql: simul_zap_query = "DELETE FROM radacct WHERE
RadAcctId = '%s'"^M
...
...
query: INSERT into radacct (RadAcctId, AcctSessionId,
AcctUniqueId, UserName, Realm, NASIPAddress,
NASPortId, NASPortType, AcctStartTime, AcctStopTime,
rlm_sql: Released sql socket id: 3
modcall[accounting]: module "sql" returns ok
...
No other sql query are attempted.
Those are the modules called by radiusd:
modcall[authorize]: module "preprocess" returns ok
modcall[authorize]: module "chap" returns ok
modcall[authorize]: module "suffix" returns noop
modcall[authorize]: module "files" returns notfound
modcall[authorize]: module "sql" returns ok
modcall[authenticate]: module "chap" returns ok
modcall[preacct]: module "preprocess" returns noop
modcall[preacct]: module "suffix" returns noop
modcall[preacct]: module "files" returns ok
modcall[accounting]: module "detail" returns ok
modcall[accounting]: module "sql" returns ok
modcall[accounting]: module "radutmp" returns ok
modcall[preacct]: module "preprocess" returns noop
modcall[preacct]: module "suffix" returns noop
modcall[preacct]: module "files" returns ok
modcall[accounting]: module "detail" returns ok
modcall[accounting]: module "sql" returns ok
modcall[accounting]: module "radutmp" returns ok
------------------------------------
Niccolo Rigacci <[EMAIL PROTECTED]>
Tex.NET s.r.l.
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
