building 1.4 (CentOS 4.4) MYSQL

Andrew Long along at escapewire.com
Mon Jan 15 05:20:00 CET 2007


two hours ago I was able to ntradping and receive an accept. Now, I am
rejected. All I did was load the sql tables with data. (Before, my
only record was the one you see returned below). Shouldn't this still
authorize? Is this due to (2nd to last line) "no authenticate method"?

rlm_sql (sql): sql_set_user escaped user --> 'along'
radius_xlat:  'SELECT id, UserName, Attribute, Value, op FROM radcheck WHERE Username = 'along' ORDER BY id'

mysql> +----+----------+-----------+------------+----+
    -> | id | username | attribute | value      | op |
    -> +----+----------+-----------+------------+----+
    -> |  1 | along    | password  | testing123 | == |
    -> +----+----------+-----------+------------+----+
    -> 1 row in set (0.00 sec)
    -> ;
    
rlm_sql (sql): Reserving sql socket id: 4
radius_xlat:  'SELECT radgroupcheck.id,radgroupcheck.GroupName,radgroupcheck.Attribute,radgroupcheck.Value,radgroupcheck.op  FROM radgroupcheck,usergroup WHERE usergroup.Username = 'along' AND usergroup.GroupName = radgroupcheck.GroupName ORDER BY radgroupcheck.id'

--> empty set (0.00 sec)

radius_xlat:  'SELECT id, UserName, Attribute, Value, op FROM radreply WHERE Username = 'along' ORDER BY id'

--> empty set (0.00 sec)

radius_xlat:  'SELECT radgroupreply.id,radgroupreply.GroupName,radgroupreply.Attribute,radgroupreply.Value,radgroupreply.op  FROM radgroupreply,usergroup WHERE usergroup.Username = 'along' AND usergroup.GroupName = radgroupreply.GroupName ORDER BY radgroupreply.id'

--> empty set (0.00 sec)

rlm_sql (sql): Released sql socket id: 4
rlm_sql (sql): No matching entry in the database for request from user [along]
  modcall[authorize]: module "sql" returns notfound for request 0
rlm_sqlcounter: Entering module authorize code
rlm_sqlcounter: Could not find Check item value pair
  modcall[authorize]: module "noresetcounter" returns noop for request 0
rlm_sqlcounter: Entering module authorize code
rlm_sqlcounter: Could not find Check item value pair
  modcall[authorize]: module "dailycounter" returns noop for request 0
rlm_sqlcounter: Entering module authorize code
rlm_sqlcounter: Could not find Check item value pair
  modcall[authorize]: module "monthlycounter" returns noop for request 0
rlm_sqlcounter: Entering module authorize code
rlm_sqlcounter: Could not find Check item value pair
  modcall[authorize]: module "daypasscounter" returns noop for request 0
modcall: leaving group authorize (returns ok) for request 0
auth: No authenticate method (Auth-Type) configuration found for the request: Rejecting the user
auth: Failed to validate the user.







More information about the Freeradius-Users mailing list