RE: SQL Authentication Failure

[Chhai Thach]

See below   -----Original Message----- From: Vijay Reddy [mailto:[EMAIL PROTECTED]] Sent: Friday, 29 November 2002 4:25 PM To: [EMAIL PROTECTED] Subject: SQL Authentication Failure   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   I think the client dial up tries to use CHAP but you only have User-Password stored in your database. If you change the dial up client to PAP it should works.     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