Anyone using the IC Radius radius.cgi with FreeRadius? I've been using
it for months and just recently switches the box the cgi is running on
to something that's more powerful with more drive space. Needless to
say I had to re-install linux, all the perl libraries, etc. My problem
now is that the radius log is spewing out an error pertaining to
attempts radius.cgi makes to authenticate:
Tue Jul 23 19:32:52 2002 : Debug: Thread 3 assigned request 7
Tue Jul 23 19:32:52 2002 : Debug: --- Walking the entire request list
---
Tue Jul 23 19:32:52 2002 : Debug: Threads: total/active/spare threads =
5/1/4
Tue Jul 23 19:32:52 2002 : Debug: Nothing to do. Sleeping until we see
a request.
Tue Jul 23 19:32:52 2002 : Debug: Thread 3 handling request 7, (2
handled so far)
User-Name = "snipped"
User-Password = "snipped"
Tue Jul 23 19:32:52 2002 : Debug: modcall: entering group authorize
Tue Jul 23 19:32:52 2002 : Debug: modcall[authorize]: module
"preprocess" returns ok
Tue Jul 23 19:32:52 2002 : Error: rlm_eap: EAP-Message not found
Tue Jul 23 19:32:52 2002 : Debug: modcall[authorize]: module "eap"
returns noop
Tue Jul 23 19:32:52 2002 : Debug: rlm_realm: Looking up realm NULL
for User-Name = "snipped"
Tue Jul 23 19:32:52 2002 : Debug: rlm_realm: Found realm DEFAULT
Tue Jul 23 19:32:52 2002 : Debug: rlm_realm: Adding
Stripped-User-Name = "snipped"
Tue Jul 23 19:32:52 2002 : Debug: rlm_realm: Proxying request from
user snipped to realm DEFAULT
Tue Jul 23 19:32:52 2002 : Debug: rlm_realm: Authentication realm is
LOCAL.
Tue Jul 23 19:32:52 2002 : Debug: rlm_realm: auth_port is not set.
proxy cancelled
Tue Jul 23 19:32:52 2002 : Debug: modcall[authorize]: module "suffix"
returns noop
Tue Jul 23 19:32:52 2002 : Debug: radius_xlat: 'snipped'
Tue Jul 23 19:32:52 2002 : Debug: sql_set_user: escaped user -->
'snipped'
Tue Jul 23 19:32:52 2002 : Debug: radius_xlat: 'SELECT
id,UserName,Attribute,Value,op FROM radcheck WHERE Username = 'snipped'
ORDER BY id'
Tue Jul 23 19:32:52 2002 : Debug: rlm_sql: Reserving sql socket id: 2
Tue Jul 23 19:32:52 2002 : Debug: radius_xlat: 'SELECT
radgroupcheck.id,radgroupcheck.GroupName,radgroupcheck.Attribute,radgrou
pcheck.Value,radgroupcheck.op FROM radgroupcheck,usergroup WHERE
usergroup.Username = 'snipped' AND usergroup.GroupName =
radgroupcheck.GroupName ORDER BY radgroupcheck.id'
Tue Jul 23 19:32:52 2002 : Debug: radius_xlat: 'SELECT
id,UserName,Attribute,Value,op FROM radreply WHERE Username = 'snipped'
ORDER BY id'
Tue Jul 23 19:32:52 2002 : Error: rlm_sql: unknown attribute
Radius-Operator
Tue Jul 23 19:32:52 2002 : Error: rlm_sql: Error getting data from
database
Tue Jul 23 19:32:52 2002 : Debug: radius_xlat: 'SELECT
radgroupreply.id,radgroupreply.GroupName,radgroupreply.Attribute,radgrou
preply.Value,radgroupreply.op FROM radgroupreply,usergroup WHERE
usergroup.Username = 'snipped' AND usergroup.GroupName =
radgroupreply.GroupName ORDER BY radgroupreply.id'
Tue Jul 23 19:32:52 2002 : Debug: radius_xlat: 'SELECT Value,Attribute
FROM radcheck WHERE UserName = 'snipped' AND ( Attribute =
'User-Password' OR Attribute = 'Password' OR Attribute =
'Crypt-Password' ) ORDER BY Attribute DESC'
Tue Jul 23 19:32:52 2002 : Debug: rlm_sql: Released sql socket id: 2
Tue Jul 23 19:32:52 2002 : Debug: modcall[authorize]: module "sql"
returns ok
Tue Jul 23 19:32:52 2002 : Debug: modcall: group authorize returns ok
Tue Jul 23 19:32:52 2002 : Debug: auth: type Local
Tue Jul 23 19:32:52 2002 : Debug: auth: user supplied User-Password
matches local User-Password
Tue Jul 23 19:32:52 2002 : Auth: Login OK: [snipped] (from client
blackbox port 0)
Sending Access-Accept of id 83 to 216.7.221.26:33270
Tue Jul 23 19:32:52 2002 : Debug: Finished request 7
Tue Jul 23 19:32:52 2002 : Debug: Going to the next request
Tue Jul 23 19:32:52 2002 : Debug: Thread 3 waiting to be assigned a
request
The offending line is the sql module complaining about the
Radius-Operator attribute followed by "Error getting data from databse".
That error appears to result in radius.cgi giving me an "Error: Invalid
Login".
Would anyone be able to offer some assistance?
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
