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)
radiusd.conf
prefix = /usr/local
exec_prefix = ${prefix}
sysconfdir = ${prefix}/etc
localstatedir = ${prefix}/var
sbindir = ${exec_prefix}/sbin
logdir = ${localstatedir}/log/radius
raddbdir = ${sysconfdir}/raddb
radacctdir = ${logdir}/radacct
# Location of config and logfiles.
confdir = ${raddbdir}
run_dir = ${localstatedir}/run/radiusd
libdir = ${exec_prefix}/lib
pidfile = ${run_dir}/radiusd.pid
max_request_time = 30
delete_blocked_requests = no
cleanup_delay = 5
max_requests = 1024
bind_address = *
port = 0
hostname_lookups = no
allow_core_dumps = no
regular_expressions = yes
extended_expressions = yes
log_stripped_names = no
log_auth = no
log_auth_badpass = no
log_auth_goodpass = no
usercollide = no
lower_user = no
lower_pass = no
nospace_user = no
nospace_pass = no
checkrad = ${sbindir}/checkrad
security {
max_attributes = 200
reject_delay = 1
}
$INCLUDE ${confdir}/clients.conf
proxy_requests = no
thread pool {
start_servers = 5
max_servers = 32
min_spare_servers = 3
max_spare_servers = 10
max_requests_per_server = 0
}
modules {
pap {
encryption_scheme = clear
}
preprocess {
huntgroups = ${confdir}/huntgroups
hints = ${confdir}/hints
with_ascend_hack = no
ascend_channels_per_line = 23
with_ntdomain_hack = no
with_specialix_jetstream_hack = no
with_cisco_vsa_hack = no
}
$INCLUDE ${confdir}/sql.conf
}
authorize {
preprocess
sql
}
authenticate {
authtype PAP {
pap
}
}
accounting {
sql
}
session {
sql
}
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
