which version of FR do you use?
can the machine where freeradius runs connect to the oracle server?
I notice that in the select is missing the Op column. I don't know what FR
does without it. Pay attention because SQL commands to create tables in the
distribution don't add this column.
Andrea
At 22.10 24/09/02, you wrote:
>I'm trying to use freeradius with oracle.
>I managed to make freeradius connect to oracle and try to authentificate
>there, but i still cannot get a positive response.
>
>any sugestions?
>
>
>
>echo "User-Name = diego11" || radclient localhost auth testing123
>
>rad_recv: Access-Request packet from host 127.0.0.1:32904, id=248,
>length=47
> User-Name = "diego11"
> User-Password =
>"V\334\035\356.\210\317\247{q\356\240\305b\357\347"
>modcall: entering group authorize
> modcall[authorize]: module "preprocess" returns ok
>radius_xlat: 'diego11'
>sql_set_user: escaped user --> 'diego11'
>radius_xlat: 'SELECT id,UserName,Attribute,Value FROM radcheck WHERE
>Username = 'diego11' ORDER BY id'
>rlm_sql: Reserving sql socket id: 4
>SELECT id,UserName,Attribute,Value FROM radcheck WHERE Username =
>'diego11' 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 =
>'diego11' 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
>--- Walking the entire request list ---
>Waking up in 1 seconds...
>--- Walking the entire request list ---
>Sending Access-Reject of id 248 to 127.0.0.1:32904
>Waking up in 4 seconds...
>MASTER: exit on signal (2)
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
