rad_check_password

[bharani]

Hi, Following my earlier mails...for database connectivity between postgresql and freeradius...it is fine but authentication is not coming....ie ..     modcall: entering group authorize modcall[authorize]: module "preprocess" returns ok modcall[authorize]: module "suffix" returns ok users: Matched kavitha at 83 modcall[authorize]: module "files" returns ok   after this :    modcall[autz]: Group returns ok  rad_check_password:  Found auth-type SQL  auth: SQL   is missing....what may be the problem...i could'nt trace it out.....i hope u all will help in this regard... Thanks in advance Bharani   This is the whole message from server ::   modcall: entering group authorize modcall[authorize]: module "preprocess" returns ok modcall[authorize]: module "suffix" returns ok users: Matched kavitha at 83 modcall[authorize]: module "files" returns ok rlm_sql: Reserving sql socket id: 4 radius_xlat:  'kavitha' sql_escape in:  'kavitha' sql_escape out:  'kavitha' sql_set_user:  escaped user --> 'kavitha' radius_xlat:  'SELECT id,UserName,Attribute,Value FROM radcheck WHERE Username = 'kavitha' ORDER BY id' uery: SELECT id,UserName,Attribute,Value FROM radcheck WHERE Username = 'kavitha ' ORDER BY id backend message type 0x45 arrived while idle postgreSQL Query failed Error: PQsendQuery() -- There is no connection to the bakend. rlm_sql_getvpdata: database query error rlm_sql:  SQL query error; rejecting user rlm_sql: Released sql socket id: 4 modcall[authorize]: module "sql" returns invalid modcall: group authorize returns invalid sending Access-Reject of id 60 to 192.192.1.252:1024        Reply-Message = "hai kavitha from local" finished request 0 going to the next request etc....etc.......... Nothing to do.  Sleeping until we see a request.