SQL Authentication Failure

[Vijay Reddy]

Hi,

 

   I Installed  FreeRadius and MySQL on Linux ,I inserted the record in the radcheck using query into the server

 

Insert into radcheck(UserName,Attribute,Value) values ("vreddy","vreddy","test");

 

Now we started the Radius Server as radiusd -X,and when we started the test client with options as below

 

radtest vreddy test localhost 0 testing123

 

client is sending & resending the Access-Request packets,but server is not responding,the following error is occured at Server Side

 

rad_recv: Access-Request packet from host 127.0.0.1:33380, id=72, length=58
        User-Name = "vreddy"
        User-Password = "vreddy"
        NAS-IP-Address = 255.255.255.255
        NAS-Port = 0
modcall: entering group authorize
  modcall[authorize]: module "preprocess" returns ok
rlm_chap: Could not find proper Chap-Password attribute in request
  modcall[authorize]: module "chap" returns noop
  modcall[authorize]: module "mschap" returns notfound
    rlm_realm: No '@' in User-Name = "vreddy", looking up realm NULL
    rlm_realm: No such realm NULL
  modcall[authorize]: module "suffix" returns noop
radius_xlat:  'vreddy'
rlm_sql (sql): sql_set_user escaped user --> 'vreddy'
radius_xlat:  'SELECT id,UserName,Attribute,Value,op FROM radcheck WHERE Username = 'vreddy' ORDER BY id'
rlm_sql (sql): Reserving sql socket id: 4
rlm_sql_mysql: query:  SELECT id,UserName,Attribute,Value,op FROM radcheck WHERE Username = 'vreddy' ORDER BY id
rlm_sql: unknown attribute
rlm_sql (sql): Error getting data from database
rlm_sql (sql): SQL query error; rejecting user
rlm_sql (sql): Released sql socket id: 4
  modcall[authorize]: module "sql" returns fail
modcall: group authorize returns fail
Finished request 0
Going to the next request

 

 

 

regards

Vijay Reddy