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