R: Common error on sql_counter on Ver 2.1.5

Ivan Kalik tnt at kalik.net
Mon May 18 19:17:12 CEST 2009


> [sql]   expand: %{User-Name} -> mauro
> [sql] sql_set_user escaped user --> 'mauro'
> rlm_sql (sql): Reserving sql socket id: 0
> [sql]   expand: SELECT id, UserName, Attribute, Value, op FROM
> UtentiAutorizzati
>  WHERE UserName = '%{SQL-User-Name}' AND MACADDWAN =
> '%{Called-Station-Id}'
> AND
> (CheckOnLine - UtentiConnessi) > 0 AND DataScadenza > GetDate() -> SELECT
> id, Us
> erName, Attribute, Value, op FROM UtentiAutorizzati WHERE UserName =
> 'mauro'
> AND
>  MACADDWAN = '00-03-9D-4A-0A-0A' AND (CheckOnLine - UtentiConnessi) > 0
> AND
> Data
> Scadenza > GetDate()
> query:  SELECT id, UserName, Attribute, Value, op FROM UtentiAutorizzati
> WHERE U
> serName = 'mauro' AND MACADDWAN = '00-03-9D-4A-0A-0A' AND (CheckOnLine -
> UtentiC
> onnessi) > 0 AND DataScadenza > GetDate()
> WARNING: Found User-Password == "...".
> WARNING: Are you sure you don't mean Cleartext-Password?
> WARNING: See "man rlm_pap" for more information.
> [sql] User found in radcheck table
> [sql]   expand: SELECT id,UserName,Attribute,Value,op FROM radreply WHERE
> Userna
> me = '%{SQL-User-Name}' ORDER BY id -> SELECT
> id,UserName,Attribute,Value,op
> FRO
> M radreply WHERE Username = 'mauro' ORDER BY id
> query:  SELECT id,UserName,Attribute,Value,op FROM radreply WHERE Username
> =
> 'ma
> uro' ORDER BY id
> rlm_sql (sql): Released sql socket id: 0
> ++[sql] returns ok

PS. You have either disabled group checking or removed group membership
query.

Ivan Kalik
Kalik Informatika ISP




More information about the Freeradius-Users mailing list