in the query you miss the op field. check that it is present in the DB (if you are using a recent CVS you can find the correct sql commands to create that)
If you are performing a wrong query FR thinks that there isn't a connection to the DB and try to reconnect. In recents CVS there are some patches to the Oracle module. At 23.40 15/10/02, you wrote: >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 --------------------------------------- MICROSOFT: Most Intelligent Customers Realize Our Software is Only for Fools and Teenagers. --------------------------------------- Ing. Andrea Gabellini Email: [EMAIL PROTECTED] Tel: 0549 886111 (Italy) Tel. +378 0549 886111 (International) Intelcom San Marino S.p.A. Strada degli Angariari, 3 47891 Rovereta Repubblic of San Marino http://www.omniway.sm http://www.intelcom.sm - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
