buffered-sql detail
Gabriel Blanchard
gabe at teksavvy.ca
Tue Aug 4 23:07:19 CEST 2009
The type detail server appears to be broken again in stable git. The
server logs fine I put the sql module in the main accounting block of
the virtual server.
if I move the sql block back inside the buffered-sql detail server it
moves the detail file to -> .work
but then never does anything with it, even worst, it deletes the .work
file without sending anything.
I had this exact same config with a previous version of freeradius and
it worked just fine. Unfortunately I don't remember what version that
was.
bsddev# radiusd -v
radiusd: FreeRADIUS Version 2.1.6, for host amd64-portbld-freebsd7.2,
built on Aug 4 2009 at 15:32:18
server buffered-sql {
listen {
type = detail
filename = ${radacctdir}/sqlrelay
load_factor = 10
}
preacct {
files
}
accounting {
sql
}
}
[sqlrelay] Processing sql_log_postauth
[sqlrelay-teksavvy] expand: INSERT into radius.dbo.radpostauth
(username, pass, reply, authdate) values ('%{User-Name}', '%{User-
Password:-Chap-Password}'
[sqlrelay] expand: /var/log/radacct/sqlrelay -> /var/log/radacct/
sqlrelay
++[sqlrelay-teksavvy] returns ok
} # server teksavvy
Sending Access-Accept of id 231 to 127.0.0.1 port 57073
Finished request 0.
Going to the next request
Waking up in 0.2 seconds.
Polling for detail file /var/log/radacct/sqlrelay
detail_recv: Renaming /var/log/radacct/sqlrelay -> /var/log/radacct/
sqlrelay.work
--> Here I'm expecting the sql module to wake up and send the log, but
it never does.
Waking up in 1.1 seconds.
Polling for detail file /var/log/radacct/sqlrelay
More information about the Freeradius-Devel
mailing list