Accounting into MySQL

[EasyHorpak.com]

is it freeradius and freeradius-mysql ?



----- Original Message ----- 
From: "Tim Dressel" <tjdressel at gmail.com>
To: <freeradius-users at lists.freeradius.org>
Sent: Friday, May 15, 2009 3:53 AM
Subject: Accounting into MySQL


> Hi folks,
>
> I have an Ubuntu server 8.04.2 LTS running (pretty bare bones). I
> installed freeradius and freeradius-sql from the repositories (MySQL
> 5, all dependiencies, etc). For configuration I followed the SQL HOWTO
> on the FreeRADIUS Wiki page. I am able to successfully use NTRadPing
> Test Utility against the radius server when configured to use SQL as
> the back end.
>
> I also followed the instructions on the Frontios website and a few
> other websites, and by searching this groups mail archive on how to
> configure accounting into SQL, but I'm not getting any accounting
> information.
>
> Running freeradius -X I see the queries going to the database for
> authentication, but I don't see any insert/select into statements
> indicating accounting information being written to the database.
>
> I have some basic questions to better understand accounting into SQL.
>
> 1. Using NTRadPING, should I get entries in my radacct table?
>
> 2. I have uncommented the sql_log, and all the detail log sections,
> and in the accounting section, and uncommented the sql in the
> accounting section. What other changed are required assuming that I am
> already successfully authenticating from the radcheck table?
>
> 3. Is there a more detailed how-to on the internet (I guess my
> google-foo is not as good as others) specifically on accounting in
> mysql?
>
> 3.b) ... sepecifically on MAC authentication?
>
> Thanks so much!
>
> Tim
> -
> List info/subscribe/unsubscribe? See 
> http://www.freeradius.org/list/users.html
>