Accounting into MySQL info at
Fri May 15 04:00:35 CEST 2009

is it freeradius and freeradius-mysql ?

----- Original Message ----- 
From: "Tim Dressel" <tjdressel at>
To: <freeradius-users at>
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 

More information about the Freeradius-Users mailing list