Hi,
Thanks for your reply. I don't know why the sql module is failing. Still i get the
same result which i have mentioned in the earlier mails. The modules i have mentioned
is like this...
modules {
sql rlm_sql {
driver = rlm_sql_postgresql
}
authorize{
....
files
rlm_sql
}
authenticate{
....
rlm_sql
}
The output is the same...can you please suggest me what may be the reason for the
RLM_MODULE NOTFOUND...as you have mentioned..What things i should do. Can you please
suggest the right sequence to proceed. I am in great urgent to get a conclusion for
this...Thanks for the same..
Bharani
The output is the same:
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.
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html