Buffered SQL Setup Not Reading Detail File

Alan Buxey A.L.M.Buxey at lboro.ac.uk
Tue Nov 8 17:10:27 CET 2011

> I tried adding the noop block to the detail reader and doesn't seem to
> make a difference. I'm still seeing this suspicious debug:

Alan Dekok already told you this

"  Read raddb/sites-available/default.  Look for "zero".     "

the trouble is, if you HAVE a zero thats sneaked in, then theres be troubles...
so you need a wrapper around your sql-buffer reader...eg

                sql { 
			invalid = 2
			fail = 2
		if (fail || noop || invalid) {

in the buffered-sql  (that syntax might work, take care!)

or, even better, make sure the situation where the detail file
gets such a thing doesnt happen in the first place eg, in your
virtual server accounting section...

	if (Acct-Session-Time != 0) {
        else {


More information about the Freeradius-Users mailing list