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