Hello,
I have successfully connected to Oracle from FreeRadius but it seems that
I am unable to return the correct data to FreeRadius. I am getting the
correct logs until I make an request from the client. Here is a snippet
of the output after I make a request using the Radtest app. I have the
user 'adam' in the oracle database in both the radreply and the radcheck
tables and my oracle user has the correct privileges. What other
information must I store in order for the requests to exchange correctly.
The 'rlm_sql: failed after reconnect' below, is from the
rlm_sql_select_query call. Also I built FreeRadius with Threads and Thread
pool enabled. Thanks.
rad_recv: Access-Request packet from host 10.11.10.24:32871, id=209,
length=54
User-Name = "adam"
User-Password = "'<2cH\257\246\002\341!Z\300\341\263\314\240"
NAS-IP-Address = 255.255.255.255
NAS-Port-Id = "10"
modcall: entering group authorize
modcall[authorize]: module "preprocess" returns ok
radius_xlat: 'adam'
sql_set_user: escaped user --> 'adam'
radius_xlat: 'SELECT id,UserName,Attribute,Value FROM radcheck WHERE
Username = 'adam' ORDER BY id'
rlm_sql: Reserving sql socket id: 4
SELECT id,UserName,Attribute,Value FROM radcheck WHERE Username = 'adam'
ORDER BY id
rlm_sql: Attempting to connect #4
rlm_sql: Connected new DB handle, #4
SELECT id,UserName,Attribute,Value FROM radcheck WHERE Username = 'adam'
ORDER BY id
rlm_sql: failed after re-connect
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 fail
modcall: group authorize returns fail
There was no response configured: rejecting request 0
Server rejecting request 0.
Finished request 0
Going to the next request
--
Adam Joncas
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
