RE: SQL Authentication Failure

[Vijay Reddy]

Hi, Sorry If i am disturbing a lot, Now following error is occured,after modifying the radiusd.conf with authenticate module(only PAP is enabled)     rlm_sql (sql): Pairs do not match for user [vreddy] rlm_sql (sql): Released sql socket id: 2   modcall[authorize]: module "sql" returns notfound     users: Matched DEFAULT at 152   modcall[authorize]: module "files" returns ok modcall: group authorize returns ok   rad_check_password:  Found Auth-Type PAP auth: type "PAP" modcall: entering group authtype rlm_pap: empty password supplied   modcall[authenticate]: module "pap" returns invalid modcall: group authtype returns invalid auth: Failed to validate the user.   what should be the record in the radcheck table, so that radtest vreddy Password localhost 0  testing123 client program need to work   Thanks in Advance   regards Vijay reddy     -----Original Message----- From: Novel S Sidabutar [mailto:[EMAIL PROTECTED]] Sent: Friday, November 29, 2002 11:49 AM To: [EMAIL PROTECTED] Subject: Re: SQL Authentication Failure You can try configure again your rlm_sql free radius source on /free~/src/modules/rlm_sql/ and do configure again, $./configure $./make $./make install   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