Buffered SQL Setup Not Reading Detail File

[Gary T. Giesen]

Alan,

Thanks for your help, the problem was that I had 3 months of detail
data previously that did have the problem. I misunderstood that adding
Alan Dekok's block would fix the problem for my older data. I'm going
to work on making sure it doesn't happen again, but for the time being
my server is happily plowing through the detail data.

Much thanks,

GG

On Tue, Nov 8, 2011 at 11:10 AM, Alan Buxey <A.L.M.Buxey at lboro.ac.uk> wrote:
> Hi,
>> 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) {
>                        ok
>                }
>
> 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) {
>                detail
>        }
>        else {
>                ok
>        }
>
> alan
> -
> List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
>