freeradius 1.0.2 with oracle backend

[Sam Gibbs]

On 10/8/07, tnt at kalik.co.yu <tnt at kalik.co.yu> wrote:
> 1. Update - 1.0.2 is years out of date.

Thanks, I will update. The doc I followed specified 1.0.2.

> 2. Delete (comment out) DEFAULT entry setting Auth-Type System from the
> users file (if you don't plan to use it).

I've commented out these two lines:
DEFAULT        Auth-Type = System
Fall-Through = 1

> 3. Post the debug from the request.

It now works with oracle users!

rad_recv: Access-Request packet from host 10.1.9.92:2879, id=12, length=46
        User-Name = "guest2"
        User-Password = "guest2"
  Processing the authorize section of radiusd.conf
modcall: entering group authorize for request 0
  modcall[authorize]: module "preprocess" returns ok for request 0
  modcall[authorize]: module "chap" returns noop for request 0
  modcall[authorize]: module "mschap" returns noop for request 0
    rlm_realm: No '@' in User-Name = "guest2", looking up realm NULL
    rlm_realm: No such realm "NULL"
  modcall[authorize]: module "suffix" returns noop for request 0
  rlm_eap: No EAP-Message, not doing EAP
  modcall[authorize]: module "eap" returns noop for request 0
  modcall[authorize]: module "files" returns notfound for request 0
radius_xlat:  'guest2'
rlm_sql (sql): sql_set_user escaped user --> 'guest2'

<several sql select statements>

rlm_sql (sql): Released sql socket id: 4
  modcall[authorize]: module "sql" returns ok for request 0
modcall: group authorize returns ok for request 0
auth: type Local
auth: user supplied User-Password matches local User-Password
Sending Access-Accept of id 12 to 10.1.9.92:2879
Finished request 0

Thanks for your help, Ivan.

Sam