buffered-sql doesn't make sense to me
Hi All, I'm trying to set up buffered-sql on my test freeradius server. I've been reading the example config files, but I'm confused because the buffered-sql example seems to be incomplete. The example "buffered-sql" file says to use one virtual server to log to the detail file, and another virtual server to read from it. But, there is no example config file supplied for logging to the detail file. The only example given is the one for reading from it (i.e. the buffered-sql file) How do I configure buffered-sql? Also, decoupled-accounting appears to me to be very similar to buffered-sql. If it's not, how is it different? Regards, Ranbir -- Kanwar Ranbir Sandhu Linux 2.6.27.21-170.2.56.fc10.x86_64 x86_64 GNU/Linux 15:25:10 up 20 days, 15:21, 4 users, load average: 1.09, 1.13, 0.83
I'm trying to set up buffered-sql on my test freeradius server. I've been reading the example config files, but I'm confused because the buffered-sql example seems to be incomplete.
No. Your understanding of how it works is incomplete.
The example "buffered-sql" file says to use one virtual server to log to the detail file,
Yes. That would be default virtual server (by default).
and another virtual server to read from it.
Yes. buffered-sql.
But, there is no example config file supplied for logging to the detail file.
Because it is the default virtual server. It's already configured.
The only example given is the one for reading from it (i.e. the buffered-sql file)
How do I configure buffered-sql?
Make sure that the detail file default virtual server writes to is the same that buffered-sql will read from (it isn't same by default). Uncomment sql in accunting section of buffered-sql.
Also, decoupled-accounting appears to me to be very similar to buffered-sql. If it's not, how is it different?
Default virtual server doesn't write to detail file but special virtual server (write_detail.example.com) does that. Accounting is totally separated from authentication. Ivan Kalik Kalik Informatika ISP
On Mon, 2009-05-04 at 21:29 +0100, Ivan Kalik wrote:
No. Your understanding of how it works is incomplete.
Ok, fair enough. But,...
The example "buffered-sql" file says to use one virtual server to log to the detail file,
Yes. That would be default virtual server (by default).
...I was actually considering that perhaps the explanation meant the "default" config was the virtual server writing to the detail file. I suppose I should have gone with my initial instincts on that one instead of thinking "that can't possibly be right".
Make sure that the detail file default virtual server writes to is the same that buffered-sql will read from (it isn't same by default). Uncomment sql in accunting section of buffered-sql.
Thanks for explaining/confirming that for me. I made the necessary changes in the detail module, and now accounting records are being buffered. Yeah! Hopefully I'll still have a working config when I eventually test with the real NAS hardware instead of with just the radclient app.
Also, decoupled-accounting appears to me to be very similar to buffered-sql. If it's not, how is it different?
Default virtual server doesn't write to detail file but special virtual server (write_detail.example.com) does that. Accounting is totally separated from authentication.
So, once buffered-sql is configured correctly, it's the same thing as decoupled-accounting. Is that right? What I'm trying to say is that although these are two different terms, the end result is exactly the same? Regards, Ranbir -- Kanwar Ranbir Sandhu Linux 2.6.27.21-170.2.56.fc10.x86_64 x86_64 GNU/Linux 16:52:53 up 20 days, 16:49, 4 users, load average: 1.24, 1.22, 1.18
So, once buffered-sql is configured correctly, it's the same thing as decoupled-accounting. Is that right?
Not exactly. decoupled-accounting doesn't use default vitual server to write to detail file. You define an extra virtual server that only writes to detail file and reference it in listen section for accounting (global one, in radiusd.conf). Use of virtual servers in listen section is explained in raddb/sites-available/README. In that way accounting virtual servers have nothing to do with virtual servers doing authenticatione. Hence the name - decoupled-accounting. Ivan Kalik Kalik Informatika ISP
participants (2)
-
Ivan Kalik -
Kanwar Ranbir Sandhu